Name: Ancient Trees
Creator: UK Government
License: http://reference.data.gov.uk/id/open-government-licence

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

48.63 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
);