Hi,
Is your projection this one
http://epsg-registry.org/report.htm?type=selection&entity=urn:ogc:def:crs:EPSG::26910&reportDetail=short&style=urn:uuid:report-style:default-with-code&style_name=OGP%20Default%20With%20Code&title=26910
If it is, your bounds cover only 360 by 180 meters. Or do you use the native
Oracle SRID code, not EPSG?
-Jukka Rahkonen-
rkliao wrote:
> I had to do this again with another set of shapes and is ending up with
> Geoserver
> timing out even if I had created the indexes. Is there something else I
> might be
> missing?
>
> I create the metadata and indexes as follows:
>
> 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)
> ),
> 26910 -- SRID
> );
>
> CREATE INDEX GEOSERVER_CEMDATA_idx ON GEOSERVER_CEMDATA
> (the_geom) INDEXTYPE IS MDSYS.SPATIAL_INDEX;
>
>
> The only different is the SRID is now 26910 instead of 4326.
>
> Thanks.
>
>
>
>
> --
> View this message in context: http://osgeo-org.1560.x6.nabble.com/Oracle-
> Data-in-Geoserver-tp5089732p5132967.html
> Sent from the GeoServer - User mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
