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

[Rahkonen Jukka]

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 <blocked::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-
 


________________________________

	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



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20101116/354e59ee/attachment.htm>