Name: Group TPO
Creator: UK Government
License: https://data.europa.eu/en/copyright-notice

About this Dataset

Group TPO

Tables

Table 1

@ukgov.group_tpo.table_1

43.61 KB
276 rows
25 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "file_ref" VARCHAR,
  "tree_ref" VARCHAR,
  "title" VARCHAR,
  "address" VARCHAR,
  "town" VARCHAR,
  "location" VARCHAR,
  "tpotype" VARCHAR,
  "species" VARCHAR,
  "species_list" VARCHAR,
  "label" VARCHAR,
  "tpomade" TIMESTAMP,
  "status" VARCHAR,
  "tpoconfirm" TIMESTAMP,
  "tpofell" TIMESTAMP,
  "tporemove" TIMESTAMP,
  "inspected" VARCHAR,
  "inspectdate" TIMESTAMP,
  "updated" TIMESTAMP,
  "origin" VARCHAR,
  "licence" VARCHAR,
  "licenceurl" VARCHAR,
  "captscale" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);