This page contains templates of file formats that are used to load data into the Particle Size Toolbox using runpst.

There are four different formats available for runpst: DEFAULT, DINO, DINO_QWA and TOP_INTEGRAAL. These last three formats are for users at TNO.
Everyone else should use DEFAULT. To download a Microsoft Excel copy of these templates click here.
    • NB: if data are missing for a particular variable, leave the cell blank, but remember to include blank cells when the file is exported as either '.txt' or '.csv' format.

DEFAULT
The format of a DEFAULT type input file is given in Table 1 > DEFAULT. These data are saved in the widely used comma-separated-value (.csv) format.
CSV files can be exported from commonly used software packages including Microsoft Office, Open Office and Apple Pages. The .csv file should start with a row of column headers followed by a row for each sample record.
The example given here was created using the Create_example_data function. This creates a data-set of semi-randomized particle-size distributions on a 3D voxel grid and extracts twenty-five 'boreholes' from the voxel model using two different types of particle-size 'techniques'. The model has four geology types with distinct particle-size dsitributions and spatial trends.

Explanation of variables: [+/-]
  • SITE_NR : Site or borehole number unique to paired X-Y co-ordinates [alphanumeric/string]
  • UNIQUE_ID : A unique identifier for each record or sample [alphanumeric/string]
  • X : Easting in metres [numeric]
  • Y : Northing in metres [numeric]
  • HEIGHT : Surface elevation of site or borehole
  • SITE_NR in metres above vertical datum [numeric]
  • TOP : Top of sample unit relative to HEIGHT in metres. Negative = below / positive = above. [numeric]
  • BASE : Base of sample unitrelative to HEIGHT in metres. Negative = below / positive = above. [numeric]
  • COLUMNS 9 : END-1 : A 1 by n vector of particle-size frequencies in percent. [positive numeric]
  • NB: The column headers for columns 9:end are given as the largest particle-size in each particle-size category in phi units. Size categories are ordered left to right in descending particle sizes, i.e. lower to higher numbers in phi units. To convert from millimetres or micrometres to phi use mm2phi or microns2phi.


DINO

The format for a DINO type input file is given in Table 1 > DINO. These data are formatted as a tab-delimited text file, which can be created by exporting from Microsoft Access of Excel or by running the Python script DINOExtractie.
For more details on the particle-size classifications used by TNO please refer to these documents:
NEN5104: Particle Size Classification
NEN5104: Gravel Codes
NEN5104: Visual Estimates of Particle-Size
'NEN5104: Borehole Description Methods' (in Dutch: pp 33 -- 44)

Explanation of variables: [+/-]
  • NITG_NR: Borehole identifier [alphanumeric]
  • X_RD_CRD: Latitude of borehole collar on RD grid in metres [numeric]
  • Y_RD_CRD: Longitude of borehole collar in RD grid in metres [numeric]
  • HEIGHT_NAP: Height of the borehole collar relative to Normaal Amsterdams Peil in millimetres [numeric]
  • STR_TOP: Top of stratigraphic unit below HEIGHT_NAP in millimetres [numeric]
  • STR_BASE: Base of stratigraphic unit below HEIGHT_NAP in millimetres [numeric]
  • LITH_TOP: Top of lithological unit below HEIGHT_NAP in millimetres [numeric]
  • LITH_BASE: base of lithological unit below HEIGHT_NAP in millimetres [numeric]
  • PROVINCE_CD: Province code [alphanumeric]
  • UNIT_CD: Unit code [alphanumeric]
  • UNIT_ALT_CD: Alternative unit code [alphanumeric]
  • LITHOFACIES_CD: Lithofacies code [alphanumeric]
  • PUSHED_BY_ICE_CD: Boolean field for glacigenic sediment [J/N]
  • LITHOLOGY_CD: Lithology code [alphanumeric]
  • LP: Visual estimate of clay (lutum) content [percent frequency]
  • SP: Visual estimate of silt content [percent frequency]
  • ZP: Visual estimate of sand content [percent frequency]
  • GP: Visual estimate of gravel content [percent frequency]
  • OP: Visual estimate of organic content [percent frequency]
  • SHP: Visual estimate of shell content [percent frequency]
  • ZM: Visual estimate of the sand median [micrometres]
  • ZMC: Classification code of the sand median [alphanumeric]
  • GMC: Classification code of the gravel median [alphanumeric]
  • GFN: Classification code of the fine grave median [alphanumeric]
  • GMG: Classification code of the medium gravel median [alphanumeric]
  • GZG: Classification code of the coarse gravel median [alphanumeric]
  • SL_BLN: Boolean field for presence of a sublayer [J/N]
  • SL_T: Thickness of the sublayer relative to the layer [percent]
  • SL_T_CD: Thickness of the sublayer given as a code [alphanumeric]
  • SL_LITH_CD: Sublayer lithology code [alpahnumeric]
  • SL_LP: Visual estimate of sublayer clay (lutum) content [percent frequency]
  • SL_SP: Visual estimate of sublayer silt content [percent frequency]
  • SL_ZP: Visual estimate of sublayer sand content [percent frequency]
  • SL_GP: Visual estimate of sublayer gravel content [percent frequency]
  • SL_OP: Visual estimate of sublayer organic content [percent frequency]
  • SL_SHP: Visual estimate of sublayer shell content [percent frequency]
  • SL_ZM: Visual estimate of the sublayer sand median [micrometres]
  • SL_ZMC: Classification code of the sublayer sand median [alphanumeric]
  • SL_GMC: Classification code of the sublayer gravel median [alphanumeric]
  • MODEL_CD: Geological model used for stratigraphic and lithological interpretations [alphanumeric]
  • prefSTRAT: Is stratigraphic model the preferred interpretation? [J/N]
  • prefLTH: Is lithological model the preferred interpretation? [J/N]
  • DESCRIBER_NM: Name of staff member who described the log [alphanumeric]


