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!
How to fix the coordinates in a CSV file?
Userlevel 4
+30
- Evangelist
- 1880 replies
-
18 April 2022
Hi @debbiewly
I used the transformer JSONFlattener to extract the informations that you want:
Attached the Workspace.
Thanks in Advance,
Danilo
+2
@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
Userlevel 4
+30
- Evangelist
- 1880 replies
-
18 April 2022
It works! Thanks @danilo_fme
Oh Thanks your feedback! :)
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.
Userlevel 2
+11
- Safer
- 255 replies
-
18 April 2022
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"?
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.