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
