Pitney Bowes MapInfo Professional - Manual (Page 497)

character sets, you can determine the correct syntax for your character set by exporting a table and
examining the .MIF file in a text editor.
Delimiter
Specify the delimiting character in quotation marks, for example:
DELIMITER ";"
The default delimiter is Tab; if you are using the default, you do not need the DELIMITER line.
Unique
Specify a number. This number refers to a database column; 3 is the third column, 7 is the seventh
column, and so forth. What happens to columns in the UNIQUE list is subtle. For example, imagine that
you have a database with highways in it. Each highway has only one name, but it might be represented
by several segments. You would put the NAME column in the UNIQUE list, while the column containing
data for the individual segments would not be in that list. This has the effect of creating two related tables;
one with names, and one with the other attributes of the objects. This is how Pitney Bowes Software
Inc.'s various street maps (StreetPro) are prepared.
Index
To indicate that columns in the table are indexed, include a number (or a comma-separated list of
numbers) in the Index clause. Each number refers to a database column; 3 is the third column, 7 is the
seventh column, and so forth. Columns in the INDEX list will have indexes prepared for them.
CoordSys Clause
Specify the COORDSYS clause to note that the data is not stored in longitude/latitude form. When no
COORDSYS clause is specified, data is assumed to be stored in longitude/latitude form.
All coordinates are stored with respect to the northeast quadrant. The coordinates for points in the United
States have a negative X while coordinates for points in Europe (east of Greenwich) have a positive X.
Coordinates for points in the Northern hemisphere have a positive Y while coordinates for points in the
Southern hemisphere have a negative Y.
Syntax1
CoordSys Earth
[ Projection type,
datum,
unitname
[ , origin_longitude ]
[ , origin_latitude ]
[ , standard_parallel_1 [ , standard_parallel_2 ] ]
[ , azimuth ]
[ , scale_factor ]
[ , false_easting ]
[ , false_northing ]
[ , range ] ]
[ Affine Units unitname, A, B, C, D, E, F ]
[ Bounds ( minx, miny) ( maxx, maxy ) ]
Syntax2
CoordSys Nonearth
[ Affine Units unitname, A, B, C, D, E, F ]
Units unitname
Bounds ( minx, miny ) ( maxx, maxy )
497 MapInfo Professional User Guide
Appendix D: MapInfo Map Interchange Format