Name: COJ_ServiceMaterialLocations
Display Field: HIST_ID
Type: Feature Layer
Geometry Type: esriGeometryPoint
Has Views: true
Source Schema Changes Allowed: true
Views
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: 994690.657539182
YMin: 1737461.86240266
XMax: 1077571.094575
YMax: 1794655.08801543
Spatial Reference: 102671 (3435)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"74b5d1a199ed99142864dcbdd96c9403","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAcAAAAHCAYAAADEUlfTAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAsElEQVQImWNhgAAJBgYGdwYGJiMGhn//GBgYCkGCLCAJRkaWKXzC5gFc/GrM3z7dYvj45rg3w/9/aiBJdwFRWwshKTdmkGouXjWGv78/K3/5cCmeBWQUK4eINNR4MODiU2f68uGKEQsDw79nP78/Y+BlMIJL/vz27C8Dw79zIGM7P749YczAwBDMzinF9O3Tzb9fP147wcDAsBMkycDw72/Yx9dH46GuPQeSYGBgeAEAWOs3Qxi1ru4AAAAASUVORK5CYII=","contentType":"image/png","width":5,"height":5,"angle":0,"xoffset":0,"yoffset":0}},"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:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- AddressNum (type: esriFieldTypeString, alias: AddressNum, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- AddressPreDir (type: esriFieldTypeString, alias: AddressPreDir, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Street (type: esriFieldTypeString, alias: Street, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- StreetType (type: esriFieldTypeString, alias: StreetType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- StreetPostDir (type: esriFieldTypeString, alias: StreetPostDir, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- StreetAddress (type: esriFieldTypeString, alias: Street Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ProjectReplacement (type: esriFieldTypeString, alias: Project Replaced, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Phase 1 LSLR: Phase 1 LSLR], [Phase 2A LSLR: Phase 2A LSLR], [Phase 2B LSLR: Phase 2B LSLR], ... 8 more ...)
- NewPublicMaterial (type: esriFieldTypeString, alias: New Public Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Copper: Copper], [Ductile Iron: Ductile Iron], [Unknown: Unknown], ... 8 more ...)
- NewPubDate (type: esriFieldTypeDate, alias: New Public Material Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- NewPubSource (type: esriFieldTypeString, alias: New Public Material Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Visual: Visual Inspection], [Home: Home Age], [Construction: Construction Record])
- NewPrivateMaterial (type: esriFieldTypeString, alias: New Private Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Copper: Copper], [Ductile Iron: Ductile Iron], [Unknown: Unknown], ... 8 more ...)
- NewPrivInstallDate (type: esriFieldTypeDate, alias: New Private Material Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- NewPrivSource (type: esriFieldTypeString, alias: New Private Material Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Visual: Visual Inspection], [Home: Home Age], [Construction: Construction Record])
- OriginalPublicMaterial (type: esriFieldTypeString, alias: Original Public Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Copper: Copper], [Ductile Iron: Ductile Iron], [Unknown: Unknown], ... 8 more ...)
- OriginalPubInstallDate (type: esriFieldTypeDate, alias: Original Public Material Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- OriginalPubInspectionDate (type: esriFieldTypeDate, alias: Original Public Material Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- OriginalPubSource (type: esriFieldTypeString, alias: Original Public Material Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Visual: Visual Inspection], [Home: Home Age], [Construction: Construction Record])
- OriginalPrivateMaterial (type: esriFieldTypeString, alias: Original Private Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Copper: Copper], [Ductile Iron: Ductile Iron], [Unknown: Unknown], ... 8 more ...)
- OriginalPrivInsallDate (type: esriFieldTypeDate, alias: Original Private Material Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- OriginalPrivateInspectionDate (type: esriFieldTypeDate, alias: Original Private Material Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- OriginalPrivSource (type: esriFieldTypeString, alias: Original Private Material Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Visual: Visual Inspection], [Home: Home Age], [Construction: Construction Record])
- WithinLeadBoundary (type: esriFieldTypeString, alias: Within Suspected Lead Boundary, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- PropertyBuilt (type: esriFieldTypeString, alias: Year Property Built, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- High_Risk_Facility (type: esriFieldTypeString, alias: High-Risk Facility, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- Disadvantaged (type: esriFieldTypeString, alias: Disadvantaged, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- Access (type: esriFieldTypeString, alias: Access Refused, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- Lead_Notification (type: esriFieldTypeDate, alias: Lead Service Notification Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Waiver_IDPH_Notification (type: esriFieldTypeDate, alias: Waiver or IDPH Notification Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- LeadSolder (type: esriFieldTypeString, alias: Copper/Assumed Lead Solder, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- CreationDate_1 (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Creator_1 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
- EditDate_1 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Editor_1 (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
- Lead_2018_Earlier (type: esriFieldTypeDouble, alias: Lead_2018_Earlier, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
- HighRiskCategory (type: esriFieldTypeString, alias: HighRiskCategory, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [School: School], [Park: Park], [Child Care Facility: Child Care Facility], ... 6 more ...)
- HighRiskName (type: esriFieldTypeString, alias: HighRiskName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- VALVE_OID (type: esriFieldTypeInteger, alias: VALVE_OID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- AccountNum (type: esriFieldTypeDouble, alias: AccountNum, SQL Type: sqlTypeOther, nullable: true, editable: true)
- WaterMainYear (type: esriFieldTypeString, alias: WaterMainYear, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [2025: 2025], [2026: 2026], [2027: 2027], ... 7 more ...)
- SampleSiteID (type: esriFieldTypeString, alias: SampleSiteID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
Templates:
Name: COJ_ServiceMaterialLocations
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- High_Risk_Facility: No
- Enabled: 1
- NewPubSource: Home
- NewPrivSource: Home
- OriginalPubSource: Home
- OriginalPrivSource: Home
- Disadvantaged: No
- Access: No
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 5/23/2025 12:54:02 PM
Schema Last Edit Date: 5/23/2025 12:54:02 PM
Data Last Edit Date: 5/23/2025 12:54:02 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