← All datasets
# curated.water_system
EPA SDWIS public water systems serving the 8-county region, one row per PWSID (4,994 rows; category: Environment; no geometry)
Notes: pws_type_code 'CWS' = community system serving homes (use this for residents); NTNCWS/TNCWS are schools, businesses, campgrounds. pws_activity_code 'A' = active. population_served_count and service_connections_count are self-reported. gw_sw_code GW = groundwater (wells), SW = surface water; GWP/SWP = purchased. Link a system to its EPA page as https://echo.epa.gov/detailed-facility-report?fid=<pwsid>.
Fields (expression | type | filled/distinct in a sample | values or examples):
- pwsid | text | 4994/4994 | e.g.: TX1010810; TX1013168; TX1012429
- pws_name | text | 4994/4976 | e.g.: PLAZA 290; CHUEN-FU RESTAURANT; DIMITRIS CABARET
- pws_activity_code | text | 4994/3 | values: A; I; N
- pws_deactivation_date | date | 2296/729 | e.g.: 2009-12-15; 1985-12-01; 2009-08-15
- pws_type_code | text | 4994/3 | values: CWS; TNCWS; NTNCWS
- gw_sw_code | text | 4994/2 | values: GW; SW
- primary_source_code | text | 4994/5 | values: GW; SWP; GWP; SW; GU
- owner_type_code | text | 4978/5 | values: P; L; S; M; F
- population_served_count | integer | 4994/1191 | e.g.: 0; 25; 50
- service_connections_count | integer | 4994/1013 | e.g.: 1; 2; 3
- is_wholesaler_ind | boolean | 4994/2 | values: false; true
- org_name | text | 3374/2583 | e.g.: FOLTZ, SCOT, W; BARRY, CHUCK; THOMAS, CAREY, A
- phone_number | text | 3802/2375 | e.g.: 713-860-6400; 512-990-4400; 713-623-4531
- address_line1 | text | 4734/2923 | e.g.: 3200 SOUTHWEST FWY STE 2600; -WATER UTILITIES OFFICIAL; 1106 CLAYTON LN STE 400W
- city_name | text | 4990/308 | e.g.: HOUSTON; AUSTIN; CONROE
- zip_code | text | 4989/2143 | e.g.: 77027-7537; 78723-2476; 78754-5132
- first_reported_date | date | 4994/190 | e.g.: 1980-03-14; 1987-01-14; 1981-01-20
- last_reported_date | date | 4981/18 | e.g.: 2026-09-28; 2002-03-13; 2003-12-17
- counties_served | text | 4994/8 | values: Harris; Montgomery; Brazoria; Fort Bend; Liberty; Galveston; Waller; Chambers