Neil, try using a sql view, with your sql being something like
select *, STGeomFromText(wkt) as the_geom from yourtable
I wouldn't use * to skip the wkt, but you get the idea
hth
charles
On Feb 8, 2011, at 3:46 AM, Neil Mercer wrote:
> 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: [email protected] on behalf of Andrea Aime
> Sent: Tue 8/02/2011 6:41 PM
> To: Neil Mercer
> Cc: [email protected]
> Subject: Re: [Geoserver-users] Best way to incorporate WKT feature data
>
> On Tue, Feb 8, 2011 at 6:29 AM, Neil Mercer
> <[email protected]> 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
>
>
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
