get_NASIS_table_metadata: Get NASIS Table Metadata (Table and Column Descriptions)

In soilDB: Soil Database Interface

Get NASIS Table Metadata (Table and Column Descriptions)

Description

Retrieve a table containing table and column names with descriptions, help text, units of measure, etc. from NASIS 7 metadata tables.

Usage

get_NASIS_table_metadata(
  table = NULL,
  column = NULL,
  what.table = "TablePhysicalName",
  what.column = "ColumnPhysicalName",
  query_string = FALSE,
  dsn = NULL
)

Arguments

table	Character vector of table identifiers to match. Default NULL for "all tables" (no constraint)
column	Character vector of column identifiers to match. Default NULL for "all columns" (in selected tables, if any, otherwise no constraint)
what.table	Column to match table against. Default: TablePhysicalName.
what.column	Column to match column against. Default: ColumnPhysicalName.
query_string	Default: FALSE; if TRUE return a character containing query that would be sent to NASIS.
dsn	Optional: path to local SQLite database containing NASIS table structure; default: NULL

Details

These data are derived from the MetadataTable and MetadataTableColumn tables and describe the expected contents of standard NASIS tables and columns.

For NASIS choice lists based on domain and column names see get_NASIS_metadata() and NASISChoiceList(). This function (get_NASIS_table_metadata()) is intended for higher-level description of the expected contents of a NASIS database instance, rather than the codes/specific values used within columns.

Value

a data.frame

See Also

get_NASIS_metadata() NASISChoiceList() uncode() code()

Examples

if (local_NASIS_defined())
 str(get_NASIS_table_metadata())

soilDB documentation built on Sept. 11, 2024, 8:28 p.m.