View In:   ArcGIS Online Map Viewer

Name: Utility Side | Customer Side

Display Field: null

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 58efc47c9bcd43afbaa457012d6eb96b

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 66619.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -363443.20095785003
YMin: 3064839.381620167
XMax: -320889.2459676718
YMax: 3103271.964024466
Spatial Reference: 103037  (6455)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: utilstatus
Field 2: custstatus
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [255, 255, 255, 255]
Size: 12.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Default Label: Other
UniqueValueInfos:
• Value: 1,1
  Label: Lead | Lead
  Description: N/A
  Symbol:
  
• Value: 1,3
  Label: Lead | Galvanized Requiring Replacement
  Description: N/A
  Symbol:
  
• Value: 1,2
  Label: Lead | Non-Lead
  Description: N/A
  Symbol:
  
• Value: 1,0
  Label: Lead | Unknown
  Description: N/A
  Symbol:
  
• Value: 3,1
  Label: Galvanized Requiring Replacement | Lead
  Description: N/A
  Symbol:
  
• Value: 3,3
  Label: Galvanized Requiring Replacement | Galvanized Requiring Replacement
  Description: N/A
  Symbol:
  
• Value: 3,2
  Label: Galvanized Requiring Replacement | Non-Lead
  Description: N/A
  Symbol:
  
• Value: 3,0
  Label: Galvanized Requiring Replacement | Unknown
  Description: N/A
  Symbol:
  
• Value: 2,1
  Label: Non-Lead | Lead
  Description: N/A
  Symbol:
  
• Value: 2,3
  Label: Non-Lead | Galvanized Requiring Replacement
  Description: N/A
  Symbol:
  
• Value: 2,2
  Label: Non-Lead | Non-Lead
  Description: N/A
  Symbol:
  
• Value: 2,0
  Label: Non-Lead | Unknown
  Description: N/A
  Symbol:
  
• Value: 0,1
  Label: Unknown | Lead
  Description: N/A
  Symbol:
  
• Value: 0,3
  Label: Unknown | Galvanized Requiring Replacement
  Description: N/A
  Symbol:
  
• Value: 0,2
  Label: Unknown | Non-Lead
  Description: N/A
  Symbol:
  
• Value: 0,0
  Label: Unknown | Unknown
  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: false
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: true
Supports Query With LOD Spatial Reference: true

HasZ: true

HasM: true

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: utilstatus

Fields:

• utilsource ( nullable: true, editable: true, defaultValue: null, alias: Basis of Material Classification-System Owned Portion, type: esriFieldTypeSmallInteger , Coded Values: [1: Installation record (e.g., tap card)] , [6: Installation date after local lead ban (provide date)] , [7: Installation date after statewide lead ban (1/1/1985)] , ...6 more... )
• utilstatus ( nullable: true, editable: true, defaultValue: null, alias: System Owned Portion Service Line Material Classification, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Lead] , [2: Non-Lead] , ...1 more... )
• custsource ( nullable: true, editable: true, defaultValue: null, alias: Basis of Material Classification-Customer Owned Portion, type: esriFieldTypeSmallInteger , Coded Values: [1: Installation record (e.g., tap card)] , [6: Installation date after local lead ban (provide date)] , [7: Installation date after statewide lead ban (1/1/1985)] , ...6 more... )
• custstatus ( nullable: true, editable: true, defaultValue: null, alias: Customer Owned Portion Service Line Material Classification, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Lead] , [2: Non-Lead] , ...1 more... )
• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: OBJECTID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
• pid ( nullable: true, editable: true, defaultValue: null, length: 20, alias: Parcel ID, type: esriFieldTypeString )
• streetaddress ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Address, type: esriFieldTypeString )
• city ( nullable: true, editable: true, defaultValue: null, length: 50, alias: City, type: esriFieldTypeString )
• zip ( nullable: true, editable: true, defaultValue: null, length: 10, alias: Zip Code, type: esriFieldTypeString )
• otherlocationidentifier ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Other Location Identifier, type: esriFieldTypeString )
• specialcircumstances ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Special Circumstances, type: esriFieldTypeString )
• uniqueid ( nullable: true, editable: true, defaultValue: null, length: 25, alias: Unique Service Line ID, type: esriFieldTypeString )
• bothsidesstatus ( nullable: true, editable: true, defaultValue: null, alias: Entire Service Line Material Classification, type: esriFieldTypeInteger , Coded Values: [0: Unknown] , [1: Lead] , [2: Non-Lead] , ...1 more... )
• notes ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Notes, type: esriFieldTypeString )

Types:

ID: 1
Name: Lead | Lead
Domains:
• utilsource:
  Inherited
• custverified:
  Inherited
• utilverified:
  Inherited
• utildiameter:
  Inherited
• utilstatus:
  Inherited
• utilmaterial:
  Inherited
• replacereason:
  Inherited
• custstatus:
  Inherited
• custdiameter:
  Inherited
• custmaterial:
  Inherited
• replacestatus:
  Inherited
• custsource:
  Inherited
• custnotified:
  Inherited
