pg_insert_observations: Insert plots and samples in PostgreSQL
In kamapu/vegtables2: Handling Vegetation Data Sets (Advanced Features)

Plots and records of species in the plots will be jointly inserted in a PostgreSQL database, whereby a series of checks will be carried out previous to insert the data.

This function carry out a series of checks on the input data previous to import them in the database (if not errored). The variable 'original_number' will be used for cross-check identities of entries in samples and in header. Connection to taxa via 'TaxonUsageID'.

pg_insert_observations(conn, ...)

## S3 method for class 'PostgreSQLConnection'
pg_insert_observations(
  conn,
  samples,
  header,
  names2concepts,
  db_samples,
  db_header,
  geom,
  ...
)

`conn`	A database connection provided by `dbConnect`.
`...`	Further arguments (not yet in use).
`samples`	A data frame including records of species in plots. Columns 'ReleveID' and 'TaxonUsageID' are mandatory in this object.
`header`	An object of class sp::SpatialPointsDataFrame including the information on the plots. In the attribute table the columns 'ReleveID' and 'original_number' are mandatory.
`names2concepts, db_samples, db_header`	Character vectors including the name of the respective schema and table in database.
`geom`	Character value indicating the name of the geometry variable in the database.