516 Database of boreholes, soil samples, and water samples

Title

Database of boreholes, soil samples, and water samples

Period

2016-01-02 till 2017-10-10

Period length

1 year 9 months 8 days

Sampling interval

21 days Irregular Interval

Description

Database including following tables:

BOREHOLE
-BOREHOLENO (Borehole number/ID in the format AA-BB, AA = Area/transect number, and BB = Location/nest number)
-ELEVATION (Terrain elevation in m at borehole, DVR90)
-XUTM (X coordinate, UTM zone 32N, Euref89)
-YUTM (Y coordinate, UTM zone 32N, Euref89)

DRAINS
-DRAIN (Drain number/ID)
-XUTM (X coordinate, UTM zone 32N, Euref89)
-YUTM (Y coordinate, UTM zone 32N, Euref89)
-Notes (Drain type/diameter)

LITHSAMP (following the structure and field codes of the Danish National Borehole Database, Jupiter)
-BOREHOLENO (Borehole number/ID corresponding to ID in the BOREHOLE table)
-SAMPLENO (Sample number/ID)
-TOP (Top of sample in m below terrain)
-BOTTOM (Bottom of sample in m below terrain)
-ROCKSYMBOL (Lithology code, l=clay, s=sand, ft=peat, fp=gyttja, ml=clay till, fv=interchanging lithologies, g=gravel, x=unknown)
-COLOR
-TEXTURE
-NOTES

SCREEN
-BOREHOLENO (Borehole number/ID corresponding to ID in the BOREHOLE table)
-SCREENNO (Screen number starting from the deepest screen in each nest)
-TOP (Elevation in m of top of screen)
-BOTTOM (Elevation in m of bottom of screen)
-PIPELENGTH (Total piezometer length in m)
-HABOVETERRAIN (Piezometer pipe length above terrain in m)
-TERRAIN (Terrain elevation in m, DVR90)
-XUTM (X coordinate, UTM zone 32N, Euref89)
-YUTM (Y coordinate, UTM zone 32N, Euref89)
-K (Hydraulic conductivity measured in screen in m/s)
-Note

REDOX
-BOREHOLENO (Borehole number/ID corresponding to BOREHOLENO in the BOREHOLE table)
-INTAKENO (Intake number corresponding to SCREENNO in the SCREEN table)
-DATEOFMEAS (Measurement date)
-REDOX (Redox potential in mV relative to a standard hydrogen electrode)

SOILCHEM
-LABID (Laboratory ID)
-BOREHOLE (Borehole number/ID corresponding to BOREHOLENO in the BOREHOLE table)
-SAMPLE (Sample ID, A is the uppermost sample in a borehole)
-SAMPLEDATE (Date of sampling)
-TOP (Elevation in m of top of soil sample)
-BOTTOM (Elevation in m of bottom of soil sample)
-Volume (Sample volume in cm³)
-Weight (Sample weight in g)
-DryBD (Dry bulk density [105°C, 24h] in g/cm³)
-LOI (Loss On Ignition [550°C, 4h] in weight%)
-FeCBD (Citrate-bicarbonate-dithionite-extractable iron in mg/kg air dry soil)
-Feox (Oxalate-extractable iron in mg/kg air dry soil)
-TOC (Total Organic Carbon in weight%)
-TN (Total Nitrogen in weight%)
-CaCO3 (Calcium carbonate in weight%)
-pH
-Porosity (volume%)

WATLEVEL
-BOREHOLENO (Borehole number/ID corresponding to ID in the BOREHOLE table)
-INTAKENO (Intake number corresponding to SCREENNO in the SCREEN table)
-DATEOFMEAS (Date of water level mesurement)
-TIMEOFMEAS (Time of water level measurement)
-WATLEVMSL (Water level elevation in m, DVR90)

WATSAMP
-LABID (Laboratory ID)
-BOREHOLENO (Borehole number/ID corresponding to BOREHOLENO in the BOREHOLE table)
-SCREENNO (Intake number corresponding to SCREENNO in the SCREEN table)
-SAMPLEDATE (Date of sample collection)
-pH
-O2 (Oxygen, O₂ in mg/L)
-NOTES
-NH4N (Ammmonium, NH_4⁺-N in mg N/L)
-NO3N (Nitrate, NO_3^--N in mg N/L)
-Ntotal (Total nitrogen in mg N/L)
-SO4 (Sulplate, SO₄^2- in mg SO₄^2-/L)
-Temp (Temperature in °C)
-Ctotal (Total organic carbon in mg/L)
-d2H (δ²H in ‰)
-d18O (δ¹⁸H in ‰)
-Br (Br^- in ppm)

Species Groups

Study site

Fensholt

Sampling types

surface water, groundwater

Parameters

physics:

water level

water level

name

water level

synonyms

level, Pegel

wt

water temperature

name

water temperature

description

determination by temperature-probe

synonyms

water temp, Wassertemperatur

chemistry:

Br

Br, bromide

name

Br, bromide

CaCO³

calcium carbonate

name

calcium carbonate

C

carbon (solid)

name

carbon (solid)

synonyms

Kohlenstoff

TFe

Fe, total iron

name

Fe, total iron

description

0,45µm filtrated, inductively coupled plasma optical emission spectrometry (ICP-OES)

synonyms

Gesamteisen

NH₄⁺-N

N, ammonia-nitrogen

name

N, ammonia-nitrogen

description

0,45µm filtrated, photometric determination

synonyms

NH4+-N, Ammonium, ammonia, NH4-N, NH4

NO₃^--N

N, nitrate-nitrogen

name

N, nitrate-nitrogen

description

0,45µm filtrated, photometric determination

synonyms

NO3-N, NO3--N, nitrate, Nitrat

TN

N, total nitrogen

name

N, total nitrogen

description

nondispersive infrared sensor  (NDIR) after combustion

synonyms

Gesamtstickstoff

O₂

O, oxygen concentration

name

O, oxygen concentration

description

determination by oxygen-probe

synonyms

Sauerstoffkonzentration

pH

pH

name

pH

description

pH-probe determination

temporal:

day of year

day of year

name

day of year

synonyms

doy

geodesy:

elevation

elevation

name

elevation

latitude

latitude

name

latitude

longitude

longitude

name

longitude

Contact

Rasmus Jes Petersen

Licence for data

All rights reserved. Please send a request to Rasmus Jes Petersen if you like to use this data. Mind our data policy: IGB Data Policy

Project

TReNDS - Fensholt Project Website

Data files (e.g. excel)

Machine Readable Metadata Files

FRED provides all metadata of this package in a maschine readable format. There is a pure XML file and one EML file in Ecological Metadata Language. Both files are published under the freeODC-ByLicence.

• Database_of_boreholes,_soil_samples,_and_water_samples.xml
• Database_of_boreholes,_soil_samples,_and_water_samples.eml