On Tue, Feb 7, 2017 at 7:56 PM, Martin Davis wrote:
> Another user reported that this even works with defining the view as a
> GeoServer SQL View, which is a very handy capability. It would be nice if
> this worked for Oracle as well!
>
For Oracle to work this fella needs to be fixed (basically
Ok, figured it out. The view as orginally defined used
"geography::STGeomFromText". GeoServer only recognizes the "geometry"
MS-SQL datatype (which is reasonable). Changing the view to use
"geometry::STGeomFromText" fixed the problem. GeoServer recognizes the
geometry column and renders it.
Fur
Has anyone tried creating a spatial view on an XY table in MS SQL Server,
so it can be exposed via GeoServer?
We are not having any luck with this. What we have done is:
1) Define a spatial view:
CREATE VIEW UDO_Fuel_Cache_SVW AS
SELECT
ID,
Latitude,
Longitude,
Geo