[Mapserver-users] Operation on two GEOMETRIES with different SRIDs

["Weßling, Achim"]

Hallo,

I use mapserv 4.01 on a freebsd 4.9. The database ist PostgreSQL 7.4.1 with
PostGIS 0.8.1.
When trying to reach a postgis layer with umn postgis throws the following
error:

Operation on two GEOMETRIES with different SRIDs

The following is the full error page:

<?xml version='1.0' encoding="ISO-8859-1" standalone="no" ?>
<!DOCTYPE ServiceExceptionReport SYSTEM
"http://www.digitalearth.gov/wmt/xml/exception_1_1_0.dtd">
<ServiceExceptionReport version="1.1.0">
<ServiceException>
msDrawMap(): Image handling error. Failed to draw layer named 'dgk5gitter'.
<br>
msPOSTGISLayerWhichShapes(): Query error. Error executing POSTGIS  SQL
statement (in FETCH ALL): DECLARE mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text from
dgk5gitter_l WHERE the_geom && setSRID('BOX3D(3455060.58680556
5747011.58680556,3457342.41319444 5749293.41319444)'::BOX3D,
find_srid('','dgk5gitter_l','the_geom') )
-ERROR:  Operation on two GEOMETRIES with different SRIDs


Error with POSTGIS data variable. You specified ''.<br>
Standard ways of specifiying are : <br>
(1) 'geometry_column from geometry_table' <br>
(2) 'geometry_column from (&lt;sub query&gt;) as foo using unique &lt;column
name&gt; using SRID=&lt;srid#&gt;' <br><br>

Make sure you put in the 'using unique  &lt;column name&gt;' and 'using
SRID=#' clauses in.

<br><br>For more help, please see
http://postgis.refractions.net/documentation.php 

<br><br>Mappostgis.c - version of June 12/2003.
 <br>
msDrawRaster(): Unable to access file. (5648gs_400.tif) <br>
msDrawRaster(): Unable to access file. (5646gs_400.tif) <br>
msDrawRaster(): Unable to access file. (5448gs_400.tif) <br>
msDrawRaster(): Unable to access file. (5446gs_400.tif) <br>
</ServiceException>
</ServiceExceptionReport>

Does someone has a similar problem?
Thanks!


Mit freundlichem Gruß

Achim Weßling
=====================
INFOKOM Gütersloh AöR
Fachbereich Technische Anwendungen
Herzebrocker Str. 140
33334 Gütersloh
Tel.: 05241/85-2926
Achim.Wessling at gt-net.de
http://www.infokom-gt.de