AnsweredAssumed Answered

Create New Field w/ Field Calculator (Regular Expression) between :

Question asked by Mtclimber03 on Jul 28, 2016
Latest reply on Jul 29, 2017 by W0194119

Hey guys,

 

I'm not sure if using the field calculator (regular expression) is the function in GeoEvents I should be using to accomplish what I need so let me try and explain. I have geoevents recieving a JSON REST endpoint that contains data that looks like/similar to the below.

 

{

"record" : {

  "ID" : "18",

  "PARENT_RECORD_ID" : "0",

  "PARENT_PAGE_ID" : "0",

  "PARENT_ELEMENT_ID" : "0",

  "CREATED_DATE" : "2016-06-29 17:43:32",

  "CREATED_BY" : "username",

  "CREATED_LOCATION" : "36.863681:42.992592:557.165466:65.000000:18.446595:-1.000000:-1.000000:1467211407.825839",

  "CREATED_DEVICE_ID" : "917f86ddc676fa0ef39f910c6460838d4451f0b8",

  "MODIFIED_DATE" : "2016-06-29 17:43:34",

  "MODIFIED_BY" : "username",

  "MODIFIED_LOCATION" : "36.863681:42.992592:557.165466:65.000000:18.446595:-1.000000:-1.000000:1467211407.825839",

  "MODIFIED_DEVICE_ID" : "917f86ddc676fa0ef39f910c6460838d4451f0b8",

  "SERVER_MODIFIED_DATE" : "2016-06-29 17:43:38",

  "project_number" : "8675309j",

  "project_name" : "name of project",

  "project_nickname" : "nickname",

  "date_of_report" : "2016-06-29",

  "data_type" : "completed_activity",

  "admin_div_1" : "some_governorate",

  "admin_div_2" : "Any_Town",

  "admin_div_3" : "Any_Loc",

  "admin_div_4" : "Any_where",

  "a99999_benev_funding" : 204,

  "a99999_benev_funding_male" : 0,

  "a99999_benev_funding_female" : 204,

  "a91602" : 85,

  "a91602_male" : 28,

  "a91602_female" : 57,

  "a99999_children_counseling" : 16,

  "a99999_children_counseling_male" : 6,

  "a99999_children_counseling_female" : 10,

  "a99999_hhheads_seminars" : 0,

  "a99999_hhheads_seminars_male" : 0,

  "a99999_hhheads_seminars_female" : 0,

  "a99999_cohesion_activities" : 47,

  "a99999_cohesion_activities_male" : 18,

  "a99999_cohesion_activities_female" : 29,

  "a90107" : 31,

  "a90107_male" : 15,

  "a90107_female" : 16,

  "a90309" : 97,

  "a90309_male" : 39,

  "a90309_female" : 58,

  "a90308" : 12,

  "a90308_male" : 6,

  "a90308_female" : 6,

  "a99999_leaders_trained" : 0,

  "a99999_leaders_trained_male" : 0,

  "a99999_leaders_trained_female" : 0,

  "a99999_cfs" : 40,

  "a99999_cfs_male" : 20,

  "a99999_cfs_female" : 20,

  "a50200_health_services" : 366,

  "a50200_health_services_male" : 128,

  "a50200_health_services_female" : 238,

  "a50200_dental" : 0,

  "a50200_dental_male" : 0,

  "a50200_dental_female" : 0,

  "a50200_obgyn" : 76,

  "a50200_obgyn_male" : 0,

  "a50200_obgyn_female" : 76,

  "a99999_emergency" : 60,

  "a99999_emergency_male" : 30,

  "a99999_emergency_female" : 30,

  "data_submission_status" : "validated",

  "assign_to" : "username"

  },

 

From here I need to use the record.CREATED_LOCATION coordinates to generate two new fields for latitude and longitude that can be used for the geometry. The 1st two sections of the record.CREATED_LOCATION are the x:y. Can some one point me in the right direction for what needs to be done to achieve this? Or alternatively let me know if there is another place in the geoevents manager I should be setting this up? So far I have my JSON feed successfully passing records into a feature service, just not mapping the points.

Outcomes