Layers:

Layer: wrl_borehole_p_unhcr (0)

Name: wrl_borehole_p_unhcr

Display Field: name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Main WASH borehole database. Canada is filtered as test area.

Copyright Text:

Default Visibility: true

MaxRecordCount: 5000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: -104.99999999999994
YMin: -28.349999999999966
XMax: 92.26683618000004
YMax: 58.00000000000006
Spatial Reference: 4326  (4326)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: pump_type
Field 2: status
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: electrical_pump,active
  Label: Active electric pump
  Description: N/A
  Symbol:
  
• Value: electrical_pump,
  Label: Inactive electric pump
  Description: N/A
  Symbol:
  
• Value: electrical_pump,
  Label: Inactive electric pump
  Description: N/A
  Symbol:
  
• Value: electrical_pump,inactive
  Label: Inactive electric pump
  Description: N/A
  Symbol:
  
• Value: hand_pump,active
  Label: Active hand of foot pump
  Description: N/A
  Symbol:
  
• Value: foot_pump,active
  Label: Active hand of foot pump
  Description: N/A
  Symbol:
  
• Value: hand_pump,
  Label: Inactive/Unknown hand or foot pump
  Description: N/A
  Symbol:
  
• Value: hand_pump,
  Label: Inactive/Unknown hand or foot pump
  Description: N/A
  Symbol:
  
• Value: foot_pump,inactive
  Label: Inactive/Unknown hand or foot pump
  Description: N/A
  Symbol:
  
• Value: hand_pump,inactive
  Label: Inactive/Unknown hand or foot pump
  Description: N/A
  Symbol:
  
• Value: ,inactive
  Label: Missing status or type
  Description: N/A
  Symbol:
  
• Value: ,inactive
  Label: Missing status or type
  Description: N/A
  Symbol:
  
• Value: ,
  Label: Missing status or type
  Description: N/A
  Symbol:
  
• Value: ,active
  Label: Missing status or type
  Description: N/A
  Symbol:
  
• Value: ,active
  Label: Missing status or type
  Description: N/A
  Symbol:
  
