<br><br><div class="gmail_quote">On Tue, Nov 16, 2010 at 10:37 AM, Rahkonen Jukka <span dir="ltr"><<a href="mailto:Jukka.Rahkonen@mmmtike.fi">Jukka.Rahkonen@mmmtike.fi</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div>
<div dir="ltr" align="left">
<div dir="ltr" align="left"><span></span><font face="Arial"><font color="#0000ff"><font size="2">H<span>i,</span></font></font></font></div>
<div><font color="#0000ff" size="2" face="Arial"><span></span></font> </div>
<div><span><font color="#0000ff" size="2" face="Arial">No
idea exactly about this, but if you manage to <span>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><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></span></font> </div>
<div><font color="#0000ff" size="2" face="Arial"><span>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></span></font> </div>
<div><span></span><font color="#0000ff" size="2" face="Arial"><span>-Jukka
Rahkonen-</span></font></div></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"></font></div></div></blockquote><div><br></div><div>Actually I have just convinced the DBA to add a column... ;) </div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div><div dir="ltr" align="left"> </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" align="left">
<hr>
<font size="2" face="Tahoma"><b>Lähettäjä:</b>
<a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a>
[mailto:<a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a>] <b>Puolesta </b>Sebastian E.
Ovide<br><b>Lähetetty:</b> 16. marraskuuta 2010 12:14<br><b>Vastaanottaja:</b>
<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br><b>Aihe:</b> [mapserver-users] POINT layer
from simple x,y table: Segmentation fault<br></font><br></div><div><div></div><div class="h5">
<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" target="_blank">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" target="_blank">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></div></div></blockquote></div>
</blockquote></div><br><br clear="all"><br>-- <br>Sebastian E. Ovide<br><br><br><br><br>