Easyloader is used to load a TAB file into Oracle Spatial. There is also a command line utility, or easyloader run from command line, but I would recommend EasyLoader for starters.
You will not see the "features" loaded, only a status bar. Display of features while they are loaded would require excessive overhead (connect time) and generally slow down the process as it would have to performed through SQL inserts, not through a batch load process. This would slow down the load and you would also have the read overhead to send the record to MapX or MI Pro. There are some other implications I won�t go into here. Once the data is loaded into Oracle Spatial there are a number of spatial functions you can use to display the data in MapX or MIPro. Some examples: SDO_GEOM.VALIDATE_GEOMETRY is a function to test the topology of each feature. This function can be used to "flag" bad topology and handle that set of features as a group. Another thing I like to do is create a table of "AOI" area of interest. These can be irregular polygons, or a set of tiles. You can then use SDO_GEOM.SDO_RELATE or SDO_FILTER to extract features for the area of interest, making the dataset manageable and helping to organize any kind of Q/A process. There are additional functions in the MapInfo Oracle extensions (SpatialWare) that can be used to perform more in-depth interrogation of geometries, and perform topology manipulation to "fix" features. Speaking of Q/A, as a practice I like to add "Q/A flags" to my table structures so that as data is checked and edited it can be tracked. The flags can be set while editing the data, in batch modes, or through triggers in the database. Another strategy you can use is to load the TAB data into a "temporary" table, display it from there, make any necessary modifications, and then move the data to the real target table, and delete the temporary table when you are done. In this manner you can create any number of temporary tables where the data is loaded and then manipulated via Oracle SQL commands, then loaded into a final destination table. Load hints: 1) If you are loading multiple TAB files into a single table make sure you do some Q/A on the TAB table structure first. Make sure all attribute names are consistent (name, data type, length, etc) 2) Make sure the TAB files have the same, identical, coordinate system. Set the coordinate system in MI Pro as you Q/A the TAB files, and remember "longitude latitude" is not a coordinate system, it must also identify the datum eg:NAD 83..bla bla bla. -----Original Message----- From: Javier Quispe [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 09:21 AM To: Lista MapInfo Ingles Subject: MI-L Read of format Oracle Spatial from MapInfo Greetings A consultation, somebody has worked loading objects in format Oracle Spatial from MapInfo, and a way of seeing it through the control MapX. Initially one has a layer in format TAB and we want to pass it to format Oracle Spatial, for then to be loaded from any PC enabled with MapInfo and visualized as reading from an application with MapX. Can somebody help me in this respect? Also somebody has information of as converting format information MapInfo to Oracle Spatial Javier Quispe ---------------------------- Proyecto Especial Titulaci�n de Tierras y Catastro Rural http://www.pett.gob.pe ---------------------------- --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7251 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7270
