Re: [mapserver-users] [EXTERNAL] Layer with point from X and Y columns in

[Jakub Štambachr]

Mike, 

 

thank you for your  help, works like a charm.

 

Jakub

 

From: Smith, Michael ERDC-RDE-CRREL-NH [mailto:michael.sm...@erdc.dren.mil] 
Sent: Thursday, March 13, 2014 12:01 PM
To: Jakub Štambachr; mapserver-users@lists.osgeo.org
Subject: Re: [EXTERNAL] [mapserver-users] Layer with point from X and Y
columns in

 

Jakub,

 

What you have to do is disable the use of the spatial index (since you are
defining this on the fly, there will be no index). 

 

DATA "shape FROM (select MDSYS.SDO_GEOMETRY(2001, NULL,
MDSYS.SDO_POINT_TYPE(table.x, table.Y, NULL), NULL, NULL) AS shape from
table)" USING NONE

 

See  
http://mapserver.org/input/vector/oracle.html#using-none for details.

 

Mike

 

-- 

Michael Smith

US Army Corps

Remote Sensing GIS/Center

 

 

From: Jakub Štambachr 
Date: Thursday, March 13, 2014 at 5:39 AM
To: "mapserver-users@lists.osgeo.org" 
Subject: [EXTERNAL] [mapserver-users] Layer with point from X and Y columns
in
Resent-From: Michael Smith 

 

Hi,

 

I have table in Oracle Database that contains points specified by columns X
and Y (The table also contains SDO_Geometry column but it's not always
filled with data and I'm not at liberty to modify the table). 

 

My question is: Is it possible to specify layers with point using the
columns X and Y?

 

So far I have something like this and I need an alternative to replace the
DATA 

 

TYPE POINT

CONNECTIONTYPE oraclespatial

 

CONNECTION "isypoo/password@orcl"

DATA "shape FROM (select table.shape as SHAPE from table)"  

 

I tried the following:

 

DATA "shape FROM (select MDSYS.SDO_GEOMETRY(2001, NULL,
MDSYS.SDO_POINT_TYPE(table.x, table.Y, NULL), NULL, NULL) AS shape from
table)"

 

But got the following error:

 

msDrawMap(): Image handling error. Failed to draw layer named 'mosty'.

msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error: ORA-13226:
interface not supported without a spatial index

 

Is there any other way of doing this without modifying the database?

 

Thank you for your help,

 

Jakub

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] [EXTERNAL] Layer with point from X and Y columns in

[Smith, Michael ERDC-RDE-CRREL-NH]

Jakub,

What you have to do is disable the use of the spatial index (since you are 
defining this on the fly, there will be no index).

DATA "shape FROM (select MDSYS.SDO_GEOMETRY(2001, NULL, 
MDSYS.SDO_POINT_TYPE(table.x, table.Y, NULL), NULL, NULL) AS shape from table)” 
USING NONE

See http://mapserver.org/input/vector/oracle.html#using-none for details.

Mike

--
Michael Smith
US Army Corps
Remote Sensing GIS/Center


From: Jakub Štambachr mailto:stamb...@gmail.com>>
Date: Thursday, March 13, 2014 at 5:39 AM
To: "mapserver-users@lists.osgeo.org" 
mailto:mapserver-users@lists.osgeo.org>>
Subject: [EXTERNAL] [mapserver-users] Layer with point from X and Y columns in
Resent-From: Michael Smith 
mailto:michael.sm...@usace.army.mil>>

Hi,

I have table in Oracle Database that contains points specified by columns X and 
Y (The table also contains SDO_Geometry column but it’s not always filled with 
data and I’m not at liberty to modify the table).

My question is: Is it possible to specify layers with point using the columns X 
and Y?

So far I have something like this and I need an alternative to replace the DATA

TYPE POINT
CONNECTIONTYPE oraclespatial

CONNECTION "isypoo/password@orcl"
DATA "shape FROM (select table.shape as SHAPE from table)"

I tried the following:

DATA "shape FROM (select MDSYS.SDO_GEOMETRY(2001, NULL, 
MDSYS.SDO_POINT_TYPE(table.x, table.Y, NULL), NULL, NULL) AS shape from table)"

But got the following error:

msDrawMap(): Image handling error. Failed to draw layer named 'mosty'.
msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error: ORA-13226: 
interface not supported without a spatial index

Is there any other way of doing this without modifying the database?

Thank you for your help,

Jakub
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users