[mapserver-users] POINT layer from simple x, y table: Segmentation fault
Sebastian E. Ovide
sebastian.ovide at gmail.com
Tue Nov 16 14:29:12 PST 2010
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.htm>
More information about the MapServer-users
mailing list