Hi to Pablo, Gilbert & Ake, and Keith,
See if you can get a copy of "Oracle Spatial User's Guide and Reference Rel
9.2" (Part A96630-01).
This gives examples of how to get objects into Oracle Spatial using 9i's SQL
code. It does support circles, you just cannot load them as such from
MapInfo.
This is the code for a rectangle (sect 2.3.1):
INSERT INTO table VALUES( attribute1, attribute2,
MDSYS.SDO_GEOMETRY(
2003,
NULL,
NULL,
MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3)
MDSYS.SDO_ORDINATE_ARRAY(1,1 5,7)
)
);
To insert a circle, MDSYS.SDO_ORDINATE_ARRAY() needs 3 co-ordinates
from the circumference.
Ian
- - - - - - - - - - - - - - - - -
Ian Robertson,
Information Services,
Regeneration & Culture,
Leicester City Council, LE1 6ZG, UK.
T: +44 (0) 116 252 7230
F: +44 (0) 116 222 1091
E: [EMAIL PROTECTED]
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 14319
