The Bor Format consists of two parts:
-
the specification of the storage format
-
the specification of the field type
Introduction
First, it is assumed that a file matches a recording as an independant logical unit. The file is named with a .bor extension.
File name example
50001180101060101P.bor
5 | 0001 | 180101060101 | D | .bor |
---|---|---|---|---|
Generation |
Serial |
Date |
Domain |
Format |
ID | Domain |
---|---|
|
Drilling parameters |
|
Grouting parameters |
|
JetGrouting parameters |
|
Ménard Pressuremeter Test |
|
Continuous Flight Auger Pile (CFA) |
|
Lugeon Test |
|
Vibroflotation |
|
Dynamic probing and SPT |
Abilities
The file has the following abilities:
-
recording description
-
data logs
-
non-modification source-file guarantee
Format specification
The bor file is a zip format archive containing the files below:
-
A file description that contains technical informations non-specific to the recording type and field properties, references to data file: description.xml
-
Data file, example: data.nc
Data file
Data file use the netCDF (3.6+) format. It contain data logs and each variable.
Description file
The description file contains 2 different types of information:
-
non-specific technical information
-
field-specific properties
Example of Description file
<?xml version="1.0" encoding="UTF-8"?>
<description xmlns="http://www.lim.eu/description" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.lim.eu/description description.xsd">
<filename>50001180101070101D</filename>
<creation>2018-01-01T07:01:01+01:00</creation>
<modification>2018-01-01T07:31:01+01:00</modification>
<project_ref>Bor-Format</project_ref>
<borehole_ref>SP1</borehole_ref>
<cell>
<mcc>208</mcc>
<mnc>01</mnc>
<cellid>31605177</cellid>
<lac>21301</lac>
</cell>
<operator>ROBERT</operator>
<device>
<serial>50001</serial>
<version>1.4</version>
<build>20180101</build>
</device>
<drilling>
<machine_ref>DRIL</machine_ref>
<method>DRLMTD_RTR</method>
<tool>DRLBIT_CNTCI</tool>
<tool_diameter unit="mm">66</tool_diameter>
<rod_length unit="m">2</rod_length>
</drilling>
<convention version="1.1">
<parameters phase="DRILL">
<inclination>
<X unit="degree">91.9</X>
<Y unit="degree">88.6</Y>
</inclination>
<effective_duration unit="s">1800.00</effective_duration>
<logfile>data.nc</logfile>
</parameters>
</convention>
</description>
Non-specific technical information
Property | Description | Type | Required | Example |
---|---|---|---|---|
|
Borehole reference |
text |
required [1] |
SP1 |
|
Borehole information |
structure (see below) |
optional |
|
|
Cell position |
structure (see below) |
optional |
|
|
Creation date |
iso8601 |
required |
2018-01-01T07:01:01+01:00 |
|
Device information |
structure (see below) |
required |
|
|
Drilling information |
structure (see below) |
required |
|
|
File name |
text |
required |
50001180101070101D |
|
Modification date |
iso8601 |
required |
2018-01-01T07:31:01+01:00 |
|
Operator name |
text |
optional |
ROBERT |
|
GPS measurement |
structure (see below) |
optional |
|
|
File reference |
text |
required |
Bor-Format |
Borehole information (optional)
Property | Description | Type | Required | Example |
---|---|---|---|---|
|
Borehole diameter |
length |
optional |
66 (mm) |
|
Depth of water level [2] |
level |
optional |
8.97 (m) |
Cell position (optional)
Property | Description | Type | Required | Example |
---|---|---|---|---|
|
Cell ID |
integer |
required |
31605177 |
|
Local area code |
integer |
required |
21301 |
|
Mobile country code |
integer |
required |
208 |
|
Mobile network code |
integer |
required |
1 |
GPS measurement (optional)
Property | Description | Type | Required | Example |
---|---|---|---|---|
|
Altitude |
length |
required |
186 (m) |
|
Standard deviation of horizontal position error |
length |
required |
12.229 (m) |
|
Standard deviation of vertical position error |
length |
required |
13.9042 (m) |
|
Latitude |
angle |
required |
45.75905881 (degree) |
|
Longitude |
angle |
required |
4.91944618 (degree) |
Device information
Property | Description | Type | Required | Example |
---|---|---|---|---|
|
Build version |
text |
optional |
20180101 |
|
Serial number |
integer |
required |
50001 |
|
Hardware version |
text |
optional |
1.4 |
Drilling information
Property | Description | Type | Required | Example |
---|---|---|---|---|
|
Drilling tool mass |
mass |
optional |
10 (kg) |
|
Drilling fluid |
code (see below) |
optional |
DRLFLD_WBM |
|
Surface of holdback pressure |
area |
optional |
301 (cm2) |
|
Drilling machine |
text |
optional |
GEODRIL |
|
Drilling method |
code (see below) |
optional |
DRLMTD_RTR |
|
Drilling rod mass |
mass |
optional |
20 (kg) |
|
Drilling rod length |
length |
optional |
2 (m) |
|
Surface of thrust pressure |
area |
optional |
401 (cm2) |
|
Drilling tool |
code (see below) |
optional |
DRLBIT_CNTCI |
|
Drilling tool diameter |
length |
optional |
66 (mm) |
|
Torque factor |
decimal |
optional |
112 |
Drilling method | Description |
---|---|
|
Auger |
|
Continuous flight auger |
|
Auger with drilling mud |
|
Hollow Stem Auger |
|
Disintegrating tool with mud circulation |
|
Core drilling |
|
Rotary drilling |
|
Rotary reverse flow of flushing medium |
|
Rotary percussion |
|
Rotary percussion with mud |
|
Downhole hammer |
|
Driving |
|
Driven sampler |
|
Driven slotted tube |
|
Slotted tube with inside disintegrating tool and mud circulation |
|
Cable percussion drilling |
|
Vibro driven sampler |
|
Vibration drilling |
|
Vibro-sinking |
|
Push sampler |
Drilling tool | Description |
---|---|
|
Blade bit |
|
2 Blades bit |
|
3 Blades bit |
|
4 Blades bit |
|
Bladed tool tip |
|
Bladed tool with tube topped |
|
Jet bit |
|
Rotary disk bit |
|
Flat chisel |
|
Cross chisel |
|
Cross Cut Step bit with TCI |
|
Buttons bit (Rotary percussion) |
|
Buttons bit DTH |
|
Button bit ODEX |
|
Cutter bit PDC (polycrystalline diamond compact) |
|
Cutter bit GHI (grit hotpressed inserts) |
|
Stubber (heavy tool) |
|
California chisel bit |
|
Bicone bit |
|
Tricone bit |
|
Tricone Steeltooth bit |
|
Tricone TCI (Tungsten Carbide Insert) |
|
Spiral bit |
|
Auger |
|
Auger with bucket |
|
Hand Auger |
|
Hollow Stem Auger |
|
Continuous Flight Auger |
|
Core bit |
|
Tungsten carbide set |
|
Geotechnical saw-tooth carbide set |
|
Polycrystalline diamond core bit |
|
Thermally stable polycrystalline set |
|
Single-tube corebarrel |
|
Double-tube corebarrel |
|
Triple-tube corebarrel |
|
DD/TT corebarrel with extended inner tube |
|
Open-sampler thin-walled (Shelby) |
|
Open-sampler thick-walled |
|
Hydraulic Piston samplers |
|
Piston samplers, thick-walled |
|
Piston samplers, thin-walled |
|
Bit with shell (or bailer) |
|
Bit with clay cutter |
|
Sectional shell |
Drilling fluid | Description |
---|---|
|
Air |
|
Water |
|
Air-Water |
|
Air-Polymer |
|
Water-based mud |
|
Water-Shale-based mud |
|
Dry-polymer-based mud |
|
Lignosulfonate-based mud |
|
Sea-Water-based mud |
|
Saturated-Salt-based mud |
|
Lime-based mud |
|
Calcium-based mud |
|
Oil-based mud |
|
Synthetic-based mud |
Field types (convention)
Drilling Parameters convention
Definition
Drilling Parameters convention combine drilling parameters recorded during drilling tool movement according to time or depth.
The convention is simply named parameters.
Three different field types are actually supported by this format. Each field type can have different phases.
Field type | Phase |
---|---|
Parameters recorded during drilling |
|
Jet grouting parameters recorded during drilling and injection |
|
CFA Pile parameters recorded during drilling and concreting |
|
Example of parameters convention
<convention version="1.1">
<parameters phase="DRILL">
<inclination>
<X unit="degree">91.9</X>
<Y unit="degree">88.6</Y>
</inclination>
<effective_duration unit="s">3789.00</effective_duration>
<logfile>data.nc</logfile>
</parameters>
</convention>
Properties
Property | Description | Type | Required | Example |
---|---|---|---|---|
|
Drilling effective duration (out of break) |
duration |
required |
3789.00 (s) |
|
Tilt of the drill mast |
structure (see below) |
optional |
|
|
Name of data file |
text |
required |
data.nc |
Property | Description | Type | Required | Example |
---|---|---|---|---|
|
Inclination depending on X direction |
angle |
required |
91.9 (degree) |
|
Inclination depending on Y direction |
angle |
required |
88.6 (degree) |
Data file
Data file is made with the netCDF (3.6+) format. They contain data logs and log names declarations (variables).
Example of data.nc dump
Example of data file from 50001180101070101D.bor (data.nc dump to data.cdl format)
netcdf data { dimensions: time = UNLIMITED ; // (976 currently) variables: float time(time) ; time:unit = "s" ; time:label = "Temps" ; float DEPTH(time) ; DEPTH:unit = "m" ; DEPTH:label = "Prof." ; float AS(time) ; AS:unit = "m/h" ; AS:label = "VIA" ; AS:scale_max = 1500.f ; int EVP(time) ; EVP:label = "evt-part" ; int EVR(time) ; EVR:label = "evt-new-rod" ; float TP(time) ; TP:unit = "bar" ; TP:label = "PO" ; TP:scale_max = 300.f ; float IP(time) ; IP:unit = "bar" ; IP:label = "PI" ; IP:scale_max = 50.f ; float TQ(time) ; TQ:unit = "bar" ; TQ:label = "CR" ; TQ:scale_max = 300.f ; float SP(time) ; SP:unit = "bar" ; SP:label = "PF" ; SP:scale_max = 300.f ; data: time = 0, 2.2, 2.4, 2.6, 2.8, 3, 3.2, 3.4, 3.6, 3.8, 4, 4.2, 4.4, 4.6, 4.8, ... 4037.6, 4042.4, 4043.6, 4046, 4047, 4163.4 ; DEPTH = 0, 0.02, 0.08, 0.15, 0.21, 0.28, 0.35, 0.42, 0.48, 0.55, 0.62, 0.69, ... 14.96, 14.97, 14.98, 15 ; AS = 0, 31.45398, 1178.385, 1148.298, 1138.269, 1228.529, 1258.615, .... 15.87894, 53.15267, 20.05761 ; EVP = 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ... 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ; EVR = 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ... 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ; TP = 7.42, 7.42, 70.89, 70.89, 70.89, 70.89, 70.89, 70.89, 70.89, 70.89, ... 73.34, 74.56, 74.56, 74.56, 70.89, 4.98 ; IP = 1.31, 1.31, 1.31, 1.31, 1.31, 1.31, 1.31, 1.31, 1.31, 1.31, 1.31, 1.31, ... 12.3, 4.98, 7.42, 17.18, 11.08, 7.42, 14.74, 12.3, 1.31 ; TQ = 4.98, 4.98, 6.2, 6.2, 2.53, 4.98, 4.98, 4.98, 4.98, 4.98, 4.98, 4.98, ... 74.56, 86.76, 85.54, 85.54, 64.79 ; SP = 1.31, 2.53, 1.31, 0, 4.98, 1.31, 0.09, 1.31, 6.2, 0, 4.98, 1.31, 2.53, ... 2.53, 1.31, 2.53, 1.31, 2.53, 4.98, 0, 4.98, 4.98, 7.42 ; }
Parameters Log names
Log name | Description | Type | Required | Remark |
---|---|---|---|---|
|
Measured time |
float |
required |
NETCDF dimension |
|
Measured penetration length |
float |
required |
|
|
Advance Speed (penetration rate) |
float |
required |
|
|
Event Particular |
integer |
optional |
|
|
Event new Rod |
integer |
optional |
|
|
Event start relay |
float |
optional |
|
|
Tool pressure |
float |
optional |
|
|
Injection pressure |
float |
optional |
|
|
Rotation pressure (Torque) |
float |
optional |
|
|
Casing Rotation pressure |
float |
optional |
|
|
Rotation Speed |
float |
optional |
|
|
Casing Rotation Speed |
float |
optional |
|
|
Holding Pressure |
float |
optional |
|
|
Striking Pressure |
float |
optional |
|
|
Reflected Vibration |
float |
optional |
|
|
Injection Flow (inlet flow) |
float |
optional |
|
|
Drilling fluid outflow (Outlet Flow) |
float |
optional |
|
|
Injection Volume |
float |
optional |
|
|
Outlet Volume |
float |
optional |
|
|
Air Pressure |
float |
optional |
|
|
Air Flow |
float |
optional |
|
|
Air Volume |
float |
optional |
|
|
Water Flow |
float |
optional |
|
|
Water Pressure |
float |
optional |
|
|
Water Volume |
float |
optional |
|
|
Electrical Conductivity of Mud |
float |
optional |
|
|
pH of Mud |
float |
optional |
|
|
Dissolved O2 in Mud |
float |
optional |
|
|
Temperature of Mud |
float |
optional |
Ménard Pressuremeter Test convention
Definition
Ménard Pressuremeter Test is performed by the radial expansion of a tricell probe placed in the ground. This test is specified by the standard ISO 22476-4.
The convention is simply named pressuremeter.
Three different pressuremeter test types are supported by this format.
Test type | Description |
---|---|
|
Ménard pressuremeter test in natural soils |
|
Equipment volume loss calibration test |
|
Probe pressure loss calibration test |
Example of Ménard Pressuremeter Test convention
<convention version="1.2">
<pressuremeter>
<cu_ref>CPVA001</cu_ref>
<ground>
<pressure_loss_filename>50001180101062101P.bor</pressure_loss_filename>
<cu_height unit="m">1</cu_height>
<test_depth unit="m">2</test_depth>
<logfile>data.nc</logfile>
</ground>
</pressuremeter>
</convention>
Common properties
Property | Description | Type | Required | Example |
---|---|---|---|---|
|
Control Unit ID |
text |
optional |
CPVA001 |
Volume loss test
<volume_loss>
<cover_type>CVR_RUBBER</cover_type>
<probe_type>PRB_G</probe_type>
<central_cell_diameter unit="mm">56</central_cell_diameter>
<central_cell_length unit="mm">210</central_cell_length>
<tubing_type>TUB_COAXIAL</tubing_type>
<tubing_length unit="m">25</tubing_length>
<calibration_cylinder_diameter unit="mm">60</calibration_cylinder_diameter>
<membrane_pressure_loss unit="bar">0.54</membrane_pressure_loss>
<slotted_tube>true</slotted_tube>
<central_cell_diameter_inside_slotted_tube unit="mm">
44
</central_cell_diameter_inside_slotted_tube>
<logfile>data.nc</logfile>
</volume_loss>
Property | Description | Type | Required | Example |
---|---|---|---|---|
|
Calibration cylinder diameter |
length |
required |
66 (mm) |
|
Central cell diameter |
length |
required |
56 (mm) |
|
Central cell length |
length |
required |
210 (mm) |
|
Cover type |
code (see below) |
required |
CVR_RUBBER |
|
Membrane pressure loss |
pressure |
required |
0.054 (MPa) |
|
Type of pressuremeter probe |
code (see below) |
required |
PRB_G |
|
Tubing length |
length |
required |
25 (m) |
|
Tubing type |
code (see below) |
required |
TUB_COAXIAL |
|
Name of data file |
text |
required |
data.nc |
Cover type | Description |
---|---|
|
Rubber |
|
Reinforced mesh |
|
Metallic mesh |
|
Metallic strips |
Probe type | Description |
---|---|
|
Type of pressuremeter probe where the central measuring cell is formed by a dedicated membrane over which an external membrane is fitted to form the guard cells |
|
Type of pressuremeter probe where the three cells are formed by three separate membranes in line |
Tubing type | Description |
---|---|
|
Parallel lines |
|
Coaxial line |
Pressure loss test
<pressure_loss>
<volume_loss_filename>50001180101060101P.bor</volume_loss_filename>
<logfile>data.nc</logfile>
</pressure_loss>
Property | Description | Type | Required | Example |
---|---|---|---|---|
|
Name of associated volume loss test |
text |
required |
50001180101060101P.bor |
|
Name of data file |
text |
required |
data.nc |
Ground test
<ground>
<pressure_loss_filename>50001180101062101P.bor</pressure_loss_filename>
<cu_height unit="m">1</cu_height>
<test_depth unit="m">2</test_depth>
<logfile>data.nc</logfile>
</ground>
Property | Description | Type | Required | Example |
---|---|---|---|---|
|
Height of the control unit relative to ground level |
length |
required |
1 (m) |
|
Name of associated pressure loss test |
text |
required |
50001180101060101P.bor |
|
Depth of the test relative to ground level |
length |
required |
2 (m) |
|
Name of data file |
text |
required |
data.nc |
Data file
Data file is made with the netCDF (3.6+) format. They contain data logs and log names declarations (variables).
Example of data.nc dump
Example of data file (data.nc dump to data.cdl format)
netcdf data { dimensions: time = UNLIMITED ; // (12 currently) variables: float time(time) ; time:unit = "s" ; time:label = "time" ; float PR1(time) ; PR1:unit = "bar" ; PR1:label = "PR1S" ; float PR15(time) ; PR15:unit = "bar" ; PR15:label = "PR15S" ; float PR30(time) ; PR30:unit = "bar" ; PR30:label = "PR30S" ; float PR60(time) ; PR60:unit = "bar" ; PR60:label = "PR60S" ; float PG1(time) ; PG1:unit = "bar" ; PG1:label = "PG1S" ; float PG15(time) ; PG15:unit = "bar" ; PG15:label = "PG15S" ; float PG30(time) ; PG30:unit = "bar" ; PG30:label = "PG30S" ; float PG60(time) ; PG60:unit = "bar" ; PG60:label = "PG60S" ; float V1(time) ; V1:unit = "cm3" ; V1:label = "V1S" ; float V15(time) ; V15:unit = "cm3" ; V15:label = "V15S" ; float V30(time) ; V30:unit = "cm3" ; V30:label = "V30S" ; float V60(time) ; V60:unit = "cm3" ; V60:label = "V60S" ; V60:scale_max = 500.f ; float CREEP(time) ; CREEP:unit = "cm3" ; CREEP:label = "fluage" ; float DELT60(time) ; DELT60:unit = "cm3" ; DELT60:label = "delt60" ; data: time = 80, 141, 205, 273, 339, 410, 477, 546, 616, 687, 759, 836 ; PR1 = 0.48, 0.96, 1.48, 2.62, 3.46, 5.67, 7.62, 11.59, 15.6, 20.53, 25.49, 30.46 ; PR15 = 0.51, 1, 1.45, 2.56, 3.52, 5.57, 7.48, 11.53, 15.48, 20.52, 25.48, 30.48 ; PR30 = 0.49, 1.02, 1.51, 2.56, 3.5, 5.55, 7.47, 11.5, 15.47, 20.53, 25.49, 30.48 ; PR60 = 0.46, 0.98, 1.5, 2.55, 3.47, 5.52, 7.49, 11.56, 15.47, 20.48, 25.5, 30.5 ; PG1 = 0.12, 0.12, 0.52, 1.5, 2.6, 4.52, 6.48, 10.48, 14.51, 19.54, 24.59, 29.53 ; PG15 = 0.14, 0.12, 0.53, 1.5, 2.54, 4.53, 6.51, 10.5, 14.56, 19.52, 24.52, 29.5 ; PG30 = 0.12, 0.12, 0.53, 1.52, 2.55, 4.53, 6.5, 10.5, 14.52, 19.55, 24.5, 29.53 ; PG60 = 0.14, 0.14, 0.56, 1.53, 2.53, 4.53, 6.51, 10.51, 14.51, 19.53, 24.53, 29.55 ; V1 = 37, 51, 81, 105, 116, 136, 152, 178, 207, 240, 282, 348 ; V15 = 43, 65, 89, 108, 119, 139, 155, 185, 212, 249, 295, 369 ; V30 = 46, 72, 91, 110, 121, 141, 156, 187, 215, 254, 304, 388 ; V60 = 48, 77, 95, 111, 121, 142, 158, 189, 219, 259, 315, 414 ; CREEP = 2, 5, 4, 1, 0, 1, 2, 2, 4, 5, 11, 26 ; DELT60 = 48, 29, 18, 16, 10, 21, 16, 31, 30, 40, 56, 99 ; }
Pressuremeter Log names
Log name | Description | Type | Required | Remark |
---|---|---|---|---|
|
Measured time |
float |
required |
NETCDF dimension |
|
Liquid pressure at 1 s [3] |
float |
required |
|
|
Liquid pressure at 15 s [3] |
float |
required |
|
|
Liquid pressure at 30 s [3] |
float |
required |
|
|
Liquid pressure at 60 s [3] |
float |
required |
|
|
Gas pressure at 1 s [4] |
float |
required |
|
|
Gas pressure at 15 s [4] |
float |
required |
|
|
Gas pressure at 30 s [4] |
float |
required |
|
|
Gas pressure at 60 s [4] |
float |
required |
|
|
Volume of injected liquid at 1 s [5] |
float |
required |
|
|
Volume of injected liquid at 15 s [5] |
float |
required |
|
|
Volume of injected liquid at 30 s [5] |
float |
required |
|
|
Volume of injected liquid at 60 s [5] |
float |
required |
|
|
Difference in volumes recorded at 60 s and at 30 s at each pressure hold |
float |
required |
|
|
60 s injected volume change between successive pressure holds |
float |
required |