Project

General

Profile

This page is about an taxonomic experts (meta)database


Experts Database

Overview

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:

  • Provision of a better knowledge base for an integrated recruitment strategy in EDIT

  • Taxonomic information backbone and Pan-European checklist activities of WP3

  • Coordination of research organised by WP4 (especially regarding methodology)

  • Formation of networks, committees and task-forces for WP6 and WP7 activities

  • WP8s assessment of training resources for taxonomy in Europe

As agreed at the EDIT WP2 kick-off meeting in Paris, June 29 2006, the secretariat of the EDIT WP2 drafted an outline of:

  • How to collect contents for the WP2 online information service on taxonomic experts, their expertise, and their ongoing and planned research

  • An experts/expertise and project database structure, based on previous similar efforts

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

  • The form to enter or update data on experts

  • The actual database structure behind the information service

  • What the service (the product) should be able to do

  • How we could achieve designing and implementing the service.

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:

  • Their taxonomic expertise in 7 kinds of taxonomic activities (Enghoff &Seberg, 2006 and see below), within taxa - searchable by all levels down to family

  • Geographic area(s) (countries, terrestrial areas, aquatic areas) their expertise relates to

  • Environment of their taxonomic group (see elaboration below)

  • Their ongoing taxonomic research

  • National / International taxonomic research projects they are involved in

  • Country they reside in

  • Institution they work in

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!

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.).

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.

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:

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.

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:

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.

Conclusion

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.

Specification

Data model

Tabular Model

For every expert the following metadata should be stored:

#!CSV
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
Contact information Name    First & middle name Free text   Mandatory   Public  Explanatory text saying - Mandatory
        Last Name   Free text   Mandatory   Public  Explanatory text saying - Mandatory
        Title   Choose one from drop-down list  Mandatory   Public  Explanatory text saying - Mandatory
        Nickname    Free text   Optional    Public  
    E-Mail  E-mail  List up to 5 addresses and choose one as Default through radio button.  Mandatory   Public  Explanatory text saying - Mandatory
    Institution / Organisation / University Institution Free text   Optional    Public  
        Division / Department   Free text   Optional    Restricted 1    
        Office  Free text   Optional    Restricted 1    
        Institutional Acronym   Free text   Optional    Restricted 1    
    Mailing Address Street Address  Free text   Optional    Restricted 1    
        Postal or ZIP code  Free text   Optional    Restricted 1    
        City    Free text   Optional    Restricted 1    
        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
        State / Province    Choose one from drop-down list created based on country selected    Mandatory   Restricted 1    Explanatory text saying - Mandatory
    Phone/Communications (including country code)   Phone       Optional    Restricted 1    
        Mobile      Optional    Restricted 1    
        Fax     Optional    Restricted 1    
        Phone PA        Optional    Restricted 1    
    Internet URL    Institutional / Project related www Allow to list up to three URLs  Optional    Restricted 1    
    year of birth           Mandatory   Restricted 2    
    foreseen year of retirement from professional service as a taxonomist           Mandatory   Restricted 2    
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.
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.
    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.
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.
    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.
    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?
        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.
        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.?
        Partner / Persons / Institutions    Free text   Optional    Restricted 1    For each listed project, free text should be possible to write.

Privacy Levels

4 levels of privacy based on what information (data) each category of user can see:

  • Private: No one can see the data. Useful to register for shibboleth?

  • Restricted 2: Only for members of Board of Directors (BoD). They can see all the entered data

  • 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.

  • Public: All users can see only the mandatory entries.

#!CSV
Level of data privacy   User type allowed to see the data           
    Everybody   EDIT project members    Board of Directors  (Shibboleth)
Private             x
Restricted 2            x   
Restricted 1        x       
Public  x           

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 Fields, Roles & Permissions.xls.

<code class="html">
<TABLE FRAME=VOID CELLSPACING=0 COLS=10 RULES=NONE BORDER=0>
    <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>
    <TBODY>
        <TR>
            <TD WIDTH=151 HEIGHT=17 ALIGN=LEFT><B>Table</B></TD>

            <TD WIDTH=113 ALIGN=LEFT><B>Field</B></TD>
            <TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" COLSPAN=4 WIDTH=336 ALIGN=CENTER><B>Permissions</B></TD>
            <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>
            </TR>
        <TR>
            <TD HEIGHT=33 ALIGN=LEFT><I><BR></I></TD>
            <TD ALIGN=LEFT><I><BR></I></TD>

            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT VALIGN=TOP><I>Public = annonymous</I></TD>
            <TD ALIGN=LEFT VALIGN=TOP><I>General Editor</I></TD>
            <TD ALIGN=LEFT VALIGN=TOP><I>Institutional Editor</I></TD>
            <TD ALIGN=LEFT VALIGN=TOP><I>Owner</I></TD>
            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><I>Public</I></TD>
            <TD ALIGN=LEFT><I>ContactPrivate</I></TD>

            <TD ALIGN=LEFT><I>Private</I></TD>
            <TD STYLE="border-right: 1px solid #000000" ALIGN=LEFT><I>Custom (2)</I></TD>
        </TR>
        <TR>
            <TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" HEIGHT=18 ALIGN=LEFT>user</TD>
            <TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT>picture</TD>
            <TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>

            <TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
            <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>

            <TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
        </TR>
        <TR>
            <TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000" HEIGHT=18 ALIGN=LEFT><BR></TD>
            <TD STYLE="border-bottom: 1px solid #000000" ALIGN=LEFT>mail</TD>
            <TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-bottom: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>

            <TD STYLE="border-bottom: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD STYLE="border-bottom: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
            <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>
            <TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>

        </TR>
        <TR>
            <TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" HEIGHT=18 ALIGN=LEFT>Person</TD>
            <TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT>Fullname</TD>
            <TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>

            <TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <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>
            <TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
        </TR>
        <TR>

            <TD STYLE="border-left: 1px solid #000000" HEIGHT=18 ALIGN=LEFT><BR></TD>
            <TD ALIGN=LEFT>Name_aliases</TD>
            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>

            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
            <TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
        </TR>
        <TR>
            <TD STYLE="border-left: 1px solid #000000" HEIGHT=18 ALIGN=LEFT><BR></TD>

            <TD ALIGN=LEFT>Lifespan </TD>
            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
            <TD ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
            <TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>

            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
            <TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
            <TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
        </TR>
        <TR>
            <TD STYLE="border-left: 1px solid #000000" HEIGHT=18 ALIGN=LEFT><BR></TD>
            <TD ALIGN=LEFT>Retirement_year </TD>

            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
            <TD ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
            <TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>

            <TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
            <TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
        </TR>
        <TR>
            <TD STYLE="border-left: 1px solid #000000" HEIGHT=18 ALIGN=LEFT><BR></TD>
            <TD ALIGN=LEFT>Privacy </TD>
            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>

            <TD ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
            <TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>

            <TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
        </TR>
        <TR>
            <TD STYLE="border-left: 1px solid #000000" HEIGHT=18 ALIGN=LEFT><BR></TD>
            <TD ALIGN=LEFT>Url   </TD>
            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>

            <TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
            <TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
            <TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>

        </TR>
        <TR>
            <TD STYLE="border-left: 1px solid #000000" HEIGHT=18 ALIGN=LEFT><BR></TD>
            <TD ALIGN=LEFT>Email </TD>
            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>

            <TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
            <TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
            <TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
        </TR>
        <TR>

            <TD STYLE="border-left: 1px solid #000000" HEIGHT=18 ALIGN=LEFT><BR></TD>
            <TD ALIGN=LEFT>Phone </TD>
            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>

            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
            <TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
            <TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
        </TR>
        <TR>
            <TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000" HEIGHT=18 ALIGN=LEFT><BR></TD>

            <TD STYLE="border-bottom: 1px solid #000000" ALIGN=LEFT>Address </TD>
            <TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-bottom: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD STYLE="border-bottom: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD STYLE="border-bottom: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>

            <TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
            <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>
            <TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
        </TR>
        <TR>
            <TD STYLE="border-top: 1px solid #000000" HEIGHT=18 ALIGN=LEFT>InstitutionalMembership</TD>
            <TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT>*</TD>

            <TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <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>

            <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>
            <TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
        </TR>
        <TR>
            <TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" HEIGHT=18 ALIGN=LEFT>Institution </TD>
            <TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT>*</TD>
            <TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>

            <TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>

            <TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
        </TR>
        <TR>
            <TD STYLE="border-top: 1px solid #000000" HEIGHT=18 ALIGN=LEFT>TaxonInterest</TD>
            <TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT>Taxon</TD>
            <TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>

            <TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <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>
            <TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>

        </TR>
        <TR>
            <TD HEIGHT=18 ALIGN=LEFT><BR></TD>
            <TD ALIGN=LEFT>Georegion</TD>
            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>

            <TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
            <TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
        </TR>
        <TR>

            <TD HEIGHT=18 ALIGN=LEFT><BR></TD>
            <TD STYLE="border-right: 1px solid #000000" ALIGN=LEFT>Environment</TD>
            <TD ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>

            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
            <TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
        </TR>
        <TR>
            <TD HEIGHT=18 ALIGN=LEFT><BR></TD>

            <TD STYLE="border-right: 1px solid #000000" ALIGN=LEFT>Methodology</TD>
            <TD ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>

            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
            <TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
        </TR>
        <TR>
            <TD HEIGHT=18 ALIGN=LEFT><BR></TD>
            <TD STYLE="border-right: 1px solid #000000" ALIGN=LEFT>Activity</TD>

            <TD ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>

            <TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
            <TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
        </TR>
        <TR>
            <TD STYLE="border-bottom: 1px solid #000000" HEIGHT=18 ALIGN=LEFT><BR></TD>
            <TD STYLE="border-bottom: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT>Hidden (1) </TD>
            <TD STYLE="border-bottom: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>

            <TD STYLE="border-bottom: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
            <TD STYLE="border-bottom: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-bottom: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
            <TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
            <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>

            <TD STYLE="border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>
        </TR>
        <TR>
            <TD STYLE="border-top: 1px solid #000000" HEIGHT=18 ALIGN=LEFT>Project</TD>
            <TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT>*</TD>
            <TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>

            <TD STYLE="border-top: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD STYLE="border-top: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#339966">edit</FONT></TD>
            <TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000" ALIGN=LEFT><FONT COLOR="#3366FF">view</FONT></TD>
            <TD STYLE="border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><B><FONT COLOR="#FF0000">-</FONT></B></TD>
            <TD STYLE="border-top: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT><BR></TD>

        </TR>
        <TR>
            <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>
            <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>
            </TR>
        <TR>
            <TD HEIGHT=17 ALIGN=LEFT><BR></TD>

            <TD ALIGN=LEFT><BR></TD>
            <TD ALIGN=LEFT><BR></TD>
            <TD ALIGN=LEFT><BR></TD>
            <TD ALIGN=LEFT><BR></TD>
            <TD ALIGN=LEFT><BR></TD>
            <TD ALIGN=LEFT><BR></TD>
            <TD ALIGN=LEFT><BR></TD>
            <TD ALIGN=LEFT><BR></TD>
            <TD ALIGN=LEFT><BR></TD>

        </TR>
        <TR>
            <TD COLSPAN=6 HEIGHT=17 ALIGN=LEFT>The tables Person and TaxonInterest require Fieldbased permissions.</TD>
            <TD ALIGN=LEFT><BR></TD>
            <TD ALIGN=LEFT><BR></TD>
            <TD ALIGN=LEFT><BR></TD>
            <TD ALIGN=LEFT><BR></TD>
        </TR>

    </TBODY>
</TABLE>

The fields Address and Fullname actually consist of several subfields:

Address

  • pobox

  • street

  • postcode

  • locality

  • region

  • country

Fullname

  • prefix

  • forename

  • surname

  • suffix

UML Model

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

[!ExpertDataModelgif|width=200px!]

Implementation

The database will be implemented as a module for the content management system Drupal by wp5.

Developer notes on the implementation are found at the ExpertsDatabaseImplementationNotes page.

A first prototype is running at !http://dev.e-taxonomy.eu/expertsdb/.

Release

The first release of the ExpertsDB is available as an zip archive 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.

ExpertDataModel.gif View (39.6 KB) Andreas Kohlbecker, 09/25/2007 06:43 PM

Fields, Roles & Permissions.xls (22.5 KB) Andreas Kohlbecker, 07/09/2008 10:09 AM

expertsdb release v1.0 2009-01-27.zip (10.2 MB) Andreas Kohlbecker, 01/29/2009 01:21 PM