Data Layout

Introduction

Melissa offers a comprehensive building footprint dataset for more than 120 million structures in the U.S. This database provides an extensive look at where building footprints exists, and represents the total area a building covers to the outer edge of its foundation. It can be used for geospatial analyses and can be applied in real estate development and investment, city planning, insurance, and more. Combine this dataset with specific data attributes about a property (available in our U.S. Property Dataset) to obtain a comprehensive understanding about each structure or building.

Sample File

Click here to download the sample file.

Layout and Definitions

Grouping	Column Name	Type	Definition
Address	BuildingID	varchar(13)	The BuildingID is a unique 13-digit (varchar(13)) number that represents the County FIPS (5) + 8-digit unique ID for each Building.
	State	varchar(2)	State
	FIPSCode	varchar(5)	The FIPSCode indicates the location of the address at both the state and county level.
	CountyName	varchar(50)	County name
Geo	Area	bigint	Area of the parcel polygon shape (in square meters)
	Shape	geography	Internal shape information used to generate shape
	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(18,2)	Elevation in meters associated with the height of the buildings centroid.