Selecting Data from a StreetPro Table - MapInfo_Pro - 2023

If you are using MapInfo Pro StreetPro products, you may want to create a separate layer of just the highway data. The following selection demonstrates a typical selection of highways.

1. On the HOME tab, in the File group, from the Open list, click Table. Select your StreetPro file. In this example, the table name is NYSHCHES.TAB.
2. On the TABLE tab, click SQL Select. Fill in the SQL Select dialog box.
   • Select Columns: *
   • from Tables: NYSCHES
   • where Condition: Class = ANY("A10", "A11", "A12", "A13", "A14", "A15", "A16", "A17", "A18")
   • into Table Named: HIGHWAYS

   This will create a new table called HIGHWAYS that contains all the primary roads contained in the StreetPro NYSCHES table.

3. On the HOME tab, click Save Copy As and save the HIGHWAYS table. The HIGHWAYS table can be added to your map as a separate layer.
   Note: The above SQL Select statement selects all of the primary roads as defined by the CFCC codes. To determine the class of the streets that you want to select, use the Info command on a few of the streets that you want to select, or refer to your StreetPro documentation for explanations of the classes.