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