Page Comparison

The "geometryless" spatial engine is intended to add support for database tables that have am an 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.20121129.jarThe driver tries to expose every table in the database that it's pointed to as a spatially enabled table.

Name	Type	Required	Default	Description
dbtype	String	yes

must

Must be 'locationsxy'
driver	String	yes		Java Class name of an installed

ConectionPool

JDBC driver
urlprefix	String	yes

complete jdbc

Complete JDBC URL for the database connection
user	String	yes	Username to connect to the database
passwd	String	yes	Password to connect to the database
xcolumn	String

no

yes

'longitude'

name

Name of JDBC results column containing easting (x, longitude etc)
ycolumn	String

no

yes

'latitude'

name the name

Name of JDBC results column containing northing (y, latitude etc)
geom_name	String

no

'the_geom'

yes

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

. This is a virtual column that will be added to each table and will be a Point that is made from the values in xcolumn and ycolumn. The value used here doesn't have any external effects, it just provides the name of the column that will be created. examples are "shape" or "the_geom" or just "geom"
schema	String	no	none

database

Database schema
charset	String	no	none	Database character set

namespace

crs

String

no

none

namespace prefix used

A default CRS to use for the data contained within the tables

Code Block

	xml
	xml
title	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>
	<user>gis</user>
	<passwd>ENCSSJKXUMJBMTPGEJFGJZJ</passwd>
	<xcolumn>x</xcolumn>
	<ycolumn>y</ycolumn>
	<geom_name>shape</geom_name>
	<user>gis</user>
	<passwd>ENCSSJKXUMJBMTPGEJFGJZJ</passwd><crs>EPSG:28355</crs>
	<primarykeymetadata>
		<table name="WkALR" column="fid"/>
		<table name="WkPRN" column="fid"/>
	</primarykeymetadata>
</spatial:spatialengine>

<Edit>

Versions Compared

Old Version 2

New Version Current

Key