Name: ServiceLine
Display Field: accountid
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description:
Copyright Text:
Min. Scale: 18057
Max. Scale: 0
Default Visibility: true
Max Record Count: 1000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: 1368856.16482605
YMin: 492845.671654388
XMax: 1405214.2682908
YMax: 532185.725520059
Spatial Reference: 102723 (3735)
Drawing Info:
{"renderer":{"type":"uniqueValue","field1":"utilverified","field2":"custverified","field3":null,"defaultSymbol":null,"defaultLabel":null,"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"e4d0144af347d3ad0004e361458ded6a","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAgAAAAICAYAAADED76LAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAALdJREFUGJVtyrFKQnEYhvFH+uDDOigcbEonXTNscWsWl0NX4BrkDTjlpOJVNLh5AwVJRKM5uImTS5uc7Z+8CNZgQ5K/9XmMPYvHcSuUQ5UtG6Y8q61XAAMiZozSWpqQ+d0vufOKD9VQz/zNu7pWwl9Z8rpRxx/9wyjR5Jgska50azpR7ugAxBbnzIMvhS7+1W8IaViYVnrgnDoFTg+GBXM9aWA0eWdC4kXv60xVdnyx5oVP7umz/QF/sDvC17lGLwAAAABJRU5ErkJggg==","contentType":"image/png","width":6,"height":6,"angle":0,"xoffset":0,"yoffset":0},"value":"Yes,Yes","label":"Both Sides Verified","description":""},{"symbol":{"type":"esriPMS","url":"2f24bf036c4f3e092a5bf51038e729f5","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAgAAAAICAYAAADED76LAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAMZJREFUGJVtyrGOAWEUQOEjbvJnlpAI1Y6KFjHNdmqZZuIJtBJeQEVlxFModF7AJjsR2dIqtpuoNDqZbsjNJCg0Ir72HOFBlstCt1KJ60nCZbvlezDQNYAA2d2ORbMZeanU467V6FWrZtZu60Q2GzN2HPV4YlnkWy0dzufmT8plXN6wLLKNhnYkndbcuwFApJCTODZ70M/XeLtBFMWhHA46KpX4Khb5eB7CkP/VSqfiuvwGAZ5tGz+T0fr1yvl04ud4pO/7JHff2z+2YOck9QAAAABJRU5ErkJggg==","contentType":"image/png","width":6,"height":6,"angle":0,"xoffset":0,"yoffset":0},"value":",Yes","label":"Customer Side Verified","description":""},{"symbol":{"type":"esriPMS","url":"44446d1408120b729decd9b68ef370e3","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAgAAAAICAYAAADED76LAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAMhJREFUGJVjYYAAltX5QvHKEl/1fjMwfD99jWFnzuKf+xkYGBhYGBgYeM62MywxVHrnzwhVrSvDkKEiy97l0fazjeVgA3uDkdJPfwYkwMnGwG+n9bNyQRb7GRZZYQYvBiyAk5WBR1/uZyALM9NPPmwKGBgYGFhYhPhYvv5gv8XA8FMaXfI/AwPDu89fb7A8ePqzXpSfwVyEl4ELWcGNJwwXdzT+7GDx6mM4vLeawV9GlL2dm+On3r//DN/efGTY8/QVQ3Y7A8NvAOZvPBp0oDybAAAAAElFTkSuQmCC","contentType":"image/png","width":6,"height":6,"angle":0,"xoffset":0,"yoffset":0},"value":"Yes,","label":"Utility Side Verified","description":""},{"symbol":{"type":"esriPMS","url":"f8450d8b1bfb2192e961971caa05c01a","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAgAAAAICAYAAADED76LAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAM5JREFUGJVjYYAAlvpZq+OllJT1/vz+/f3mpdM7J5Xn7GdgYGBgYWBg4Jm5++wSFR1Df0ZGRgYGBgYGZU3dDGk5la7ySI82lv71BxtUdY38GZAAGwcnv76lXWXJ5AVnWMRlZL0YsAA2Dk4eNU39QBYmZmY+bAoYGBgYWNlY+Fh+fP16i4GBQRpd8v///wwf3r27wfLsyYN6fmFRc34hES5kBY/v3Lj46uSODpaqSK/DXav2+kvIyLSzc3HrMfz79+3juzd7nj19mt3e3v4bAHj0QgIi1Nb4AAAAAElFTkSuQmCC","contentType":"image/png","width":6,"height":6,"angle":0,"xoffset":0,"yoffset":0},"value":",","label":"Not Verified","description":""}],"fieldDelimiter":","},"transparency":0,"labelingInfo":null}
HasZ: false
HasM: true
Has Attachments: true
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field: utilverified
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- accountid (type: esriFieldTypeString, alias: Account ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- location (type: esriFieldTypeString, alias: Other Location Identifier, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- sensitivepop (type: esriFieldTypeString, alias: Sensitive Population, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes - School: Yes - School], [Yes - Day Care: Yes - Day Care], [Yes - Other: Yes - Other], ... 1 more ...)
- disadvantaged (type: esriFieldTypeString, alias: Disadvantaged Neighborhood, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- utilassetid (type: esriFieldTypeString, alias: Utility Asset ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- utilmaterial (type: esriFieldTypeString, alias: Utility Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Unknown - Material Unknown: Unknown - Material Unknown], [Unknown - Likely Lead: Unknown - Likely Lead], [Unknown - Unlikely Lead: Unknown - Unlikely Lead], ... 6 more ...)
- everlead (type: esriFieldTypeString, alias: Ever Lead?, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- utilinstalldate (type: esriFieldTypeDate, alias: Utility Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- utildiameter (type: esriFieldTypeDouble, alias: Utility Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [0.5: 1/2"], [0.75: 3/4"], ... 13 more ...)
- utilsource (type: esriFieldTypeString, alias: Utility Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, 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 (type: esriFieldTypeString, alias: Utility Side Verified, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- utilverifmethod (type: esriFieldTypeString, alias: Utility Verification Method, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, 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 (type: esriFieldTypeDate, alias: Utility Verification Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- utilstatus (type: esriFieldTypeSmallInteger, alias: Utility Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Lead], [2: Non-Lead], ... 1 more ...)
- utilnotes (type: esriFieldTypeString, alias: Utility Side Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- custassetid (type: esriFieldTypeString, alias: Customer Asset ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- custmaterial (type: esriFieldTypeString, alias: Customer Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Unknown - Material Unknown: Unknown - Material Unknown], [Unknown - Likely Lead: Unknown - Likely Lead], [Unknown - Unlikely Lead: Unknown - Unlikely Lead], ... 6 more ...)
- custinstalldate (type: esriFieldTypeDate, alias: Customer Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- custdiameter (type: esriFieldTypeDouble, alias: Customer Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [0.5: 1/2"], [0.75: 3/4"], ... 13 more ...)
- custsource (type: esriFieldTypeString, alias: Customer Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, 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 (type: esriFieldTypeString, alias: Customer Side Verified, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- custverifmethod (type: esriFieldTypeString, alias: Customer Verification Method, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, 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 (type: esriFieldTypeDate, alias: Customer Verification Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- custstatus (type: esriFieldTypeSmallInteger, alias: Customer Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Lead], [2: Non-Lead], ... 1 more ...)
- custnotes (type: esriFieldTypeString, alias: Customer Side Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- bothsidesstatus (type: esriFieldTypeString, alias: Entire Service Line Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Unknown: Unknown], [Lead: Lead], [Non-Lead: Non-Lead], ... 1 more ...)
- leadconnector (type: esriFieldTypeString, alias: Lead Connector, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- leadsolder (type: esriFieldTypeString, alias: Lead Solder, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- otherfittings (type: esriFieldTypeString, alias: Other Fittings Containing Lead, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- buildingtype (type: esriFieldTypeString, alias: Building Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Single Family Residence: Single Family Residence], [Multiple Family Residence: Multiple Family Residence], [Building: Building], ... 1 more ...)
- pointofentry (type: esriFieldTypeString, alias: Point-of-Entry or Point-of-Use, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- copperwithlead (type: esriFieldTypeString, alias: Copper Pipes with Lead Solder Before Lead Ban, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- samplingsite (type: esriFieldTypeString, alias: Current LCR Sampling Site, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- replacestatus (type: esriFieldTypeString, alias: Replacement Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Doesn't Need Replacement: Doesn't Need Replacement], [Needs Replacement: Needs Replacement], [Scheduled Replacement: Scheduled Replacement], ... 1 more ...)
- scheddate (type: esriFieldTypeDate, alias: Utility Side Scheduled Replacement Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- utilreplacedate (type: esriFieldTypeDate, alias: Utility Side Replacement Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- custscheddate (type: esriFieldTypeDate, alias: Customer Side Scheduled Replacement Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- custreplacedate (type: esriFieldTypeDate, alias: Customer Side Replacement Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- replacereason (type: esriFieldTypeString, alias: Reason for Replacement, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Lead: Lead], [Other: Other])
- custnotified (type: esriFieldTypeString, alias: Notified Customer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
- notifydate (type: esriFieldTypeDate, alias: Notification Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- yearstructbuilt (type: esriFieldTypeSmallInteger, alias: Year Structure Built, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- recinspectionsite (type: esriFieldTypeInteger, alias: Recommended Inspection Site, SQL Type: sqlTypeOther, nullable: true, editable: true)
- utilleadpred (type: esriFieldTypeDouble, alias: Utility Lead Prediction, SQL Type: sqlTypeOther, nullable: true, editable: true)
- custleadpred (type: esriFieldTypeDouble, alias: Customer Lead Prediction, SQL Type: sqlTypeOther, nullable: true, editable: true)
Types:
ID: Yes
Name: Yes
Domains:
- Field Name: sensitivepop
Inherited
- Field Name: disadvantaged
Inherited
- Field Name: utilmaterial
Inherited
- Field Name: everlead
Inherited
- Field Name: utildiameter
Inherited
- Field Name: utilsource
Inherited
- Field Name: utilverified
Inherited
- Field Name: utilverifmethod
Inherited
- Field Name: utilstatus
Inherited
- Field Name: custmaterial
Inherited
- Field Name: custdiameter
Inherited
- Field Name: custsource
Inherited
- Field Name: custverified
Inherited
- Field Name: custverifmethod
Inherited
- Field Name: custstatus
Inherited
- Field Name: bothsidesstatus
Inherited
- Field Name: leadconnector
Inherited
- Field Name: leadsolder
Inherited
- Field Name: buildingtype
Inherited
- Field Name: pointofentry
Inherited
- Field Name: copperwithlead
Inherited
- Field Name: samplingsite
Inherited
- Field Name: replacestatus
Inherited
- Field Name: replacereason
Inherited
- Field Name: custnotified
Inherited
Templates:
Name: Both Sides Verified
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- utilverified: Yes
- custverified: Yes
- recinspectionsite: 0
Name: Utility Side Verified
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- utilverified: Yes
- recinspectionsite: 0
ID:
Name:
Domains:
- Field Name: sensitivepop
Inherited
- Field Name: disadvantaged
Inherited
- Field Name: utilmaterial
Inherited
- Field Name: everlead
Inherited
- Field Name: utildiameter
Inherited
- Field Name: utilsource
Inherited
- Field Name: utilverified
Inherited
- Field Name: utilverifmethod
Inherited
- Field Name: utilstatus
Inherited
- Field Name: custmaterial
Inherited
- Field Name: custdiameter
Inherited
- Field Name: custsource
Inherited
- Field Name: custverified
Inherited
- Field Name: custverifmethod
Inherited
- Field Name: custstatus
Inherited
- Field Name: bothsidesstatus
Inherited
- Field Name: leadconnector
Inherited
- Field Name: leadsolder
Inherited
- Field Name: buildingtype
Inherited
- Field Name: pointofentry
Inherited
- Field Name: copperwithlead
Inherited
- Field Name: samplingsite
Inherited
- Field Name: replacestatus
Inherited
- Field Name: replacereason
Inherited
- Field Name: custnotified
Inherited
Templates:
Name: Customer Side Verified
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- custverified: Yes
- recinspectionsite: 0
Name: Not Verified
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 4/24/2024 3:09:55 AM
Schema Last Edit Date: 4/24/2024 3:09:55 AM
Data Last Edit Date: 4/24/2024 3:09:55 AM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Attachments
Update Features
Apply Edits
Calculate
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat