Extracting Geometry Coordinates from JSON String

TomFlahive

With the GeoEvent Processor, is there a way to extract the coordinates from a JSON field when the coordinates are embedded in a single string?:

"CREATED_LOCATION":"31.555114:-117.458182:12.792526:10.000000:3.000000:0.000000:-1.000000:1402525011.385171"

I'm just trying to pull out the 31.555114 and -117.458182 to be used in creating Geometry for a feature service.  I asked a similar question recently (http://forums.arcgis.com/threads/109721-Converting-Lat-Long-Coordinates-in-JSON-Feed-to-Geometry?p=389548#post389548), but this case is a little trickier since the coordinates are now embedded in a single string.

RJSunderman

Hello Tom -

I apologize for not being able to respond to your post earlier.

The easiest way to do what I think you are trying to do will be to leverage the Field Calculator and Java string functions available with the 10.2.2 product release.

Given a block of JSON input:

{
    "Attributes": {
        "name": "Some name...",
        "date": "2/17/2014 15:31:45"
    },
    "Location": "31.555114:-117.458182:12.792526:10.000000:3.000000:0.000000"
}

You could design a GeoEvent Service something like the one illustrated below to find the index of the ':' delimiters within the event attribute string and then pull the substring found between those index values.

[ATTACH=CONFIG]34963[/ATTACH]
(Click to Enlarge)

This is going to depend on your "latitude" and "longitude" always being found within the first two substring values of the Location attribute string. The output you should expect would look something like:

[
    {
        "Attributes": {
            "name": "Some name...",
            "date": 1392679905000
        },
        "Location": "31.555114:-117.458182:12.792526:10.000000:3.000000:0.000000",
        "IdxA": 9,
        "IdxB": 21,
        "Latitude": 31.555114,
        "Longitude": -117.458182
    }
]

Hope that helps -
RJ

GeoEventService.png