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 -- ------------------------------------------------------- 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://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 [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
