Name: WaterServiceAccounts

Display Field: UPROPID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 577791

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 393642.25947883
YMin: 453823.67460303
XMax: 521379.024346994
YMax: 584860.336738074
Spatial Reference: 102711 (3424)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"color":[255,0,197,128],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,255],"width":0.9975,"type":"esriSLS","style":"esriSLSSolid"}}},"transparency":0}

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: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• UPROPID (type: esriFieldTypeInteger, alias: UPROPID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ServiceLocation (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• city (type: esriFieldTypeString, alias: city, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Ewing: Ewing], [Hamilton: Hamilton], [Lawrence: Lawrence], ... 5 more ...)
• Observed_HO_Material (type: esriFieldTypeString, alias: SurveyedHO_MatInterior, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [COPPER: COPPER], [PLASTIC: PLASTIC], [LEAD: LEAD], ... 7 more ...)
• PreConstruct_HO_MATERIAL (type: esriFieldTypeString, alias: HO Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [COPPER: COPPER], [PLASTIC: PLASTIC], [LEAD: LEAD], ... 9 more ...)
• PreConstuct_TWW_MATERIAL (type: esriFieldTypeString, alias: TWWCombined, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [COPPER: COPPER], [PLASTIC: PLASTIC], [LEAD: LEAD], ... 9 more ...)
• PreConstructionInspectedTWWMate (type: esriFieldTypeString, alias: ContractorObsMaterialTWW, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [COPPER: COPPER], [PLASTIC: PLASTIC], [LEAD: LEAD], ... 7 more ...)
• PreconstructionInspectedHOMater (type: esriFieldTypeString, alias: ContractObsMatHOEx, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [COPPER: COPPER], [PLASTIC: PLASTIC], [LEAD: LEAD], ... 7 more ...)
• TWW_Replaced_YorN (type: esriFieldTypeString, alias: TWW_Replaced_YorN, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [YES: YES], [NO: NO], [DNC: DNC], ... 1 more ...)
• HO_Replaced_YorN (type: esriFieldTypeString, alias: HO_Replaced_YorN, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [YES: YES], [NO: NO])
• ConfirmedResponse (type: esriFieldTypeString, alias: Response, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes - Owner Replacement: Yes - Participate in replacement program], [Decline owner Replacement: Decline - Participation in replacement program], [No - Line has already been replaced: No - Line has already been replaced], ... 3 more ...)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• TWWFinalMat (type: esriFieldTypeString, alias: TWWFinalMat, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [COPPER: COPPER], [PLASTIC: PLASTIC], [LEAD: LEAD], ... 8 more ...)
• HOFinalMat (type: esriFieldTypeString, alias: HOFinalMat, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [COPPER: COPPER], [PLASTIC: PLASTIC], [LEAD: LEAD], ... 10 more ...)
• TypeInspection (type: esriFieldTypeString, alias: Type of Inspection, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Meter inspection or replacement: Meter inspection or replacement], [Door-to-door materials: Door-to-door materials], [During tap sampling: During tap sampling], ... 6 more ...)
• ContractorOBsHOatMeter (type: esriFieldTypeString, alias: ContractObsMatHOInterior, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [COPPER: COPPER], [PLASTIC: PLASTIC], [LEAD: LEAD], ... 7 more ...)
• PropertyStatus (type: esriFieldTypeString, alias: PropertyStatus, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [CR: Completed Replacement], [Partial Completion - Return for HO side: Partial Completion - Return for HO side], [TPnL: Test Pit completed found no lead], ... 23 more ...)
• ContractNo (type: esriFieldTypeString, alias: ContractNo, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Phase 1A: Phase 1A], [Phase 1B: Phase 1B], [Emergency: Emergency], ... 8 more ...)
• ContractorName (type: esriFieldTypeString, alias: ContractorName, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [South State: South State], [Spiniello: Spiniello], [TWW crew: TWW crew], ... 5 more ...)
• ContractNoHO (type: esriFieldTypeString, alias: ContractNoHO, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Phase 1A: Phase 1A], [Phase 1B: Phase 1B], [Emergency: Emergency], ... 7 more ...)
• ContractorNameHO (type: esriFieldTypeString, alias: ContractorNameHO, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [South State: South State], [Spiniello: Spiniello], [TWW crew: TWW crew], ... 2 more ...)
• FinalInspectMaterial (type: esriFieldTypeString, alias: FinalInspectMaterial, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [COPPER: COPPER], [PLASTIC: PLASTIC], [LEAD: LEAD], ... 6 more ...)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Relationships:

• Relate2MaterialAssumptions (0) -- Related To: Material_Assumptions_AllMunis_KristinsSpreadsheets (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/23/2025 7:23:44 PM

Schema Last Edit Date: 6/23/2025 7:23:44 PM

Data Last Edit Date: 6/23/2025 7:23:44 PM

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