I have an SQL Server 2012 table, which contains a DbGeometry column with a spatial index. Then a Geoserver 2.7 using it. The problem is that when I do a WFS query it doesn't restrict the results to the coordinates I pass in by BBOX, it always returns all records.
I create the database entry using:
DbGeometry geo = DbGeometry.PointFromText(string.Format("POINT({0} {1})", hp.Lng, hp.Lat), 4326);The point inserts fine, using 4326 & Long/Lat. Geoserver sees it and picks up Native & Declared SRS of EPSG:4326. I have tried 'Force declared' and 'Keep native'.
Ultimately I'm using Leaflet map with the WFS query as an Ajax call, but for now I'm just trying to get this working using a browser call.
The call/query looks like this:http://ourserver:port/geoserver/ncc...43632,53.035893,-0.755842,53.077641,EPSG:4326
Is there anything else I can try to fix this problem or even any other way of doing the same thing?
I have seen some posts about SQL Server sometimes passing back inaccurate results, but this isn't restricting them at all.
Edit to include this, the returned data.
-1.11036761969209 53.3084063531532
أكثر...
I create the database entry using:
DbGeometry geo = DbGeometry.PointFromText(string.Format("POINT({0} {1})", hp.Lng, hp.Lat), 4326);The point inserts fine, using 4326 & Long/Lat. Geoserver sees it and picks up Native & Declared SRS of EPSG:4326. I have tried 'Force declared' and 'Keep native'.
Ultimately I'm using Leaflet map with the WFS query as an Ajax call, but for now I'm just trying to get this working using a browser call.
The call/query looks like this:http://ourserver:port/geoserver/ncc...43632,53.035893,-0.755842,53.077641,EPSG:4326
Is there anything else I can try to fix this problem or even any other way of doing the same thing?
I have seen some posts about SQL Server sometimes passing back inaccurate results, but this isn't restricting them at all.
Edit to include this, the returned data.
-1.11036761969209 53.3084063531532
أكثر...