jkall / qgis-midvatten-plugin

Midvatten plugin for QGIS
24 stars 8 forks source link

AGS import function? #322

Open KoalaGeo opened 5 years ago

KoalaGeo commented 5 years ago

Have you considered including AGS format http://www.agsdataformat.com/datatransferv4/rules.php as one of the data import formats?

HenrikSpa commented 5 years ago

Hi!

We usually only implement specific import functions for data formats that we regularly use ourselves. We haven't yet stumbled upon this AGS format. Where and when do you use it?

I checked the example file "Monitoring Example 2: Precise level point " (The "Example" menu to the left on your linked page). The format seems to store a lot of metadata at the top of the file, then the data as comma separated values ("GROUP","MOND" for example).

The data can be imported one file at the time using the Midvatten general csv import:

If the data of interest is always at the bottom of the file, it could be loaded to QGIS using Layer->Add Layer->Add delimited text layer and then choose to skip the first X rows, and specifying comma as delimiter and " as quote. The data can then be imported using Midvatten > Import data to database >" Import data using general csv format" and then choosing "Load data from all features from active layer.

You could also load the whole file as comma delimited file using "Add delimited text layer" and then select the rows of interest and choose "Load data from selected features from active layer" instead. Then you have to answer that there is no header and specify which column goes where in the next step.

jkall commented 5 years ago

A new database design would probably make it easier to add a number of various import formats. AGS is definitely one of the exchange formats to study carefully in the process of deciding a new database design.

KoalaGeo commented 5 years ago

Great to hear.

@HenrikSpa AGS is a standard file format for sharing site investigation data in the UK, Australia & NZ, including contractor, laboratory, drilling and logging data.

Its one of the accepted file formats for submission to the British Geological Survey archives who then make them open, they have over 10,000 boreholes available in AGS format.

cesarcorreo commented 3 years ago

Any update about AGS format import? Thanks

HenrikSpa commented 3 years ago

