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.
- After downloading your selected file from MAGIC, unzip the file.
- In MapInfo, use the Table/Import to import the data.
- 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.
- Save your Query using the File/Save Copy as command.
- Close your working files.
- Open the saved file.
- 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
- Change the Field names:
COL_1 to Street
LEFTADD1 to FromLeft
LEFTADD2 to ToLeft
RIGHTADD1 toFromRight
RIGHTADD2 to ToRight
- Change the Type:
LEFTADD1 from Character to Integer
LEFTADD2 from Character to Integer
RIGHTADD1 from Character to Integer
RIGHTADD2 from Character to Integer
- Index the Street field.
- Hit the OK button.
- Test your new file by using the Query/Find command. Enter a known address and check the accuracy.

