CM3(Manningham Lane)
City of Bradford Metropolitan District Council
@ukgov.cm3manningham_lane12
Table 1
@ukgov.cm3manningham_lane12.table_1
- 610.08 KB
- 35040 rows
- 10 columns
date_timeDate Time | rainfall_minRainfall MIN | rainfall_maxRainfall MAX | rainfall_avgRainfall AVG | rainfall_sumRainfall SUM | rainfall_intensity_minRainfall Intensity MIN | rainfall_intensity_maxRainfall Intensity MAX | rainfall_intensity_avgRainfall Intensity AVG | rainfall_intensity_sumRainfall Intensity SUM | fidFID |
|---|---|---|---|---|---|---|---|---|---|
| Mon Jan 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time) | 1 | ||||||||
| Mon Jan 01 2018 00:15:00 GMT+0000 (Coordinated Universal Time) | 2 | ||||||||
| Mon Jan 01 2018 00:30:00 GMT+0000 (Coordinated Universal Time) | 3 | ||||||||
| Mon Jan 01 2018 00:45:00 GMT+0000 (Coordinated Universal Time) | 4 | ||||||||
| Mon Jan 01 2018 01:00:00 GMT+0000 (Coordinated Universal Time) | 5 | ||||||||
| Mon Jan 01 2018 01:15:00 GMT+0000 (Coordinated Universal Time) | 6 | ||||||||
| Mon Jan 01 2018 01:30:00 GMT+0000 (Coordinated Universal Time) | 7 | ||||||||
| Mon Jan 01 2018 01:45:00 GMT+0000 (Coordinated Universal Time) | 8 | ||||||||
| Mon Jan 01 2018 02:00:00 GMT+0000 (Coordinated Universal Time) | 9 | ||||||||
| Mon Jan 01 2018 02:15:00 GMT+0000 (Coordinated Universal Time) | 10 |
CREATE TABLE table_1 (
"date_time" TIMESTAMP,
"rainfall_min" DOUBLE,
"rainfall_max" DOUBLE,
"rainfall_avg" DOUBLE,
"rainfall_sum" DOUBLE,
"rainfall_intensity_min" DOUBLE,
"rainfall_intensity_max" DOUBLE,
"rainfall_intensity_avg" DOUBLE,
"rainfall_intensity_sum" DOUBLE,
"fid" BIGINT
);