Function reference

AGS

Read, transform & validate AGS Files

gi.ags.read.ags_to_dfs Converts AGS 3 or AGS 4 data to a dictionary of pandas DataFrames.
gi.ags.read.ags3_to_dfs Converts AGS 3 data to a dictionary of pandas DataFrames.
gi.ags.read.ags4_to_dfs Converts AGS 4 data to a dictionary of pandas DataFrames.
gi.ags.transform.ags3_db_to_no_gis_brgi_db Maps a database with GI data from a single AGS 3 file to a database with Bedrock’s schema.
gi.ags.transform.ags_proj_to_brgi_project Maps the AGS 3 ‘PROJ’ group to a Bedrock GI ‘Project’ table.
gi.ags.validate.check_ags_proj_group Checks if the AGS 3 or AGS 4 PROJ group is correct.

Validate

Validate Bedrock GI databases

gi.validate.check_brgi_database Validates the structure and relationships of a ‘Bedrock Ground Investigation’ (BRGI) database (which is a dictionary of DataFrames).
gi.validate.check_no_gis_brgi_database Validates the structure and relationships of a ‘Bedrock Ground Investigation’ (BGI) database without GIS geometry.
gi.validate.check_foreign_key Validates referential integrity between two tables by checking foreign key relationships.

Write

Write Bedrock GI databases to different file formats

gi.write.write_gi_db_to_gpkg Writes a database with Bedrock Ground Investigation data to a GeoPackage file.
gi.write.write_gi_db_to_excel Writes a database with Ground Investigation data to an Excel file.
gi.write.sanitize_table_name Replaces invalid characters and spaces in GI table names with underscores and truncates to 31 characters.

Concatenate

gi.concatenate.concatenate_databases Concatenates two dictionaries of DataFrames into one dict of DataFrames.

GIS Geometry

Calculate GIS Geometry for Bedrock GI databases and GI locations

gi.gis_geometry.calculate_gis_geometry Calculates GIS geometry for tables in a Bedrock Ground Investigation database.
gi.gis_geometry.calculate_location_gis_geometry Calculates GIS geometry for a set of Ground Investigation locations.
gi.gis_geometry.calculate_wgs84_coordinates Transforms coordinates from an arbitrary Coordinate Reference System (CRS) to the WGS84 CRS, which is the standard for geodetic coordinates.
gi.gis_geometry.create_lon_lat_height_table Creates a GeoDataFrame with GI locations in WGS84 (lon, lat, height) coordinates.
gi.gis_geometry.calculate_in_situ_gis_geometry Calculates GIS geometry for a set of Ground Investigation in-situ data.