[GIS] How to save (Commit) a temporary table in Mapinfo

mapinfo

I tried the following:

Commit Table Query1 As "C:\Temp\XYZ.TAB" TYPE Query Interactive

It does not work.

Best Answer

Try like this:

Commit Table Query1 As "C:\Temp\Query1.TAB" TYPE NATIVE Interactive

Related Solutions

[GIS] Copying objects to existing records in MapInfo

How about running an SQL join:

select tab1.attr1, tab1.attr2
from tab2, tab1
where Tab1.Site_ref = Tab2.Site_ref
into q_ToSave

commit table q_ToSave as "C:\NewTable.tab"

This works.

If Tab1 doesn't have objects in it then the order of the tables in the from clause is not important, but if there are objects in tab1 to be replaced, then specifying tab2 first in the list will ensure that the tab2 objects are saved in NewTable

An alternative using undocumented behaviour (including a second object column in a query) is to do the following. This requires that Tab1 is already mappable, and Tab1 must be first in the from clause list:

select tab2.obj "Tab2Obj"
from tab1, tab2
where Tab1.Site_ref = Tab2.Site_ref
into q_ToSave

update q_ToSave set obj = Tab2Obj

This should directly overwrite the objects in Tab1 where the join is true.

[GIS] Convert MapInfo .TAB to Latitude and Longitude Points

OGR will read mapinfo files, and export to virtually any format you can imagine. You may want to try that first.

Best Answer

Related Solutions

[GIS] Copying objects to existing records in MapInfo

[GIS] Convert MapInfo .TAB to Latitude and Longitude Points

Related Question