ArcGIS REST Services Directory Login
JSON | SOAP

Ethiopia/ETH_HA_SPOT_Devices_merge (MapServer)

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: Full Extent: Units: esriDecimalDegrees

Supported Image Format Types: PNG32,PNG24,PNG,JPG,DIB,TIFF,EMF,PS,PDF,GIF,SVG,SVGZ,BMP

Document Info: 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