View In:   ArcGIS Online Map Viewer

Parent Layer: COB Water System

Name: Water Service Connections

Display Field: METERID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 6000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 18100

Max Scale: 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: -2.207234501838684E-5
YMin: 7.236003875732422E-5
XMax: 1431295.7453203462
YMax: 311615.49691886455
Spatial Reference: 102697  (102697)

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:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• ACCOUNTID ( type: esriFieldTypeString, alias: Account Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ACCOUNTID )
• SERVICETYPE ( type: esriFieldTypeString, alias: Service Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SERVICETYPE , Coded Values: [Domestic: Domestic] , [Commercial: Commercial] , [Industrial: Industrial] , ...11 more... )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• CRITICAL ( type: esriFieldTypeSmallInteger, alias: CriticalCustomer, editable: true, nullable: true, defaultValue: 0, modelName: CRITICAL , Coded Values: [0: False] , [1: True] )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...7 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...18 more... )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• METERID ( type: esriFieldTypeString, alias: Meter ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: METERID )
• METER_SIZE ( type: esriFieldTypeDouble, alias: Meter Size, editable: true, nullable: true, defaultValue: null, modelName: METER_SIZE , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...25 more... )
• SETTER ( type: esriFieldTypeDouble, alias: Setter Size, editable: true, nullable: true, defaultValue: null, modelName: SETTER , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...25 more... )
• SETTER_TYPE ( type: esriFieldTypeString, alias: Setter Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SETTER_TYPE , Coded Values: [Single Check: Single Check] , [Dual Check: Dual Check] )
• ANGLE_STOP_TYPE ( type: esriFieldTypeString, alias: Angle Stop Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ANGLE_STOP_TYPE , Coded Values: [Lock Ring: Lock Ring] , [Straight Stop: Straight Stop] , [Lug: Lug] , ...1 more... )
• ANGLE_STOP_SIZE ( type: esriFieldTypeDouble, alias: Angle Stop Size, editable: true, nullable: true, defaultValue: null, modelName: ANGLE_STOP_SIZE , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...25 more... )
• SHUTOFF_VLV_LOC ( type: esriFieldTypeString, alias: Shutoff Valve Location, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SHUTOFF_VLV_LOC , Coded Values: [Inside Pit: Inside Pit] , [Outside Pit: Outside Pit] )
• SHUTOFF_VLV_TYP ( type: esriFieldTypeString, alias: Shutoff Valve Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SHUTOFF_VLV_TYP , Coded Values: [Ball: Ball] , [Wheel: Wheel] , [Curb Stop: Curb Stop] )
• SHUTOFF_VLV_SIZ ( type: esriFieldTypeDouble, alias: SHUTOFF_VLV_SIZ, editable: true, nullable: true, defaultValue: null, modelName: SHUTOFF_VLV_SIZ , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...25 more... )
• ANTENNA ( type: esriFieldTypeString, alias: Antenna (Yes/No), editable: true, nullable: true, length: 25, defaultValue: null, modelName: ANTENNA , Coded Values: [Yes: Yes] , [No: No] )
• METER_BRAND ( type: esriFieldTypeString, alias: Meter Brand, editable: true, nullable: true, length: 50, defaultValue: null, modelName: METER_BRAND , Coded Values: [Hersey: Hersey] , [Metron-Farnier: Metron-Farnier] , [Sensus: Sensus] , ...4 more... )
• VAULT_PIT ( type: esriFieldTypeString, alias: Vault or Pit, editable: true, nullable: true, length: 25, defaultValue: null, modelName: VAULT_PIT , Coded Values: [Vault: Vault] , [Pit: Pit] )
• VAULT_PIT_MAT ( type: esriFieldTypeString, alias: Vault or Pit Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: VAULT_PIT_MAT , Coded Values: [Concrete: Concrete] , [PVC: PVC] , [Clay Tile: Clay Tile] , ...1 more... )
• TRACE_WIRE ( type: esriFieldTypeString, alias: Trace Wire (Yes/No), editable: true, nullable: true, length: 25, defaultValue: null, modelName: TRACE_WIRE , Coded Values: [Yes: Yes] , [No: No] )
• LID_TYPE ( type: esriFieldTypeString, alias: Lid Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LID_TYPE , Coded Values: [Door: Door] , [Grate: Grate] , [Cover: Cover] , ...7 more... )
• SAMPLING_STA ( type: esriFieldTypeString, alias: Sampling Station (Yes/No), editable: true, nullable: true, length: 25, defaultValue: null, modelName: SAMPLING_STA , Coded Values: [Yes: Yes] , [No: No] )
• ADDRESS ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 250, defaultValue: null, modelName: ADDRESS )
• UNIT ( type: esriFieldTypeString, alias: Address Unit or Suite, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UNIT )
• PRESSUREZN ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PRESSUREZN )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• YEAR_INSTALLED ( type: esriFieldTypeString, alias: Year Installed, editable: true, nullable: true, length: 10, defaultValue: null, modelName: YEAR_INSTALLED )
• MODEL ( type: esriFieldTypeString, alias: Meter Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MODEL )
• YEAR_REPLACE ( type: esriFieldTypeString, alias: Year Replace, editable: true, nullable: true, length: 10, defaultValue: null, modelName: YEAR_REPLACED )
• METER_CUST_TYPE ( type: esriFieldTypeString, alias: Meter Customer Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: METER_CUST_TYPE , Coded Values: [DOM: Domestic] , [IRR: Irrigation] , [COM: Commercial] , ...1 more... )
• LATITUDE ( type: esriFieldTypeString, alias: Latitude, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LATITUDE )
• LONGITUDE ( type: esriFieldTypeString, alias: Longitude, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LONGITUDE )
• COMMENT ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 450, defaultValue: null, modelName: COMMENT )
• PIT_SIZE ( type: esriFieldTypeSmallInteger, alias: Pit Size in Inches, editable: true, nullable: true, defaultValue: null, modelName: PIT_SIZE , Coded Values: [18: 18"] , [24: 24"] )
• VAULT_SIZE ( type: esriFieldTypeString, alias: Vault Size, editable: true, nullable: true, length: 25, defaultValue: null, modelName: VAULT_SIZE , Coded Values: [3' x 5': 3' x 5'] , [4' x 5': 4' x 5'] , [4' dia: 4' Diameter] , ...1 more... )
• DEPTH ( type: esriFieldTypeString, alias: Depth of Meter, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DEPTH , Coded Values: [12: 12] , [18: 18] , [24: 24] , ...4 more... )
• SERVICE_MATERIAL ( type: esriFieldTypeString, alias: Service Material, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SERVICE_MATERIAL , Coded Values: [PVC: PVC] , [CTS: CTS] , [Copper: Copper] , ...16 more... )
• CUSTOMER_SERVICE ( type: esriFieldTypeString, alias: Customer Service, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CUSTOMER_SERVICE , Coded Values: [PVC: PVC] , [CTS: CTS] , [Copper: Copper] , ...16 more... )
• CITYLEAD ( type: esriFieldTypeString, alias: City Lead, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CITYLEAD , Coded Values: [Confirmed Lead: Confirmed Lead] , [Non-Lead: Non-Lead] , [Potentially Lead: Potentially Lead] , ...1 more... )
• CUSTOMERLEAD ( type: esriFieldTypeString, alias: Customer Lead, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CUSTOMERLEAD , Coded Values: [Confirmed Lead: Confirmed Lead] , [Non-Lead: Non-Lead] , [Potentially Lead: Potentially Lead] , ...1 more... )
• MTRIDREVIEWFLAG ( type: esriFieldTypeString, alias: Meter ID Review Flag, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MTRIDREVIEWFLAG , Coded Values: [Yes: Yes] , [No: No] )
• INTERIORPLUMB ( type: esriFieldTypeString, alias: Interior plumbing, editable: true, nullable: true, length: 100, defaultValue: null, modelName: INTERIORPLUMB , Coded Values: [Lead: Lead] , [Galvanized: Galvanized] , [Non-Lead-Copper: Non-Lead-Copper] , ...5 more... )

Templates:

• Name: Water Service Connections
  Description:
  Prototype:
  OWNEDBY: 1
  CRITICAL: 0
  ENABLED: 1
  ACTIVEFLAG: 1
  MAINTBY: 1
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Extract

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

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