Table Schema

The dataset consists of geometric features representing parcel boundaries and a set of attributes that describe each parcel. Polygons representing the boundarie…

The dataset consists of geometric features representing parcel boundaries and a set of attributes that describe each parcel. Polygons representing the boundaries of individual land parcels for purposes of tax assessment for the jurisdiction in which they reside. These geometries are derived from digitized cadastral maps, surveys, recorded deeds, and legal descriptions of the parcel.

2.1. Schema Definition

#ColumnTypeConstraintsDescription
1lridSTRING / UUIDREQUIREDUniversally unique ID (UUID) assigned to each parcel assigned by the Land Record database.
2parcelidSTRINGREQUIREDParcel id assigned by the local administrative authority. AKA parcel number, APN, AIN, PID, and PIN. The format will vary.
3parcelid2STRINGNULLABLEAlternate parcel id assigned by the local or state administrative authority. May be the same as parcelid if no alternate given.
4geoidSTRINGREQUIREDThe full combined FIPS code of the jurisdiction in which the parcel resides (state fips + county fips).
5statefpSTRINGREQUIREDState FIPS code.
6countyfpSTRINGREQUIREDCounty FIPS code.
7taxacctnumSTRINGNULLABLEThe assigned tax account number associated with this parcel / owner.
8taxyearINTEGERNULLABLEThe year for which the provided tax assessments are levied.
9usecodeSTRINGNULLABLELand use code.
10usedescSTRINGNULLABLEDescription of the land use associated with this parcel.
11zoningcodeSTRINGNULLABLEZoning code associated with this parcel. These will vary in format.
12zoningdescSTRINGNULLABLEZoning description associated with this parcel. These will vary in format and length.
13numbldgsSTRINGNULLABLENumber of buildings located on the parcel. This includes primary residence as well as any accessory dwellings, garages, sheds, etc.
14numunitsSTRINGNULLABLENumber of living units located on the parcel.
15yearbuiltSTRINGNULLABLEThe recorded year that the primary building was constructed.
16numfloorsSTRINGNULLABLENumber of stories/floors/levels in the primary building according to the local authorities.
17bldgsqftSTRINGNULLABLEAssessed area in square feet of the primary building.
18bedroomsINTEGERNULLABLENumber of known and assessed bedrooms in the main building.
19halfbathsINTEGERNULLABLENumber of known and assessed half bathrooms in the main building.
20fullbathsINTEGERNULLABLENumber of known and assessed full bathrooms in the main building.
21imprvalueBIGINTEGERNULLABLEAssessed value of improvements; typically this is the value of any and all buildings located on the parcel.
22landvalueBIGINTEGERNULLABLEAssessed value of the surface land only. Does not include value of buildings, agriculture, or subsurface minerals or water.
23agvalueBIGINTERGERNULLABLEAssessed value of any agricutlure or agriculture rights.
24totalvalueBIGINTEGERNULLABLETotal assessed value, i.e. landvalue + imprvalue + agvalue.
25taxacresFLOATNULLABLEAssessor-specified acreage under assessment. May be different the calculated area.
26calcareaFLOATREQUIREDCalculated area of the parcel geometry in square meters.
27saleamtBIGINTEGERNULLABLETransaction amount of the most recent recorded sale that this parcel was a part of. Usually the parcel comprises the entire sale, but occasionally the sale amount can include other parcels.
28saledateDATENULLABLETransaction date of the most recent recorded sale that this parcel was a part of.
29ownernameSTRINGNULLABLEName of the recorded owner.
30owneraddrSTRINGNULLABLEMailing street address of the recorded owner.
31ownercitySTRINGNULLABLEMailing address city of the recorded owner.
32ownerstateSTRINGNULLABLEMailing address state of the recorded owner
33ownerzipSTRINGNULLABLEMailing address postal code of the recorded owner.
34parceladdrSTRINGNULLABLEPhysical street address of the parcel.
35parcelcitySTRINGNULLABLECity in which the parcel is located.
36parcelstateSTRINGREQUIREDState in which the parcel is located.
37parcelzipSTRINGNULLABLEPostal code of the parcel.
38legaldescSTRINGNULLABLELegal description of the parcel; this is usually described in terms of lot numbers, plat numbers, book numbers, etc.
39townshipSTRINGNULLABLEPublic Land Survey System (PLSS) township identifier.
40sectionSTRINGNULLABLEPublic Land Survey System (PLSS) section identifier.
41qtrsectionSTRINGNULLABLEPublic Land Survey System (PLSS) quarter-section identifier.
42rangeSTRINGNULLABLEPublic Land Survey System (PLSS) range identifier.
43plssdescSTRINGNULLABLEPublic Land Survey System (PLSS) full description.
44bookSTRINGNULLABLEPlat book number or name.
45pageSTRINGNULLABLEPlat book page number or name.
46blockSTRINGNULLABLEPlat block identifier.
47lotSTRINGNULLABLEPlat lot identifier.
48updatedDATEREQUIREDDate of last known update of the source data. If not specified by the source provider or if it is unknown, this field represents the date of most recent acquisition of source data.
49centroidxNUMERICREQUIREDx-coordinate (longitude) of geographic center POINT of the parcel in EPSG 4326. In rare cases the center may lie outside the parcel shape itself in the case of a ‘C’ shaped parcel.
50centroidyNUMERICREQUIREDy-coordinate (latitude) of geographic center POINT of the parcel in EPSG 4326. In rare cases the center may lie outside the parcel shape itself in the case of a ‘C’ shaped parcel.
51surfpointxNUMERICREQUIREDx-coordinate (longitude) of centermost POINT that is guaranteed to lie within the parcel’s surface in EPSG 4326. This point will never lie outside the parcel.
52surfpointyNUMERICREQUIREDy-coordinate of centermost POINT that is guaranteed to lie within the parcel’s surface in EPSG 4326. This point will never lie outside the parcel.
53geomGEOMETRYREQUIREDMULTIPOLYGON of the parcel lot line boundary in EPSG 4326.
54ogparcelidSTRINGNULLABLEOriginal parcel identifier.
55ogparcelid2STRINGNULLABLESecondary original parcel identifier.
56parentidSTRINGNULLABLEOptional identifier of the parent parcel.
57stackidSTRING / UUIDNULLABLEUnique identifier for the parcel stack.
58countynameSTRINGNULLABLEName of the county.
59cousubfpSTRINGNULLABLECounty subdivision FIPS code.
60cousubnameSTRINGNULLABLEName of the county subdivision.
61tractceSTRINGNULLABLECensus tract code.
62tractnameSTRINGNULLABLEName of the census tract.
63taxdistrictSTRINGNULLABLEName of the tax district.
64ownertypeSTRINGNULLABLEType of owner.
65parceltypeSTRINGNULLABLEType of parcel.
66accesstypeSTRINGNULLABLEType of access.
67iucnclassSTRINGNULLABLEIUCN classification.
68placenameSTRINGNULLABLEName of the place.
69placetypeSTRINGNULLABLEType of place.
70firmidSTRINGNULLABLEUnique identifier for the firm.
71firmdateDATENULLABLEDate associated with the firm.
72fldzoneSTRINGNULLABLEFlood zone designation.
73zonesubtySTRINGNULLABLESubtype of the zone.
74staticbfeFLOATNULLABLEStatic Base Flood Elevation.
75elevminFLOATNULLABLEMinimum elevation.
76elevmaxFLOATNULLABLEMaximum elevation.
77elevavgFLOATNULLABLEAverage elevation.
78fireplacesINTEGERNULLABLENumber of fireplaces in the primary structure on the parcel.
79heatingSTRINGNULLABLEType of heating in the primary structure on the parcel.
80heatfuelSTRINGNULLABLEType of heating fuel used by the heating system.
81coolingSTRINGNULLABLEType of cooling in the primary structure on the parcel.
82foundationSTRINGNULLABLEType of foundation of the primary structure on the parcel.
83roofcoverSTRINGNULLABLEType of roof covering/material of the primary structure on the parcel.
84sidingSTRINGNULLABLEType of siding on the primary structure on the parcel.
85bldgtypeSTRINGNULLABLEType of building.
86naicscodeSTRINGNULLABLENorth American Industry Classification System (NAICS) code.
87frsidSTRINGNULLABLEEPA Facility Registry Service Identifier.
88dfrurlSTRINGNULLABLEURL for EPA Detailed Facility Reports.
89caapermitSTRINGNULLABLEClean Air Act (CAA) permit identifier.
90cwapermitSTRINGNULLABLEClean Water Act (CWA) permit identifier.
91rcrapermitSTRINGNULLABLEResource Conservation and Recovery Act (RCRA) permit identifier.
92extrasJSONNULLABLEAdditional metadata or supplemental information.