DINO_QWA

The format for a DINO_QWA type input file is given in Table 1 > DINO_QWA. These data are formatted as comma-separated values in a '.txt' or '.csv' file, which can be created by exporting data from Microsoft Access of Excel. Important to note is that particle-size data are listed in columns rather than rows. The example given in Table 1 > DNO_QWA is only one complete sample. For more details on the different techniques types in the DINO_QWA database go to Technique Codes.

Explanation of variables: [+/-]
  • BOREHOLE_NR: Borehole identifier [alphanumeric]
  • SAMPLE_NR: Sample unique identifier [numeric]
  • SUBSAMPLE_NR: Subsample unique identifier [numeric]
  • X_RD_CRD: Latitude of borehole collar on RD grid in metres [numeric]
  • Y_RD_CRD: Longitude of borehole collar in RD grid in metres [numeric]
  • HEIGHT: Height of the borehole collar relative to Normaal Amsterdams Peil in millimetres [numeric]
  • TOP: Top of lithological unit below HEIGHT in millimetres [numeric]
  • BASE: base of lithological unit below HEIGHT in millimetres [numeric]
  • PROVINCE: Province code [alphanumeric]
  • UPPER_LIMIT: Largest particle-size in category in micrometres [numeric]
  • LOWER_LIMIT: Smallest particle-size in category in micrometres [numeric]
  • VALUE: Particle-size frequency in percent [positive numeric]
  • TECH_CD: Technique code [alphanumeric]


TOP_INTEGRAAL

The format for a TOP_INTEGRAAL type input file is given in Table 1 > TOP_INTEGRAAL. These are comma-separated values saved as '.txt' or '.csv' files, which can be created by exporting data from Microsoft Access of Excel. For more details on the different techniques types in the Top Integraal database go to Technique Codes.

Explanation of variables: [+/-]
  • BOREHOLE_NR: Borehole identifier [alphanumeric]
  • LOC_DEPTH: Unique sample location identifier [alphanumeric]
  • X_RD: Latitude of borehole collar on RD grid in metres [numeric]
  • Y_RD: Longitude of borehole collar in RD grid in metres [numeric]
  • HEIGHT_NAP: Height of the borehole collar relative to Normaal Amsterdams Peil in millimetres [numeric]
  • TOP: Top of lithological unit below HEIGHT_NAP in millimetres [numeric]
  • BASE: Base of lithological unit below HEIGHT_NAP in millimetres [numeric]
  • MID: Sample depth below HEIGHT_NAP in millimetres [numeric]
  • UNIT Unit code [alphanumeric]
  • LITHOFACIES: Lithofacies code [alphanumeric]
  • LITH: Lithology code [alphanumeric]
  • PROVINCE: Province code [alphanumeric]
  • F0.1 : F2000: Percentage-frequency distribution for partciles-sise categores given in micrometres [numeric positive]
  • DW: Dry weight of sample in grams [numeric]
  • DWGT2MM: Dry weight of sample larger than 2 mm in grams [numeric]
  • TYPEGT2MM: Type of sample larger than 2 mm (schelp/grind) [string]
  • RESIDUAL_W: Residual sample weight in grams [numeric]
  • LP: Visual estimate of clay (lutum) content [percent frequency]
  • SP: Visual estimate of silt content [percent frequency]
  • ZP: Visual estimate of sand content [percent frequency]
  • GP: Visual estimate of gravel content [percent frequency]
  • OP: Visual estimate of organic content [percent frequency]
  • SHP: Visual estimate of shell content [percent frequency]
  • ZM: Visual estimate of the sand median [micrometres]
  • ZMC: Classification code of the sand median [alphanumeric]
  • GMC: Classification code of the gravel median [alphanumeric]
  • GFN: Classification code of the fine grave median [alphanumeric]
  • GMG: Classification code of the medium gravel median [alphanumeric]
  • GZG: Classification code of the coarse gravel median [alphanumeric]
  • SL_P: Thickness of the sublayer relative to the layer in percent [numeric]
  • SL_CD: Thickness of the sublayer given as a code [alphanumeric]
  • SL_LITH: Sublayer lithology code [alpahnumeric]
  • SL_LP: Visual estimate of sublayer clay (lutum) content [percent frequency]
  • SL_SP: Visual estimate of sublayer silt content [percent frequency]
  • SL_ZP: Visual estimate of sublayer sand content [percent frequency]
  • SL_GP: Visual estimate of sublayer gravel content [percent frequency]
  • SL_OP: Visual estimate of sublayer organic content [percent frequency]
  • SL_SHP: Visual estimate of sublayer shell content [percent frequency]
  • SL_ZM: Visual estimate of the sublayer sand median [micrometres]
  • SL_ZMC: Classification code of the sublayer sand median [alphanumeric]
  • SL_GMC: Classification code of the sublayer gravel median [alphanumeric]
  • TECH_CD: Measurement and preparation technique used in particle-size analysis [alphanumeric]