Hi, does anyone know how to fix the "Geom" field and turn it into appropriate coordinates? I downloaded the CSV file from the city of Vancouver open portal and ran it in the FEM workspace without changing any parameters, but I couldn't see any point features after. I was wondering if I should fix the attributes as the coordinates are within the same field? Thank you!
Question
How to fix the coordinates in a CSV file?
+55- Celebrity
Hi @debbiewly
I used the transformer JSONFlattener to extract the informations that you want:
Attached the Workspace.
Thanks in Advance,
Danilo
@debbiewly It is odd that the City of Vancouver distributes it's point geometry as GeoJSON. You can use the GeometryReplacer and select Geometry Encoding: GeoJSON
Hi @debbiewly
I used the transformer JSONFlattener to extract the informations that you want:
Attached the Workspace.
Thanks in Advance,
Danilo
It works! Thanks @danilo_fme
Hi @Mark Stoakes , I am wondering if it is normal that the coordinates are gone after running the GeometryReplacer? Since I can no longer see the coordinates in the attribute.
+23- Safer
Hi @Mark Stoakes , I am wondering if it is normal that the coordinates are gone after running the GeometryReplacer? Since I can no longer see the coordinates in the attribute.
@debbiewly By default the "Remove Attribute" parameter on the GeometryReplacer is set to "Yes". Did you change it to "No"?
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.