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

bigint

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

Geo

Area

numeric(20,2)

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)

Elevation

numeric(20,2)

Elevation in meters associated with the building centroid point from mean sea level

test