Global Address Data:Database Layouts: Difference between revisions

From Melissa Data Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 64: Line 64:
==Global Field Names==
==Global Field Names==
Available countries: Canada, France, Germany, Italy, Spain, Portugal, and Slovenia
Available countries: Canada, France, Germany, Italy, Spain, Portugal, and Slovenia


{|class="alternate01 sortable" cellspacing="0"
{|class="alternate01 sortable" cellspacing="0"

Revision as of 23:18, 8 May 2019

Template:MelissaAddressTableNav


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
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