Name: Ky_WRIS_WaterSystems_StatusItems

Display Field: user_name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 3f03876943d0407b9fe95ec274b90ed3

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

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: false
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: ObjectID )
• pwsid ( modelName: pwsid, nullable: true, editable: true, defaultValue: null, length: 16, alias: PWSID, type: esriFieldTypeString )
• system_status ( modelName: system_status, nullable: true, editable: true, defaultValue: null, length: 32, alias: System_Status, type: esriFieldTypeString )
• status_comments ( modelName: status_comments, nullable: true, editable: true, defaultValue: null, length: 2048, alias: Status_Comments, type: esriFieldTypeString )
• connections_out ( modelName: connections_out, nullable: true, editable: true, defaultValue: null, alias: Connections_Out, type: esriFieldTypeSmallInteger )
• connections_out_count ( modelName: connections_out_count, nullable: true, editable: true, defaultValue: null, alias: Connections_Out_Count, type: esriFieldTypeInteger )
• connections_out_hospital ( modelName: connections_out_hospital, nullable: true, editable: true, defaultValue: null, alias: Connections_Out_Hospital, type: esriFieldTypeSmallInteger )
• connections_out_nursinghome ( modelName: connections_out_nursinghome, nullable: true, editable: true, defaultValue: null, alias: Connections_Out_NursingHome, type: esriFieldTypeSmallInteger )
• connections_out_healthcarefac ( modelName: connections_out_healthcarefac, nullable: true, editable: true, defaultValue: null, alias: Connections_Out_HealthCareFac, type: esriFieldTypeSmallInteger )
• connections_out_school ( modelName: connections_out_school, nullable: true, editable: true, defaultValue: null, alias: Connections_Out_School, type: esriFieldTypeSmallInteger )
• connections_out_other ( modelName: connections_out_other, nullable: true, editable: true, defaultValue: null, alias: Connections_Out_Other, type: esriFieldTypeSmallInteger )
• connections_out_othertype ( modelName: connections_out_othertype, nullable: true, editable: true, defaultValue: null, length: 128, alias: Connections_Out_OtherType, type: esriFieldTypeString )
• connections_lowpressure ( modelName: connections_lowpressure, nullable: true, editable: true, defaultValue: null, alias: Connections_LowPressure, type: esriFieldTypeSmallInteger )
• connections_lowpressure_count ( modelName: connections_lowpressure_count, nullable: true, editable: true, defaultValue: null, alias: Connections_LowPressure_Count, type: esriFieldTypeInteger )
• connections_lowpressure_hospital ( modelName: connections_lowpressure_hospital, nullable: true, editable: true, defaultValue: null, alias: Connections_LowPressure_Hospital, type: esriFieldTypeSmallInteger )
• connections_lowpressure_nursinghome ( modelName: connections_lowpressure_nursinghome, nullable: true, editable: true, defaultValue: null, alias: Connections_LowPressure_NursingHome, type: esriFieldTypeSmallInteger )
• connections_lowpressure_healthcarefac ( modelName: connections_lowpressure_healthcarefac, nullable: true, editable: true, defaultValue: null, alias: Connections_LowPressure_HealthCareFac, type: esriFieldTypeSmallInteger )
• connections_lowpressure_school ( modelName: connections_lowpressure_school, nullable: true, editable: true, defaultValue: null, alias: Connections_LowPressure_School, type: esriFieldTypeSmallInteger )
• connections_lowpressure_other ( modelName: connections_lowpressure_other, nullable: true, editable: true, defaultValue: null, alias: Connections_LowPressure_Other, type: esriFieldTypeSmallInteger )
• connections_lowpressure_othertype ( modelName: connections_lowpressure_othertype, nullable: true, editable: true, defaultValue: null, length: 128, alias: Connections_LowPressure_OtherType, type: esriFieldTypeString )
• connections_under_bwa ( modelName: connections_under_bwa, nullable: true, editable: true, defaultValue: null, alias: Connections_Under_BWA, type: esriFieldTypeSmallInteger )
• connections_under_bwa_count ( modelName: connections_under_bwa_count, nullable: true, editable: true, defaultValue: null, alias: Connections_Under_BWA_Count, type: esriFieldTypeInteger )
• connections_under_bwa_hospital ( modelName: connections_under_bwa_hospital, nullable: true, editable: true, defaultValue: null, alias: Connections_Under_BWA_Hospital, type: esriFieldTypeSmallInteger )
• connections_under_bwa_nursinghome ( modelName: connections_under_bwa_nursinghome, nullable: true, editable: true, defaultValue: null, alias: Connections_Under_BWA_NursingHome, type: esriFieldTypeSmallInteger )
• connections_under_bwa_healthcarefac ( modelName: connections_under_bwa_healthcarefac, nullable: true, editable: true, defaultValue: null, alias: Connections_Under_BWA_HealthCareFac, type: esriFieldTypeSmallInteger )
• connections_under_bwa_school ( modelName: connections_under_bwa_school, nullable: true, editable: true, defaultValue: null, alias: Connections_Under_BWA_School, type: esriFieldTypeSmallInteger )
• connections_under_bwa_other ( modelName: connections_under_bwa_other, nullable: true, editable: true, defaultValue: null, alias: Connections_Under_BWA_Other, type: esriFieldTypeSmallInteger )
• connections_under_bwa_othertype ( modelName: connections_under_bwa_othertype, nullable: true, editable: true, defaultValue: null, length: 128, alias: Connections_Under_BWA_OtherType, type: esriFieldTypeString )
• current_days_of_storage ( modelName: current_days_of_storage, nullable: true, editable: true, defaultValue: null, alias: Current_Days_of_Storage, type: esriFieldTypeDouble )
• conservation_implemented ( modelName: conservation_implemented, nullable: true, editable: true, defaultValue: null, alias: Conservation_Implemented, type: esriFieldTypeSmallInteger )
• can_purchase_water ( modelName: can_purchase_water, nullable: true, editable: true, defaultValue: null, alias: Can_Purchase_Water, type: esriFieldTypeSmallInteger )
• can_purchase_water_from ( modelName: can_purchase_water_from, nullable: true, editable: true, defaultValue: null, length: 2048, alias: Can_Purchase_Water_From, type: esriFieldTypeString )
• bottled_water_requested ( modelName: bottled_water_requested, nullable: true, editable: true, defaultValue: null, alias: Bottled_Water_Requested, type: esriFieldTypeSmallInteger )
• connections_needing_bottled_water ( modelName: connections_needing_bottled_water, nullable: true, editable: true, defaultValue: null, alias: Connections_Needing_Bottled_Water, type: esriFieldTypeInteger )
• power_disrupted ( modelName: power_disrupted, nullable: true, editable: true, defaultValue: null, alias: Power_Disrupted, type: esriFieldTypeSmallInteger )
• plant_power_disrupted ( modelName: plant_power_disrupted, nullable: true, editable: true, defaultValue: null, alias: Plant_Power_Disrupted, type: esriFieldTypeSmallInteger )
• pump_station_power_disrupted ( modelName: pump_station_power_disrupted, nullable: true, editable: true, defaultValue: null, alias: Pump_Station_Power_Disrupted, type: esriFieldTypeSmallInteger )
• pump_stations_without_power ( modelName: pump_stations_without_power, nullable: true, editable: true, defaultValue: null, length: 2048, alias: Pump_Stations_Without_Power, type: esriFieldTypeString )
• generators_needed ( modelName: generators_needed, nullable: true, editable: true, defaultValue: null, alias: Generators_Needed, type: esriFieldTypeSmallInteger )
• generators_needed_details ( modelName: generators_needed_details, nullable: true, editable: true, defaultValue: null, length: 2048, alias: Generators_Needed_Details, type: esriFieldTypeString )
• estimated_time_power_restored ( modelName: estimated_time_power_restored, nullable: true, editable: true, defaultValue: null, length: 256, alias: Estimated_Time_Power_Restored, type: esriFieldTypeString )
• intake_pumps_not_operational ( modelName: intake_pumps_not_operational, nullable: true, editable: true, defaultValue: null, alias: Intake_Pumps_Not_Operational, type: esriFieldTypeSmallInteger )
• intake_pumps_not_operational_reason ( modelName: intake_pumps_not_operational_reason, nullable: true, editable: true, defaultValue: null, length: 2048, alias: Intake_Pumps_Not_Operational_Reason, type: esriFieldTypeString )
• estimated_time_intake_pump_repairs ( modelName: estimated_time_intake_pump_repairs, nullable: true, editable: true, defaultValue: null, length: 256, alias: Estimated_Time_Intake_Pump_Repairs, type: esriFieldTypeString )
• chemical_supply_not_adequate ( modelName: chemical_supply_not_adequate, nullable: true, editable: true, defaultValue: null, alias: Chemical_Supply_Not_Adequate, type: esriFieldTypeSmallInteger )
• chemical_supply_needs ( modelName: chemical_supply_needs, nullable: true, editable: true, defaultValue: null, length: 2048, alias: Chemical_Supply_Needs, type: esriFieldTypeString )
• estimated_time_of_resolution ( modelName: estimated_time_of_resolution, nullable: true, editable: true, defaultValue: null, length: 256, alias: Estimated_Time_of_Resolution, type: esriFieldTypeString )
• user_name ( modelName: user_name, nullable: true, editable: true, defaultValue: null, length: 64, alias: User_Name, type: esriFieldTypeString )
• user_ip_address ( modelName: user_ip_address, nullable: true, editable: true, defaultValue: null, length: 16, alias: User_IP_Address, type: esriFieldTypeString )
• as_of_date ( modelName: as_of_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: As_of_Date, type: esriFieldTypeDate )
• last_updated ( modelName: last_updated, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Last_Updated, type: esriFieldTypeDate )

Templates:

• Name: Ky_WRIS_WaterSystems_StatusItems
  Description:
  Prototype:
  connections_needing_bottled_water: null
  connections_out_hospital: null
  current_days_of_storage: null
  pwsid: null
  intake_pumps_not_operational: null
  pump_stations_without_power: null
  generators_needed: null
  connections_lowpressure: null
  conservation_implemented: null
  status_comments: null
  connections_out_school: null
  user_ip_address: null
  plant_power_disrupted: null
  intake_pumps_not_operational_reason: null
  bottled_water_requested: null
  last_updated: null
  connections_out_count: null
  chemical_supply_not_adequate: null
  connections_out_nursinghome: null
  connections_out_healthcarefac: null
  can_purchase_water_from: null
  connections_under_bwa_hospital: null
  connections_lowpressure_other: null
  connections_lowpressure_healthcarefac: null
  connections_under_bwa: null
  estimated_time_power_restored: null
  connections_lowpressure_othertype: null
  pump_station_power_disrupted: null
  user_name: null
  can_purchase_water: null
  estimated_time_intake_pump_repairs: null
  connections_out: null
  power_disrupted: null
  connections_under_bwa_healthcarefac: null
  connections_under_bwa_nursinghome: null
  connections_lowpressure_school: null
  connections_under_bwa_other: null
  estimated_time_of_resolution: null
  connections_under_bwa_school: null
  connections_under_bwa_count: null
  as_of_date: null
  connections_under_bwa_othertype: null
  connections_out_othertype: null
  connections_lowpressure_hospital: null
  chemical_supply_needs: null
  generators_needed_details: null
  system_status: null
  connections_out_other: null
  connections_lowpressure_nursinghome: null
  connections_lowpressure_count: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Extract

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata