How to write code to calculate distance between two points using pointObject using PHP Map server.<br><br><br>Also how to write code to find shortest path from one point to other using php mapserver.<br><br>
On Wed, 22 Sep 2010 22:40:25 +0530 mapserver-users-request@lists.osgeo.org wrote<br>
>Send mapserver-users mailing list submissions to<br>
>mapserver-users@lists.osgeo.org<br>
><br>
>To subscribe or unsubscribe via the World Wide Web, visit<br>
>http://lists.osgeo.org/mailman/listinfo/mapserver-users<br>
>or, via email, send a message with subject or body 'help' to<br>
>mapserver-users-request@lists.osgeo.org<br>
><br>
>You can reach the person managing the list at<br>
>mapserver-users-owner@lists.osgeo.org<br>
><br>
>When replying, please edit your Subject line so it is more specific<br>
>than "Re: Contents of mapserver-users digest..."<br>
><br>
><br>
>Today's Topics:<br>
><br>
> 1. Re: Coments about the Tickedt 3541 (Alan Boudreault)<br>
><br>
><br>
>----------------------------------------------------------------------<br>
><br>
>Message: 1<br>
>Date: Wed, 22 Sep 2010 13:11:19 -0400<br>
>From: Alan Boudreault <aboudreault@mapgears.com><br>
>Subject: Re: [mapserver-users] Coments about the Tickedt 3541<br>
>To: mapserver-users@lists.osgeo.org<br>
>Message-ID: <201009221311.20241.aboudreault@mapgears.com><br>
>Content-Type: text/plain; charset="iso-8859-1"<br>
><br>
>Hmm... very strange. Although I am not able to reprodude it under Unix.... It <br>
>seems to be an Oracle bug.<br>
><br>
>On September 22, 2010 03:35:38 am Jorge Bellido Diez wrote:<br>
>> We reproduced the same problem doing requets to the OCG Services using<br>
>> OpenLayers 2.8 or gvSig 1.1.2 Doing a getfeatureinfo to a Oracle layer of<br>
>> an WMS Service or getfeatrue to a Oracle layer of an WFS Service the<br>
>> Oracle Server produce a log file and a dump memory. Then I coud see<br>
>> duplicates values in my primary key, furthermore primary index still<br>
>> points to old data even though the user has no UPDATE-GRANTS. This<br>
>> behavior seems to be random<br>
>> <br>
>> These are our configuration:<br>
>> - MS4W 3.0 Beta 10<br>
>> - MapServer 5.6.1<br>
>> - Personal Oracle Database 10g Release 10.2.0.1.0 - 64bit Production<br>
>> <br>
>> This is the way we declare an Oracle Layer in the map file:<br>
>> ----------------<br>
>> LAYER<br>
>> STATUS ON<br>
>> CONNECTIONTYPE oraclespatial<br>
>> CONNECTION "admcarto/admcarto@ORA10GEX"<br>
>> NAME "PoligonosSigpac"<br>
>> PROJECTION<br>
>> "init=epsg:23030"<br>
>> END<br>
>> <br>
>> TYPE POLYGON<br>
>> METADATA<br>
>> "wms_title" "Poligonos Sigpac 2009"<br>
>> "wms_srs" "EPSG:23030"<br>
>> "wms_name" "poligonos"<br>
>> "wms_server_version" "1.1.1"<br>
>> "wms_format" "image/png"<br>
>> "wms_transparent" "true"<br>
>> "wms_extent" "470000 4700000 610000 4820000"<br>
>> END<br>
>> <br>
>> DATA "GEOMETRY FROM (SELECT * FROM GV_SIGPAC_POL_ED50) USING UNIQUE <br>
>gid<br>
>> SRID 82337"<br>
>> <br>
>> CLASS<br>
>> NAME "Poligonos"<br>
>> STYLE<br>
>> OUTLINECOLOR 178 0 255<br>
>> END<br>
>> TEMPLATE "ttt_query.html"<br>
>> END<br>
>> END<br>
>> --------------<br>
>> <br>
>> This is a little portion of one of this log files with the error code:<br>
>> <br>
>> Dump file f:\oracle\admin\ora10gex\udump\ora10gex_ora_1408.trc<br>
>> Wed Sep 01 12:56:09 2010<br>
>> ORACLE V10.2.0.1.0 - 64bit Production vsnsta=0<br>
>> vsnsql=14 vsnxtr=3<br>
>> Personal Oracle Database 10g Release 10.2.0.1.0 - 64bit Production With the<br>
>> Partitioning, OLAP and Data Mining options Windows NT Version V5.2 Service<br>
>> Pack 2 CPU :2 - type 8664, 1 Physical Cores<br>
>> Process Affinity : 0x0000000000000000<br>
>> Memory (Avail/Total): Ph:1786M/4031M, Ph+PgF:5772M/7808M Instance name:<br>
>> ora10gex<br>
>> <br>
>> Redo thread mounted by this instance: 1<br>
>> <br>
>> Oracle process number: 19<br>
>> <br>
>> Windows thread id: 1408, image: ORACLE.EXE (SHAD)<br>
>> <br>
>> <br>
>> *** SERVICE NAME:(ORA10GEX) 2010-09-01 12:56:09.919<br>
>> *** SESSION ID:(159.12216) 2010-09-01 12:56:09.919<br>
>> ********** Internal heap ERROR 17182 addr=000007FF985DDC24 *********<br>
>> ***** Dump of memory around addr 000007FF985DDC24:<br>
>> 7FF985DCC20 3CC3093F 090E2C10 09474557 [?..<.,..WEG.]<br>
>> 7FF985DCC30 535005C4 44511B43 3CC3093F 152B2D10 [..PSC.QD?..<.-+.]<br>
>> <br>
>> ..<br>
>> ..<br>
>> ..<br>
>> <br>
>> Permanent space = 1732608<br>
>> ******************************************************<br>
>> Hla: 255<br>
>> *** 2010-09-01 12:56:10.966<br>
>> ksedmp: internal or fatal error<br>
>> ORA-00600: internal error code, arguments: [17182], [0x7FF985DDC24], [],<br>
>> [], [], [], [], [] Current SQL statement for this session: SELECT gid,<br>
>> TER_HIST, AREA, PERIMETRO, GID, PROVINCIA, GEOMETRY FROM (SELECT * FROM<br>
>> GT_PROVINCIAS_ED50) WHERE SDO_FILTER( GEOMETRY, MDSYS.SDO_GEOMETRY(2003,<br>
>> :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates<br>
>> ),'querytype=window') = 'TRUE' ----- Call Stack Trace -----<br>
>> calling call entry argument values in hex<br>
>> location type point (? means dubious value)<br>
>> -------------------- -------- --------------------<br>
>> ----------------------------<br>
>> <br>
>> ..<br>
>> ..<br>
>> ..<br>
>> <br>
>> <br>
>> <br>
>> Thanks, Jorge.<br>
>> <br>
>> <br>
>> -----Mensaje original-----<br>
>> De: mapserver-users-bounces@lists.osgeo.org<br>
>> [mailto:mapserver-users-bounces@lists.osgeo.org] En nombre de Sumit Sharma<br>
>> Enviado el: miércoles, 15 de septiembre de 2010 17:05 Para:<br>
>> mapserver-users@lists.osgeo.org<br>
>> Asunto: [mapserver-users] Re: Problems with MapServer and Oracle Spatial<br>
>> <br>
>> <br>
>> Thanks for you response.<br>
>> As suggested by you I have created a ticket.<br>
>> Ticket number is 3541.<br>
>> -Sumit<br>
>> --<br>
>> View this message in context:<br>
>> http://osgeo-org.1803224.n2.nabble.com/Problems-with-MapServer-and-Oracle-<br>
>> Spatial-tp5518303p5534732.html Sent from the Mapserver - User mailing list<br>
>> archive at Nabble.com. _______________________________________________<br>
>> mapserver-users mailing list<br>
>> mapserver-users@lists.osgeo.org<br>
>> http://lists.osgeo.org/mailman/listinfo/mapserver-users<br>
>> _______________________________________________<br>
>> mapserver-users mailing list<br>
>> mapserver-users@lists.osgeo.org<br>
>> http://lists.osgeo.org/mailman/listinfo/mapserver-users<br>
><br>
>-- <br>
>Alan Boudreault<br>
>Mapgears<br>
>http://www.mapgears.com<br>
>-------------- next part --------------<br>
>An HTML attachment was scrubbed...<br>
>URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20100922/36653591/attachment.html<br>
><br>
>------------------------------<br>
><br>
>_______________________________________________<br>
>mapserver-users mailing list<br>
>mapserver-users@lists.osgeo.org<br>
>http://lists.osgeo.org/mailman/listinfo/mapserver-users<br>
><br>
><br>
>End of mapserver-users Digest, Vol 32, Issue 51<br>
>***********************************************<br>
><br><A HREF="http://sigads.rediff.com/RealMedia/ads/click_nx.ads/www.rediffmail.com/signatureline.htm@Middle?" target="_blank"><IMG SRC="http://sigads.rediff.com/RealMedia/ads/adstream_nx.ads/www.rediffmail.com/signatureline.htm@Middle"></A>