Welcome to Voyager Help

Use the Search field below or select a Category from the list at the left

Indexing Records with Geometry from a Spatial Database (PostGIS)

Voyager Search can index records' geometries from databases,such as Oracle Spatial, MSSQL, SDE and PostgreSQL/PostGIS, that support spatial content and operations. However in some cases, notably PostGIS, geometries are not extracted as geometric objects from the database, but you can use the database's native spatial functions to convert them in to a Well-Known-Text (WKT) geometry which Voyager can use to interpret location and shape.

To index Records with Geometry from a Spatial Database (PostGIS):

  1. Go to Manage Voyager > Discovery > Locations > Add Location and select the SQL tab. 
  2. Select PostgreSQL and create a JDBC connection

  3. Note the default query absorbs the geometry column as a pure string

  4. The geometry is captured as a WKT geometry, but not represented with any spatial context in Voyager Search results

  5. Use the PostGIS function
    to transform the geometric string into a WKT (Well-Known Text) representation of the geometry

  6. Save the Location settings, clear and rebuild the index

  7. The PostGIS search results will include a BBOX and will be displayed on the map.
Web Design and Web Development by Buildable