PEP725
Activity report:
WP1: data base
Anita Jurković
[email protected]
EMS/ECAM 2013, 9.-13. Sept. Reading, United Kingdom
OBJECTIVES OF WP1: Data Base [DB] /Quality Control [QC]
• continuous monitoring and maintenance of our PEP725 DB
• import of datasets
routinely: updates – currently 2013 is running
additionally: implementation of historical datasets
• adaption , re- configuration of table structure
new definition: plants, cultivar, animals, species, bbch, flag
• QC
in general: concept development
pre checks, consistency checks of incoming data sets
including check of metadata
testing of semi-automatical QC-procedures
EMS/ECAM 2013, 9.-13. Sept. Reading, United Kingdom
OVERVIEW
• NEWS
• DATA CONTANT DB: current status - updates 2013
• RESTRUCTURE: table pep_provider
• HISTORICAL DATASETS: implementation - challenges - outlook
• REAL-TIME DATA: school project Saxony/Germany
• WORK IN PROGRESS:
• BBCH CODE: new coding system
• PLANTS: table - new structure - standardized taxonomic codes
• ANIMALS: new table - first concept plans and table structures
• QC: multistage - concept - test phase - fully / semi automation
• SYNCHRONIZATION: Austrian db - pep725 database
EMS/ECAM 2013, 9.-13. Sept. Reading, United Kingdom
NEWS
EMS/ECAM 2013, 9.-13. Sept. Reading, United Kingdom
PEP station network:
station network PEP725
#20.558
periods of
observations
Germany
Slovenia
Austria
Czech Republic
Switzerland
Slovakia
Luxenbourg
Belgium
Norway
Latvia
Finland
Lithuania
France
Spain
Poland
Romania
Netherland
Sweden
Ireland
United Kingdom
Croatia
Italy
Hungary
Republic of Serbia
Bosnia and Herzegovina
EMS/ECAM 2013, 9.-13. Sept.1865
Reading,
Kingdom
1875 United
1885 1895
1905 1915 1925 1935 1945 1955 1965 1975 1985 1995 2005 2015
So please sent us your
updates:
update 2013 completed
update in progress
update from parts of the country
in contact, waiting for data
establishing contact
no information
[email protected];
[email protected]
documentation and more
information:
http://www.pep725.eu/pr
oject/submitting.php
EMS/ECAM 2013, 9.-13. Sept. Reading, United Kingdom
METADATA: table pep_provider – structured coding
country_id country_name
1 Germany
2 Slovenia
3 Austria
4 Czech Republic
5 Switzerland
6 Slovakia
7 Luxenbourg
8 Belgium
9 Norway
10 Latvia
11 Finland
12 Lithuania
13 France
14 Spain
15 Poland
16 Romania
provider_id provider_id_old
101
106
102
NEW!
301
101
401
103
501
107
601
NEW!
1101
104
1401
NEW!
2101
102
2201
NEW!
2202
NEW!
2601
105
2701
NEW!
country_id
17
18
19
20
21
22
23
25
26
27
28
29
31
32
33
country_name
Netherland
Sweden
Ireland
United Kingdom
Croatia
Italy
Hungary
Republic of Serbia
Bosnia and Herzegovina
Montenegro
Bulgaria
Greece
Macedonia
Denmark
Portugal
provider_org
DWD
SACHSEN (SCHOOL)
ZAMG
CHMI
METEOSCHWEIZ
SHMU Slovakia
METLA
SMC-Meteocat
DHMZ
CRI
CRA-CMA
FHMZBIH
ZHMS Crna Gora
• 6 new providers
• 3 new contacts
Portugal
Macedonia
Ireland
provider_name
Kirsten Zimmermann
Falk Boettcher
Elisabeth Koch
Lenka Hajkova
Barbara Pietragalla
Zora Snopkova
Eero Kubin
Montse Busto; Jordi Cunillera
Visnja Vucetic
Emanuele Eccel
Giovanni Dal Monte
Sabina Hozdic
Tonka Popovic
provider_email
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]; [email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
EMS/ECAM 2013, 9.-13. Sept. Reading, United Kingdom
provider_web
country
http://www.dwd.de/phaenologie
DE
http://www.umwelt.sachsen.de/umwelt/klim
DE
http://zacost.zamg.ac.at/phaeno_portal/
AT
http://www.chmi.cz/portal/dt?portal_lang=c
CZ
http://www.meteoschweiz.admin.ch/web/d
CH
NA
SK
http://www.metla.fi
FI
http://www20.gencat.cat/portal/site/meteo
ES
http://klima.hr/agro.php?id=agro_zanimljivo
HR
http://cri.fmach.eu/DA
IT
http://cma.entecra.it/iphen/index.html
IT
http://fhmzbih.gov.ba
BA
NA
ME
IMPLEMENTAION OF HISTORICAL DATASETS
Germany: 1530-1983
Austria: 1948-
CHALLENGES:
old-new plant classifications (latin nomenclature)
historical latin name:
HEMEROCALLIS COEROLEA
after research most likely: old writing – mistake in writing
HEMEROCALLIS CAERULEA
current latin name:
HOSTA SIEBOLDIANA
OUTLOOK:
Hungary: 1952-1998
Montenegro: 1951-now
Austria: 1926-1931
EMS/ECAM 2013, 9.-13. Sept. Reading, United Kingdom
REAL TIME DATA FROM GERMANY- SAXONY
• school project started in 2013
• 5 partner schools
• pupils observe 11 plants/phases
NR
1
2
3
4
5
6
plant_name
Galanthus nivalis
Salix caprea
Ribes grossularia
Malus x domestica
Sambucus
Tilia platyphyllos
phase
Beginning of flowering
Beginning of flowering
Leaf unfolding
Beginning of flowering
Beginning of flowering
Beginning of flowering
NR
7
8
9
10
11
plant_name
Malus x domestica
Sambucus
Quercus robur
Quercus robur
Quercus robur
phase
Fruits ripe for picking
First ripe fruits
First ripe fruits
Autumnal coloring of leaves (50%)
50 % autumnal leaf fall
• more information: http://www.umwelt.sachsen.de/umwelt/klima/30686.htm
• weekly updates with semi-automatically insert routines
• additionally: transmission of 25 DWD ‘Sofortmelder’ stations
(reporting immediately )
EMS/ECAM 2013, 9.-13. Sept. Reading, United Kingdom
WORK IN PROGRESS
EMS/ECAM 2013, 9.-13. Sept. Reading, United Kingdom
BBCH code:
• not always clear defined: different classification plants-bbch
• need for a subcategoration
Example Swedish data set:
0 = summergreen
1 = starting to show colors
2 = 1/3 of the leaves colored
3 = 2/3 of the leaves colored
4 = no (<5%) remaining green leaves
pep database
92 = leaves beginning to discolor
94 = autumnal coloring of leaves (50%)
95 = 50% autumnal leaf fall
96 = coloring of leaves (100%)
97=end of autumnal leaf fall (95% fallen)
POSSIBLE SOLUTION:
-> 92=leaves beginning to discolor
-> 903=30% of leaves discolored
-> 907=70% of leaves discolored
-> 96=coloring of leaves (100%)
bbch – blackwell soya bean
91 901 10% of leaves discolored or fallen
92 902 20% of leaves discolored or fallen
93 903 30% of leaves discolored or fallen
94 904 40% of leaves discolored or fallen
95 905 50% of leaves discolored or fallen
96 906 60% of leaves discolored or fallen
EMS/ECAM 2013, 9.-13. Sept. Reading, United Kingdom
DEFINITION OF PLANTS
OLD SYSTEM: 2 tables: pep_plant; pep_cultivar (more specific)
CHALLENGE: implementation of other and additive plants/ cultivars
• extension of pep region (additional providers)
• historical data sets
• new system – table structure
POSSIBLE SOLUTION: standardized taxonomic codes - discussion in facebook group
https://www.dyntaxa.se\ Swedish taxonomic descriptions
http://www.eu-nomen.eu/portal/
www.itis.gov US IT IS database
http://biodiver.bio.ub.es/biocat/index.jsp ;http://ichn.iec.cat/bages/index/index.htm
http://www.floracatalana.es/INICI/INICI.html Spanish specifications
EMS/ECAM 2013, 9.-13. Sept. Reading, United Kingdom
ANIMAL OBERRVATIONS:
• pep_phase: additional entries – marked with neg. codes
EMS/ECAM 2013, 9.-13. Sept. Reading, United Kingdom
bbch
-100
-101
-102
-103
-111
-112
-121
-122
-201
-211
-212
-213
-221
-222
-223
-224
-231
-241
-301
-302
-311
-400
-401
-402
-403
-404
-501
-511
-512
-513
-521
-531
-601
-602
-801
-802
description-stage_en
description-stage_de
Active_individuals
Aktive_Exemplare
Active_adults
Aktive_adulte_Tiere
Active_juveniles
Aktive_Jungtiere
First_individual
Erstes_Expemplar
Adults_on_land
Adulte_Tiere_am_Land
Adults_in_water
Adulte_Tiere_im_Wasser
Individuals_at_a_light
Exemplare_an_einer_Lichtquelle
Individuals_in_a_net
Exemplare_mit_Netz_gefangen
Flower_visitation
Blütenbesuch
Vocalizing_singing
Lautgebung_Gesang
Male_combat
Kämpfende_Männchen
Mating
Paarung
Nest_building
Nestbau
Egg_laying
Eiablage
Fresh_eggs
Frischeier
Nesting
Brüten
Caterpillars_in_tent
Raupen_in_Gespinst
pupation
Verpuppung
Juveniles_on_land
Jungtiere_am_Land
Juveniles_in_water
Jungtiere_im_Wasser
Recently_emerged_adults
Übergang_zum_adulten_Tier
Migrating_adults
Wandernde_adulte_Tiere
Adults_migrating_upstream
Wandernde_adulte_Tiere_flussaufwärts
Adults_migrating_downstream
Wandernde_adulte_Tiere_flussabwärts
Juveniles_moving_upstream
Wandernde_Jungtiere_flussaufwärts
Left_habitat
Abzug
Individuals_on_a_hook
Exemplare_mit_Haken_gefangen
Fruit_seed_consumption
Aufnahme_von_Früchten_oder_Samen
Nut_gathering
Sammeln_von_Nüssen
Carnal_consumption
Aufnahme_von_tierischem_Futter
Feeding
Füttern
Individuals_at_a_feeding_station
Exemplare_an_Futterstelle
Dead_or_dying_adults
Tote_oder_sterbende_adulte_Tiere
Dead_or_dying_juveniles
Tote_oder_sterbende_Jungtiere
Summer_coat
Sommerfell
EMS/ECAM 2013, 9.-13. Sept. Reading, United Kingdom
Winter_coat
Winterfell
ANIMAL OBERRVATIONS:
occurrence/observation
• pep_phase: additional entries – marked with neg. codes
mating and reproduction
juveniles
movement
feed behavior
ANIMAL OBERRVATIONS:
• pep_phase: additional entries – marked with neg. codes
• pep_animal: NEW table equivalent to pep_plant -> composite pep_class
class_id
100
200
300
400
500
sci_name
mammalia
aves
amphibia
reptilia
insecta
german_name
Säugetiere
Vögel
Amphibien
Reptilien
Insekten
english_name
mammals
birds
amphibians
reptiles
insects
EMS/ECAM 2013, 9.-13. Sept. Reading, United Kingdom
ANIMAL OBERRVATIONS:
• pep_phase: additional entries – marked with neg. codes
• pep_animal: NEW table equivalent to pep_plant
• pep_species: NEW table equivalent to pep_cultivar -> composite to pep_species
species_id
10
20
21
22
23
24
25
26
27
28
30
40
50
51
52
53
54
sci_name
english_name
Microbats
Microchiroptera Sp.
Alauda arvensis
Eurasian Skylark
Gartenrotschwanz
Phoenicurus phoenicurus
Pyrrhula pyrrhula
Bullfinch
Cuculus canorus
Common Cuckoo
Hirundo rustica
Barn Swallow
Sturnus vulgaris
Common Starling
Scolopax rusticola
Eurasian Woodcock
Anas platyrhynchos
Wild Duck
Anser anser
Greylag Goose
Pelophylax Sp.
Green frog
Lacerta agilis
Sand Lizard
Nymphalis urticae
Small Tortoiseshell
Apis mellifera
European Honey Bee
Pieris brassicae
Large White
Melolontha melolontha Cockchafer
Gonepteryx rhamni
Common Brimstone
EMS/ECAM 2013, 9.-13. Sept. Reading, United Kingdom
german_name
Fledermaus
Feldlerche
Common Redstart
Gimpel
Kuckuck
Rauchschwalbe
Star
Waldschnepfe
Wildente
Wildgans
Wasserfrosch
Zauneidechse
Fuchsfalter
Honigbiene
Kohlweißling
Maikäfer
Zitronenfalter
ANIMAL OBSERVATIONS:
• pep_phase: additional entries – marked with neg. codes
• pep_animal: NEW table equivalent to pep_plant
• pep_species: NEW table equivalent to pep_cultivar
• Austrian animal observation: example and mapping
OLD: code 218: all swallows away
NEW:
s_id
xxx
class_id
200/birds
species_id
24/barn swallow
bbch
-404/left_habitat
EMS/ECAM 2013, 9.-13. Sept. Reading, United Kingdom
year
xxx
day
xxx
flag
xxx
EMS/ECAM 2013, 9.-13. Sept. Reading, United Kingdom
SYNCHRONIZATION OF NATIONAL – INTERNATIONAL DATABASE
GOAL:
• Implementation of all observations (additional plants and animals)
• Automatic and real-time synchronization (weekly)
[SYBASEinternal use]
international
data base
[SYBASEinternal use]
historical data
EMS/ECAM 2013, 9.-13. Sept. Reading, United Kingdom
WEBPAGE
http://zacost.zamg.ac.at/phaeno
_portal/
national
data base
PEP 725
AUSTRIA
real-time data
PEP 725 data
base
[MYSQL]

IMAGINARY report English (pdf)