LEFT JOIN eth_hazard_area_v2_evw ON haz_dev_evw.dev_haz_id::text = eth_hazard_area_v2_evw.cont_id::text<\/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>
<\/div>",
"mapName": "Map5",
"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;",
"copyrightText": "",
"supportsDynamicLayers": true,
"layers": [
{
"id": 0,
"name": "ETH_spot_ha_dev_combined",
"parentLayerId": -1,
"defaultVisibility": true,
"subLayerIds": null,
"minScale": 0,
"maxScale": 0,
"type": "Feature Layer",
"geometryType": "esriGeometryPoint",
"supportsDynamicLegends": true
}
],
"tables": [],
"spatialReference": {
"wkid": 4326,
"latestWkid": 4326,
"xyTolerance": 8.983152841195215E-9,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -400,
"falseY": -400,
"xyUnits": 9.999999999999999E8,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
},
"singleFusedMapCache": false,
"initialExtent": {
"xmin": 36.868521675218126,
"ymin": 10.307997603652623,
"xmax": 43.13272056078198,
"ymax": 14.9867596323475,
"spatialReference": {
"wkid": 4326,
"latestWkid": 4326,
"xyTolerance": 8.983152841195215E-9,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -400,
"falseY": -400,
"xyUnits": 9.999999999999999E8,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
}
},
"fullExtent": {
"xmin": 37.72899716300003,
"ymin": 10.842529236000075,
"xmax": 42.27224507300008,
"ymax": 14.452228000000048,
"spatialReference": {
"wkid": 4326,
"latestWkid": 4326,
"xyTolerance": 8.983152841195215E-9,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -400,
"falseY": -400,
"xyUnits": 9.999999999999999E8,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
}
},
"datesInUnknownTimezone": false,
"minScale": 0,
"maxScale": 0,
"units": "esriDecimalDegrees",
"supportedImageFormatTypes": "PNG32,PNG24,PNG,JPG,DIB,TIFF,EMF,PS,PDF,GIF,SVG,SVGZ,BMP",
"documentInfo": {
"Title": "Map15",
"Author": "",
"Comments": "",
"Subject": "",
"Category": "",
"Version": "3.2.0",
"AntialiasingMode": "Fast",
"TextAntialiasingMode": "Force",
"Keywords": "ETH,HA,SPOT"
},
"supportsQueryDomains": true,
"capabilities": "Map,Query,Data",
"supportedQueryFormats": "JSON, geoJSON, PBF",
"exportTilesAllowed": false,
"referenceScale": 0.0,
"supportsDatumTransformation": true,
"archivingInfo": {"supportsHistoricMoment": false},
"supportsClipping": true,
"supportsSpatialFilter": true,
"supportsTimeRelation": true,
"supportsQueryDataElements": true,
"mapUnits": {"uwkid": 9102},
"maxRecordCount": 2000,
"maxImageHeight": 4096,
"maxImageWidth": 4096,
"supportedExtensions": "",
"serviceItemId": "c5719d135b4e4fd99b5eb6a61dde1d72"
}