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