Hi,
I’ve imported several GeoJSON files (all from data.gov) into Foundry and have been trying to run transforms on them. Following the tutorials, I imported them as “Unstructured” and then used a series of transforms — including the “Prepare Geometry” transform — to properly format the geometry column.
It seemed very straightforward, and I was able to get it working perfectly… but only with the exact same data file used in the tutorial. I have several other GeoJSON files I’d really like to use.
The issue is that when I run the first transform (“Extract Rows from JSON”) and paste my GeoJSON into the text field to auto-generate the schema, it does a decent job overall but does not correctly parse the geometry field (and everything downstream from it).
The feature to automatically generate the schema from a GeoJSON file is really nice in theory, but it doesn’t seem to work reliably most of the time. Am I doing something wrong?
I’ve occasionally gotten it to work by manually editing the geometry level and adding extra nested array + double fields through trial and error, but this isn’t scalable at all.
This is currently the one thing holding me back on the platform. Any guidance on what I’m missing would be greatly appreciated!
Example geojson that’s giving me trouble: https://data.cnra.ca.gov/dataset/california-lakes
Thanks!