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
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,
"holding_type" VARCHAR
);
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,
"holding_type" VARCHAR
);
Anyone who has the link will be able to view this.