Baselight

Water Capture By Method

City of Los Angeles

@usgov.city_of_los_angeles_water_capture_by_method

Loading...
Loading...

About this Dataset

Water Capture By Method

Though it doesn't rain often in Los Angeles, the city has various means of capturing rainfall to increase our local water supply. This dataset shows how much water we've capturing cumulatively this season as well as today.

It is calculated through a script that is available on github here (https://github.com/CityOfLosAngeles/WaterCapture). When it rains, the dataset will update with new rows every hour.
Organization: City of Los Angeles
Last updated: 2020-11-10T17:52:38.758276
Tags: stormwater, sustainability, water-capture

Tables

Table 1

@usgov.city_of_los_angeles_water_capture_by_method.table_1
  • 10.98 kB
  • 99 rows
  • 8 columns
Loading...
CREATE TABLE table_1 (
  "timestamp" VARCHAR,
  "spreading_ground_cumulative" BIGINT,
  "rain_barrels_and_cisterns_cumulative" DOUBLE,
  "incidental_capture_cumulative" DOUBLE,
  "green_infrastructure_capture_cumulative" DOUBLE,
  "green_streets_and_alleys_capture" DOUBLE,
  "total_water_capture_this_season" DOUBLE,
  "total_rainfall_this_season" DOUBLE
);

Share link

Anyone who has the link will be able to view this.