About this Dataset

GLA Group Land Assets

Data showing the location of the GLA Group's land and property holdings and development opportunities. This data is available to view interactively on the GLA Land and Property Database.
Publisher name: Greater London Authority
Last updated: 2024-09-14T08:12:36Z

Tables

GLA Assets (11/05/2018)

@ukgov.gla_group_land_assets.gla_assets_11_05_2018

27.99 KB
162 rows
20 columns


CREATE TABLE gla_assets_11_05_2018 (
  "objectid" BIGINT,
  "borough" VARCHAR,
  "unique_asset_id" VARCHAR,
  "unique_asset_id_x" DOUBLE,
  "unique_asset_id_y" DOUBLE,
  "holding_name" VARCHAR,
  "address" VARCHAR,
  "post_code" VARCHAR,
  "sub_unit" VARCHAR,
  "uprn" VARCHAR,
  "description" VARCHAR,
  "occupied" VARCHAR,
  "land_building" VARCHAR,
  "asset_category" VARCHAR,
  "tenure" VARCHAR,
  "site_area_hectares" DOUBLE,
  "building_area_gia_sqm" BIGINT,
  "site_area_hectares_1" DOUBLE,
  "easting" BIGINT,
  "northing" BIGINT
);

LFB Assets (11/05/2018)

@ukgov.gla_group_land_assets.lfb_assets_11_05_2018

20.88 KB
116 rows
18 columns


CREATE TABLE lfb_assets_11_05_2018 (
  "objectid" BIGINT,
  "borough" VARCHAR,
  "unique_asset_id" VARCHAR,
  "holding_name" VARCHAR,
  "address" VARCHAR,
  "post_code" VARCHAR,
  "sub_unit" VARCHAR,
  "uprn" VARCHAR,
  "description" VARCHAR,
  "occupied" VARCHAR,
  "land_building" VARCHAR,
  "asset_category" VARCHAR,
  "tenure" VARCHAR,
  "site_area_hectares" DOUBLE,
  "building_area_gia_sqm" DOUBLE,
  "building_area_nia_sqm" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE
);

LLDC Assets (11/05/2018)

@ukgov.gla_group_land_assets.lldc_assets_11_05_2018

21.84 KB
29 rows
29 columns


CREATE TABLE lldc_assets_11_05_2018 (
  "objectid" BIGINT,
  "borough" VARCHAR,
  "unique_asset_id" BIGINT,
  "holding_name" VARCHAR,
  "address" VARCHAR,
  "post_code" VARCHAR,
  "sub_unit" VARCHAR,
  "uprn" VARCHAR,
  "description" VARCHAR,
  "occupied_by_lldc" VARCHAR,
  "land_buildings" VARCHAR,
  "asset_category" VARCHAR,
  "tenure" VARCHAR,
  "site_area_hectares" DOUBLE,
  "building_area_gia_sqm" DOUBLE,
  "building_area_nia_sqm" DOUBLE,
  "easting" BIGINT,
  "northing" BIGINT,
  "field18" VARCHAR,
  "field19" VARCHAR,
  "field20" VARCHAR,
  "field21" VARCHAR,
  "field22" VARCHAR,
  "field23" VARCHAR,
  "field24" VARCHAR,
  "field25" VARCHAR,
  "field26" VARCHAR,
  "occupied_by" VARCHAR,
  "built_out" VARCHAR
);

MPS Assets (11/05/2018)

@ukgov.gla_group_land_assets.mps_assets_11_05_2018

45.36 KB
302 rows
29 columns


CREATE TABLE mps_assets_11_05_2018 (
  "objectid" BIGINT,
  "borough" VARCHAR,
  "unique_asset_id" BIGINT,
  "holding_name" VARCHAR,
  "address" VARCHAR,
  "post_code" VARCHAR,
  "sub_unit" VARCHAR,
  "uprn" VARCHAR,
  "description" VARCHAR,
  "occupied_by_mps" VARCHAR,
  "land_buildings" VARCHAR,
  "asset_category" VARCHAR,
  "tenure" VARCHAR,
  "site_area_hectares" DOUBLE,
  "building_area_gia_sqm" DOUBLE,
  "building_area_nia_sqm" DOUBLE,
  "easting" BIGINT,
  "northing" BIGINT,
  "field18" VARCHAR,
  "field19" VARCHAR,
  "field20" VARCHAR,
  "field21" VARCHAR,
  "field22" VARCHAR,
  "field23" VARCHAR,
  "field24" VARCHAR,
  "field25" VARCHAR,
  "field26" VARCHAR,
  "occupied_by" VARCHAR,
  "built_out" VARCHAR
);

TFL Assets (11/05/2018)

@ukgov.gla_group_land_assets.tfl_assets_11_05_2018

56.82 KB
656 rows
32 columns


CREATE TABLE tfl_assets_11_05_2018 (
  "objectid" BIGINT,
  "borough" VARCHAR,
  "unique_asset_id" VARCHAR,
  "holding_name" VARCHAR,
  "address" VARCHAR,
  "post_code" VARCHAR,
  "sub_unit" VARCHAR,
  "uprn" VARCHAR,
  "description" VARCHAR,
  "occupied_by_tfl" VARCHAR,
  "land_buildings" VARCHAR,
  "asset_category" VARCHAR,
  "tenure" VARCHAR,
  "site_area_hectares" VARCHAR,
  "building_area_gia_sqm" DOUBLE,
  "building_area_nia_sqm" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "field18" VARCHAR,
  "field19" VARCHAR,
  "field20" VARCHAR,
  "field21" VARCHAR,
  "field22" VARCHAR,
  "field23" VARCHAR,
  "field24" VARCHAR,
  "field25" VARCHAR,
  "field26" VARCHAR,
  "field27" VARCHAR,
  "field28" VARCHAR,
  "field29" VARCHAR,
  "occupied_by" VARCHAR,
  "built_out" VARCHAR
);