Land & Property Assets - Rochdale Borough Council
Rochdale Borough Council
@ukgov.land_property_assets_rochdale_borough_council
Rochdale Borough Council
@ukgov.land_property_assets_rochdale_borough_council
Dataset of land and property assets, where the Council has either has an ownership or occupational interest. Council housing stock properties are not part of the land and property dataset. Roads/highways/highway infrastructure are not part of the land and property dataset. The boundaries represent occupational boundaries which may differ from the Council’s legal title boundary. Assets may be subject, in whole or part, to third party interests, for example, tenancies, leases, rights etc. Assets may be subject to long-term leases and therefore the record reflects the Council’s reversionary interest only.
Publisher name: Rochdale Borough Council
Last updated: 2024-09-14T05:32:13Z
CREATE TABLE n_2020_2021_land_and_property_assets (
"organisation_name" VARCHAR,
"effective_date" VARCHAR,
"unique_property_reference_number" VARCHAR,
"unique_asset_identity" BIGINT,
"name_of_the_building_land_or_both" VARCHAR,
"street_name" VARCHAR,
"town" VARCHAR,
"postcode" VARCHAR,
"x" VARCHAR,
"y" VARCHAR,
"tenure_type" VARCHAR,
"tenure_detail_see_list" VARCHAR -- Tenure Detail (see List),
"holding_type" VARCHAR
);CREATE TABLE n_2023_2024_land_and_property_assets (
"unique_asset_identity" BIGINT,
"organisation_name" VARCHAR,
"effective_date" VARCHAR,
"unique_property_reference_number" VARCHAR,
"name_of_the_building_land_or_both" VARCHAR,
"street_name" VARCHAR,
"town" VARCHAR,
"postcode" VARCHAR,
"x" DOUBLE,
"y" DOUBLE,
"tenure_type" VARCHAR,
"tenure_detail_see_list" VARCHAR -- Tenure Detail (see List),
"holding_type" VARCHAR
);Anyone who has the link will be able to view this.