Cambridge City Car Park Usage Data By Length Of Stay
Cambridgeshire Insight
@ukgov.cambridge_city_car_park_usage_data_by_length_of_stay
Cambridgeshire Insight
@ukgov.cambridge_city_car_park_usage_data_by_length_of_stay
CREATE TABLE grafton_east_car_park_usage_data (
"date" TIMESTAMP,
"day" VARCHAR,
"week_locator" VARCHAR,
"n__up_to_1_hr" VARCHAR,
"n__1_to_2_hrs" VARCHAR,
"n__2_to_3_hrs" VARCHAR,
"n__3_to_4_hrs" VARCHAR,
"n__4_to_5_hrs" VARCHAR,
"n__5_to_6_hrs" VARCHAR,
"n__6_to_24_hours" VARCHAR,
"n__24_hours" VARCHAR,
"n__subscribers" VARCHAR,
"total_exc_sub" BIGINT,
"comments" VARCHAR
);
CREATE TABLE surface_car_park_usage_data (
"month" VARCHAR,
"year" BIGINT,
"fy" VARCHAR,
"month_year" VARCHAR,
"adam_eve_metric" BIGINT,
"adam_eve_justpark" DOUBLE,
"adam_eve_total" BIGINT,
"castle_hill_metric" BIGINT,
"catle_hill_justpark" DOUBLE,
"castle_hill_total" BIGINT,
"gwydir_street_metric" BIGINT,
"gwydir_street_justpark" DOUBLE,
"gwydir_street_total" BIGINT,
"riverside_metric" DOUBLE,
"riverside_justpark" DOUBLE,
"riverside_total" BIGINT
);
CREATE TABLE car_park_locations_inc_surface_car_parks (
"car_park" VARCHAR,
"longitude" DOUBLE,
"latitude" DOUBLE,
"address" VARCHAR
);
CREATE TABLE queen_annes_terrace_car_park_usage_data (
"date" TIMESTAMP,
"day" VARCHAR,
"week_locator" VARCHAR,
"up_to_1_hr" BIGINT,
"n_1_to_2_hrs" BIGINT,
"n_2_to_3_hrs" BIGINT,
"n_3_to_4_hrs" BIGINT,
"n_4_to_5_hrs" BIGINT,
"n_5_to_6_hrs" BIGINT,
"n_6_to_24_hours" BIGINT,
"n_24_hours" BIGINT,
"subscribers" BIGINT,
"total_exc_sub" BIGINT,
"comments" VARCHAR
);
CREATE TABLE grand_arcade_car_park_usage_data (
"date" TIMESTAMP,
"day" VARCHAR,
"week_locator" VARCHAR,
"up_to_1_hr" BIGINT,
"n_1_to_2_hrs" BIGINT,
"n_2_to_3_hrs" BIGINT,
"n_3_to_4_hrs" BIGINT,
"n_4_to_5_hrs" BIGINT,
"n_5_to_6_hrs" BIGINT,
"n_6_to_24_hours" BIGINT,
"n_24_hours" BIGINT,
"subscribers" BIGINT,
"total_exc_sub" BIGINT,
"comments" VARCHAR
);
CREATE TABLE grafton_west_car_park_usage_data (
"date" TIMESTAMP,
"day" VARCHAR,
"week_locator" VARCHAR,
"up_to_1_hr" BIGINT,
"n_1_to_2_hrs" BIGINT,
"n_2_to_3_hrs" BIGINT,
"n_3_to_4_hrs" BIGINT,
"n_4_to_5_hrs" BIGINT,
"n_5_to_6_hrs" BIGINT,
"n_6_to_24_hours" BIGINT,
"n_24_hours" BIGINT,
"subscribers" BIGINT,
"total_exc_sub" BIGINT,
"comments" VARCHAR
);
CREATE TABLE park_street_terrace_car_park_usage_data (
"date" TIMESTAMP,
"day" VARCHAR,
"week_locator" VARCHAR,
"up_to_1_hr" DOUBLE,
"n_1_to_2_hrs" DOUBLE,
"n_2_to_3_hrs" DOUBLE,
"n_3_to_4_hrs" DOUBLE,
"n_4_to_5_hrs" DOUBLE,
"n_5_to_6_hrs" BIGINT,
"n_6_to_24_hours" DOUBLE,
"n_24_hours" DOUBLE,
"subscribers" DOUBLE,
"total_exc_sub" DOUBLE,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.