Data Layout

Introduction

Melissa offers a comprehensive parcel boundary dataset for more than 148 million properties in the U.S. This database provides an extensive look at the boundaries of a piece of land or an individual property. It contains the Assessor Parcel Number (APN) as well as its corresponding centroid coordinates and provides attribution related to TIGER Census statistical data. Combine this dataset with specific data attributes about a property (available in our U.S. Property Dataset) to obtain demographic or socioeconomic characteristics about each property or sets of properties. It’s easy to integrate this data with analytics models such as site location analytics and risk analysis for unparalleled insight.

Sample File

Click here to download the sample file.

Layout and Definitions

Grouping	Column Name	Type	Definition
Address	State	varchar(2)	State
	County	varchar(50)	The name of the county that provided the shape
	FIPSCode	varchar(5)	Five-digit United States FIPS county code: State (2) + County Code (3)
Geo	Shape	geography	Internal shape information used to generate shape
	ParcelID	varchar(12)	Identification Key of the parcel record
	APN	varchar(250)	Assessor’s Parcel Number, parcel unique identifier provided by County Assessors
	CenterLatitude	decimal(18,6)	The latitude in decimal degrees using the WGS84 datum for the centroid of the parcel
	CenterLongitude	decimal(18,6)	The longitude in decimal degrees using the WGS84 datum for the centroid of the parcel
	CensusKey	varchar(16)	Fifteen or sixteen-digit key that represents: State (2) + County (3) + Tract (6) + Block Group Number (4) + Optional Block Suffix (1). The suffix is used to indicate if any changes were made the to Block Group Number
	CensusKeyDecennial	varchar(15)	Fifteen-digit key that represents: State (2) + County (3) + Tract (6) + Block Group Number (4)
	PlaceCode	varchar(7)	Place identifier represented as State FIPS (2) + PlaceFIPS (5)
	ElevationInMeters	numeric(16,2)	Elevation in meters associated with the parcel centroid point from mean sea level
	Area	bigint	Area of the parcel polygon shape (in square meters)