Oracle Spatial

thank you ur anwser was helpful !! when i try to access these tables from mapextreme here are the errors i get ..do i need to change the srids ? how could i do that?

 to my knowledge  to change srid .first i need to change the srid in the MDSYS.SDO_GEOMETRY  and then manually in the user_sdo_geom_metadata.


   could u help me with this ??

here is the error i got while i try to access europe_admin_geometry



java.lang.RuntimeException: Error rendering: Message=ORA-13226: Oberfläche ohne räumlicher Index nicht unterstützt
ORA-06512: in "MDSYS.MD", Zeile 1723
ORA-06512: in "MDSYS.MDERR", Zeile 8
ORA-06512: ine  "MDSYS.SDO_3GL", Zeile 336
 at com.mapinfo.mapxtreme.client.MapXtremeImageRenderer.c(Unknown Source)
 at com.mapinfo.mapxtreme.client.MapXtremeImage Renderer.toImage(Unknown Source)
 at com.mapinfo.beans.vmapj.de.a(Unknown Source)
 at com.mapinfo.beans.vmapj.de.end(Unknown Source)
 at com.mapinfo.mapxtreme.client.MapXtremeImag eRenderer.render(Unknown Source)
 at com.mapinfo.graphics.AsyncRenderer.run(Unknown Source)
 at java.lang.Thread.run(Unknown Source)




And the second errors with the table geometry are:
 
java.lang.RuntimeException: Error rendering: Message=ORA-29903: Fehler bei der Ausführung von Routine ODCIIndexFetch()
ORA-13236: Interner Fehler bei Verarbeitung von R-Baum: []
ORA-13236: Interner Fehler bei Verarbeitung von R-Baum: [Recursive fetch error]
ORA-29400: Data Cartridge-Fehler
ORA-00942: Tabelle oder View nicht vorhanden
 

 at com.mapinfo.mapxtreme.client.MapXtremeImageRenderer.c(Unknown Source)
 at com.mapinfo.mapxtreme.client.MapXtremeImage Renderer.toImage(Unknown Source)
 at com.mapinfo.beans.vmapj.de.a(Unknown Source)
 at com.mapinfo.beans.vmapj.de.end(Unknown Source)
 at com.mapinfo.mapxtreme.client.MapXtremeImage Renderer.render(Unknown Source)
 at com.mapinfo.graphics.AsyncRenderer.run(Unknown Source)
 at java.lang.Thread.run(Unknown Source)


waiting for answers !!

one more addition

first table europe was uploaded using mapinfo and has a srid 8307


geometry table the second one has a srid NULL

does anybody know why ?

  when i select distinct SRID from MDSYS.SDO_GEOMETRY column of a table i get null but when i select the SRID from user_sdo_geom_metadata for the same table i get the value 8265

??????????


SQL> select distinct g.shape.sdo_srid from geometry g;

SHAPE.SDO_SRID
--------------



SQL> select table_name ,srid from user_sdo_geom_metadata
  2  where table_name like '%GEOMETRY%';

TABLE_NAME                             SRID
-------------------------------- ----------
GEOMETRY                               8265

????????????????????????

What coordinate system is the geometry data actually in? Is it WGS84 (SRID=8307) or NAD83 (SRID=8265) or Cartesian (SRID=NULL)?

These are each different. You shouldn't just set the SRID arbitrarily - it has to represent the actual coordinate system of the data.

If you must, you can use update to force the SRID to whatever value you want it to be (e.g. update geometry g set g.geometry.sdo_srid=8265), I would strongly suggest ensuring the data is correct and valid NAD83 data before doing this though.

I suspect that if the geometry SRID is NULL, that means your data is Cartesian and hence incompatible with the data in the europe table.

The answer was what i was needing but do u know why ??

when i select distinct SRID from MDSYS.SDO_GEOMETRY column of a table i get null but when i select the SRID from user_sdo_geom_metadata for the same table i get the value 8265

??????????


SQL> select distinct g.shape.sdo_srid from geometry g;

SHAPE.SDO_SRID
--------------



SQL> select table_name ,srid from user_sdo_geom_metadata
 2  where table_name like '%GEOMETRY%';

TABLE_NAME                             SRID
-------------------------------- ----------
GEOMETRY                               8265

????????????????????????

The values are independently set: they are whatever you (or your application) has set them to.

The metadata isn't generated from the table data or vice-versa - you (or your application) insert them both seperately.

Similarly Oracle won't force you keep the two values in sync, although you won't be able to build a spatial index until they are the same.

You can either update them by hand in SQL if you're sure of the values they should be, or examine why your application and source data to see where the inconsitent values are coming from.

        I appricate for the help you are giving . well while i was trying to update the SRID of geometry table
i get the following error.. could u help me with updating srid and setting up index ?

SQL> update geometry g set g.shape.sdo_srid =8307;
update geometry g set g.shape.sdo_srid =8307
*
FEHLER in Zeile 1:
ORA-29877: Routine ODCIINDEXUPDATE nicht erfolgreich ausgef©úhrt
ORA-13037: SRIDs stimmen f©úr die beiden Geometrien nicht ©úberein
ORA-13037: SRIDs stimmen f©úr die beiden Geometrien nicht ©úberein
ORA-06512: in "MDSYS.SDO_INDEX_METHOD_9I", Zeile 319
ORA-06512: in "MDSYS.SDO_IDX", Zeile 16
ORA-06512: in "MDSYS.SDO_INDEX_METHOD_9I", Zeile 368

The geometry table already has a spatial index on it. You need to drop the index first before you update the SRIDs (as above, you cannot mix SRIDs in an index)

Don't forget to check your metadata SRID matches before you recreate the index though.

thanks a lot for all ur help !!

     well i got a srid 8307 for the table geometry.
i created a following index on it ..do u have a suggestion ??


CREATE INDEX geometry_idx
ON geometry(shape)
INDEXTYPE IS MDSYS.SPATIAL_INDEX;


laterz

thanks a lot for all ur help !!

     well i got a srid 8307 for the table geometry.
i created a following index on it ..do u have a suggestion ??


CREATE INDEX geometry_idx
ON geometry(shape)
INDEXTYPE IS MDSYS.SPATIAL_INDEX;


laterz