AGS data in GIS
Bring ground investigation data in the AGS4 format into GIS. The series reads and validates AGS4 files in Python, maps the boreholes in QGIS, draws 3D borehole logs, builds geological cross-sections and ground-model surfaces, analyses SPT N-values, and 3D prints the geological ground model. It then charts and maps laboratory classification tests, follows groundwater through standpipe monitoring, interprets cone penetration tests, screens contaminated land chemistry against published values, publishes the ground model on the web as glTF and 3D Tiles, and turns legacy borehole logs into valid AGS4.
- Intermediate to Advanced
- 7 of 13 published
- About 83 minutes so far
Start with part 1: Read and validate AGS4 ground investigation data with Python
The parts, in order
-
Read and validate AGS4 ground investigation data with Python
Find a real ground investigation in the British Geological Survey's AGS archive, download it as AGS4, learn how the file is put together, read it into pandas with python-ags4, fix every error the AGS checker reports, and check that the borehole logs make geological sense. The example is the A417 Missing Link at Crickley Hill.
-
Boreholes on a map: AGS4 locations in British National Grid with QGIS
Turn the LOCA group of a real AGS4 file into points in British National Grid, see what happens when the CRS is wrong, summarise each hole's geology from GEOL, check every ground level against Environment Agency LIDAR, and build a QGIS project with labels and a map tip that shows the borehole log.
-
3D borehole logs from AGS4 data in PyVista and QGIS
Build every borehole log in a real AGS4 file as coloured 3D cylinders at their true elevation under Environment Agency LIDAR terrain with PyVista, then style the same intervals in the QGIS 3D map view. Along the way, test whether neighbouring logs agree, and find a block of ground at the top of Crickley Hill where they don't.
-
A geological cross-section from AGS4 boreholes and LIDAR in Python and QGIS
Draw a 3.2 km geological cross-section up the Cotswold escarpment from real AGS4 borehole logs, with the ground profile from Environment Agency LIDAR. Project every hole in a corridor onto the line, pick and correlate the contacts, and measure how much of each correlation line rests on a log and how much is inferred. Then draw the same section with the QGIS elevation profile.
-
A 3D ground model from AGS4 boreholes: kriged stratum surfaces in Python
Pick rockhead and the top and base of the key formations from real AGS4 logs, krige them into stratum surfaces under Environment Agency LIDAR ground, and build a 3D ground model of the A417 escarpment in PyVista. Then test it: leave-one-out cross-validation at every borehole, kriging standard deviation maps, a check against every hole that stops short of a surface, and proof that no surface crosses another.
-
Visualising SPT N-values from AGS4 data in Python
Read the Standard Penetration Tests (ISPT) from a real AGS4 file, separate full tests from refusals, find the stratum each test was made in, and show the N-values four ways: by unit against elevation, across the base of a landslide, as coloured discs on 3D borehole logs over LIDAR terrain, and as a map of the depth to the first refusal.
-
3D-print a geological ground model: one watertight STL per stratum
Turn the kriged stratum surfaces from Part 5 into a multi-material 3D print of the Cotswold escarpment at Crickley Hill. Cut a window, decide what is too thin to print, build one solid per unit with mesh booleans, prove the parts fit exactly and are watertight, and write five STLs and a colour 3MF for AMS and MMU printers.
-
Laboratory classification data from AGS4: plasticity charts, grading curves and maps in Python
-
Groundwater monitoring from AGS4: hydrographs, groundwater level maps and the QGIS Temporal Controller
-
CPT data from AGS4 in Python: soil behaviour type, boreholes and maps
-
Contaminated land chemistry from AGS4 in Python: screening values and maps
-
A geological ground model on the web: glTF, 3D Tiles and a three.js viewer
-
From legacy borehole logs to valid AGS4 in Python: clean, validate and map
A new part is published each week. Follow the TechnicalGIS RSS feed to hear when the next one is out.