Cone Penetration Test (CPT)

A Cone Penetration Test is used both on land and at sea to map the subsurface structure, with a focus on the geotechnical characteristics of the subsurface.

import os
import brodata

download_dir = "download"
if not os.path.isdir(download_dir):
    os.makedirs(download_dir)
fname = os.path.join(download_dir, "CPT000000005925.xml")
cpt = brodata.cpt.ConePenetrationTest.from_bro_id("CPT000000005925", to_file=fname)
cpt

ConePenetrationTest(broId='CPT000000005925', x=118406.0, y=439678.0)

cpt.conePenetrationTest

	depth	elapsedTime	coneResistance	correctedConeResistance	netConeResistance	magneticFieldStrengthX	magneticFieldStrengthY	magneticFieldStrengthZ	magneticFieldStrengthTotal	electricalConductivity	...	inclinationResultant	magneticInclination	magneticDeclination	localFriction	poreRatio	temperature	porePressureU1	porePressureU2	porePressureU3	frictionRatio
penetrationLength
0.4	NaN	NaN	1.50	NaN	NaN	NaN	NaN	NaN	NaN	NaN	...	NaN	NaN	NaN	0.066	NaN	NaN	NaN	NaN	NaN	4.4
0.5	NaN	NaN	1.60	NaN	NaN	NaN	NaN	NaN	NaN	NaN	...	NaN	NaN	NaN	0.060	NaN	NaN	NaN	NaN	NaN	3.7
0.6	NaN	NaN	2.00	NaN	NaN	NaN	NaN	NaN	NaN	NaN	...	NaN	NaN	NaN	0.066	NaN	NaN	NaN	NaN	NaN	3.3
0.7	NaN	NaN	2.20	NaN	NaN	NaN	NaN	NaN	NaN	NaN	...	NaN	NaN	NaN	0.093	NaN	NaN	NaN	NaN	NaN	4.2
0.8	NaN	NaN	2.00	NaN	NaN	NaN	NaN	NaN	NaN	NaN	...	NaN	NaN	NaN	0.073	NaN	NaN	NaN	NaN	NaN	3.6
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
17.8	NaN	NaN	13.00	NaN	NaN	NaN	NaN	NaN	NaN	NaN	...	NaN	NaN	NaN	0.266	NaN	NaN	NaN	NaN	NaN	2.0
17.9	NaN	NaN	11.00	NaN	NaN	NaN	NaN	NaN	NaN	NaN	...	NaN	NaN	NaN	0.283	NaN	NaN	NaN	NaN	NaN	2.5
18.0	NaN	NaN	9.00	NaN	NaN	NaN	NaN	NaN	NaN	NaN	...	NaN	NaN	NaN	0.300	NaN	NaN	NaN	NaN	NaN	3.3
18.1	NaN	NaN	12.25	NaN	NaN	NaN	NaN	NaN	NaN	NaN	...	NaN	NaN	NaN	0.000	NaN	NaN	NaN	NaN	NaN	NaN
18.2	NaN	NaN	15.50	NaN	NaN	NaN	NaN	NaN	NaN	NaN	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN

179 rows × 24 columns

Plot a single Cone Penetration Test (CPT).

brodata.plot.cone_penetration_test(cpt);

You can also request the BRO web service to generate a graphical representation of the CPT.

brodata.cpt.graph(fname)

We can show the different supported graph types with the following command:

brodata.cpt.get_graph_types()

	name	description
