|
|
To participate > Study cases
In order to demonstrate the interest of graph construction in the fields of ecology and environment, the consortium organized two workshops simultaneously in Aix-en-Provence at CESAB and Paris at the ISCC. They brought together a small group of data specialists and a small group of environmental data producers. The aim is to reorganize a part of the datasets by the participants via the appropriate descriptors and to prepare the manipulations in the form of a graph.
The ECOSCOPE Portal Metadata Catalog
Description of the database:
• Metadata of biodiversity observation datasets at different levels of life organization
• Data type: descriptive data of dispositives and their data sets
• Date of creation: 2015
• Type of software: PostGre for storing metadata; Input and export application in XML format; PostGIS for storage of georeferenced information
• Number of users: 50 to 100 for metadata providers with access codes, much more for potential users (researchers, associations, managers, institutional ...)
• Size (Byte) and spatio-temporal span - N / A
• Data accessible online: Yes on the site ecoscope.fondationbiodiversite.fr/ecoscope-portal/
Content of the database:
• Main information fields: Title, abstract, variables, temporal and spatial coverage, taxa, material and methods, contacts, conditions for accessing and using data, collection, URL to database ...
• Number of records in the main tables: 50 rows for the dispositive, 150 rows for the dataset table
• How many / which% of fields / descriptors must have a value: title and starting date are compulsory to complete in the application
Data from the SAGIR network
Description of the database:
• Terrestrial wildlife autopsy data: lesions, results of complementary examinations
• Date of creation: BDD since the 90s, data collected since the fifties
• Software type: Input application, export to excel format
• Number of users: approximately 200 with access codes
• Size (Byte) and spatio-temporal span - N / A
• Data available online? Access reserved for observers with login / password
Content of the database:
• Main information fields: Species, date, place, lesions, isolated pathogens, main and secondary pathological processes, definitive cause of death ...
• Number of records in tables: tens of thousands of entries
• How many / which% of fields / descriptors must have a value: ~ 50% of fields / descriptors must have a value
The ArkeoGIS database
Description of the database:
• More than 50 extracts from databases related to the past (archeology, environment)
• Data type: Spatial data, united by an ontology. Stacked bases (have duplicates)
• Software Type: Database Management via PostgresSQL
• Number of users: approximately 200 with access codes
• Size (byte) and spatio-temporal span - from a few kilos to several mega, via the csv exchange format
• Data accessible online? Since 2012
Content of the database:
• Main information fields: spatial information, time limits, 4 levels of characterization ...
• Number of records in tables: from ten to thousands of entries
The Vigie-Nature database
Description of the database:
• Biodiversity data from participatory science
• Data Type: Logged pbservations
• Date of creation: 1989 (for the oldest)
• Software Type: Access, MySQL, PostGres, Oracle, MongoDb ...
• Number of users: more than 10,000 data providers, a few tens to exploit the data
• Size (byte) and spatio-temporal span - Tanz of Tera over the past 25 years
• Data available online: under development
Content of the database:
• Main information fields: Observation of taxa and interactions between taxa / individuals (presence, size, class, context variables, etc.)
• Number of records in tables: from 103 to 106 entries
The APECS database
Description of the database:
• Observation data for basking sharks in the North-East Atlantic and Brittany
• Data type: from participatory and opportunistic sciences
• Date of creation: 1997
• Software type: MS Access organized in three tables
• Number of users: approximately 1400
• Size (Octet) and spatio-temporal span - 5 MegaOctects
• Data available online: no
Content of the database:
• Main information fields: Geographical area, year, commune, type of observation, size class
• Number of records in tables: 1402
| Online user: 1 |
|
