I have an R dataframe, with location stored in a column. Location values look like this:
I was told that it is PostGIS data.
The goal is to visualize all those locations in R. My plan is to use
ggmap, and for that I need to have lat, long values.
I have spun up a PSQL DB with PostGIS extension to try and poke at this data, but I have no clue what type it is, and treating it as
varchar seems like a dead end. I have looked into PostGIS documentation on data types, but haven't been able to find anything that resembles my data. My initial guess was that my data is of point type, but it doesn't seem to be correct, since points are represented as pairs of numbers (for 2d), not as 51-chars-long strings.
Now I am at a loss. What type is this data and how can I get lat, long from it?