[mapserver-users] Re: mapserver-users Digest, Vol 32, Issue 51

Fri Jan 14 19:48:35 PST 2011

How to write code to calculate distance between two points using pointObject  using PHP Map server.

Also how to write code to find shortest path from one point to other using php mapserver.

On Wed, 22 Sep 2010 22:40:25 +0530 mapserver-users-request at lists.osgeo.org wrote

>Send mapserver-users mailing list submissions to

>mapserver-users at lists.osgeo.org

>

>To subscribe or unsubscribe via the World Wide Web, visit

>http://lists.osgeo.org/mailman/listinfo/mapserver-users

>or, via email, send a message with subject or body 'help' to

>mapserver-users-request at lists.osgeo.org

>

>You can reach the person managing the list at

>mapserver-users-owner at lists.osgeo.org

>

>When replying, please edit your Subject line so it is more specific

>than "Re: Contents of mapserver-users digest..."

>

>

>Today's Topics:

>

>  1. Re: Coments about the Tickedt 3541 (Alan Boudreault)

>

>

>----------------------------------------------------------------------

>

>Message: 1

>Date: Wed, 22 Sep 2010 13:11:19 -0400

>From: Alan Boudreault <aboudreault at mapgears.com>

>Subject: Re: [mapserver-users] Coments about the Tickedt 3541

>To: mapserver-users at lists.osgeo.org

>Message-ID: <201009221311.20241.aboudreault at mapgears.com>

>Content-Type: text/plain; charset="iso-8859-1"

>

>Hmm... very strange. Although I am not able to reprodude it under Unix.... It 

>seems to be an Oracle bug.

>

>On September 22, 2010 03:35:38 am Jorge Bellido Diez wrote:

>> We reproduced the same problem doing requets to the OCG Services using

>> OpenLayers 2.8 or gvSig 1.1.2 Doing a getfeatureinfo to a Oracle layer of

>> an WMS Service or getfeatrue to a Oracle layer of an WFS Service the

>> Oracle Server produce a log file and a dump memory. Then I coud see

>> duplicates values in my primary key, furthermore primary index still

>> points to old data even though the user has no UPDATE-GRANTS. This

>> behavior seems to be random

>> 

>> These are our configuration:

>> - MS4W 3.0 Beta 10

>> - MapServer 5.6.1

>> - Personal Oracle Database 10g Release 10.2.0.1.0 - 64bit Production

>> 

>> This is the way we declare an Oracle Layer in the map file:

>> ----------------

>> LAYER

>> STATUS ON

>> CONNECTIONTYPE oraclespatial

>> CONNECTION "admcarto/admcarto at ORA10GEX"

>> NAME "PoligonosSigpac"

>> PROJECTION

>> "init=epsg:23030"

>> END

>> 

>> TYPE POLYGON

>> METADATA

>> "wms_title" "Poligonos Sigpac 2009"

>> "wms_srs"       "EPSG:23030"

>> "wms_name"      "poligonos"

>> "wms_server_version" "1.1.1"

>> "wms_format"     "image/png"

>> "wms_transparent"   "true"

>> "wms_extent" "470000 4700000 610000 4820000"

>> END

>> 

>> DATA "GEOMETRY FROM (SELECT * FROM GV_SIGPAC_POL_ED50) USING UNIQUE 

>gid

>> SRID 82337"

>> 

>> CLASS

>> NAME "Poligonos"

>> STYLE

>> OUTLINECOLOR 178 0 255

>> END

>> TEMPLATE "ttt_query.html"

>> END

>> END

>> --------------

>> 

>> This is a little portion of one of this log files with the error code:

>> 

>> Dump file f:\oracle\admin\ora10gex\udump\ora10gex_ora_1408.trc

>> Wed Sep 01 12:56:09 2010

>> ORACLE V10.2.0.1.0 - 64bit Production vsnsta=0

>> vsnsql=14 vsnxtr=3

>> Personal Oracle Database 10g Release 10.2.0.1.0 - 64bit Production With the

