topic Re: Format for .csv file to import ground control points in ArcGIS Pro Questions

Format for .csv file to import ground control points

bobscarto — Sat, 11 Jun 2022 06:22:12 GMT

After asking the Community about using Ground Control Points in ArcGIS, I have narrowed the problem down to (apparently) the format of the X,Y,Z data in the .csv file that is imported using the Import GCP file command under the Manage GCPs tab in Ortho Mapping. I have been using Decimal Degrees, not DMS, but they don't seem to be accepted by ArcGIS. I'm wondering whether there is a rule for the number of digits after the decimal point. I've even tried dropping the decimal point, but this doesn't work (and isn't accepted practice for GPS coordinates). The other problem was that creating the table in Excel meant that when it was saved as a .csv, it always appeared as a .txt file, with the X and Y accuracy columns missing. I finally ran the Excel file through Google Sheets to get an actual .csv file with all the data, but this still didn't work with Import GCP file. Anyone with any answers?

Cheers, Bob

Re: Format for .csv file to import ground control points

RobertBorchert — Mon, 13 Jun 2022 12:18:19 GMT

show us an example of your x,y data.

Re: Format for .csv file to import ground control points

Anonymous User — Mon, 13 Jun 2022 17:52:55 GMT

Here's the relevant snippet from the docs

Click the Import GCPs tool from the Manage GCPs menu. Browse to the location of the GCP File, which can be a .csv or .txt file, feature class, or shapefile.
The fields in the file should include the GCP Label, X coordinate, Y coordinate, Z coordinate, XY accuracy, and Z accuracy.

Could you provide more info about what didn't work?

Re: Format for .csv file to import ground control points

bobscarto — Tue, 14 Jun 2022 23:39:04 GMT

Robert, I've attached the original Excel file, then the .txt file created when saving as a .csv from Excel, and then the .csv saved from Excel (via Google Sheets) which resulted in an actual .csv. The last is the one I've been trying to use to Import GCP. Cheers, Bob

Re: Format for .csv file to import ground control points

bobscarto — Tue, 14 Jun 2022 23:40:08 GMT

Dear 'and_viceversa', Please see my reply to RobertBorchert, above. Cheers, Bob