Data from BAWSCA Annual Survey. Water consumption data by water districts in San Mateo County from 2008-2013. Includes data on: water use, water use by customer class, water source, number of customer accounts, and residential per capita water consumption.
This dataset has the following 40 columns:
| Column Name | API Column Name | Data Type | Sample Values |
|---|---|---|---|
| End of Fiscal Year | end_of_fiscal_year | calendar_date | 2009-07-31T00:00:00.000 2010-07-31T00:00:00.000 2011-07-31T00:00:00.000 2012-07-31T00:00:00.000 2013-07-31T00:00:00.000 view top 100 |
| Water District/City | water_district_city | text | California Water Service Company- Bear Gulch District California Water Service Company - Mid Peninsula District California Water Service Company - South San Francisco District City of Brisbane/ Guadalupe Valley Municipal Improvement District City of Burlingame view top 100 |
| Area Size (square miles) | area_size_square_miles | number | 4 2.5 45.3 17 35 view top 100 |
| Avg. Day Demand (mgd) | avg_day_demand_mgd | number | 3.25 3.63 0.9 3.14 0.81 view top 100 |
| Service Population | service_population | number | 36100 4282 41114 40000 30282 view top 100 |
| Water Purchased/Produced from SFPUC (mgd) | water_purchased_produced_from_sfpuc_mgd | number | 3.25 1.82 0.9 3.14 2.88 view top 100 |
| Water use (ccf) | water_use_ccf | number | 101551 192485 275934 276601 280650 view top 100 |
| Water use (mgd) | water_use_mgd | number | 0.9 3.14 3.25 4.03 3.63 view top 100 |
| Water Source - SFPUC Purchases (ccf) | water_source_sfpuc_purchases_ccf | number | 275934 276601 280650 287290 302577 view top 100 |
| Water Source - Local Source - Groundwater (ccf) | water_source_local_source_groundwater_ccf | number | 0 584 896 2686 4278 view top 100 |
| Water source - Local Source - Surface Water (ccf) | water_source_local_source_surface_water_ccf | number | 0 49960 64532 84358 90401 view top 100 |
| Water Source - Other Source - Recycled Water (ccf) | water_source_other_source_recycled_water_ccf | number | 0 146400 12000 4064 5294 view top 100 |
| Water Source - Other Source - Other (ccf) | water_source_other_source_other_ccf | number | 0 522 15535 20903 21691 view top 100 |
| Water Use By Customer Class - Residential - Single Family (ccf) | water_use_by_customer_class_residential_single_family_ccf | number | 0 67073 85910 86271 87333 view top 100 |
| Water Use By Customer Class - Residential - Multiple Family (ccf) | water_use_by_customer_class_residential_multiple_family_ccf | number | 0 18389 18568 18999 20134 view top 100 |
| Water Use By Customer Class - Residential - Single and Multiple Family Combined (ccf) | water_use_by_customer_class_residential_single_and_multiple_family_combined_ccf | number | 104478 105270 105722 110380 112037 view top 100 |
| Water Use By Customer Class - Non-residential - Commercial (ccf) | water_use_by_customer_class_non_residential_commercial_ccf | number | 0 62 2171 3485 3699 view top 100 |
| Water Use By Customer Class - Non-residential - Industrial (ccf) | water_use_by_customer_class_non_residential_industrial_ccf | number | 0 83 59 74 884 view top 100 |
| Water Use By Customer Class - Non-residential - Commercial and Industrial Combined (ccf) | water_use_by_customer_class_non_residential_commercial_and_industrial_combined_ccf | number | 3485 5421 7000 28504 30661 view top 100 |
| Water Use By Customer Class - Other (ccf) | water_use_by_customer_class_other_ccf | number | 0 137649 70228 3850 4477 view top 100 |
| Water Use By Customer Class - Dedicated Irrigation (ccf) | water_use_by_customer_class_dedicated_irrigation_ccf | number | 0 12328 15563 20038 20878 view top 100 |
| Water Use By Customer Class - Unaccounted (ccf) | water_use_by_customer_class_unaccounted_ccf | number | -551515 -201721 -182920 -150132 -128286 view top 100 |
| Number of Customer Accounts - Residential - Single Family | number_of_customer_accounts_residential_single_family | number | 6820 5744 9485 7099 1420 view top 100 |
| Number of Customer Accounts - Residential - Multiple Family | number_of_customer_accounts_residential_multiple_family | number | 0 738 239 120 157 view top 100 |
| Number of Customer Accounts - Residential - Single Family and Multiple Family Combined | number_of_customer_accounts_residential_single_family_and_multiple_family_combined | number | 0 7338 10575 7124 3546 view top 100 |
| Number of Customer Accounts - Non-Residential - Commercial | number_of_customer_accounts_non_residential_commercial | number | 586 477 36 278 13 view top 100 |
| Number of Customer Accounts - Non-Residential - Industrial | number_of_customer_accounts_non_residential_industrial | number | 0 1 3 5 94 view top 100 |
| Number of Customer Accounts - Non-Residential - Commercial and Industrial Combined | number_of_customer_accounts_non_residential_commercial_and_industrial_combined | number | 856 556 87 297 266 view top 100 |
| Number of Customer Accounts - Non-Residential - Government, Other | number_of_customer_accounts_non_residential_government_other | number | 0 42 48 504 81 view top 100 |
| Number of Customer Accounts - Non-Residential - Total | number_of_customer_accounts_non_residential_total | number | 637 1360 28 349 716 view top 100 |
| Number of Customer Accounts - Dedicated Irrigation | number_of_customer_accounts_dedicated_irrigation | number | 0 94 89 195 119 view top 100 |
| Number of Customer Accounts - Total (all categories combined) | number_of_customer_accounts_total_all_categories_combined | number | 9113 7975 6538 11410 4182 view top 100 |
| Residential Per Capita Consumption (gpcpd) | residential_per_capita_consumption_gpcpd | number | 79 50 60 55 85 view top 100 |
| Gross per capita consumption (gallons per capita per day) | gross_per_capita_consumption_gpcpd | number | 112 68 113 132 136 view top 100 |
| Single-Family Average Monthly Use (ccf) | single_family_average_monthly_use_ccf | number | 8 9.7 11 9.9 10 view top 100 |
| Location | location | point | {"coordinates":[-122.3070631,37.5517319],"type":"Point"} {"coordinates":[-122.3637871,37.55790423],"type":"Point"} {"coordinates":[-122.4670691,37.69977101],"type":"Point"} {"coordinates":[-122.4420966,37.48152736],"type":"Point"} {"coordinates":[-122.4266014,37.62404006],"type":"Point"} view top 100 |
| Location (address) | location_address | text | view top 100 |
| Location (city) | location_city | text | view top 100 |
| Location (state) | location_state | text | view top 100 |
| Location (zip) | location_zip | text | view top 100 |