The hardware and bandwidth for this mirror is donated by METANET, the Webhosting and Full Service-Cloud Provider.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]metanet.ch.
Added gpkg_create_spatial_view() for creating spatial views, which are dynamic layers accessible as if they were typical static geometry layers (for #6).
gpkg_write() now properly writing attributes from a data.frame source (which is not nested in a list) when table_name argument is
gpkg_tables() better handling for terra::vect() failures with non-spatial table function fallback.
gpkg_write() now can handle SpatVectorProxy input by querying it. Note this will not work for data that will not fit in memory. May try to implement an ogr2ogr-like interface for this in the future (#15).
gpkg_bbox() as an application of gpkg_ogr_query()geopackage() internal connection object has been moved to an internal environment (<geopackage>$env$con rather than <geopackage>$con)
gpkg_connect() allows for in-place modification of an existing object for the purposes of creating an internal SQLiteConnection
Improvement to gpkg_add_contents() and gpkg_update_contents(): more intelligent choice of data type when heterogeneous (non-attribute) data are in database but not registered. Fix for broken tests on Windows/GDAL 3.5.2.
Fixed bug in gpkg_tables() when multiple attribute tables were present.
Added gpkg_ogr_query() (and ogr argument to gpkg_query()) to support querying OGR data sources using a ‘terra’ SpatVectorProxy back end. This allows for use of GeoPackage-specific SQL functions and the OGR/SQLite dialects: https://gdal.org/user/sql_sqlite_dialect.html and https://gdal.org/user/ogr_sql_dialect.html; requires latest ‘terra’ (1.7-33+)
Added gpkg_rast() (analog of gpkg_vect() for terra::rast()) for lazy manipulation of gridded data in a GeoPackage
Added gpkg_create_dummy_features() which is a workaround for use of gpkg_vect() on a GeoPackage with only attribute data. This creates innocuous entries in gpkg_geometry_columns and an empty table to “trick” GDAL into reading arbitrary data sources.
Added gpkg_list_contents() and gpkg_ogr_contents(); the former returns only table names registered in gpkg_contents table, which are optionally intersected with tables defined in gpkg_ogr_contents when ogr=TRUE.
Fixed bug in .gpkg_gdaloptions_add() that could cause addition of options with no value set
Added gpkg_vect(): a terra::vect()-based analog of gpkg_table() for lazy manipulation of vector and attribute data in a GeoPackage
gpkg_update_table() defaults to wherecol=NULL which allows updating rows with no SQL WHERE clause specified
Refactoring table accessor methods (https://github.com/brownag/gpkg/issues/2)
Renamed lazy.frame() -> gpkg_table_pragma()
Renamed dplyr.frame() -> gpkg_table()
gpkg_table() gains collect argument (toggles materializing data.frame v.s. ‘dbplyr’ approach). collect requires only ‘RSQLite’ not ‘dbplyr’.
gpkg_tables() gains pragma argument to toggle use of gpkg_table_pragma() over gpkg_table(). It also supports collect argument.
gpkg_update_table() is now exported; this method is/was used internally for updating the NoData entry for existing layers via gpkg_tile_set_data_null()
Updated definitions of lazy.frame() and dplyr.frame() and related docs
Updated gpkg_write() for raster, vector, and attribute data
General cleanup and refactored approach for splitting input data sources between attributes, vector, and tiled grid coverage.
New approach still contains hard-coded logic related to the allowed object types and file data sources (that will be generalized in the future)
RASTER_TABLE name is now properly injected into GDAL options from named list input (when not otherwise specified)
Bug fix in geopackage(<list>) related to appending v.s. overwriting raster data
gpkg_update_contents(): Handle gpkgext_ and sqlite_sequence as standard GPKG table prefixes
Added {dbplyr} backend option to return tibble object via geopackage object internal SQLiteConnection
Changed formatting of PRAGMA table_info child data.frame in lazy.frame() result
These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.