About this Dataset

Rain Gauge Rainfall Data

This dataset shows rainfall data from 6 rain gauges located at various locations across the city. Please note ----------- * The siting of the gauges is not to Met Office standards (e.g.. maybe too close to a wall), which may not give an entirely accurate reflection of rainfall. The exact location of these gauges is not released. * Measurements are in millilitres. * It is recognised that there are inconsistencies in the data in respect of site readings. This can be for a number of reasons e.g. damaged cable, faulty loggers or damaged GPRS aerial.
Publisher name: Leeds City Council
Last updated: 2024-09-14T09:41:19Z

Tables

01/10/2017 - 31/10/2017

@ukgov.rain_gauge_rainfall_data.n_01_10_2017_31_10_2017

3.74 KB
31 rows
3 columns


CREATE TABLE n_01_10_2017_31_10_2017 (
  "timestamp_lessone" VARCHAR,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_shadwell_daily_rain_mm_tot" DOUBLE
);

01/11/2014 - 30/11/2014

@ukgov.rain_gauge_rainfall_data.n_01_11_2014_30_11_2014

7.65 KB
30 rows
7 columns


CREATE TABLE n_01_11_2014_30_11_2014 (
  "timestamp_lessone" VARCHAR,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_middleton_daily_rain_mm_tot" DOUBLE,
  "qry_otley_daily_rain_mm_tot" DOUBLE,
  "qry_potteryfield_daily_rain_mm_tot" DOUBLE,
  "qry_shadwell_daily_rain_mm_tot" DOUBLE,
  "qry_wetherby_daily_rain_mm_tot" DOUBLE
);

01/11/2015 - 30/11/2015

@ukgov.rain_gauge_rainfall_data.n_01_11_2015_30_11_2015

7.95 KB
30 rows
7 columns


CREATE TABLE n_01_11_2015_30_11_2015 (
  "timestamp_lessone" TIMESTAMP,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_middleton_daily_rain_mm_tot" DOUBLE,
  "qry_otley_daily_rain_mm_tot" DOUBLE,
  "qry_potteryfield_daily_rain_mm_tot" DOUBLE,
  "qry_shadwell_daily_rain_mm_tot" DOUBLE,
  "qry_wetherby_daily_rain_mm_tot" DOUBLE
);

01/12/2015 - 31/12/2015

@ukgov.rain_gauge_rainfall_data.n_01_12_2015_31_12_2015

7.99 KB
31 rows
7 columns


CREATE TABLE n_01_12_2015_31_12_2015 (
  "timestamp_lessone" TIMESTAMP,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_middleton_daily_rain_mm_tot" DOUBLE,
  "qry_otley_daily_rain_mm_tot" DOUBLE,
  "qry_potteryfield_daily_rain_mm_tot" DOUBLE,
  "qry_shadwell_daily_rain_mm_tot" DOUBLE,
  "qry_wetherby_daily_rain_mm_tot" DOUBLE
);

01/12/2016 - 31/12/2016

@ukgov.rain_gauge_rainfall_data.n_01_12_2016_31_12_2016

7.56 KB
31 rows
7 columns


CREATE TABLE n_01_12_2016_31_12_2016 (
  "timestamp_lessone" TIMESTAMP,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_middleton_daily_rain_mm_tot" DOUBLE,
  "qry_otley_daily_rain_mm_tot" DOUBLE,
  "qry_potteryfield_daily_rain_mm_tot" DOUBLE,
  "qry_shadwell_daily_rain_mm_tot" DOUBLE,
  "qry_wetherby_daily_rain_mm_tot" DOUBLE
);

01/12/2017 - 31/12/2017

@ukgov.rain_gauge_rainfall_data.n_01_12_2017_31_12_2017

5.64 KB
31 rows
5 columns


CREATE TABLE n_01_12_2017_31_12_2017 (
  "timestamp_lessone" VARCHAR,
  "qry_allertonbywater_daily_rain_mm_tot" DOUBLE,
  "qry_middleton_daily_rain_mm_tot" DOUBLE,
  "qry_shadwell_daily_rain_mm_tot" DOUBLE,
  "qry_wetherby_daily_rain_mm_tot" DOUBLE
);