Name: Service_Connection

Display Field: AccountID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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: 1135105.98737372
YMin: 803382.6051559
XMax: 1256828.3613579
YMax: 1767527.06883752
Spatial Reference: 102656 (2234)

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":null}

HasZ: false

HasM: false

Has Attachments: true

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:

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: 10, nullable: true, editable: true)
• PWSID (type: esriFieldTypeString, alias: PWSID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SITE_ID (type: esriFieldTypeString, alias: SITE ID, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• LOCATION_IDENTIFIER (type: esriFieldTypeString, alias: LOCATION IDENTIFIER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• STREET_ADDRESS (type: esriFieldTypeString, alias: STREET ADDRESS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TOWN (type: esriFieldTypeString, alias: TOWN, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Windham: Windham], [Mansfield: Mansfield])
• STATE (type: esriFieldTypeString, alias: STATE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CT: CT])
• CONNECTOR_OR_GOOSENECK_MATERIAL (type: esriFieldTypeString, alias: CONNECTOR OR GOOSENECK MATERIAL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CL: CONFIRMED LEAD], [CC: CONFIRMED COPPER], [PL: PLASTIC], ... 5 more ...)
• CONNECTOR_OR_GOOSENECK_MATERI_1 (type: esriFieldTypeSmallInteger, alias: CONNECTOR OR GOOSENECK MATERIAL INSTALL YEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WAS_CONNECTOR_OR_GOOSENECK_PREV (type: esriFieldTypeString, alias: WAS CONNECTOR OR GOOSENECK PREVIOUSLY LEAD?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Y: YES - KNOWN WITH CERTAINTY], [N: NO - KNOWN WITH CERTAINTY], [U: NOT KNOWN WITH CERTAINTY])
• SYSTEM_SERVICE_LINE_MATERIAL (type: esriFieldTypeString, alias: SYSTEM SERVICE LINE MATERIAL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CL: Confirmed Lead], [CC: Confirmed Copper], [CG: Confirmed Galvanized], ... 8 more ...)
• WAS_SYSTEM_SERVICE_LINE_MATERIA (type: esriFieldTypeString, alias: WAS SYSTEM SERVICE LINE MATERIAL EVER PREVIOUSLY LEAD?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Y: YES - KNOWN WITH CERTAINTY], [N: NO - KNOWN WITH CERTAINTY], [U: NOT KNOWN WITH CERTAINTY])
• SYSTEM_SERVICE_LINE_DIAMETER__I (type: esriFieldTypeString, alias: SYSTEM SERVICE LINE DIAMETER (INCHES), SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [O: OTHER], [1: 1 INCH], [3/8: 0.375 INCHES], ... 15 more ...)
• SYSTEM_SERVICE_LINE_INSTALL_YEA (type: esriFieldTypeSmallInteger, alias: SYSTEM SERVICE LINE INSTALL YEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SYSTEM_VERIFICATION_DATE (type: esriFieldTypeDate, alias: SYSTEM VERIFICATION DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SYSTEM_VERIFICATION_SOURCE (type: esriFieldTypeString, alias: SYSTEM VERIFICATION SOURCE, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [RO: Records Only], [FI: Field Inspection Only], [RV: Records Validation], ... 9 more ...)
• IS_SYSTEM_SERVICE_LINE_REPLACEM (type: esriFieldTypeString, alias: IS SYSTEM SERVICE LINE REPLACEMENT REQUIRED?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No], [U: Unknown])
• CUSTOMER_SERVICE_LINE_MATERIAL (type: esriFieldTypeString, alias: CUSTOMER SERVICE LINE MATERIAL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CL: Confirmed Lead], [CC: Confirmed Copper], [GR: Galvanized Requiring Replacement], ... 9 more ...)
• CUSTOMER_SERVICE_LINE_DIAMETER_ (type: esriFieldTypeString, alias: CUSTOMER SERVICE LINE DIAMETER (INCHES), SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [O: OTHER], [1: 1 INCH], [3/8: 0.375 INCHES], ... 15 more ...)
• CUSTOMER_SERVICE_LINE_INSTALL_Y (type: esriFieldTypeSmallInteger, alias: CUSTOMER SERVICE LINE INSTALL YEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CUSTOMER_SIDE_VERIFICATION_DATE (type: esriFieldTypeDate, alias: CUSTOMER SIDE VERIFICATION DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CUSTOMER_SIDE_VERIFICATION_SOUR (type: esriFieldTypeString, alias: CUSTOMER SIDE VERIFICATION SOURCE, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [RO: Records Only], [FI: Field Inspection Only], [RV: Records Validation], ... 9 more ...)
• IS_CUSTOMER_SERVICE_LINE_REPLAC (type: esriFieldTypeString, alias: IS CUSTOMER SERVICE LINE REPLACEMENT REQUIRED?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No], [U: Unknown])
• ENTIRE_SERVICE_LINE_MATERIAL_CL (type: esriFieldTypeString, alias: ENTIRE SERVICE LINE MATERIAL CLASSIFICATION, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [LEAD: LEAD], [NL: NON-LEAD], [LSU: LEAD STATUS UNKNOWN], ... 1 more ...)
• IS_THERE_LEAD_SOLDER_IN_SERVICE (type: esriFieldTypeString, alias: IS THERE LEAD SOLDER IN SERVICE LINE?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• BUILDING_TYPE (type: esriFieldTypeString, alias: BUILDING TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [SF: SINGLE-FAMILY], [MF: MULTI-FAMILY], [SCH/CC: SCHOOL/CHILD CARE], ... 4 more ...)
• NO_OF_SERVICE_CONNECTIONS_SERVE (type: esriFieldTypeString, alias: NO OF SERVICE CONNECTIONS SERVED BY SERVICE LINE, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [0: 0], [1: 1], [2: 2], ... 9 more ...)
• POINT_OF_ENTRY_OR_POINT_OF_USE_ (type: esriFieldTypeString, alias: POINT-OF-ENTRY OR POINT-OF-USE TREATMENT PRESENT, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Y: YES - KNOWN WITH CERTAINTY], [N: NO - KNOWN WITH CERTAINTY], [U: NOT KNOWN WITH CERTAINTY])
• BUILDING_PLUMBING_MATERIAL_1 (type: esriFieldTypeString, alias: BUILDING PLUMBING MATERIAL 1, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CL: CONFIRMED LEAD], [CC: CONFIRMED COPPER], [CLS: COPPER W/LEAD SOLDER], ... 4 more ...)
• BUILDING_PLUMBING_MATERIAL_2 (type: esriFieldTypeString, alias: BUILDING PLUMBING MATERIAL 2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CL: CONFIRMED LEAD], [CC: CONFIRMED COPPER], [CLS: COPPER W/LEAD SOLDER], ... 4 more ...)
• BUILDING_PLUMBING_MATERIAL_INST (type: esriFieldTypeInteger, alias: BUILDING PLUMBING MATERIAL INSTALLED DATE, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Before 1987], [2: Between 1987 and 2014], [3: After 2014], ... 1 more ...)
• BUILDING_PLUMBING_VERIFICATION_ (type: esriFieldTypeDate, alias: BUILDING PLUMBING VERIFICATION DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• BUILDING_PLUMBING_VERIFICATION1 (type: esriFieldTypeString, alias: BUILDING PLUMBING VERIFICATION SOURCE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [RO: Records Only], [FI: Field Inspection Only], [RV: Records Validation], ... 9 more ...)
• CURRENT_LCR_SAMPLING_SITE (type: esriFieldTypeString, alias: CURRENT LCR SAMPLING SITE?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LCRR_SAMPLE_SITE (type: esriFieldTypeString, alias: LCRR SAMPLE SITE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SAMPLE_SITE_TIER_LEVEL (type: esriFieldTypeString, alias: SAMPLE SITE TIER LEVEL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Tier 1: Single-family structures (SFSs) served by known lead service lines (LSLs). Multiple-family residences (MFRs) served by LSLs represent at least 20% of the structures served by the water system.], [Tier 2: Buildings and MFRs served by known LSLs], [Tier 3: SFSs with galvanized service line down-stream of a known LSL, currently or in the past or known to be downstream of a lead gooseneck or connector.], ... 2 more ...)
• SAMPLING_POINT_ID (type: esriFieldTypeString, alias: SAMPLING POINT ID, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• COMMENTS (type: esriFieldTypeString, alias: COMMENTS, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• 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)
• YearBuilt_Int (type: esriFieldTypeSmallInteger, alias: Year Built (integer), SQL Type: sqlTypeOther, nullable: true, editable: true)
• DisadvNbhd (type: esriFieldTypeString, alias: Disadvantaged Neighborhood?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• OtherFittings (type: esriFieldTypeString, alias: Is there other fittings/equipment connected that contain lead?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• ReplacementDate (type: esriFieldTypeDate, alias: Replacement Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ReplacementMaterial (type: esriFieldTypeString, alias: Customer-Side Replacement Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CP: Copper], [PL: Plastic], [DI: Ductile Iron], ... 3 more ...)
• SystemSideVerifiedMaterial (type: esriFieldTypeString, alias: System Side Verified Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CL: Confirmed Lead], [CC: Confirmed Copper], [CG: Confirmed Galvanized], ... 5 more ...)
• CustomerSideVerifiedMaterial (type: esriFieldTypeString, alias: CustomerSideVerifiedMaterial, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CL: Confirmed Lead], [CC: Confirmed Copper], [GR: Confirmed Galvanized Requiring Replacement], ... 6 more ...)
• CustomerInitiatedLSLRDate (type: esriFieldTypeDate, alias: Customer Initiated LSLR Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CustomerInitiatedLSLRExtension (type: esriFieldTypeDate, alias: CustomerInitiated LSLR Extension Deadline, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CustomerRefusals (type: esriFieldTypeString, alias: Customer Refusals and Non-Responses, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [RF: Customer Refusal], [1A: First Attempt No Response], [2A: Second Attempt No Response], ... 2 more ...)
• MeterType (type: esriFieldTypeString, alias: Meter Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FireServiceLine (type: esriFieldTypeString, alias: Fire Service Line Present, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• TypeOfBackflow (type: esriFieldTypeString, alias: TypeOfBackflow, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [RPD: RPD], [DCV: DCV], [None: None])
• FireServiceDiameter (type: esriFieldTypeString, alias: Fire Service Diameter, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [O: OTHER], [1: 1 INCH], [3/8: 0.375 INCHES], ... 15 more ...)
• FireServiceMaterial (type: esriFieldTypeString, alias: Fire Service Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CL: Confirmed Lead], [CC: Confirmed Copper], [CG: Confirmed Galvanized], ... 8 more ...)
• FireServiceComments (type: esriFieldTypeString, alias: Fire Service Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Lat (type: esriFieldTypeDouble, alias: Lat, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Lon (type: esriFieldTypeDouble, alias: Lon, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RightTieIn (type: esriFieldTypeString, alias: Right Tie In, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LeftTieIn (type: esriFieldTypeString, alias: Left Tie In, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LengthofService (type: esriFieldTypeString, alias: Length of Service, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Owner (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Town: Town], [State: State], [Private: Private], ... 1 more ...)
• DepthofPipe (type: esriFieldTypeString, alias: Depth of Pipe, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 1000000000, nullable: true, editable: true)
• ReplacementPriority (type: esriFieldTypeSmallInteger, alias: Replacement Priority, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LocationNumber (type: esriFieldTypeString, alias: Location Number (UMS), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UtilitySideReplacementMaterial (type: esriFieldTypeString, alias: Utility-Side Replacement Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CP: Copper], [PL: Plastic], [DI: Ductile Iron], ... 3 more ...)

Templates:

Name: Tie Card
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• TOWN: Windham
• STATE: CT
• BUILDING_PLUMBING_MATERIAL_INST: 4
• FireServiceLine: N

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/6/2026 2:00:55 PM

Schema Last Edit Date: 10/6/2026 2:00:55 PM

Data Last Edit Date: 10/6/2026 2:00:55 PM

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