topic Re: Write polyline vertices to csv in Python Questions

Write polyline vertices to csv

TonyAppel1 — Thu, 10 Apr 2014 13:27:54 GMT

I am looking for some code to write out each line feature in a feature class/shapefile to a csv file that would look something like this:

FID, X, Y

All help is appreciated.

thanks

Tony

Re: Write polyline vertices to csv

JakeSkinner — Thu, 10 Apr 2014 14:53:49 GMT

Hi Tony,

You could perform the following steps:

1. Convert the lines vertices to a point feature class using Feature Vertices to Points
2. Add XY Coordinates to point feature class
3. Export feature class to dbf file
4. Rename output dbf file to csv using os.rename

Re: Write polyline vertices to csv

Zeke — Thu, 10 Apr 2014 15:14:50 GMT

You could also use the python csv module to write the file out.

Re: Write polyline vertices to csv

MattEiben — Sun, 12 Dec 2021 00:32:30 GMT

A search cursor like this could easily iterate through all the points and add them to a csv file for you.

The key here is to use the "explode to points" method in the search cursor

import csv
        
with arcpy.da.SearchCursor(featureClass, ["OID@","SHAPE@XY"],explode_to_points=True) as cursor:
    with open("outputFile.csv","wb") as csvfile:
        writer = csv.writer(csvfile)
        writer.writerow(["FID","LAT","LON"])
        for row in cursor:
            FID = row[0]
            lat = row[1][1]
            lon = row[1][0]
            writer.writerow([FID,lat,lon])

Hope this helps!

Matt

Re: Write polyline vertices to csv

MatthewDobson — Fri, 11 Apr 2014 03:30:28 GMT

I am not sure, but will the 'Export Feature Attribute to ASCII' tool do the trick?

I found it under Spatial Statistics -> Utilities ....

Matthew