Hi Andrea,
In our current Mapserver environment we're using the OGR library to pull the
data from the table. In it's data source definition we identify the column
that has the geometry. I was hoping there would be something similar for
GeoServer, but it seems not.
We're not performing any geometry calculations on the data, it's purely for
display on top of a bunch of other maps via OpenLayers.
Cheers,
Neil.
________________________________
From: andrea.a...@gmail.com on behalf of Andrea Aime
Sent: Tue 8/02/2011 6:41 PM
To: Neil Mercer
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] Best way to incorporate WKT feature data
On Tue, Feb 8, 2011 at 6:29 AM, Neil Mercer
<neil.mer...@douglaspartners.com.au> wrote:
> Hi,
>
>
>
> I have a database of feature information held in SQL Server 2005. The
> spatial information is all stored in WKT format. Previously we have been
> using MapServer to make this information available via WMS, but now would
> like to explore GeoServer's capabilities. Can anyone suggest the best way
> to make this information available? Upgrading to SQL Server 2008 is not an
> option at this point, and I would rather not complicate the environment by
> adding a PostGIS server, but will consider it if it's the best way forward.
Hum... plain storage as wkt is not supported. I think it should be possible to
extend the sql server plugin code (or even the generic jdbc store code)
to support this kind of column somehow (there would need to be some
metadata to read in order to know the a particular column is wkt)
It would also seem very inefficient, reading wkt is slow in itself
and as an aggravation you don't have any spatial index.
Out of curiosity, how was the table setup in the mapserver mapfile?
Cheers
Andrea
--
-------------------------------------------------------
Ing. Andrea Aime
GeoSolutions S.A.S.
Tech lead
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 962313
mob: +39 333 8128928
http://www.geo-solutions.it <http://www.geo-solutions.it/>
http://geo-solutions.blogspot.com/
http://www.youtube.com/user/GeoSolutionsIT
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf
-------------------------------------------------------
------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