2.2. Notes on particular attributes

2.2.1. lrid

This column is guaranteed to be universally unique across the entire nationwide dataset, including within counties. It is an RFC 4122 UUID type that uniquely identifies each parcel across space, but not time.

Efforts are made in the landrecords database to maintain lrid lineage across vintages, so that a particular parcel maintains the same lrid over time as new versions of the dataset are produced. While this process is reliable, it is not perfect. Moreover, parcels regularly change shape as new digitization methods are used by assessors, and parcels are occasionally subdivided or joined to form entirely different parcels, and the lineage to the ancestor parcels is not always ascertainable.

2.2.2. usecode / usedesc

Localities define their own land use codes, but in most cases, these attributes are mapped to a common set of standardized land use categories. In cases where the locality defines their own standard that does not align with the standardized categories, or the data is unavailable, usecode and usedesc may deviate from those categories.

2.2.3. zoningcode / zoningdesc

Like usecode, zoningcode is locality-specific. Unlike usecode, there is no nationally agreed-upon standard that all zoning codes and descriptions can be mapped to. Since specific zoning codes only have semantic value within the borders of a particular county (or city or other jurisdiction), zoning codes are kept in the format provided by the county, to the degree they are provided.

2.2.4. numunits / numfloors

This data is lifted directly from the source data when it is available, but it is often missing from source datasets. As a result, they are often estimated.

