Project

General

Profile

ExpertsDatabase » History » Version 23

Niels Hoffmann, 06/14/2010 01:20 PM

1 1 Markus Döring
2
3
4 23 Niels Hoffmann
_This page is about an taxonomic experts (meta)database_
5 1 Markus Döring
6
7
8 23 Niels Hoffmann
9
10 1 Markus Döring
----
11
12
13
# Experts Database
14 23 Niels Hoffmann
15
16
{{>toc}}
17
18
19 1 Markus Döring
20
21
## Overview
22
23 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: 
24 1 Markus Döring
25
26 2 Markus Döring
* Provision of a better knowledge base for an integrated recruitment strategy in EDIT 
27 1 Markus Döring
28 2 Markus Döring
* Taxonomic information backbone and Pan-European checklist activities of WP3 
29 1 Markus Döring
30 2 Markus Döring
* Coordination of research organised by WP4 (especially regarding methodology) 
31 1 Markus Döring
32 2 Markus Döring
* Formation of networks, committees and task-forces for WP6 and WP7 activities 
33 1 Markus Döring
34 2 Markus Döring
* WP8s assessment of training resources for taxonomy in Europe 
35 1 Markus Döring
36
37 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: 
38 1 Markus Döring
39
40 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 
41 1 Markus Döring
42 2 Markus Döring
* An experts/expertise and project database structure, based on previous similar efforts 
43 1 Markus Döring
44
45 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 
46 1 Markus Döring
47
48 2 Markus Döring
* The form to enter or update data on experts 
49 1 Markus Döring
50 2 Markus Döring
* The actual database structure behind the information service 
51 1 Markus Döring
52 2 Markus Döring
* What the service (the product) should be able to do 
53 1 Markus Döring
54 2 Markus Döring
* How we could achieve designing and implementing the service. 
55 1 Markus Döring
56
57 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: 
58 1 Markus Döring
59
60 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 
61 1 Markus Döring
62 2 Markus Döring
* Geographic area(s) (countries, terrestrial areas, aquatic areas) their expertise relates to 
63 1 Markus Döring
64 2 Markus Döring
* Environment of their taxonomic group (see elaboration below) 
65 1 Markus Döring
66 2 Markus Döring
* Their ongoing taxonomic research 
67 1 Markus Döring
68 2 Markus Döring
* National / International taxonomic research projects they are involved in 
69 1 Markus Döring
70 2 Markus Döring
* Country they reside in 
71 1 Markus Döring
72 2 Markus Döring
* Institution they work in 
73 1 Markus Döring
74
75 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! 
76 1 Markus Döring
77
78 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.). 
79 1 Markus Döring
80
81 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. 
82 1 Markus Döring
83
84 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: 
85 1 Markus Döring
86
87 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. 
88 1 Markus Döring
89 2 Markus Döring
* DAISIE European Alien Species Expertise Registry http://daisie.ckff.si/ 
90 1 Markus Döring
91
92 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. 
93 1 Markus Döring
94
95 2 Markus Döring
* “New Accession States” extension to Fauna Europaea, FaEu?-NAS http://zoology.fns.uniba.sk/faeu/search_service/search_index.htm 
96 1 Markus Döring
97 2 Markus Döring
* Fauna Europaea experts database http://www.faunaeur.org/experts.php 
98 1 Markus Döring
99
100 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: 
101 1 Markus Döring
102
103 2 Markus Döring
* Walther Berendsohn: Recommends integrating with Index Herbariorum, http://sciweb.nybg.org/science2/IndexHerbariorum.asp 
104 1 Markus Döring
105 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 
106 1 Markus Döring
107 2 Markus Döring
* Jackie Van Goethem: The very recently released Belgian information service BioBel? http://biobel.biodiversity.be/ 
108 1 Markus Döring
109
110 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. 
111 1 Markus Döring
112
113
114 2 Markus Döring
### Conclusion
115 1 Markus Döring
116 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. 
117 1 Markus Döring
118
119
120 2 Markus Döring
## Specification
121 1 Markus Döring
122
123 2 Markus Döring
### Data model
124 1 Markus Döring
125 10 Andreas Kohlbecker
126
#### Tabular Model
127
128 2 Markus Döring
For every expert the following metadata should be stored:
129
130 1 Markus Döring
131 4 Markus Döring
~~~
132
#!CSV
133 9 Andreas Kohlbecker
Name of major Tab	Name of category within Tab	Legend for text field to complete by expert	Comment	Optional/mandatory	Level of privacy	Discussion of design/implementation
134
Contact information	Name	First & middle name	Free text	Mandatory	Public	Explanatory text saying - Mandatory
135
		Last Name	Free text	Mandatory	Public	Explanatory text saying - Mandatory
