[GIS] Exporting coordinates of shapefile into CSV using FME

csvfmeshapefile

I use FME to make a series of transformations from an autocad file to a shapefile (with line geometry).

What I am trying to do is to also export (together with the shapefile) a CSV file containing the coordinates. More specifically I need to get only the first and last coordinate of each linestring in the shapefile.

How can I do this in FME 2014?

Right now I have managed to export only a CSV containing the attribute values corresponding to each line.

Best Answer

One option its to make use of 2 coordinateExtractors , 1 for index 0 (1st coordinate) and another with index -1 (last coordinate) . enter image description here

Related Solutions

[GIS] Converting shapefile to CSV including attributes and geometry

Here's a simple script that uses the OGR python bindings:

import ogr,csv,sys

shpfile=r'C:\Temp\test.shp' #sys.argv[1]
csvfile=r'C:\Temp\test.csv' #sys.argv[2]

#Open files
csvfile=open(csvfile,'wb')
ds=ogr.Open(shpfile)
lyr=ds.GetLayer()

#Get field names
dfn=lyr.GetLayerDefn()
nfields=dfn.GetFieldCount()
fields=[]
for i in range(nfields):
    fields.append(dfn.GetFieldDefn(i).GetName())
fields.append('kmlgeometry')
csvwriter = csv.DictWriter(csvfile, fields)
try:csvwriter.writeheader() #python 2.7+
except:csvfile.write(','.join(fields)+'\n')

# Write attributes and kml out to csv
for feat in lyr:
    attributes=feat.items()
    geom=feat.GetGeometryRef()
    attributes['kmlgeometry']=geom.ExportToKML()
    csvwriter.writerow(attributes)

#clean up
del csvwriter,lyr,ds
csvfile.close()

EDIT: and another script to convert from your CSV to KML

import ogr,csv,sys,os
ogr.UseExceptions()

csvfile=r'C:\temp\test.csv' #sys.argv[1]
kmlfile=r'C:\temp\test.kml' #sys.argv[2]

csvreader=csv.reader(open(csvfile,'rb'))
headers=csvreader.next()

ds = ogr.GetDriverByName('KML').CreateDataSource(kmlfile)
lyr = ds.CreateLayer(os.path.splitext(os.path.basename(kmlfile))[0])

for field in headers[:-1]: #skip kmlgeometry
    field_def = ogr.FieldDefn(field)
    print lyr.CreateField(field_def)

for rec in csvreader:
    feat = ogr.Feature(lyr.GetLayerDefn())
    for i,field in enumerate(headers[:-1]): #skip kmlgeometry
        feat.SetField(field, rec[i])
    feat.SetGeometry(ogr.CreateGeometryFromGML(rec[-1]))
    lyr.CreateFeature(feat)

del lyr,ds

[GIS] Converting CAD Annotation to Shapefile with attributes using FME

First add the Autocad annotation layer in ArcGIS. Open the table of this layer and write down the fields you want to have in your shapefile.

Now create a point shapefile and add the same fields. Start editing the shapefile and just copy-paste the autocad annotation in the shapefile.

The table in the shapefile should now contain the text displayed in the annotation so now you can just label the points in ArcGIS.

Best Answer

Related Solutions

[GIS] Converting shapefile to CSV including attributes and geometry

[GIS] Converting CAD Annotation to Shapefile with attributes using FME

Related Question