Solved

JSON Multipolygon extraction


Badge

Hello,

 

I'm trying to extract a multipolygon from a JSON file with the model of this topic (https://knowledge.safe.com/questions/40791/json-multipolygon.html) but I don't achive to do it ...

It's my first time working with JSON

 

The multipolygon in the Json file is defined like this (I replace real value by x1 x2 etc in the exemple) :

{ "stages": { "filters.hexbin":{"boundary": "MULTIPOLYGON (((x1 y1,x2 y2,x3 y3,.... )))

I've try with : json["stages"]["filters.hexbin"]["boundary"] in JSONExtractor but it doesn't work , an I don't really know what I need to fill in "JSON Document" ...

Does anyone have any idea how to do it?

 

Regards

icon

Best answer by takashi 13 June 2020, 06:55

View original

2 replies

Userlevel 2
Badge +17

Hi @arnaudfouch, looks like the MULTIPOLYGON text is an OGC WKT geometry representation. If so, you can convert the text to a geometry with the GeometryReplacer (Geometry Encoding: OGC Well Known Text).

Badge

Hi @arnaudfouch, looks like the MULTIPOLYGON text is an OGC WKT geometry representation. If so, you can convert the text to a geometry with the GeometryReplacer (Geometry Encoding: OGC Well Known Text).

Great ! It works !

Thank you very much

Reply