numunits is often estimated based on the number of mailing addresses associated with a parcel, provided there is at least one building on the parcel. Likewise, numfloors is rarely available in the source data, but can occasionally be estimated based on the known or modeled height of the main building. (The “main” building is whichever building on the parcel has the largest internal usable area measured in square feet).

For example if the building footprint is 1000sqft on the surface, has a total usable area of 1800sqft, a height of 21 feet, and is zoned residential, a reasonable conclusion is that this is a 2-story building, i.e. numfloors=2. The land records database will derive these data in circumstances such as this when there is a high degree of confidence.

2.2.5. parceladdr

Usually, the primary parcel address is that which, when written on the front of an envelope, would reach a mailbox located on the parcel grounds. But this is not always the case. Many localities assign addresses to parcels that no letter can ever reach. In these cases, the land records database prefers the physical address assigned by the local authority if it is made available.

Conversely, it is also the case that a single parcel can have many addresses, as in the case of an apartment building or commercial strip mall. In these cases, the address assigned is either 1) provided by the taxation or appraisal authority that has jurisdiction over the parcel, or 2) that which is closest to the centroid of the parcel, and in most cases, any unit number will be removed. The number of addresses associated with a parcel is shown indirectly in the numunits column of the parcel record.

2.2.6. legaldesc / plssdesc

A core historic function of the “county” unit of government is to record deeds and collect property taxes. Deeds are recorded by the county to indicate ownership of parcels, and as part of the deed is a “legal description” of the parcel in question.

Some counties publish the full physical legal description, which involves using the PLSS (Public Land Survey System) to describe the exact boundary and location of the parcel. Others describe simply the parcel’s filing location in the book of deeds, e.g. BOOK A2 PAGE 97 and its components will be stored in the columns book and page. Additionally, these recorded pages may have a map attached, and will be designated by block, and lot if available. The land record database does not discriminate between these various approaches, and will record the provided “legal description” in the legaldesc column, irrespective of the format.

On the other hand, the plssdesc will always contain a standardized PLSS description when it is available. 30 states utilize PLSS to describe the location and bounds of parcels, and its components separated into the columns for section, quarter section, range, and township. In the 20 states where PLSS is not used, plssdesc, range, section, and qtrsection will always be NULL.

2.2.7 cooling, heating, and heatfuel

Heating, heatfuel, and cooling values will fall into one of the following enumerated values.

heatfuel — primary fuel source for the heating system:

ValueDescription
ELECTRICElectricity is the sole heating energy source.
GASNatural gas, typically piped from a municipal gas utility.
GAS/ELECTRICHybrid system that draws from both natural gas and electricity.
PROPANELiquid propane (LP) from an on-site tank.
OILHeating oil delivered to an on-site tank.
OIL/ELECTRICHybrid system that draws from both heating oil and electricity.
COALCoal-fired heating.
WOODWood-burning heat source (e.g., wood stove, fireplace insert, pellet stove).
SOLARActive solar thermal as the primary heat source.
GEOTHERMALGround-source heat pump drawing from a closed- or open-loop geothermal field.
NO HEATBuilding is unheated.
UNDETERMINEDFuel source is unknown or not reported by the source data.

heating — heat-distribution / system type:

