Potato Cyst Nematode Sampling - Seed Potato Classification Scheme 2013
Animal and Plant Health Agency
@ukgov.potato_cyst_nematode_sampling_seed_potato_classificati_ebc0fabb
Animal and Plant Health Agency
@ukgov.potato_cyst_nematode_sampling_seed_potato_classificati_ebc0fabb
This dataset provides information on the Potato Cyst Nematode (PCN) sampling for entry into the Seed Potato Classification Scheme (SPCS) during 2013. Seed Potatoes are those intended for use as seeds for future crops rather than consumption. The dataset includes the fields: Visit date, Job description, PCN +ve (positive for PCN), Sample area (Hectares), Number of samples, Cysts present Y/N, Cysts non viable, Fields non viable cysts, Area non viable cysts, Cysts viable globodera pallida, Cysts viable globodera rostochiensis, Pallida infested, Area pallida infested, Rostochiensis infested, Area rostochiensis infested, Combined pallida & rostochiensis infested, Area combined pallida & rostochiensis infested. Attribution statement: ©Crown Copyright, APHA 2016
Publisher name: Animal and Plant Health Agency
Last updated: 2023-11-03T00:18:01Z
CREATE TABLE potato_cyst_nematode_sampling_seed_potato_classificati_ebc0fabb (
"region" VARCHAR,
"visit_date" TIMESTAMP,
"job_desc" VARCHAR,
"pcn_ve" VARCHAR -- PCN +ve,
"sample_area_ha" VARCHAR -- Sample Area (Ha.),
"no_samples" DOUBLE -- No. Samples,
"cysts_present_y_n" VARCHAR,
"cysts_non_viable" DOUBLE,
"fields_non_viable_cysts" DOUBLE,
"area_non_viable_cysts" DOUBLE,
"cysts_viable_globodera_pallida" DOUBLE,
"cysts_viable_globoderarostochiensis" DOUBLE,
"pallida_infested" DOUBLE,
"area_pallida_infested" DOUBLE,
"rostochiensis_infested" DOUBLE,
"area_rostochiensis_infested" VARCHAR,
"combined_pallida_rostochiensis_infested" DOUBLE -- Combined Pallida & Rostochiensis Infested,
"area_combined_pallida_rostochiensis_infested" DOUBLE -- Area Combined Pallida & Rostochiensis Infested
);Anyone who has the link will be able to view this.