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
