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)