Project

General

Profile

ExpertsDatabase » History » Version 8

Andreas Kohlbecker, 09/25/2007 06:45 PM

1 1 Markus Döring
_This page is about an taxonomic experts (meta)database_
2
3
4
{{>toc}}
5
6
7
8
9
----
10
11
12
# Experts Database
13
14
15
## Overview
16
17 2 Markus Döring
The objective of this information service is to provide an efficient online information service on European Taxonomic experts, their expertise and ongoing and planned taxonomic research projects, building on existing services and content from previous efforts. The in-formation service is for internal as well as external use, but it will be designed (and con-tent collected) with high priority on meeting the needs for information by EDIT partners regarding: 
18 1 Markus Döring
19
20 2 Markus Döring
* Provision of a better knowledge base for an integrated recruitment strategy in EDIT 
21 1 Markus Döring
22 2 Markus Döring
* Taxonomic information backbone and Pan-European checklist activities of WP3 
23 1 Markus Döring
24 2 Markus Döring
* Coordination of research organised by WP4 (especially regarding methodology) 
25 1 Markus Döring
26 2 Markus Döring
* Formation of networks, committees and task-forces for WP6 and WP7 activities 
27 1 Markus Döring
28 2 Markus Döring
* WP8s assessment of training resources for taxonomy in Europe 
29 1 Markus Döring
30
31 2 Markus Döring
As agreed at the EDIT WP2 kick-off meeting in Paris, June 29 2006, the secretariat of the EDIT WP2 drafted an outline of: 
32 1 Markus Döring
33
34 2 Markus Döring
* How to collect contents for the WP2 online information service on taxonomic experts, their expertise, and their ongoing and planned research 
35 1 Markus Döring
36 2 Markus Döring
* An experts/expertise and project database structure, based on previous similar efforts 
37 1 Markus Döring
38
39 2 Markus Döring
The draft has been reviewed by the WP2 partners, modified accordingly and formatted into this current draft which acts as the beginning of a specification of 
40 1 Markus Döring
41
42 2 Markus Döring
* The form to enter or update data on experts 
43 1 Markus Döring
44 2 Markus Döring
* The actual database structure behind the information service 
45 1 Markus Döring
46 2 Markus Döring
* What the service (the product) should be able to do 
47 1 Markus Döring
48 2 Markus Döring
* How we could achieve designing and implementing the service. 
49 1 Markus Döring
50
51 2 Markus Döring
The product, a web-based information service on taxonomists, their fields of expertise and their interests / ongoing and planned research projects, should enable filtering and search facilities to find taxonomic experts based on any combination of criteria regarding: 
52 1 Markus Döring
53
54 2 Markus Döring
* Their taxonomic expertise in 7 kinds of taxonomic activities (Enghoff &Seberg, 2006 and see below), within taxa - searchable by all levels down to family 
55 1 Markus Döring
56 2 Markus Döring
* Geographic area(s) (countries, terrestrial areas, aquatic areas) their expertise relates to 
57 1 Markus Döring
58 2 Markus Döring
* Environment of their taxonomic group (see elaboration below) 
59 1 Markus Döring
60 2 Markus Döring
* Their ongoing taxonomic research 
61 1 Markus Döring
62 2 Markus Döring
* National / International taxonomic research projects they are involved in 
63 1 Markus Döring
64 2 Markus Döring
* Country they reside in 
65 1 Markus Döring
66 2 Markus Döring
* Institution they work in 
67 1 Markus Döring
68
69 2 Markus Döring
In order to find an existing system to fulfill the above roughly specified needs we started an intensive market screening and product survey on the internet. Hence we have initiated a collection of URLs for relevant existing services that contain data which could be in-cluded in the WP2 service – see http://www.connotea.org/user/icalabuig/tag/List%20taxonomic%20experts?num=100. This list should be heavily expanded, including the list of resources that keep catalogues of experts. Suggestions are most welcome! 
70 1 Markus Döring
71
72 2 Markus Döring
Please note: The survey only included services which offer information related to taxon-omy / biodiversity, and did not include other e.g. commercial and / or off-the-shelf prod-ucts designed for other purposes (health sciences etc.). 
73 1 Markus Döring
74
75 2 Markus Döring
Importantly, the German GTI-toolkits’ chapter Lists & databases on taxonomic experts will be explored further by the WP2 secretariat and hopefully, based on discussions with the German GTI focal point, selected content from this database may be included in the WP2 service. 
76 1 Markus Döring
77
78 2 Markus Döring
In addition to relevant contents, the following services also have very relevant filter & query features and other functionality that have acted as inspiration for the WP2 service: 
79 1 Markus Döring
80
81 2 Markus Döring
* ETI World Taxonomist Database: http://www.eti.uva.nl/tools/wtd.php, hosted and maintained by ETI – the Expert Center for Taxonomic Identification. 
82 1 Markus Döring
83 2 Markus Döring
* DAISIE European Alien Species Expertise Registry http://daisie.ckff.si/ 
84 1 Markus Döring
85
86 2 Markus Döring
The portal contains special functionality, to our knowledge not covered by any of the other services, which we think would suit the needs of the WP2 information service – see elaboration below. 
87 1 Markus Döring
88
89 2 Markus Döring
* “New Accession States” extension to Fauna Europaea, FaEu?-NAS http://zoology.fns.uniba.sk/faeu/search_service/search_index.htm 
90 1 Markus Döring
91 2 Markus Döring
* Fauna Europaea experts database http://www.faunaeur.org/experts.php 
92 1 Markus Döring
93
94 2 Markus Döring
Further services to explore for possible integration / linking / inspiration / migration of content etc. as per February 19, 2007, based on recent feed-back from EDIT WP2 partners: 
95 1 Markus Döring
96
97 2 Markus Döring
* Walther Berendsohn: Recommends integrating with Index Herbariorum, http://sciweb.nybg.org/science2/IndexHerbariorum.asp 
98 1 Markus Döring
99 2 Markus Döring
* Marian Ramos: Possible import of data from SYNTHESYS matrix on experts, and fur-ther development/re-use of tools developed under Fauna Iberica, see http://faunaiberica.org/ to be explored further 
100 1 Markus Döring
101 2 Markus Döring
* Jackie Van Goethem: The very recently released Belgian information service BioBel? http://biobel.biodiversity.be/ 
102 1 Markus Döring
103
104 2 Markus Döring
Recently, it has been concluded that the Filemaker database on taxonomic expertise de-veloped by the German GTI focal Point matches the needs for the WP2 information service. Hence, a similar database application will be developed by EDIT WP5 for use in the EDIT network of institutions. 
105 1 Markus Döring
106
107
108 2 Markus Döring
### Conclusion
109 1 Markus Döring
110 2 Markus Döring
There might be several other splendid services out there, which the WP2 secretariat does not yet know about, but these are the main ones we have been able to find based on own search and a query among EDIT partner institutions. Based on the above market screening and information provided by product vendors and suppliers we must conclude that there are no current systems capable of fulfilling our main requirements. There may be systems or commercial products which might be able to fulfill our requirements by modification or adaptation of the system / product. We are not IT-literates though, and invite all kinds of comments and suggestions to solve this task of building an information service. 
111 1 Markus Döring
112
113
114 2 Markus Döring
## Specification
115 1 Markus Döring
116
117 2 Markus Döring
### Data model
118 1 Markus Döring
119 2 Markus Döring
For every expert the following metadata should be stored:
120
121 1 Markus Döring
122 4 Markus Döring
~~~
123
#!CSV
124
Name of major Tab	Name of category within Tab	Legend for text field to complete by expert	Comment	Discussion of design/implementation 
125
Contact information	Name 	First & middle name 	Free text	
126
		Last Name 	Free text	
