Name: Count of MCL Violations
Display Field: PWS_Name
Type: Feature Layer
Geometry Type: esriGeometryPolygon
Description: Community water system service area boundaries describe the geographic area that receives drinking water from a given community water system. Knowing these boundaries help to connect water system data (such as, compliance status) with water system customers.This dataset contains 44,415 unique service areas across all 50 states. While not 100% comprehensive, these systems cover 99% of all public water system consumers. 42% of systems are sourced from 20 state databases. The remaining systems, those with no state supplied boundary, were modeled using machine learning techniques. This effort used state sourced service areas to train a model on dozens of explanatory variables in order to approximate service areas where none were accessible.This dataset used the 2023 Quarter 4 Safe Drinking Water Information System for establishing the universe of community water systems.For detailed information on this dataset, visit our GitHub repository: https://github.com/USEPA/ORD_SAB_Model
Copyright Text: US EPA
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: -359223.703148777
YMin: 1240819.77688054
XMax: -134023.367911609
YMax: 1536729.7015084
Spatial Reference: 102039 (102039)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[29,167,222,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"$feature.Count_of_MCL","title":"Custom"},"labelPlacement":"esriServerPolygonPlacementAlwaysHorizontal","multiPart":"labelLargest","allowOverrun":true,"deconflictionStrategy":"dynamicNeverRemove","repeatLabel":false,"useClippedGeometry":true,"stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"useCodedValues":true,"maxScale":0,"minScale":0,"name":"Class 1","priority":-1,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,255,255],"haloSize":1,"font":{"family":"Segoe UI Semibold","size":8,"style":"normal","weight":"normal","decoration":"none"}}}]}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: true
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- PWSID (type: esriFieldTypeString, alias: PWSID, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
- State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- PWS_Name (type: esriFieldTypeString, alias: PWS_Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Primacy_Agency (type: esriFieldTypeString, alias: Primacy_Agency, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Pop_Cat_5 (type: esriFieldTypeString, alias: Pop_Cat_5, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Population_Served_Count (type: esriFieldTypeInteger, alias: Population_Served_Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Service_Connections_Count (type: esriFieldTypeInteger, alias: Service_Connections_Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Method (type: esriFieldTypeString, alias: Method, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Service_Area_Type (type: esriFieldTypeString, alias: Service_Area_Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Symbology_Field (type: esriFieldTypeString, alias: Symbology_Field, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Original_Data_Provider (type: esriFieldTypeString, alias: Original Data Provider, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Data_Provider_Type (type: esriFieldTypeString, alias: Data Provider Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Boundary_Method (type: esriFieldTypeString, alias: Boundary Method, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Method_Basis (type: esriFieldTypeString, alias: Method Basis, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Method_Details (type: esriFieldTypeString, alias: Method Details, SQL Type: sqlTypeOther, length: 441, nullable: true, editable: true)
- System_Type (type: esriFieldTypeString, alias: System Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Verification_Status (type: esriFieldTypeString, alias: Verification Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Verification_Process (type: esriFieldTypeString, alias: Verification Process, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Verifier_Type (type: esriFieldTypeString, alias: Verifier Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Publisher_Owner (type: esriFieldTypeString, alias: Publisher (Owner), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Data_Source_Link (type: esriFieldTypeString, alias: Data Source Link, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Secondary_ID (type: esriFieldTypeString, alias: Secondary ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Secondary_ID_Source (type: esriFieldTypeString, alias: Secondary ID Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Detailed_Facility_Report (type: esriFieldTypeString, alias: Detailed_Facility_Report, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Date_Created (type: esriFieldTypeDate, alias: Date Created, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Date_Modified (type: esriFieldTypeDate, alias: Date Modified, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Verification_Date (type: esriFieldTypeDate, alias: Verification Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- ID (type: esriFieldTypeString, alias: ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Count_of_MCL (type: esriFieldTypeDouble, alias: Count of MCL, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ObjectID_1 (type: esriFieldTypeInteger, alias: ObjectID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
- Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Templates:
Name: Count of MCL Violations
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 8/12/2024 11:28:20 PM
Schema Last Edit Date: 8/12/2024 11:28:20 PM
Data Last Edit Date: 8/12/2024 11:28:20 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat