SpatiaLite

Note

GeoServer does not come built-in with support for SpatiaLite; it must be installed through an extension. Furthermore it requires that additional native libraries be available on the system. Proceed to Installing the SpatiaLite extension for installation details.

SpatiaLite is the spatial extension of the popular SQLite embedded relational database.

Installing the SpatiaLite extension

  1. Download the SpatiaLite extension from the nightly GeoServer community module builds.

    Warning

    Make sure to match the version of the extension to the version of the GeoServer instance!

  2. Extract the contents of the archive into the WEB-INF/lib directory of the GeoServer installation.

Notes about shared libraries

The version of SpatiaLite included in the extension is compiled against the GEOS and PROJ libraries so they must be installed on the system. If the libraries are not installed on the system the extension will cease to function.

If the libraries are not installed on your system in a “default” location you must set the LD_LIBRARY_PATH (or equivalent) environment variable in order to load them at runtime.

Note

On Windows systems it is easiest to place the GEOS and PROJ dll’s in the C:\WINDOWS\system32 directory.

Adding a SpatiaLite database

Once the extension is properly installed SpatiaLite will show up as an option when creating a new data store.

../../_images/spatialitecreate.png

SpatiaLite in the list of vector data sources

Configuring a SpatiaLite data store

../../_images/spatialiteconfigure.jpg

Configuring a SpatiaLite data store

database The name of the database to connect to. See notes below.
schema The database schema to access tables from. Optional.
user The name of the user to connect to the database as. Optional.
password The password to use when connecting to the database. Optional, leave blank for no password.

max connections

min connections

Connection pool configuration parameters. See the Database Connection Pooling section for details.

The database parameter may be specified as an absolute path or a relative one. When specified as a relative path the database will created in the spatialite directory, located directly under the root of the GeoServer data directory.