136
		Title	Choose one from drop-down list	Mandatory	Public	Explanatory text saying - Mandatory
137
		Nickname	Free text	Optional	Public	
138
	E-Mail	E-mail	List up to 5 addresses and choose one as Default through radio button.	Mandatory	Public	Explanatory text saying - Mandatory
139
	Institution / Organisation / University	Institution	Free text	Optional	Public	
140
		Division / Department	Free text	Optional	Restricted 1	
141
		Office	Free text	Optional	Restricted 1	
142
		Institutional Acronym	Free text	Optional	Restricted 1	
143
	Mailing Address	Street Address	Free text	Optional	Restricted 1	
144
		Postal or ZIP code	Free text	Optional	Restricted 1	
145
		City	Free text	Optional	Restricted 1	
146
		Country	Choose one from drop-down list	Mandatory	Public	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). Explanatory text saying - Mandatory
147
		State / Province	Choose one from drop-down list created based on country selected	Mandatory	Restricted 1	Explanatory text saying - Mandatory
148
	Phone/Communications (including country code)	Phone		Optional	Restricted 1	
149
		Mobile		Optional	Restricted 1	
150
		Fax		Optional	Restricted 1	
151
		Phone PA		Optional	Restricted 1	
152
	Internet URL	Institutional / Project related www	Allow to list up to three URLs	Optional	Restricted 1	
153
	year of birth			Mandatory	Restricted 2	
154
	foreseen year of retirement from professional service as a taxonomist			Mandatory	Restricted 2	
155
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	Mandatory	Public	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. Explanatory text sayting - Mandatory.
156
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	Mandatory	Public	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?. Explanatory text saying - Mandatory.
157
	Environment of taxonomic group	Environment of ?name of chosen taxa?	Select environment for study for each and every taxon listed as field of expertise	Mandatory	Public	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. Explanatory text saying - Mandatory.
158
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:	Mandatory	Public?????	Multiple-choice from list from Excel file ?Taxonomic activities? Tick box. Explanatory text saying - Mandatory.
159
	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	Mandatory	Public?????	Multiple-choice. Insert name of taxa automatically to fill out the Methodology / approach per pre-selected taxa. Explanatory text saying - Mandatory.
160
	Ongoing / Planned research projects	Title of project	Free text	Optional	Restricted 1	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?
161
		Ongoing project OR Planned project		Optional	Restricted 1	Select either ongoing project or planned project ? radio button. This should be possible for each project listed.
162
		Keywords	Free text	Optional	Restricted 1	For each listed project, free text keywords should be possible to write. As explanatory text ?E.g. taxa, geographic range, approach etc.?
163
		Partner / Persons / Institutions	Free text	Optional	Restricted 1	For each listed project, free text should be possible to write.
164 4 Markus Döring
~~~
165 10 Andreas Kohlbecker
166
#### Privacy Levels
167
168
169 11 Andreas Kohlbecker
4 levels of privacy based on what information (data) each category of user can see: 
170
171
172
* Private: No one can see the data. Useful to register for shibboleth?
173
174
* Restricted 2: Only for members of Board of Directors (BoD). They can see all the entered data 
175
176
* Restricted 1: For EDIT project members (who are themselves registered in the database). They can see all entered data except age and foreseen retirement year.
177
178 20 Andreas Müller
* Public: All users can see only the mandatory entries.
179 11 Andreas Kohlbecker
180
181 10 Andreas Kohlbecker
~~~
182
#!CSV
183
Level of data privacy	User type allowed to see the data			
184
	Everybody	EDIT project members	Board of Directors	(Shibboleth)
185
Private				x
186
Restricted 2			x	
187
Restricted 1		x		
188
Public	x			
189
190
~~~
191
192 19 Andreas Kohlbecker
The following table shows the latest concept for the data structure together with the field based permissions. It is based on the former noted levels of privacy and on the suggested data structure above. The table shown is a html representation of the attached spreadsheet attachment:"Fields, Roles & Permissions.xls".
193 10 Andreas Kohlbecker
194
195 17 Andreas Kohlbecker
~~~
196
<code class="html">
197
<TABLE FRAME=VOID CELLSPACING=0 COLS=10 RULES=NONE BORDER=0>
198
	<COLGROUP><COL WIDTH=151><COL WIDTH=113><COL WIDTH=93><COL WIDTH=94><COL WIDTH=90><COL WIDTH=59><COL WIDTH=57><COL WIDTH=98><COL WIDTH=85><COL WIDTH=78></COLGROUP>
