It would be good to match ESRI JSON output format to ESRI Enclosed Format so that it can be used for AWS Athena tables.
Archived
ESRI JSON output format should match ESRI Enclosed JSON format
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.
+3- Contributor
Agreed.
the format 'com.esri.json.hadoop.EnclosedJsonInputFormat' is required for all Athena geospatial compatibility.
https://docs.aws.amazon.com/athena/latest/ug/geospatial-functions-list.html
Current workaround is to use
- GeometryExtractor - Esri JSON for coordinates
- JSON Templater - kludgey as requires complex workbench / or hand coded field definitions.
- JSON Formatter
- write to text file
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.