===================== Installing SpatiaLite ===================== `SpatiaLite`__ adds spatial support to SQLite, turning it into a full-featured spatial database. First, check if you can install SpatiaLite from system packages or binaries. For example, on Debian-based distributions that package SpatiaLite 4.3+, try to install the ``libsqlite3-mod-spatialite`` package. For older releases install ``spatialite-bin``. For macOS, follow the :ref:`instructions below`. For Windows, you may find binaries on the `Gaia-SINS`__ home page. In any case, you should always be able to :ref:`install from source `. __ https://www.gaia-gis.it/fossil/libspatialite/index __ https://www.gaia-gis.it/gaia-sins/ .. _spatialite_source: Installing from source ====================== :doc:`GEOS and PROJ` should be installed prior to building SpatiaLite. SQLite ------ Check first if SQLite is compiled with the `R*Tree module`__. Run the sqlite3 command line interface and enter the following query: .. code-block:: sqlite3 sqlite> CREATE VIRTUAL TABLE testrtree USING rtree(id,minX,maxX,minY,maxY); If you obtain an error, you will have to recompile SQLite from source. Otherwise, skip this section. To install from sources, download the latest amalgamation source archive from the `SQLite download page`__, and extract: .. code-block:: shell $ wget https://www.sqlite.org/YYYY/sqlite-amalgamation-XXX0000.zip $ unzip sqlite-amalgamation-XXX0000.zip $ cd sqlite-amalgamation-XXX0000 Next, run the ``configure`` script -- however the ``CFLAGS`` environment variable needs to be customized so that SQLite knows to build the R*Tree module: .. code-block:: shell $ CFLAGS="-DSQLITE_ENABLE_RTREE=1" ./configure $ make $ sudo make install $ cd .. __ https://www.sqlite.org/rtree.html __ https://www.sqlite.org/download.html .. _spatialitebuild: SpatiaLite library (``libspatialite``) -------------------------------------- Get the latest SpatiaLite library source bundle from the `download page`__: .. code-block:: shell $ wget https://www.gaia-gis.it/gaia-sins/libspatialite-sources/libspatialite-X.Y.Z.tar.gz $ tar xaf libspatialite-X.Y.Z.tar.gz $ cd libspatialite-X.Y.Z $ ./configure $ make $ sudo make install .. note:: For macOS users building from source, the SpatiaLite library *and* tools need to have their ``target`` configured: .. code-block:: shell $ ./configure --target=macosx __ https://www.gaia-gis.it/gaia-sins/libspatialite-sources/ .. _spatialite_macos: macOS-specific instructions ============================== To install the SpatiaLite library and tools, macOS users can use `Homebrew`_. Homebrew -------- `Homebrew`_ handles all the SpatiaLite related packages on your behalf, including SQLite, SpatiaLite, PROJ, and GEOS. Install them like this: .. code-block:: shell $ brew update $ brew install spatialite-tools $ brew install gdal Finally, for GeoDjango to be able to find the SpatiaLite library, add the following to your ``settings.py``:: SPATIALITE_LIBRARY_PATH = "/usr/local/lib/mod_spatialite.dylib" .. _Homebrew: https://brew.sh/