199
	<TBODY>
200
		<TR>
201
			<TD WIDTH=151 HEIGHT=17 ALIGN=LEFT><B>Table</B></TD>
202
203
			<TD WIDTH=113 ALIGN=LEFT><B>Field</B></TD>
204
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" COLSPAN=4 WIDTH=336 ALIGN=CENTER><B>Permissions</B></TD>
205
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" COLSPAN=4 WIDTH=317 ALIGN=CENTER BGCOLOR="#99CCFF"><B>Person.Privacy settings</B></TD>
206
			</TR>
207
		<TR>
208
			<TD HEIGHT=33 ALIGN=LEFT><I><BR></I></TD>
209
			<TD ALIGN=LEFT><I><BR></I></TD>
210
211
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT VALIGN=TOP><I>Public = annonymous</I></TD>
212
			<TD ALIGN=LEFT VALIGN=TOP><I>General Editor</I></TD>
213
			<TD ALIGN=LEFT VALIGN=TOP><I>Institutional Editor</I></TD>
214
			<TD ALIGN=LEFT VALIGN=TOP><I>Owner</I></TD>
215
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><I>Public</I></TD>
216
			<TD ALIGN=LEFT><I>ContactPrivate</I></TD>
217
218
			<TD ALIGN=LEFT><I>Private</I></TD>
219
			<TD STYLE="border-right: 1px solid #000000" ALIGN=LEFT><I>Custom (2)</I></TD>
220
		</TR>
221
		<TR>
222
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" HEIGHT=18 ALIGN=LEFT>user</TD>
223
			<TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT>picture</TD>
224
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
225
226
			<TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
227
			<TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
228
			<TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
229
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
230
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
231
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
232
233
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
234
		</TR>
235
		<TR>
236
			<TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000" HEIGHT=18 ALIGN=LEFT><BR></TD>
237
			<TD STYLE="border-bottom: 1px solid #000000" ALIGN=LEFT>mail</TD>
238
			<TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
239
			<TD STYLE="border-bottom: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
240
241
			<TD STYLE="border-bottom: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
242
			<TD STYLE="border-bottom: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
243
			<TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
244
			<TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
245
			<TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
246
			<TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
247
248
		</TR>
249
		<TR>
250
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" HEIGHT=18 ALIGN=LEFT>Person</TD>
251
			<TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT>Fullname</TD>
252
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
253
			<TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
254
			<TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
255
256
			<TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
257
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
258
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
259
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
260
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
261
		</TR>
262
		<TR>
263
264
			<TD STYLE="border-left: 1px solid #000000" HEIGHT=18 ALIGN=LEFT><BR></TD>
265
			<TD ALIGN=LEFT>Name_aliases</TD>
266
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
267
			<TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
268
			<TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
269
			<TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
270
271
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
272
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
273
			<TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
274
			<TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
275
		</TR>
276
		<TR>
277
			<TD STYLE="border-left: 1px solid #000000" HEIGHT=18 ALIGN=LEFT><BR></TD>
278
279
			<TD ALIGN=LEFT>Lifespan </TD>
280
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
281
			<TD ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
282
			<TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
283
			<TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
284
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
285
286
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
287
			<TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
288
			<TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
289
		</TR>
290
		<TR>
291
			<TD STYLE="border-left: 1px solid #000000" HEIGHT=18 ALIGN=LEFT><BR></TD>
292
			<TD ALIGN=LEFT>Retirement_year </TD>
293
294
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
295
			<TD ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
296
			<TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
297
			<TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
298
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
299
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
300
301
			<TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
302
			<TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
303
		</TR>
304
		<TR>
305
			<TD STYLE="border-left: 1px solid #000000" HEIGHT=18 ALIGN=LEFT><BR></TD>
306
			<TD ALIGN=LEFT>Privacy </TD>
307
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
308
309
			<TD ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
310
			<TD ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
311
			<TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
312
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
313
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
314
			<TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
315
316
			<TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
317
		</TR>
318
		<TR>
319
			<TD STYLE="border-left: 1px solid #000000" HEIGHT=18 ALIGN=LEFT><BR></TD>
