Woodland Sites
Plymouth City Council
@ukgov.woodland_sites
Plymouth City Council
@ukgov.woodland_sites
Data that has been collected over the course of 2016 with volunteers on a Citizen Science project at Poole Farm. This is specifically data gained from sampling woodland sites in the Bircham and Forder Valley. The data has been collected using a set methodology set out in bespoke booklets for this survey methodology.
Publisher name: Plymouth City Council
Last updated: 2022-07-01T04:04:31Z
CREATE TABLE sampling_of_woodland_sites_in_bircham_and_forder_valley_2016 (
"date" TIMESTAMP,
"transect" BIGINT,
"quadrat" BIGINT,
"tqcode" VARCHAR,
"species" VARCHAR,
"dafor_d_a_f_o_or_r" VARCHAR -- DAFOR (D, A, F, O Or R),
"shrub_cover_n_0_5" BIGINT -- Shrub Cover N (0-5),
"shrub_cover_e_0_5" BIGINT -- Shrub Cover E (0-5),
"shrub_cover_s_0_5" BIGINT -- Shrub Cover S (0-5),
"shrub_cover_w_0_5" BIGINT -- Shrub Cover W (0-5),
"average_shrub_cover_0_5" DOUBLE -- Average Shrub Cover (0-5),
"canopy_lg" VARCHAR -- Canopy LG (%),
"canopy_overhead" VARCHAR -- Canopy Overhead (%),
"average_canopy_openness" VARCHAR -- Average Canopy Openness (%),
"trampling_1_none_low_2_medium_3_high" VARCHAR -- Trampling (1=none/low; 2=medium; 3=high),
"litter_y_n" VARCHAR -- Litter? (Y/N),
"garden_waste_y_n" VARCHAR -- Garden Waste? (Y/N),
"comments" VARCHAR
);Anyone who has the link will be able to view this.