Baselight
Sign In

Bristol City Council Land And Building Assets

Bristol City Council

@ukgov.bristol_city_council_land_and_building_assets_2014

Loading...
Loading...

About this Dataset

Bristol City Council Land And Building Assets

This dataset comprises all land and building assets owned, used and/or managed by Bristol City Council, with the exception of individual social housing units, in accordance with the requirements of the Local Government Transparency Code 2014. This is the first annual update of this dataset, the first version having been published in January 2015. As was the case with the original version, it may contain some errors and omissions (particularly with regard to some Council Housing assets which it has still not been possible to include while excluding all individual housing units, as well as the existence of some ground leases which have been difficult or impossible to identify from our database). Some improvements have been made with regard to the accuracy of the data, but we are still striving to correct and improve the data so that future submissions will be increasingly more accurate.
Publisher name: Bristol City Council
Last updated: 2025-01-26T04:02:33Z

Tables

Bristol City Council Land And Building Assets

@ukgov.bristol_city_council_land_and_building_assets_2014.bristol_city_council_land_and_building_assets
  • 358.98 kB
  • 4,039 rows
  • 32 columns
Loading... 
CREATE TABLE bristol_city_council_land_and_building_assets (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "effective_date" TIMESTAMP,
  "uprn" DOUBLE,
  "property_id" BIGINT,
  "property_type" VARCHAR,
  "property_name" VARCHAR,
  "property_name_address_where_no_uprn" VARCHAR  -- Property Name/Address (Where No UPRN),
  "street_number" DOUBLE,
  "secondary_address_detail" VARCHAR,
  "street" VARCHAR,
  "town_post_town" VARCHAR  -- Town / Post Town,
  "postcode" VARCHAR,
  "non_postal_address" VARCHAR  -- Non-Postal Address?,
  "ward" VARCHAR,
  "geo_x_easting" DOUBLE  -- Geo X (Easting),
  "geo_y_northing" DOUBLE  -- Geo Y (Northing),
  "tenure_type" VARCHAR,
  "ground_lease_in" VARCHAR,
  "ground_lease_out" VARCHAR,
  "lease_in_to_council" VARCHAR,
  "lease_out" VARCHAR,
  "licence_in_to_council" VARCHAR,
  "licence_out" VARCHAR,
  "sub_lease_in_to_council" VARCHAR,
  "sub_lease_out" VARCHAR,
  "vacant" VARCHAR,
  "holding_type" VARCHAR,
  "building_size_gia_m2" DOUBLE  -- Building Size - GIA (M2),
  "site_area_hectares" DOUBLE  -- Site Area (Hectares),
  "purpose_asset_category" VARCHAR  -- Purpose / Asset Category,
  "occupied_by_council_direct_service_property" VARCHAR  -- Occupied By Council / Direct Service Property
);

Land And Building Assets 2019

@ukgov.bristol_city_council_land_and_building_assets_2014.land_and_building_assets_2019
  • 339.98 kB
  • 3,804 rows
  • 32 columns
Loading... 
CREATE TABLE land_and_building_assets_2019 (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "effective_date" TIMESTAMP,
  "uprn" DOUBLE,
  "property_id" BIGINT,
  "property_type" VARCHAR,
  "property_name" VARCHAR,
  "property_name_address_where_no_uprn" VARCHAR  -- Property Name/Address (Where No UPRN),
  "street_number" DOUBLE,
  "secondary_address_detail" VARCHAR,
  "street" VARCHAR,
  "town_post_town" VARCHAR  -- Town / Post Town,
  "post_code" VARCHAR,
  "non_postal_address" VARCHAR  -- Non-Postal Address?,
  "ward" VARCHAR,
  "geo_x_easting" DOUBLE  -- Geo X (Easting),
  "geo_y_northing" DOUBLE  -- Geo Y (Northing),
  "tenure_type" VARCHAR,
  "ground_lease_in" VARCHAR,
  "ground_lease_out" VARCHAR,
  "lease_in_to_council" VARCHAR,
  "lease_out" VARCHAR,
  "licence_in_to_council" VARCHAR,
  "licence_out" VARCHAR,
  "sub_lease_in_to_council" VARCHAR,
  "sub_lease_out" VARCHAR,
  "vacant" VARCHAR,
  "asset_type" VARCHAR,
  "building_size_gia_m2" DOUBLE  -- Building Size - GIA (M2),
  "site_area_hectares" DOUBLE  -- Site Area (Hectares),
  "occupied_by_council_direct_service_property" VARCHAR  -- Occupied By Council / Direct Service Property,
  "purpose_asset_category" VARCHAR  -- Purpose / Asset Category
);

