Create New Field w/ Field Calculator (Regular Expression) between :
Charlie,
The field calculator (regular expression) is exactly what you need to help parse through your JSON and extract the proper coordinates. Since I do not have access to your JSON REST endpoint, I took your example record and utilized the "Watch a Folder for New JSON Files" connector.
1. Create a new GeoEvent definition for your input (copy the auto generated definition from the first time you recorded a GeoEvent through the REST endpoint). My original input I called JSON_IN:
Add three fields to your new copy:
- Coords (String)
- x (Double)
- y (Double)
My new output definition I called JSON_IN-copy (new fields at the end)
2. Begin to extract coordinates and calculate geometry:
- Field Mapper -- Map original GeoEvent Definition to the new one
- Name: fm
- Processor: Field Mapper
- Source: JSON_IN (your original input)
- Target: JSON_IN-copy (your modified output with three fields).
- Make sure your three new fields are included at the bottom:
- Field Calculator (Regular Expression) -- Process the Latitude/Longitude from original JSON
- Name: Pull Coordinates
- Processor: Field Calculator (Regular Expression)
- Field Name: ${CREATED_LOCATION}
- Pattern: ^(\d*.\d*):(\d*.\d*)
- Target Field: Existing Field
- Existing Field Name: Coords
- Sample value written to Coords field: 36.863681:42.992592
- Field Calculator (Regular Expression) -- Calculate X - Search from the beginning of the Coords field value for all characters prior to a colon.
- Name: x_calc
- Processor: Field Calculator (Regular Expression)
- Field Name: ${Coords}
- Pattern: ^(\d*.\d*) or ^[^:]+
- Target Field: Existing Field
- Existing Field Name: x
- Sample value: 36.863681
- Field Calculator (Regular Expression) -- Calculate Y
- Name: y_calc
- Processor: Field Calculator (Regular Expression) - Locate value before a colon (from end of the Coords field)
- Field Name: ${Coords}
- Pattern: (\d*.\d*)$ or [^:]+$
- Target Field: Existing Field
- Existing Field Name: y
- Sample Value: 42.992592
- Field Calculator - Process Geometry - Combine values of X, Y into a geometry field
- Name: Process Geometry
- Processor: Field Calculator
- Expression: '{"x":'+ x +',"y":'+ y +'}'
- Target Field: New Field
- New Field Name: Geometry
- New Field Type: GEOMETRY
- New GeoEvent Definition Name: Final_EXAMPLE
That process will output:
You can now see the fields at the end including the geometry in " ". With a geometry assigned, you should be able to output to a Feature Service. I have a hunch that you can accomplish this in maybe a step or less, depending on your experience level with regular expressions. However, this worked just fine for me.
Let me know if you have any questions.
Regards,
Alex
Hi Alexander,
Thanks for this sample. I have it about 99% working but I think it is getting hung up somewhere in the service. Maybe the last step? In my monitor page I can see that I have data coming in and the input also indicates this. However, I am not getting an output. See screenshots attached below. Any ideas where this might be getting hung up?
