View In:
ArcGIS JavaScript
ArcGIS Online Map Viewer
ArcGIS Earth
ArcGIS Pro
Service Description: spot_ha_devices:
SELECT row_number() OVER (ORDER BY eth_spot_hazard_task_evw.uniquerowid)::oid AS objectid,
next_globalid() AS globalid,
spot_hazard_dev_evw.dev_haz_id AS report_id,
spot_hazard_dev_evw.dev_cont_type AS cont_type,
spot_hazard_dev_evw.eo_model,
spot_hazard_dev_evw.eo_device,
spot_hazard_dev_evw.eo_device_other,
spot_hazard_dev_evw.dev_amount AS amount,
eth_spot_hazard_task_evw.cont_id,
eth_spot_hazard_task_evw.report_dt,
eth_spot_hazard_task_evw.status,
eth_spot_hazard_task_evw.admin1name,
eth_spot_hazard_task_evw.admin2name,
eth_spot_hazard_task_evw.admin3name,
eth_spot_hazard_task_evw.ops_validation_status,
eth_spot_hazard_task_evw.im_validation_status,
eth_spot_hazard_task_evw.shape,
'Spot Task'::text AS source_table
FROM spot_hazard_dev_evw
LEFT JOIN eth_spot_hazard_task_evw ON spot_hazard_dev_evw.dev_haz_id::text = eth_spot_hazard_task_evw.cont_id::text
WHERE eth_spot_hazard_task_evw.ops_validation_status::text = 'validated'::text AND eth_spot_hazard_task_evw.im_validation_status::text !~~ 'rejected'::text;
HA_devices:
SELECT row_number() OVER (ORDER BY eth_hazard_area_v2_evw.uniquerowid)::oid AS objectid,
next_globalid() AS globalid,
haz_dev_evw.dev_haz_id AS report_id,
haz_dev_evw.dev_cont_type AS cont_type,
haz_dev_evw.eo_model,
haz_dev_evw.eo_device,
haz_dev_evw.eo_device_other,
haz_dev_evw.dev_amount AS amount,
eth_hazard_area_v2_evw.cont_id,
eth_hazard_area_v2_evw.report_dt,
eth_hazard_area_v2_evw.status,
eth_hazard_area_v2_evw.admin1name,
eth_hazard_area_v2_evw.admin2name,
eth_hazard_area_v2_evw.admin3name,
eth_hazard_area_v2_evw.ops_validation_status,
eth_hazard_area_v2_evw.im_validation_status,
eth_hazard_area_v2_evw.shape,
'HA'::text AS source_table
FROM haz_dev_evw
LEFT JOIN eth_hazard_area_v2_evw ON haz_dev_evw.dev_haz_id::text = eth_hazard_area_v2_evw.cont_id::text
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;
Map Name: Map5
Legend
All Layers and Tables
Dynamic Legend
Dynamic All Layers
Layers:
Description: spot_ha_devices: SELECT row_number() OVER (ORDER BY eth_spot_hazard_task_evw.uniquerowid)::oid AS objectid, next_globalid() AS globalid, spot_hazard_dev_evw.dev_haz_id AS report_id, spot_hazard_dev_evw.dev_cont_type AS cont_type, spot_hazard_dev_evw.eo_model, spot_hazard_dev_evw.eo_device, spot_hazard_dev_evw.eo_device_other, spot_hazard_dev_evw.dev_amount AS amount, eth_spot_hazard_task_evw.cont_id, eth_spot_hazard_task_evw.report_dt, eth_spot_hazard_task_evw.status, eth_spot_hazard_task_evw.admin1name, eth_spot_hazard_task_evw.admin2name, eth_spot_hazard_task_evw.admin3name, eth_spot_hazard_task_evw.ops_validation_status, eth_spot_hazard_task_evw.im_validation_status, eth_spot_hazard_task_evw.shape, 'Spot Task'::text AS source_table FROM spot_hazard_dev_evw LEFT JOIN eth_spot_hazard_task_evw ON spot_hazard_dev_evw.dev_haz_id::text = eth_spot_hazard_task_evw.cont_id::text WHERE eth_spot_hazard_task_evw.ops_validation_status::text = 'validated'::text AND eth_spot_hazard_task_evw.im_validation_status::text !~~ 'rejected'::text;HA_devices: SELECT row_number() OVER (ORDER BY eth_hazard_area_v2_evw.uniquerowid)::oid AS objectid, next_globalid() AS globalid, haz_dev_evw.dev_haz_id AS report_id, haz_dev_evw.dev_cont_type AS cont_type, haz_dev_evw.eo_model, haz_dev_evw.eo_device, haz_dev_evw.eo_device_other, haz_dev_evw.dev_amount AS amount, eth_hazard_area_v2_evw.cont_id, eth_hazard_area_v2_evw.report_dt, eth_hazard_area_v2_evw.status, eth_hazard_area_v2_evw.admin1name, eth_hazard_area_v2_evw.admin2name, eth_hazard_area_v2_evw.admin3name, eth_hazard_area_v2_evw.ops_validation_status, eth_hazard_area_v2_evw.im_validation_status, eth_hazard_area_v2_evw.shape, 'HA'::text AS source_table FROM haz_dev_evw LEFT JOIN eth_hazard_area_v2_evw ON haz_dev_evw.dev_haz_id::text = eth_hazard_area_v2_evw.cont_id::text 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;
Service Item Id: c5719d135b4e4fd99b5eb6a61dde1d72
Copyright Text:
Spatial Reference:
4326
(4326)
Single Fused Map Cache: false
Initial Extent:
XMin: 36.868521675218126
YMin: 10.307997603652623
XMax: 43.13272056078198
YMax: 14.9867596323475
Spatial Reference: 4326
(4326)
Full Extent:
XMin: 37.72899716300003
YMin: 10.842529236000075
XMax: 42.27224507300008
YMax: 14.452228000000048
Spatial Reference: 4326
(4326)
Units: esriDecimalDegrees
Supported Image Format Types: PNG32,PNG24,PNG,JPG,DIB,TIFF,EMF,PS,PDF,GIF,SVG,SVGZ,BMP
Document Info:
Title: Map15
Author:
Comments:
Subject:
Category:
Keywords: ETH,HA,SPOT
AntialiasingMode: Fast
TextAntialiasingMode: Force
Supports Dynamic Layers: true
MaxRecordCount: 2000
MaxImageHeight: 4096
MaxImageWidth: 4096
Supported Query Formats: JSON, geoJSON, PBF
Supports Query Data Elements: true
Min Scale: 0
Max Scale: 0
Supports Datum Transformation: true
Child Resources:
Info
Dynamic Layer
Supported Operations:
Export Map
Identify
QueryLegends
QueryDomains
Find
Return Updates