Baselight

MyLondon

Greater London Authority

@ukgov.mylondon

Loading...
Loading...

About this Dataset

MyLondon

My London is a new tool to help people who are moving to London for the first time or who are moving within London. It allows people to define an area or neighbourhood of interest and pulls back an uptodate range of data important to decision making when moving house.
Publisher name: Greater London Authority
Last updated: 2024-09-14T08:09:13Z

Tables

Bounding Boxes

@ukgov.mylondon.bounding_boxes
  • 1.71 MB
  • 25053 rows
  • 10 columns
Loading...

CREATE TABLE bounding_boxes (
  "lsoa" VARCHAR,
  "oa" VARCHAR,
  "left" DOUBLE,
  "bottom" DOUBLE,
  "right" DOUBLE,
  "top" DOUBLE,
  "easting" BIGINT,
  "northing" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Bounding Boxes (LSOA Resolution)

@ukgov.mylondon.bounding_boxes_lsoa_resolution
  • 247.81 KB
  • 4835 rows
  • 6 columns
Loading...

CREATE TABLE bounding_boxes_lsoa_resolution (
  "lsoa" VARCHAR,
  "os" VARCHAR,
  "left" DOUBLE,
  "right" DOUBLE,
  "top" DOUBLE,
  "bottom" DOUBLE
);

Modelled OA Rents

@ukgov.mylondon.modelled_oa_rents
  • 382.1 KB
  • 25053 rows
  • 5 columns
Loading...

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
);

MyLondon Fare Zone OA

@ukgov.mylondon.mylondon_fare_zone_oa
  • 171.5 KB
  • 25053 rows
  • 2 columns
Loading...

CREATE TABLE mylondon_fare_zone_oa (
  "oa11cd" VARCHAR,
  "fare_zone" BIGINT
);

MyLondon LOAC Area Description Text V3

@ukgov.mylondon.mylondon_loac_area_description_text_v3
  • 173.67 KB
  • 25053 rows
  • 3 columns
Loading...

CREATE TABLE mylondon_loac_area_description_text_v3 (
  "oa11cd" VARCHAR,
  "general_description" VARCHAR,
  "oa_description" VARCHAR
);

MyLondon Postcode OA

@ukgov.mylondon.mylondon_postcode_oa
  • 158.86 KB
  • 25053 rows
  • 2 columns
Loading...

CREATE TABLE mylondon_postcode_oa (
  "oa11cd" VARCHAR,
  "pc_dist" VARCHAR
);

MyLondonSchoolsCatchmentv2

@ukgov.mylondon.mylondonschoolscatchmentv2
  • 351.71 KB
  • 25053 rows
  • 13 columns
Loading...

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
);

MyLondon Traveltime To Bank Station OA

@ukgov.mylondon.mylondon_traveltime_to_bank_station_oa
  • 349.34 KB
  • 25053 rows
  • 8 columns
Loading...

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
);

Summary

@ukgov.mylondon.summary
  • 502.63 KB
  • 25053 rows
  • 8 columns
Loading...

CREATE TABLE summary (
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "lad" VARCHAR,
  "rent_per_m" BIGINT,
  "green_spac" DOUBLE,
  "travel" DOUBLE,
  "safety" DOUBLE,
  "schools" DOUBLE
);

Share link

Anyone who has the link will be able to view this.