[GIS] Importing CSV data with Coordinates in one column

csvqgis

I'm trying to import the Lat/Long coordinates from the "Location" field of a CSV from here :https://data.colorado.gov/Water/DWR-Water-Right-Net-Amounts/acsg-f33s

Unfortunately the coordinates are in a single column and I can't seem to get QGIS to recognize them.

There is a set of columns with UTM, but I think most of my other data is in Lat/Long and I am using Natural Earth basemaps and I'm not sure how to convert the entire world data set to Colorado UTM coordinates.

My goal is to be able to load the CSV data into QGIS and place them accurately over a basemap.

Best Answer

You need to parse the string in the Location field into two separate fields to be able to map the points. First, get rid of the special degree character and then evaluate the tuple string:

loc = '(40.37856, -104.756463)'
lat,lon = eval(loc)

>>> lat
40.37856
>>> lon
-104.756463
Related Question