Hi, I need to export a point feature dataset that contains over 530+ points to a CSV file that contains the points coordiantes as WGS84 Lat and Long format?
I did follow this help section from ESRI site, but I didn't know every time it asks to enter a SINGLE point on the MAP. I need to select all features and export them at once.
Create or open an output configuration file—ArcGIS Pro | Documentation
If you need the coordinates of a point featureclass you could use
Calculate Geometry Attributes (Data Management)—ArcGIS Pro | Documentation
If you need to export the resultant table with the coordinates in the coordinate system of your choice, then use
Export Table (Conversion)—ArcGIS Pro | Documentation
this allows you to get the x, y coordinates in a different projection/spatial reference if the inputs differ from the desired outputs
Good Day Dan,
I'm not sure what did I do wrong, but when I add any extennsion like .CSV to the tool output file, I got the following error message
Output Table (Required)
Error 000345 The name contains invalid characters
The output table containing the exported rows.
The output table field I typed the name as 'ExportTable.csv' to assign the file extension.
Yet I'm receiveing the above error.
I managed to correct the file name error. I created two files one with .CSV and .TAB. Niether both are containing the Lat and Long coordinates. Just data!!
As a note, my input is a point feature layer with over 530+ points.
You have to add the coordinates to the featureclass, as I outlined above, before making the csv
Hi Dan, Do you mean I have add manually to each point their X and Y coordinates?! But these points are already GIS point features and are displayies on the MAP.
I need to export all points to CSV and each point record should have its LAT and LONG coordinates in separate fields. Then I can use this file and display the Points for example in POWER BI dashboard.
Can you add a lat and lon field to the table and use calculate geometry to calculate the lat and lon, then export the table?
Are the points graphics? separate featureclasses?
If they are on the map, then they arrived there somehow.
You can convert graphics to a featureclass.
You can merge features.
Once you have a featureclass table, then you can get the feature geometry in the coordinate system you want.
Perhaps you can explain what you have onscreen
Good Day Dan,
I do have these points as Point features, see attached file. Again my need is to export these points including their attributes along with their Lat and Long coordinates as .CSV file. Then I will include this CSV file in MS Power BI using the Map Visual. This will enable me to create many analysis and link them to MAP using the Lat and Long coordinates. I hope I made it more clear of what I'm looking for.
use this to add the geometry x, y and z in te desired coordinate system
Calculate Geometry Attributes (Data Management)—ArcGIS Pro | Documentation
then export to csv