Note to self: There is a python package for reading and writing AGS-files, but it would have to be installed manually (OSGeo4-win doesn't have it): https://pypi.org/project/python-ags4/.

@cesarcorreo Could you give a short example file with the information you would need from the AGS format? There is a very large variety of data that could be stored in an AGS file and it's a lot of work to implement it fully or to cover all variables that the Midvatten database itself can store.

Regards, Henrik

cesarcorreo commented 3 years ago

At the moment I don't have the programme installed (due to licensing issues) so I can't send you a "proper file". On the website ( http://ags-archive.forumcourt.myzen.co.uk/datatransferv4/example.php ) you can download several examples dedicated to specific measurements; moreover, they come with a small document explaining the file structure. I'm sure this is more useful than a file I could send you. Best regards ____

César Herrera Lindo http://www.cesarpagina.com

El lun, 22 mar 2021 a las 9:07, HenrikSpa @.***>) escribió:

Note to self: There is a python package for reading and writing AGS-files, but it would have to be installed manually (OSGeo4-win doesn't have it): https://pypi.org/project/python-ags4/.

@cesarcorreo https://github.com/cesarcorreo Could you give a short example file with the information you would need from the AGS format? There is a very large variety of data that could be stored in an AGS file and it's a lot of work to implement it fully or to cover all variables that the Midvatten database itself can store.

Regards, Henrik

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/jkall/qgis-midvatten-plugin/issues/322#issuecomment-803854497, or unsubscribe https://github.com/notifications/unsubscribe-auth/AGF3HWJRTB7AGZ5G673OB4LTE33DXANCNFSM4H3GHTAA .

KoalaGeo commented 3 years ago

FYI the python library repo is moving to https://gitlab.com/ags-data-format-wg/ags-python-library as it's being brought under the AGS (https://www.ags.org.uk/) organisational umbrella. And hopefully in the next few months they'll be a open API available to validate AGS files.

Example AGS file below (can't attach .ags files in GitHub). Typically you'd want borehole locations, geology logs, sampling and geotech testing results.

"GROUP","PROJ" "HEADING","PROJ_ID","PROJ_NAME","PROJ_LOC","PROJ_CLNT","PROJ_CONT","PROJ_ENG","PROJ_MEMO","FILE_FSET","PROJ_OFFC" "UNIT","","","","","","","","","" "TYPE","X","X","X","X","X","X","X","X","U" "DATA","A112794-16","Glenelly Road Embankment Slip","116 Glenelly Road","Dfl Roads HSU","WYG","JA","","","Belfast"

"GROUP","ABBR" "HEADING","ABBR_HDNG","ABBR_CODE","ABBR_DESC","ABBR_LIST","ABBR_REM","FILE_FSET" "UNIT","","","","","","" "TYPE","X","X","X","X","X","X" "DATA","DICT_TYPE","GROUP","Group","","","" "DATA","DICT_TYPE","HEADING","Heading","","","" "DATA","DICT_STAT","OTHER","Other Field","","","" "DATA","DICT_STAT","KEY","Key Field","","","" "DATA","LOCA_TYPE","CP","Cable percussion (shell and auger)","","","" "DATA","LOCA_STAT","DRAFT","Draft data","","","" "DATA","BKFL_LEG","903","Bentonite","","","" "DATA","HDPH_TYPE","CP","Cable percussion (shell and auger)","","","" "DATA","SAMP_TYPE","B","Bulk disturbed sample","","","" "DATA","SAMP_TYPE","D","Small disturbed sample","","","" "DATA","ERES_CODE","P1440","Moisture content","","","" "DATA","ERES_MATX","SOLID","Solid","","","" "DATA","ERES_RTYP","INITIAL","Initial","","","" "DATA","ERES_RUNI","%","percentage","","","" "DATA","GCHM_CODE","PH","Acidity/alkalinity (pH to nearest 0.1)","","","" "DATA","GCHM_CODE","WS","Water-soluble sulphate (as mg/l SO4)","","","" "DATA","GCHM_TTYP","SOLID_21 WATER EXTRACT","Solid (2:1 Soil/Water extract)","","","" "DATA","GCHM_UNIT","-","No unit","","","" "DATA","GCHM_UNIT","g/l","grams per litre","","","" "DATA","SHBG_TYPE","SMALL SBOX","Small Shearbox","","","" "DATA","SHBG_COND","REMOULDED","Remoulded","","","" "DATA","ISPT_TYPE","S","Split spoon","","","" "DATA","GEOL_LEG","102","MADE GROUND","","","" "DATA","GEOL_LEG","504","Sandy GRAVEL","","","" "DATA","GEOL_LEG","601","PEAT","","","" "DATA","GEOL_LEG","813","Medium grained METAMORPHIC","","",""

"GROUP","DICT" "HEADING","DICT_TYPE","DICT_GRP","DICT_HDNG","DICT_STAT","DICT_DTYP","DICT_DESC","DICT_UNIT","DICT_EXMP","DICT_PGRP","DICT_REM","FILE_FSET" "UNIT","","","","","","","","","","","" "TYPE","PA","X","X","PA","PT","X","PU","X","X","X","X" "DATA","HEADING","PROJ","PROJ_OFFC","OTHER","X","Undefined","","","","","" "DATA","HEADING","LOCA","LOCA_CHKG","OTHER","X","The person who checked the data for this Location","","","","","" "DATA","HEADING","LOCA","LOCA_APPG","OTHER","X","The person who approved the data for this Location","","","","","" "DATA","HEADING","ISPT","ISPT_RL","OTHER","2DP","SPT Rod Length","m","","","","" "DATA","HEADING","GEOL","GEOL_GEO3","OTHER","PA","Third Geology Code","","","","",""

"GROUP","TRAN" "HEADING","TRAN_ISNO","TRAN_DATE","TRAN_PROD","TRAN_STAT","TRAN_DESC","TRAN_AGS","TRAN_RECV","TRAN_DLIM","TRAN_RCON","TRAN_REM","FILE_FSET" "UNIT","","yyyy-mm-dd","","","","","","","","","" "TYPE","X","DT","X","X","X","X","X","X","X","X","X" "DATA","1","2020-01-09","WYG","Preliminary","Undefined","4.0","Undefined","|","+","",""

"GROUP","TYPE" "HEADING","TYPE_TYPE","TYPE_DESC","FILE_FSET" "UNIT","","","" "TYPE","X","X","X" "DATA","U","Undefined","" "DATA","X","Text","" "DATA","ID","Unique identifier","" "DATA","PA","ABBR pick list","" "DATA","2DP","Value; required number of decimal places, 2","" "DATA","DT","Date Time (ISO 8601:2004)","" "DATA","0DP","Value; required number of decimal places, 0","" "DATA","1DP","Value; required number of decimal places, 1","" "DATA","YN","Yes/No","" "DATA","XN","Text/Numeric","" "DATA","3DP","Value; required number of decimal places, 3","" "DATA","PT","TYPE pick list","" "DATA","PU","UNIT pick list","" "DATA","DMS","Degrees:Minutes:Seconds","" "DATA","T","Elapsed time","" "DATA","RL","Record link","" "DATA","2SF","Value; required number of significant figures, 2","" "DATA","MC","Moisture content (BS1377:Part 2)",""

"GROUP","UNIT" "HEADING","UNIT_UNIT","UNIT_DESC","UNIT_REM","FILE_FSET" "UNIT","","","","" "TYPE","X","X","X","X" "DATA","%","percentage","","" "DATA","-","No unit","","" "DATA","g/l","grams per litre","","" "DATA","m","metre","","" "DATA","yyyy-mm-dd","Date (ISO8601)","","" "DATA","mm","millimetre","","" "DATA","yyyy-mm-ddThh:mm:ss","Date Time (ISO8601)","","" "DATA","deg","degree (angle)","","" "DATA","bar","bar","","" "DATA","degC","degree Celsius","","" "DATA","l/min","litres per minute","","" "DATA","hh:mm:ss","hh:mm:ss","","" "DATA","s","second","","" "DATA","kPa","kiloPascal","","" "DATA","Mg/m3","megagrams per cubic metre","","" "DATA","mm/min","millimetres per minute","","" "DATA","l","litre","",""

"GROUP","BKFL" "HEADING","LOCA_ID","BKFL_TOP","BKFL_BASE","BKFL_DESC","BKFL_LEG","BKFL_DATE","BKFL_REM","FILE_FSET" "UNIT","","m","m","","","yyyy-mm-dd","","" "TYPE","ID","2DP","2DP","X","PA","DT","X","X" "DATA","BH01","0.00","5.08","Bentonite Backfill","903","","",""

"GROUP","CDIA" "HEADING","LOCA_ID","CDIA_DPTH","CDIA_DIAM","CDIA_REM","FILE_FSET" "UNIT","","m","mm","","" "TYPE","ID","2DP","0DP","X","X" "DATA","BH01","5.08","200","",""

"GROUP","ERES" "HEADING","LOCA_ID","SAMP_TOP","SAMP_REF","SAMP_TYPE","SAMP_ID","SPEC_REF","SPEC_DPTH","ERES_CODE","ERES_METH","ERES_MATX","ERES_RTYP","ERES_TESN","ERES_NAME","ERES_TNAM","ERES_RVAL","ERES_RUNI","ERES_RTXT","ERES_RTCD","ERES_RRES","ERES_DETF","ERES_ORG","ERES_IQLF","ERES_LQLF","ERES_RDLM","ERES_MDLM","ERES_QLM","ERES_DUNI","ERES_TICP","ERES_TICT","ERES_RDAT","ERES_SGRP","SPEC_PREP","SPEC_DESC","ERES_DTIM","ERES_TEST","ERES_TORD","ERES_LOCN","ERES_BAS","ERES_DIL","ERES_LMTH","ERES_LDTM","ERES_IREF","ERES_SIZE","ERES_PERP","ERES_REM","ERES_LAB","ERES_CRED","TEST_STAT","FILE_FSET" "UNIT","","m","","","","","m","","","","","","","","","","","","","","","","","","","","","%","s","yyyy-mm-dd","","","","yyyy-mm-ddThh:mm:ss","","","","","","","yyyy-mm-ddThh:mm:ss","","mm","%","","","","","" "TYPE","ID","2DP","X","PA","ID","X","2DP","PA","X","PA","PA","X","X","X","2DP","PA","X","PA","YN","YN","YN","X","X","2DP","2DP","2DP","PA","0DP","0DP","DT","X","X","X","DT","X","X","PA","PA","0DP","X","DT","X","0DP","1DP","X","X","X","X","X" "DATA","BH01","3.80","9","B","","941532_MOI_SZ","","P1440","2030","SOLID","INITIAL","","Moisture content","","11.11","%","11","","","","","","","","0.02","","","","","2019-12-11","","","","","","","","","","","","","","","","","Unaccredited","",""

"GROUP","GCHM" "HEADING","LOCA_ID","SAMP_TOP","SAMP_REF","SAMP_TYPE","SAMP_ID","SPEC_REF","SPEC_DPTH","GCHM_CODE","GCHM_METH","GCHM_TTYP","GCHM_RESL","GCHM_UNIT","GCHM_NAME","SPEC_DESC","SPEC_PREP","GCHM_REM","GCHM_LAB","GCHM_CRED","TEST_STAT","FILE_FSET" "UNIT","","m","","","","","m","","","","","","","","","","","","","" "TYPE","ID","2DP","X","PA","ID","X","2DP","PA","X","PA","XN","PA","X","X","X","X","X","X","X","X" "DATA","BH01","2.80","8","B","","941532_PH_SZ","","PH","2010","SOLID_21 WATER EXTRACT","7.20","-","Acidity/alkalinity (pH to nearest 0.1)","","","","","UKAS 2183 Accredited","","" "DATA","BH01","2.80","8","B","","941532_HWSO4_SZ","","WS","2120","SOLID_21 WATER EXTRACT","<0.010","g/l","Water-soluble sulfate (as mg/l SO4)","","","","","UKAS 2183 Accredited","",""

"GROUP","GEOL" "HEADING","LOCA_ID","GEOL_TOP","GEOL_BASE","GEOL_DESC","GEOL_LEG","GEOL_GEOL","GEOL_GEO2","GEOL_STAT","GEOL_BGS","GEOL_FORM","GEOL_REM","FILE_FSET","GEOL_GEO3" "UNIT","","m","m","","","","","","","","","","" "TYPE","ID","2DP","2DP","X","PA","PA","PA","X","PA","X","X","X","PA" "DATA","BH01","0.00","0.10","MADE GROUND: Bituminous Macadam","102","","","","","","","","" "DATA","BH01","0.10","0.50","MADE GROUND: Brown, sandy gravel with low cobble content. Gravel is fine to coarse and sub-angular.","102","","","","","","","","" "DATA","BH01","0.50","1.10","Spongy, brown, fibrous PEAT","601","","","","","","","","" "DATA","BH01","1.10","4.80","Medium dense to dense, grey, sandy GRAVEL. Sand is fine to coarse. Gravel is fine to coarse, sub-angular to sub-rounded schist.","504","","","","","","","","" "DATA","BH01","4.80","5.08","Possible Schist BEDROCK","813","","","","","","","",""

"GROUP","HDIA" "HEADING","LOCA_ID","HDIA_DPTH","HDIA_DIAM","HDIA_REM","FILE_FSET" "UNIT","","m","mm","","" "TYPE","ID","2DP","0DP","X","X" "DATA","BH01","5.08","200","",""

"GROUP","HDPH" "HEADING","LOCA_ID","HDPH_TOP","HDPH_BASE","HDPH_TYPE","HDPH_STAR","HDPH_ENDD","HDPH_CREW","HDPH_EXC","HDPH_SHOR","HDPH_STAB","HDPH_DIML","HDPH_DIMW","HDPH_DBIT","HDPH_BCON","HDPH_BTYP","HDPH_BLEN","HDPH_LOG","HDPH_LOGD","HDPH_REM","HDPH_ENV","HDPH_METH","HDPH_CONT","FILE_FSET" "UNIT","","m","m","","yyyy-mm-ddThh:mm:ss","yyyy-mm-ddThh:mm:ss","","","","","m","m","","","","m","","yyyy-mm-dd","","","","","" "TYPE","ID","2DP","2DP","PA","DT","DT","X","X","X","X","2DP","2DP","X","X","X","2DP","X","DT","X","X","X","X","X" "DATA","BH01","0.00","5.08","CP","2019-11-04T00:00:00","2019-11-04T00:00:00","SS","Dando 2000","","","","","","","","","OR","2019-11-04","","","","Causeway Geotech",""

"GROUP","HORN" "HEADING","LOCA_ID","HORN_TOP","HORN_BASE","HORN_ORNT","HORN_INCL","HORN_REM","FILE_FSET" "UNIT","","m","m","deg","deg","","" "TYPE","ID","2DP","2DP","0DP","0DP","X","X" "DATA","BH01","0.00","5.08","","90","",""

"GROUP","ISPT" "HEADING","LOCA_ID","ISPT_TOP","ISPT_SEAT","ISPT_MAIN","ISPT_NPEN","ISPT_NVAL","ISPT_REP","ISPT_CAS","ISPT_WAT","ISPT_TYPE","ISPT_HAM","ISPT_ERAT","ISPT_SWP","ISPT_INC1","ISPT_INC2","ISPT_INC3","ISPT_INC4","ISPT_INC5","ISPT_INC6","ISPT_PEN1","ISPT_PEN2","ISPT_PEN3","ISPT_PEN4","ISPT_PEN5","ISPT_PEN6","ISPT_ROCK","ISPT_REM","ISPT_ENV","ISPT_METH","ISPT_CRED","TEST_STAT","FILE_FSET","ISPT_RL" "UNIT","","m","","","mm","","","m","m","","","%","mm","","","","","","","mm","mm","mm","mm","mm","mm","","","","","","","","m" "TYPE","ID","2DP","0DP","0DP","0DP","0DP","X","2DP","X","PA","X","0DP","0DP","0DP","0DP","0DP","0DP","0DP","0DP","0DP","0DP","0DP","0DP","0DP","0DP","YN","X","X","X","X","X","X","2DP" "DATA","BH01","1.20","10","12","450","12","N=12 (6,4/3,3,3,3)","","","S","","","","6","4","3","3","3","3","75","75","75","75","75","75","","","","","","","","" "DATA","BH01","2.00","6","17","450","17","N=17 (3,3/4,4,4,5)","","","S","","","","3","3","4","4","4","5","75","75","75","75","75","75","","","","","","","","" "DATA","BH01","3.00","6","22","450","22","N=22 (3,3/4,4,6,8)","","","S","","","","3","3","4","4","6","8","75","75","75","75","75","75","","","","","","","","" "DATA","BH01","4.00","19","46","450","46","N=46 (9,10/12,12,12,10)","","","S","","","","9","10","12","12","12","10","75","75","75","75","75","75","","","","","","","","" "DATA","BH01","5.00","75","","376","","0 (75 for 76mm/,,,)","","","S","","","","25","50","","","","","45","31","75","75","75","75","","","","","","","",""

"GROUP","LOCA" "HEADING","LOCA_ID","LOCA_TYPE","LOCA_STAT","LOCA_NATE","LOCA_NATN","LOCA_GREF","LOCA_GL","LOCA_REM","LOCA_FDEP","LOCA_STAR","LOCA_PURP","LOCA_TERM","LOCA_ENDD","LOCA_LETT","LOCA_LOCX","LOCA_LOCY","LOCA_LOCZ","LOCA_LREF","LOCA_DATM","LOCA_ETRV","LOCA_NTRV","LOCA_LTRV","LOCA_XTRL","LOCA_YTRL","LOCA_ZTRL","LOCA_LAT","LOCA_LON","LOCA_ELAT","LOCA_ELON","LOCA_LLZ","LOCA_LOCM","LOCA_LOCA","LOCA_CLST","LOCA_ALID","LOCA_OFFS","LOCA_CNGE","LOCA_TRAN","FILE_FSET","LOCA_CHKG","LOCA_APPG" "UNIT","","","","m","m","","m","","m","yyyy-mm-dd","","","yyyy-mm-dd","","m","m","m","","","m","m","m","m","m","m","","","","","","","","","","","","","","","" "TYPE","ID","PA","PA","2DP","2DP","PA","2DP","X","2DP","DT","X","X","DT","X","2DP","2DP","2DP","X","X","2DP","2DP","2DP","2DP","2DP","2DP","DMS","DMS","DMS","DMS","X","X","X","X","X","2DP","X","X","X","X","X" "DATA","BH01","CP","DRAFT","254239.65","391880.45","","214.45","","5.08","2019-11-04","","Refusal on hard strata","2019-11-04","","","","","","","","","","","","","","","","","","","","","","","","","","SM","AD"

"GROUP","SAMP" "HEADING","LOCA_ID","SAMP_TOP","SAMP_REF","SAMP_TYPE","SAMP_ID","SAMP_BASE","SAMP_DTIM","SAMP_UBLO","SAMP_CONT","SAMP_PREP","SAMP_SDIA","SAMP_WDEP","SAMP_RECV","SAMP_TECH","SAMP_MATX","SAMP_TYPC","SAMP_WHO","SAMP_WHY","SAMP_REM","SAMP_DESC","SAMP_DESD","SAMP_LOG","SAMP_COND","SAMP_CLSS","SAMP_BAR","SAMP_TEMP","SAMP_PRES","SAMP_FLOW","SAMP_ETIM","SAMP_DURN","SAMP_CAPT","SAMP_LINK","GEOL_STAT","FILE_FSET" "UNIT","","m","","","","m","yyyy-mm-ddThh:mm:ss","","","","mm","m","%","","","","","","","","yyyy-mm-dd","","","","bar","degC","bar","l/min","yyyy-mm-ddThh:mm:ss","hh:mm:ss","","","","" "TYPE","ID","2DP","X","PA","ID","2DP","DT","0DP","X","X","0DP","X","0DP","X","X","X","X","X","X","X","DT","X","X","X","1DP","0DP","1DP","1DP","DT","T","X","X","X","X" "DATA","BH01","5.00","10","B","","","","","","","","","","","","","","","","Bulk Sample","","","","","","","","","","","","","","" "DATA","BH01","0.80","6","B","","1.20","","","","","","","","","","","","","","Bulk Sample","","","","","","","","","","","","","","" "DATA","BH01","1.80","7","B","","2.20","","","","","","","","","","","","","","Bulk Sample","","","","","","","","","","","","","","" "DATA","BH01","2.80","8","B","","3.20","","","","","","","","","","","","","","Bulk Sample","","","","","","","","","","","","","","" "DATA","BH01","3.80","9","B","","4.20","2019-12-10T12:00:00","","","","","","","","","","","","","Bulk Sample","","","","","","","","","","","","","","" "DATA","BH01","0.50","1","D","","","","","","","","","","","","","","","","SPT","","","","","","","","","","","","","","" "DATA","BH01","1.50","2","D","","","","","","","","","","","","","","","","SPT","","","","","","","","","","","","","","" "DATA","BH01","2.50","3","D","","","","","","","","","","","","","","","","SPT","","","","","","","","","","","","","","" "DATA","BH01","3.50","4","D","","","","","","","","","","","","","","","","SPT","","","","","","","","","","","","","","" "DATA","BH01","4.50","5","D","","","","","","","","","","","","","","","","SPT","","","","","","","","","","","","","",""

"GROUP","SHBG" "HEADING","LOCA_ID","SAMP_TOP","SAMP_REF","SAMP_TYPE","SAMP_ID","SPEC_REF","SPEC_DPTH","SPEC_DESC","SPEC_PREP","SHBG_TYPE","SHBG_COND","SHBG_CONS","SHBG_PCOH","SHBG_PHI","SHBG_RCOH","SHBG_RPHI","SHBG_ENCA","SHBG_REM","SHBG_METH","SHBG_LAB","SHBG_CRED","TEST_STAT","FILE_FSET" "UNIT","","m","","","","","m","","","","","","kPa","deg","kPa","deg","","","","","","","" "TYPE","ID","2DP","X","PA","ID","X","2DP","X","X","PA","PA","X","2SF","1DP","2SF","1DP","X","X","X","X","X","X","X" "DATA","BH01","2.80","8","B","","1","2.80","Brownish grey slightly gravelly silty SAND.","Material tested passing 2mm sieve","SMALL SBOX","REMOULDED","Remoulded using hand tamped effort","9.0","33.0","","","","","BS1377:Part 7:1990 Clause 4","Professional Soils Laboratory Ltd","UKAS 4043","Approved","" "DATA","BH01","2.80","8","B","","2","2.80","","","SMALL SBOX","REMOULDED","Remoulded using hand tamped effort","9.0","33.0","","","","","BS1377:Part 7:1990 Clause 4","Professional Soils Laboratory Ltd","UKAS 4043","Approved","" "DATA","BH01","2.80","8","B","","3","2.80","","","SMALL SBOX","REMOULDED","Remoulded using hand tamped effort","9.0","33.0","","","","","BS1377:Part 7:1990 Clause 4","Professional Soils Laboratory Ltd","UKAS 4043","Approved",""

"GROUP","SHBT" "HEADING","LOCA_ID","SAMP_TOP","SAMP_REF","SAMP_TYPE","SAMP_ID","SPEC_REF","SPEC_DPTH","SHBT_TESN","SHBT_BDEN","SHBT_DDEN","SHBT_NORM","SHBT_DISP","SHBT_DISR","SHBT_REVS","SHBT_PEAK","SHBT_RES","SHBT_PDIS","SHBT_RDIS","SHBT_PDIN","SHBT_RDIN","SHBT_PDEN","SHBT_IVR","SHBT_MCI","SHBT_MCF","SHBT_DIA1","SHBT_DIA2","SHBT_HGT","SHBT_CRIT","SHBT_REM","FILE_FSET" "UNIT","","m","","","","","m","","Mg/m3","Mg/m3","kPa","mm/min","mm/min","","kPa","kPa","mm","mm","mm","mm","","","%","%","mm","mm","mm","","","" "TYPE","ID","2DP","X","PA","ID","X","2DP","X","2DP","2DP","0DP","2SF","2SF","0DP","1DP","1DP","2DP","2DP","2DP","2DP","XN","3DP","2DP","2DP","2DP","2DP","2DP","X","X","X" "DATA","BH01","2.80","8","B","","1","2.80","1","2.11","1.76","50","0.60","","","43.2","","4.00","","","","#2.65","0.506","20.00","18.00","59.97","59.97","20.05","","Reached end of travel","" "DATA","BH01","2.80","8","B","","2","2.80","2","2.11","1.75","100","0.60","","","76.4","","5.00","","","","#2.65","0.514","20.00","17.00","59.97","59.97","20.05","","Reached end of travel","" "DATA","BH01","2.80","8","B","","3","2.80","3","2.11","1.75","200","0.60","","","137.8","","5.00","","","","#2.65","0.514","20.00","17.00","59.97","59.97","20.05","","Reached end of travel",""

"GROUP","WADD" "HEADING","LOCA_ID","WADD_TOP","WADD_BASE","WADD_VOLM","WADD_METH","WADD_REM","FILE_FSET" "UNIT","","m","m","l","","","" "TYPE","ID","2DP","2DP","0DP","X","X","X" "DATA","BH01","1.20","5.00","","","",""

"GROUP","WSTG" "HEADING","LOCA_ID","WSTG_DPTH","WSTG_DTIM","WSTG_SEAL","WSTG_CAS","WSTG_REM","FILE_FSET" "UNIT","","m","yyyy-mm-ddThh:mm:ss","m","m","","" "TYPE","ID","2DP","DT","2DP","2DP","X","X" "DATA","BH01","","","","","DRY",""