Hi,
SDO_GEOM_METADATA must match your data. SRID in the metadata table must be the
same than SRID that is used for storing the geometries. If you really want to
set geometries in data to null you must:
- drop the spatial index
- update all the geometries to have SRID=null
- update the line in SDO_GEOM_METADATA to have SRID=null
- create a new spatial index.
However, Geoserver works also if you use a real SRID for geometries and the
same value in SDO_GEOM_METADATA. I am not sure if Geoserver supports the
native Oracle SRID numbering system or if you need to use EPSG codes. We are
using EPSG codes in our system.
-Jukka Rahkonen-
________________________________
Lähettäjä: 王震阳 [mailto:[email protected]]
Lähetetty: 11. lokakuuta 2010 12:21
Vastaanottaja: [email protected]
Aihe: [Geoserver-users] Difficulty in Using Oracle Spatial
Hello,
I have two questions:
1. I have some data in Oracle Spatial, but I can't see these tables
from GeoServer when I try to add this layer. Finally I think this is because
GeoServer can't handle the tablenames starting with "SDO" because I can see
other tables with other table names.
2. I import some data by Manifold 8, but I can't display the data
correctly. The line features are displayed as points. I have created spatial
index by the following script:
----
CREATE INDEX LINK_COPY_spatial_idx
ON LINK_COPY(geom)
iNDEXTYPE IS MDSYS.SPATIAL_INDEX
PARAMETERS ('layer_gtype=LINE');
----
I think this may because of the SDO_SRID value in
mdsys.sdo_geom_metadata_table because I can correctly display data imported by
shp2sdo and these data has null in mdsys.sdo_geom_metadata_table.SDO_SRID
column.
Then I just update the value of mdsys.sdo_geom_metadata_table.SDO_SRID
to null, but when I try to create a spatial index, I receive:ORA-13365: layer
SRID does not match geometry SRID.
Does anybody know how to put the projection in oracle to null?
Regards,
Wang Zhenyang
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
