{
 "culture": "en-GB",
 "name": "ETH_HA_SPOT_Devices_merge",
 "guid": "9B7021A4-49A6-4D94-8AD8-5B402F19CAC6",
 "catalogPath": "",
 "snippet": "combines the spot_ha_devices_join and ha_devices_join into a single feature layer",
 "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>",
 "summary": "combines the spot_ha_devices_join and ha_devices_join into a single feature layer",
 "title": "ETH HA SPOT Devices merge",
 "tags": [
  "ETH",
  "HA",
  "SPOT"
 ],
 "type": "Map Service",
 "typeKeywords": [
  "ArcGIS",
  "ArcGIS Server",
  "Data",
  "Map Service",
  "Service"
 ],
 "thumbnail": "thumbnail/thumbnail.png",
 "url": "",
 "extent": [
  [
   37.728997163,
   10.8425292360001
  ],
  [
   42.2722450730001,
   14.452228
  ]
 ],
 "minScale": 0,
 "maxScale": 1.7976931348623157E308,
 "spatialReference": "GCS_WGS_1984",
 "accessInformation": "",
 "licenseInfo": "",
 "portalUrl": ""
}