Skip to main content
Question

Convert nested complex GeoJSON to SQL Table

  • March 12, 2018
  • 1 reply
  • 28 views
A

Hi All,

I am trying to convert nested geoJSON to SQL table but FME converter is missing out on few tags when converting to a sql table (). The geoJSON file is attached below for reference. the FME SQL writer is not able to read "geometry" tag at line 75 from geoJSON file ().

Thanks

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.

1 reply

takashi
Celebrity
  • takashiCelebrity
  • March 12, 2018

Hi @abhaga, the missing fields seem to correspond to list attributes which have been converted from arrays in the source GeoJSON document. A list attribute could contain multiple values as its elements, whereas each field in the destination table can only contain a single value, so FME won't map a list attribute to a field automatically. See here to learn more about list attribute: About List Attributes

The solution depends on how you need to write the list elements into the destination table.

For example, the "wof:belongsto" array in the GeoJSON example contains six elements (102191575, 85633793, 85977539, etc.). How do you want to write them into the destination table?

Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.