MyLondon
Greater London Authority
@ukgov.mylondon
Greater London Authority
@ukgov.mylondon
CREATE TABLE bounding_boxes (
"lsoa" VARCHAR,
"oa" VARCHAR,
"left" DOUBLE,
"bottom" DOUBLE,
"right" DOUBLE,
"top" DOUBLE,
"easting" BIGINT,
"northing" BIGINT,
"latitude" DOUBLE,
"longitude" DOUBLE
);
CREATE TABLE bounding_boxes_lsoa_resolution (
"lsoa" VARCHAR,
"os" VARCHAR,
"left" DOUBLE,
"right" DOUBLE,
"top" DOUBLE,
"bottom" DOUBLE
);
CREATE TABLE modelled_oa_rents (
"oa11cd" VARCHAR,
"ave_rent_1_bedroom" BIGINT,
"ave_rent_2_bedroom" BIGINT,
"ave_rent_3_bedroom" BIGINT,
"ave_rent_4_bedroom" BIGINT
);
CREATE TABLE mylondon_fare_zone_oa (
"oa11cd" VARCHAR,
"fare_zone" BIGINT
);
CREATE TABLE mylondon_loac_area_description_text_v3 (
"oa11cd" VARCHAR,
"general_description" VARCHAR,
"oa_description" VARCHAR
);
CREATE TABLE mylondon_postcode_oa (
"oa11cd" VARCHAR,
"pc_dist" VARCHAR
);
CREATE TABLE mylondonschoolscatchmentv2 (
"oa11cd" VARCHAR,
"pschoolname1" VARCHAR,
"pschool1percent" BIGINT,
"pschoolname2" VARCHAR,
"pschool2percent" VARCHAR,
"pschoolname3" VARCHAR,
"pschool3percent" VARCHAR,
"sschoolname1" VARCHAR,
"sschool1percent" BIGINT,
"sschoolname2" VARCHAR,
"sschool2percent" BIGINT,
"sschoolname3" VARCHAR,
"sschool3percent" VARCHAR
);
CREATE TABLE mylondon_traveltime_to_bank_station_oa (
"oa11cd" VARCHAR,
"driving_distance_miles" DOUBLE,
"driving_time_mins" BIGINT,
"public_transport_time_mins" BIGINT,
"cycling_distance_miles" DOUBLE,
"cycling_time_mins" BIGINT,
"walking_distance_miles" DOUBLE,
"walking_time_mins" BIGINT
);
CREATE TABLE summary (
"oa" VARCHAR,
"lsoa" VARCHAR,
"lad" VARCHAR,
"rent_per_m" BIGINT,
"green_spac" DOUBLE,
"travel" DOUBLE,
"safety" DOUBLE,
"schools" DOUBLE
);
Anyone who has the link will be able to view this.