topic Re: How do I export cordinates of polygon shapes to excel. in Data Management Questions

How do I export cordinates of polygon shapes to excel.

Nicolettevan_den_Heever — Mon, 13 Mar 2017 13:14:09 GMT

I received shape files, and imported it. I can see the shapes, but I need to export the cordinate points of the shape to an excel or csv file in order to import into another program.

Re: How do I export cordinates of polygon shapes to excel.

JayantaPoddar — Mon, 13 Mar 2017 14:48:43 GMT

If you are looking for the XY coordinates of Centroid of polygons, you could add two Fields to Attribute Table, viz, X and Y and use Calculate Geometry to populate the fields with the X and Y coordinate of the Centroid. Then you can use Table to Excel geoprocessing tool to export to Excel.

But, if you want the XY coordinates of all the vertices of the polygon, you will need to convert feature vertices to points, add the XY fields to attribute table and populate using Calculate Geometry. Then Go for Table to Excel.

Re: How do I export cordinates of polygon shapes to excel.

DanPatterson_Retired — Mon, 13 Mar 2017 18:32:12 GMT

For all points for all license levels, there are other workarounds

The key is the explode_to_points which busts up the geometry into its constituent points. Rows 1 to 5 form the clockwise points of a square in this example. Once busted up, bring it back in as table and export to excel, or there are tools to simply send the array to excel directly...

Re: How do I export cordinates of polygon shapes to excel.

LieslDe_Swardt1 — Mon, 14 Jan 2019 10:16:47 GMT

Hi Dan,

Is it possible to export the coordinates of vertices of a polygon into excel or as a text file in the following format: Polygon1: y,x ; y,x ;y,x ; y,x

Therefore, all coordinates that make up a polygon should be in one row?

Re: How do I export cordinates of polygon shapes to excel.

DanPatterson_Retired — Mon, 14 Jan 2019 13:05:20 GMT

Liesl Not without coding the output to from numpy to a row format. If you have a use case, you might want to start another question describing the need to go to excel and why WKT or similar output format is needed

Re: How do I export cordinates of polygon shapes to excel.

XanderBakker — Sun, 12 Dec 2021 06:36:32 GMT

Hi Liesl De Swardt ,

I guess you could do something like this with a bit of Python code:

def main():
    import arcpy

    fc = r'C:\GeoNet\WKT\data.gdb\polygons'  # the input polygons
    fld_id = 'OID@'  # use the OID as ID field in the output
    txt = r'C:\GeoNet\WKT\output2.txt'  # teh output text file to load into Excel

    with open(txt, 'w') as f:
        with arcpy.da.SearchCursor(fc, (fld_id, 'SHAPE@')) as curs:
            for row in curs:
                polygon = row[1]
                result = GetYXcrdList(polygon.WKT)
                f.write("{}\t{}\n".format(row[0], result))


def GetYXcrdList(wkt):
    wkt = wkt.replace('MULTIPOLYGON (((', '').replace(')))', '')
    lst = wkt.split(',')
    result = ""
    for crd in lst:
        xy = crd.strip().split(' ')
        if result == '':
            result = "{},{}".format(xy[1], xy[0])
        else:
            result += ";{},{}".format(xy[1], xy[0])
    return result

if __name__ == '__main__':
    main()
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Just change:

line 4 to point to your polygon featureclass
line 5 to include a field to identify the resulting coordinate lists
line 6 to point to an output text file that can be loaded into Excel

Below the result of a test run:

What do you want to do with this list of Lat, Lon coordinates in Excel?

Re: How do I export cordinates of polygon shapes to excel.

MRC — Thu, 20 Jun 2019 08:01:34 GMT

i cant run this code

pls help me with this error @Xander Bakker

Re: How do I export cordinates of polygon shapes to excel.

DanPatterson_Retired — Thu, 20 Jun 2019 08:33:18 GMT

You have a shapefile in a geodatabase... try a featureclass in a geodatabase

You have to edit the full path to the inputs... you just changed "Polygons" to polygons.shp in Xander's code on line 4, so unless you recreated his folder path structure, it won't work

Re: How do I export cordinates of polygon shapes to excel.

MRC — Thu, 20 Jun 2019 10:05:30 GMT

i have ald changed folder path structure , but it didn't work. .

it is my link folder , i make like him

the error still just say: "cannot open"

could you please give me an advise... thank you

Re: How do I export cordinates of polygon shapes to excel.

MRC — Thu, 20 Jun 2019 10:08:09 GMT

if you can make a video for this code, it will be great....

Re: How do I export cordinates of polygon shapes to excel.

DanPatterson_Retired — Thu, 20 Jun 2019 10:20:07 GMT

You still have a shapefile...

Line 9.... it is Shape@ , not Shape*

I prefer https://community.esri.com/message/672481-re-how-do-i-export-cordinates-of-polygon-shapes-to-excel?commentID=672481#comm…

Re: How do I export cordinates of polygon shapes to excel.

MRC — Thu, 20 Jun 2019 10:34:23 GMT

""You still have a shapefile..."" what would file i need ??

i changed it to shape@ but still same, can you use this code and run it ? then you can find the point i fail, thanks you very much because help me ....

Re: How do I export cordinates of polygon shapes to excel.

XanderBakker — Thu, 20 Jun 2019 16:52:01 GMT

Hi Havan Cong ,

When you look at the original code I provided, you will see on line 4:

    fc = r'C:\GeoNet\WKT\data.gdb\polygons'  # the input polygons‍

In my case, I have a featureclass named "polygons" which is stored inside a file geodatabase called "data.gdb" inside the folder "C:\GeoNet\WKT".

In your case you have:

    fc = r'C:\GeoNet\WKT\data.gdb\polygons.shp'‍

You are using a shapefile called "polygons.shp" which is located inside a folder called "C:\GeoNet\WKT\data.gdb". Possibly using a folder name with a point in it is causing the problems or maybe there is something wrong with the polygon shapefile. Is it possible to attach a ZIP file with the shapefile to this thread to see what is causing the problem?

The error indicates that it cannot open the shapefile.

Re: How do I export cordinates of polygon shapes to excel.

MRC — Fri, 21 Jun 2019 02:35:26 GMT

Thank you for your help Xander, it's worked. But the result of a test run i get not like my wish

example: the coordinates of polygon i use is a GCS_WGS_1984 and the result show me like this

but the file result i want to receive like below :

the type coordinates is Degree same like coordinates of Google earth file

Could you please help me change a little bit of the code and then export the coordinates like i hope

thank you very much Xander....

Re: How do I export cordinates of polygon shapes to excel.

XanderBakker — Fri, 21 Jun 2019 12:01:19 GMT

I guess that if you project your coordinates to WGS 1984, the result will list the coordinates in WGS 1984 decimal degrees. The code will not change the coordinates, just make sure your shapefile or featureclass is in the right coordinate system before you run the code.