<dependency>
<groupId>org.geotools.jdbc</groupId>
<artifactId>gt-jdbc-postgis</artifactId>
<version>${geotools.version}</version>
</dependency>
Note that the groupId
is org.geotools.jdbc
for this and other JDBC plugin modules.
Connection Parameters
Parameter
Description
dbtype
Must be the string postgis
Machine name or IP address to connect to
Port number to connect to, default 5432
schema
The database schema to access
database
The database to connect to
User name
passwd
Password
preparedStatements
encode functions
Creation
Connect using DataStore finder:
Map<String, Object> params = new HashMap<>();
params.put("dbtype", "postgis");
params.put("host", "localhost");
params.put("port", 5432);
params.put("schema", "public");
params.put("database", "database");
params.put("user", "postgres");
params.put("passwd", "postgres");
params.put("preparedStatements", true);
params.put("encode functions", true);
DataStore dataStore = DataStoreFinder.getDataStore(params);
Configuration Flags
An optimization on spatial queries can be applied, to avoid a bug with PostGIS query planner with big geometries and small bounding boxes, setting a system property.
This optimization can be enabled using a system-wide default from the command line:
java -Dorg.geotools.data.postgis.largeGeometriesOptimize=true