gi.ags.transform.ags3_db_to_no_gis_brgi_db

gi.ags.transform.ags3_db_to_no_gis_brgi_db(ags3_db, crs)

Maps a database with GI data from a single AGS 3 file to a database with Bedrock’s schema.

This function converts an AGS 3 formatted geotechnical database into Bedrock’s internal database format, maintaining data relationships and structure. It handles various types of geotechnical data including project information, locations, samples, lab tests, and in-situ measurements.

The mapping process: 1. Project Data: Converts AGS 3 ‘PROJ’ group to Bedrock’s ‘Project’ table 2. Location Data: Converts AGS 3 ‘HOLE’ group to Bedrock’s ‘Location’ table 3. Sample Data: Converts AGS 3 ‘SAMP’ group to Bedrock’s ‘Sample’ table 4. Other Data: Handles lab tests, in-situ measurements, and miscellaneous tables

Parameters

Name	Type	Description	Default
ags3_db	Dict[str, pd.DataFrame]	A dictionary containing AGS 3 data tables, where keys are table names and values are pandas DataFrames.	required
crs	CRS	Coordinate Reference System for the project data.	required

Returns

Name	Type	Description
	Dict[str, pd.DataFrame]	Dict[str, pd.DataFrame]: A dictionary containing Bedrock GI database tables,
	Dict[str, pd.DataFrame]	where keys are table names and values are transformed pandas DataFrames.

Note

The function creates a copy of the input database to avoid modifying the original data. It performs foreign key checks to maintain data integrity during the mapping.