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?
Question
Shapefile to csv
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
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.