There are instances where the street name of streets that share a common name may need to be updated. Change the reference number of the segments that need to reflect a new name using the following procedure:
- Open the Geocode2 table (SSGeocode2 for the particular State) in a browser window, and the Geocode1 table (SSGeocode1 for the particular State) in a Map window.
- Determine if the new name for the group of streets already exists in the
Geocode2 table. By clicking Query > SQL Select and
selecting all records where Name = yourstreet.
- If no records are returned, a new record needs to be added to the Geocode2 table. Proceed to step 3.
- If a record are returned by the query, note the MI_Refnum. Use this MI_Refnum for the group of streets that to be selected and proceed to Step 5.
- Click on the title bar of the Geocode2 Browser window to make it active. Add a new record to the Geocode2 table from the Edit menu by clicking New Row.
- Type the new street name into this empty record. The new street name needs a corresponding MapInfo Pro reference number to associate it with the street segments. Type in a unique reference number, for example 900000. (We suggest that you start labeling new names with this number because such a strategy will easily enable you to differentiate between new and old reference numbers. Add any additional reference numbers sequentially.) Use this number as the MI_Refnum for the street segments that you will select in Step 5.
- Click on the title bar of the Geocode1 Map window to make it active. Using the Select tool, click on all of the segments that you want to rename.
- From the Window menu, select New Browser Window, and open the selection table.
- Click on the title bar of the selection table in Browser window. Click in the MI_Refnum column of each selected record and change the MapInfo Pro reference number to the MI_Refnum that you determined in Step 2 or the MI_Refnum that you added in Step 4. With the Geocode2 Browser window active, select Save Table from the File menu to retain your changes.