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?
Userlevel 3
+17
- Contributor
- 7538 replies
-
6 February 2019
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.
- Open FME Workbench.
- Add the Shapefile reader.
- Add the CSV (or Excel) writer.
- Connect between the reader feature type and the writer feature type on the Canvas.
- Insert a transformer (CoordinateConcatenator or GeometryExtractor) between them. It depends on your desired geometry format to use which transformer.
- Modify the configuration of User Attributes in the CSV (or Excel) writer feature type as your desired.
- Done! Run the workspace.
I would recommend you to learn first the FME Desktop Basic Training Manual.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.