<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18702"></HEAD>
<BODY>
<DIV dir=ltr align=left>
<DIV dir=ltr align=left><SPAN class=540422510-16112010></SPAN><FONT
face=Arial><FONT color=#0000ff><FONT size=2>H<SPAN
class=540422510-16112010>i,</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT color=#0000ff size=2 face=Arial><SPAN
class=540422510-16112010></SPAN></FONT> </DIV>
<DIV><SPAN class=540422510-16112010><FONT color=#0000ff size=2 face=Arial>No
idea exactly about this, but if you manage to <SPAN
class=953373610-16112010>get</SPAN> further I fear you will be banging your head
to the next wall because Mapserver won't get a spatial index from Oracle for
such a query. Adding "USING NONE" to the end of DATA should help then, see
</FONT><A href="blocked::http://mapserver.org/input/vector/oracle.html"><FONT
size=2
face=Arial>http://mapserver.org/input/vector/oracle.html</FONT></A></SPAN></DIV>
<DIV><FONT color=#0000ff size=2 face=Arial><SPAN
class=540422510-16112010></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff size=2 face=Arial><SPAN class=540422510-16112010>I
suppose you have some good reason for playing with x_coord and y_coord
columns instead of massaging them into a real physical SDO_GEOMETRY column
that could also be indexed with a spatial filter, for example going
through a materialized view way.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff size=2 face=Arial><SPAN
class=540422510-16112010></SPAN></FONT> </DIV>
<DIV><SPAN class=540422510-16112010></SPAN><FONT color=#0000ff size=2
face=Arial><SPAN class=540422510-16112010>-Jukka
Rahkonen-</SPAN></FONT></DIV></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2
face=Arial></FONT> </DIV><BR>
<BLOCKQUOTE
style="BORDER-LEFT: #0000ff 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV dir=ltr lang=fi class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>Lähettäjä:</B>
mapserver-users-bounces@lists.osgeo.org
[mailto:mapserver-users-bounces@lists.osgeo.org] <B>Puolesta </B>Sebastian E.
Ovide<BR><B>Lähetetty:</B> 16. marraskuuta 2010 12:14<BR><B>Vastaanottaja:</B>
mapserver-users@lists.osgeo.org<BR><B>Aihe:</B> [mapserver-users] POINT layer
from simple x,y table: Segmentation fault<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>
<DIV>Hi All,</DIV>
<DIV><BR></DIV>
<DIV>I've created a POINT layer:</DIV>
<DIV><BR></DIV>
<DIV> LAYER</DIV>
<DIV> NAME POLICY</DIV>
<DIV> TYPE POINT</DIV>
<DIV> EXTENT 54225.000000 5800.000000 655625.000000
1220325.000000</DIV>
<DIV> STATUS ON</DIV>
<DIV> CONNECTIONTYPE OGR</DIV>
<DIV> CONNECTION "OCI:la001/<A
href="http://la001@192.168.60.70/MFUATDB">la001@192.168.60.70/MFUATDB</A>"</DIV>
<DIV> DATA "Select match_level, x_coord, y_coord,
SDO_GEOMETRY(2001,27700,SDO_POINT_TYPE(x_coord, y_coord, NULL), NULL, NULL) as
point From policy"</DIV>
<DIV> PROJECTION</DIV>
<DIV> "init=epsg:27700"</DIV>
<DIV> END</DIV>
<DIV> CLASS</DIV>
<DIV> STYLE</DIV>
<DIV> SYMBOL "star"</DIV>
<DIV> COLOR 255 0 0</DIV>
<DIV> SIZE 10</DIV>
<DIV> END</DIV>
<DIV> END</DIV>
<DIV> END</DIV>
<DIV><BR></DIV>
<DIV>and this is what I'm getting in apache logs:</DIV>
<DIV><BR></DIV>
<DIV>OGR: OGROpen(OCI:la001/<A
href="http://la001@192.168.60.70/MFUATDB/0xa194160">la001@192.168.60.70/MFUATDB/0xa194160</A>)
succeeded as OCI.</DIV>
<DIV>OCI: ExecuteSQL(Select match_level, x_coord, y_coord,
SDO_GEOMETRY(2001,27700,SDO_POINT_TYPE(x_coord, y_coord, NULL), NULL, NULL) as
point From policy)</DIV>
<DIV>OCI: Prepare(Select match_level, x_coord, y_coord,
SDO_GEOMETRY(2001,27700,SDO_POINT_TYPE(x_coord, y_coord, NULL), NULL, NULL) as
point From policy)</DIV>
<DIV>[Tue Nov 16 10:06:31 2010] [error] [client 10.0.1.50] FastCGI: incomplete
headers (0 bytes) received from server "/home/gis/bin/mapserv"</DIV>
<DIV>[Tue Nov 16 10:06:31 2010] [warn] FastCGI: (dynamic) server
"/home/gis/bin/mapserv" (pid 1086) terminated due to uncaught signal '11'
(Segmentation fault)</DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV>any ideas ?</DIV>
<DIV>-- </DIV>
<DIV>Sebastian E. Ovide</DIV>
<DIV><BR></DIV>
<DIV><BR></DIV></DIV></BLOCKQUOTE></BODY></HTML>