Layer: Service Line Inventory (ID:0)

View In: Map Viewer

Name: Service Line Inventory

Display Field: accountid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

","uniqueValueGroups":[{"heading":"Entire Service Line Status","classes":[{"label":"Galvanized Requiring Replacement","description":"Galvanized Requiring Replacement","symbol":{"type":"esriPMS","url":"3be7b5140bb62edca17de8d1d0dc27af","imageData":"iVBORw0KGgoAAAANSUhEUgAAABwAAAAaCAYAAACkVDyJAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABaklEQVRIidWWQYqDMBSG/4V3kPYQBclcodCFMycQutMDFLpt1oEeYGbdG7j0CuOmhyh4i+GleWkq0VaNwvzQkkr06/vz/sQICyv6L8A1gBWAegmgAPBrxgWAn7mBsjWeFSgApJvN/cf1qm2VrT8RFPhNX1kGbLdAkuhrJ1Pl7Z0HDAHmVCFVR0AGXy4WWoQECrbtcHhcpLEB5qbKOhSQHrhiK1lxfIeez9bujxBAYYDWSlcErCrdQDTvE0A5FSgZxt3pg+73tspyCjDnGLhr1xbZTHNMTHg9RwM1jNarT0oBu52tchTQxsBtlC7xvKqy0GIIUHDI+6z0VZkk/TGJXjXKO9WxyHZnM/DGJOraL/nmoVLKAoX51K+A0u28MVIKOB71sDRnZyfQxoBuGqvM2OqLiQtcuzGYKvWIiewCpuQ558209yTFMdA0z2emC9TVNY3dpkIq9QG/OHszSPLABdKJTbv9rFr8vfQPMZte+WVTuEwAAAAASUVORK5CYII=","contentType":"image/png","width":19,"height":19,"angle":0,"xoffset":0,"yoffset":0},"values":[["Galvanized Requiring Replacement"]]},{"label":"Lead","description":"Lead","symbol":{"type":"esriPMS","url":"45464c1fa6ed6d306c59af3381ec4a39","imageData":"iVBORw0KGgoAAAANSUhEUgAAABsAAAAbCAYAAACN1PRVAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABmElEQVRIic2WTW7CMBBG34I7IDhEJESv0B29QSR24QCV2HdbiQOUdU5AWPQQZONDUOUW1YSxbAdD86eon2QlipJ5nsn4s2dMqNl/hL0Ba2CjV6sfoACOQDkUlunwAb4W3jsC+1B4Z1ihmZAArzrmOkRGxwGobhM6AWetRGtYDZKg70D64KVERwrkwP72WCZ4AV7awGpQoiDJpo1SBW9dll/A7hks8zNqC7IS2DewcrGCxonBeoGsZKKfrqRSpWUMVre3/QdDlOo/NLduXdvsfFjd3n0zairRTtVq7ZqwzZiwVLPz1+hdZnYNjZEZT2CMCZvUiKvQP+9g8nBhwhL0lnG31xhM1kQ2Fqxyt9FFLas9O4ywznCdaOPewWQGpfhaPhCYuzLWMWMwdD867T1H7yrjrMrG4xGs0P1os1VTnXcEbcPyFX+1vnjkRcq5UlNtU9I8zOjc3F4ewdCNT/ajbK+BrEEnXrcZveZhqx9joGcw9IO6FOLeJuywmMohZxAbYKn+Zg8+a88ErvrOKKcrHxotTRdNekj9BUNlYI6714ceAAAAAElFTkSuQmCC","contentType":"image/png","width":20,"height":20,"angle":0,"xoffset":0,"yoffset":0},"values":[["Lead"]]},{"label":"Non-Lead","description":"Non-Lead","symbol":{"type":"esriPMS","url":"5cd627d7f588ddf2e6865d03b729a2da","imageData":"iVBORw0KGgoAAAANSUhEUgAAABoAAAAaCAYAAACpSkzOAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAjklEQVRIiWNhoBNgGQiLjBkYGNIYGBikqGh+OgMDwzN0i9KgmJpgJgMDgy+6RRCftO9gYBAUp8z49y8ZGCo9CMQRyBJKLRosiYGmgIW2xiPAqEVkAxbytZIGRi0iG7CQr5U0MGrRUAy69y8pN/X9SyIsQqsZqQVY0BoSoDqemiAdm0Wg1gq4IUELQLfEAAAruw+QgLfdUgAAAABJRU5ErkJggg==","contentType":"image/png","width":19,"height":19,"angle":0,"xoffset":0,"yoffset":0},"values":[["Non-Lead"]]},{"label":"Unknown","description":"Unknown","symbol":{"type":"esriPMS","url":"6cd359373d9899914c9e112c191787fb","imageData":"iVBORw0KGgoAAAANSUhEUgAAABYAAAAkCAYAAACNBsqdAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABxElEQVRIid2WMW7CMABF/5CdrGThCBnSGS4AHIGRTGzsULGyMcHIEcIJYK6HHMFDmX2E6kd2ZdI4jgNVpX7JiCT24/vnEyXCLyn6t+AEwBHAEMDbK8FLAFP9favH0+AMwGY0GlUHUsoNgAsA8Sx4y4/5fI44jrHb7cy52TPgjBGkaQoOis6llFN9TfQFH41bo9VqhfV6DR1H0ge8pKvxeFy5NGIcPHe73YZ6zikEnHARgbZbo8ViQbDJOgg8pdvJZFI5bBLh5/N56KpfEzhjtnTLLbvEa9fr1Vm/qK1ePtG1q36Rr15t4q5c9Yt89fLJVb/IVy+fXPV7AMdxHOTWiGvq9bPBmXHQR1ynlLqbYxucK6WORVEEu+YapRTsP4sNPjGOoigyNqJrzlJKE4NwgakcwAcd8G53Eedqvdvn62DBUZZlRic+12VZVkM7vbSBKQb8eTgcsN/v0dHtjwdRE/jOiUqpJbNzPS94jbvSUNH16ZbrG9kIZgO0W1HP1gdurV+tXt/d7Qo+NdXPVa8QcGP9XPUKBQu7fty+q16h4If6DQaD6kRbBCHgu6mfdcPEK8Am65n+kdZs+7zGJgFz//79OFhfVt3YxHZ4wRQAAAAASUVORK5CYII=","contentType":"image/png","width":27,"height":27,"angle":0,"xoffset":0,"yoffset":0},"values":[["Unknown"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"3be7b5140bb62edca17de8d1d0dc27af","imageData":"iVBORw0KGgoAAAANSUhEUgAAABwAAAAaCAYAAACkVDyJAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABaklEQVRIidWWQYqDMBSG/4V3kPYQBclcodCFMycQutMDFLpt1oEeYGbdG7j0CuOmhyh4i+GleWkq0VaNwvzQkkr06/vz/sQICyv6L8A1gBWAegmgAPBrxgWAn7mBsjWeFSgApJvN/cf1qm2VrT8RFPhNX1kGbLdAkuhrJ1Pl7Z0HDAHmVCFVR0AGXy4WWoQECrbtcHhcpLEB5qbKOhSQHrhiK1lxfIeez9bujxBAYYDWSlcErCrdQDTvE0A5FSgZxt3pg+73tspyCjDnGLhr1xbZTHNMTHg9RwM1jNarT0oBu52tchTQxsBtlC7xvKqy0GIIUHDI+6z0VZkk/TGJXjXKO9WxyHZnM/DGJOraL/nmoVLKAoX51K+A0u28MVIKOB71sDRnZyfQxoBuGqvM2OqLiQtcuzGYKvWIiewCpuQ558209yTFMdA0z2emC9TVNY3dpkIq9QG/OHszSPLABdKJTbv9rFr8vfQPMZte+WVTuEwAAAAASUVORK5CYII=","contentType":"image/png","width":19,"height":19,"angle":0,"xoffset":0,"yoffset":0},"value":"Galvanized Requiring Replacement","label":"Galvanized Requiring Replacement"},{"symbol":{"type":"esriPMS","url":"45464c1fa6ed6d306c59af3381ec4a39","imageData":"iVBORw0KGgoAAAANSUhEUgAAABsAAAAbCAYAAACN1PRVAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABmElEQVRIic2WTW7CMBBG34I7IDhEJESv0B29QSR24QCV2HdbiQOUdU5AWPQQZONDUOUW1YSxbAdD86eon2QlipJ5nsn4s2dMqNl/hL0Ba2CjV6sfoACOQDkUlunwAb4W3jsC+1B4Z1ihmZAArzrmOkRGxwGobhM6AWetRGtYDZKg70D64KVERwrkwP72WCZ4AV7awGpQoiDJpo1SBW9dll/A7hks8zNqC7IS2DewcrGCxonBeoGsZKKfrqRSpWUMVre3/QdDlOo/NLduXdvsfFjd3n0zairRTtVq7ZqwzZiwVLPz1+hdZnYNjZEZT2CMCZvUiKvQP+9g8nBhwhL0lnG31xhM1kQ2Fqxyt9FFLas9O4ywznCdaOPewWQGpfhaPhCYuzLWMWMwdD867T1H7yrjrMrG4xGs0P1os1VTnXcEbcPyFX+1vnjkRcq5UlNtU9I8zOjc3F4ewdCNT/ajbK+BrEEnXrcZveZhqx9joGcw9IO6FOLeJuywmMohZxAbYKn+Zg8+a88ErvrOKKcrHxotTRdNekj9BUNlYI6714ceAAAAAElFTkSuQmCC","contentType":"image/png","width":20,"height":20,"angle":0,"xoffset":0,"yoffset":0},"value":"Lead","label":"Lead"},{"symbol":{"type":"esriPMS","url":"5cd627d7f588ddf2e6865d03b729a2da","imageData":"iVBORw0KGgoAAAANSUhEUgAAABoAAAAaCAYAAACpSkzOAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAjklEQVRIiWNhoBNgGQiLjBkYGNIYGBikqGh+OgMDwzN0i9KgmJpgJgMDgy+6RRCftO9gYBAUp8z49y8ZGCo9CMQRyBJKLRosiYGmgIW2xiPAqEVkAxbytZIGRi0iG7CQr5U0MGrRUAy69y8pN/X9SyIsQqsZqQVY0BoSoDqemiAdm0Wg1gq4IUELQLfEAAAruw+QgLfdUgAAAABJRU5ErkJggg==","contentType":"image/png","width":19,"height":19,"angle":0,"xoffset":0,"yoffset":0},"value":"Non-Lead","label":"Non-Lead"},{"symbol":{"type":"esriPMS","url":"6cd359373d9899914c9e112c191787fb","imageData":"iVBORw0KGgoAAAANSUhEUgAAABYAAAAkCAYAAACNBsqdAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABxElEQVRIid2WMW7CMABF/5CdrGThCBnSGS4AHIGRTGzsULGyMcHIEcIJYK6HHMFDmX2E6kd2ZdI4jgNVpX7JiCT24/vnEyXCLyn6t+AEwBHAEMDbK8FLAFP9favH0+AMwGY0GlUHUsoNgAsA8Sx4y4/5fI44jrHb7cy52TPgjBGkaQoOis6llFN9TfQFH41bo9VqhfV6DR1H0ge8pKvxeFy5NGIcPHe73YZ6zikEnHARgbZbo8ViQbDJOgg8pdvJZFI5bBLh5/N56KpfEzhjtnTLLbvEa9fr1Vm/qK1ePtG1q36Rr15t4q5c9Yt89fLJVb/IVy+fXPV7AMdxHOTWiGvq9bPBmXHQR1ynlLqbYxucK6WORVEEu+YapRTsP4sNPjGOoigyNqJrzlJKE4NwgakcwAcd8G53Eedqvdvn62DBUZZlRic+12VZVkM7vbSBKQb8eTgcsN/v0dHtjwdRE/jOiUqpJbNzPS94jbvSUNH16ZbrG9kIZgO0W1HP1gdurV+tXt/d7Qo+NdXPVa8QcGP9XPUKBQu7fty+q16h4If6DQaD6kRbBCHgu6mfdcPEK8Am65n+kdZs+7zGJgFz//79OFhfVt3YxHZ4wRQAAAAASUVORK5CYII=","contentType":"image/png","width":27,"height":27,"angle":0,"xoffset":0,"yoffset":0},"value":"Unknown","label":"Unknown"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,233,252,255],"toColor":[184,233,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,251,179,255],"toColor":[252,251,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,250,255],"toColor":[252,179,250,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,200,192,255],"toColor":[252,200,192,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,252,205,255],"toColor":[179,252,205,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,188,252,255],"toColor":[179,188,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,241,212,255],"toColor":[252,241,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[235,215,252,255],"toColor":[235,215,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,187,215,255],"toColor":[252,187,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[215,252,235,255],"toColor":[215,252,235,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[224,252,197,255],"toColor":[224,252,197,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[195,252,179,255],"toColor":[195,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,209,252,255],"toColor":[182,209,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,210,225,255],"toColor":[252,210,225,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,199,252,255],"toColor":[252,199,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,182,255],"toColor":[252,215,182,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GlobalID