graphType
localFrictionBasic	Plaatselijke wrijving	Plaatselijke wrijving uitgezet tegen de sondee...
cptCombinedLengthFixed	Gecombineerde grafiek, vaste schaal - lengte	Gecombineerde grafiek: wrijvingsweerstand, con...
inclinationResultantBasic	Hellingsresultante	Hellingsresultante uitgezet tegen de sondeertr...
porePressureU1Basic	Waterspanning U1	Waterspanning - U1, uitgezet tegen de sondeert...
coneResistanceBasic	Conusweerstand	Conusweerstand uitgezet tegen de sondeertrajec...
cptCombinedDepth	Gecombineerde grafiek 2 - diepte	Gecombineerde grafiek: conusweerstand, plaatse...
porePressureU2Basic	Waterspanning U2	Waterspanning - U2, uitgezet tegen de sondeert...
cptCombinedDepthFixed	Gecombineerde grafiek, vaste schaal - diepte	Gecombineerde grafiek: wrijvingsweerstand, con...
cptCombinedLength	Gecombineerde grafiek 3 - lengte	Gecombineerde grafiek: conusweerstand, plaatse...
frictionRatioBasic	Wrijvingsgetal	Wrijvingsgetal uitgezet tegen de sondeertrajec...
porePressureU3Basic	Waterspanning U3	Waterspanning - U3, uitgezet tegen de sondeert...

Show the rest of the contents of the Cone Penetration Test.

cpt_data = cpt.to_dict()
cpt_data.pop("conePenetrationTest")
cpt_data

{'additionalInvestigationPerformed': 'onbekend',
 'broId': 'CPT000000005925',
 'conePenetrationTest_phenomenonTime': Timestamp('1986-09-15 00:00:00'),
 'conePenetrationTest_resultTime': Timestamp('1986-09-15 00:00:00'),
 'conePenetrometerType': 'ONBEKEND',
 'coneSurfaceArea': None,
 'coneToFrictionSleeveDistance': None,
 'coordinateTransformation': 'RDNAPTRANS2008',
 'corrected': 'nee',
 'cptMethod': 'mechanischDiscontinu',
 'cptStandard': 'NEN3680',
 'date': '1986-09-15',
 'deliveredLocation': <POINT (118406 439678)>,
 'deliveryAccountableParty': '50200097',
 'deliveryContext': 'archiefoverdracht',
 'deregistered': 'nee',
 'description': '??&MZW',
 'dissipationTestPerformed': 'nee',
 'expertCorrectionPerformed': 'onbekend',
 'featureOfInterest': None,
 'finalDepth': '18.200',
 'frictionSleeveSurfaceArea': None,
 'frictionSleeveSurfaceQuotient': None,
 'horizontalPositioningDate': Timestamp('1986-09-15 00:00:00'),
 'horizontalPositioningMethod': 'onbekend',
 'id': 'BRO_0007',
 'interruptionProcessingPerformed': 'onbekend',
 'localVerticalReferencePoint': 'maaiveld',
 'objectRegistrationTime': '2017-01-10T21:20:08+01:00',
 'observedProperty': None,
 'offset': '5.580',
 'parameters': penetrationLength              ja
 depth                         nee
 elapsedTime                   nee
 coneResistance                 ja
 correctedConeResistance       nee
 netConeResistance             nee
 magneticFieldStrengthX        nee
 magneticFieldStrengthY        nee
 magneticFieldStrengthZ        nee
 magneticFieldStrengthTotal    nee
 electricalConductivity        nee
 inclinationEW                 nee
 inclinationNS                 nee
 inclinationX                  nee
 inclinationY                  nee
 inclinationResultant          nee
 magneticInclination           nee
 magneticDeclination           nee
 localFriction                  ja
 poreRatio                     nee
 temperature                   nee
 porePressureU1                nee
 porePressureU2                nee
 porePressureU3                nee
 frictionRatio                  ja
 dtype: str,
 'predrilledDepth': '0.40',
 'procedure': None,
 'qualityClass': 'nvt',
 'qualityRegime': 'IMBRO/A',
 'registrationCompletionTime': '2017-01-10T21:20:08+01:00',
 'registrationStatus': 'voltooid',
 'reregistered': 'nee',
 'researchReportDate': Timestamp('2009-10-23 00:00:00'),
 'sampledFeature': None,
 'signalProcessingPerformed': 'onbekend',
 'standardizedLocation': <POINT (4.855 51.944)>,
 'stopCriterion': 'einddiepte',
 'surveyPurpose': 'onbekend',
 'underReview': 'nee',
 'verticalDatum': 'NAP',
 'verticalPositioningMethod': 'onbekend',
 'voidReason': 'onbekend',
 'zeroLoadMeasurement': None}