127
		Title 	Choose one from drop-down list 	
128
		Nickname 	Free text	
129
	E-Mail 	E-mail 	List up to 5 addresses and choose one as Default through radio button. 	
130
	Institution / Organisation / University 	Institution 	Free text	
131
		Division / Department 	Free text	
132
		Office 	Free text	
133
		Institutional Acronym 	Free text	
134
	Mailing Address 	Street Address 	Free text	
135
		Postal or ZIP code 	Free text	
136
		City 	Free text	
137
		Country 	Choose one from drop-down list 	Would be good to be able to scroll in the drop down list. Also write one letter(e.g. “D”) and it jumps in the menu (to e.g. Denmark)
138
		State / Province 	Choose one from drop-down list created based on country selected 	
139
	Phone/Communications (including country code) 	Phone 		
140
		Mobile 		
141
		Fax 		
142
		Phone PA 		
143
	Internet URL	Institutional / Project related www 	Allow to list up to three URLs 	
144 5 Markus Döring
Taxa 	Field of expertise	Taxa	Multiple-choice from drop-down list provided by DAISIE (listed in Excel, attached to mail). Also free text writing, with the restriction that the name is on the DAISIE list	Explanatory text under box with drop-down list (is it called a legend?) should be “Select a Taxon (hold down CTRL and click to multi- or deselect)” Is it possible to make a “box” where the selected taxa is “thrown” into (where you can click add or remove) from the drop-down list? Am I talking rubbish, or do you know what I mean? This way the user has an overview of what he/she has selected in stead of scrolling up and down.
145 1 Markus Döring
Geography 	Geographic range of expertise	Geographical range of expertise for ‘name of chosen taxa’	Choose geographic range of expertise for each and every taxon which has been listed as field of expertise. Regarding Marine areas use list from DAISIE	For terrestric areas, Markus suggested list from TDWG. I haven’t been able to find it.  Insert name of taxa automatically to fill out the geographic range of expertise per pre-selected taxa. For marine areas, please use list from classification by BioBEL (check: http://biobel.biodiversity.be/biobel/search/classification) (is it possible to extract the marine areas of the list?)
146 4 Markus Döring
	Environment of taxonomic group	Environment of ‘name of chosen taxa’	Select environment for study for each and every taxon listed as field of expertise	Multiple-choice in a tick box. List from the Excel file “Environment”.  Insert name of taxa automatically to fill out the Environment per pre-selected taxa
147 6 Markus Döring
Activity / Interest	Taxonomic activity	Taxonomic activity 	Select one or several of the 7 kinds of taxonomic activity as outlined by Enghoff & Seberg 2007 - and do this for each and every taxon which has been listed as field of expertise . The 7 kinds are:	Multiple-choice from list from Excel file “Taxonomic activities” Tick box
148 5 Markus Döring
	Methodology / Approach	Methodology / approach of ‘name of chosen taxa’	Select one or several of the approaches listed in the Excel file “M;ethodology Approach” for each and every taxon listed as field of expertise	Multiple-choice. Insert name of taxa automatically to fill out the Methodology / approach per pre-selected taxa
149 4 Markus Döring
	Ongoing / Planned research projects	Title of project	Free text	It should be possible for the user to list as many projects as they wish in separate boxes by pushing a button saying ‘add project’
150 6 Markus Döring
		Ongoing project OR Planned project		Select either ongoing project or planned project – radio button. This should be possible for each project listed.
151 4 Markus Döring
		Keywords	Free text	For each listed project, free text keywords should be possible to write. As explanatory text “E.g. taxa, geographic range, approach etc.”
152
		Partner / Persons / Institutions	Free text	For each listed project, free text should be possible to write.
153
~~~
154
155 7 Andreas Kohlbecker
On base on this tabular model and on base of the GTI Taxonomists Database an UML diagram has been developed:
156
157
158 8 Andreas Kohlbecker
![](ExpertDataModel.gif)
159
160 7 Andreas Kohlbecker
161 1 Markus Döring
162 3 Markus Döring
## Implementation
163 1 Markus Döring
164
The database will be implemented as a module for the content management system Drupal by wp5.