I have created a geojson file from nine features drawn from a postgis database. I have tried all the examples from the community pages with no success. Can anybody point me in the right direction?
Solved
JsonTempater Geometry template usage
+9- Contributor
Best answer by daveatsafe
You can do this with a simple PostGIS to GeoJSON workspace, with the GeoJSON writer option ‘File Structure’ set to ‘Array of FeatureCollection objects - one per feature type’.
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.
+58- Celebrity
Hi
Do you have the geoson created? If yes, could you share us?
Thanks
+9- Contributor
I should have said I’m trying the create a geojson. It writes out but this geometry template doesn’t do anything.
jurgen
+58- Celebrity
I should have said I’m trying the create a geojson. It writes out but this geometry template doesn’t do anything.
jurgen
Hi Jurgen, thanks your answer.
Please, could you share your workspace template.
+9- Contributor
Finally, here is the workbench. Can someone have a look and see what i am doing wrong. I am trying to include the geometry in the output geojsn file but none of the examples i have tried when configuring the geometry template in the JSONTemplater have worked.
+48- Celebrity
Is there a reason you want/need to use the Templator as opposed to just the GeoJSON Writer? Does FME not create the correct structure from your featuers?
+9- Contributor
I have a dataset that has multiple features and I was hoping to generate one json file instead of one for each feature.
+24- Safer
- Best Answer
You can do this with a simple PostGIS to GeoJSON workspace, with the GeoJSON writer option ‘File Structure’ set to ‘Array of FeatureCollection objects - one per feature type’.
+9- Contributor
Thanks Dave,
PS. For future reference is there anything wrong with the way i am setting up the Geometry Template?
Jurgen
+24- Safer
Working with the geometry template can be quite complex. You can see more information on it at https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Transformers/XQuery/XQuery_functions.htm. It would be a lot easier to use the GeometryExtractor to extract the geometry as GeoJSON, then insert that attribute into the template using:
"geometry" :fme:get-json-attribute("_geometry")