[mapserver-users] POINT layer from simple x, y table: Segmentation fault

[Sebastian E. Ovide]

On Tue, Nov 16, 2010 at 10:37 AM, Rahkonen Jukka
<Jukka.Rahkonen at mmmtike.fi>wrote:

>  Hi,
>
> No idea exactly about this, but if you manage to get 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
> http://mapserver.org/input/vector/oracle.html
>
> 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.
>
> -Jukka Rahkonen-
>

Actually I have just convinced the DBA to add a column... ;)


>
>
>  ------------------------------
> *Lähettäjä:* mapserver-users-bounces at lists.osgeo.org [mailto:
> mapserver-users-bounces at lists.osgeo.org] *Puolesta *Sebastian E. Ovide
> *Lähetetty:* 16. marraskuuta 2010 12:14
> *Vastaanottaja:* mapserver-users at lists.osgeo.org
> *Aihe:* [mapserver-users] POINT layer from simple x,y table: Segmentation
> fault
>
>  Hi All,
>
> I've created a POINT layer:
>
>   LAYER
>     NAME POLICY
>     TYPE POINT
>     EXTENT 54225.000000 5800.000000 655625.000000 1220325.000000
>     STATUS ON
>     CONNECTIONTYPE OGR
>     CONNECTION "OCI:la001/la001 at 192.168.60.70/MFUATDB"
>     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"
>     PROJECTION
>       "init=epsg:27700"
>     END
>     CLASS
>       STYLE
>         SYMBOL "star"
>         COLOR 255 0 0
>         SIZE 10
>       END
>     END
>   END
>
> and this is what I'm getting in apache logs:
>
> OGR: OGROpen(OCI:la001/la001 at 192.168.60.70/MFUATDB/0xa194160) succeeded as
> OCI.
> 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)
> 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)
> [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"
> [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)
>
>
> any ideas ?
> --
> Sebastian E. Ovide
>
>
>


-- 
Sebastian E. Ovide
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20101116/47199fa7/attachment.html