Cultural Infrastructure Map
Greater London Authority
@ukgov.cultural_infrastructure_map1
Greater London Authority
@ukgov.cultural_infrastructure_map1
CREATE TABLE outdoor_spaces_for_cultural_use (
"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,
"alternativenames" VARCHAR,
"greenflagcommunityaward" VARCHAR,
"easting" DOUBLE,
"northing" DOUBLE,
"longitude" DOUBLE,
"latitude" DOUBLE,
"runtime" TIMESTAMP
);
CREATE TABLE prop_costume_making_and_hiring_data_captured_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 pubs_data_provided_by_camra_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,
"easting" DOUBLE,
"northing" DOUBLE,
"longitude" DOUBLE,
"latitude" DOUBLE,
"runtime" TIMESTAMP
);
CREATE TABLE set_and_exhibition_design_and_building_captured_november_2018 (
"name" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"address3" VARCHAR,
"website" VARCHAR,
"os_addressbase_uprn" DOUBLE,
"ward_2018_name" VARCHAR,
"ward_2018_code" VARCHAR,
"borough_name" VARCHAR,
"borough_code" VARCHAR,
"easting" DOUBLE,
"northing" DOUBLE,
"longitude" DOUBLE,
"latitude" DOUBLE,
"runtime" TIMESTAMP
);
CREATE TABLE skate_parks_data_captured_in_january_2019 (
"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,
"easting" DOUBLE,
"northing" DOUBLE,
"runtime" TIMESTAMP
);
CREATE TABLE textiles_design_and_finishing_services_captured_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,
"runtime" TIMESTAMP
);
CREATE TABLE theatre_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,
"longitude" DOUBLE,
"latitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
CREATE TABLE theatre_rehearsal_studios_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,
"longitude" DOUBLE,
"latitude" DOUBLE,
"easting" DOUBLE,
"northing" DOUBLE
);
Anyone who has the link will be able to view this.