320
			<TD ALIGN=LEFT>Url   </TD>
321
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
322
			<TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
323
324
			<TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
325
			<TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
326
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
327
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
328
			<TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
329
			<TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
330
331
		</TR>
332
		<TR>
333
			<TD STYLE="border-left: 1px solid #000000" HEIGHT=18 ALIGN=LEFT><BR></TD>
334
			<TD ALIGN=LEFT>Email </TD>
335
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
336
			<TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
337
			<TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
338
339
			<TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
340
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
341
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
342
			<TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
343
			<TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
344
		</TR>
345
		<TR>
346
347
			<TD STYLE="border-left: 1px solid #000000" HEIGHT=18 ALIGN=LEFT><BR></TD>
348
			<TD ALIGN=LEFT>Phone </TD>
349
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
350
			<TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
351
			<TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
352
			<TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
353
354
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
355
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
356
			<TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
357
			<TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
358
		</TR>
359
		<TR>
360
			<TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000" HEIGHT=18 ALIGN=LEFT><BR></TD>
361
362
			<TD STYLE="border-bottom: 1px solid #000000" ALIGN=LEFT>Address </TD>
363
			<TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
364
			<TD STYLE="border-bottom: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
365
			<TD STYLE="border-bottom: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
366
			<TD STYLE="border-bottom: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
367
			<TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
368
369
			<TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
370
			<TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
371
			<TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
372
		</TR>
373
		<TR>
374
			<TD STYLE="border-top: 1px solid #000000" HEIGHT=18 ALIGN=LEFT>InstitutionalMembership</TD>
375
			<TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT>*</TD>
376
377
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
378
			<TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
379
			<TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
380
			<TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
381
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
382
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
383
384
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
385
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
386
		</TR>
387
		<TR>
388
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" HEIGHT=18 ALIGN=LEFT>Institution </TD>
389
			<TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT>*</TD>
390
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
391
392
			<TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
393
			<TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
394
			<TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
395
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
396
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
397
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
398
399
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
400
		</TR>
401
		<TR>
402
			<TD STYLE="border-top: 1px solid #000000" HEIGHT=18 ALIGN=LEFT>TaxonInterest</TD>
403
			<TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT>Taxon</TD>
404
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
405
			<TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
406
407
			<TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
408
			<TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
409
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
410
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
411
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
412
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
413
414
		</TR>
415
		<TR>
416
			<TD HEIGHT=18 ALIGN=LEFT><BR></TD>
417
			<TD ALIGN=LEFT>Georegion</TD>
418
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
419
			<TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
420
			<TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
421
422
			<TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
423
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
424
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
425
			<TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
426
			<TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
427
		</TR>
428
		<TR>
429
430
			<TD HEIGHT=18 ALIGN=LEFT><BR></TD>
431
			<TD STYLE="border-right: 1px solid #000000" ALIGN=LEFT>Environment</TD>
432
			<TD ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
433
			<TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
434
			<TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
435
			<TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
436
437
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
438
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
439
			<TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
440
			<TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
441
		</TR>
442
		<TR>
443
			<TD HEIGHT=18 ALIGN=LEFT><BR></TD>
444
445
			<TD STYLE="border-right: 1px solid #000000" ALIGN=LEFT>Methodology</TD>
446
			<TD ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
447
			<TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
448
			<TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
449
			<TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
450
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
451
452
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
453
			<TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
454
			<TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
455
		</TR>
456
		<TR>
457
			<TD HEIGHT=18 ALIGN=LEFT><BR></TD>
458
			<TD STYLE="border-right: 1px solid #000000" ALIGN=LEFT>Activity</TD>
459
460
			<TD ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
461
			<TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
462
			<TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
463
			<TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
464
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
465
			<TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
466
467
			<TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
468
			<TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
469
		</TR>
470
		<TR>
471
			<TD STYLE="border-bottom: 1px solid #000000" HEIGHT=18 ALIGN=LEFT><BR></TD>
472
			<TD STYLE="border-bottom: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT>Hidden (1) </TD>
473
			<TD STYLE="border-bottom: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
474
475
			<TD STYLE="border-bottom: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
476
			<TD STYLE="border-bottom: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
477
			<TD STYLE="border-bottom: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
478
			<TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
479
			<TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
480
			<TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
481
482
			<TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
483
		</TR>
484
		<TR>
485
			<TD STYLE="border-top: 1px solid #000000" HEIGHT=18 ALIGN=LEFT>Project</TD>
