Dataset: Ancient Trees

About this Dataset

Ancient Trees

Data showing the location of all the ancient trees in Plymouth prior to 2016. Any changes in the records of ancient trees made since then will not be reflected within this data.
Publisher name: Plymouth City Council
Last updated: 2022-07-01T04:00:40Z

Tables

Table 1

@ukgov.ancient_trees.table_1

47.49 KB
153 rows
42 columns


CREATE TABLE table_1 (
  "type" VARCHAR,
  "date_of_survey" TIMESTAMP,
  "grid_ref" VARCHAR,
  "species" VARCHAR,
  "girth_measure" DOUBLE,
  "estimated" VARCHAR,
  "height_of" DOUBLE,
  "local_hist" VARCHAR,
  "public_access" VARCHAR,
  "tree_form" VARCHAR,
  "standing_or_fallen" VARCHAR,
  "living_status" VARCHAR,
  "tree_location" VARCHAR,
  "comments_on_location" VARCHAR,
  "veteran_status" VARCHAR,
  "champion_status" VARCHAR,
  "ancient_tr" VARCHAR,
  "ancient_t1" VARCHAR,
  "is_on_a_wo" VARCHAR,
  "organisation" VARCHAR,
  "tree_fungi" VARCHAR,
  "tree_invertebrates" VARCHAR,
  "tree_epiph" VARCHAR,
  "tree_bats" VARCHAR,
  "tree_condition" VARCHAR,
  "tree_protection" VARCHAR,
  "tree_threats" VARCHAR,
  "comment_fr" VARCHAR,
  "legacy_con" VARCHAR,
  "legacy_co1" VARCHAR,
  "publicly_v" VARCHAR,
  "dbrc_photo" VARCHAR,
  "dbrc_and_s" VARCHAR,
  "age_estimate" VARCHAR,
  "saltram_tr" BIGINT,
  "easting" BIGINT,
  "northing" BIGINT,
  "geometry_type" VARCHAR,
  "geometry_coordinates_0_0" DOUBLE,
  "geometry_coordinates_0_1" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);