Question
I need to go from EXCEL in address form TO KML
The excel sheet has the address with the St Num and Street Name are in 2 seperate colums. How do I translate this in fme to kml
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.
Hi,
A basic way is: 1) Start the FME Workbench with a blank workspace. 2) Add an Excel reader to read the Excel spread sheet. 3) Add a KML writer to write a kml file, and define user attributes named "St Num" and "Street Name" in the writer feature type. 4) Connect the reader to the writer, then run the workspace. If attribute names provided by the Excel reader are not preferable, rename them with the AttributeRenamer after reading features. By the way, I think a kml file is usually used to save spatial data, i.e. geometries and corresponding attributes. Do those attributes have to be written together with geometries (maybe line shapes)? If so, you probably should consider how to merge geometry (where come from?) and attributes (from Excel file) before writing. e.g. using the FeatureMerger. If you have any question about this, please let us know your actual conditions.
Takashi
+21- Safer
Hi,
You can try the GoogleGeocoder from the FME store, but you need more than just st num and strret name for that (or for any other type of geocoding for that matter)
Itay
+21- Safer
download the transformer and see for yourself....type google on the fme cnavas the store transformer should appear.
+21- Safer
You can create a KML file with just the addresses instead of a location and Google Earth will geocode those on the fly for you. See "http://fmepedia.safe.com/articles/How_To/How-to-use-Google-Earth-to-Georeference-KML-files" for more information.