486
			<TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT>*</TD>
487
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
488
			<TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
489
490
			<TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
491
			<TD STYLE="border-top: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
492
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
493
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
494
			<TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
495
			<TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
496
497
		</TR>
498
		<TR>
499
			<TD STYLE="border-top: 1px solid #000000" COLSPAN=6 HEIGHT=99 ALIGN=LEFT VALIGN=TOP><B><FONT SIZE=1 COLOR="#FF6600">(1)</FONT></b> A user can choose to hide his own taxon Interests from the members of role Public and of role General Editor by selecting one of the default 'Person.Privacy settings' : Public, ContactPrivate, Private. <B><FONT SIZE=1 COLOR="#FF6600">(2)</FONT></b> A implementation should be designed in such way that is is possible to extend the 'Person.Privacy settings' by a per user specific named Custom setting. In Custom mode the user can define individual setting for each of this fields. </B></TD>
500
			<TD STYLE="border-top: 1px solid #000000" COLSPAN=4 ALIGN=LEFT VALIGN=TOP>Setting in the field Person.Privacy override the role based access setting for Public &amp; General Editor   where ever the permission view ist set for the specific role and field.  </TD>
501
			</TR>
502
		<TR>
503
			<TD HEIGHT=17 ALIGN=LEFT><BR></TD>
504
505
			<TD ALIGN=LEFT><BR></TD>
506
			<TD ALIGN=LEFT><BR></TD>
507
			<TD ALIGN=LEFT><BR></TD>
508
			<TD ALIGN=LEFT><BR></TD>
509
			<TD ALIGN=LEFT><BR></TD>
510
			<TD ALIGN=LEFT><BR></TD>
511
			<TD ALIGN=LEFT><BR></TD>
512
			<TD ALIGN=LEFT><BR></TD>
513
			<TD ALIGN=LEFT><BR></TD>
514
515
		</TR>
516
		<TR>
517
			<TD COLSPAN=6 HEIGHT=17 ALIGN=LEFT>The tables Person and TaxonInterest require Fieldbased permissions.</TD>
518
			<TD ALIGN=LEFT><BR></TD>
519
			<TD ALIGN=LEFT><BR></TD>
520
			<TD ALIGN=LEFT><BR></TD>
521
			<TD ALIGN=LEFT><BR></TD>
522
		</TR>
523
524
	</TBODY>
525
</TABLE>
526
~~~
527
528 18 Andreas Kohlbecker
The fields **Address** and **Fullname** actually consist of several subfields:
529 17 Andreas Kohlbecker
530
531 18 Andreas Kohlbecker
 **Address** 
532
533
534
* pobox
535
536
* street
537
538
* postcode
539
540
* locality
541
542
* region
543
544
* country
545
546
547
 **Fullname** 
548
549
550
* prefix       
551
552
* forename    
553
554
* surname      
555
556
* suffix      
557
558
559
560
561
562
563
564
565 7 Andreas Kohlbecker
### UML Model
566 1 Markus Döring
567 17 Andreas Kohlbecker
568 1 Markus Döring
On base on tabular model above and on base of the GTI Taxonomists Database an UML diagram has been developed. This model has been used a base for discussion and as a stating point for initial development and has become obsolete
569 17 Andreas Kohlbecker
570 1 Markus Döring
571 18 Andreas Kohlbecker
[!ExpertDataModelgif|width=200px!]   
572 17 Andreas Kohlbecker
573 8 Andreas Kohlbecker
574 7 Andreas Kohlbecker
575 1 Markus Döring
576 3 Markus Döring
## Implementation
577 1 Markus Döring
578 12 Andreas Kohlbecker
579 1 Markus Döring
The database will be implemented as a module for the content management system Drupal by wp5.
580 12 Andreas Kohlbecker
581
582
Developer notes on the implementation are found at the [[ExpertsDatabaseImplementationNotes]] page.
583 13 Andreas Kohlbecker
584
585 21 Andreas Kohlbecker
A first prototype is running at !http://dev.e-taxonomy.eu/expertsdb/. 
586
587
588
589
## Release
590
591
592 22 Andreas Kohlbecker
The first release of the ExpertsDB is available as an zip archive attachment:"expertsdb release v1.0 2009-01-27.zip". This archive bundles Drupal5 together with the expertsdb module and all other required modules and themes. For instructions on how to install the expertsDB please read EXPERTS_DB-INSTALL.txt which is found in the archive root.