Cultural Infrastructure Map
Greater London Authority
@ukgov.cultural_infrastructure_map1
Greater London Authority
@ukgov.cultural_infrastructure_map1
CREATE TABLE archives_data_captured_in_january_2019 (
"name" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" DOUBLE,
"borough_code" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"ward_2018_name" VARCHAR,
"ward_2018_code" VARCHAR,
"longitude" DOUBLE,
"latitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE art_centres_data_captured_in_january_2019 (
"name" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"borough_code" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"os_addressbase_uprn" BIGINT,
"ward_2018_name" VARCHAR,
"ward_2018_code" VARCHAR,
"longitude" DOUBLE,
"latitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE,
"runtime" TIMESTAMP
);
CREATE TABLE artists_workspaces_data_captured_in_march_2018 (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" DOUBLE,
"borough_code" VARCHAR,
"ward_2018_name" VARCHAR,
"ward_2018_code" VARCHAR,
"longitude" DOUBLE,
"latitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE cinemas_data_captured_in_january_2019 (
"name" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" DOUBLE,
"borough_code" VARCHAR,
"ward_2018_name" VARCHAR,
"ward_2018_code" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"easting" DOUBLE,
"northing" DOUBLE,
"longitude" DOUBLE,
"latitude" DOUBLE
);
CREATE TABLE commercial_galleries_data_captured_in_january_2019 (
"name" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"borough_code" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"os_addressbase_uprn" DOUBLE,
"ward_2018_name" VARCHAR,
"ward_2018_code" VARCHAR,
"easting" DOUBLE,
"northing" DOUBLE,
"longitude" DOUBLE,
"latitude" DOUBLE
);
CREATE TABLE community_centres_captured_in_january_2019 (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" DOUBLE,
"borough_code" VARCHAR,
"ward_2018_name" VARCHAR,
"ward_2018_code" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE creative_co_working_desk_space_data_captured_in_november_2018 (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" VARCHAR,
"borough_code" VARCHAR,
"ward_2018_name" VARCHAR,
"ward_2018_code" VARCHAR,
"easting" DOUBLE,
"northing" DOUBLE,
"longitude" DOUBLE,
"latitude" DOUBLE
);
CREATE TABLE creative_workspace_captured_april_2019 (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" VARCHAR,
"borough_code" VARCHAR,
"ward_name_2018" VARCHAR,
"ward_code_2018" VARCHAR,
"easting" DOUBLE,
"northing" DOUBLE,
"longitude" DOUBLE,
"latitude" DOUBLE
);
CREATE TABLE dance_performance_venues_captured_december_2018 (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" VARCHAR,
"borough_code" VARCHAR,
"ward_2018_name" VARCHAR,
"ward_2018_code" VARCHAR,
"address3" VARCHAR,
"longitude" DOUBLE,
"latitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE dance_rehearsal_studios_captured_december_2018 (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" VARCHAR,
"borough_code" VARCHAR,
"ward_2018_name" VARCHAR,
"ward_2018_code" VARCHAR,
"longitude" DOUBLE,
"latitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE fashion_and_design_manufacturing_captured_in_november_2018 (
"name" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" DOUBLE,
"borough_code" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"ward_2018_name" VARCHAR,
"ward_2018_code" VARCHAR,
"longitude" DOUBLE,
"latitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE,
"runtime" TIMESTAMP
);
CREATE TABLE jewellery_design_and_manufacturing_captured_in_november_2018 (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" DOUBLE,
"borough_code" VARCHAR,
"ward_2018_name" VARCHAR,
"ward_2018_code" VARCHAR,
"easting" DOUBLE,
"northing" DOUBLE,
"longitude" DOUBLE,
"latitude" DOUBLE
);
CREATE TABLE large_scale_screen_based_media_production_studios_capt_85fbe3bf (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" BIGINT,
"borough_code" VARCHAR,
"ward_2018_name" VARCHAR,
"ward_2018_code" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"rm_organisation_name" VARCHAR,
"building_name" VARCHAR,
"ward_code" VARCHAR,
"fid_london_ward" BIGINT,
"easting" DOUBLE,
"northing" DOUBLE,
"runtime" TIMESTAMP
);
CREATE TABLE legal_street_art_walls_data_captured_in_january_2019 (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" VARCHAR,
"borough_code" VARCHAR,
"ward_2018_name" VARCHAR,
"ward_2018_code" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE,
"runtime" TIMESTAMP
);
CREATE TABLE lgbt_night_time_venues_data_captured_in_july_2019 (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" DOUBLE,
"borough_code" VARCHAR,
"ward_2018_name" VARCHAR,
"ward_2018_code" VARCHAR,
"longitude" DOUBLE,
"latitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE libraries_data_captured_in_january_2019 (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" DOUBLE,
"borough_code" VARCHAR,
"ward_2018_name" VARCHAR,
"ward_2018_code" VARCHAR,
"easting" DOUBLE,
"northing" DOUBLE,
"longitude" DOUBLE,
"latitude" DOUBLE
);
CREATE TABLE live_in_artists_workspace_data_captured_in_january_2019 (
"name" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" BIGINT,
"borough_code" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"ward_2018_name" VARCHAR,
"ward_2018_code" VARCHAR,
"longitude" DOUBLE,
"latitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE,
"runtime" TIMESTAMP
);
CREATE TABLE makerspaces_data_captured_in_november_2018 (
"name" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" DOUBLE,
"borough_code" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"ward_2018_name" VARCHAR,
"ward_2018_code" VARCHAR,
"longitude" DOUBLE,
"latitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE making_manufacturing_for_the_creative_industries_captu_cf451535 (
"name" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" VARCHAR,
"borough_code" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"ward_2018_name" VARCHAR,
"ward_2018_code" VARCHAR,
"easting" DOUBLE,
"northing" DOUBLE,
"longitude" DOUBLE,
"latitude" DOUBLE
);
CREATE TABLE museums_and_public_galleries_data_captured_in_january_2019 (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" DOUBLE,
"borough_code" VARCHAR,
"ward_2018_name" VARCHAR,
"ward_2018_code" VARCHAR,
"easting" DOUBLE,
"northing" DOUBLE,
"longitude" DOUBLE,
"latitude" DOUBLE
);
CREATE TABLE music_office_based_businesses_data_captured_in_march_2018 (
"name" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" BIGINT,
"borough_code" VARCHAR,
"ward_2018_name" VARCHAR,
"ward_2018_code" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"easting" DOUBLE,
"northing" DOUBLE,
"longitude" DOUBLE,
"latitude" DOUBLE,
"runtime" TIMESTAMP
);
CREATE TABLE music_recording_data_captured_june_2019 (
"name" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" VARCHAR,
"borough_code" VARCHAR,
"ward_2018_name" VARCHAR,
"ward_2018_code" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"easting" DOUBLE,
"northing" DOUBLE,
"longitude" DOUBLE,
"latitude" DOUBLE
);
CREATE TABLE music_rehearsal_studios_data_captured_june_2019 (
"name" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" VARCHAR,
"borough_code" VARCHAR,
"ward_2018_name" VARCHAR,
"ward_2018_code" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"easting" DOUBLE,
"northing" DOUBLE,
"longitude" DOUBLE,
"latitude" DOUBLE
);
CREATE TABLE music_venues_all_data_captured_march_2018 (
"name" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" DOUBLE,
"borough_code" VARCHAR,
"ward_2018_name" VARCHAR,
"ward_2018_code" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"easting" DOUBLE,
"northing" DOUBLE,
"longitude" DOUBLE,
"latitude" DOUBLE,
"runtime" TIMESTAMP
);
CREATE TABLE music_venues_grassroots_data_captured_in_july_2019 (
"name" VARCHAR,
"borough_name" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" DOUBLE,
"borough_code" VARCHAR,
"ward_2018_name" VARCHAR,
"ward_2018_code" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"easting" DOUBLE,
"northing" DOUBLE,
"longitude" DOUBLE,
"latitude" DOUBLE,
"runtime" TIMESTAMP
);
Anyone who has the link will be able to view this.