4 ms·
I prefer the GeoPackage format [1]. Very similar to SpatiaLite it is based on SQLite, but as official OGC standard I anticipate better integration and support i
by dvisca 4y ago
I prefer the GeoPackage format [1]. Very similar to SpatiaLite it is based on SQLite, but as official OGC standard I anticipate better integration and support in the long run.
[1]: https://www.geopackage.org/ https://www.geopackage.org/
- clumsysmurf 4y agoIs there anything like this for time-series sensor data (temperature, humidity, etc)?
- dvisca 4y agoThere is the OGC SensorThings API spec for accessing sensor data. For storage I would assume something like GeoPackage or SpatiaLite would be sufficient.
- sideshowb 4y agoGeopandas adds gis operations to pandas, which is good with time series, if that helps. Can read and write several common formats.
- zipzappy 4y agoDoes this do spatial queries? It doesn’t seem so.
- dvisca 4y agoNo, it doesn't. It is designed as lightweight format for data storage and exchange. Usually it is used in the context of other GIS applications like QGIS. However, you can also use SpatiaLite to apply spatial functions to GeoPackage files.
- fortysixdegrees 4y agoI feel you should retract this comment so as to not mislead people. See extensive spatialite documentation on spatial operators here: http://www.gaia-gis.it/gaia-sins/spatialite-sql-4.2.0.html http://www.gaia-gis.it/gaia-sins/spatialite-sql-4.2.0.html
- dvisca 4y agoBut GeoPackage, which the question referred to, does not support spatial functions in and of itself. But I also wrote that you can use e.g. SpatiaLite to apply spatial functions to geometries stored in GeoPackage. But then this is not really different from using any other application like QGIS or gdal.
- fortysixdegrees 4y agoYes, it does. See the extensive list of spatial query operators here: http://www.gaia-gis.it/gaia-sins/spatialite-sql-4.2.0.html http://www.gaia-gis.it/gaia-sins/spatialite-sql-4.2.0.html
- deleted 4y ago[deleted]
- zdkl 4y ago> GeoPackage is supported in SpatiaLite as of version 4.2.0. https://www.geopackage.org/implementations.html https://www.geopackage.org/implementations.html https://www.gaia-gis.it/fossil/libspatialite/wiki?name=4.2.0+functions#8 https://www.gaia-gis.it/fossil/libspatialite/wiki?name=4.2.0...