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
