Haaaa thank you, I totally forgot the field SPATIALTYPE, I'm dumb ! Gonna try it
-----Original Message----- From: Peter Horsbøll Møller [mailto:[EMAIL PROTECTED] Sent: January 3, 2006 10:50 AM To: Gilbert, Antoine; Mapinfo-List (E-Mail) Cc: Samson, Réjean; Vachon, Patrick Subject: RE: [MI-L] mapinfo map catalog There is another place where you need to specify certain things. MapInfo.MapInfo_mapCatalog is MapInfos way to store information on spatial tables in database systems. Oracle has it's own way of doing this, namely thru the MDSYS.SDO_GEOM_METADATA_TABLE. Here is an example of a statement, that inserts information about a spatial table into this table: INSERT INTO MDSYS.SDO_GEOM_METADATA_TABLE (SDO_OWNER,SDO_TABLE_NAME,SDO_COLUMN_NAME,SDO_DIMINFO, SDO_SRID) VALUES ( 'PETER', 'BEST_SHOPS_IN_PROT_OF_SPAIN', 'GEO_LOCATION', MDSYS.SDO_DIM_ARRAY( MDSYS.SDO_DIM_ELEMENT('X',500000,900000,0.001), MDSYS.SDO_DIM_ELEMENT('Y',1000000,1400000,0.001)) ,82277); But another problem could be the SPATIALTYPE column in the MAPINFO.MAPINFO_MAPCATALOG. The value specified here can also prevent the user from inserting 2complex" spatial objects into the table. To use Oracles spatial datatype, you should specify: --- 13.0: Only Points --- 13.1: Only Lines --- 13.2: Only Regions/Polygons --- 13.3: Mixture of objecttypes is possible Peter Horsbøll Møller GIS Developer, MTM Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis > -----Original Message----- > From: Gilbert, Antoine [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 03, 2006 4:33 PM > To: Peter Horsbøll Møller; Mapinfo-List (E-Mail) > Cc: "Samson, Réjean"; Vachon, Patrick > Subject: RE: [MI-L] mapinfo map catalog > > I have a "sub question" > > We are creating our spatial table directly via sql, adding > the spatial metadata info and the entry in the catalog and > the creation of spatial index via sql. > > We are able to open the table in MapInfo and see our line > objects. But each time we try to modify and existing line > created outside of MapInfo it keep saying "Cannot upload > object - Line object type is not supported in this table". > How this can be solved? I don't see any place in Oracle I can > specify the object type beside in the mapcatalog, but When I > use easy loader to load a test line table, no type info is > added and I can edit all the line objects without any error... > > -----Original Message----- > From: Peter Horsbøll Møller [mailto:[EMAIL PROTECTED] > Sent: January 3, 2006 8:58 AM > To: Gilbert, Antoine; Mapinfo-List (E-Mail) > Cc: Samson, Réjean; Vachon, Patrick > Subject: RE: [MI-L] mapinfo map catalog > > Antoine, > > Your column names are wrong: > RENDITION_COLUMN VARCHAR2(32 BYTE), > RENDITION_TYPE VARCHAR2(32 BYTE), > RENDITION_TABLE VARCHAR2(32 BYTE), > > should be > RENDITIONCOLUMN VARCHAR2(32 BYTE), > RENDITIONTYPE VARCHAR2(32 BYTE), > RENDITIONTABLE VARCHAR2(32 BYTE), > > I'm not sure whether it matters but the documentation > specifies VARCHAR and not VARCHAR2 ?? > > Peter Horsbøll Møller > GIS Developer, MTM > Geographical Information & IT > > COWI A/S > Odensevej 95 > DK-5260 Odense S. > Denmark > > Tel +45 6311 4900 > Direct +45 6311 4908 > Mob +45 5156 1045 > Fax +45 6311 4949 > E-mail [EMAIL PROTECTED] > http://www.cowi.dk/gis > > > > -----Original Message----- > > From: Gilbert, Antoine [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, January 03, 2006 2:39 PM > > To: Peter Horsbøll Møller; Mapinfo-List (E-Mail) > > Cc: Vachon, Patrick; "Samson, Réjean" > > Subject: RE: [MI-L] mapinfo map catalog > > > > Hi > > > > Somehow this is not working on my Oracle database > > > > I wonder if my column type are wrong > > > > CREATE TABLE MAPINFO_MAPCATALOG > > ( > > SPATIALTYPE FLOAT(126), > > TABLENAME VARCHAR2(32 BYTE), > > OWNERNAME VARCHAR2(32 BYTE), > > SPATIALCOLUMN VARCHAR2(32 BYTE), > > DB_X_LL FLOAT(126), > > DB_Y_LL FLOAT(126), > > DB_X_UR FLOAT(126), > > DB_Y_UR FLOAT(126), > > COORDINATESYSTEM VARCHAR2(254 BYTE), > > SYMBOL VARCHAR2(254 BYTE), > > XCOLUMNNAME VARCHAR2(32 BYTE), > > YCOLUMNNAME VARCHAR2(32 BYTE), > > RENDITION_COLUMN VARCHAR2(32 BYTE), > > RENDITION_TYPE VARCHAR2(32 BYTE), > > RENDITION_TABLE VARCHAR2(32 BYTE), > > NUMBER_ROWS NUMBER(38) > > ) > > > > -----Original Message----- > > From: Peter Horsbøll Møller [mailto:[EMAIL PROTECTED] > > Sent: December 23, 2005 1:57 AM > > To: Gilbert, Antoine; Mapinfo-List (E-Mail) > > Cc: Vachon, Patrick; Samson, Réjean > > Subject: RE: [MI-L] mapinfo map catalog > > > > Antoine, > > > > If you specify 1 in column RENDITION_TYPE and enter the name of a > > column in your spatial table in column RENDITION_COLUMN > MapInfo will > > use the style from that column for the style. > > Changes to the style will also be written back to this coloum > > > > The third column RENDITION_TABLE is not used yet > > > > Peter Horsbøll Møller > > GIS Developer, MTM > > Geographical Information & IT > > > > COWI A/S > > Odensevej 95 > > DK-5260 Odense S. > > Denmark > > > > Tel +45 6311 4900 > > Direct +45 6311 4908 > > Mob +45 5156 1045 > > Fax +45 6311 4949 > > E-mail [EMAIL PROTECTED] > > http://www.cowi.dk/gis > > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of > > Gilbert, Antoine > > Sent: Thursday, December 22, 2005 8:37 PM > > To: Mapinfo-List (E-Mail) > > Cc: Vachon, Patrick; "Samson, Réjean" > > Subject: [MI-L] mapinfo map catalog > > > > > > Hi > > > > > > > > I have a table in oracle with a field RENDITION containing > values like > > for example "Line (2, 2, 0)" > > > > > > > > I want MapInfo to display the rendition for each line object. > > > > > > > > In the MapInfo Map Catalog, I can specify 3 fields : > > RENDITION_COLUMN, RENDITION_TYPE, RENDITION_TABLE > > > > > > > > Whatever I specify these 3 values, this is not working. > > > > > > > > Anyone ever tried to do what I'm trying? > > > > > > > > Antoine Gilbert > > > > _______________________________________________ > > MapInfo-L mailing list > > [email protected] > > http://www.directionsmag.com/mailman/listinfo/mapinfo-l > > > > > > > > > > > > > > _______________________________________________ > MapInfo-L mailing list > [email protected] > http://www.directionsmag.com/mailman/listinfo/mapinfo-l > > > > _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
