Package to Download and Create the DB of LUCAS Data Harmonized
Add geometries and calculated distance
Add new columns to tables
Add revisit column
Add photo fields 2006
Align mapping CSVs
Assert files
Check mapping CSVs
Conntect to DB
Consistency checks
Harmonize long values in all tables
Correct theoretical long lat
Create tags for harmonized table
Final column order
Merge all tables
Change column order
Update values to fit 2018
Remove unwanted columns
Rename columns to match 2018 survey
User-friendly consistency check
Update Record descriptor
Upload_exif
Update csv to database
Upper case columns
User-friendly LUCAS harmonized
Reproduces the harmonized DB of the ESTAT survey of the same name. The survey data is served as separate spreadsheets with noticeable differences in the collected attributes. The tool here presented carries out a series of instructions that harmonize the attributes in terms of name, meaning, and occurrence, while also introducing a series of new variables, instrumental to adding value to the product. Outputs include one harmonized table with all the years, and three separate geometries, corresponding to the theoretical point, the gps location where the measurement was made and the 250m east-facing transect.