Name: serviceline_utility_point:serviceline_utility_point

Display Field: external_id

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: -9184458.99057224
YMin: 3446964.96247137
XMax: -9151841.88929613
YMax: 3473620.21918091
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"temp_symbl","defaultSymbol":{"type":"esriSMS","style":"esriSMSCircle","color":[130,130,130,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"defaultLabel":"","uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[230,0,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"Galvanized","label":"Galvanized"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[240,226,139,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"Non-lead","label":"Non-lead"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[130,130,130,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"Unknown","label":"Unknown"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[79,64,153,255],"toColor":[79,64,153,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[95,227,122,255],"toColor":[95,227,122,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[201,102,75,255],"toColor":[201,102,75,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[130,210,232,255],"toColor":[130,210,232,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[219,210,83,255],"toColor":[219,210,83,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[217,111,172,255],"toColor":[217,111,172,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[119,128,79,255],"toColor":[119,128,79,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[131,161,242,255],"toColor":[131,161,242,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[207,118,245,255],"toColor":[207,118,245,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[84,107,128,255],"toColor":[84,107,128,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[247,196,166,255],"toColor":[247,196,166,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[140,81,95,255],"toColor":[140,81,95,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[72,171,136,255],"toColor":[72,171,136,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

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:

Type ID Field: temp_symbl

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)
• service_line_side (type: esriFieldTypeString, alias: Service Line Side, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• material (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• method_id (type: esriFieldTypeString, alias: Material Method, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• 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)
• 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)
• 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)
• 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)
• 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)
• temp_symbl (type: esriFieldTypeString, alias: temp_symbl, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ORIG_FID (type: esriFieldTypeInteger, alias: ORIG_FID, SQL Type: sqlTypeOther, nullable: true, editable: true)

Types:

ID: Galvanized
Name: Galvanized
Domains:

Templates:

Name: Galvanized
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

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

---

ID: Non-lead
Name: Non-lead
Domains:

Templates:

Name: Non-lead
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• lifecycle_status: 8
• contains_lead_solder: U
• service_line_type_id: 0
• material: UNK
• method_id: R
• is_inspection_required: U
• connector_material: UNK
• is_previously_lead: U
• temp_symbl: Non-lead

---

ID: Unknown
Name: Unknown
Domains:

Templates:

Name: Unknown
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

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

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/30/2023 4:17:41 PM

Schema Last Edit Date: 5/30/2023 4:17:41 PM

Data Last Edit Date: 5/30/2023 4:17:41 PM

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