About this Dataset

SLDC Local Authority Land

Asset register of the land and buildings owned by South Lakeland District Council (SLDC). The UPRN and GeoX and GeoY information has been included where held, following the announced exemption by Ordnance Survey.
Publisher name: South Lakeland District Council
Last updated: 2024-09-14T17:49:13Z

Tables

SLDC Local Authority Land 2016

@ukgov.sldc_local_authority_land.sldc_local_authority_land_2016

45.08 KB
419 rows
29 columns


CREATE TABLE sldc_local_authority_land_2016 (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "uprn" DOUBLE,
  "uniqueassetidentity" VARCHAR,
  "propertyname" VARCHAR,
  "streetname" VARCHAR,
  "posttown" VARCHAR,
  "postcode" VARCHAR,
  "coordinatereferencesystem" VARCHAR,
  "geox" VARCHAR,
  "geoy" VARCHAR,
  "geopointlicensingurl" VARCHAR,
  "tenure" VARCHAR,
  "tenuretype" VARCHAR,
  "otherdetail" VARCHAR,
  "holdingtype" VARCHAR,
  "buildingsize" VARCHAR,
  "landsize" DOUBLE,
  "servicesfunctionlabel" VARCHAR,
  "servicesfunctioncode" VARCHAR,
  "description" VARCHAR,
  "purpose" VARCHAR,
  "buildingoperationcosts" VARCHAR,
  "requiredmaintenance" VARCHAR,
  "functionalsuitabilityrating" VARCHAR,
  "energyperformancerating" VARCHAR,
  "landregistrytitlenumber" VARCHAR,
  "inspireurl" VARCHAR
);

SLDC Local Authority Land 2017

@ukgov.sldc_local_authority_land.sldc_local_authority_land_2017

44.89 KB
416 rows
29 columns


CREATE TABLE sldc_local_authority_land_2017 (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "uprn" DOUBLE,
  "uniqueassetidentity" VARCHAR,
  "propertyname" VARCHAR,
  "streetname" VARCHAR,
  "posttown" VARCHAR,
  "postcode" VARCHAR,
  "coordinatereferencesystem" VARCHAR,
  "geox" VARCHAR,
  "geoy" VARCHAR,
  "geopointlicensingurl" VARCHAR,
  "tenure" VARCHAR,
  "tenuretype" VARCHAR,
  "otherdetail" VARCHAR,
  "holdingtype" VARCHAR,
  "buildingsize" VARCHAR,
  "landsize" DOUBLE,
  "servicesfunctionlabel" VARCHAR,
  "servicesfunctioncode" VARCHAR,
  "description" VARCHAR,
  "purpose" VARCHAR,
  "buildingoperationcosts" VARCHAR,
  "requiredmaintenance" VARCHAR,
  "functionalsuitabilityrating" VARCHAR,
  "energyperformancerating" VARCHAR,
  "landregistrytitlenumber" VARCHAR,
  "inspireurl" VARCHAR
);

SLDC Local Authority Land 2018

@ukgov.sldc_local_authority_land.sldc_local_authority_land_2018

44.19 KB
428 rows
29 columns


CREATE TABLE sldc_local_authority_land_2018 (
  "n" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "uprn" DOUBLE,
  "uniqueassetidentity" VARCHAR,
  "propertyname" VARCHAR,
  "streetname" VARCHAR,
  "posttown" VARCHAR,
  "postcode" VARCHAR,
  "coordinatereferencesystem" VARCHAR,
  "geox" VARCHAR,
  "geoy" VARCHAR,
  "geopointlicensingurl" VARCHAR,
  "tenure" VARCHAR,
  "tenuretype" VARCHAR,
  "otherdetail" VARCHAR,
  "holdingtype" VARCHAR,
  "buildingsize" VARCHAR,
  "landsize" DOUBLE,
  "servicesfunctionlabel" VARCHAR,
  "servicesfunctioncode" VARCHAR,
  "description" VARCHAR,
  "purpose" VARCHAR,
  "buildingoperationcosts" VARCHAR,
  "requiredmaintenance" VARCHAR,
  "functionalsuitabilityrating" VARCHAR,
  "energyperformancerating" VARCHAR,
  "landregistrytitlenumber" VARCHAR,
  "inspireurl" VARCHAR
);