[Cartoweb-users] -ERROR: Operation on two geometries with differentSRIDs

[Oliver Christen]

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 at 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 at lists.maptools.org
  http://lists.maptools.org/mailman/listinfo/cartoweb-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/cartoweb-users/attachments/20090130/ed68ea8b/attachment.htm