Building Footprint — data dictionary
Building footprint geometry + structure attributes per parcel. · 24 fields · source FA Building Footprint Data Dictionary Layout v24 20250601 (v24 · 2025-06-01).
Roof footprint area / structure-count context for the roofing model.
| Field | Type | Display | Code table | Description |
|---|---|---|---|---|
| PROPERTY IDENTIFICATION INFORMATION | ||||
| FIPS | varchar(5) | Public Display | FIPS | FIPS: Federal Information Processing Standard. Five digit code. First two digits represent the STATE, while the last three digits represent the COUNTY or county equivalents. |
| PropertyID | bigint(19) | No Display | The First American Derived ID that uniquely identifies a property in the First American Database. | |
| FormattedAPN | varchar(45) | No Display | Assessor's Parcel Number or Parcel Identification Number. An arbitrary parcel identifier assigned by the county Assessor to simplify identification and expedite the locating of parcels. | |
| PROPERTY ADDRESS INFORMATION | ||||
| SitusFullStreetAddress | varchar(116) | Public Display | Street Address: 123 S MAIN ST # 4 | |
| SitusHouseNbr | varchar(10) | Public Display | House Number: 123 S MAIN ST # 4 | |
| SitusHouseNbrSuffix | varchar(10) | Public Display | Alpha characters found to the right of the house number: 123 W S MAIN ST # 4 | |
| SitusDirectionLeft | varchar(2) | Public Display | Alpha characters found to the left of the street name: 123 S MAIN ST # 4 | |
| SitusStreet | varchar(60) | Public Display | Name or number of the street. 123 S MAIN ST # 4 | |
| SitusMode | varchar(5) | Public Display | Suffix of the Street: 123 S MAIN ST # 4 | |
| SitusDirectionRight | varchar(2) | Public Display | Represents the quadrant of the city the street segment lies: 123 S MAIN ST NW # 4 | |
| SitusUnitType | varchar(10) | Public Display | The type used in the property address for the unit: 123 S Main St # 4 | |
| SitusUnitNbr | varchar(15) | Public Display | The unit or suite number of the property address: 123 S Main St # 4 | |
| SitusCity | varchar(30) | Public Display | The city for the property address. | |
| SitusState | varchar(2) | Public Display | Two letter state abbreviation for the property. | |
| SitusZIP5 | varchar(9) | Public Display | Five digit code assigned by the USPS: 90001-1000 | |
| SitusZIP4 | varchar(9) | Public Display | Four digit code assigned by the USPS: 90001-1000 | |
| SitusCarrierCode | varchar(4) | Restricted Display | Four digit code used by the local mail carrier to identify delivery path. | |
| BUILDING FOOTPRINT INFORMATION | ||||
| Height | int(53) | Restricted Display | Building Height | |
| SqFeet | int(53) | Restricted Display | Building Square Footage | |
| GeomWKT | bigint(1) | No Display | Geometric data - Well Known Text format - up to 10000000 characters | |
| Latitude | varchar(53) | Restricted Display | Latitude | |
| Longitude | int(53) | Restricted Display | Longitude | |
| ADDITIONAL FA PROCESSING INFORMATION | ||||
| FATimeStamp | datetime2(15) | No Display | Timestamp applied to transaction records when created, edited, or deleted. Format: 20150925. | |
| FARecordType | varchar(1) | No Display | I - Insert (new record). C & U - Change or Update to the record (treat the same). D = Record deleted. | |