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. |