Local Authority Land 2015

@ukgov.local_authority_owned.local_authority_land_2015

94.42 KB
1667 rows
12 columns


CREATE TABLE local_authority_land_2015 (
  "uprn" VARCHAR,
  "site_name" VARCHAR,
  "address" VARCHAR,
  "type_of_site" VARCHAR,
  "tenure" VARCHAR,
  "operational_status" VARCHAR,
  "gia" DOUBLE,
  "lease_information" VARCHAR,
  "site_function" VARCHAR,
  "sub_function" VARCHAR,
  "function_detail" VARCHAR,
  "notes_other" VARCHAR
);

Local Authority Land 2016

@ukgov.local_authority_owned.local_authority_land_2016

127.78 KB
1922 rows
17 columns


CREATE TABLE local_authority_land_2016 (
  "uprn" VARCHAR,
  "site_name" VARCHAR,
  "address" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "type_of_site" VARCHAR,
  "tenure" VARCHAR,
  "operational_status" VARCHAR,
  "gia" DOUBLE,
  "lease_information" VARCHAR,
  "site_function" VARCHAR,
  "sub_function" VARCHAR,
  "function_detail" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR
);

Local Authority Land 2017

@ukgov.local_authority_owned.local_authority_land_2017

132.7 KB
1976 rows
13 columns


CREATE TABLE local_authority_land_2017 (
  "uprn" VARCHAR,
  "site_name" VARCHAR,
  "address" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "holding_type" VARCHAR,
  "tenure" VARCHAR,
  "operational_status" VARCHAR,
  "gia" DOUBLE,
  "lease_information" VARCHAR,
  "site_function" VARCHAR,
  "sub_function" VARCHAR,
  "function_detail" VARCHAR
);

Local Authority Land 2018

@ukgov.local_authority_owned.local_authority_land_2018

132.16 KB
2014 rows
13 columns


CREATE TABLE local_authority_land_2018 (
  "uprn" VARCHAR,
  "site_name" VARCHAR,
  "address" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "holding_type" VARCHAR,
  "tenure" VARCHAR,
  "operational_status" VARCHAR,
  "gia" DOUBLE,
  "lease_information" VARCHAR,
  "site_function" VARCHAR,
  "sub_function" VARCHAR,
  "function_detail" VARCHAR
);

Local Authority Land 2019

@ukgov.local_authority_owned.local_authority_land_2019

169.79 KB
2588 rows
14 columns


CREATE TABLE local_authority_land_2019 (
  "uprn" VARCHAR,
  "site_name" VARCHAR,
  "address" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "ward" VARCHAR,
  "holding_type" VARCHAR,
  "tenure" VARCHAR,
  "operational_status" VARCHAR,
  "gia" DOUBLE,
  "lease_information" VARCHAR,
  "site_function" VARCHAR,
  "sub_function" VARCHAR,
  "function_detail" VARCHAR
);

Local Authority Land 2020

@ukgov.local_authority_owned.local_authority_land_2020

169.49 KB
2574 rows
14 columns


CREATE TABLE local_authority_land_2020 (
  "uprn" VARCHAR,
  "site_name" VARCHAR,
  "address" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "ward" VARCHAR,
  "holding_type" VARCHAR,
  "tenure" VARCHAR,
  "operational_status" VARCHAR,
  "gia" DOUBLE,
  "lease_information" VARCHAR,
  "site_function" VARCHAR,
  "sub_function" VARCHAR,
  "function_detail" VARCHAR
);

Local Authority Land 2021

@ukgov.local_authority_owned.local_authority_land_2021

201.88 KB
3134 rows
14 columns


CREATE TABLE local_authority_land_2021 (
  "uprn" VARCHAR,
  "site_name" VARCHAR,
  "address" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "ward" VARCHAR,
  "holding_type" VARCHAR,
  "tenure" VARCHAR,
  "operational_status" VARCHAR,
  "gia" DOUBLE,
  "lease_information" VARCHAR,
  "site_function" VARCHAR,
  "sub_function" VARCHAR,
  "function_detail" VARCHAR
);

Local Authority Land 2023

@ukgov.local_authority_owned.local_authority_land_2023

211.94 KB
3241 rows
14 columns


CREATE TABLE local_authority_land_2023 (
  "uprn" VARCHAR,
  "site_name" VARCHAR,
  "address" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "ward" VARCHAR,
  "holding_type" VARCHAR,
  "tenure" VARCHAR,
  "operational_status" VARCHAR,
  "gia" DOUBLE,
  "lease_information" VARCHAR,
  "site_function" VARCHAR,
  "sub_function" VARCHAR,
  "function_detail" VARCHAR
);

Local Authority Land

About this Dataset