How to geo-code in MapInfo using MAGIC Street files

The street files in MAGIC use the same variable names and sequence as the TIGER files from which they were derived. MAGIC converts data, but does little to edit or improve them. In order to do address matching or geo-coding using the Street files in MapInfo, you must first set them up in the way that MapInfo wants them. All of this should be done within MapInfo Ver. 3 or 4.

1. After downloading your selected file from MAGIC, unzip the file.
2. In MapInfo, use the Table/Import to import the data.
3. Use the Query/SQL Select to concatenate the FNAME and the FTYPE fields. Select the TABLE. Build an SQL statement in the COLUMNS Box to read FNAME+" "+FTYPE, LEFTADD1, LEFTADD2, RIGHTADD1, RIGHTADD2, CFCC and generate a Query.
4. Save your Query using the File/Save Copy as command.
5. Close your working files.
6. Open the saved file.
7. Use the Table/Maintenance/Table Structure to change the structure. You should now arrange the fields so that the table begins with FNAME and is in this order:
   FNAMEFTYPE
   LEFTADD1
   LEFTADD2
   RIGHTADD1
   RIGHTADD2
   CFCC
   
8. Change the Field names:
   COL_1 to Street
   LEFTADD1 to FromLeft
   LEFTADD2 to ToLeft
   RIGHTADD1 toFromRight
   RIGHTADD2 to ToRight
   
9. Change the Type:
   LEFTADD1 from Character to Integer
   LEFTADD2 from Character to Integer
   RIGHTADD1 from Character to Integer
   RIGHTADD2 from Character to Integer
   
10. Index the Street field.
11. Hit the OK button.
12. Test your new file by using the Query/Find command. Enter a known address and check the accuracy.