View In:   ArcGIS Online Map Viewer

Name: Water Service

Display Field: tb_SL_id

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 4c5d527d9c5b48d1ac444d4a17cdc786

Copyright Text:

Default Visibility: true

MaxRecordCount: 100000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: NaN
YMin: NaN
XMax: NaN
YMax: NaN
Spatial Reference: 0  (0)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• tb_SL_address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: tb_SL_address )
• md_address_subunits ( type: esriFieldTypeString, alias: Apt/Suite, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: md_address_subunits )
• md_parcel_number ( type: esriFieldTypeString, alias: Parcel Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: md_parcel_number )
• md_subdivision ( type: esriFieldTypeString, alias: Subdivision, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: md_subdivision )
• DEQ_service_line_category ( type: esriFieldTypeString, alias: Service Line Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DEQ_service_line_category )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• water_service_inventory_id ( type: esriFieldTypeInteger, alias: water_service_inventory_id, editable: true, nullable: true, defaultValue: null, modelName: water_service_inventory_id )
• tb_SL_id ( type: esriFieldTypeString, alias: tb_SL_id, editable: true, nullable: true, length: 50, defaultValue: null, modelName: tb_SL_id )
• tb_account_number ( type: esriFieldTypeString, alias: tb_account_number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: tb_account_number )
• md_address_id ( type: esriFieldTypeInteger, alias: md_address_id, editable: true, nullable: false, defaultValue: null, modelName: md_address_id )
• md_lot ( type: esriFieldTypeInteger, alias: md_lot, editable: true, nullable: false, defaultValue: null, modelName: md_lot )
• md_block ( type: esriFieldTypeInteger, alias: md_block, editable: true, nullable: false, defaultValue: null, modelName: md_block )
• DEQ_PWS_service_line_category ( type: esriFieldTypeString, alias: DEQ_PWS_service_line_category, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DEQ_PWS_service_line_category )
• DEQ_private_service_line_category ( type: esriFieldTypeString, alias: DEQ_private_service_line_category, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DEQ_private_service_line_category )
• DEQ_service_line_ownership ( type: esriFieldTypeString, alias: DEQ_service_line_ownership, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DEQ_service_line_ownership )
• DEQ_replacement_status ( type: esriFieldTypeString, alias: DEQ_replacement_status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DEQ_replacement_status )
• DEQ_lead_components ( type: esriFieldTypeString, alias: DEQ_lead_components, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DEQ_lead_components )
• DEQ_verification_method ( type: esriFieldTypeString, alias: DEQ_verification_method, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DEQ_verification_method )
• DEQ_structure_or_service_line_type ( type: esriFieldTypeString, alias: DEQ_structure_or_service_line_type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DEQ_structure_or_service_line_type )
• DEQ_consumer_notified_if_LSL ( type: esriFieldTypeString, alias: DEQ_consumer_notified_if_LSL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DEQ_consumer_notified_if_LSL )
• DEQ_private_side_replacement_tracking ( type: esriFieldTypeString, alias: DEQ_private_side_replacement_tracking, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DEQ_private_side_replacement_tracking )
• DEQ_other_relevant_information ( type: esriFieldTypeString, alias: DEQ_other_relevant_information, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: DEQ_other_relevant_information )
• tb_meter_id ( type: esriFieldTypeString, alias: tb_meter_id, editable: true, nullable: true, length: 50, defaultValue: null, modelName: tb_meter_id )
• tb_meter_activation ( type: esriFieldTypeString, alias: tb_meter_activation, editable: true, nullable: true, length: 50, defaultValue: null, modelName: tb_meter_activation )
• tb_unit_id ( type: esriFieldTypeString, alias: tb_unit_id, editable: true, nullable: true, length: 50, defaultValue: null, modelName: tb_unit_id )
• unit_type ( type: esriFieldTypeString, alias: unit_type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: unit_type )
• gis_main_install_date ( type: esriFieldTypeString, alias: gis_main_install_date, editable: true, nullable: true, length: 50, defaultValue: null, modelName: gis_main_install_date )
• tb_service_classification ( type: esriFieldTypeString, alias: tb_service_classification, editable: true, nullable: true, length: 50, defaultValue: null, modelName: tb_service_classification )
• gis_service_line_size ( type: esriFieldTypeString, alias: gis_service_line_size, editable: true, nullable: true, length: 30, defaultValue: null, modelName: gis_service_line_size )
• gis_service_install_date ( type: esriFieldTypeString, alias: gis_service_install_date, editable: true, nullable: true, length: 50, defaultValue: null, modelName: gis_service_install_date )
• internal_notes ( type: esriFieldTypeString, alias: internal_notes, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: internal_notes )
• reporting_data_is_complete ( type: esriFieldTypeSmallInteger, alias: reporting_data_is_complete, editable: true, nullable: false, defaultValue: null, modelName: reporting_data_is_complete )
• gis_material_type ( type: esriFieldTypeString, alias: gis_material_type, editable: true, nullable: true, length: 120, defaultValue: null, modelName: gis_material_type )
• last_edit_datetime ( type: esriFieldTypeDate, alias: last_edit_datetime, editable: true, nullable: false, length: 8, defaultValue: null, modelName: last_edit_datetime )
• last_edit_worker_no ( type: esriFieldTypeInteger, alias: last_edit_worker_no, editable: true, nullable: false, defaultValue: null, modelName: last_edit_worker_no )
• active_flag ( type: esriFieldTypeSmallInteger, alias: active_flag, editable: true, nullable: false, defaultValue: null, modelName: active_flag )
• WaterSource ( type: esriFieldTypeString, alias: WaterSource, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WaterSource )
• meter_type ( type: esriFieldTypeString, alias: meter_type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: meter_type )
• mxu_port_id ( type: esriFieldTypeString, alias: mxu_port_id, editable: true, nullable: true, length: 50, defaultValue: null, modelName: mxu_port_id )
• MXU_type ( type: esriFieldTypeString, alias: MXU_type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MXU_type )
• longitude ( type: esriFieldTypeDouble, alias: longitude, editable: true, nullable: true, defaultValue: null, modelName: longitude )
• latitude ( type: esriFieldTypeDouble, alias: latitude, editable: true, nullable: true, defaultValue: null, modelName: latitude )
• PipeMaterial ( type: esriFieldTypeString, alias: PipeMaterial, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PipeMaterial )
• MXU_port_order ( type: esriFieldTypeInteger, alias: MXU_port_order, editable: true, nullable: true, defaultValue: null, modelName: MXU_port_order )

