document - Deltares

seasoningalluringΔιαχείριση Δεδομένων

29 Νοε 2012 (πριν από 4 χρόνια και 10 μήνες)

232 εμφανίσεις


Memo





Aan

Data distributors to BwN


Datum

12 juli 2012

Aantal pagina's

3



Van

Gerrit Hendriksen

Doorkiesnummer

+31 (0)88 33 58 094

E
-
mail

gerrit.hendriksen

@deltares.nl


Onderwerp

Data delivery to PostgreSQL/PostGIS database





1

Introduction

Building With Nature supports from juli 2012 not only rasterbased, jarkus and vakloadingen
data but also observations of biotic nature. Because of the nature of the data there was not yet
a method to disseminate the data through OpenEarth. How
ever within the PMR
-
NCV (nature
conservation Voordelta, for more information, check http://openearth.eu/products) project much
experience is gained in processing, storing and disseminate data of biotic observations.

This document describes, based on the da
ta model of PMR
-
NCV, how data can be provide so
it can be stored in the PostgreSQL database.

2

Data model

The figure below is a schematic presentation of the data model set up for the PMR
-
NCV
project.






Datum

12 juli 2012

Pagina

2
/
3







The main tables are represented by the observation and

the location table. In order to fill these
tables a csv with the following items is sufficient.

fieldname

Description

X

X Coordinate

Y

Y coordinate

EPSG code

Check
http://spatialreference.org

for the correct

codes

Parameter

species name, physical parameter, etc.

Date

YYYY
-
MM
-
DD

hh:
mm
:
ss

(example: 2009
-
01
-
08 04:05:06
)

Method

Method used to determine value (analysis method)

Observationtype

Type of observation (modeloutput, airborne observation, boxcore sam
ple,
stomach contents)

Value

Floating point value

Unit

Unit of measurement

sampleid

Unique identifier to link data to other observations in the list of observations
provided

R
efid

Unique identifier from provider of the data

Remark

If necessary remark
from provider


The fieldname sampleid needs some explanation. Some type of observations, for instance of
the number of shells in a boxcore sample (sampleid) can be split into species and their weigth.
The sampleid ensures that SQL requests can be made ent
ire boxcore samples.






Datum

12 juli 2012

Pagina

3
/
3







The field value can also be filled up with ordinal classes. For instance length class. In that case
a full list of length classes has to be submitted to the BwN repository.

3

Standards

The parameter table contains of several parameter t
ables such as parameter_worms,
parameter_hilucs and parameter_physical. There are numerous standards that can be used for
numerous types of data. In case biotic data is submitted to the repository please confirm to the
standard WoRMS (
http://www.marinespecies.org
). In case observations of physical parameter
are used please confirm to the CF standard, just like the process of creation of netCDF’s,
which is fully described on page
http://publicwiki.deltares.nl/display/OE/Protocol+data+uploading
.

Any kind of use of the environment (such as shipping, recreation) is kept up in the Hierarchic
Land Use Classification System (HILUCS).

Any
other standards used should be submitted to the repository with as much information as
possible.

It is important for the description of the final dataset to know exactly what is in the database.

4

Final procedure

If all datasets are delivered in csv format a
ccording to the table described in chapter 2 then a
procedure will be created to upload all the data into the database.

The procedure will first check all the values of the parameter tables, method descriptions etc.
Then a unique list of locations will be

uploaded before the actual upload of the data into the
observation table.

5

Dissemination

Dissemination of the data can be done by creating a direct link to the database using
geoserver. This enables exports to various formats according to OCG standards
, s
uch as KML.

The shape in which the data is disseminated is not yet known. The nature of the data together
with the features of the PostgreSQL/PostGIS combination ensures creation of various
aggregated dataformats (for instance density per predefined raster
ised shape).