If the data and geometry is within an Oracle Spatial table simply read "select" all the data from the table into MI Pro. Save the layer as a new table. You might want to "unlink" the tables and check to make sure the coordinates system is correct first.
Depending upon the size of the table this may take some time. A consideration you might make is organizing the data into several TAB files by selecting with a where condition on an attribute and/or the geometry. For example if there is an attribute that identifies a set of post codes as being in "Queensland" you could select using that condition and save the objects and attributes into a "Queenslandpost" TAB. This may or may not be an advantage to you, just a suggestion. You can merge the TAB files and Oracle postcode table using the "join" methods for connecting the two tables as you would with any set of tables where one contains geometry and the other attributes. You will need to use the primary key to perform the join such as the postcode value. I don't understand how you get point objects? If the data in the Oracle table is polygon then the results in MI Pro should yield polygons. What is the full query you are using? If you have a set of geocoded addresses (points) that you are summarizing the statistics for you must first create a summary table that has the statistical results (sum's avg's, medians, etc) grouped by postal code. This summary table is then joined with the postal code table. It's too bad you can't use Oracle Spatial, negotiate a better deal. You will spend a great deal of time / labor performing the new process (extracts and joins), and file management overhead outside the database that can currently be performed via a SQL statement within Oracle. You will need to manually keep track of the extra data files you are creating and organize them so you know what "version" you are joining. To reduce cost, and get the benefits of the database environment, you might consider using SQL Server and SpatialWare. This might not go well with your IT organization however. -----Original Message----- From: Peter Brown [mailto:[EMAIL PROTECTED] Sent: Monday, June 30, 2003 12:31 AM To: [EMAIL PROTECTED] Subject: MI-L Census and Oracle Spatial 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 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7438
