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.
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.