‹ › ×

    FRED
    • Contact
    • GDPR policy
    • Imprint
    • About
    • Sign Up
    • Login
    • SEARCH
    • Search and find
    • Packages
    • Map
    • By Category ...
      • Study sites
      • Sampling sites
      • 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)

    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 freeODC-ByLicence.

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