db_check_childless_metadata: Check for any records in metadata tables with no associated...

In mbedward/CERMBlidarpostgis: Store and retrieve processed LIDAR data from a PostGIS database

Description

Each record in a point_counts table, which contains rasters of point counts for vertical strata, is linked to a parent record in the las_metadata table within the same schema (e.g. 'mgazone56') via the relation point_counts.meta_id = las_metadata.id. The database will not allow a point counts record without an associated metadata record, but it will allow a metadata record without any point counts records. Usually, this will indicate that some problem occurred during import. This function checks for any such childless metadata records.

Usage

db_check_childless_metadata(dbsettings, schema = NULL)

Arguments

dbsettings	A named list of database connection settings returned by db_connect_postgis or db_create_postgis.
schema	A character vector giving the names of one or more schemas (e.g. "mgazone56") to check. If NULL (default), all schemas are checked.

Value

A data frame. If childless meta-data records were found, the schema, integer id and filename will be listed for each. If no such records were found the data frame will have zero rows and columns.

mbedward/CERMBlidarpostgis documentation built on Nov. 14, 2021, 7:15 p.m.