Layers:

Layer: ServiceLine (0)

Name: ServiceLine

Display Field: accountid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: cde681d048314745863d2bcf118104e3

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 40000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:
XMin: -93.26692022881359
YMin: 45.11887198625466
XMax: -93.14250925148194
YMax: 45.21159596411828
Spatial Reference: 4269  (0)  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:
Label Placement: esriServerPointLabelPlacementCenterCenter
Label Expression: null
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: -2
YOffset: 0
Size: 10
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 5000.0
Max. Scale: 0.0

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: true

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: utilstatus

Fields:
• accountid ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, isViewOverride: false, alias: Account ID )
• address ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, isViewOverride: false, alias: Address )
• location ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, isViewOverride: false, alias: Other Location Identifier )
• sensitivepop ( nullable: true, editable: true, defaultValue: null, length: 15, type: esriFieldTypeString, isViewOverride: false, alias: Sensitive Population , Coded Values: [Yes - School: Yes - School] , [Yes - Day Care: Yes - Day Care] , [Yes - Other: Yes - Other] , ...1 more... )
• disadvantaged ( nullable: true, editable: true, defaultValue: null, length: 15, type: esriFieldTypeString, isViewOverride: false, alias: Disadvantaged Neighborhood , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• utilassetid ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, isViewOverride: false, alias: Utility Asset ID )
• utilmaterial ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, isViewOverride: false, alias: Utility Material , Coded Values: [Unknown - Material Unknown: Unknown - Material Unknown] , [Unknown - Likely Lead: Unknown - Likely Lead] , [Unknown - Unlikely Lead: Unknown - Unlikely Lead] , ...6 more... )
• everlead ( nullable: true, editable: true, defaultValue: null, length: 15, type: esriFieldTypeString, isViewOverride: false, alias: Ever Lead? , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• utilinstalldate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, isViewOverride: false, alias: Utility Install Date )
• utildiameter ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, isViewOverride: false, alias: Utility Diameter , Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...13 more... )
• utilsource ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, isViewOverride: false, alias: Utility Source , Coded Values: [Installation record (e.g., tap card): Installation record (e.g., tap card)] , [Water sampling only with no records: Water sampling only with no records] , [Field inspection only with no records: Field inspection only with no records] , ...6 more... )
• utilverified ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, isViewOverride: false, alias: Utility Side Verified , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• utilverifmethod ( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, isViewOverride: false, alias: Utility Verification Method , Coded Values: [Visual inspection at meter pit: Visual inspection at meter pit] , [Customer self-identification: Customer self-identification] , [CCTV Inspection at Curb Box - Internal: CCTV Inspection at Curb Box - Internal] , ...7 more... )
• utilverifdate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, isViewOverride: false, alias: Utility Verification Date )
• utilstatus ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeSmallInteger, isViewOverride: false, alias: Utility Status , Coded Values: [0: Unknown] , [1: Lead] , [2: Non-Lead] , ...1 more... )
• utilnotes ( nullable: true, editable: true, defaultValue: null, length: 2000, type: esriFieldTypeString, isViewOverride: false, alias: Utility Side Notes )
• custassetid ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, isViewOverride: false, alias: Customer Asset ID )
• custmaterial ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, isViewOverride: false, alias: Customer Material , Coded Values: [Unknown - Material Unknown: Unknown - Material Unknown] , [Unknown - Likely Lead: Unknown - Likely Lead] , [Unknown - Unlikely Lead: Unknown - Unlikely Lead] , ...6 more... )
• custinstalldate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, isViewOverride: false, alias: Customer Install Date )
• custdiameter ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, isViewOverride: false, alias: Customer Diameter , Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...13 more... )
• custsource ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, isViewOverride: false, alias: Customer Source , Coded Values: [Installation record (e.g., tap card): Installation record (e.g., tap card)] , [Water sampling only with no records: Water sampling only with no records] , [Field inspection only with no records: Field inspection only with no records] , ...6 more... )
• custverified ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, isViewOverride: false, alias: Customer Side Verified , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• custverifmethod ( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, isViewOverride: false, alias: Customer Verification Method , Coded Values: [Visual inspection at meter pit: Visual inspection at meter pit] , [Customer self-identification: Customer self-identification] , [CCTV Inspection at Curb Box - Internal: CCTV Inspection at Curb Box - Internal] , ...7 more... )
• custverifdate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, isViewOverride: false, alias: Customer Verification Date )
• custstatus ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeSmallInteger, isViewOverride: false, alias: Customer Status , Coded Values: [0: Unknown] , [1: Lead] , [2: Non-Lead] , ...1 more... )
• custnotes ( nullable: true, editable: true, defaultValue: null, length: 2000, type: esriFieldTypeString, isViewOverride: false, alias: Customer Side Notes )
• bothsidesstatus ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, isViewOverride: false, alias: Entire Service Line Status , Coded Values: [Unknown: Unknown] , [Lead: Lead] , [Non-Lead: Non-Lead] , ...1 more... )
• leadconnector ( nullable: true, editable: true, defaultValue: null, length: 15, type: esriFieldTypeString, isViewOverride: false, alias: Lead Connector , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• leadsolder ( nullable: true, editable: true, defaultValue: null, length: 15, type: esriFieldTypeString, isViewOverride: false, alias: Lead Solder , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• otherfittings ( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, isViewOverride: false, alias: Other Fittings Containing Lead )
• buildingtype ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, isViewOverride: false, alias: Building Type , Coded Values: [Single Family Residence: Single Family Residence] , [Multiple Family Residence: Multiple Family Residence] , [Building: Building] , ...1 more... )
• pointofentry ( nullable: true, editable: true, defaultValue: null, length: 15, type: esriFieldTypeString, isViewOverride: false, alias: Point-of-Entry or Point-of-Use , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• copperwithlead ( nullable: true, editable: true, defaultValue: null, length: 15, type: esriFieldTypeString, isViewOverride: false, alias: Copper Pipes with Lead Solder Before Lead Ban , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• samplingsite ( nullable: true, editable: true, defaultValue: null, length: 15, type: esriFieldTypeString, isViewOverride: false, alias: Current LCR Sampling Site , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• replacestatus ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, isViewOverride: false, alias: Replacement Status , Coded Values: [Doesn't Need Replacement: Doesn't Need Replacement] , [Needs Replacement: Needs Replacement] , [Scheduled Replacement: Scheduled Replacement] , ...1 more... )
• scheddate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, isViewOverride: false, alias: Utility Side Scheduled Replacement Date )
• utilreplacedate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, isViewOverride: false, alias: Utility Side Replacement Date )
• custscheddate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, isViewOverride: false, alias: Customer Side Scheduled Replacement Date )
• custreplacedate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, isViewOverride: false, alias: Customer Side Replacement Date )
• replacereason ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, isViewOverride: false, alias: Reason for Replacement , Coded Values: [Lead: Lead] , [Other: Other] )
• custnotified ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, isViewOverride: false, alias: Notified Customer , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• notifydate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, isViewOverride: false, alias: Notification Date )
• yearstructbuilt ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeSmallInteger, isViewOverride: false, alias: Year Structure Built )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, isViewOverride: false, alias: Creator )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, isViewOverride: false, alias: CreationDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, isViewOverride: false, alias: Editor )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, isViewOverride: false, alias: EditDate )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, isViewOverride: false, alias: GlobalID )
• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, isViewOverride: false, alias: OBJECTID )
Types:
ID: 1
Name: Lead | Lead
Domains:
Templates:
• Name: Lead | Lead
  Description:
  Prototype:
  samplingsite: null
  utilreplacedate: null
  utilsource: null
  custverified: null
  disadvantaged: null
  utilinstalldate: null
  scheddate: null
  utilmaterial: null
  custinstalldate: null
  custnotes: null
  accountid: null
  utilassetid: null
  custreplacedate: null
  leadsolder: null
  bothsidesstatus: null
  yearstructbuilt: null
  custsource: null
  custnotified: null
  custassetid: null
  leadconnector: null
  notifydate: null
  custverifmethod: null
  address: null
  utilverified: null
  sensitivepop: null
  utildiameter: null
  utilverifdate: null
  utilstatus: 1
  buildingtype: null
  replacereason: null
  utilverifmethod: null
  custstatus: null
  custscheddate: null
  everlead: null
  custdiameter: null
  otherfittings: null
  utilnotes: null
  custmaterial: null
  replacestatus: null
  location: null
  custverifdate: null
  pointofentry: null
  copperwithlead: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 3