Templates:

• Name: Water Service
  Description:
  Prototype:
  PipeMaterial: null
  tb_SL_address: null
  md_address_subunits: null
  md_parcel_number: null
  md_subdivision: null
  DEQ_service_line_category: null
  water_service_inventory_id: null
  tb_SL_id: null
  tb_account_number: null
  md_address_id: 0
  md_lot: 0
  md_block: 0
  DEQ_PWS_service_line_category: null
  DEQ_private_service_line_category: null
  DEQ_service_line_ownership: null
  DEQ_replacement_status: null
  DEQ_lead_components: null
  DEQ_verification_method: null
  DEQ_structure_or_service_line_type: null
  DEQ_consumer_notified_if_LSL: null
  DEQ_private_side_replacement_tracking: null
  DEQ_other_relevant_information: null
  tb_meter_id: null
  tb_meter_activation: null
  tb_unit_id: null
  unit_type: null
  gis_main_install_date: null
  tb_service_classification: null
  gis_service_line_size: null
  gis_service_install_date: null
  internal_notes: null
  reporting_data_is_complete: 0
  gis_material_type: null
  last_edit_datetime: -2209161600000
  last_edit_worker_no: 0
  active_flag: 0
  WaterSource: null
  meter_type: null
  mxu_port_id: null
  MXU_type: null
  longitude: null
  latitude: null
  MXU_port_order: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata