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

28.66 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

21.38 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

22.36 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

46.45 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

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