Hello All,
I guess the Subject question is not completely correct - in the way that I am thinking.
I am here to ask if I am understanding correctly - There is a way to "connect" GeoEvent Server to a table (or view) in a in a non-spatial or non-SDE database. Maybe the correct way of saying this is that we can register a database (in my case PostgreSQL) with ArcGIS Server and then, in GeoEvent, connect to the Feature/Web service that is now available in Server.
Am I getting this concept right? Here's my workflow:
My db user has all of the correct privileges....
In this scenario, should I be able to utilize a "Poll an ArcGIS Server for Features" input to grab the most recent events from those published payers?
Thank you for your help,
--Adam
Solved! Go to Solution.
An alternative to the suggestion below of using a hierarchical JSON structure is to use regular expression in a standard field calculator to pull each field out (you would need 5 Field Calculators. Each one would would have an expresion like the following:
replaceAll(jsonStringField, '.*"rssi":(\d+),.*', '$1')
Just replace the field name (rssi) with whatever field you are working on.
At GeoEvent Server version 10.9 you can add this function in a Field Mapper processor. Previous versions will require a Field Calclulator for each field you want to parse the value for.