[HN Gopher] SpatiaLite: Extends SQLite core to support Spatial S...
___________________________________________________________________
SpatiaLite: Extends SQLite core to support Spatial SQL capabilities
Author : thunderbong
Score : 121 points
Date : 2022-07-22 18:34 UTC (4 hours ago)
(HTM) web link (www.gaia-gis.it)
(TXT) w3m dump (www.gaia-gis.it)
| yread wrote:
| There is also a JS port
|
| https://github.com/jvail/spl.js
| mdp2021 wrote:
| > _Using SQLite + SpatiaLite you can effectively deploy an
| alternative open source Spatial DBMS roughly equivalent to
| PostgreSQL + PostGIS_
|
| Any info on performance differences?
| [deleted]
| brandmeyer wrote:
| I have to disagree with the "roughly equivalent" statement. Its
| missing core functionality relative to PostGIS. For example,
| the Geography type and associated operators (which is
| functionally distinct from Geometry) is completely absent.
| zipzappy wrote:
| It's not actively developed. The nearest neighbor functionality
| in the released version is deprecated and both it and the
| development replacement have a recently filed bug that makes you
| worry about accuracy. The docs are also out of date
| infogulch wrote:
| Paraphrased from the docs [1]:
|
| > SpatiaLite is smoothly integrated into SQLite to provide a
| complete and powerful Spatial DBMS (mostly OGC-SFS compliant).
| Using SQLite + SpatiaLite you can effectively deploy an
| alternative open source Spatial DBMS roughly equivalent to
| PostgreSQL + PostGIS. The difference between them is mainly
| architecture: PostgreSQL + PostGIS uses a client/server
| architecture suitable for sophisticated Spatial Data
| infrastructures at the cost of complexity; SQLite + SpatiaLite
| has much simpler architecture more appropriate for desktop,
| stand-alone, and personal activities.
|
| > SpatiaLite supports direct SQL access to several commonly used
| external datasources: ESRI Shapefiles, DBF Archive Files,
| TXT/CSV/XLS ...
|
| > SpatiaLite actively supports many alternative standard Geometry
| notations: WKT [Well Known Text] and WKB [Well Known Binary],
| PostGIS own EWKT and EWKB [Extended WKT / WKB], GML [Geography
| Markup Language], KML [Keyhole Markup Language, used by Google
| Maps and Google Earth], GeoJSON [Geometry Java Script Object
| Notation], SVG [Scalable Vector Graphics].
|
| [1]: https://www.gaia-gis.it/gaia-sins/splite-
| doxy-5.0.1/index.ht...
| [deleted]
| dvisca wrote:
| 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/
| zdkl wrote:
| > GeoPackage is supported in SpatiaLite as of version 4.2.0.
|
| https://www.geopackage.org/implementations.html
|
| https://www.gaia-gis.it/fossil/libspatialite/wiki?name=4.2.0...
| clumsysmurf wrote:
| Is there anything like this for time-series sensor data
| (temperature, humidity, etc)?
| dvisca wrote:
| There is the OGC SensorThings API spec for accessing sensor
| data. For storage I would assume something like GeoPackage or
| SpatiaLite would be sufficient.
| sideshowb wrote:
| Geopandas adds gis operations to pandas, which is good with
| time series, if that helps. Can read and write several common
| formats.
| zipzappy wrote:
| Does this do spatial queries? It doesn't seem so.
| dvisca wrote:
| 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.
| qwertox wrote:
| Apparently it's also trivial to use it in Python via `pip install
| spatialite`[1], but the GitHub repo [2] seems to be dead.
|
| [1] https://pypi.org/project/spatialite/
|
| [2] https://github.com/malexer/spatialite
| zipzappy wrote:
| No you need the library installed separately
___________________________________________________________________
(page generated 2022-07-22 23:00 UTC)