ArcGIS REST Services Directory
Home
>
services
>
Community_Water_Systems_June_8_2024_all_CWS (FeatureServer)
>
All Layers and Tables
|
API Reference
JSON
All Layers and Tables (Community_Water_Systems_June_8_2024_all_CWS)
Layers:
Tables:
PWS_Complete_Table_2026_01_16.csv
(477)
Name:
PWS_Complete_Table_2026_01_16.csv
Display Field:
PWS_NAME
Type:
Table
Description:
Copyright Text:
Max Record Count:
2000
Supported query Formats:
JSON, geoJSON, PBF
Use Standardized Queries:
True
HasZ:
false
HasM:
false
Has Attachments:
false
Has Geometry Properties:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
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)
Field1
(type: esriFieldTypeInteger, alias: Field1, SQL Type: sqlTypeOther, nullable: true, editable: true)
PWS_NAME
(type: esriFieldTypeString, alias: PWS_NAME, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
PWSID
(type: esriFieldTypeString, alias: PWSID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
REGISTRY_ID
(type: esriFieldTypeString, alias: REGISTRY_ID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
EPA_REGION
(type: esriFieldTypeString, alias: EPA_REGION, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
ZIP_CODE_SERVED
(type: esriFieldTypeString, alias: ZIP_CODE_SERVED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
CITY_SERVED
(type: esriFieldTypeString, alias: CITY_SERVED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
COUNTY_SERVED
(type: esriFieldTypeString, alias: COUNTY_SERVED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
TRIBE_SERVED
(type: esriFieldTypeString, alias: TRIBE_SERVED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
BIA_TRIBE_CODE
(type: esriFieldTypeString, alias: BIA_TRIBE_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
ANSI_ENTITY_CODE
(type: esriFieldTypeString, alias: ANSI_ENTITY_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
PRIMACY_TYPE
(type: esriFieldTypeString, alias: PRIMACY_TYPE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
PRIMACY_AGENCY
(type: esriFieldTypeString, alias: PRIMACY_AGENCY, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
PWS_TYPE
(type: esriFieldTypeString, alias: PWS_TYPE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
OWNER_TYPE
(type: esriFieldTypeString, alias: OWNER_TYPE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
SCHOOL_OR_DAYCARE
(type: esriFieldTypeString, alias: SCHOOL_OR_DAYCARE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
WHOLESALER
(type: esriFieldTypeString, alias: WHOLESALER, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
SOURCE_WATER_TYPE
(type: esriFieldTypeString, alias: SOURCE_WATER_TYPE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
POPULATION_SERVED_COUNT
(type: esriFieldTypeDouble, alias: POPULATION_SERVED_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
POPULATION_CATEGORY_SERVED
(type: esriFieldTypeString, alias: POPULATION_CATEGORY_SERVED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
SERVICE_CONNECTIONS_COUNT
(type: esriFieldTypeInteger, alias: SERVICE_CONNECTIONS_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
COMP_PERIOD_BEGIN_FYQTR
(type: esriFieldTypeString, alias: COMP_PERIOD_BEGIN_FYQTR, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
VIOLATIONS_NON_RTC_COUNT
(type: esriFieldTypeInteger, alias: VIOLATIONS_NON_RTC_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
VIOLATIONS_NON_RTC_COUNT_RANGE
(type: esriFieldTypeString, alias: VIOLATIONS_NON_RTC_COUNT_RANGE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
HBV_NON_RTC_COUNT
(type: esriFieldTypeInteger, alias: HBV_NON_RTC_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
HBV_NON_RTC_COUNT_RANGE
(type: esriFieldTypeString, alias: HBV_NON_RTC_COUNT_RANGE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
HB_RULES_VIOL_NONRTC
(type: esriFieldTypeString, alias: HB_RULES_VIOL_NONRTC, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
HBV_COUNT_QTRS_5YRS
(type: esriFieldTypeInteger, alias: HBV_COUNT_QTRS_5YRS, SQL Type: sqlTypeOther, nullable: true, editable: true)
HBV_COUNT_QTRS_5YRS_RANGE
(type: esriFieldTypeString, alias: HBV_COUNT_QTRS_5YRS_RANGE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
HB_RULES_VIOLATED_5YRS
(type: esriFieldTypeString, alias: HB_RULES_VIOLATED_5YRS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
LCR_VIOL_NONRTC_COUNT
(type: esriFieldTypeInteger, alias: LCR_VIOL_NONRTC_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
LCR_VIOL_NONRTC_COUNT_RANGE
(type: esriFieldTypeString, alias: LCR_VIOL_NONRTC_COUNT_RANGE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
LCR_VIOL_COUNT_QTRS_5YRS
(type: esriFieldTypeInteger, alias: LCR_VIOL_COUNT_QTRS_5YRS, SQL Type: sqlTypeOther, nullable: true, editable: true)
LCR_VIOL_COUNT_QTRS_5YRS_RANGE
(type: esriFieldTypeString, alias: LCR_VIOL_COUNT_QTRS_5YRS_RANGE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
MR_VIOL_COUNT_QTRS_5YRS
(type: esriFieldTypeInteger, alias: MR_VIOL_COUNT_QTRS_5YRS, SQL Type: sqlTypeOther, nullable: true, editable: true)
MR_VIOL_COUNT_QTRS_5YRS_RANGE
(type: esriFieldTypeString, alias: MR_VIOL_COUNT_QTRS_5YRS_RANGE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
FEA_VIOL_NONRTC_COUNT
(type: esriFieldTypeInteger, alias: FEA_VIOL_NONRTC_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
FEA_VIOL_NONRTC_COUNT_RANGE
(type: esriFieldTypeString, alias: FEA_VIOL_NONRTC_COUNT_RANGE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
LEAD_ALE_5YRS_YN
(type: esriFieldTypeString, alias: LEAD_ALE_5YRS_YN, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
LEAD_ALE_COUNT_5YRS
(type: esriFieldTypeInteger, alias: LEAD_ALE_COUNT_5YRS, SQL Type: sqlTypeOther, nullable: true, editable: true)
LEAD_ALE_COUNT_5YRS_RANGE
(type: esriFieldTypeString, alias: LEAD_ALE_COUNT_5YRS_RANGE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
LEAD_SAMPLE_COUNT_5YRS
(type: esriFieldTypeInteger, alias: LEAD_SAMPLE_COUNT_5YRS, SQL Type: sqlTypeOther, nullable: true, editable: true)
LEAD_SAMPLE_COUNT_5YRS_RANGE
(type: esriFieldTypeString, alias: LEAD_SAMPLE_COUNT_5YRS_RANGE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
SL_RPT_STATUS
(type: esriFieldTypeString, alias: SL_RPT_STATUS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
NUM_GALVANIZED_REQUIRING_REPLACEMENT_SL
(type: esriFieldTypeString, alias: NUM_GALVANIZED_REQUIRING_REPLACEMENT_SL, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
NUM_LEAD_SERVICE_LINES
(type: esriFieldTypeString, alias: NUM_LEAD_SERVICE_LINES, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
NUM_LEAD_STATUS_UNKNOWN_SL
(type: esriFieldTypeString, alias: NUM_LEAD_STATUS_UNKNOWN_SL, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
NUM_NONLEAD_SERVICE_LINES
(type: esriFieldTypeString, alias: NUM_NONLEAD_SERVICE_LINES, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
TOTAL_NUM_SERVICE_LINES_REPORTED
(type: esriFieldTypeString, alias: TOTAL_NUM_SERVICE_LINES_REPORTED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
ENF_PRIORITY_SYS
(type: esriFieldTypeString, alias: ENF_PRIORITY_SYS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
SS_OUTSTAND_PERFORM
(type: esriFieldTypeString, alias: SS_OUTSTAND_PERFORM, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
SS_OUTSTAND_PERFORM_BEGIN_DATE
(type: esriFieldTypeString, alias: SS_OUTSTAND_PERFORM_BEGIN_DATE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
TRMT_4LOG_OR_GREATER
(type: esriFieldTypeString, alias: TRMT_4LOG_OR_GREATER, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
SS_DATE_MOST_RECENT
(type: esriFieldTypeString, alias: SS_DATE_MOST_RECENT, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
SS_SURVEY_OVERDUE
(type: esriFieldTypeString, alias: SS_SURVEY_OVERDUE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
SS_VISIT_TYPE
(type: esriFieldTypeString, alias: SS_VISIT_TYPE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
SS_SIGD_OR_SAND_INFRA_YN
(type: esriFieldTypeString, alias: SS_SIGD_OR_SAND_INFRA_YN, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
SS_SIGD_OR_SAND_CAP_YN
(type: esriFieldTypeString, alias: SS_SIGD_OR_SAND_CAP_YN, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
MANAGEMENT_OPS_EVAL_CODE
(type: esriFieldTypeString, alias: MANAGEMENT_OPS_EVAL_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
SOURCE_WATER_EVAL_CODE
(type: esriFieldTypeString, alias: SOURCE_WATER_EVAL_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
SECURITY_EVAL_CODE
(type: esriFieldTypeString, alias: SECURITY_EVAL_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
PUMPS_EVAL_CODE
(type: esriFieldTypeString, alias: PUMPS_EVAL_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
OTHER_EVAL_CODE
(type: esriFieldTypeString, alias: OTHER_EVAL_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
COMPLIANCE_EVAL_CODE
(type: esriFieldTypeString, alias: COMPLIANCE_EVAL_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
DATA_VERIFICATION_EVAL_CODE
(type: esriFieldTypeString, alias: DATA_VERIFICATION_EVAL_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
TREATMENT_EVAL_CODE
(type: esriFieldTypeString, alias: TREATMENT_EVAL_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
FINISHED_WATER_STOR_EVAL_CODE
(type: esriFieldTypeString, alias: FINISHED_WATER_STOR_EVAL_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
DISTRIBUTION_EVAL_CODE
(type: esriFieldTypeString, alias: DISTRIBUTION_EVAL_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
FINANCIAL_EVAL_CODE
(type: esriFieldTypeString, alias: FINANCIAL_EVAL_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
STATE_DWSRF_DAC
(type: esriFieldTypeString, alias: STATE_DWSRF_DAC, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
DWSRF_AWARDS_10YRS_COUNT
(type: esriFieldTypeInteger, alias: DWSRF_AWARDS_10YRS_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
DWSRF_AWARDS_10YRS_COUNT_RANGE
(type: esriFieldTypeString, alias: DWSRF_AWARDS_10YRS_COUNT_RANGE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
PWS_MHI_WEIGHT
(type: esriFieldTypeString, alias: PWS_MHI_WEIGHT, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
PCT_LOWINC
(type: esriFieldTypeString, alias: PCT_LOWINC, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
PCT_RURAL
(type: esriFieldTypeString, alias: PCT_RURAL, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
PCT_UNEMPLY
(type: esriFieldTypeString, alias: PCT_UNEMPLY, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
PCT_LOWINC_RANGE
(type: esriFieldTypeString, alias: PCT_LOWINC_RANGE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
PCT_RURAL_RANGE
(type: esriFieldTypeString, alias: PCT_RURAL_RANGE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
PCT_UNEMPLY_RANGE
(type: esriFieldTypeString, alias: PCT_UNEMPLY_RANGE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
DFR_URL
(type: esriFieldTypeString, alias: DFR_URL, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Templates:
Name: PWS_Complete_Table_2026_01_16.csv
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Attributes:
Is Data Versioned:
false
Has Contingent Values:
false
Supports Rollback On Failure Parameter:
true
Last Edit Date:
1/20/2026 1:53:43 PM
Schema Last Edit Date:
1/20/2026 1:53:43 PM
Data Last Edit Date:
1/20/2026 1:53:43 PM