I've received a database of drill hole locations in SPCS but I only use UTM.
How can I convert a CSV spreadsheet from State Plane Coordinate System, Nevada East NAD27 TO UTM?
Here's a video of the process I'm following with no success.
- Please post some of your point file. QGIS can transform those points. Another option is to use the NCAT site: geodesy.noaa.gov/NCATPointdump– Pointdump2022-01-24 21:18:35 +00:00Commented Jan 24, 2022 at 21:18
- Thanks Kadir. Here's an excerpt (there are thousands that we have to convert): Easting 400687.85 Northing 2414690.07; E 400412.31 N 2413816.15; E 396233 N 2413647; E 396191.6 N 2413557.5Bighouse Productions– Bighouse Productions2022-01-24 21:34:28 +00:00Commented Jan 24, 2022 at 21:34
- PS I'm familiar with QGIS so if there's a way that would be great.Bighouse Productions– Bighouse Productions2022-01-24 21:36:47 +00:00Commented Jan 24, 2022 at 21:36
- Create a new project in QGIS and set the CRS to the appropriate UTM zone. Then load the CSV file Layer->Add Layer-> Delimited Text Layer. It's critical that you set the Geometry CRS field in the dialog , otherwise it will assume something that is wrong. Once loaded, you can export the layer into whatever format with whatever CRS you want.Llaves– Llaves2022-01-24 22:01:04 +00:00Commented Jan 24, 2022 at 22:01
- 1Thanks all - figured it out: I needed to add a selection to the GEOMETRY in LAYER OPTIONS: as_xy and that adds the converted data columns to the spreadsheet. Thanks for your help.Bighouse Productions– Bighouse Productions2022-01-25 18:01:07 +00:00Commented Jan 25, 2022 at 18:01
| Show 4 more comments
1 Answer
Layer >> Add Layer >> Add Delimited Text Layer >> Export >> Save Features As
In the newly created layer, Open Attribute Table >> Click the Edit Pencil >> Field Calculator.
Add 2 new fields:
x(transform($geometry, 'EPSG:32007', 'EPSG:32611'))
y(transform($geometry, 'EPSG:32007', 'EPSG:32611')) 
Export >> Save Features As >> CSV Format:
E_32007,N_32007,E_32611,N_32611
400687.85,2414690.07,588119.058,4581576.026
400412.31,2413816.15,588039.455,4581308.374
396233.00,2413647.00,586766.880,4581236.018
396191.60,2413557.50,586754.711,4581208.542
