1 / 10

European Database Natura 2000

European Database Natura 2000. 17 June 2009 Mechanical cleanup where possible. Mechanical cleanup?. Remove the obvious errors. Systematicaly remove elements based by simple logic rules. Without changing any context. No manual cleanup. Small statistics. Unique species names.

xena
Download Presentation

European Database Natura 2000

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. European DatabaseNatura 2000 17 June 2009 Mechanical cleanup where possible.

  2. Mechanical cleanup? • Remove the obvious errors. • Systematicaly remove elements based by simple logic rules. • Without changing any context. • No manual cleanup

  3. Small statistics Unique species names. • 32.346 Reported. • 14.839 Only reported in one site. • 4.218 Reported in more then 10 sites.

  4. Strange Characters. [CR][RT] Ì = i (no Unicode) Asci(00) Strange binary data in 10 records. Real blockers Table: Biotop [Field: Docum]???¯ ?/???/ ??????! ???? = ?? ???? o ! ? # ???H¯a ?? ?? 11 Sites have issues.

  5. Species names that have no meaning from a lookup list. " " " " “ - Species names with leading or ending spaces ’ Allium suaveolens ‘ Easy to remove 551 unqiue records = 1490 relations

  6. Actaea erythrocarpa -/V Actaea spicata -/V Alnus glutinosa -/V Arabis alpina -/E Aretostaphylos alpina -/Sh Asplenium septentrionale -/E Asplenium viride -/V Asplenium viride -/V Botrychium multifidum -/St Butomus umbellatus -/V Species names-/v, -/st, -/sh, -/e Numbers... > 20 Nachtschmetterlingsarten > 500 Schmetterlingsarten >175 weitere Lepidoptera >293 Großschmetterligsarten 15 weitere Saltatoria 300 weitere Lepidoptera-Arten 762 weitere Lepidoptera A??? Phylloscopus brehmii A085-Accipiter gentilis A086-Accipiter nisus A096-Falco tinnunculus A110-Alectoris rufa A207 Columba oenas A214 Otus scops A227 Apus pallidus 154 unqiue records = 323 relations

  7. Accipiter gentilis (Linnaeus, 1758) Accipiter nisus (Linnaeus, 1758) Accipiter nisus (sédentaire) Acrocephalus arundinaceus (Linnaeus, 1758) Acrocephalus paludicola (pass.) Acrocephalus palustris (passage) Acrocephalus scirpaceus (Hermann, 1804 Actaea erythrocarpa (E) Actites hypoleucos (Linnaeus, 1758) Actitis hypoleucos (Linnaeus, 1758) Actitis hypoleucos (nid.) Actitis hypoleucos (passage) Species ending with(...) (! Some cases it is on purpose -> other field?) 1201 unqiue records = 2785 relations

  8. We can find but not clean Borderea pyrenaica (Bubani & Bordère ex Gren.) Miégev. Been&White-fronted geese Agrilus guerini Boisduval & Lacordaire, 1835 Vespertilio murinus/Eptesicus serotinus 231 unqiue records

  9. Global Names Index

  10. In_out field should only contain ’I’ and ’O’ ’L’ ’0’ (null) ’ ’ (Space) ’A’ ??? Activity-table(impact) BIOREGION, CONTACTS, DESIGNATIONSTATUS, DIRECTIVES_SPECIES,HABITATS,NATURA2000_SITES,OTHER_SPECIES,SPECIES

More Related