添加链接
link管理
链接快照平台
  • 输入网页链接,自动生成快照
  • 标签化管理网页链接

Related

  • http://www.foss4g2007.org/workshops/W-04/ PostGIS workshop if you need an introduction to setting up PostGIS

  • Maven

    <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