Columns – Pitney Bowes MapInfo Professional User Manual

Page 499

Advertising
background image

To transform quadrant 2 data into quadrant 1 data, use the following transform clause:

TRANSFORM -1,0,0,0

The zeroes instruct MapInfo Professional to ignore that parameter.

When you have an application which creates MIF files in quadrant 2, you can:

• Add the TRANSFORM clause to the MIF files

• Change the application so that it creates coordinates in quadrant 1

• Change the application so that it adds a TRANSFORM clause to the MIF files

Columns

Specify the number of columns. Then, for each column, create a row containing the column name, the
column type, and, for character and decimal columns, a number to indicate the width of the field.

Field names cannot have spaces.

Note:

Valid column types are:

• char (width)

• integer (which is 4 bytes)

• smallint (which is 2 bytes, so it can only store numbers between -32767 and +32767)

• decimal (width,decimals)

• float

• date

• logical

This is an example of the columns section of the header:

COLUMNS 3
STATE char (15)
POPULATION integer
AREA decimal (8,4)

For the database specified in this header, the MID file has three columns:

• a 15 character field that represents the STATE column,

• an integer field that represents the POPULATION column,

• an AREA column that consists of a decimal field with up to 8 total characters (digits, decimals points,

and optional sign) and 4 digits after the decimal.

499

MapInfo Professional User Guide

Appendix D: MapInfo Map Interchange Format

Advertising