I will try that, yes.
On further reflection, I thought of something else that is possibly related:
I use shp2pgsql to import Esri shapefiles into PostGIS. For some reason, when
the table is created, the SRID is set to 0. Then I change it to the
appropriate one in PostGIS. When I then add it to GeoServer, it doesn’t pick
up on that and leaves the “Native SRS” field blank, so I have to use the
Declared SRS instead.
Bettina
(402) 554-2088
From: [email protected] [mailto:[email protected]] On Behalf Of Andrea
Aime
Sent: Tuesday, June 03, 2014 11:49
To: Bettina Lechner
Cc: [email protected]
Subject: Re: [Geoserver-users] ERROR: Operation on mixed SRID geometries
On Tue, Jun 3, 2014 at 6:44 PM, Bettina Lechner
<[email protected]<mailto:[email protected]>> wrote:
Yes, it is PostGIS. Sorry, I forgot to mention that.
Here’s the geometry_columns content for that table:
f_table_catalog
f_table_schema
f_table_name
f_geometry_column
coord_dimension
srid
type
heartland
heartland
traffic_scenario_a
geom
2
3857
MULTIPOLYGON
Running
SELECT DISTINCT(ST_SRID(ST_AsEWKT(geom))) FROM heartland.traffic_scenario_a;
Returns only one row containing 3857.
Hmm... wondering if it's the GeoServer version, it's pretty old now. Any chance
you can upgrade to 2.5.1?
Cheers
Andrea
--
==
Meet us at GEO Business 2014! in London! Visit http://goo.gl/fES3aK
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
-------------------------------------------------------
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
