{
"name":"Ethiopia/ETH_HA_SPOT_Devices_merge",
"title":"Ethiopia/ETH_HA_SPOT_Devices_merge",
"type":"Map Service",
"typeKeywords":["ArcGIS Server","Service","Map Service"],
"description":"spot_ha_devices:<br /><div> SELECT row_number() OVER (ORDER BY eth_spot_hazard_task_evw.uniquerowid)::oid AS objectid,<\/div><div>    next_globalid() AS globalid,<\/div><div>    spot_hazard_dev_evw.dev_haz_id AS report_id,<\/div><div>    spot_hazard_dev_evw.dev_cont_type AS cont_type,<\/div><div>    spot_hazard_dev_evw.eo_model,<\/div><div>    spot_hazard_dev_evw.eo_device,<\/div><div>    spot_hazard_dev_evw.eo_device_other,<\/div><div>    spot_hazard_dev_evw.dev_amount AS amount,<\/div><div>    eth_spot_hazard_task_evw.cont_id,<\/div><div>    eth_spot_hazard_task_evw.report_dt,<\/div><div>    eth_spot_hazard_task_evw.status,<\/div><div>    eth_spot_hazard_task_evw.admin1name,<\/div><div>    eth_spot_hazard_task_evw.admin2name,<\/div><div>    eth_spot_hazard_task_evw.admin3name,<\/div><div>    eth_spot_hazard_task_evw.ops_validation_status,<\/div><div>    eth_spot_hazard_task_evw.im_validation_status,<\/div><div>    eth_spot_hazard_task_evw.shape,<\/div><div>    'Spot Task'::text AS source_table<\/div><div>   FROM spot_hazard_dev_evw<\/div><div>     LEFT JOIN eth_spot_hazard_task_evw ON spot_hazard_dev_evw.dev_haz_id::text = eth_spot_hazard_task_evw.cont_id::text<\/div><div>  WHERE eth_spot_hazard_task_evw.ops_validation_status::text = 'validated'::text AND eth_spot_hazard_task_evw.im_validation_status::text !~~ 'rejected'::text;<br /><br />HA_devices:<br /><div> SELECT row_number() OVER (ORDER BY eth_hazard_area_v2_evw.uniquerowid)::oid AS objectid,<\/div><div>    next_globalid() AS globalid,<\/div><div>    haz_dev_evw.dev_haz_id AS report_id,<\/div><div>    haz_dev_evw.dev_cont_type AS cont_type,<\/div><div>    haz_dev_evw.eo_model,<\/div><div>    haz_dev_evw.eo_device,<\/div><div>    haz_dev_evw.eo_device_other,<\/div><div>    haz_dev_evw.dev_amount AS amount,<\/div><div>    eth_hazard_area_v2_evw.cont_id,<\/div><div>    eth_hazard_area_v2_evw.report_dt,<\/div><div>    eth_hazard_area_v2_evw.status,<\/div><div>    eth_hazard_area_v2_evw.admin1name,<\/div><div>    eth_hazard_area_v2_evw.admin2name,<\/div><div>    eth_hazard_area_v2_evw.admin3name,<\/div><div>    eth_hazard_area_v2_evw.ops_validation_status,<\/div><div>    eth_hazard_area_v2_evw.im_validation_status,<\/div><div>    eth_hazard_area_v2_evw.shape,<\/div><div>    'HA'::text AS source_table<\/div><div>   FROM haz_dev_evw<\/div><div>     LEFT JOIN eth_hazard_area_v2_evw ON haz_dev_evw.dev_haz_id::text = eth_hazard_area_v2_evw.cont_id::text<\/div><div>  WHERE eth_hazard_area_v2_evw.ops_validation_status::text = 'validated'::text AND eth_hazard_area_v2_evw.im_validation_status::text !~~ 'rejected'::text AND eth_hazard_area_v2_evw.im_validation_status::text !~~ 'Remove'::text;<\/div><br /><\/div>",
"extent":[[36.868521675218126,43.13272056078198],[10.307997603652623,14.9867596323475]],

"url":"https://ims.unmas.org/server/rest/services/Ethiopia/ETH_HA_SPOT_Devices_merge/MapServer"
}