CM7(Rook Lane)

City of Bradford Metropolitan District Council

@ukgov.cm7rook_lane12

Table List

1 table(577.17 KB)

Table 1

@ukgov.cm7rook_lane12.table_1

577.17 KB
35040 rows
10 columns

date_time Date Time	rainfall_max Rainfall MAX	rainfall_avg Rainfall AVG	rainfall_sum Rainfall SUM	rainfall_intensity_min Rainfall Intensity MIN	rainfall_intensity_max Rainfall Intensity MAX	rainfall_intensity_avg Rainfall Intensity AVG	rainfall_intensity_sum Rainfall Intensity SUM	fid FID
Mon Jan 01 2018 12:30:00 GMT+0000 (Coordinated Universal Time)								1
Mon Jan 01 2018 12:45:00 GMT+0000 (Coordinated Universal Time)								2
Mon Jan 01 2018 13:00:00 GMT+0000 (Coordinated Universal Time)								3
Mon Jan 01 2018 13:15:00 GMT+0000 (Coordinated Universal Time)								4
Mon Jan 01 2018 13:30:00 GMT+0000 (Coordinated Universal Time)								5
Mon Jan 01 2018 13:45:00 GMT+0000 (Coordinated Universal Time)	0.01822917	0.006076389	0.01822917					6
Mon Jan 01 2018 14:00:00 GMT+0000 (Coordinated Universal Time)	0.09895834	0.04253472	0.1276042					7
Mon Jan 01 2018 14:15:00 GMT+0000 (Coordinated Universal Time)	0.2552083	0.1102431	0.3307292					8
Mon Jan 01 2018 14:30:00 GMT+0000 (Coordinated Universal Time)	0.4817708	0.2838542	0.8515625	2	2	2	2	9
Mon Jan 01 2018 14:45:00 GMT+0000 (Coordinated Universal Time)	0.1432292	0.07725695	0.2317708					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
);