Hi Andrea,
well first of all, everything is very strange, since that layers was running
for some monthsbefore my today check.Then the layer checked is actually a
postgis view, where the field 'the_geom' is included.In Qgis the layer is
loaded correctly with the right SRID '4326', moreover in the table view
'geometry_column'all the rows has 0 as value in srid field.
That probably is the reason why in the geoserver I haven's null values for the
layers coming fromthat postgis datastore.I just wonder how was able to
work?!?!?...
My solution could be to fill-in the field srid in geometry_column view
table,can be right?
Regards
Eugenio
Date: Wed, 20 Nov 2013 16:13:03 +0100
Subject: Re: [Geoserver-users] Operation on mixed SRID geometries
From: [email protected]
To: [email protected]
CC: [email protected]
On Wed, Nov 20, 2013 at 3:54 PM, Eugenio Trumpy <[email protected]> wrote:
Hello everybody,
I get an error on wms.I'm able to see the wms as layer preview but clicking on
a feature I got:Internal error occurred java.io.IOException null ERROR:
Operation on mixed SRID geometries
This error happens when postgres is trying to apply a spatial index with a
geometry having one srid, but thedata has another.
Are you using a sql view? If so, maybe you setup the wrong srid when creating
the sql view?
If instead it's a normal view, may it be there are geometries in different
srids in it?Postgis has a function to check the srid of a geometry, you should
check.
Another possibility for the difference is that qgis is not using any spatial
filter... but that would be rather strange.
CheersAndrea
--
==Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==
Ing. Andrea Aime
@geowolfTechnical Lead
GeoSolutions S.A.S.Via Poggio alle Viti 118755054 Massarosa (LU)
Italyphone: +39 0584 962313fax: +39 0584 1660272mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
------------------------------------------------------------------------------
Shape the Mobile Experience: Free Subscription
Software experts and developers: Be at the forefront of tech innovation.
Intel(R) Software Adrenaline delivers strategic insight and game-changing
conversations that shape the rapidly evolving mobile landscape. Sign up now.
http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
