2

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.

Improve this question
5
  • 1
    It's not possible to convert the world to one UTM zone, but it's certainly possible to convert UTM to geographic. It should also be possible to parse any geographic data coordinate (the last column is lat,lon DD), but the primary description uses Public Land Survey (PLS) designations, which are polygon values, if parsed correctly. Please edit your question to choose between ArcGIS and QGIS, and between PLS polygons, UTM points, and geographic points and your preferred response. Please also take the Tour for guidelines on question formulation
    – Vince
    Commented Sep 28, 2015 at 16:11
  • 2
    If you create new columns in your excel sheet and use =LEFT(AI2,10) for lat and =RIGHT(AI2,11) for LNG (then again to remove the brackets) you separate your values that can be load into QGIS
    – Mapperz ♦
    Commented Sep 28, 2015 at 16:23
  • Your question still focuses on lat/lon parsing, so the final sentence is a sudden turn. Have you researched PLS data conversion? You're going to need ancillary data to convert township,range,section,quad,quarter-quad,q-q-quad to a polygon.
    – Vince
    Commented Sep 28, 2015 at 17:01
  • There are 2 Questions here please make 2 separate questions one for the csv to QGIS conversion (this question) and one for the PLS Polygon creation
    – Mapperz ♦
    Commented Sep 28, 2015 at 17:15
  • I edited the question to address only getting the point data into Q. I don't need the Polygons until a later project. Ultimately, the excel code was helpful in allowing me to import the values and have them display accurately. Thanks.
    – Jack Doe
    Commented Sep 29, 2015 at 15:01

1 Answer 1

Reset to default
1

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
Improve this answer
3
  • This doesn't answer the revised question about generating polygons based on PLS quad data.
    – Vince
    Commented Sep 28, 2015 at 16:54
  • 2
    The polygon geometries can't be extracted from the dataset. So I think this answers the main part of the question. The polygons should be moved to a new question. You may however label the points with the PLS number if that is what you want.
    – AndreJ
    Commented Sep 28, 2015 at 17:12
  • The polygon can be extracted from the PLS descriptor, with ancillary information (this was why the US Public Land Survey System was developed).
    – Vince
    Commented Sep 28, 2015 at 18:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.