soilDB 2.7.7

soilDB 2.7.7 (2023-03-10)

Enhancements

• fetchNASIS(from="pedons") and get_site_data_from_NASIS_db() now return siteobsiid column (@natearoe)

• mukey.wcs() gains experimental gridded STATSGO layer (300m)

• Add get_NASIS_table_metadata() for returning information about columns in NASIS tables.

• simplifyFragment/ArtifactData(): downgrade warnings

• get_cosoilmoist_from_SDA(): mukey and cokey now included when duplicates=TRUE; thanks to @andypaolucci for catching this

• fetchSoilGrids()

  • Add SpatVector coercion for input locations (already supported sf/sp classes)

  • Add handling for messages from API about erroneous input

• Add fetchNASIS("pedons") columns vignette

• Add get_NASIS_table_metadata() and optional argument include_description for get_NASIS_metadata() and get_NASIS_column_metadata()

• get_SDA_cosurfmorph() + get_SDA_pmgroupname(): support for including or excluding misc. areas via miscellaneous_areas argument

• get_site_data_from_NASIS_db():

  • Omit "multiple horizontal datums" warning

  • Remove calculated X/Y long/lat + add proper NASIS alias for long/lat

  • Add siteothvegclass id/name - add tables to default lookup/site sets

Bug fixes

• dbQueryNASIS(..., close=TRUE) now calls dbDisconnect() on.exit() (ensuring connections get closed on error)

• fetchSCAN():

  • 2x requests when timeseries argument not specified

  • Account for no results (e.g. year = 1800)

  • Bug fix in vectorization when daily + hourly data requested

• downloadSSURGO():

  • Handle SDA_query() with invalid syntax in WHERE clause

  • Fix for include_template=FALSE

• createSSURGO()

  • Attribute tables are now added to gpkg_contents when output filename is a GeoPackage

• Fix for .get_comonth_from_SDA()

• Fix selected set (SS argument) for get_ecosite_history_from_NASIS_db() in get_site_data_from_NASIS_db()

• get_SDA_pmgroupname: return NA (not "NULL") for empty/missing pmgroupname when simplify=TRUE

• SDA_spatialQuery():

  • geomIntersection=TRUE with db="SAPOLYGON" now correctly labels the areasymbol column (previously was mukey) to match geomIntersection=FALSE and SDA schema

  • Bounding box extent polygons are now only calculated for SpatRaster (not SpatVector) input

What's Changed

• get_site_data_from_NASIS_db: Add siteothvegclass id/name by @brownag in #280
• Improving support for get_SDA*() component filters by @brownag in #259
• Table and Column Metadata by @brownag in #278
• Add get_ecosite_history_from_NASIS_db() by @brownag in #281
• createSSURGO: add minimal gpkg_contents entries for attribute tables by @brownag in #283

Full Changelog: 2.7.6...2.7.7