any idea what the best way to extract the xy location from this string would be?
{"type":"Point","coordinates":[-1.35507,52.83477]}
Best answer by davideagle
View original
+10
- Contributor
- 577 replies
-
13 June 2016
- Best Answer
regex.fmw should sort you out. Use regex to grab the contents of the square brackets and then split the string in the usual way with the AttributeSplitter.
Hope that helps, Dave
Userlevel 4
- 8170 replies
-
13 June 2016
In addition to the regex-based solution by @1spatialdave, you can also use the JSONExtractor (since what you posted looks to be JSON) and do the whole extraction with a single transformer.
To extract your coordinates into the attributes x and y, use:
+10
- Contributor
- 577 replies
-
13 June 2016
In addition to the regex-based solution by @1spatialdave, you can also use the JSONExtractor (since what you posted looks to be JSON) and do the whole extraction with a single transformer.
To extract your coordinates into the attributes x and y, use:
Nice one @david_r
thank you both for your help still getting my head around the regex expressions. perfect :)
+3
Well, it is the geometry part of a GeoJSON.
Actually GeometryReplacer might be your best friend. It converts the string to feature if you tell the transformer that it is a GeoJSON :)
So you can use the CoordinateExtractor and no coding involved.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.