MI Selecting Subsets: Difference between revisions

Content deleted Content added

Revision as of 15:07, 5 September 2011 view source Ari Craven (talk \| contribs) 59 edits No edit summary ← Older edit		Latest revision as of 16:59, 5 September 2011 view source Ari Craven (talk \| contribs) 59 edits No edit summary
(3 intermediate revisions by the same user not shown)
Line 7: </li> [[File:Basic Select.png\|frame\|none]] </ol> <br> There will now be a temporary table called 'selection' which can be added to a map window opened in a new browser window. == SQL Select == <ol> <li>Import the 1d_nwk_check.mif layer into MapInfo. </li> <li>To select all channels of Type “C” (ie. pipes or circular culverts) go to Query, SQL Select… to display the dialog below. Click in the “from Tables:” field and use the “Tables” drop down list on the top right to select the 1d_nwk_check layer. Click in the “where Condition:” field and using the Columns drop down list select Type (or Channel_Type for older 1d_nwk_check layers) and complete the expression as per below: <br> Type = “C” <br> ensuring that quotes are placed around the C. Finally, for the “into Table Named:” field, instead of “Selection” enter “Pipes”. Use Verify to check your entries and press OK to select all circular culverts and place them in a virtual table (ie. a subset table of the 1d_nwk_check layer) called Pipes. </li> [[File:SQL Select.png\|frame\|none]]