View In:   ArcGIS Online Map Viewer

Name: Meter Pits and Curb Stops

Display Field: ACCOUNTID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

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: 1523885.067741707
YMin: 524687.2976408452
XMax: 1717866.907090366
YMax: 712687.5255919397
Spatial Reference: 102722  (3734)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: ConnectionType
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label: Missing "Connection Type" Attribute
UniqueValueInfos:
• Value: CS
  Label: Curb Stop
  Description: N/A
  Symbol:
  
• Value: MP
  Label: Meter Pit
  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: 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: ConnectionType

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• 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: [1: Water] , [2: Sewer] , [3: Water and Sewer] , ...2 more... )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• LOCATIONID ( type: esriFieldTypeString, alias: Location Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LOCATIONID )
• CRITICAL ( type: esriFieldTypeSmallInteger, alias: CriticalCustomer, editable: true, nullable: true, defaultValue: 0, modelName: CRITICAL )
• 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 )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: NWWSD] , [-1: Private] , [-2: Other] )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: NWWSD] , [2: Perrysburg] , [3: Private] , ...1 more... )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR )
• ConnectionType ( type: esriFieldTypeString, alias: ConnectionType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ConnectionType , Coded Values: [MP: Meter Pit] , [CS: Curb Stop] )
• Svc_Address ( type: esriFieldTypeString, alias: Svc_Address, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Svc_Address )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Status , Coded Values: [1: Service On] , [2: Service Off] , [3: Pending] )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Comments )
• GPS_Located ( type: esriFieldTypeString, alias: GPS_Located, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GPS_Located , Coded Values: [GPS: Located and GPS] , [NGPS: Not Located needs GPS] , [FV: Not GPS But Field Verified] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Copper ( type: esriFieldTypeString, alias: Copper, editable: true, nullable: true, length: 125, defaultValue: null, modelName: Copper )
• GPSDate ( type: esriFieldTypeDate, alias: GPS Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPSDate )
• Link ( type: esriFieldTypeString, alias: Link, editable: true, nullable: true, length: 125, defaultValue: null, modelName: Link )
• Source ( type: esriFieldTypeString, alias: Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Source )
• StealthChangedOut ( type: esriFieldTypeString, alias: Stealth Changed Out, editable: true, nullable: true, length: 25, defaultValue: null, modelName: StealthChangedOut , Coded Values: [NO: NO] , [YES: YES] , [INACTIVE: INACTIVE] , ...1 more... )
• DateChangeOut ( type: esriFieldTypeDate, alias: Date ofChange Out, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateChangeOut )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 175, defaultValue: null, modelName: Notes )
• 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 )
• leadsvcline ( type: esriFieldTypeString, alias: Lead Service Line, editable: true, nullable: true, length: 50, defaultValue: null, modelName: leadsvcline , Coded Values: [NO: NO] , [YES: YES] , [INACTIVE: INACTIVE] , ...1 more... )
• PitType ( type: esriFieldTypeString, alias: Pit Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PitType , Coded Values: [S: Single] , [T: Tandem] )
• FieldVerifiedBy ( type: esriFieldTypeString, alias: Field Verified By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: InspectedBy , Coded Values: [cb: Chris Blake] , [cf: Chad Feehan] , [tm: Tom McGrain] , ...23 more... )
• FieldVerifiedNotes ( type: esriFieldTypeString, alias: Field Notes, editable: true, nullable: true, length: 75, defaultValue: null, modelName: ResponseRecomm , Coded Values: [Needs Attention-Ops: Needs Attention-Ops] , [Needs Attention-GIS: Needs Attention-GIS] , [Verified: Verified] , ...1 more... )
• FieldVerifiedDate ( type: esriFieldTypeDate, alias: Date Field Verified, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateOfLeakSurvey )
• AdditionalNotes ( type: esriFieldTypeString, alias: Additional Notes, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LeakNotes )
• PrjNum ( type: esriFieldTypeString, alias: Project Number, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PrjNum )
• PWSID ( type: esriFieldTypeString, alias: PWS ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PWSID )
• TypeofAttention ( type: esriFieldTypeString, alias: Type of Attention, editable: true, nullable: true, length: 125, defaultValue: null, modelName: TypeofAttention , Coded Values: [Good: Good] , [Can't Locate: Can't Locate] , [Needs Repaired: Needs Repaired] , ...5 more... )
• LocationNo ( type: esriFieldTypeString, alias: LocationNo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LocationNo )
• MeterTechCrew ( type: esriFieldTypeString, alias: Meter Tech Crew, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MeterTechCrew , Coded Values: [ds: Don Straub] )
• dateofmetertechvisit ( type: esriFieldTypeDate, alias: Date of Meter Tech Visit, editable: true, nullable: true, length: 8, defaultValue: null, modelName: dateofmetertechvisit )
• MeterTechNotes ( type: esriFieldTypeString, alias: Meter Tech Notes, editable: true, nullable: true, length: 200, defaultValue: null, modelName: MeterTechNotes )
• ServiceConnectionInspectedforLe ( type: esriFieldTypeString, alias: Service Connection Inspected for Leaks, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ServiceConnectionInspectedforLe , Coded Values: [lf: Leak Found] , [nlf: No Leak Found] , [pl: Possible Leak-Follow Up Needed] , ...1 more... )
• DateofLeakInspection ( type: esriFieldTypeDate, alias: Date of Leak Inspection, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateofLeakInspection )
• LeakInspector ( type: esriFieldTypeString, alias: Leak Inspector, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LeakInspector , Coded Values: [cb: Chris Blake] , [cf: Chad Feehan] , [tm: Tom McGrain] , ...5 more... )
• LeakInspectorNotes ( type: esriFieldTypeString, alias: Leak Inspector Notes, editable: true, nullable: true, length: 225, defaultValue: null, modelName: LeakInspectorNotes )
• DateFixed ( type: esriFieldTypeDate, alias: Date Fixed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateFixed )
• FieldVerified ( type: esriFieldTypeString, alias: Field Verified, editable: true, nullable: true, length: 25, defaultValue: NO, modelName: FieldVerified , Coded Values: [YES: YES] , [NO: NO] , [FOLLOW UP: FOLLOW UP] )
• WhoseAttentionNeeded ( type: esriFieldTypeString, alias: Whose Attention Needed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WhoseAttentionNeeded , Coded Values: [OPs: OPs] , [GIS: GIS] , [Meter Tech: Meter Tech] )
• SrvcConnectionLoc ( type: esriFieldTypeString, alias: Service Connection Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SrvcConnectionLoc , Coded Values: [Sidewalk: Sidewalk] , [Driveway: Driveway] , [Curb: Curb] , ...11 more... )

Types:

ID: CS
Name: Curb Stop
Domains:
• SERVICETYPE:
  Inherited
• ENABLED:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• ConnectionType:
  Inherited
• Status:
  Inherited
• GPS_Located:
  Inherited
• StealthChangedOut:
  Inherited
• leadsvcline:
  Inherited
• PitType:
  Inherited
• FieldVerifiedBy:
  Inherited
• FieldVerifiedNotes:
  Inherited
• TypeofAttention:
  Inherited
• MeterTechCrew:
  Inherited
• ServiceConnectionInspectedforLe:
  Inherited
• LeakInspector:
  Inherited
• FieldVerified:
  Inherited
• WhoseAttentionNeeded:
  Inherited
• SrvcConnectionLoc:
  Inherited
Templates:
• Name: Curb Stop
  Description:
  Prototype:
  LASTEDITOR: null
  WhoseAttentionNeeded: null
  ACCOUNTID: null
  SERVICETYPE: null
  INSTALLDATE: null
  LOCDESC: null
  LOCATIONID: null
  CRITICAL: 0
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  LASTUPDATE: null
  ConnectionType: CS
  Svc_Address: null
  Status: null
  Comments: null
  GPS_Located: null
  SrvcConnectionLoc: null
  Copper: null
  GPSDate: null
  Link: null
  Source: null
  StealthChangedOut: null
  DateChangeOut: null
  Notes: null
  FieldVerified: NO
  DateFixed: null
  LeakInspectorNotes: null
  LeakInspector: null
  leadsvcline: null
  PitType: null
  FieldVerifiedBy: null
  FieldVerifiedNotes: null
  FieldVerifiedDate: null
  AdditionalNotes: null
  PrjNum: null
  PWSID: null
  TypeofAttention: null
  LocationNo: null
  MeterTechCrew: null
  dateofmetertechvisit: null
  MeterTechNotes: null
  ServiceConnectionInspectedforLe: null
  DateofLeakInspection: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: MP
Name: Meter Pit
Domains:
• SERVICETYPE:
  Inherited
• ENABLED:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• ConnectionType:
  Inherited
• Status:
  Inherited
• GPS_Located:
  Inherited
• StealthChangedOut:
  Inherited
• leadsvcline:
  Inherited
• PitType:
  Inherited
• FieldVerifiedBy:
  Inherited
• FieldVerifiedNotes:
  Inherited
• TypeofAttention:
  Inherited
• MeterTechCrew:
  Inherited
• ServiceConnectionInspectedforLe:
  Inherited
• LeakInspector:
  Inherited
• FieldVerified:
  Inherited
• WhoseAttentionNeeded:
  Inherited
• SrvcConnectionLoc:
  Inherited
Templates:
• Name: Meter Pit
  Description:
  Prototype:
  LASTEDITOR: null
  WhoseAttentionNeeded: null
  ACCOUNTID: null
  SERVICETYPE: null
  INSTALLDATE: null
  LOCDESC: null
  LOCATIONID: null
  CRITICAL: 0
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  LASTUPDATE: null
  ConnectionType: MP
  Svc_Address: null
  Status: null
  Comments: null
  GPS_Located: null
  SrvcConnectionLoc: null
  Copper: null
  GPSDate: null
  Link: null
  Source: null
  StealthChangedOut: null
  DateChangeOut: null
  Notes: null
  FieldVerified: NO
  DateFixed: null
  LeakInspectorNotes: null
  LeakInspector: null
  leadsvcline: null
  PitType: null
  FieldVerifiedBy: null
  FieldVerifiedNotes: null
  FieldVerifiedDate: null
  AdditionalNotes: null
  PrjNum: null
  PWSID: null
  TypeofAttention: null
  LocationNo: null
  MeterTechCrew: null
  dateofmetertechvisit: null
  MeterTechNotes: null
  ServiceConnectionInspectedforLe: null
  DateofLeakInspection: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Create,Update,Delete,Uploads,Editing

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: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata