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

Land And Building Assets

@ukgov.land_and_building_assets3.land_and_building_assets

95.21 kB
1,197 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
);

Table 1

@ukgov.land_and_building_assets3.table_1

13.18 kB
28 rows
12 columns

CREATE TABLE table_1 (
  "dataset_id_dsid" BIGINT  -- Dataset ID (DSID),
  "dataset_name" VARCHAR,
  "field" VARCHAR,
  "type" VARCHAR,
  "mandatory_or_optional_requirement_mor" VARCHAR  -- Mandatory Or Optional Requirement (MOR),
  "field_description" VARCHAR,
  "schema" VARCHAR,
  "lcc_mapping" VARCHAR,
  "schema_comments" VARCHAR,
  "schema_data_rules_comment" VARCHAR,
  "formatreference" VARCHAR,
  "example" VARCHAR
);