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.
