On Tue, Nov 16, 2010 at 10:37 AM, Rahkonen Jukka <jukka.rahko...@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-boun...@lists.osgeo.org [mailto: > mapserver-users-boun...@lists.osgeo.org] *Puolesta *Sebastian E. Ovide > *Lähetetty:* 16. marraskuuta 2010 12:14 > *Vastaanottaja:* mapserver-users@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/la...@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/la...@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
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users