Creating Points for Intersections - MapInfo_Pro - 2023

Many people working with street files are often interested in information that is located at intersections. For some, their only concern is the intersections. In MapInfo Pro you can geocode to intersections in your street file with the Geocode command, but it would be easier to work with a table that contained only intersections. For example, a municipality is interested in tracking the types of traffic control devices at each street intersection. It would be beneficial for them to make an entire layer that contains the intersection of every street.

To create points for every intersection in your table:

1. On the HOME tab, in the File group, on the Open list, click Table, and open your street file.
2. Make two copies of the street file and give each copy a new name by clicking Save Copy As on the HOME tab.
3. Repeat Step 2 and save the file under a different name.
4. On the HOME tab, in the File group, on the Open list, click Table, and open the two files that you created.
5. On the HOME tab, in the the Selection group, click SQL Select, and fill in the following SQL Select statement. This query matches the two street files against each other where the streets intersect and are not the same named street.
   • Select Columns: Streets1.StreetName + “&&” + Streets2.StreetName
   • from Tables: Streets1, Streets2
   • where Condition: Streets1.obj Intersects Streets2.obj And Streets1.StreetName <> Streets2.StreetName
   • into Table Named: Intersect
   • Select the Browse Results check box.
   • Select the Find Results In Current Map Window check box.
6. On the HOME tab, in the File group, click Save Copy As, and save the resulting table.
7. Open the newest table and ungeocode it.
8. On the TABLE tab, in the Maintenance group, click Table, and Modify Structure. Clear the Table Is Mappable check box.
9. Geocode the unmapped table to one of the copies of the street file. You may have duplicate points at the same location if a street intersects another of the same name more than once.

You can review directions for extracting longitude and latitude from a geocoded table Extracting Latitude and Longitude into a New Table. For more about querying and selecting data, see Selecting and Querying Data.