• Value: ,active
  Label: Missing status or type
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: objectid )
• iso3 ( type: esriFieldTypeString, alias: Iso3, length: 3 )
• country ( type: esriFieldTypeString, alias: Country, length: 100 )
• camp_code ( type: esriFieldTypeString, alias: Camp, length: 50 )
• camp_name ( type: esriFieldTypeString, alias: Camp name, length: 100 )
• name ( type: esriFieldTypeString, alias: Borehole name, length: 50 )
• pcode ( type: esriFieldTypeString, alias: Automatic Borehole ID, length: 50 )
• last_update_date ( type: esriFieldTypeDate, alias: System update date, length: 8 )
• lat ( type: esriFieldTypeDouble, alias: Latitude )
• lon ( type: esriFieldTypeDouble, alias: Longitude )
• ele ( type: esriFieldTypeDouble, alias: Elevation )
• status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [active: Active] , [inactive: Inactive] )
• drilling_date ( type: esriFieldTypeDate, alias: Drilling date, length: 8 )
• depth ( type: esriFieldTypeDouble, alias: Depth )
• static_water_level ( type: esriFieldTypeDouble, alias: Static water level )
• dynamic_water_level ( type: esriFieldTypeDouble, alias: Dynamic water level )
• pump_type ( type: esriFieldTypeString, alias: Type of pump, length: 50 , Coded Values: [hand_pump: Hand pump] , [foot_pump: Foot pump] , [electrical_pump: Electrical pump] )
• pump_brand_model ( type: esriFieldTypeString, alias: Pump brand and model, length: 100 )
• pump_depth ( type: esriFieldTypeDouble, alias: Pump depth )
• pump_motor_power ( type: esriFieldTypeDouble, alias: Pump motor power )
• energy_type ( type: esriFieldTypeString, alias: Type of energy relied on, length: 50 , Coded Values: [generator: Generator] , [grid: Grid] , [grid_generator: Grid and generator backup] , ...2 more... )
• generator_brand_model ( type: esriFieldTypeString, alias: Generator brand and model, length: 100 )
• second_generator_brand_model ( type: esriFieldTypeString, alias: Second generator brand and model, length: 100 )
• generator_capacity ( type: esriFieldTypeDouble, alias: Generator capacity )
• second_generator_capacity ( type: esriFieldTypeDouble, alias: Second generator capacity )
• casing_diameter ( type: esriFieldTypeDouble, alias: Casing diameter )
• casing_material ( type: esriFieldTypeString, alias: Casing material, length: 50 , Coded Values: [pvc: PVC] , [steel: Steel] , [concrete: Concrete] )
• first_screened_area_from ( type: esriFieldTypeDouble, alias: First screened area from )
• first_screened_area_to ( type: esriFieldTypeDouble, alias: First screened area to )
• second_screened_area_from ( type: esriFieldTypeDouble, alias: Second screened area from )
• second_screened_area_to ( type: esriFieldTypeDouble, alias: Second screened area to )
• third_screened_area_from ( type: esriFieldTypeDouble, alias: Third screened area from )
• third_screened_area_to ( type: esriFieldTypeDouble, alias: Third screened area to )
• aquifer_type ( type: esriFieldTypeString, alias: Aquifer type, length: 50 , Coded Values: [fractured_rock: Fractured rock] , [porous: Porous] , [karstic: Karstic] )
• safe_yield ( type: esriFieldTypeDouble, alias: Driller's yield )
• daily_pumping_time ( type: esriFieldTypeDouble, alias: Daily pumping time )
• water_quality_control_date ( type: esriFieldTypeDate, alias: Date of water quality control, length: 8 )
• conductivity ( type: esriFieldTypeDouble, alias: Conductivity )
• ph ( type: esriFieldTypeDouble, alias: pH )
• turbidity ( type: esriFieldTypeDouble, alias: Turbidity )
• ammonia_concentration ( type: esriFieldTypeDouble, alias: Ammonia concentration )
• arsenic_concentration ( type: esriFieldTypeDouble, alias: Arsenic concentration )
• free_chlorine_concentration ( type: esriFieldTypeDouble, alias: Free chlorine concentration )
• total_chlorine_concentration ( type: esriFieldTypeDouble, alias: Total chlorine concentration )
• fluoride_concentration ( type: esriFieldTypeDouble, alias: Fluoride concentration )
• nitrate_concentration ( type: esriFieldTypeDouble, alias: Nitrate concentration )
• nitrite_concentration ( type: esriFieldTypeDouble, alias: Nitrite concentration )
• attachement1 ( type: esriFieldTypeString, alias: attachement1, length: 500 )
• attachement2 ( type: esriFieldTypeString, alias: Attachement 2, length: 500 )
• attachement3 ( type: esriFieldTypeString, alias: Attachement 3, length: 500 )
• attachement4 ( type: esriFieldTypeString, alias: Attachement 4, length: 500 )
• comments ( type: esriFieldTypeString, alias: Comments, length: 500 )
• globalid ( type: esriFieldTypeGlobalID, alias: globalid, length: 38 )
• local_id ( type: esriFieldTypeString, alias: Local Borehole ID, length: 50 )
• last_editor ( type: esriFieldTypeString, alias: Last editor, length: 50 )
• manual_update_date ( type: esriFieldTypeDate, alias: Manual update date, length: 8 )
• attachment_description ( type: esriFieldTypeString, alias: Attachment description, length: 500 )
• drilling_date_unknown ( type: esriFieldTypeString, alias: Unknown drilling date, length: 10 )
• ecoli ( type: esriFieldTypeString, alias: ecoli, length: 20 , Coded Values: [absent: Absent (0cfu/100ml)] , [0 to 10: Less than 10 cfu/100ml] , [10 to 100: Between 10 and 100 cfu/100ml] , ...1 more... )
• screened_areas ( type: esriFieldTypeString, alias: Screened areas, length: 200 )
• open_hole_start ( type: esriFieldTypeDouble, alias: Start of open hole )
• driller_yield ( type: esriFieldTypeDouble, alias: Drillers yield )
• dwl_at_driller_yield ( type: esriFieldTypeDouble, alias: DWL at drillers yield )
• pump_test_dwl_yield ( type: esriFieldTypeString, alias: Pumping tests (DWL/yield), length: 200 )
• solar_pump_test_quality ( type: esriFieldTypeString, alias: Pump test quality from Solarization, length: 100 )
• solar_safe_yield ( type: esriFieldTypeDouble, alias: Safe yield from Solarization )
• transmissivity_constrate_test ( type: esriFieldTypeDouble, alias: Transmissivity from constant rate pumping test )
• solar_potential ( type: esriFieldTypeDouble, alias: Solarization potential )
• solar_investment_estimation ( type: esriFieldTypeDouble, alias: Solarization investment estimation )
• solar_maintenance_estimation ( type: esriFieldTypeString, alias: Solarization maintenance estimation, length: 100 )
• solar_gross_payback ( type: esriFieldTypeDouble, alias: Solarization gross payback )
• solar_co2_avoided ( type: esriFieldTypeDouble, alias: Solarization amount of CO2 avoided )
• last_update_tool ( type: esriFieldTypeString, alias: Tool used for last update, length: 50 )
• dwl_warnings ( type: esriFieldTypeString, alias: dwl_warnings, length: 200 )
• creation_date ( type: esriFieldTypeDate, alias: creation_date, length: 8 )
• hidden_borehole ( type: esriFieldTypeString, alias: Hidden borehole, length: 3 )
• shape ( type: esriFieldTypeGeometry, alias: shape )
• camera_inspection ( type: esriFieldTypeString, alias: Camera Inspection, length: 100 )

Layer: wrl_borehole_p_unhcr_archive (1)

Name: wrl_borehole_p_unhcr_archive

Display Field: name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 5000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: -110.99999999999994
YMin: -21.071549999999945
XMax: 87.69095000000004
YMax: 86.00000000000006
Spatial Reference: 4326  (4326)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 32, 128, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• iso3 ( type: esriFieldTypeString, alias: Iso3, length: 3 )
• country ( type: esriFieldTypeString, alias: Country, length: 100 )
• camp_code ( type: esriFieldTypeString, alias: Camp, length: 50 )
• camp_name ( type: esriFieldTypeString, alias: Camp name, length: 100 )
• name ( type: esriFieldTypeString, alias: Borehole name, length: 50 )
• pcode ( type: esriFieldTypeString, alias: Borehole ID, length: 50 )
• last_update_date ( type: esriFieldTypeDate, alias: Last update date, length: 8 )
• lat ( type: esriFieldTypeDouble, alias: Latitude )
• lon ( type: esriFieldTypeDouble, alias: Longitude )
• ele ( type: esriFieldTypeDouble, alias: Elevation )
• status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [active: Active] , [inactive: Inactive] )
• drilling_date ( type: esriFieldTypeDate, alias: Drilling date, length: 8 )
• depth ( type: esriFieldTypeDouble, alias: Depth )
• static_water_level ( type: esriFieldTypeDouble, alias: Static water level )
• dynamic_water_level ( type: esriFieldTypeDouble, alias: Dynamic water level )
• pump_type ( type: esriFieldTypeString, alias: Type of pump, length: 50 , Coded Values: [hand_pump: Hand pump] , [foot_pump: Foot pump] , [electrical_pump: Electrical pump] )
• pump_brand_model ( type: esriFieldTypeString, alias: Pump brand and model, length: 100 )
• pump_depth ( type: esriFieldTypeDouble, alias: Pump depth )
• pump_motor_power ( type: esriFieldTypeDouble, alias: Pump motor power )
• energy_type ( type: esriFieldTypeString, alias: Type of energy relied on, length: 50 , Coded Values: [generator: Generator] , [grid: Grid] , [grid_generator: Grid and generator backup] , ...2 more... )
• generator_brand_model ( type: esriFieldTypeString, alias: Generator brand and model, length: 100 )
• second_generator_brand_model ( type: esriFieldTypeString, alias: Second generator brand and model, length: 100 )
• generator_capacity ( type: esriFieldTypeDouble, alias: Generator capacity )
• second_generator_capacity ( type: esriFieldTypeDouble, alias: Second generator capacity )
• casing_diameter ( type: esriFieldTypeDouble, alias: Casing diameter )
• casing_material ( type: esriFieldTypeString, alias: Casing material, length: 50 , Coded Values: [pvc: PVC] , [steel: Steel] , [concrete: Concrete] )
• first_screened_area_from ( type: esriFieldTypeDouble, alias: First screened area from )
• first_screened_area_to ( type: esriFieldTypeDouble, alias: First screened area to )
• second_screened_area_from ( type: esriFieldTypeDouble, alias: Second screened area from )
• second_screened_area_to ( type: esriFieldTypeDouble, alias: Second screened area to )
• third_screened_area_from ( type: esriFieldTypeDouble, alias: Third screened area from )
• third_screened_area_to ( type: esriFieldTypeDouble, alias: Third screened area to )
• aquifer_type ( type: esriFieldTypeString, alias: Aquifer type, length: 50 , Coded Values: [fractured_rock: Fractured rock] , [porous: Porous] , [karstic: Karstic] )
• safe_yield ( type: esriFieldTypeDouble, alias: Safe yield )
• daily_pumping_time ( type: esriFieldTypeDouble, alias: Daily pumping time )
• water_quality_control_date ( type: esriFieldTypeDate, alias: Date of water quality control, length: 8 )
• conductivity ( type: esriFieldTypeDouble, alias: Conductivity )
• ph ( type: esriFieldTypeDouble, alias: pH )
• turbidity ( type: esriFieldTypeDouble, alias: Turbidity )
• ammonia_concentration ( type: esriFieldTypeDouble, alias: Ammonia concentration )
• arsenic_concentration ( type: esriFieldTypeDouble, alias: Arsenic concentration )
• free_chlorine_concentration ( type: esriFieldTypeDouble, alias: Free chlorine concentration )
• total_chlorine_concentration ( type: esriFieldTypeDouble, alias: Total chlorine concentration )
• fluoride_concentration ( type: esriFieldTypeDouble, alias: Fluoride concentration )
• nitrate_concentration ( type: esriFieldTypeDouble, alias: Nitrate concentration )
• nitrite_concentration ( type: esriFieldTypeDouble, alias: Nitrite concentration )
• attachement1 ( type: esriFieldTypeString, alias: attachement1, length: 500 )
• attachement2 ( type: esriFieldTypeString, alias: Attachement 2, length: 500 )
• attachement3 ( type: esriFieldTypeString, alias: Attachement 3, length: 500 )
• attachement4 ( type: esriFieldTypeString, alias: Attachement 4, length: 500 )
• comments ( type: esriFieldTypeString, alias: Comments, length: 500 )
• globalid ( type: esriFieldTypeGlobalID, alias: globalid, length: 38 )
• archive_action ( type: esriFieldTypeString, alias: archive_action, length: 20 )
• archive_date ( type: esriFieldTypeDate, alias: archive_date, length: 8 )
• archive_editby ( type: esriFieldTypeString, alias: archive, length: 50 )
• local_id ( type: esriFieldTypeString, alias: Local Borehole ID, length: 50 )
• last_editor ( type: esriFieldTypeString, alias: Last editor, length: 50 )
• manual_update_date ( type: esriFieldTypeDate, alias: manual_update_date, length: 8 )
• attachment_description ( type: esriFieldTypeString, alias: attachment_description, length: 500 )
• drilling_date_unknown ( type: esriFieldTypeString, alias: Unknown drilling date, length: 10 )
• ecoli ( type: esriFieldTypeString, alias: ecoli, length: 20 , Coded Values: [absent: Absent (0cfu/100ml)] , [0 to 10: Less than 10 cfu/100ml] , [10 to 100: Between 10 and 100 cfu/100ml] , ...1 more... )
• screened_areas ( type: esriFieldTypeString, alias: Screened areas, length: 200 )
• open_hole_start ( type: esriFieldTypeDouble, alias: Start of open hole )
• driller_yield ( type: esriFieldTypeDouble, alias: Drillers yield )
• dwl_at_driller_yield ( type: esriFieldTypeDouble, alias: DWL at drillers yield )
• pump_test_dwl_yield ( type: esriFieldTypeString, alias: Pumping tests (DWL/yield), length: 200 )
• solar_pump_test_quality ( type: esriFieldTypeString, alias: Pump test quality from Solarization, length: 100 )
• solar_safe_yield ( type: esriFieldTypeDouble, alias: Safe yield from Solarization )
• transmissivity_constrate_test ( type: esriFieldTypeDouble, alias: Transmissivity from constant rate pumping test )
• solar_potential ( type: esriFieldTypeDouble, alias: Solarization potential )
• solar_investment_estimation ( type: esriFieldTypeDouble, alias: Solarization investment estimation )
• solar_maintenance_estimation ( type: esriFieldTypeString, alias: Solarization maintenance estimation, length: 100 )
• solar_gross_payback ( type: esriFieldTypeDouble, alias: Solarization gross payback )
• solar_co2_avoided ( type: esriFieldTypeDouble, alias: Solarization amount of CO2 avoided )
• last_update_tool ( type: esriFieldTypeString, alias: Tool used for last update, length: 50 )
• dwl_warnings ( type: esriFieldTypeString, alias: dwl_warnings, length: 200 )
• creation_date ( type: esriFieldTypeDate, alias: creation_date, length: 8 )
• hidden_borehole ( type: esriFieldTypeString, alias: Hidden borehole, length: 3 )
• archive_tool ( type: esriFieldTypeString, alias: archive_tool, length: 50 )
• shape ( type: esriFieldTypeGeometry, alias: shape )
• camera_inspection ( type: esriFieldTypeString, alias: Camera inspection, length: 100 )

Tables:

Table: sector.sector_wash.wrl_borehole_p_unhcr__ATTACH (2)

Name: sector.sector_wash.wrl_borehole_p_unhcr__ATTACH

Display Field: att_name

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 5000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• attachmentid ( type: esriFieldTypeOID, alias: attachmentid )
• rel_globalid ( type: esriFieldTypeGUID, alias: rel_globalid, length: 38 )
• content_type ( type: esriFieldTypeString, alias: content_type, length: 150 )
• att_name ( type: esriFieldTypeString, alias: att_name, length: 250 )
• data_size ( type: esriFieldTypeInteger, alias: data_size )
• data ( type: esriFieldTypeBlob, alias: data )
• globalid ( type: esriFieldTypeGlobalID, alias: globalid, length: 38 )

Table: sector.sector_wash.wrl_borehole_p_unhcr_attachment_attributes (3)

Name: sector.sector_wash.wrl_borehole_p_unhcr_attachment_attributes

Display Field: attachmentid

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 5000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• attachmentid ( type: esriFieldTypeInteger, alias: attachmentid )
• globalid ( type: esriFieldTypeGlobalID, alias: globalid, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• doc_type ( type: esriFieldTypeString, alias: doc_type, length: 50 )