LUCAS Copernicus 2018

Joint Research Centre

@ecjrc.cfe66a0c_bdee_4074_96e1_a2f7030b9515

Table List

1 table(10.58 MB)

LUCAS 2018 Copernicus Polygons

@ecjrc.cfe66a0c_bdee_4074_96e1_a2f7030b9515.lucas_2018_copernicus_polygons

10.58 MB
63287 rows
120 columns
Only the first 100 columns are shown

id ID	point_id POINT ID	year YEAR	nuts0 NUTS0	nuts1 NUTS1	nuts2 NUTS2	nuts3 NUTS3	th_lat TH LAT	th_long TH LONG	survey_date SURVEY DATE	car_latitude CAR LATITUDE	car_ew CAR EW	car_longitude CAR LONGITUDE	gps_proj GPS PROJ	gps_prec GPS PREC	gps_altitude GPS ALTITUDE	gps_lat GPS LAT	gps_ew GPS EW	gps_long GPS LONG	obs_dist OBS DIST	obs_direct OBS DIRECT	obs_type OBS TYPE	obs_radius OBS RADIUS	letter_group LETTER GROUP	lc1 LC1	lc1_label LC1 LABEL	lc1_spec LC1 SPEC	lc1_spec_label LC1 SPEC LABEL	lc1_perc LC1 PERC	lc2 LC2	lc2_label LC2 LABEL	lc2_spec LC2 SPEC	lc2_spec_label LC2 SPEC LABEL	lu1 LU1	lu1_label LU1 LABEL	lu1_type LU1 TYPE	lu1_type_label LU1 TYPE LABEL	lu1_perc LU1 PERC	lu2 LU2	lu2_label LU2 LABEL	lu2_type LU2 TYPE	lu2_type_label LU2 TYPE LABEL	parcel_area_ha PARCEL AREA HA	tree_height_maturity TREE HEIGHT MATURITY	tree_height_survey TREE HEIGHT SURVEY	feature_width FEATURE WIDTH	lm_stone_walls LM STONE WALLS	crop_residues CROP RESIDUES	lm_grass_margins LM GRASS MARGINS	grazing GRAZING	special_status SPECIAL STATUS	lc_lu_special_remark LC LU SPECIAL REMARK	cprn_cando CPRN CANDO	cprn_lc CPRN LC	cprn_lc_label CPRN LC LABEL	cprn_lc1n CPRN LC1N	cprnc_lc1e CPRNC LC1E	cprnc_lc1s CPRNC LC1S	cprnc_lc1w CPRNC LC1W	cprn_lc1n_brdth CPRN LC1N BRDTH	cprn_lc1e_brdth CPRN LC1E BRDTH	cprn_lc1s_brdth CPRN LC1S BRDTH	cprn_lc1w_brdth CPRN LC1W BRDTH	cprn_lc1n_next CPRN LC1N NEXT	cprn_lc1s_next CPRN LC1S NEXT	cprn_lc1e_next CPRN LC1E NEXT	cprn_lc1w_next CPRN LC1W NEXT	cprn_urban CPRN URBAN	cprn_impervious_perc CPRN IMPERVIOUS PERC	inspire_plcc1 INSPIRE PLCC1	inspire_plcc2 INSPIRE PLCC2	inspire_plcc3 INSPIRE PLCC3	inspire_plcc4 INSPIRE PLCC4	inspire_plcc5 INSPIRE PLCC5	inspire_plcc6 INSPIRE PLCC6	inspire_plcc7 INSPIRE PLCC7	inspire_plcc8 INSPIRE PLCC8	eunis_complex EUNIS COMPLEX	grassland_sample GRASSLAND SAMPLE	grass_cando GRASS CANDO	wm WM	wm_source WM SOURCE	wm_type WM TYPE	wm_delivery WM DELIVERY	erosion_cando EROSION CANDO	soil_stones_perc SOIL STONES PERC	soil_bio_taken SOIL BIO TAKEN	soil_blk_0_10_taken SOIL BLK 0–10 TAKEN	soil_blk_10_20_taken SOIL BLK 10–20 TAKEN	soil_blk_20_30_taken SOIL BLK 20–30 TAKEN	soil_std_taken SOIL STD TAKEN
69067	26461768	2018	PT	PT1	PT15	PT150	37.112501958	-8.906503574	28/05/18	37.112463	West	8.90672	WGS84	5	182	37.1125	West	-8.9065		On the point	In situ < 100 m	NA	D	D10	Shrubland with sparse tree cover	8	Not relevant	> 75 %	8	Not relevant	8	Not relevant	U420	Semi-natural and natural areas not in use	8	Not relevant	> 90 %	8	Not relevant	8	Not relevant	> 10 ha	> 5 m	< 5 m	> 20 m	No	No	No	No signs of grazing	Protected	No remark	Yes	D1	Shrubland with sparse tree cover	51	51	51	18	888	888	888		8	8	8	A2	No	10	6		94						Unknown		Not relevant	Not relevant	Not relevant	Not relevant	Not relevant	Not relevant	Not relevant	8	Not relevant	Not relevant	Not relevant	Not relevant
121380	26501768	2018	PT	PT1	PT15	PT150	37.121389594	-8.862762502	28/05/18	37.121335	West	8.861145	WGS84	5	122	37.12138	West	-8.862774	1	On the point	In situ < 100 m	NA	C	C22	Pine dominated coniferous woodland	C22A	Pine dominated coniferous woodland - coniferous forest of the mediterranean region	> 75 %	8	Not relevant	8	Not relevant	U120	Forestry	8	Not relevant	> 90 %	8	Not relevant	8	Not relevant	> 10 ha	> 5 m	> 5 m	> 20 m	No	No	No	No signs of grazing	Hunting	No remark	Yes	C2	Coniferous woodland	51	51	51	51	888	888	888	888	8	8	8	8	No		75		25						Other		Not relevant	Not relevant	Not relevant	Not relevant	Not relevant	Not relevant	Not relevant	8	Not relevant	Not relevant	Not relevant	Not relevant
128936	26521762	2018	PT	PT1	PT15	PT150	37.073158701	-8.826303235	28/05/18	37.073373	West	8.826052	WGS84	5	87	37.07316	West	-8.826296	1	On the point	In situ < 100 m	NA	D	D10	Shrubland with sparse tree cover	8	Not relevant	> 75 %	8	Not relevant	8	Not relevant	U420	Semi-natural and natural areas not in use	8	Not relevant	> 90 %	8	Not relevant	8	Not relevant	1 - 10 ha	< 5 m	< 5 m	> 20 m	No	No	No	No signs of grazing	No special status	No remark	Yes	D1	Shrubland with sparse tree cover	30	51	51	51	10	888	888	888	A2	8	8	8	No	5		9	86			5			Unknown		Not relevant	Not relevant	Not relevant	Not relevant	Not relevant	Not relevant	Not relevant	8	Not relevant	Not relevant	Not relevant	Not relevant
53250	26521776	2018	PT	PT1	PT15	PT150	37.196037283	-8.86038452	29/05/18	37.196202	West	8.86016	WGS84	5	76	37.19604	West	-8.860387	1	On the point	In situ < 100 m	NA	E	E20	Grassland without tree/shrub cover	8	Not relevant	> 75 %	8	Not relevant	8	Not relevant	U111	Agriculture (excluding fallow land and kitchen gardens)	8	Not relevant	> 90 %	8	Not relevant	8	Not relevant	1 - 10 ha	Not relevant	Not relevant	Not relevant	No	No	No	Signs of grazing	No special status	No remark	Yes	E2	Grassland without tree/shrub cover	9	51	51	7	10	888	888		A2	8	8	A1	No	30			5	90			5		Not relevant	1	Yes	No visible water management	Not relevant	Not relevant	Not relevant	Yes	Not relevant	8	Not relevant	Not relevant	Not relevant	Not relevant
99974	26521978	2018	PT	PT1	PT17	PT170	38.964564276	-9.371957328	22/05/18	38.964347	West	9.372662	WGS84	5	175	38.96456	West	-9.371954	1	On the point	In situ < 100 m	NA	E	E20	Grassland without tree/shrub cover	8	Not relevant	> 75 %	8	Not relevant	8	Not relevant	U111	Agriculture (excluding fallow land and kitchen gardens)	8	Not relevant	> 90 %	8	Not relevant	8	Not relevant	0.5 - 1 ha	Not relevant	Not relevant	Not relevant	No	No	No	No signs of grazing	No special status	No remark	Yes	E2	Grassland without tree/shrub cover	30	20	5	20	10	70	100	100	D2	D2	B7	D2	No				4	96					Not relevant	1	Yes	No visible water management	Not relevant	Not relevant	Not relevant	Yes	Not relevant	8	Not relevant	Not relevant	Not relevant	Not relevant
50171	26521982	2018	PT	PT1	PT17	PT170	38.999500856	-9.382475202	01/08/18	38.99929	West	9.382208	WGS84	5	119	38.99929	West	-9.382482	24	On the point	In situ < 100 m	NA	D	D20	Shrubland without tree cover	8	Not relevant	> 75 %	8	Not relevant	8	Not relevant	U111	Agriculture (excluding fallow land and kitchen gardens)	8	Not relevant	> 90 %	8	Not relevant	8	Not relevant	1 - 10 ha	Not relevant	Not relevant	Not relevant	No	No	No	Signs of grazing	No special status	No remark	Yes	D2	Shrubland without tree cover	51	51	5	20	888	888		10	8	-1	8	C1	No	5	5		70	20			5		Not relevant		Not relevant	No visible water management	Not relevant	Not relevant	Not relevant	Not relevant	Not relevant	8	Not relevant	Not relevant	Not relevant	Not relevant
76181	26541984	2018	PT	PT1	PT17	PT170	39.02154574	-9.365301028	01/08/18	39.021592	West	9.365839	WGS84	5	108	39.02154	West	-9.365294	1	On the point	In situ < 100 m	NA	E	E20	Grassland without tree/shrub cover	8	Not relevant	> 75 %	8	Not relevant	8	Not relevant	U111	Agriculture (excluding fallow land and kitchen gardens)	8	Not relevant	> 90 %	8	Not relevant	8	Not relevant	0.5 - 1 ha	Not relevant	Not relevant	Not relevant	No	No	No	No signs of grazing	No special status	No remark	Yes	E2	Grassland without tree/shrub cover	20	51	51	51	100	888	888	888	B8	8	8	8	No	10				90			10		Not relevant		Not relevant	No visible water management	Not relevant	Not relevant	Not relevant	Not relevant	Not relevant	8	Not relevant	Not relevant	Not relevant	Not relevant
195169	26561922	2018	PT	PT1	PT17	PT170	38.484174398	-9.181775193	05/07/18	38.484178	West	9.181782	WGS84	5	88	38.48418	West	-9.181783	1	On the point	In situ < 100 m	NA	C	C22	Pine dominated coniferous woodland	C22A	Pine dominated coniferous woodland - coniferous forest of the mediterranean region	> 75 %	8	Not relevant	8	Not relevant	U120	Forestry	8	Not relevant	> 90 %	8	Not relevant	8	Not relevant	> 10 ha	> 5 m	> 5 m	> 20 m	No	No	No	No signs of grazing	No special status	No remark	Yes	C2	Coniferous woodland	51	51	51	51	888	888	888	888	8	8	8	8	No	10	70		15	5			10		Other		Not relevant	Not relevant	Not relevant	Not relevant	Not relevant	Not relevant	Not relevant	8	Not relevant	Not relevant	Not relevant	Not relevant
121345	26561940	2018	PT	PT1	PT17	PT170	38.641593279	-9.228163101	05/07/18	38.641742	West	9.230244	WGS84	5	62	38.64159	West	-9.228169	1	On the point	In situ < 100 m	NA	E	E30	Spontaneously vegetated surfaces	8	Not relevant	> 75 %	8	Not relevant	8	Not relevant	U112	Fallow land	8	Not relevant	> 90 %	8	Not relevant	8	Not relevant	1 - 10 ha	Not relevant	Not relevant	Not relevant	No	No	No	No signs of grazing	No special status	No remark	Yes	E3	Spontaneously re-vegetated surfaces	5	30	51	51	100	90	888	888	B3	8	B3	8	No	50				50			50		Not relevant		Not relevant	Potential irrigation	Other/Not Identifiable	Pressure: Micro-irrigation	Pipeline	Not relevant	Not relevant	8	Not relevant	Not relevant	Not relevant	Not relevant
215777	26561990	2018	PT	PT1	PT16	PT16B	39.078523167	-9.358644744	25/07/18	39.078308	West	9.359646	WGS84	5	66	39.07853	West	-9.358633	1	On the point	In situ < 100 m	NA	B	B15	Oats	8	Not relevant	> 75 %	8	Not relevant	8	Not relevant	U111	Agriculture (excluding fallow land and kitchen gardens)	8	Not relevant	> 90 %	8	Not relevant	8	Not relevant	1 - 10 ha	Not relevant	Not relevant	Not relevant	No	No	No	No signs of grazing	No special status	No remark	Yes	B1	Cereals	20	51	51	51	100	888	888	888	E3	8	8	8	No		888	888	888	888	888	888	888	888	Not relevant		Not relevant	No visible water management	Not relevant	Not relevant	Not relevant	Not relevant	Not relevant	8	Not relevant	Not relevant	Not relevant	Not relevant


