I am working with Oracle 9i Spatial. In a nutshell, it works well. Points and polygons are non problem. if you know oracle, you simply get a new column type (for geometry) and an new spatial index, as well as a number of spatial operatores to use with sql (such as intersect etc).
we are using ora spatial for bigger databases (eg 40 Gig) and it works ok. however, you need oracle knowledge and an ora admin. if you already have this, everything is fine. regards christof -----Urspr�ngliche Nachricht----- Von: Brown, Greg 8690 [SMTP:[EMAIL PROTECTED]] Gesendet am: Dienstag, 12. November 2002 11:53 An: [EMAIL PROTECTED] Betreff: MI-L Spatial database question Does anyone have any experience of Oracle 9i for storing, using spatial data? Particularly, I understand it is shipped with a component called Locator which carries some of the basic functionality from what was Spatial Cartridge. What I am looking to do is evaluate the spatial options between SQL Server + Spatialware or Oracle 9i for implementing a data warehouse. The requirement will be to store point data (Crimes etc) and polygon data (boroughs etc) and provide for geographic querying for non-MapInfo users. At present there is no requirement to edit any of the spatial data inside the database. any advice appreciated thanks Greg Brown Corporate Data Manager Information Services > Surrey Police HQ, Mount Browne, Sandy Lane, Guildford, GU3 1HG > Tel. 01483 48(2333) Fax. 01483 482374 > Email. [EMAIL PROTECTED] > > > > Internet communications are not secure and therefore Surrey Police does not accept legal responsibility for the contents of this message. This email and any attachments may be confidential. They may contain privileged information and are intended for the named addressee (s) only. They must not be distributed without our consent. If you are not the intended recipient, please notify us immediately and delete the message and any attachments from your computer, do not disclose, distribute, or retain this email or any part of it. Unless expressly stated, opinions in this email are those of the individual sender, and not of Surrey Police. We believe but do not warrant that this e-mail and any attachments are virus free. You must therefore take full responsibility for virus checking. Surrey Police reserves the right to monitor all email communications through their networks. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 4030
