Hi all, To reduce cost, the business wants to remove Oracle spatial licensing from a server which has an oracle database warehouse, which stores various spatial tables used by MapInfo. One thing we currently do is have a postcode (zipcode) table in the database which has a MDSYS.SDO_GEOMETRY field which contains the postcode polygon object, and then a number of other fields which summarise information at the postcode level for financial information such as sales per postcode. We have just received the latest Australian CData 2001 pack, which contains the new postcode boundaries.
What I want to be able to do is export the new postcode boundary data as a MapInfo table which contains the spatial co-ordinates of the polygon, and I also want to retain the database table "POSTCODES", so that I can do my month end processing and financial summations at the end of each month (without the spatial column). Ideally what I want to then do is merge the results of the Mapinfo table and database table, taking the spatial component from the mapinfo table, and the financial data from the database table, therefore creating me a layer of information with boundary information, and financial information - therefore eliminating the need for Oracle Spatial. I have attempted to do this, but when I select the mapinfo obj field in Query->SQL Select, the map window still shows point objects, when I really want polygon objects (so that I can do thematic mapping etc). Has anyone got any ideas, experiences or thoughts that could help shed some light on this? Thanks, Peter ********************************************************************** CONFIDENTIALITY NOTE: This e-mail is intended only for the use of the individual or entity named above and may contain information that is confidential and privileged. If you are not the intended recipient, you are hereby notified that any distribution, copying or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error or are not the named recipient, please notify us immediately by return e-mail or telephone +61 3 8517 7777 and destroy the original message. Thank you ********************************************************************** --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7427
