Title of the dataset: Feature database of Estonian agricultural parcels for crop classification (years 2018-2019).

---INTRODUCTION---

ccdb_18_201001.zip - contains PostgreSQL database dump for the year 2018.

ccdb_19_201001.zip - contains PostgreSQL database dump for the year 2019.

cc_csv_18_201202.zip - contains the feature set database of Estonian agricultural parcels from 2018 as individual CSV files.

cc_csv_19_201202.zip - contains the feature set database of Estonian agricultural parcels from 2019 as individual CSV files.

The .CSV files correspond to the following database tables (before dashed line) and views (after dashed line):
	rita18_crop_201202.csv - crop type info
	rita18_parcel_201202.csv - parcel (field) info and geometry
	rita18_parcel_crop_201202.csv - parcels and crop type relations
	rita18_precipitation_product_201202.csv - list of products/files for precipitation data
	rita18_precipitation_record_201202.csv - precipitation sums for each field and date
	rita18_s1_product_201202.csv - list of products/files for Sentinel-1 data	
	rita18_s2_product_201202.csv - list of products/files for Sentinel-2 data	
	rita18_s1_ts_record_201202.csv - calculated features of Sentinel-1 for each field and date 
	rita18_s2_ts_record_201202.csv - calculated features of Sentinel-2 for each field and date
	rita18_soil_record_201202.csv - soil type for each field
	rita18_temperature_product_201202.csv - list of products/files for temperature data
	rita18_temperature_record_201202.csv - daily average temperature for each field and date
	-------------------------------------------
	rita18_parcelv_narrow_201202.csv - parcels (fields) with valid geometry in narrow classification
	rita18_parcelv_wide_201202.csv - parcels (fields) with valid geometry in wide classification
	rita18_precipitation_recordv_201202.csv - precipitation sums for each field and date (extra columns compared to original table)
	rita18_s1_ts_recordv_201202.csv - calculated features of Sentinel-1 for each field and date (extra columns compared to original table) 
	rita18_s2_ts_recordv_201202.csv - calculated features of Sentinel-2 for each field and date (extra columns compared to original table)
	rita18_soil_recordv_201202.csv - soil type data for each field (extra columns compared to original table)
	rita18_temperature_recordv_201202.zip - daily average temperature for each field and date (extra columns compared to original table)

Similar folder structure and table description applies to cc_csv_19_201202.zip, but data is from year 2019.

Many tables are related with each other. Relation are presented here table by table:
crop: 
	TABLE "parcel_crop" CONSTRAINT "parcel_crop_crop_id_fkey" FOREIGN KEY (crop_id) REFERENCES crop(id)
parcel: 
	TABLE "parcel_crop" CONSTRAINT "parcel_crop_parcel_id_fkey" FOREIGN KEY (parcel_id) REFERENCES parcel(id)
	TABLE "precipitation_record" CONSTRAINT "precipitation_record_parcel_id_fkey" FOREIGN KEY (parcel_id) REFERENCES parcel(id)
	TABLE "result" CONSTRAINT "result_parcel_id_fkey" FOREIGN KEY (parcel_id) REFERENCES parcel(id)
	TABLE "s1_ts_record" CONSTRAINT "s1_ts_record_parcel_id_fkey" FOREIGN KEY (parcel_id) REFERENCES parcel(id)
	TABLE "s2_ts_record" CONSTRAINT "s2_ts_record_parcel_id_fkey" FOREIGN KEY (parcel_id) REFERENCES parcel(id)
	TABLE "soil_record" CONSTRAINT "soil_record_parcel_id_fkey" FOREIGN KEY (parcel_id) REFERENCES parcel(id)
	TABLE "temperature_record" CONSTRAINT "temperature_record_parcel_id_fkey" FOREIGN KEY (parcel_id) REFERENCES parcel(id)
precipitation_product:
	TABLE "precipitation_record" CONSTRAINT "precipitation_record_precipitation_product_id_fkey" FOREIGN KEY (precipitation_product_id) REFERENCES precipitation_product(id)
s1_product:
	TABLE "result" CONSTRAINT "result_s1_product_id_fkey" FOREIGN KEY (s1_product_id) REFERENCES s1_product(id)
    TABLE "s1_ts_record" CONSTRAINT "s1_ts_record_s1_product_id_fkey" FOREIGN KEY (s1_product_id) REFERENCES s1_product(id)
s2_product:
	TABLE "s2_ts_record" CONSTRAINT "s2_ts_record_s2_product_id_fkey" FOREIGN KEY (s2_product_id) REFERENCES s2_product(id)
temperature_product:
	TABLE "temperature_record" CONSTRAINT "temperature_record_temperature_product_id_fkey" FOREIGN KEY (temperature_product_id) REFERENCES temperature_product(id)
	
---METHODOLOGICAL AND DATA SPECIFIC INFORMATION---

All information regarding collecting and processing data can be found from here (in Estonian): https://datadoi.ee/handle/33/314
Full description of the data model, column names, description and type are accessible from the previous link in sub-document 
"D4.1 Kirjanduse ülevaade ja esialgne põllukultuuride tuvastusmudeli kirjeldus" pages 17-26.

See also: https://bitbucket.org/kappazeta/rita-evaluator/src/master/
Please contact Kappazeta Ltd, for any further information: info@kappazeta.ee

---SHARING AND ACCESS INFORMATION---
The data is shared under Creative Commons 4.0 licence.