On Tue, Nov 19, 2013 at 2:09 PM, rkliao <rkl...@stoneorchardsoftware.com>wrote:
> Thanks for the reply.
>
> I have figured out the problem. It had to do with the creation of an entry
> in the ORACLE USER_SDO_GEOM_METADATA table in order to create the Spatial
> index.
>
> I originally set it to the ff (copied this off the web as I was not able to
> create spatial indexes without it):
>
> INSERT INTO USER_SDO_GEOM_METADATA
> VALUES (
> 'Geoserver_Cem000',
> 'the_geom',
> MDSYS.SDO_DIM_ARRAY( -- 20X20 grid, virtually zero tolerance
> MDSYS.SDO_DIM_ELEMENT('X', 0, 20, 0.005),
> MDSYS.SDO_DIM_ELEMENT('Y', 0, 20, 0.005)
> ),
> 4326 -- SRID
> );
>
> and have changed it to
>
> INSERT INTO USER_SDO_GEOM_METADATA
> VALUES (
> 'GEOSERVER_CEMDATA',
> 'THE_GEOM',
> MDSYS.SDO_DIM_ARRAY(
> MDSYS.SDO_DIM_ELEMENT('X', -180, 180, 0.005),
> MDSYS.SDO_DIM_ELEMENT('Y', -90, 90, 0.005)
> ),
> 4326 -- SRID
> );
>
>
> I am very new to Oracle spatial and am learning as I go. I am not even
> sure
> why the difference but it worked.
>
The issue is that Oracle cannot run the spatial filters used by GeoServer
(SDO_FILTER)
without a spatial index
Cheers
Andrea
--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
------------------------------------------------------------------------------
Shape the Mobile Experience: Free Subscription
Software experts and developers: Be at the forefront of tech innovation.
Intel(R) Software Adrenaline delivers strategic insight and game-changing
conversations that shape the rapidly evolving mobile landscape. Sign up now.
http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
