CM4(Manchester Road Mayo Avenue)

City of Bradford Metropolitan District Council

@ukgov.cm4manchester_road_mayo_avenue12

Table List

1 table(579.83 KB)

Table 1

@ukgov.cm4manchester_road_mayo_avenue12.table_1

579.83 KB
35040 rows
10 columns

date_time Date Time	rainfall_max Rainfall MAX	rainfall_avg Rainfall AVG	rainfall_sum Rainfall SUM	fid FID
Wed Jan 03 2018 02:00:00 GMT+0000 (Coordinated Universal Time)	0.0546875	0.02604167	0.078125	1
Wed Jan 03 2018 02:15:00 GMT+0000 (Coordinated Universal Time)	0.03385417	0.01215278	0.03645834	2
Wed Jan 03 2018 02:30:00 GMT+0000 (Coordinated Universal Time)	0.078125	0.05034722	0.1510417	3
Wed Jan 03 2018 02:45:00 GMT+0000 (Coordinated Universal Time)	0.005208333	0.001736111	0.005208333	4
Wed Jan 03 2018 03:00:00 GMT+0000 (Coordinated Universal Time)				5
Wed Jan 03 2018 03:15:00 GMT+0000 (Coordinated Universal Time)				6
Wed Jan 03 2018 03:30:00 GMT+0000 (Coordinated Universal Time)	0.02864583	0.015625	0.046875	7
Wed Jan 03 2018 03:45:00 GMT+0000 (Coordinated Universal Time)	0.07552084	0.03645834	0.109375	8
Wed Jan 03 2018 04:00:00 GMT+0000 (Coordinated Universal Time)	0.01302083	0.005208333	0.015625	9
Wed Jan 03 2018 04:15:00 GMT+0000 (Coordinated Universal Time)				10


CREATE TABLE table_1 (
  "date_time" TIMESTAMP,
  "rainfall_min" BIGINT,
  "rainfall_max" DOUBLE,
  "rainfall_avg" DOUBLE,
  "rainfall_sum" DOUBLE,
  "rainfall_intensity_min" BIGINT,
  "rainfall_intensity_max" BIGINT,
  "rainfall_intensity_avg" BIGINT,
  "rainfall_intensity_sum" BIGINT,
  "fid" BIGINT
);