Skip to main content
Question

How to fix the coordinates in a CSV file?


Forum|alt.badge.img

Van_coordinatesScreenshot 2022-04-17 125608Hi, 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!

7 replies

danilo_fme
Evangelist
Forum|alt.badge.img+45
  • Evangelist
  • April 17, 2022

Hi @debbiewly​ 

 

I used the transformer JSONFlattener to extract the informations that you want:

 

Workspace_JSON 

Attached the Workspace.

 

Thanks in Advance,

Danilo

 

 

 


Forum|alt.badge.img+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


Forum|alt.badge.img
  • Author
  • April 18, 2022
danilo_fme wrote:

Hi @debbiewly​ 

 

I used the transformer JSONFlattener to extract the informations that you want:

 

Workspace_JSON 

Attached the Workspace.

 

Thanks in Advance,

Danilo

 

 

 

It works! Thanks @danilo_fme


danilo_fme
Evangelist
Forum|alt.badge.img+45
  • Evangelist
  • April 18, 2022
debbiewly wrote:

It works! Thanks @danilo_fme

Oh Thanks your feedback! :)


Forum|alt.badge.img
  • Author
  • April 18, 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.


DanAtSafe
Safer
Forum|alt.badge.img+18
  • Safer
  • April 18, 2022
debbiewly wrote:

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"?


use JSONFlattener to extract data.

 

papajohns promo codes


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings