-- Steps to reproduce problem
CREATE TABLE GEOMS
(
id NUMBER(10,0) NOT NULL,
GEOMETRY SDO_GEOMETRY NOT NULL
);
INSERT INTO USER_SDO_GEOM_METADATA VALUES
(
'GEOMS', -- TABLE_NAME
'GEOMETRY', -- COLUMN_NAME
SDO_DIM_ARRAY -- DIMINFO attribute for storing dimension bounds, tolerance
(
SDO_DIM_ELEMENT
(
'LONGITUDE', -- DIMENSION NAME for first dimension
-180, -- SDO_LB for the dimension
180, -- SDO_UB for the dimension
0.5 -- Tolerance of 0.5 meters
),
SDO_DIM_ELEMENT
(
'LATITUDE', -- DIMENSION NAME for second dimension
-90, -- SDO_LB for the dimension
90, -- SDO_UB for the dimension
0.5 -- Tolerance of 0.5 meters
)
),
4326 -- SRID value for specifying a geodetic coordinate system
);
INSERT INTO GEOMS VALUES
(
'3',
SDO_GEOMETRY
(
2003, -- SDO_GTYPE format: D00T. Set to 2005 5 = Multipoint
4326, -- SDO_SRID
NULL, -- SDO_POINT attribute set to NULL
SDO_ELEM_INFO_ARRAY -- SDO_ELEM_INFO attribute (see Table 4-2 for values)
(
1, -- Offset is 1
1003, -- For polygons, the element-type is 1003 (the T value in SDO_GTYPE is 3).
1 -- For line strings and polygons, the interpretation is 1 if the connectivity is by straight lines
),
SDO_ORDINATE_ARRAY -- SDO_ORDINATES attribute
(
-77.04487, 38.9043742, -- coordinates of first vertex
-77.046645, 38.9040983, -- other vertices
-77.04815, 38.9033127,
-77.049155, 38.9021368,
-77.049508, 38.9007499,
-77.049155, 38.899363,
-77.048149, 38.8981873,
-77.046645, 38.8974017,
-77.04487, 38.8971258,
-77.043095, 38.8974017,
-77.041591, 38.8981873,
-77.040585, 38.899363,
-77.040232, 38.9007499,
-77.040585, 38.9021368,
-77.04159, 38.9033127,
-77.043095, 38.9040983,
-77.04487, 38.9043742 -- coordinates of last vertex same as first vertex
)
)
);
SELECT SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(a.geometry, 0.5)
is_valid
FROM GEOMS a
WHERE a.id=3;
Returns TRUE;
CREATE INDEX MESSAGE_GEOMS_GEOMETRY ON GEOMS
(
"GEOMETRY"
)
INDEXTYPE IS "MDSYS"."SPATIAL_INDEX" ;
CREATE OR REPLACE FORCE VIEW GEOMS_LAYER ("ID", "GEOMETRY")
AS
SELECT geoms.id, geoms.GEOMETRY AS geometry
FROM geoms
WHERE
geoms.id != 0;
When I create the layer the Native SRS isn't populated by default. So I hand-jam into the Declared SRS
to EPSG:4326.
I set both Bounding Boxes to -180 -90 180 90 and save.
This returns the record.
http://localhost:8080/geoserver/wfs?request=GetFeature&typeName=GEOMS_LAYER&maxFeatures=10
This explodes...
GEOMETRY
-180 -90
180 90
EXCEPTION TEXT!
-
-
java.lang.RuntimeException: java.io.IOException
java.io.IOException
null
ORA-29902: error in executing ODCIIndexStart() routine
ORA-13208: internal error while evaluating [window SRID does not match layer SRID] operator
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 286