Hi Folks, some time ago, somebody was asking why we have to maintain the tabel mapinfo.mapinfo_catalog when using Oracle Spatial with MapInfo as well as user_sdo_geom_metadata. For Oracle, the view user_sdo_geom_metadata holds information about the bounds etc of the spatial indexes.
So I tried to use a view Mapinfo_mapcatalog rather than a table that needs to be maintened. Every table with an entry in user_sdo_geom_metadata should automatically be mapable for mapinfo. Here are some ideas (to be run from sqlplus).The ugly long rows are needed to get the bounds out of the Oracle Diminfo-Object. Note that I am still interessted in the right Projection String if the data is in long/lag WGS 84 but in 10^-7 degree. I simply cant fit in the 'Transform' in there. Any comments appreciated. Regards Christof ---- connect mdsys/mdsys grant select on user_sdo_gem_metadata to public with grant option; connect mapinfo/mapinfo -- drop any existing matinfo_mapcatalog drop table mapinfo_mapcatalog; drop view mapinfo_mapcatalog; create view mapinfo_mapcatalog as select 13.3 AS SPATIALTYPE, table_name AS TABLENAME, user AS OWNERNAME, column_name AS SPATIALCOLUMN, (SELECT SDO_LB FROM THE(SELECT DIMINFO FROM user_sdo_geom_metadata b where a.table_name=b.table_name ) WHERE sdo_dimname='X' ) AS DB_X_LL, (SELECT SDO_LB FROM THE(SELECT DIMINFO FROM user_sdo_geom_metadata b where a.table_name=b.table_name ) WHERE sdo_dimname='Y' ) AS DB_Y_LL, (SELECT SDO_UB FROM THE(SELECT DIMINFO FROM user_sdo_geom_metadata b where a.table_name=b.table_name ) WHERE sdo_dimname='X' ) AS DB_X_UR, (SELECT SDO_UB FROM THE(SELECT DIMINFO FROM user_sdo_geom_metadata b where a.table_name=b.table_name ) WHERE sdo_dimname='Y' ) AS DB_Y_UR, 'NonEarth Units "in" Bounds (-2000000000,-2000000000) (2000000000,2000000000)' AS COORDINATESYSTEM, 'Symbol (35,0,12) Pen (1,2,0) Pen (1,2,0) Brush (2,16777215,16777215)' AS SYMBOL, 'NO_COLUMN' AS XCOLUMNNAME, 'NO_COLUMN' AS YCOLUMNNAME, 0 AS RENDITIONTYPE, null AS RENDITIONCOLUMN, null AS RENDITIONTABLE from user_sdo_geom_metadata a; grant select on mapinfo_mapcatalog to public; --- _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
