Layers:

Layer: service line (55)


Name: service line

Display Field: property_id

Type: Feature Layer

Geometry Type: esriGeometryPolyline

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: -8285692.2581
YMin: 4933635.8826
XMax: -8260699.9538
YMax: 4955407.4035
Spatial Reference: 102100 (3857)


Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[63,130,135,255],"width":1}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

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, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• id (type: esriFieldTypeGUID, alias: id, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• property_id (type: esriFieldTypeGUID, alias: Property ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• external_id (type: esriFieldTypeString, alias: External ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• service_line_type_id (type: esriFieldTypeSmallInteger, alias: Service Line Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [11: Residential Service], [12: Commercial Service], ... 7 more ...)
• service_line_side (type: esriFieldTypeString, alias: Service Line Side, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Utility: Utility], [Private: Private])
• material (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AC: Asbestos Cement], [BR: Brass], [CI: Cast Iron], ... 19 more ...)
• method_id (type: esriFieldTypeString, alias: Material Method, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [R: Records], [F: Field Inspection], [V: Records Validation], ... 5 more ...)
• material_source (type: esriFieldTypeString, alias: Material Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• is_inspection_required (type: esriFieldTypeString, alias: Inspection Required, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No], [U: Unknown])
• diameter (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• tap_size (type: esriFieldTypeDouble, alias: Tap Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
• connector_material (type: esriFieldTypeString, alias: Connector Material, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [LD: Lead], [CU: Copper], [PL: Plastic], ... 4 more ...)
• connector_material_source (type: esriFieldTypeString, alias: Connector Material Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• is_previously_lead (type: esriFieldTypeString, alias: Previously Lead, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No], [U: Unknown])
• previous_lead_source (type: esriFieldTypeString, alias: Previous Lead Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• contains_lead_solder (type: esriFieldTypeString, alias: Contains Lead Solder, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No], [U: Unknown])
• installation_date (type: esriFieldTypeDate, alias: Installation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• length (type: esriFieldTypeDouble, alias: Length (ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
• water_main_diameter (type: esriFieldTypeDouble, alias: Water Main Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• contract_id (type: esriFieldTypeGUID, alias: Contract ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• start_date (type: esriFieldTypeDate, alias: Start Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• end_date (type: esriFieldTypeDate, alias: End Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• properties (type: esriFieldTypeString, alias: Properties, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• other_fittings_containing_lead (type: esriFieldTypeString, alias: Other Fittings Containing Lead, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lifecycle_status (type: esriFieldTypeSmallInteger, alias: Lifecycle Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Proposed], [8: In Service], ... 4 more ...)
• MSEXID (type: esriFieldTypeString, alias: MSEXID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: service line
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• service_line_type_id: 0
• material: UNK
• method_id: R
• is_inspection_required: U
• connector_material: UNK
• is_previously_lead: U
• contains_lead_solder: U
• lifecycle_status: 8

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/31/2024 3:45:02 PM

Schema Last Edit Date: 5/31/2024 3:45:02 PM

Data Last Edit Date: 1/25/2024 3:06:14 PM