Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

The "geometryless" spatial engine is intended to add support for database tables that have am x and y location.

The driver emulates a spatially enabled table by generating point geometry on the fly based on the values in the x and y columns in the underlying tables.

org.geotools.geometryless_2.6.6.20130909.jar

Name

Type

Required

Default

Description

dbtype

String

yes

 

must be 'locationsxy'

driver

String

yes

 

Java Class name of installed ConectionPool JDBC driver

urlprefix

String

yes

 

complete jdbc URL for the database connection

xcolumn

String

no

'longitude'

name of JDBC results column containing easting (x, longitude etc)

ycolumn

String

no

'latitude'

name of JDBC results column containing northing (y, latitude etc)

geom_name

String

no

'the_geom'

the name of the geometry attribute generated from the x,y columns

user

String

yes

 

user name to login as

passwd

String

yes

 

password used to login

schema

String

no

none

database schema

charset

String

no

none

character set

namespace

String

no

none

namespace prefix used

Example
<spatial:spatialengine id="test">
	<dbtype>locationsxy</dbtype>
	<driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver>
	<urlprefix><![CDATA[jdbc:sqlserver://sqlserver2008;instanceName=SQLEXPRESS;databaseName=GIS]]></urlprefix>
	<xcolumn>x</xcolumn>
	<ycolumn>y</ycolumn>
	<geom_name>shape</geom_name>
	<user>gis</user>
	<passwd>ENCSSJKXUMJBMTPGEJFGJZJ</passwd>
</spatial:spatialengine>
  • No labels