>> Partitioning, OLAP and Data Mining options Windows NT Version V5.2 Service

>> Pack 2 CPU         :2 - type 8664, 1 Physical Cores

>> Process Affinity  : 0x0000000000000000

>> Memory (Avail/Total): Ph:1786M/4031M, Ph+PgF:5772M/7808M Instance name:

>> ora10gex

>> 

>> Redo thread mounted by this instance: 1

>> 

>> Oracle process number: 19

>> 

>> Windows thread id: 1408, image: ORACLE.EXE (SHAD)

>> 

>> 

>> *** SERVICE NAME:(ORA10GEX) 2010-09-01 12:56:09.919

>> *** SESSION ID:(159.12216) 2010-09-01 12:56:09.919

>> ********** Internal heap ERROR 17182 addr=000007FF985DDC24 *********

>> ***** Dump of memory around addr 000007FF985DDC24:

>> 7FF985DCC20     3CC3093F 090E2C10 09474557   [?..<.,..WEG.]

>> 7FF985DCC30 535005C4 44511B43 3CC3093F 152B2D10 [..PSC.QD?..<.-+.]

>> 

>> ..

>> ..

>> ..

>> 

>> Permanent space  = 1732608

>> ******************************************************

>> Hla: 255

>> *** 2010-09-01 12:56:10.966

>> ksedmp: internal or fatal error

>> ORA-00600: internal error code, arguments: [17182], [0x7FF985DDC24], [],

>> [], [], [], [], [] Current SQL statement for this session: SELECT gid,

>> TER_HIST, AREA, PERIMETRO, GID, PROVINCIA, GEOMETRY FROM (SELECT * FROM

>> GT_PROVINCIAS_ED50) WHERE SDO_FILTER( GEOMETRY, MDSYS.SDO_GEOMETRY(2003,

>> :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates

>> ),'querytype=window') = 'TRUE' ----- Call Stack Trace -----

>> calling       call   entry        argument values in hex

>> location       type   point        (? means dubious value)

>> -------------------- -------- --------------------

>> ----------------------------

>> 

>> ..

>> ..

>> ..

>> 

>> 

>> 

>> Thanks, Jorge.

>> 

>> 

>> -----Mensaje original-----

>> De: mapserver-users-bounces at lists.osgeo.org

>> [mailto:mapserver-users-bounces at lists.osgeo.org] En nombre de Sumit Sharma

>> Enviado el: miércoles, 15 de septiembre de 2010 17:05 Para:

>> mapserver-users at lists.osgeo.org

>> Asunto: [mapserver-users] Re: Problems with MapServer and Oracle Spatial

>> 

>> 

>> Thanks for you response.

>> As suggested by you I have created a ticket.

>> Ticket number is 3541.

>> -Sumit

>> --

>> View this message in context:

>> http://osgeo-org.1803224.n2.nabble.com/Problems-with-MapServer-and-Oracle-

>> Spatial-tp5518303p5534732.html Sent from the Mapserver - User mailing list

>> archive at Nabble.com. _______________________________________________

>> mapserver-users mailing list

>> mapserver-users at lists.osgeo.org

>> http://lists.osgeo.org/mailman/listinfo/mapserver-users

>> _______________________________________________

>> mapserver-users mailing list

>> mapserver-users at lists.osgeo.org

>> http://lists.osgeo.org/mailman/listinfo/mapserver-users

>

>-- 

>Alan Boudreault

>Mapgears

>http://www.mapgears.com

>-------------- next part --------------

>An HTML attachment was scrubbed...

>URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20100922/36653591/attachment.html

>

>------------------------------

>

>_______________________________________________

>mapserver-users mailing list

>mapserver-users at lists.osgeo.org

>http://lists.osgeo.org/mailman/listinfo/mapserver-users

>

>

>End of mapserver-users Digest, Vol 32, Issue 51

>***********************************************

>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20110115/7f4d5e5e/attachment.htm>