MI Selecting Subsets: Difference between revisions

<li>To select all channels of Type “C” (iei.e. pipes or circular culverts) go to Query, Select… to display the dialog below. Ensure the correct table is selected in the 'Select Records from Table' drop down box. In the dialogue box type the following: Type = "C". Click 'OK'.

<li>To select all channels of Type “C” (iei.e. 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>

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 (iei.e. a subset table of the 1d_nwk_check layer) called Pipes. </li>