topic Re: How to export many point features as Lat Long coordinates to CSV using ArcGIS Pro V. 3.0? in ArcGIS Pro Questions

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

ThamerTarabzouni — Sun, 29 Oct 2023 07:04:43 GMT

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

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

DanPatterson — Mon, 30 Oct 2023 13:16:20 GMT

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

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

ThamerTarabzouni — Mon, 30 Oct 2023 04:29:32 GMT

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.

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

ThamerTarabzouni — Mon, 30 Oct 2023 05:48:06 GMT

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.

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

DanPatterson — Mon, 30 Oct 2023 10:50:32 GMT

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

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

AngelaSchirck — Mon, 30 Oct 2023 12:41:36 GMT

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?

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

ThamerTarabzouni — Thu, 02 Nov 2023 06:02:17 GMT

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.

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

DanPatterson — Thu, 02 Nov 2023 09:34:30 GMT

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

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

ThamerTarabzouni — Tue, 07 Nov 2023 05:56:21 GMT

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.

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

DanPatterson — Tue, 07 Nov 2023 09:28:30 GMT

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