Also see this page, which gives a good example of using the function-based
index technique:
http://gis.stackexchange.com/questions/92554/can-i-create-an-oracle-spatial-view-from-a-non-spatial-table
That page also mentions the possiblity of defining a *materialized view* on
the underlying table, which should be able to support a spatial index
directly.
On Wed, May 13, 2015 at 9:27 AM, Martin Davis <mtncl...@gmail.com> wrote:
> Have you tried creating a spatial function-based index on the table?
>
>
> http://docs.oracle.com/cd/E11882_01/appdev.112/e11830/sdo_exten.htm#SPATL799
>
> See the example 9.2.1 - it creates a function creating the geometry out of
> the X,Y values, and then uses that for indexing and querying. Hopefully
> it's possible to define a view hiding the existence of the function, but
> still using the spatial index. In this case, GeoServer might be able to
> query the view (using SDO_FILTER as per normal) and Oracle will support the
> query since it can use the index.
>
> Ironically, in my experience when working with tables containing XY data,
> it's at least as fast to simply use normal B-tree indexes and range
> queries. However, it doesn't sound like this can be made to work in
> GeoServer (yet...)
>
>
>
> On Wed, May 13, 2015 at 7:10 AM, Alper Dinçer <alperd....@gmail.com>
> wrote:
>
>> Hi,
>>
>> We have a table that includes X and Y columns for latitude and
>> longitudes. We created a view with geom column from this table as follows :
>>
>> (SDO_GEOMETRY(2001, 4326, SDO_POINT_TYPE (ST.Y, ST.X, NULL), NULL, NULL))
>>
>> Then we published this view from GeoServer and try to get the WMS
>> request.
>>
>> The WMS request has following error :
>>
>> <?xml version="1.0" encoding="UTF-8" standalone="no"?><!DOCTYPE
>> ServiceExceptionReport SYSTEM "
>> http://172.16.1.139:8084/geoserver/schemas/wms/1.1.1/WMS_exception_1_1_1.dtd";>
>> <ServiceExceptionReport version="1.1.1" > <ServiceException
>> code="internalError">
>> Rendering process failed
>> java.io.IOExceptionORA-13226: interface not supported without a spatial
>> index
>> ORA-06512: at "MDSYS.MD", line 1723
>> ORA-06512: at "MDSYS.MDERR", line 8
>> ORA-06512: at "MDSYS.SDO_3GL", line 88
>>
>> </ServiceException></ServiceExceptionReport>
>>
>> As far as I searched, this was a problem in Oracle 9, but we are working
>> on 11g.
>>
>> How can we get rid of this error? There was no luck with creating spatial
>> index on views.
>>
>>
>>
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
