Réf. : Re: [udig-devel] Printing investigation and PostGIS

[sebastien.piau@xxxxxxxxxxxx]

-----udig-devel-bounces@xxxxxxxxxxxxxxxxxxxxx a écrit : -----

>Pour : User-friendly Desktop Internet GIS
><udig-devel@xxxxxxxxxxxxxxxxxxxxx>
>De : Cory Horner <chorner@xxxxxxxxxxxxxxx>
>Envoyé par : udig-devel-bounces@xxxxxxxxxxxxxxxxxxxxx
>Date : 09/11/2006 07:32PM
>Objet : Re: [udig-devel] Printing investigation and PostGIS
>
>sebastien.piau@xxxxxxxxxxxx wrote:
>
>> 2) PostGIS:
>> -----------
>> With the RC4, i can load some geometrics data from postgis without 
>> specify any CRS (the geometry_columns table contains -1 for all 
>> SRIDs), then if i modify the layer's and the map's CRS in the same 
>> way, data are allways visible! But the RC5 seems to be more 
>> restrictive : If i modify the layer's and map's CRS, i cannot see
>the 
>> Postgis data! I can only view the postGIS data in the default CRS 
>> (WGS84?).
>>
>> If I try to change the SRID in the geometry_columns table, I obtain
>
>> the following message :
>> 9 nov. 2006 17:47:41 org.geotools.data.jdbc.JDBC1DataStore
>executeQuery
>> GRAVE: Error Performing SQL query: SELECT "gid", 
>> encode(AsBinary(force_2d("the_geom"), 'XDR'),'base64') FROM 
>> "public"."georoute500_troncon_route_dep" WHERE "the_geom" && 
>> GeometryFromText('POLYGON ((517901.17217599996 2384050, 
>> 517901.17217599996 2385010, 519165 2385010, 519165 2384050, 
>> 517901.17217599996 2384050))', 27562)
>> org.postgresql.util.PSQLException: ERROR: Operation on two
>geometries 
>> with different SRIDs
>>
>> Maybe, the "the_geom" data are not encoding with the right CRS?
>What 
>> do you think of that?
>
>Hi Sebastien,
>
>I will have a look at the PostGIS problems in the next 36 hours...  
>Please note that if the SRID is -1 in your PostGIS table, uDig will 
>likely not be able to take advantage of server-side reprojection,
>which 
>will be much faster. 
>
>uDig/GeoTools seems to be confused over which CRS to use, the above 
>error message references EPSG code 27562... is it also trying to use
>4326?
>
>Any further details you could provide would be most helpful.
>
>Thanks,
>Cory.
>_______________________________________________
>User-friendly Desktop Internet GIS (uDig)
>http://udig.refractions.net
>http://lists.refractions.net/mailman/listinfo/udig-devel
>
>

Hello Cory,

I 've also try with EPSG 4326, with the same result...
See the output : 

10 nov. 2006 08:22:06 org.geotools.data.jdbc.JDBC1DataStore executeQuery
GRAVE: Error Performing SQL query: SELECT "gid", encode(AsBinary(force_2d("the_geom"), 'XDR'),'base64') FROM "public"."georoute500_troncon_route_dep" WHERE "the_geom" && GeometryFromText('POLYGON ((472321.690625 2317874.5, 472321.690625 2448800.5, 585038.028125 2448800.5, 585038.028125 2317874.5, 472321.690625 2317874.5))', 4326)
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 sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.postgresql.ds.common.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:474)
    at $Proxy1.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:1258)
    at org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:1356)
    at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:513)
    at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:419)
    at net.refractions.udig.render.internal.feature.basic.BasicFeatureRenderer.render(BasicFeatureRenderer.java:275)
    at net.refractions.udig.render.internal.feature.basic.BasicFeatureRenderer.render(BasicFeatureRenderer.java:187)
    at net.refractions.udig.project.internal.render.impl.RenderExecutorImpl$RenderJob.startRendering(RenderExecutorImpl.java:313)
    at net.refractions.udig.project.internal.render.impl.RenderExecutorImpl$RenderJob.run(RenderExecutorImpl.java:371)
    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:58)
10 nov. 2006 08:22:06 org.geotools.renderer.lite.StreamingRenderer paint
GRAVE: Exception occurrend during rendering
org.geotools.data.DataSourceException: Error Performing SQL query: SELECT "gid", encode(AsBinary(force_2d("the_geom"), 'XDR'),'base64') FROM "public"."georoute500_troncon_route_dep" WHERE "the_geom" && GeometryFromText('POLYGON ((472321.690625 2317874.5, 472321.690625 2448800.5, 585038.028125 2448800.5, 585038.028125 2317874.5, 472321.690625 2317874.5))', 4326)
    at org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:933)
    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:1258)
    at org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:1356)
    at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:513)
    at org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:419)
    at net.refractions.udig.render.internal.feature.basic.BasicFeatureRenderer.render(BasicFeatureRenderer.java:275)
    at net.refractions.udig.render.internal.feature.basic.BasicFeatureRenderer.render(BasicFeatureRenderer.java:187)
    at net.refractions.udig.project.internal.render.impl.RenderExecutorImpl$RenderJob.startRendering(RenderExecutorImpl.java:313)
    at net.refractions.udig.project.internal.render.impl.RenderExecutorImpl$RenderJob.run(RenderExecutorImpl.java:371)
    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:58)
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 sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.postgresql.ds.common.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:474)
    at $Proxy1.executeQuery(Unknown Source)
    at org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:922)
    ... 11 more

I don't really understand the problem :
 - Does UDig execute a bad request?
 - the_geom data are wrong in my table?
 - A Postgresql Bug?

Don't hesitate to ask for me for others tests!

Sebastien