MI Selecting Subsets - Revision history

Anne.Kolega: /* Basic Select */ i.e.

2026-04-02T01:29:29Z

Basic Select: i.e.

← Older revision		Revision as of 11:29, 2 April 2026
Line 4:		Line 4:
	<ol>		<ol>
	<li>Import the 1d_nwk_check.mif layer into MapInfo. </li>		<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, 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” (i.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>		</li>
	[[File:Basic Select.png\|frame\|none]]		[[File:Basic Select.png\|frame\|none]]
Line 14:		Line 14:
	<ol>		<ol>
	<li>Import the 1d_nwk_check.mif layer into MapInfo. </li>		<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>		<li>To select all channels of Type “C” (i.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>
	Type = “C”		Type = “C”
	<br>		<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>		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 (i.e. a subset table of the 1d_nwk_check layer) called Pipes. </li>
	[[File:SQL Select.png\|frame\|none]]		[[File:SQL Select.png\|frame\|none]]

Emilie Nielsen at 01:42, 8 January 2026

2026-01-08T01:42:39Z

← Older revision		Revision as of 11:42, 8 January 2026
Line 19:		Line 19:
	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>		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]]		[[File:SQL Select.png\|frame\|none]]



			{{Tips Navigation
			\|uplink=[[MapInfo_Tips\| Back to MapInfo Tips]]
			}}

Ari Craven at 06:59, 5 September 2011

2011-09-05T06:59:11Z

← Older revision		Revision as of 16:59, 5 September 2011
Line 18:		Line 18:
	<br>		<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>		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]]

Ari Craven at 06:42, 5 September 2011

2011-09-05T06:42:05Z

← Older revision		Revision as of 16:42, 5 September 2011
Line 14:		Line 14:
	<ol>		<ol>
	<li>Import the 1d_nwk_check.mif layer into MapInfo. </li>		<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>
⚫	<li>
			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>

Ari Craven at 06:40, 5 September 2011

2011-09-05T06:40:01Z

← Older revision		Revision as of 16:40, 5 September 2011
Line 12:		Line 12:

	== SQL Select ==		== SQL Select ==
			<ol>
			<li>Import the 1d_nwk_check.mif layer into MapInfo. </li>
			<li>

Ari Craven at 05:10, 5 September 2011

2011-09-05T05:10:03Z

← Older revision		Revision as of 15:10, 5 September 2011
Line 7:		Line 7:
	</li>		</li>
	[[File:Basic Select.png\|frame\|none]]		[[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 ==		== SQL Select ==

Ari Craven at 05:07, 5 September 2011

2011-09-05T05:07:48Z

← Older revision		Revision as of 15:07, 5 September 2011
Line 5:		Line 5:
	<li>Import the 1d_nwk_check.mif layer into MapInfo. </li>		<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, 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” (ie. 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>

			[[File:Basic Select.png\|frame\|none]]

	== SQL Select ==		== SQL Select ==

Ari Craven at 05:05, 5 September 2011

2011-09-05T05:05:58Z

← Older revision		Revision as of 15:05, 5 September 2011
Line 1:		Line 1:
	== Introduction ==		== Introduction ==
	MapInfo offers two methods for selecting subsets of other tables; the basic ~~select~~ tool and the more powerful '~~sql~~ select'. This example illustrates how the pipes (Type = “C”) in a 1d_nwk_check.mif layer are selected.		MapInfo offers two methods for selecting subsets of other tables; the basic 'Select' tool and the more powerful 'SQL select'. This example illustrates how the pipes (Type = “C”) in a 1d_nwk_check.mif layer are selected.
	== Basic Select ==		== Basic 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, 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'.


	== SQL Select ==		== SQL Select ==

Ari Craven at 04:38, 5 September 2011

2011-09-05T04:38:11Z

← Older revision		Revision as of 14:38, 5 September 2011
Line 1:		Line 1:
	== Introduction ==		== Introduction ==
	MapInfo offers two methods for selecting subsets of other tables; the basic select tool and the more powerful 'sql select'. This example illustrates how the pipes (Type = “C”) in a 1d_nwk_check.mif layer are selected.		MapInfo offers two methods for selecting subsets of other tables; the basic select tool and the more powerful 'sql select'. This example illustrates how the pipes (Type = “C”) in a 1d_nwk_check.mif layer are selected.
			== Basic Select ==

			== SQL Select ==

Ari Craven: Created page with "== Introduction == MapInfo offers two methods for selecting subsets of other tables; the basic select tool and the more powerful 'sql select'. This example illustrates how the pi..."

2011-09-05T04:37:26Z

Created page with "== Introduction == MapInfo offers two methods for selecting subsets of other tables; the basic select tool and the more powerful 'sql select'. This example illustrates how the pi..."

New page

== Introduction ==
MapInfo offers two methods for selecting subsets of other tables; the basic select tool and the more powerful 'sql select'. This example illustrates how the pipes (Type = “C”) in a 1d_nwk_check.mif layer are selected.