Hi everyone, So I got a task, and I don`t know how to do it. In csv file, i have to create two new columns which shows WGS-84 coordinates. Maybe someone, have solution for this ? I can`t undertstand what is in 29 line... I tried to google it.. And I found the example... but without explanation. Thanks for any help import arcpy import csv fc = r" #" out_csv = r" #" fields = { "OBJECTID" : "OBJECTID" , "Global_ID" : "Global_ID" , "Global_Copy" : "Global_Copy" , "SHAPE@X" : "POINT_X" , "SHAPE@Y" : "POINT_Y" , "SHAPE@X" : "LAT" , "SHAPE@Y" : "LONG" } table_fields = [ ] csv_fields = [ ] for field in fields : table_fields . append ( field ) csv_fields . append ( fields [ field ] ) def tableToCSV ( fc , out_csv ) : with open ( out_csv , 'wb' ) as csv_file : writer = csv . writer ( csv_file , delimiter = ';' , lineterminator = '\n' ) writer . writerow ( csv_fields ) with arcpy . da . SearchCursor ( fc , table_fields ) as cursor : for row in cursor : arcpy . PointGeometry ( arcpy . Point ( X , Y ) , arcpy . SpatialReference ( 3346 ) ) . projectAs ( arcpy . SpatialReference ( 4326 ) ) point = Point ( row [ idxLAT ] , row [ idxLONG ] ) #TODO: reproject reppoint = point row [ idxLAT ] = reppoint . x row [ idxLONG ] = reppoint . y writer . writerow ( row ) print out_csv #csv_file.close() tableToCSV ( fc , out_csv )

This provides some interesting results. By specifying a spatial reference in the search cursor, you can get latitude and longitude very easily. And it is easy to have tab delimited output. # WGS 1984 : (4326) Lat/Lon print "{}\t{}\t{}" . format ( "OBJECTID" , "POINT_X" , "POINT_Y" ) for row in arcpy . da . SearchCursor ( "MyPointLayer" , [ "OID@" , "SHAPE@X" , "SHAPE@Y" ] , spatial_reference = arcpy . SpatialReference ( 4326 ) ) : print "{}\t{}\t{}" . format ( row [ 0 ] , # OBJECTID row [ 1 ] , # POINT_X (LON) row [ 2 ] # POINT_Y (LAT) )

Hello John, When I export a point feature to a CSV or Excel table, I like to have the X and Y coordinates in longitude and latitude. To do this, I use the Add Geometry Attributes tool before exporting my table. This tool adds two columns, Point_X and Point_Y, to your feature. By specifying a spatial reference, you can have the XY in longitude/latitude. This tool does modify the input table by adding these columns. You could make a copy of your feature, perhaps "in-memory", and modify it if you did not want the columns in your original feature. I would use the following code in your script before your lines to export to csv to create and populate the feature with Point_X and Point_Y fields: spatial_reference = arcpy . SpatialReference ( "WGS 1984" ) arcpy . AddGeometryAttributes_management ( fc , "POINT_X_Y_Z_M" , " #","#",spatial_reference) Like Neil Ayres, I am confused by your files dictionary. I am not sure why you are adding a second SHAPE@X/Y (X is Long and Y is Lat), so I would suggest dropping this. Instead of using Add Geometry Attributes, you might try something like this to get longitude and latitude: for row in arcpy . da . SearchCursor ( "MyPointLayer" , [ "OID@" , "SHAPE@XY" ] ) : print ( "Feature {}:" . format ( row [ 0 ] ) ) , px , py = row [ 1 ] print ( "{}, {}" . format ( px , py ) ) # WGS 1984 : (4326) Lat/Lon # WGS 1984 Web Mercator (auxiliary sphere) : (102100) or (3857) ptGeometry = arcpy . PointGeometry ( arcpy . Point ( px , py ) , arcpy . SpatialReference ( 3857 ) ) . projectAs ( arcpy . SpatialReference ( 4326 ) ) print ptGeometry . firstPoint . X , ptGeometry . firstPoint . Y Hope this helps.