CREATE TABLE lucas_2018_copernicus_polygons (
  "id" BIGINT,
  "point_id" BIGINT,
  "year" BIGINT,
  "nuts0" VARCHAR,
  "nuts1" VARCHAR,
  "nuts2" VARCHAR,
  "nuts3" VARCHAR,
  "th_lat" DOUBLE,
  "th_long" DOUBLE,
  "office_pi" BIGINT,
  "ex_ante" BIGINT,
  "survey_date" VARCHAR,
  "car_latitude" DOUBLE,
  "car_ew" VARCHAR,
  "car_longitude" DOUBLE,
  "gps_proj" VARCHAR,
  "gps_prec" BIGINT,
  "gps_altitude" BIGINT,
  "gps_lat" DOUBLE,
  "gps_ew" VARCHAR,
  "gps_long" DOUBLE,
  "obs_dist" BIGINT,
  "obs_direct" VARCHAR,
  "obs_type" VARCHAR,
  "obs_radius" VARCHAR,
  "letter_group" VARCHAR,
  "lc1" VARCHAR,
  "lc1_label" VARCHAR,
  "lc1_spec" VARCHAR,
  "lc1_spec_label" VARCHAR,
  "lc1_perc" VARCHAR,
  "lc2" VARCHAR,
  "lc2_label" VARCHAR,
  "lc2_spec" VARCHAR,
  "lc2_spec_label" VARCHAR,
  "lc2_perc" VARCHAR,
  "lu1" VARCHAR,
  "lu1_label" VARCHAR,
  "lu1_type" VARCHAR,
  "lu1_type_label" VARCHAR,
  "lu1_perc" VARCHAR,
  "lu2" VARCHAR,
  "lu2_label" VARCHAR,
  "lu2_type" VARCHAR,
  "lu2_type_label" VARCHAR,
  "lu2_perc" VARCHAR,
  "parcel_area_ha" VARCHAR,
  "tree_height_maturity" VARCHAR,
  "tree_height_survey" VARCHAR,
  "feature_width" VARCHAR,
  "lm_stone_walls" VARCHAR,
  "crop_residues" VARCHAR,
  "lm_grass_margins" VARCHAR,
  "grazing" VARCHAR,
  "special_status" VARCHAR,
  "lc_lu_special_remark" VARCHAR,
  "cprn_cando" VARCHAR,
  "cprn_lc" VARCHAR,
  "cprn_lc_label" VARCHAR,
  "cprn_lc1n" BIGINT,
  "cprnc_lc1e" BIGINT,
  "cprnc_lc1s" BIGINT,
  "cprnc_lc1w" BIGINT,
  "cprn_lc1n_brdth" BIGINT,
  "cprn_lc1e_brdth" BIGINT,
  "cprn_lc1s_brdth" BIGINT,
  "cprn_lc1w_brdth" BIGINT,
  "cprn_lc1n_next" VARCHAR,
  "cprn_lc1s_next" VARCHAR,
  "cprn_lc1e_next" VARCHAR,
  "cprn_lc1w_next" VARCHAR,
  "cprn_urban" VARCHAR,
  "cprn_impervious_perc" BIGINT,
  "inspire_plcc1" BIGINT,
  "inspire_plcc2" BIGINT,
  "inspire_plcc3" BIGINT,
  "inspire_plcc4" BIGINT,
  "inspire_plcc5" BIGINT,
  "inspire_plcc6" BIGINT,
  "inspire_plcc7" BIGINT,
  "inspire_plcc8" BIGINT,
  "eunis_complex" VARCHAR,
  "grassland_sample" BIGINT,
  "grass_cando" VARCHAR,
  "wm" VARCHAR,
  "wm_source" VARCHAR,
  "wm_type" VARCHAR,
  "wm_delivery" VARCHAR,
  "erosion_cando" VARCHAR,
  "soil_stones_perc" VARCHAR,
  "bio_sample" BIGINT,
  "soil_bio_taken" BIGINT,
  "bulk0_10_sample" BIGINT,
  "soil_blk_0_10_taken" VARCHAR,
  "bulk10_20_sample" BIGINT,
  "soil_blk_10_20_taken" VARCHAR,
  "bulk20_30_sample" BIGINT,
  "soil_blk_20_30_taken" VARCHAR,
  "standard_sample" BIGINT,
  "soil_std_taken" VARCHAR
);