[udig-devel] Operation on two geometries with different SRIDs

=?gb2312?B?1dTQwtSq?= zhaoxinyuan2000 at tom.com
Thu Sep 13 03:22:12 PDT 2007


HI,

I update UDig to udig-1.1.RC11.When I open a map, it can't display the map. I found some error on console. I found the error is : "Operation on two geometries with different SRIDs". The layer to display is a postgis spatial table, in the geometry-columns,I set the table SRID is 4326.
I can't find the problem in udig-1.1-RC8.
How can I do?

This the exception stack.

2007-9-13 16:44:23 org.geotools.data.jdbc.JDBC1DataStore executeQuery
ÑÏÖØ: Error Performing SQL query: SELECT "gid", AsText(force_2d("the_geom")) FROM "public"."test_poi" WHERE "the_geom" && GeometryFromText('POLYGON ((116.32268676757779 39.890502548217775, 116.32268676757779 39.979999923706025, 116.4019531250002 39.979999923706025, 116.4019531250002 39.890502548217775, 116.32268676757779 39.890502548217775))', 4326) AND intersects("the_geom", GeometryFromText('POLYGON ((116.32268676757779 39.890502548217775, 116.32268676757779 39.979999923706025, 116.4019531250002 39.979999923706025, 116.4019531250002 39.890502548217775, 116.32268676757779 39.890502548217775))', 4326))
org.postgresql.util.PSQLException: ´íÎó: 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 sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.postgresql.ds.common.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:474)
at $Proxy24.executeQuery(Unknown Source)
at org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:922)
at org.geotools.data.jdbc.JDBC1DataStore.getFeatureReader(JDBC1DataStore.java:672)
at org.geotools.data.jdbc.JDBCFeatureCollection.reader(JDBCFeatureCollection.java:78)
at org.geotools.renderer.lite.StreamingRenderer.getReader(StreamingRenderer.java:1173)
at org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:1272)
at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:464)
at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:374)
at net.refractions.udig.render.internal.feature.basic.BasicFeatureRenderer.render(BasicFeatureRenderer.java:309)
at net.refractions.udig.render.internal.feature.basic.BasicFeatureRenderer.render(BasicFeatureRenderer.java:193)
at net.refractions.udig.project.internal.render.impl.RenderExecutorImpl$RenderJob.startRendering(RenderExecutorImpl.java:315)
at net.refractions.udig.project.internal.render.impl.RenderExecutorImpl$RenderJob.run(RenderExecutorImpl.java:396)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:58) 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.refractions.net/pipermail/udig-devel/attachments/20070913/9dec4171/attachment.html


More information about the udig-devel mailing list