Global Address Data:Database Layouts

US Address Field Names

Field Name	Definition
MAK	10-digit random key assigned to each address.
Active	Specifies if the address is active. True (1) or False (0).
Address	Street Address
Suite	Suite Number
Urbanization	Urbanization Indicator
City	City
State	Name of the State Abbreviation
AddressKey	Address Key is made of Zipcode/Plus4/DPV
ParsedRange	House Number. For Example: '6450'
ParsedPreDir	Direction. For Example: 'E'
ParsedName	Street Name. For Example: 'Side'
ParsedSuffix	For Example: 'Dr'
ParsedPostDir	For Example: 'NE'
ParsedSuiteName	For Example: 'Apt'
ParsedSuiteRange	For Example: 'Q'
BaseMAK	the ID of the record’s parent for suites, apartments and PO Boxes
AddressType	Address Type Indicator See Melissa Address Table Result Codes
RBDI	Business/Residential indication
Latitude	To the level of rooftop or interpolated rooftop for most address
Longitude	To the level of rooftop or interpolated rooftop for most address
CensusKey	Census Key statefp/Countyfp/tractce/blockce/suffixlce
DateAdded	Updated Date
GeoLevel	Geo Level B - Record was coded to rooftop level. A - Record was coded to interpolated rooftop level.* 9 - Record was coded to the ZIP + 4 centroid. 7 - Record was coded to the ZIP + 2 centroid. 5 - Record was coded to the 5-digit ZIP Code centroid. X - Record was not coded

Global Field Names

Available countries: Canada, France, Germany, Italy, Spain, Portugal, and Slovenia

Column Name	Data Type	Data Len	Definition
Mak	bigint	8	Unique Address Record ID
BaseMak	bigint	8	This will give you the unique MAK number for the building
BaseRecord	bit	1	Records with Secondary addresses attached to them.
Active	bit	1	Deliverable Addresses
ISO2	nvarchar	2	03166_1_Alpha2. ISO 3166 2-character country code.
AddressLine1	nvarchar	240	Address lines should include, at minimum, the delivery address. It can also contain the full address if you do not have the area information (locality, administrative area, postal code) parsed into their individual fields.
SubPremises	nvarchar	240	Suite. Alphanumeric code identifying an individual location.
DoubleDependentLocality	nvarchar	160	Smallest population center data element.
DependentLocality	nvarchar	200	Urbanization. Smaller population center data element
Locality	nvarchar	200	City. Most common population center data element.
SubAdministrativeArea	nvarchar	160	County. Smallest geographic data element.
AdministrativeArea	nvarchar	160	State. Most common geographic data element.
PostalCode	nvarchar	20	Zip (Plus 4). Complete postal code for a particular delivery point.
AddressType	nvarchar	1
AddressIndicator	varchar	1	One-character code for the type of address coded.
SubNationalArea	nvarchar	200	Arbitrary administrative region below that of the sovereign state.
Thoroughfare	nvarchar	200	Street. Most common street or block data element.
ThoroughfarePreDirection	nvarchar	80	Street PreDirection
ThoroughfareLeadingType	nvarchar	80	Leading thoroughfare type indicator within the Thoroughfare field.
ThoroughfareName	nvarchar	200	Street Name. Name indicator within the Thoroughfare field.
ThoroughfareTrailingType	nvarchar	80	Street Suffix. Trailing thoroughfare type indicator within the Thoroughfare
ThoroughfarePostDirection	nvarchar	80	Street Post Direction
DependentThoroughfare	nvarchar	200	Dependent street or block data element.
DependentThoroughfarePreDirection	nvarchar	80	Prefix directional contained within the Dependent Thoroughfare field.
DependentThoroughfareLeadingType	nvarchar	80	Leading thoroughfare type indicator within the Dependent Thoroughfare
DependentThoroughfareName	nvarchar	200	Name indicator within the Dependent Thoroughfare field.
DependentThoroughfareTrailingType	nvarchar	80	Trailing thoroughfare type indicator within the Dependent Thoroughfare
DependentThoroughfarePostDirection	nvarchar	80	Postfix directional contained within the Dependent Thoroughfare field.
Building	nvarchar	200	Descriptive name identifying an individual location.
PremisesType	nvarchar	1	Leading premise type indicator within premises field.
PremisesNumber	nvarchar	20	Alphanumeric indicator within premises field.
SubPremisesType	nvarchar	15	Suite Name. Sub premises type indicator within premises field.
SubPremisesNumber	nvarchar	20	Suite Number. Sub premises number indicator within premises field.
PostBox	nvarchar	250	Post box information for a particular delivery point.
Latitude	decimal	9	Geographic coordinate for a particular delivery point.
Longitude	decimal	9	Geographic coordinate for a particular delivery point.
DateAdded	datetime	8	Data data was added
GeoLevel	varchar	1	Geo Level of geocoding B - Record was coded to rooftop level. A - Record was coded to interpolated rooftop level.* 9 - Record was coded to the ZIP + 4 centroid. 7 - Record was coded to the ZIP + 2 centroid. 5 - Record was coded to the 5-digit ZIP Code centroid. X - Record was not coded
GeoUpdateDate	datetime	8
CensusKey	varchar	16
RBDI	varchar	1	Residential/Business Indicator