Land And Building Assets by UK Government | Finance and Economics

About this Dataset

Land And Building Assets

This dataset contains records of all assets (land and/or buildings) that Lincolnshire County Council has an interest in - whether it be fully owned (freehold), fully leased or partially leased. The dataset also indicates the use of the site, which committee manages the site, and its size and geographic location. It also shows whether the site has restrictions against it due to being in a conservation area or having Listed Building status. The dataset is updated annually each January. - You can freely re-use this data for any purpose. Please attribute as: Contains public sector information licensed from Lincolnshire County Council under the Open Government Licence v3.0. - These copyright statements must be shown: Contains OS data © Crown copyright and database right [year]. Contains Royal Mail data © Royal Mail copyright and database right [year]. Contains National Statistics data © Crown copyright and database right [year].
Publisher name: Lincolnshire County Council
Last updated: 2025-04-13T04:00:02Z

Tables

Table 1

@ukgov.land_and_building_assets3.table_1

12.88 KB
28 rows
12 columns


CREATE TABLE table_1 (
  "dataset_id_dsid" BIGINT,
  "dataset_name" VARCHAR,
  "field" VARCHAR,
  "type" VARCHAR,
  "mandatory_or_optional_requirement_mor" VARCHAR,
  "field_description" VARCHAR,
  "schema" VARCHAR,
  "lcc_mapping" VARCHAR,
  "schema_comments" VARCHAR,
  "schema_data_rules_comment" VARCHAR,
  "formatreference" VARCHAR,
  "example" VARCHAR
);

Land And Building Assets

@ukgov.land_and_building_assets3.land_and_building_assets

92.98 KB
1197 rows
28 columns


CREATE TABLE land_and_building_assets (
  "organisationname" VARCHAR,
  "organisationcode" VARCHAR,
  "publisheddate" TIMESTAMP,
  "latestdata" BOOLEAN,
  "durationfrom" TIMESTAMP,
  "durationto" TIMESTAMP,
  "uniquepropertyreferencenumber" VARCHAR,
  "uniqueassetidentity" VARCHAR,
  "propertyname" VARCHAR,
  "propertynumber" VARCHAR,
  "streetname" VARCHAR,
  "locality" VARCHAR,
  "posttown" VARCHAR,
  "postcode" VARCHAR,
  "coordinatereferencesystem" VARCHAR,
  "geox" BIGINT,
  "geoy" BIGINT,
  "geopointlicensingurl" VARCHAR,
  "attribution" VARCHAR,
  "tenuretype" VARCHAR,
  "registered" VARCHAR,
  "sizebuilding" DOUBLE,
  "sizeland" DOUBLE,
  "purpose" VARCHAR,
  "committee" VARCHAR,
  "listedgrade" VARCHAR,
  "conservationarea" VARCHAR,
  "ancientmonument" VARCHAR
);