Land And Property Assets 2020

@ukgov.bristol_city_council_land_and_building_assets_2014.land_and_property_assets_2020
  • 341.81 kB
  • 3,819 rows
  • 32 columns
Loading... 
CREATE TABLE land_and_property_assets_2020 (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "effective_date" TIMESTAMP,
  "uprn" DOUBLE,
  "property_id" BIGINT,
  "property_type" VARCHAR,
  "property_name" VARCHAR,
  "property_name_address_where_no_uprn" VARCHAR  -- Property Name/Address (Where No UPRN),
  "street_number" DOUBLE,
  "secondary_address_detail" VARCHAR,
  "street" VARCHAR,
  "town_post_town" VARCHAR  -- Town / Post Town,
  "post_code" VARCHAR,
  "non_postal_address" VARCHAR  -- Non-Postal Address?,
  "ward" VARCHAR,
  "geo_x_easting" BIGINT  -- Geo X (Easting),
  "geo_y_northing" BIGINT  -- Geo Y (Northing),
  "tenure_type" VARCHAR,
  "ground_lease_in" VARCHAR,
  "ground_lease_out" VARCHAR,
  "lease_in_to_council" VARCHAR,
  "lease_out" VARCHAR,
  "licence_in_to_council" VARCHAR,
  "licence_out" VARCHAR,
  "sub_lease_in_to_council" VARCHAR,
  "sub_lease_out" VARCHAR,
  "vacant" VARCHAR,
  "asset_type" VARCHAR,
  "building_size_gia_m2" DOUBLE  -- Building Size - GIA (M2),
  "site_area_hectares" DOUBLE  -- Site Area (Hectares),
  "occupied_by_council_direct_service_property" VARCHAR  -- Occupied By Council / Direct Service Property,
  "purpose_asset_category" VARCHAR  -- Purpose / Asset Category
);

Land And Property Assets 2021

@ukgov.bristol_city_council_land_and_building_assets_2014.land_and_property_assets_2021
  • 348.44 kB
  • 3,820 rows
  • 32 columns
Loading... 
CREATE TABLE land_and_property_assets_2021 (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "effective_date" TIMESTAMP,
  "uprn" DOUBLE,
  "property_id" BIGINT,
  "property_type" VARCHAR,
  "property_name" VARCHAR,
  "property_name_address_where_no_uprn" VARCHAR  -- Property Name/Address (Where No UPRN),
  "secondary_address_detail" VARCHAR,
  "street_number" DOUBLE,
  "street" VARCHAR,
  "town_post_town" VARCHAR  -- Town / Post Town,
  "post_code" VARCHAR,
  "non_postal_address" VARCHAR  -- Non-Postal Address?,
  "ward" VARCHAR,
  "geo_x_easting" BIGINT  -- Geo X (Easting),
  "geo_y_northing" BIGINT  -- Geo Y (Northing),
  "tenure_type" VARCHAR,
  "ground_lease_in" VARCHAR,
  "ground_lease_out" VARCHAR,
  "lease_in_to_council" VARCHAR,
  "lease_out" VARCHAR,
  "licence_in_to_council" VARCHAR,
  "licence_out" VARCHAR,
  "sub_lease_in_to_council" VARCHAR,
  "sub_lease_out" VARCHAR,
  "vacant" VARCHAR,
  "asset_type" VARCHAR,
  "building_size_gia_m2" DOUBLE  -- Building Size - GIA (M2),
  "site_area_hectares" DOUBLE  -- Site Area (Hectares),
  "occupied_by_council_direct_service_property" VARCHAR  -- Occupied By Council / Direct Service Property,
  "purpose_asset_category" VARCHAR  -- Purpose / Asset Category
);

Share link

Anyone who has the link will be able to view this.