Sorry, but I am not quite with you here.... You now have a bunch of variables, you can construct a list of those values, then push it through the csv writer to write each line.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do you project a single pointGeometry object with arcpy?

JohnMcoy

Hi everyone,

So I got a task, and I don`t know how to do it. In csv file, i have to create two new columns which shows WGS-84 coordinates. Maybe someone, have solution for this ? I can`t undertstand what is in 29 line... I tried to google it.. And I found the example... but without explanation.

Thanks for any help

<SPAN class="keyword token">import</SPAN> arcpy 
<SPAN class="keyword token">import</SPAN> csv

fc <SPAN class="operator token">=</SPAN> r"<SPAN class="comment token">#"</SPAN>
out_csv <SPAN class="operator token">=</SPAN> r"<SPAN class="comment token">#"</SPAN>

fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"OBJECTID"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"OBJECTID"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"Global_ID"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Global_ID"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"Global_Copy"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Global_Copy"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"SHAPE@X"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"POINT_X"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"SHAPE@Y"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"POINT_Y"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"SHAPE@X"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"LAT"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"SHAPE@Y"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"LONG"</SPAN>
<SPAN class="punctuation token">}</SPAN>

table_fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
csv_fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">for</SPAN> field <SPAN class="keyword token">in</SPAN> fields<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; table_fields<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>field<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; csv_fields<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>fields<SPAN class="punctuation token">[</SPAN>field<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">tableToCSV</SPAN><SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> out_csv<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> open<SPAN class="punctuation token">(</SPAN>out_csv<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'wb'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> csv_file<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; writer <SPAN class="operator token">=</SPAN> csv<SPAN class="punctuation token">.</SPAN>writer<SPAN class="punctuation token">(</SPAN>csv_file<SPAN class="punctuation token">,</SPAN> delimiter<SPAN class="operator token">=</SPAN><SPAN class="string token">';'</SPAN><SPAN class="punctuation token">,</SPAN> lineterminator<SPAN class="operator token">=</SPAN><SPAN class="string token">'\n'</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; writer<SPAN class="punctuation token">.</SPAN>writerow<SPAN class="punctuation token">(</SPAN>csv_fields<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> table_fields<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>PointGeometry<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>Point<SPAN class="punctuation token">(</SPAN>X<SPAN class="punctuation token">,</SPAN>Y<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>SpatialReference<SPAN class="punctuation token">(</SPAN><SPAN class="number token">3346</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>projectAs<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>SpatialReference<SPAN class="punctuation token">(</SPAN><SPAN class="number token">4326</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; point <SPAN class="operator token">=</SPAN> Point<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN>idxLAT<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN>idxLONG<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#TODO: reproject</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reppoint <SPAN class="operator token">=</SPAN> point
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN>idxLAT<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> reppoint<SPAN class="punctuation token">.</SPAN>x
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN>idxLONG<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> reppoint<SPAN class="punctuation token">.</SPAN>y
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; writer<SPAN class="punctuation token">.</SPAN>writerow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> out_csv&nbsp; 
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#csv_file.close()</SPAN>

tableToCSV<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> out_csv<SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Encontre mais publicações marcadas com

Accepted answers

All comments

RandyBurton

This provides some interesting results. By specifying a spatial reference in the search cursor, you can get latitude and longitude very easily. And it is easy to have tab delimited output.

<SPAN class="comment token"># WGS 1984 : (4326) Lat/Lon&nbsp; </SPAN>

<SPAN class="keyword token">print</SPAN> <SPAN class="string token">"{}\t{}\t{}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"OBJECTID"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"POINT_X"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"POINT_Y"</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"MyPointLayer"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">"OID@"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"SHAPE@X"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"SHAPE@Y"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>spatial_reference<SPAN class="operator token">=</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>SpatialReference<SPAN class="punctuation token">(</SPAN><SPAN class="number token">4326</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"{}\t{}\t{}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="comment token"># OBJECTID</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="comment token"># POINT_X (LON)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN>&nbsp; <SPAN class="comment token"># POINT_Y (LAT)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

RandyBurton

Hello John,

When I export a point feature to a CSV or Excel table, I like to have the X and Y coordinates in longitude and latitude. To do this, I use the Add Geometry Attributes tool before exporting my table. This tool adds two columns, Point_X and Point_Y, to your feature. By specifying a spatial reference, you can have the XY in longitude/latitude. This tool does modify the input table by adding these columns. You could make a copy of your feature, perhaps "in-memory", and modify it if you did not want the columns in your original feature.

I would use the following code in your script before your lines to export to csv to create and populate the feature with Point_X and Point_Y fields:

spatial_reference <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>SpatialReference<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"WGS 1984"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddGeometryAttributes_management<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"POINT_X_Y_Z_M"</SPAN><SPAN class="punctuation token">,</SPAN>"<SPAN class="comment token">#","#",spatial_reference)‍‍‍‍‍‍</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Like Neil Ayres‌, I am confused by your files dictionary. I am not sure why you are adding a second SHAPE@X/Y (X is Long and Y is Lat), so I would suggest dropping this.

Instead of using Add Geometry Attributes, you might try something like this to get longitude and latitude:

<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"MyPointLayer"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">"OID@"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"SHAPE@XY"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Feature {}:"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;px<SPAN class="punctuation token">,</SPAN> py <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"{}, {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>px<SPAN class="punctuation token">,</SPAN> py<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="comment token"># WGS 1984 : (4326) Lat/Lon&nbsp; </SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="comment token"># WGS 1984 Web Mercator (auxiliary sphere) : (102100) or (3857)&nbsp; </SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ptGeometry <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>PointGeometry<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>Point<SPAN class="punctuation token">(</SPAN>px<SPAN class="punctuation token">,</SPAN>py<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>SpatialReference<SPAN class="punctuation token">(</SPAN><SPAN class="number token">3857</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>projectAs<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>SpatialReference<SPAN class="punctuation token">(</SPAN><SPAN class="number token">4326</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="keyword token">print</SPAN> ptGeometry<SPAN class="punctuation token">.</SPAN>firstPoint<SPAN class="punctuation token">.</SPAN>X<SPAN class="punctuation token">,</SPAN> ptGeometry<SPAN class="punctuation token">.</SPAN>firstPoint<SPAN class="punctuation token">.</SPAN>Y<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Hope this helps.

NeilAyres

So that csv is already exported from a feature class? It has an OBJECTID column.

And the presence of POINT_X, POINT_Y would also suggest that this has been used...

Add Geometry Attributes—Help | ArcGIS Desktop

So, if you haven't got the original feature instead of this exported version, why not just re-import it into ArcMap?

There are several ways of adding the XY (in whatever form) back to the point feature.

Generally, if the required coordinates are not the actual coordinates of the point feature, I use ArcMap, add the feature, change the coord sys of the data frame to the system I want, then use the calculate geometry option on 2 new columns, use the coord sys of the data frame.

JohnMcoy

I have database with ~50 columns. I take about 20 specific columns. As you see in array-fields. In csv Poin-X and Point-Y has show 3346 cordinates and Lat, Long has show 4326. In CSV file must create two new columns Lat and Long. CSV looks like this i hope you understand everything. Is there enough information ??

Switch Default2.png

NeilAyres

You could just import the csv, make a point feature out of it, then re-project it to GCS_WGS84 directly.

If you want a programmatic solution, then some details of what the csv file looks like would be good.

NeilAyres

Well WKID 3346 appears to be some coordinate system in Lithuania.

LKS94 / Lithuania TM: EPSG Projection -- Spatial Reference

Line 29, is taking 2 values (X, Y), creating a point geometry in 3346 and then re-projecting them to WKID 4326, which is GCS_WGS84.

If you already had a geometry object, the general form would be :

geom2 = geom1.projectAs(newSR)<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Not sure in the original script where X & Y are coming from.

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Entrar
Registrar

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.