Jerry,
here are some instructions describing how a colleague used workarounds and CLR extensions to enable the delivery of spatial information with GeoServer and SQL Server 2005:
https://www.seegrid.csiro.au/wiki/Infosrvices/GeoserverMsSqlServer2005Connectivity
This worked well with WFS for simple features and app-schema complex features.
This approach has not been tested with WMS; I do not know if there are spatial indices, which are IIRC required by WMS.
Kind regards,
Ben.
On 09/10/13 19:19, Jerry O'Sullivan wrote:
Stefano
Thanks..the sql server db is 2005 so I don't have geometry support
available in the db
The only options I can see are
1) Install postgres to pull the data from sql server every hour but th
is seems a bit messy but might be the best option if I use geoserver
2) investigate if there is an ogr data store for geoserver out there.
3) Use Mapserver!
What do you think?
Thanks,
Jerry
On Oct 9, 2013 11:10 a.m., "Stefano Iacovella"
<stefano.iacovella@anonymised.com <mailto:stefano.iacovella@anonymised.com>> wrote:
Hi Jerry,
In Oracle or PostGIS I would create a spatial view converting your
textual values to a geometry field.
You should use a similar function in SQL Server and then publish the
view on GeoServer.
Kind Regards,
Stefano
---------------------------------------------------
41.95581N 12.52854E
http://www.linkedin.com/in/stefanoiacovella
http://twitter.com/#!/Iacovellas
2013/10/9 osullivj <jeremiahosullivan@anonymised.com
<mailto:jeremiahosullivan@anonymised.com>>
Hi
I have a SQL Server DB with point data stored in 2 Columns (X,Y)
Can these be mapped directly using GeoServer
Thanks,
Jerry
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/Point-Data-in-X-Y-Fields-in-RDBMS-tp5082553.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get
the most from
the latest Intel processors and coprocessors. See abstracts and
register >
http://pubads.g.doubleclick.net/gampad/clk?id=60134071&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
<mailto:Geoserver-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60134071&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Ben Caradoc-Davies <Ben.Caradoc-Davies@anonymised.com>
Software Engineer
CSIRO Earth Science and Resource Engineering
Australian Resources Research Centre