Name: Galvanized Requiring Replacement | Lead
Domains:
Templates:
• Name: Galvanized Requiring Replacement | Lead
  Description:
  Prototype:
  samplingsite: null
  utilreplacedate: null
  utilsource: null
  custverified: null
  disadvantaged: null
  utilinstalldate: null
  scheddate: null
  utilmaterial: null
  custinstalldate: null
  custnotes: null
  accountid: null
  utilassetid: null
  custreplacedate: null
  leadsolder: null
  bothsidesstatus: null
  yearstructbuilt: null
  custsource: null
  custnotified: null
  custassetid: null
  leadconnector: null
  notifydate: null
  custverifmethod: null
  address: null
  utilverified: null
  sensitivepop: null
  utildiameter: null
  utilverifdate: null
  utilstatus: 3
  buildingtype: null
  replacereason: null
  utilverifmethod: null
  custstatus: null
  custscheddate: null
  everlead: null
  custdiameter: null
  otherfittings: null
  utilnotes: null
  custmaterial: null
  replacestatus: null
  location: null
  custverifdate: null
  pointofentry: null
  copperwithlead: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 2
Name: Non-Lead | Lead
Domains:
Templates:
• Name: Non-Lead | Lead
  Description:
  Prototype:
  samplingsite: null
  utilreplacedate: null
  utilsource: null
  custverified: null
  disadvantaged: null
  utilinstalldate: null
  scheddate: null
  utilmaterial: null
  custinstalldate: null
  custnotes: null
  accountid: null
  utilassetid: null
  custreplacedate: null
  leadsolder: null
  bothsidesstatus: null
  yearstructbuilt: null
  custsource: null
  custnotified: null
  custassetid: null
  leadconnector: null
  notifydate: null
  custverifmethod: null
  address: null
  utilverified: null
  sensitivepop: null
  utildiameter: null
  utilverifdate: null
  utilstatus: 2
  buildingtype: null
  replacereason: null
  utilverifmethod: null
  custstatus: null
  custscheddate: null
  everlead: null
  custdiameter: null
  otherfittings: null
  utilnotes: null
  custmaterial: null
  replacestatus: null
  location: null
  custverifdate: null
  pointofentry: null
  copperwithlead: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 0
Name: Unknown | Lead
Domains:
Templates:
• Name: Unknown | Lead
  Description:
  Prototype:
  samplingsite: null
  utilreplacedate: null
  utilsource: null
  custverified: null
  disadvantaged: null
  utilinstalldate: null
  scheddate: null
  utilmaterial: null
  custinstalldate: null
  custnotes: null
  accountid: null
  utilassetid: null
  custreplacedate: null
  leadsolder: null
  bothsidesstatus: null
  yearstructbuilt: null
  custsource: null
  custnotified: null
  custassetid: null
  leadconnector: null
  notifydate: null
  custverifmethod: null
  address: null
  utilverified: null
  sensitivepop: null
  utildiameter: null
  utilverifdate: null
  utilstatus: 0
  buildingtype: null
  replacereason: null
  utilverifmethod: null
  custstatus: null
  custscheddate: null
  everlead: null
  custdiameter: null
  otherfittings: null
  utilnotes: null
  custmaterial: null
  replacestatus: null
  location: null
  custverifdate: null
  pointofentry: null
  copperwithlead: null
  
  Drawing Tool: esriFeatureEditToolNone

---