Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Question about 8.0.4 Spatial cartridge
We are designing a database that will hold x/y coordinate data for
street addresses in CAD drawing files. We plan on modeling the 'nodes'
in the CAD drawing files where the address is by storing it's x/y
coordinate. We are trying to decide whether using the spatial cartridge.
We are NOT storing the CAD entities in the database, only the X/Y coords
for street address locations (for example curb, house, text position in
cad file etc.). We have the spatial carttridge installed but have not
used it.
Currently we are considering designing relational tables that simpy hold x and y coords for the above items. Then the cad system will simply interpret this data. There is a possibility that CAD objects (map objects) will be stored in the database at a later phase. Would it be possible to reconfigure the stored (non-spatial) relational data (x/y coords) into the spatial cartridge if this does indeed happen at a later date or would it be a better idea to just use the spatial cartridge to hold this x/y point data now?
Any comments would be appreciated!
Ryan
--
![]() |
![]() |