DCC Property Assets

CREATE TABLE dcc_property_assets (
  "asset_id" BIGINT,
  "name" VARCHAR,
  "secondary_address" VARCHAR,
  "street" VARCHAR,
  "town" VARCHAR,
  "postcode" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "geo_x" DOUBLE,
  "geo_y" DOUBLE,
  "building_gia" DOUBLE,
  "site_area" BIGINT,
  "site_tenure" VARCHAR,
  "sitetype" VARCHAR,
  "site_function" VARCHAR
);