Skip to main content

First of all, I am new to this software. I would like to convert shapefile data to a csv file to be opened with excel. The data I am using is county data for the US and I would like to extract the lat and longs for all county borders. However, all I seem to be getting when I use the Quick Translator is the max and min lat long for each county. How get I get all the data I need from this file?

If you need to extract all coordinates of a geometry read from a GIS dataset such as Shapefile file and write them into a CSV (or Excel) table, you will have to create a workspace with FME Workbench.

  1. Open FME Workbench.
  2. Add the Shapefile reader.
  3. Add the CSV (or Excel) writer.
  4. Connect between the reader feature type and the writer feature type on the Canvas.
  5. Insert a transformer (CoordinateConcatenator or GeometryExtractor) between them. It depends on your desired geometry format to use which transformer.
  6. Modify the configuration of User Attributes in the CSV (or Excel) writer feature type as your desired.
  7. Done! Run the workspace.

I would recommend you to learn first the FME Desktop Basic Training Manual.


Reply