Tags


Click a tag to remove it from package

Edit Species Groups of Package

Edit Parameter of Package

Edit DOI Package

Choose a project for this package

FRED
  • Contact
  • GDPR policy
  • Imprint
  • About
  • Sign Up
  • Login
  • SEARCH
  • Search and find
  • Packages
  • Map
  • By Category ...
    • Study sites
    • Sampling locations
    • Parameters
    • Sampling types
    • Species groups
    • Current DOIs

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, O2 in mg/L)
-NOTES
-NH4N (Ammmonium, NH4+-N in mg N/L)
-NO3N (Nitrate, NO3--N in mg N/L)
-Ntotal (Total nitrogen in mg N/L)
-SO4 (Sulplate, SO42- in mg SO42-/L)
-Temp (Temperature in °C)
-Ctotal (Total organic carbon in mg/L)
-d2H (δ2H in ‰)
-d18O (δ18H in ‰)
-Br (Br- in ppm)

Species Groups
Study site
Fensholt
Sampling types
surface water, groundwater
Parameters

physics:

water level
name
water level
synonyms
level, Pegel
water temperature
name
water temperature
description

determination by temperature-probe

synonyms
water temp, Wassertemperatur

chemistry:

Br, bromide
name
Br, bromide
calcium carbonate
name
calcium carbonate
carbon (solid)
name
carbon (solid)
synonyms
Kohlenstoff
Fe, total iron
name
Fe, total iron
description

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

synonyms
Gesamteisen
N, ammonia-nitrogen
name
N, ammonia-nitrogen
description

0,45µm filtrated, photometric determination

synonyms
NH4+-N, Ammonium, ammonia, NH4-N, NH4
N, nitrate-nitrogen
name
N, nitrate-nitrogen
description

0,45µm filtrated, photometric determination

synonyms
NO3-N, NO3--N, nitrate, Nitrat
N, total nitrogen
name
N, total nitrogen
description

nondispersive infrared sensor  (NDIR) after combustion

synonyms
Gesamtstickstoff
O, oxygen concentration
name
O, oxygen concentration
description

determination by oxygen-probe

synonyms
Sauerstoffkonzentration
pH
name
pH
description

pH-probe determination

temporal:

day of year
name
day of year
synonyms
doy

geodesy:

elevation
name
elevation
latitude
name
latitude
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)

TitlecreatedFiletypeActions
Fensholt.xlsx 06. Dec. 2019 10:33 datatable: .xlsx
Error: To access file, please get in touch with the contact person.

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 free CC BY 4.0 Licence.

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

You are about to leaving FRED and visting a third party website. We are not responsible for the content or availability of linked sites.

To remain on our site, click Cancel.

Parsing data File

Estimated Time:

Why does it take so much time?

While parsing a file, the database has to perform various tasks, some of them needs a lot of CPU and memory for larger files.

  • preprocessing: means automatic detection of headlines, table body, format values or csv-separators
  • copying: means read the file cell by cell and copy all elements to the database. During this format settings can be calculated (for example iso-time)
  • analyzing: check out for different data types (can be time, numeric or text)