Type ID Field: bothsidesstatus

Fields:

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 ...)
utilstatus (type: esriFieldTypeSmallInteger, alias: Utility Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Lead], [2: Non-Lead], ... 1 more ...)
custstatus (type: esriFieldTypeSmallInteger, alias: Customer Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Lead], [2: Non-Lead], ... 1 more ...)
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], ... 10 more ...)
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], ... 10 more ...)
OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
FileNumber (type: esriFieldTypeString, alias: File Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
Stub (type: esriFieldTypeString, alias: Stub, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
LinkID (type: esriFieldTypeString, alias: Link ID, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Owner (type: esriFieldTypeString, alias: Owned By, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Kent: Kent Water], [Soos Creek: Soos Creek Water District], [Highline: Highline Water District], ... 9 more ...)
Maint (type: esriFieldTypeString, alias: Maintained By, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Kent: Kent Water], [Soos Creek: Soos Creek Water District], [Highline: Highline Water District], ... 9 more ...)
InstallDate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
WarrantyDate (type: esriFieldTypeDate, alias: Warranty Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
LifecycleStatus (type: esriFieldTypeString, alias: Lifecycle Status, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Active: Active], [Abandoned: Abandoned], [Removed: Removed], ... 5 more ...)
OrigPlan (type: esriFieldTypeString, alias: Original Plan, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
PlanName (type: esriFieldTypeString, alias: Plan Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
RefPlan (type: esriFieldTypeString, alias: Reference Plan, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
Source (type: esriFieldTypeString, alias: Source, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [As-built: As-built], [Field Identified: Field Identified], [Imagery: Imagery], ... 3 more ...)
SpatialConf (type: esriFieldTypeSmallInteger, alias: Spatial Confidence, SQL Type: sqlTypeOther, nullable: true, editable: true)
DocLink (type: esriFieldTypeString, alias: Document Link, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AssetNotes (type: esriFieldTypeString, alias: Asset Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
OtherNotes (type: esriFieldTypeString, alias: Other Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AssetID (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
LegacyID (type: esriFieldTypeString, alias: Legacy ID, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
GISID_Old (type: esriFieldTypeInteger, alias: GISID_Old, SQL Type: sqlTypeOther, nullable: true, editable: true)
PurchaseCost (type: esriFieldTypeDouble, alias: Purchase Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
CostCenter (type: esriFieldTypeString, alias: Cost Center, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
Condition (type: esriFieldTypeSmallInteger, alias: Condition, SQL Type: sqlTypeOther, nullable: true, editable: true)
ConditionDate (type: esriFieldTypeDate, alias: Condition Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
ServiceLife (type: esriFieldTypeSmallInteger, alias: Service Life, SQL Type: sqlTypeOther, nullable: true, editable: true)
COF (type: esriFieldTypeSmallInteger, alias: COF, SQL Type: sqlTypeOther, nullable: true, editable: true)
POF (type: esriFieldTypeSmallInteger, alias: POF, SQL Type: sqlTypeOther, nullable: true, editable: true)
BRE (type: esriFieldTypeSmallInteger, alias: BRE, SQL Type: sqlTypeOther, nullable: true, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
accountid (type: esriFieldTypeString, alias: Account ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
address1 (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
location1 (type: esriFieldTypeString, alias: Other Location Identifier, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
sensitivepop (type: esriFieldTypeString, alias: Sensitive Population, SQL Type: sqlTypeOther, length: 255, 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: 255, 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)
everlead (type: esriFieldTypeString, alias: Ever Lead?, SQL Type: sqlTypeOther, length: 255, 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)
utilinstalldate_text (type: esriFieldTypeString, alias: Utility Install Date, SQL Type: sqlTypeOther, length: 255, 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: 255, 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)
utilnotes (type: esriFieldTypeString, alias: Utility Side Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
custassetid (type: esriFieldTypeString, alias: Customer Asset ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
custinstalldate (type: esriFieldTypeDate, alias: Customer Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
custinstalldate_text (type: esriFieldTypeString, alias: Customer Install Date, SQL Type: sqlTypeOther, length: 255, 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: 255, 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)
custnotes (type: esriFieldTypeString, alias: Customer Side Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
leadconnector (type: esriFieldTypeString, alias: Lead Connector, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
leadsolder (type: esriFieldTypeString, alias: Lead Solder, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
otherfittings (type: esriFieldTypeString, alias: Other Fittings Containing Lead, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
buildingtype (type: esriFieldTypeString, alias: Building Type, SQL Type: sqlTypeOther, length: 255, 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: 255, 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: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
samplingsite (type: esriFieldTypeString, alias: Current LCR Sampling Site, SQL Type: sqlTypeOther, length: 255, 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)
utildiameter_text (type: esriFieldTypeString, alias: Utility Diameter, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
custdiameter_text (type: esriFieldTypeString, alias: Customer Diameter, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
RadioRead (type: esriFieldTypeString, alias: Radio Read, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])

Types:

Field Name: bothsidesstatus
Inherited
Field Name: utilstatus
Inherited
Field Name: custstatus
Inherited
Field Name: utilmaterial
Inherited
Field Name: custmaterial
Inherited
Field Name: Owner
Inherited
Field Name: Maint
Inherited
Field Name: LifecycleStatus
Inherited
Field Name: Source
Inherited
Field Name: sensitivepop
Inherited
Field Name: disadvantaged
Inherited
Field Name: everlead
Inherited
Field Name: utildiameter
Inherited
Field Name: utilsource
Inherited
Field Name: utilverified
Inherited
Field Name: utilverifmethod
Inherited
Field Name: custdiameter
Inherited
Field Name: custsource
Inherited
Field Name: custverified
Inherited
Field Name: custverifmethod
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
Field Name: RadioRead
Inherited

bothsidesstatus: Galvanized Requiring Replacement
utilstatus: 2
custstatus: 2
utilmaterial: Non-Lead - Polyethylene
custmaterial: Non-Lead - Unknown
Owner: Kent
Maint: Kent
LifecycleStatus: Active
utilsource: Installation date is after the lead ban
custsource: Installation date is after the lead ban

Field Name: bothsidesstatus
Inherited
Field Name: utilstatus
Inherited
Field Name: custstatus
Inherited
Field Name: utilmaterial
Inherited
Field Name: custmaterial
Inherited
Field Name: Owner
Inherited
Field Name: Maint
Inherited
Field Name: LifecycleStatus
Inherited
Field Name: Source
Inherited
Field Name: sensitivepop
Inherited
Field Name: disadvantaged
Inherited
Field Name: everlead
Inherited
Field Name: utildiameter
Inherited
Field Name: utilsource
Inherited
Field Name: utilverified
Inherited
Field Name: utilverifmethod
Inherited
Field Name: custdiameter
Inherited
Field Name: custsource
Inherited
Field Name: custverified
Inherited
Field Name: custverifmethod
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
Field Name: RadioRead
Inherited

bothsidesstatus: Lead
utilstatus: 2
custstatus: 2
utilmaterial: Non-Lead - Polyethylene
custmaterial: Non-Lead - Unknown
Owner: Kent
Maint: Kent
LifecycleStatus: Active
utilsource: Installation date is after the lead ban
custsource: Installation date is after the lead ban

Field Name: bothsidesstatus
Inherited
Field Name: utilstatus
Inherited
Field Name: custstatus
Inherited
Field Name: utilmaterial
Inherited
Field Name: custmaterial
Inherited
Field Name: Owner
Inherited
Field Name: Maint
Inherited
Field Name: LifecycleStatus
Inherited
Field Name: Source
Inherited
Field Name: sensitivepop
Inherited
Field Name: disadvantaged
Inherited
Field Name: everlead
Inherited
Field Name: utildiameter
Inherited
Field Name: utilsource
Inherited
Field Name: utilverified
Inherited
Field Name: utilverifmethod
Inherited
Field Name: custdiameter
Inherited
Field Name: custsource
Inherited
Field Name: custverified
Inherited
Field Name: custverifmethod
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
Field Name: RadioRead
Inherited

bothsidesstatus: Non-Lead
utilstatus: 2
custstatus: 2
utilmaterial: Non-Lead - Polyethylene
custmaterial: Non-Lead - Unknown
Owner: Kent
Maint: Kent
LifecycleStatus: Active
utilsource: Installation date is after the lead ban
custsource: Installation date is after the lead ban

Field Name: bothsidesstatus
Inherited
Field Name: utilstatus
Inherited
Field Name: custstatus
Inherited
Field Name: utilmaterial
Inherited
Field Name: custmaterial
Inherited
Field Name: Owner
Inherited
Field Name: Maint
Inherited
Field Name: LifecycleStatus
Inherited
Field Name: Source
Inherited
Field Name: sensitivepop
Inherited
Field Name: disadvantaged
Inherited
Field Name: everlead
Inherited
Field Name: utildiameter
Inherited
Field Name: utilsource
Inherited
Field Name: utilverified
Inherited
Field Name: utilverifmethod
Inherited
Field Name: custdiameter
Inherited
Field Name: custsource
Inherited
Field Name: custverified
Inherited
Field Name: custverifmethod
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
Field Name: RadioRead
Inherited

bothsidesstatus: Unknown
utilstatus: 2
custstatus: 2
utilmaterial: Non-Lead - Polyethylene
custmaterial: Non-Lead - Unknown
Owner: Kent
Maint: Kent
LifecycleStatus: Active
utilsource: Installation date is after the lead ban
custsource: Installation date is after the lead ban

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/6/2025 9:31:34 PM

Schema Last Edit Date: 6/6/2025 9:31:34 PM

Data Last Edit Date: 6/6/2025 9:31:34 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Generate Renderer Validate SQL Get Estimates ConvertFormat