Templates:
• Name: Lead | Lead
  Description:
  Prototype:
  zip: null
  custstatus: 1
  city: null
  specialcircumstances: null
  otherlocationidentifier: null
  utilstatus: 1
  pid: null
  streetaddress: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Lead | Galvanized Requiring Replacement
  Description:
  Prototype:
  zip: null
  custstatus: 3
  city: null
  specialcircumstances: null
  otherlocationidentifier: null
  utilstatus: 1
  pid: null
  streetaddress: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Lead | Non-Lead
  Description:
  Prototype:
  zip: null
  custstatus: 2
  city: null
  specialcircumstances: null
  otherlocationidentifier: null
  utilstatus: 1
  pid: null
  streetaddress: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Lead | Unknown
  Description:
  Prototype:
  zip: null
  custstatus: 0
  city: null
  specialcircumstances: null
  otherlocationidentifier: null
  utilstatus: 1
  pid: null
  streetaddress: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: Galvanized Requiring Replacement | Lead
Domains:
• utilsource:
  Inherited
• custverified:
  Inherited
• utilverified:
  Inherited
• utildiameter:
  Inherited
• utilstatus:
  Inherited
• utilmaterial:
  Inherited
• replacereason:
  Inherited
• custstatus:
  Inherited
• custdiameter:
  Inherited
• custmaterial:
  Inherited
• replacestatus:
  Inherited
• custsource:
  Inherited
• custnotified:
  Inherited
Templates:
• Name: Galvanized Requiring Replacement | Lead
  Description:
  Prototype:
  zip: null
  custstatus: 1
  city: null
  specialcircumstances: null
  otherlocationidentifier: null
  utilstatus: 3
  pid: null
  streetaddress: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Galvanized Requiring Replacement | Galvanized Requiring Replacement
  Description:
  Prototype:
  zip: null
  custstatus: 3
  city: null
  specialcircumstances: null
  otherlocationidentifier: null
  utilstatus: 3
  pid: null
  streetaddress: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Galvanized Requiring Replacement | Non-Lead
  Description:
  Prototype:
  zip: null
  custstatus: 2
  city: null
  specialcircumstances: null
  otherlocationidentifier: null
  utilstatus: 3
  pid: null
  streetaddress: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Galvanized Requiring Replacement | Unknown
  Description:
  Prototype:
  zip: null
  custstatus: 0
  city: null
  specialcircumstances: null
  otherlocationidentifier: null
  utilstatus: 3
  pid: null
  streetaddress: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Non-Lead | Lead
Domains:
• utilsource:
  Inherited
• custverified:
  Inherited
• utilverified:
  Inherited
• utildiameter:
  Inherited
• utilstatus:
  Inherited
• utilmaterial:
  Inherited
• replacereason:
  Inherited
• custstatus:
  Inherited
• custdiameter:
  Inherited
• custmaterial:
  Inherited
• replacestatus:
  Inherited
• custsource:
  Inherited
• custnotified:
  Inherited
Templates:
• Name: Non-Lead | Lead
  Description:
  Prototype:
  zip: null
  custstatus: 1
  city: null
  specialcircumstances: null
  otherlocationidentifier: null
  utilstatus: 2
  pid: null
  streetaddress: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Non-Lead | Galvanized Requiring Replacement
  Description:
  Prototype:
  zip: null
  custstatus: 3
  city: null
  specialcircumstances: null
  otherlocationidentifier: null
  utilstatus: 2
  pid: null
  streetaddress: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Non-Lead | Non-Lead
  Description:
  Prototype:
  zip: null
  custstatus: 2
  city: null
  specialcircumstances: null
  otherlocationidentifier: null
  utilstatus: 2
  pid: null
  streetaddress: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Non-Lead | Unknown
  Description:
  Prototype:
  zip: null
  custstatus: 0
  city: null
  specialcircumstances: null
  otherlocationidentifier: null
  utilstatus: 2
  pid: null
  streetaddress: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 0
Name: Unknown | Lead
Domains:
• utilsource:
  Inherited
• custverified:
  Inherited
• utilverified:
  Inherited
• utildiameter:
  Inherited
• utilstatus:
  Inherited
• utilmaterial:
  Inherited
• replacereason:
  Inherited
• custstatus:
  Inherited
• custdiameter:
  Inherited
• custmaterial:
  Inherited
• replacestatus:
  Inherited
• custsource:
  Inherited
• custnotified:
  Inherited
Templates:
• Name: Unknown | Lead
  Description:
  Prototype:
  zip: null
  custstatus: 1
  city: null
  specialcircumstances: null
  otherlocationidentifier: null
  utilstatus: 0
  pid: null
  streetaddress: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Unknown | Galvanized Requiring Replacement
  Description:
  Prototype:
  zip: null
  custstatus: 3
  city: null
  specialcircumstances: null
  otherlocationidentifier: null
  utilstatus: 0
  pid: null
  streetaddress: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Unknown | Non-Lead
  Description:
  Prototype:
  zip: null
  custstatus: 2
  city: null
  specialcircumstances: null
  otherlocationidentifier: null
  utilstatus: 0
  pid: null
  streetaddress: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Unknown | Unknown
  Description:
  Prototype:
  zip: null
  custstatus: 0
  city: null
  specialcircumstances: null
  otherlocationidentifier: null
  utilstatus: 0
  pid: null
  streetaddress: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Extract

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

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   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata