Data Layout

Introduction

In addition to street addresses (including apartment/suite numbers), Global Address Database also provides geographic information like rooftop latitude-longitude coordinates, census tract/block number, and county name with FIPS code – ideal for analytics, mapping, risk management and logistics applications.

200+ million U.S. addresses including PO Boxes, Apartments and Suites. Customize selections by City, Province, State, Postal Code or any shape-based search. Latitude-longitude coordinates including available census data and address type (residence or business)

Sample File

Click here to download the sample file.

Layout and Definitions

Grouping	Column Name	Type	Definition
Address	MelissaAddressKey	bigint	10-digit unique key assigned to each address.
	BaseMelissaAddressKey	bigint	Displays the parent Melissa Address Key of an address if it is a part of or within a building. Ex. Apartment
	AddressLine	varchar(50)	Address line
	Suite	varchar(20)	Suite
	Urbanization	varchar(28)	Urbanization indicator
	City	varchar(35)	City
	State	char(2)	State
	AddressKey	char(11)	Address key is a combination of a location’s ZIPCode + Plus4 + DeliveryPoint
	BaseRecord	bit	Flag to indicate the address is a parent record.
	ResultCodes	varchar(50)	Melissa result codes
	AddressStreetNumber	varchar(10)	Address street number. Ex. ‘6450’
	AddressDirectionPrefix	varchar(5)	Address directional prefix. Ex. ‘e’
	AddressStreetName	varchar(40)	Street name. Ex. ‘Side’
	AddressStreetSuffix	varchar(10)	Suffix of address. Ex. ‘Dr’
	AddressDirectionSuffix	varchar(5)	Address directional suffix. Ex. ‘Ne’
	AddressSuiteName	varchar(10)	Suite. Ex. ‘Apt’
	AddressSuiteNumber	varchar(10)	Suite number. Ex. ‘Q’
	AddressType	char(1)	Address type. Ex. P.O.Box or residential address
	RBDI	char(1)	Business/residential indication
	CommercialMailReceivingAgency	bit	U.S. Only. The address is a commercial mail receiving agency like a mailbox, etc. These addresses include a private mailbox (PMB or number).
	County	varchar(100)	County
	CongressionalDistrict	varchar(2)	Federal congressional district number
	CarrierRoute	varchar(4)	The carrier route for the location address as assigned by the USPS.
AddressMisc	CityAbbreviation	varchar(13)	Alternative city name
	FIPSCode	varchar(5)	The FIPSCode indicates the location of the address at both the state and county level.
	Vacant	bit	Indicates whether an address is vacant
	NeighborhoodName	varchar(100)	The name of a Neighborhood
	ApartmentName	varchar(255)	The name of an apartment complex
	NonUSPS	bit	US only. This US address is not serviced by the USPS but does exist and may receive mail through third party carriers.
Geo	PlaceCode	varchar(7)	Place identifier represented as State FIPS (2) + PlaceFIPS (5)
	Latitude	decimal(18,6)	The latitude in decimal degrees using the WGS84 datum for the address
	Longitude	decimal(18,6)	The longitude in decimal degrees using the WGS84 datum for the address
	GeoLevel	varchar(1)	Geo level, see code table
	CensusKey	varchar(16)	Census key is a 15 or 16-character key combination of the state FIPS code + county FIPS code + tract number + block number + block suffix. The Census key was created by the US Government to correctly identify, classify, and pull statistical data from areas across the United States.
	CensusKeyDecennial	varchar(15)	Similar to the Census key, however, this key contains 15 characters and changes every 10 years. Fifteen-digit key that represents: State (2) + County (3) + Tract (6) + Block Group Number (4)
	ElevationInMeters	decimal(18,2)	Elevation of the address from sea level in meters

Code and Definitions

Column Name	Code	Definition
AddressType	A	Alias
	F	Firm or Company address
	G	General Delivery Address
	H	High Rise or Business complex
	P	P.O. Box Address
	R	Rural Route Address
	S	Street or Residential address
	U	Unique
	Z	Unique
BaseRecord	1	Parent Record
	0	Not a Parent Record
CommercialMailReceivingAgency	1	The address is a commercial mail receiving agency
	0	The address is not a commercial mail receiving agency
RBDI	B	Business
	P	P.O. Box
	R	Residential
	U	Unknown
GeoLevel	B	The record was geocoded down to the rooftop level, meaning the point is within the property boundaries, usually the center.
	A	The record was geocoded down to the rooftop level using interpolation (educated estimations using street coordinates). The point may be in or close to the property boundaries.
	9	The record was coded to the street level (ZIP+4 for US, full postal code for CA).
	7	The record was geocoded down to neighborhood level (ZIP+2 for US)
	5	The record was coded to the community level (ZIP centroid for US, 3-digit postal code for CA)