News for hackers. Stuff that matters.

A comment on SpatiaLite: Extends SQLite core to support Spatial SQL capabilities. Parent comment

Re:SpatiaLite: Extends SQLite core to support Spatial SQL ca... by zipzappy on Friday July 22, 2022 @04:49PM (#32196956)
Does this do spatial queries? It doesn’t seem so.
[ Parent | on HN ]
Re:SpatiaLite: Extends SQLite core to support Spatial SQL ca... by fortysixdegrees on Friday July 22, 2022 @11:36PM (#32200079)
Yes, it does.

See the extensive list of spatial query operators here: http://www.gaia-gis.it/gaia-sins/spatialite-sql-4.2.0.html

[ Parent | on HN ]
Re:SpatiaLite: Extends SQLite core to support Spatial SQL ca... by dvisca on Friday July 22, 2022 @05:08PM (#32197138)
No, 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.
[ Parent | on HN ]
Re:SpatiaLite: Extends SQLite core to support Spatial SQL ca... by fortysixdegrees on Friday July 22, 2022 @11:37PM (#32200089)
I 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
[ Parent | on HN ]
Re:SpatiaLite: Extends SQLite core to support Spatial SQL ca... by dvisca on Saturday July 23, 2022 @02:35AM (#32200949)
But 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.
[ Parent | on HN ]