| Hi, Hi may street map is in a postgis table. The srid is 26331. I used this query http://localhost:13218/geoserver/wms?bbox=522030.875,713514.9375,548229.5,727000.6875&Format=image/png&request=GetMap&layers=topp:lagos_roads&width=550&height=250&srs=EPSG:26331&featureid=lagos_roads.1 and it gave me the following error: Caused by: org.geotools.data.DataSourceException: Error Performing SQL query: SELECT “gid”, encode(asBinary(force_2d(“the_geom”),‘XDR’),‘base64’) FROM “public”.“lagos_roads” WHERE ((“gid” = ‘1’) AND “the_geom” && GeometryFromText(‘POLYGON ((521078.19772727275 712436.0775, 521078.19772727275 728079.5475, 549182.1772727272 728079.5475, 549182.1772727272 712436.0775, 521078.19772727275 712436.0775))’, 4326)) at org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:937) at org.geotools.data.jdbc.JDBC1DataStore.getFeatureReader(JDBC1DataStore.java:649) at org.geotools.data.jdbc.JDBCFeatureCollection.reader(JDBCFeatureCollection.java:88) at org.geotools.data.store.DataFeatureCollection.openIterator(DataFeatureCollection.java:229) at org.geotools.data.store.DataFeatureCollection.iterator(DataFeatureCollection.java:199) at org.geotools.data.store.DataFeatureCollection.features(DataFeatureCollection.java:188) at org.geotools.data.crs.ForceCoordinateSystemFeatureResults.openIterator(ForceCoordinateSystemFeatureResults.java:93) at org.geotools.feature.collection.AbstractFeatureCollection.iterator(AbstractFeatureCollection.java:332) at org.geotools.renderer.lite.StreamingRenderer.drawOptimized(StreamingRenderer.java:1747) … 75 more Caused by: org.postgresql.util.PSQLException: ERROR: Operation on two geometries with different SRIDs at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:239) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:926) … 83 more A closer look at the query sent to postgis will reveal that the srid 4326 was used instead of 26331. I don’t know how this happened. Thanks, Roman. |
|---|
Hi Roman,
It seems geoserver thinks the native data is in 4326. A couple of quetsions:
What is the srid specified on the table? Is there a geometry_columns entry for it.
What srid did you specify on the feature type editor page? And which SRS handling mode?
-Justin
Roman Isitua wrote:
Hi,
Hi may street map is in a postgis table. The srid is 26331. I used this query
and it gave me the following error:
Caused by: org.geotools.data.DataSourceException: Error Performing SQL query: SELECT "gid", encode(asBinary(force_2d("the_geom"),'XDR'),'base64') FROM "public"."lagos_roads" WHERE (("gid" = '1') AND "the_geom" && GeometryFromText('POLYGON ((521078.19772727275 712436.0775, 521078.19772727275 728079.5475, 549182.1772727272 728079.5475, 549182.1772727272 712436.0775, 521078.19772727275 712436.0775))', 4326))
at org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:937)
at org.geotools.data.jdbc.JDBC1DataStore.getFeatureReader(JDBC1DataStore.java:649)
at org.geotools.data.jdbc.JDBCFeatureCollection.reader(JDBCFeatureCollection.java:88)
at org.geotools.data.store.DataFeatureCollection.openIterator(DataFeatureCollection.java:229)
at org.geotools.data.store.DataFeatureCollection.iterator(DataFeatureCollection.java:199)
at org.geotools.data.store.DataFeatureCollection.features(DataFeatureCollection.java:188)
at org.geotools.data.crs.ForceCoordinateSystemFeatureResults.openIterator(ForceCoordinateSystemFeatureResults.java:93)
at org.geotools.feature.collection.AbstractFeatureCollection.iterator(AbstractFeatureCollection.java:332)
at org.geotools.renderer.lite.StreamingRenderer.drawOptimized(StreamingRenderer.java:1747)
... 75 more
Caused by: org.postgresql.util.PSQLException: ERROR: Operation on two geometries with different SRIDs
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:239)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:926)
... 83 moreA closer look at the query sent to postgis will reveal that the srid 4326 was used instead of 26331. I don't know how this happened.
Thanks,
Roman.
------------------------------------------------------------------------
------------------------------------------------------------------------------
Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT
is a gathering of tech-side developers & brand creativity professionals. Meet
the minds behind Google Creative Lab, Visual Complexity, Processing, & iPhoneDevCamp asthey present alongside digital heavyweights like Barbarian
Group, R/GA, & Big Spaceship. http://www.creativitycat.com------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.