About this Dataset

Council Land And Building Assets

This dataset provides a comprehensive list of council owned land and building assets which are deemed corporately owned. Some assets such as investment properties, void properties, and office accommodation are managed on behalf of the whole council by Asset Management (corporate landlord), whilst others which generally support front line services are managed by the Services themselves (tenants). Definitions and information --------------------------- * “Lease in” and “Leased in” means a property which the council rents from any external company or organisation * “Lease out” and “Leased out” means a council property rented out to an external company or organisation * “Surplus” means that the council has determined that it no longer requires the asset and whilst usually applied to vacant properties this is not necessarily the case * “ Vacant” means not currently used and it’s future has yet to be determined * “Vacant temporarily” means one council user has vacated and another council user will be moving in * “Vacant surplus” means one council user has vacated and it has been determined that the asset is no longer required * There are around 200 properties without a status, this is because the information was not available at the time when the data was prepared. It is likely that these properties are “Council occupied” * Improved descriptions and omissions will be addressed at the next revision In the spirit of openness and transparency, this is a first attempt at producing this list and it is possible that there may be some errors and omissions, the aim however, is to continuously improve on the quality of the data where necessary, in future editions. Local Government Transparency Code 2015 --------------------------------------- * This is a key dataset which the government wants local authorities to publish. * https://www.gov.uk/government/publications/local-government-transparency-code-2015
Publisher name: Leeds City Council
Last updated: 2024-09-14T09:48:38Z

Tables

03/10/2016

@ukgov.council_land_and_building_assets.n_03_10_2016

173.1 KB
2761 rows
20 columns


CREATE TABLE n_03_10_2016 (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" BIGINT,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "unnamed_5" VARCHAR,
  "uprn" DOUBLE,
  "assetcode" VARCHAR,
  "propertyname" VARCHAR,
  "siteaddress" VARCHAR,
  "coordinatereferencesystem" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "geopointlicensinguri" VARCHAR,
  "tenuretype" VARCHAR,
  "tenuredetail" VARCHAR,
  "holdingtype" VARCHAR,
  "heldby" VARCHAR,
  "service" VARCHAR,
  "ward" VARCHAR
);

05/10/2020

@ukgov.council_land_and_building_assets.n_05_10_2020

235.31 KB
5540 rows
8 columns


CREATE TABLE n_05_10_2020 (
  "uniform_asset_ref" VARCHAR,
  "address" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "ward_name" VARCHAR,
  "property_type" VARCHAR,
  "freehold_leasehold_title" VARCHAR,
  "status" VARCHAR
);

14/02/2020

@ukgov.council_land_and_building_assets.n_14_02_2020

267.91 KB
3030 rows
180 columns


CREATE TABLE n_14_02_2020 (
  "held_by" VARCHAR,
  "service" VARCHAR,
  "ward" VARCHAR,
  "uniform_asset_ref" VARCHAR,
  "site_name" VARCHAR,
  "use" VARCHAR,
  "location" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR,
  "unnamed_33" VARCHAR,
  "unnamed_34" VARCHAR,
  "unnamed_35" VARCHAR,
  "unnamed_36" VARCHAR,
  "unnamed_37" VARCHAR,
  "unnamed_38" VARCHAR,
  "unnamed_39" VARCHAR,
  "unnamed_40" VARCHAR,
  "unnamed_41" VARCHAR,
  "unnamed_42" VARCHAR,
  "unnamed_43" VARCHAR,
  "unnamed_44" VARCHAR,
  "unnamed_45" VARCHAR,
  "unnamed_46" VARCHAR,
  "unnamed_47" VARCHAR,
  "unnamed_48" VARCHAR,
  "unnamed_49" VARCHAR,
  "unnamed_50" VARCHAR,
  "unnamed_51" VARCHAR,
  "unnamed_52" VARCHAR,
  "unnamed_53" VARCHAR,
  "unnamed_54" VARCHAR,
  "unnamed_55" VARCHAR,
  "unnamed_56" VARCHAR,
  "unnamed_57" VARCHAR,
  "unnamed_58" VARCHAR,
  "unnamed_59" VARCHAR,
  "unnamed_60" VARCHAR,
  "unnamed_61" VARCHAR,
  "unnamed_62" VARCHAR,
  "unnamed_63" VARCHAR,
  "unnamed_64" VARCHAR,
  "unnamed_65" VARCHAR,
  "unnamed_66" VARCHAR,
  "unnamed_67" VARCHAR,
  "unnamed_68" VARCHAR,
  "unnamed_69" VARCHAR,
  "unnamed_70" VARCHAR,
  "unnamed_71" VARCHAR,
  "unnamed_72" VARCHAR,
  "unnamed_73" VARCHAR,
  "unnamed_74" VARCHAR,
  "unnamed_75" VARCHAR,
  "unnamed_76" VARCHAR,
  "unnamed_77" VARCHAR,
  "unnamed_78" VARCHAR,
  "unnamed_79" VARCHAR,
  "unnamed_80" VARCHAR,
  "unnamed_81" VARCHAR,
  "unnamed_82" VARCHAR,
  "unnamed_83" VARCHAR,
  "unnamed_84" VARCHAR,
  "unnamed_85" VARCHAR,
  "unnamed_86" VARCHAR,
  "unnamed_87" VARCHAR,
  "unnamed_88" VARCHAR,
  "unnamed_89" VARCHAR,
  "unnamed_90" VARCHAR,
  "unnamed_91" VARCHAR,
  "unnamed_92" VARCHAR,
  "unnamed_93" VARCHAR,
  "unnamed_94" VARCHAR,
  "unnamed_95" VARCHAR,
  "unnamed_96" VARCHAR,
  "unnamed_97" VARCHAR,
  "unnamed_98" VARCHAR,
  "unnamed_99" VARCHAR
);

21/12/2018

@ukgov.council_land_and_building_assets.n_21_12_2018

147.66 KB
2764 rows
12 columns


CREATE TABLE n_21_12_2018 (
  "held_by" VARCHAR,
  "ward" VARCHAR,
  "name" VARCHAR,
  "type" VARCHAR,
  "address_incl_postcode" VARCHAR,
  "uprn" BIGINT,
  "easting" BIGINT,
  "northing" BIGINT,
  "lcc_owned_freehold_or_leased_in_leasehold" VARCHAR,
  "freehold_occupied_by_la_ground_lease_leasehold_to_thir_15267394" VARCHAR,
  "n_2018_ward" VARCHAR,
  "unnamed_11" VARCHAR
);

22/11/2017

@ukgov.council_land_and_building_assets.n_22_11_2017

173.84 KB
2778 rows
19 columns


CREATE TABLE n_22_11_2017 (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "unnamed_5" DOUBLE,
  "assetcode" VARCHAR,
  "propertyname" VARCHAR,
  "siteaddress" VARCHAR,
  "coordinatereferencesystem" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "geopointlicensinguri" VARCHAR,
  "tenuretype" VARCHAR,
  "tenuredetail" VARCHAR,
  "holdingtype" VARCHAR,
  "heldby" VARCHAR,
  "service" VARCHAR,
  "ward" VARCHAR
);