File Formats of PEP725
1. Information for Data Provider
A very short summary what we need from you:
- old file format: is still accepted, but we can not introduce new plants or phases
- Contact info: please provide, check and update your contact information (name, email, organisation, web link)
- Station info: for each observation point we need at least an unique identifier, latitude and longitude. If available altitude as well the station name would be perfect.
- Observations: optimal would be one table in the following format:
s_id;gss_id;phase_id;year;day;cult_season;affected_flag;qc_ori_flag
affected_flag and qc_ori_flag are both optional, the first for affected observations (e.g. late frost) and qc_ori_flag offers the possibility to save your quality or test results (get in contact with us for more details)
2. Information for Data User
A very short summary what you get:
first of all a reminder – please follow our Data Use Policy!
Currently we have two different formats in use. The old one, which is implemented on this website (datasets until 2016). The second format is what you get if you write us an email (e.g. larger datasets, records after 2016, special catchments).
- Self service download: files from this website come in the form of a tar.gz archive – and can be unpacked with appropriate programs (e.g. 7-zip.org). The archive contains 4 files, a readme file, the station list, the definition of the observation phases and a file with the actual observations. Everything is described in the provided README file
- New file format: the new format is larger but is easier to handle as everything is in a single flat file
s_id;provider_id;lon;lat;alt;alt_dem;gss_id;genus;species;subspecies;year;day;date;cult_season;phase_id
s_id;gss_id;phase_id;year;day;cult_season;affected_flag;qc_ori_flag- affected_flag and qc_ori_flag are both optional, the first for affected observations (e.g. late frost) and qc_ori_flag offers the possibility to save your quality or test results (get in contact with us for more details)
3. DATA
The main data set of phenological observation should be submitted in following file structure:
| header | description | more information |
|---|---|---|
| s_id | PEP725 station number | PEP725 station list (huge file, be patient) |
| gss_id | plant identifier | PEP725 plant list |
| phase_id | phenological phase id | PEP725 pheno – phase list |
| year | YYYY | |
| day | number of day in year [1-365/366] | |
| cult_season | season of cultivation | 0..not applicable,1..summer cereals – sowing in spring, 2..winter cereals – sowing in autumn |
| affected_flag | observation affected due to to frost, pest, … | PEP725 affected flag – under development |
| qc_ori_flag | quality measures provided by our partners | data flag description – under development |