Custom Geographic Tables

 

This page discusses the Custom Geographic Tables created when MultiRate is used to generate territory definitions from latitude/longitude data. If user-defined territories are being used instead, see the User Defined Territories page.

 

There are four tables created when MultiRate Creates a Territory Column. The first table created is the Territory Table, which contains information about each territory, such as exposure, centroid, area, and other information used for calculations. The second table created is the Map Data Table, which contains a list of ZIP codes in the area of the original data and the territory which contains their centroids, and is used only for mapping Custom Geographic data. The third table created is the Map Polygon Table, which contains information defining a polygon outlining the area of the original data, and is used to create the Map Data Table and for applying territory definitions to other data. The final table created is the Parameters Table, which contains parameters used in the calculations. Continue reading for information on the layout of each of these four tables.

 

Territory Table

 

Table Name: TrainingTable_TerritoryColumnName

 

Territory Table Layout:

 

Field Name

Data Type

Explanation

TerritoryColumnName

int

The territory number.

Exposure

float

The total exposure contained in each territory.

Centroid_X

int

The X value of the centroid of the territory. (Different LatLon to XY mapping used for each dataset.)

Centroid_Y

int

The Y value of the centroid of the territory. (Different LatLon to XY mapping used for each dataset.)

Centroid_Lat

numeric

The latitude of the centroid of the territory.

Centroid_Lon

numeric

The longitude of the centroid of the territory.

Divide

int

Number code indicating if box has been divided or not (used for intermediate calculations).

Orig_Centroid_X

int

The X value of the centroid before division (used for intermediate calculations).

Orig_Centroid_Y

int

The Y value of the centroid before division (used for intermediate calculations).

Orig_maxX

int

The maximum X value of the territory before division (used for intermediate calculations).

Orig_minY

int

The minimum Y value of the territory before division (used for intermediate calculations).

Area

numeric

The total area of the territory.

 

 

Map Data Table

 

Table Name: TrainingTable_TerritoryColumnName_mapData

 

Map Data Table Layout:

 

Field Name

Data Type

Explanation

ZIP

varchar

The ZIP code.

TerritoryColumnName

int

The territory which contains the centroid of the ZIP code.

 

 

Map Polygon Table

 

Table Name: TrainingTable_TerritoryColumnName_mapPolygon

 

Map Polygon Table Layout:

 

Field Name

Data Type

Explanation

id

int

Point id number.

X

int

The X value of the point.

Y

int

The Y value of the point.

 

 

Parameters Table

 

Table Name: TrainingTable_TerritoryColumnName_Parameters

 

Parameters Table Layout:

 

Field Name

Data Type

Explanation

Territories

int

The number of territories created (before divisions).

LatCol

nvarchar

The name of the latitude column in the Training Data.

LonCol

nvarchar

The name of the longitude column in the Training Data.

onIntlDate

bit

1 or 0 indicating if the data points are near the International Dateline.

Lat0

numeric

The center of the range of latitude in the original data (used to convert LatLon to XY).

Lon0

numeric

The center of the range of longitude in the original data (used to convert LatLon to XY).

Lat0z

numeric

The center of the range of latitude after translating original data (used to convert LatLon to XY).

Lon0z

numeric

The center of the range of longitude after translating original data (used to convert LatLon to XY).

Lat1z

numeric

Standard parallel (used to convert LatLon to XY).

Lat2z

numeric

Standard parallel (used to convert LatLon to XY).

MaxN

numeric

The farthest north latitude value in the data.

MaxS

numeric

The farthest south latitude value in the data.

MaxE

numeric

The farthest east longitude value in the data.

MaxW

numeric

The farthest west longitude value in the data.

Centroid_X

int

The X value of the exposure weighted centroid of the original data (used to create the Map Polygon Table).

Centroid_Y

int

The Y value of the exposure weighted centroid of the original data (used to create the Map Polygon Table).