ValueDescription
CENTRAL AIRForced-air central heating distributed through ductwork.
GRAVITYOlder gravity-fed warm-air system (no blower).
FURNACESelf-contained warm-air furnace.
HOT WATERHydronic system that circulates hot water through radiators or coils.
STEAMSteam radiator system.
BOILERBoiler-fed hot-water or steam distribution.
RADIANTIn-floor or in-ceiling radiant heating.
BASEBOARDElectric or hydronic baseboard heaters along exterior walls.
HEAT PUMPAir-source heat pump.
MINI SPLITDuctless mini-split heat pump, typically zone-controlled.
GEOTHERMALGround-source heat-pump system.
WALL UNITThrough-the-wall single-room heater.
FLOOR UNITIn-floor unit heater serving a single room.
STOVEFree-standing stove (wood, pellet, gas) used as the primary heat source.
FIREPLACEOpen fireplace serving as the primary heat source.
SPACE HEATERPortable or fixed space heater(s).
UNIT HEATERSuspended industrial or commercial unit heater.
SOLARActive solar thermal heating.
DISTRICTDistrict heating plant supplying multiple buildings.
NO HEATBuilding has no fixed heating system.
OTHERA heating type that does not fit any of the categories above.
UNDETERMINEDHeating type is unknown or not reported by the source data.

cooling — cooling / air-conditioning system type:

ValueDescription
CENTRAL AIRForced-air central air conditioning distributed through ductwork.
HEAT PUMPReversible air-source heat pump providing cooling.
MINI SPLITDuctless mini-split AC, typically zone-controlled.
GEOTHERMALGround-source heat-pump system used for cooling.
PACKAGE UNITSingle-cabinet packaged HVAC unit serving the building.
ROOFTOP UNITRoof-mounted packaged unit, common on commercial buildings.
CHILLERCentralized chilled-water plant feeding fan-coils or air handlers.
WINDOW UNITWindow-mounted room air conditioner(s).
WALL UNITThrough-the-wall room air conditioner(s).
PORTABLEFree-standing portable air conditioner(s).
EVAPORATIVE COOLEREvaporative ("swamp") cooler, common in dry climates.
WHOLE HOUSE FANWhole-house exhaust fan; ventilation cooling rather than refrigerated cooling.
ATTIC FANAttic-only ventilation fan.
CEILING FANCeiling fan(s) only; no refrigerated cooling system.
NO COOLINGBuilding has no cooling system.
OTHERA cooling type that does not fit any of the categories above.
UNDETERMINEDCooling type is unknown or not reported by the source data.

2.2.8 accesstype, parceltype, and ownertype

accesstype and parceltype are most informative for protected lands, parks, and other publicly-managed parcels — privately-owned residential and commercial parcels generally fall through to PRIVATE / UNKNOWN. ownertype is populated for every parcel and describes the legal nature of the entity recorded on ownername, independent of the parcel's jurisdiction.

accesstype — public physical access to the parcel:

ValueDescription
OPENPublic access is permitted without conditions during normal hours.
RESTRICTEDPublic access is permitted but subject to conditions (permit, fee, season, posted hours, guided-only, membership, etc.).
CLOSEDPublic access is not permitted (private property, ecological reserve, hazardous site, military / utility installation, etc.).
UNKNOWNAccess status was not reported by the source, or could not be determined during harmonization.

parceltype — ownership / management category of the parcel:

ValueDescription
GOVT FEDERALOwned or managed by the U.S. federal government (BLM, USFS, NPS, USFWS, DoD, USACE, etc.).
GOVT STATEOwned or managed by a U.S. state government (state parks, state forests, state trust land, state wildlife areas, etc.).
GOVT LOCALOwned or managed by a local government — county, municipality, city, or township.
GOVT TRIBALOwned by a Native American tribe or tribal nation, or held in trust by the Bureau of Indian Affairs on behalf of a tribe.
GOVT TERRITORYOwned or managed by a U.S. territory government (Puerto Rico, U.S. Virgin Islands, Guam, American Samoa, Northern Mariana Islands).
GOVT SPECIAL DISTRICTOwned or managed by a special-purpose government district (school district, water district, fire district, port authority, regional transit, etc.).
GOVT MULTIPLEJointly owned or managed by multiple government entities at different levels (e.g., federal–state co-management).
GOVT UNKNOWNConfirmed to be government-owned, but the specific jurisdiction could not be determined.
NGOOwned by a non-governmental organization — typically a land trust or conservation nonprofit (Nature Conservancy, Audubon, regional land trusts, etc.).
PRIVATEPrivately owned by an individual, family, corporation, trust, or partnership.
PRIVATE WITH PUBLIC EASEMENTPrivately owned, but encumbered by a public-access easement (trail corridor, conservation easement with access provisions, etc.).

ownertype — legal nature of the entity recorded on ownername:

ValueDescription
PERSONA natural person, or two or more natural persons holding title jointly (e.g., spouses, family members).
BUSINESSA for-profit business entity — corporation, LLC, partnership, sole proprietorship, REIT, etc.
NONPROFITA non-profit organization — 501(c)(3) charity, foundation, church or religious institution, HOA, civic association, etc.
GOVERNMENTA government entity at any level (federal, state, local, tribal, territorial, or special district).
TRUSTA legal trust holding title — revocable living trust, irrevocable trust, family trust, land trust, etc.
ESTATEThe probate estate of a deceased owner, typically prior to settlement and conveyance to heirs.

2.2.9 fldzone and FEMA flood attributes

Five columns describe each parcel's relationship to FEMA's mapped flood hazards. They are sourced from the FEMA National Flood Hazard Layer (NFHL) — specifically the S_Fld_Haz_Ar (flood hazard area) feature class — and joined to each parcel by spatial overlay. Where a parcel intersects more than one flood hazard polygon, the values reflect the most hazardous zone touching the parcel, so a partially-mapped parcel is never understated.

ColumnDescription
fldzoneThe FEMA flood zone designation, stored as an UPPERCASE code (e.g. AE, VE, X). This is the primary risk indicator. See the FEMA Flood Zones reference for a full description of every value.
zonesubtyZone subtype — a qualifier that refines fldzone (e.g. FLOODWAY, 0.2 PCT ANNUAL CHANCE FLOOD HAZARD, AREA OF MINIMAL FLOOD HAZARD). Not every zone carries a subtype.
staticbfeStatic Base Flood Elevation (BFE) in feet (NAVD 88), when a single elevation applies to the entire zone polygon. NULL where no static BFE is published — many AE/VE areas instead vary the BFE continuously along the profile.
firmidIdentifier of the Flood Insurance Rate Map (FIRM) panel the zone was digitized from.
firmdateEffective date of that FIRM panel. Flood maps are revised over time; this is how you tell how current the mapping is for a given parcel.

fldzone is a fixed-domain code column — always match it with plain equality against the exact UPPERCASE value (fldzone = 'AE'), never with LIKE or a lower(...) wrapper.

Broadly, the values fall into three risk tiers:

  • High-risk — the Special Flood Hazard Area (SFHA), a 1% annual-chance (100-year) floodplain where flood insurance is federally mandated for mortgaged structures. These are the A-family zones (A, AE, AH, AO, AR, A99) and the coastal V-family zones (V, VE) subject to wave action.
  • Moderate-to-low riskX (and its legacy equivalents B and C), covering the 0.2% annual-chance (500-year) floodplain and areas outside the mapped floodplains.
  • UndeterminedD, where flood hazards exist but have not been analyzed.

Two additional values, OPEN WATER and AREA NOT INCLUDED, are not risk classifications; they mark areas the FIRM does not assess.

Parcels with no intersecting NFHL polygon — either because the county has no effective NFHL data or the parcel lies entirely outside any mapped hazard area — carry NULL in all five columns.

Every possible fldzone value is documented in detail, one page per zone, under the FEMA Flood Zones reference.

2.3. Versioning and Updates

2.3.1. Update Schedule

The National Parcel dataset is updated quarterly. Not all counties publish their source data at this interval, but all are checked by the land records database to pull, harmonize, and a merge updates if there are any.

2.3.2. Versioning

Each quarterly release is identified by a YEAR.QUARTER version, e.g. 2025.1 for the first quarter of 2025. This release version is published with the bulk download itself (in the file name and accompanying metadata) rather than stamped onto each parcel row. It is distinct and separate from the updated column, which indicates the date of the last source update or acquisition for an individual parcel.

2.4. Source Data Precision

Geometric precision varies based on the original source data (e.g., surveyed vs. digitized from aerial imagery). There is no standardized or reliable way of ascertaining data accuracy from a particular source – the data provided by a county serves as the authoritative source of parcel/tax information for that county, and Land Records does not attempt to improve upon the county’s own methods of data collection and digitization.

2.5. Output Data Precision

The output dataset is snapped to a 1e-7 uniform grid, which results in a precision of around 1cm at most North American latitudes. Each vertex is snapped to the grid point which is closest to the underlying source data while preserving topology of the original geometry.

A large proportion of source data in the United States was collected and subsequently digitized against the NAD83 datum. The output datum however, is WGS 84. The typical, off-the-shelf transformation tools utilized by Land Records to transform geometries between these datums are usually accurate within a meter or so, but this varies by latitude.

100% accuracy in transforming between NAD83 and WGS84 would require taking into account the exact time at which the original data was collected, the methods used, and the subsequent tectonic plate drift that has occurred in the meantime. If this is a requirement for your use case, more details are available in this paper: Transformations between NAD83 and WGS84. See also this open-source implementation in C++: https://github.com/SonicScholar/trans4d-cpp.

On this page