Dear Stefano and Andrea,
just to close this thread, I solved with a geoserver upgrade,now seems to run
correclty.
Thank you for your support.
Regards
Eugenio
Message: 2
Date: Thu, 21 Nov 2013 10:53:13 +0100
From: Andrea Aime andrea.a...@geo-solutions.it
So the upgrade is the most quick
frippe12...@hotmail.com
Subject: Re: [Geoserver-users] Operation on mixed SRID geometries
To: Stefano Iacovella stefano.iacove...@gmail.com
Cc: geoserver-users@lists.sourceforge.net
geoserver-users@lists.sourceforge.net
Message-ID: dub127-w7754641e8cc74058654e39e5...@phx.gbl
Content-Type: text
On Thu, Nov 21, 2013 at 9:36 AM, Eugenio Trumpy frippe12...@hotmail.comwrote:
Hi,
rebooting the ubuntu server, geoserver is running again correctly.
The very strange thing that I observe is that the same postgis datastore
used with geoserver 2.3.2 run perfectly, and I'm able to get the
Hi,yes I modify the query for producing that view (excluding the rows without
coordinates),but still doesn't work.In the preview I see the features but no
info on items, with that error.
Regards
Eugenio
Date: Thu, 21 Nov 2013 09:44:24 +0100
Subject: Re: Operation on mixed SRID geometries
From:
On Thu, Nov 21, 2013 at 9:46 AM, Eugenio Trumpy frippe12...@hotmail.comwrote:
Hi,
yes I modify the query for producing that view (excluding the rows without
coordinates),
but still doesn't work.
In the preview I see the features but no info on items, with that error.
Enable geotools
Hi again,
here the log output relate to the query:2013-11-21 10:01:07,906 DEBUG
[org.geotools.jdbc] - SELECT count(*) AS gt_result_ FROM (SELECT * FROM
public.pozzi_decodificati_vigor WHERE (the_geom
ST_GeomFromText('POLYGON ((18.71948828125 40.28446472745902, 19.074246093750002
On Thu, Nov 21, 2013 at 10:06 AM, Eugenio Trumpy frippe12...@hotmail.comwrote:
Hi again,
here the log output relate to the query:
2013-11-21 10:01:07,906 DEBUG [org.geotools.jdbc] - SELECT count(*) AS
gt_result_ FROM (SELECT * FROM public.pozzi_decodificati_vigor WHERE
(the_geom
Hi,
Ok, so this GeoServer still thinks the srid is 0.
The srid is read the first time GeoServer tries to access that view
(normally, during startup when checking if the feature type can be computed)
and from there on, it won't consult the geometry_columns anymore.
Well, unless you force it
On Thu, Nov 21, 2013 at 10:41 AM, Eugenio Trumpy frippe12...@hotmail.comwrote:
So the upgrade is the most quick solution,
I can do it, but have you any hints since I have to change from 2.1.2 to
the stable 2.4...?
Make a backup of your data directory, there has been reports of issues
during
Hi,actually the result of that query has srid value = 0
E.
From: stefano.iacove...@gmail.com
Date: Thu, 21 Nov 2013 10:43:04 +0100
Subject: Re: FW: Operation on mixed SRID geometries
To: frippe12...@hotmail.com
CC: andrea.a...@geo-solutions.it
2013/11/21 Eugenio Trumpy frippe12...@hotmail.com
2.0.3 r11128
From: stefano.iacove...@gmail.com
Date: Thu, 21 Nov 2013 10:55:55 +0100
Subject: Re: Operation on mixed SRID geometries
To: frippe12...@hotmail.com
CC: andrea.a...@geo-solutions.it; geoserver-users@lists.sourceforge.net
2013/11/21 Eugenio Trumpy frippe12...@hotmail.com
Do you loaded the data contained in the table used from the view with the
shp2pgsql utility?
If so it does not use the typmod feature for adding the geometry column to
the table, when creating views PostGIS does not populate the
geometry_columns unless you perform a cast on the geoemtry column of
On Wed, Nov 20, 2013 at 3:54 PM, Eugenio Trumpy frippe12...@hotmail.comwrote:
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
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: andrea.a...@geo-solutions.it
To: frippe12...@hotmail.com
CC: geoserver-users@lists.sourceforge.net
On Wed, Nov 20, 2013 at 3:54 PM, Eugenio
2013/11/20 Eugenio Trumpy frippe12...@hotmail.com
My solution could be to fill-in the field srid in geometry_column view
table,
can be right?
Try to republish the layer in Geoserver.
In the Native SRS filed it is showed 4326?
Do you get the error from the layer preview?
Cheers,
Stefano
is empty, so I remove and re-publish
that layerin geoserver but still doesn't work.What I'm doing wrong?
Thank you for now,
Kind regards
Eugenio
Date: Wed, 20 Nov 2013 16:13:03 +0100
Subject: Re: [Geoserver-users] Operation on mixed SRID geometries
From: andrea.a...@geo-solutions.it
To: frippe12
2013/11/20 Eugenio Trumpy frippe12...@hotmail.com
But I modify the query for producing the view excluding the rows where
the_geom is empty, so I remove and re-publish that layer
in geoserver but still doesn't work.
What I'm doing wrong?
If you run in postgis:
select
: [Geoserver-users] Operation on mixed SRID geometries
To: frippe12...@hotmail.com
CC: andrea.a...@geo-solutions.it; geoserver-users@lists.sourceforge.net
2013/11/20 Eugenio Trumpy frippe12...@hotmail.com
But I modify the query for producing the view excluding the rows where the_geom
is empty
18 matches
Mail list logo