Submitting

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:

headerdescriptionmore information
s_idPEP725 station numberPEP725 station list (huge file, be patient)
gss_idplant identifierPEP725 plant list
phase_idphenological phase idPEP725 pheno – phase list
yearYYYY 
daynumber of day in year [1-365/366] 
cult_seasonseason of cultivation0..not applicable,1..summer cereals – sowing in spring, 2..winter cereals – sowing in autumn
affected_flagobservation affected due to to frost, pest, …PEP725 affected flag – under development
qc_ori_flagquality measures provided by our partnersdata flag description – under development