Hej Owen, The tool you are refering to has been made. I made this tool called MapCutter a couple of years ago and it lets you select a number of layers from the active map window. Then you can select the area to cut with (the extension of the map window or a selected region, even multiple regions are supported) You also get to choose how to select the objects within the region (within, partly within, entirely within) Now you have to choose if you want to cut the objects if the reach outside the cutting region (cut all objects, cut all line objects, cut none) Ater this you'll have to set up how to save the resulting objects (in a single table, in multiple tables ...) and furthermore you can decide which columns to take along (all, all common, chosen columns, none, column with the name of the original layer) And finally you just have to wait. MapCutter is a tool for sale, and eventhogh we mostly sell to Danish companies, and therefor make our software is Danish, It's possible to get this tool in English as well. If you are interested send me a mail. *************************** Regarding your questions towards large tables, I'll have to say that I haven't tested this application on so large as you descripe here. But a hint for you using spatial SQL is that if you are setting up mulitple conditions in the where clause, allways put the spatial condition first. Another way of optimizing the SQL select is to avoid highlighting the objects whenever possible. Allways use Select .... Into MYSEL NoSelect The NoSelect keywords prevents MapInfo from highlighting the records, and this also saves some time. Wrong: Select * from MYTABLE where ZIP > 1000 and OBJ WithIn oBorderRegion Into TheSelectedObjects NoSelect Right: Select * from MYTABLE where OBJ WithIn oBorderRegion And ZIP > 1000 Into TheSelectedObjects NoSelect Peter ------------------------------------------------------------------------------------------------ Peter Horsb�ll M�ller, GIS-Developer Kampsax A/S, GIS Software & Solutions, Rugaardsvej 55, DK-5000 Odense, Denmark tlf: + 45 63 13 50 13, dir: + 45 63 13 50 08, fax: + 45 63 13 50 90 mail: [EMAIL PROTECTED], http://www.mapinfo.dk, http://www.kampsax.dk ------------------------------------------------------------------------------------------------ Peter M�ller Til: Peter M�ller/Kampsax@Kampsax 01-06-01 cc: 08:10 Vedr.: MI-L MI Export All layers on screen to single DXF file ------------------------------------------------------------------------------------------------ Peter Horsb�ll M�ller, GIS-Developer Kampsax A/S, GIS Software & Solutions, Rugaardsvej 55, DK-5000 Odense, Denmark tlf: + 45 63 13 50 13, dir: + 45 63 13 50 08, fax: + 45 63 13 50 90 mail: [EMAIL PROTECTED], http://www.mapinfo.dk, http://www.kampsax.dk ------------------------------------------------------------------------------------------------ ----- Videresendt af Peter M�ller/Kampsax - 01-06-01 08:08 ----- [EMAIL PROTECTED] Sendt af: Til: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: onsmag.com Vedr.: MI-L MI Export All layers on screen to single DXF file 31-05-01 15:39 Besvar venligst til owendavid Hi Mappers I am trying to find a way of exporting multiple tables to one dxf file automatically. Basically I have a user who wants to be able to draw a shape on screen (rectangle, circle or polygon) and then export all the objects from the map that fall within the shape to one dxf file. The objects will be on multiple layers and will also be from very large tables (300 - 400 meg) I have tried writing various routines in MapBasic but am struggling with performance - using 'Select' to evaluate whether object A contains object B takes too long as the tables are so big. So........ does anyone know of a way another way of achieving this - maybe by programatically controlling the marquee select tool? Or is there another, more simple way of cracking the problem. Many thanks Owen Analyst Programmer UK _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body. _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
