hi
the srid of the routing_results table is set to -1, maybe this is the cause of
the problem.
you can try to change the srid of the table, otherwise drop the table, create
it anew and modify the srid when adding the geometry column reference:
SELECT
AddGeometryColumn('','routing_results','the_geom','4326','MULTILINESTRING',2);
regards
Oliver
----- Original Message -----
From: Karol Briones
To: cartoweb-users@lists.maptools.org
Sent: Thursday, January 29, 2009 2:26 AM
Subject: [Cartoweb-users] -ERROR: Operation on two geometries with
differentSRIDs
Hello List,
I try to use the routing plugin, but I have a problem with the SRID, I follow
all steps to adapt the plugin into my proyect, in my layers I use srid=4326,
and in the tables of the plugin I change the srid from the database and the
layers to srid=4326, exist any file that I have to change too?.
This is the error:
Class : SoapFaultWrapperMessage : MapServer error: Error in msDrawMap(): Failed
to draw layer named 'graph'.
Error in msPOSTGISLayerWhichShapes(): Error executing POSTGIS SQL statement (in
FETCH ALL): DECLARE mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text from (SELECT
the_geom, gid from routing_results where results_id IN (10)) as foo WHERE
the_geom && setSRID('BOX3D(150609.329116945 608504.8625,153344
610417.7625)'::BOX3D, -1 )
-ERROR: Operation on two geometries with different SRIDsBacktrace:file: 226 -
C:\ms4w\apps\cartoweb3\coreplugins\images\server\ServerImages.phpcall:
ServerContext->checkMsErrors()file: 311 -
C:\ms4w\apps\cartoweb3\server\Cartoserver.php
call: ServerImages->drawMainmap(Object(Images))file: 349 -
C:\ms4w\apps\cartoweb3\server\Cartoserver.phpcall:
Cartoserver->doGetMap(Object(MapRequest))file: 370 -
C:\ms4w\apps\cartoweb3\server\Cartoserver.php
call: Cartoserver->callWithExceptionCheck("doGetMap", Object(MapRequest))file:
76 - C:\ms4w\apps\cartoweb3\server\MapResultCache.phpcall:
Cartoserver->cacheGetMap(Object(MapRequest))file: 184 -
C:\ms4w\apps\cartoweb3\server\MapResultCache.php
call: MapResultCache->getMapResultFromServer(Object(MapRequest))file: 380 -
C:\ms4w\apps\cartoweb3\server\Cartoserver.phpcall:
MapResultCache->getMap(Object(MapRequest))file: 104 -
C:\ms4w\apps\cartoweb3\client\CartoserverService.php
call: Cartoserver->getMap(Object(MapRequest))file: 165 -
C:\ms4w\apps\cartoweb3\client\CartoserverService.phpcall:
CartoserverService->callDirect("getMap", Object(MapRequest))file: 233 -
C:\ms4w\apps\cartoweb3\client\CartoserverService.php
call: CartoserverService->callFunction("getMap", Object(MapRequest))file: 948 -
C:\ms4w\apps\cartoweb3\client\Cartoclient.phpcall:
CartoserverService->getMap(Object(MapRequest))file: 1086 -
C:\ms4w\apps\cartoweb3\client\Cartoclient.php
call: Cartoclient->getMapResultFromRequest(Object(MapRequest))file: 1261 -
C:\ms4w\apps\cartoweb3\client\Cartoclient.phpcall: Cartoclient->doMain()file:
38 - C:\ms4w\apps\cartoweb3\htdocs\client.php
call: Cartoclient->main()Thanks for your help =).
--
Thanks and Regards
Karol
------------------------------------------------------------------------------
_______________________________________________
Cartoweb-users mailing list
Cartoweb-users@lists.maptools.org
http://lists.maptools.org/mailman/listinfo/cartoweb-users
_______________________________________________
Cartoweb-users mailing list
Cartoweb-users@lists.maptools.org
http://lists.maptools.org/mailman/listinfo/cartoweb-users
