Select to view content in your preferred language

How to export many point features as Lat Long coordinates to CSV using ArcGIS Pro V. 3.0?

3075
9
10-29-2023 12:04 AM
Labels (2)
ThamerTarabzouni
Emerging Contributor

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

 

0 Kudos
9 Replies
DanPatterson
MVP Esteemed Contributor

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


... sort of retired...
ThamerTarabzouni
Emerging Contributor

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. 

 

 

0 Kudos
ThamerTarabzouni
Emerging Contributor

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.  

0 Kudos
DanPatterson
MVP Esteemed Contributor

You have to add the coordinates to the featureclass, as I outlined above, before making the csv


... sort of retired...
0 Kudos
ThamerTarabzouni
Emerging Contributor

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. 

 

0 Kudos
AngelaSchirck
Frequent Contributor

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?

0 Kudos
DanPatterson
MVP Esteemed Contributor

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


... sort of retired...
0 Kudos
ThamerTarabzouni
Emerging Contributor

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. 

 

0 Kudos
DanPatterson
MVP Esteemed Contributor

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


... sort of retired...
0 Kudos