Name: Service Line (Utility Status | Customer Status)

Display Field: TTRRSS

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:

XMin: -8923409.7947
YMin: 2979774.0188
XMax: -8921744.4649
YMax: 2981138.3405
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,0,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"$feature.LSLI_ID","title":"Unverified Service Lines"},"labelPlacement":"esriServerPointLabelPlacementAboveCenter","deconflictionStrategy":"static","allowOverlapOfFeatureInterior":"avoid","offsetDistance":0,"stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"useCodedValues":true,"maxScale":0,"minScale":0,"name":"Class 1","priority":4,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":-2,"yoffset":0,"kerning":true,"haloColor":[255,255,255,255],"haloSize":1,"font":{"family":"Arial","size":5,"style":"normal","weight":"normal","decoration":"none"}}}]}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID_12, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• PID (type: esriFieldTypeInteger, alias: PID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LSLI_ID (type: esriFieldTypeString, alias: Unique Service Line ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TTRRSS (type: esriFieldTypeString, alias: TTRRSS, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• FOLIO (type: esriFieldTypeString, alias: FOLIO, SQL Type: sqlTypeOther, length: 13, nullable: true, editable: true)
• ADDRESS (type: esriFieldTypeString, alias: Street Address, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ISLAND (type: esriFieldTypeString, alias: ISLAND, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DESCRIPTIO (type: esriFieldTypeString, alias: DESCRIPTIO, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• utilstatus (type: esriFieldTypeInteger, alias: System Status, SQL Type: sqlTypeOther, nullable: true, editable: true)
• custstatus (type: esriFieldTypeInteger, alias: custstatus, SQL Type: sqlTypeOther, nullable: true, editable: true)
• X (type: esriFieldTypeDouble, alias: X Coordinates, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Y (type: esriFieldTypeDouble, alias: Y Coordinates, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SENS_POP (type: esriFieldTypeString, alias: Sensitive Population?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DISAD (type: esriFieldTypeString, alias: Disadvantaged Neighborhood?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SOP_SLC (type: esriFieldTypeString, alias: System-Owned Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PREV_Pb (type: esriFieldTypeString, alias: Was System Material Ever Previously Lead?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SIZE_S (type: esriFieldTypeInteger, alias: System Service Line Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BAS_CLAS (type: esriFieldTypeInteger, alias: System Basis of Material Classification, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FIELD_S (type: esriFieldTypeString, alias: Was the System Service Line Material Field Verified?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FV_MET_S (type: esriFieldTypeInteger, alias: FV_MET_S, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FV_DAT_S (type: esriFieldTypeInteger, alias: FV_DAT_S, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SOP_NOTE (type: esriFieldTypeString, alias: Notes (Customer), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• COP_SLC (type: esriFieldTypeString, alias: Customer-Owned Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• INS_DAT_C (type: esriFieldTypeString, alias: Customer Service Line Installation Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SIZE_C (type: esriFieldTypeString, alias: Customer Service Line Size, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BAS_CLAS_C (type: esriFieldTypeString, alias: Customer Basis of Material Classification, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FIELD_C (type: esriFieldTypeString, alias: Was the Customer Service Line Material Field Verified?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FV_MET_C (type: esriFieldTypeInteger, alias: FV_MET_C, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FV_DAT_C (type: esriFieldTypeString, alias: FV_DAT_C, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• COP_NOTE (type: esriFieldTypeString, alias: Notes (Customer), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLC (type: esriFieldTypeString, alias: Entire Service Line Material Classification, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Pb_con (type: esriFieldTypeString, alias: Is there a Lead Connector?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Pb_solder (type: esriFieldTypeString, alias: Is there Lead Solder in the Service Line?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Pb_fitt (type: esriFieldTypeString, alias: Pb_fitt, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Bldg_type (type: esriFieldTypeString, alias: Building Type Connected to Service Line, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• POE_PUT (type: esriFieldTypeString, alias: POE_PUT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• INTER_Pb (type: esriFieldTypeString, alias: INTER_Pb, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SAM_SITE (type: esriFieldTypeString, alias: Current LCR Sampling Site?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• COORD (type: esriFieldTypeString, alias: Coordinates, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• INS_DAT_S (type: esriFieldTypeString, alias: System Service Line Installation Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Name: Lead | Lead
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 1
• custstatus: 1
Name: Lead | Galvanized Requiring Replacement
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 1
• custstatus: 3
Name: Lead | Non-Lead
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 1
• custstatus: 2
Name: Lead | Unknown
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 1
• custstatus: 0
Name: Galvanized Requiring Replacement | Lead
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 3
• custstatus: 1
Name: Galvanized Requiring Replacement | Galvanized Requiring Replacement
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 3
• custstatus: 3
Name: Galvanized Requiring Replacement | Non-Lead
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 3
• custstatus: 2
Name: Galvanized Requiring Replacement | Unknown
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 3
• custstatus: 0
Name: Non-Lead | Lead
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 2
• custstatus: 1
Name: Non-Lead | Galvanized Requiring Replacement
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 2
• custstatus: 3
Name: Non-Lead | Non-Lead
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 2
• custstatus: 2
Name: Non-Lead | Unknown
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 2
• custstatus: 0
Name: Unknown | Lead
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 0
• custstatus: 1
Name: Unknown | Galvanized Requiring Replacement
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 0
• custstatus: 3
Name: Unknown | Non-Lead
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 0
• custstatus: 2
Name: Unknown | Unknown
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• utilstatus: 0
• custstatus: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/22/2024 4:38:49 PM

Schema Last Edit Date: 11/22/2024 4:38:49 PM

Data Last Edit Date: 11/22/2024 4:17:25 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat