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?
+52- 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.
+21- 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"?