On Mon, Mar 3, 2014 at 9:45 AM, TNU <[email protected]> wrote:
> Hi all,
>
> I'm having an issue but can't figure out why Geoserver is causing this srid
> problem:
>
> Geoserver will always put number 2 as an srid to the Filter, srid should be
> 3067. "geom".Filter(geometry::STGeomFromText('POLYGON ((-100989.41629392917
> 6052208.320800154, -100989.41629392917 8361536.260998247,
> 1004823.3858394071
> 8361536.260998247, 1004823.3858394071 6052208.320800154,
> -100989.41629392917
> 6052208.320800154))', 2)
> This query will always return zero rows, if I put the 3067 as an srid it
> will return rows.
>
> I have created a layer with SQL view against SQL Server 2008 R2. After
> refreshing the attributes geoserver will set the 2 as srid by default. I
> have corrected this one to use 3067. That's the only place where I have
> seen
> this number 2 related to this issue.
>
>
Two possibilities:
* you have geometries in that table with 2 as their srid
* you setup the geometry metadata table, and put 2 as the srid for that view
Cheers
Andrea
--
== Our support, Your Success! Visit http://opensdi.geo-solutions.it for
more information ==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
------------------------------------------------------------------------------
Subversion Kills Productivity. Get off Subversion & Make the Move to Perforce.
With Perforce, you get hassle-free workflows. Merge that actually works.
Faster operations. Version large binaries. Built-in WAN optimization and the
freedom to use Git, Perforce or both. Make the move to Perforce.
http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
