The Regrid Parcel Schema

We clean and convert all parcel data we receive into The Regrid Parcel Schema detailed below. Some counties may include additional fields. Wherever possible, we include those in our exports, but we do not have a key available for those fields. Each tier includes all of the fields in any tiers below it.

You can also view and download a detailed copy of the schema as a spreadsheet and access the schema API endpoint.

Field Description Tier Datatype
ogc_fid Object ID standard serial primary key
geoid FIPS Code

FIPS code (state + county FIPS codes)

standard text
parcelnumb Parcel ID

The assessor's primary parcel identification number or code.

Examples: 02004940, 001-020-4624-001

standard text
parcelnumb_no_formatting Parcel ID without Formatting

The primary parcel identification number with spaces and formatting characters removed.

Examples: 02004940, 0010204624001

standard text
state_parcelnumb State Provided Parcel ID Number

Statewide parcel identification number. Collected where available from states that provide a statewide parcel ID.

Examples: 02004940, 001-020-4624-001

standard text
account_number Parcel Account Number

The assessor or tax collector's account identification number for a property.

Examples: 02004940

standard text
tax_id Parcel Tax Identification Number

The assessor or tax collector's tax identification number for a property.

Examples: 02004940

standard text
alt_parcelnumb1 First Alternative Parcel ID

An assessor-provided additional or alternative parcel identification number.

Examples: 02004940, 001-020-4624-001

standard text
alt_parcelnumb2 Second Alternative Parcel ID

An assessor-provided additional or alternative parcel identification number.

Examples: 02004940, 001-020-4624-001

standard text
alt_parcelnumb3 Third Alternative Parcel ID

An assessor-provided additional or alternative parcel identification number.

Examples: 02004940, 001-020-4624-001

standard text
usecode Parcel Use Code

Varies by governing municipality

Examples: 104

standard text
usedesc Parcel Use Description

Varies by governing municipality

Examples: Residential

standard text
zoning Zoning Code

Code used by the governing municipality

Examples: R-1

standard text
zoning_description Zoning Description

Human-readable name for the zoning code defined by the governing municipality

Examples: Residential

standard text
zoning_type Zoning Type

Standardized zoning type

Examples: Residential

premium text
zoning_subtype Zoning Subtype

Standardized zoning subtype

Examples: Single-family

premium text
zoning_code_link Zoning Code Link

Link to the municipality's zoning code

Examples: https://www.zoneomics.com/code/anchorage-AK/chapter_10

premium text
zoning_id Zoning Area ID

ID for the zoning area for matching to the Regrid zoning product

Examples: 5555

premium integer
struct Structure on Parcel standard boolean
structno Number of Structures on Parcel standard integer
yearbuilt Structure Year Built standard integer
numstories Number of Stories standard double precision
numunits Number of Living Units

The number of individual living units, apartments or condominiums on a parcel.

standard integer
numrooms Number of Rooms

The number of rooms in the parcel's primary structure as recorded in county records.

standard double precision
structstyle Structure Style standard text
parvaltype Parcel Value Type

The type of value reported in the parcel value fields

Examples: Appraised, Assessed, Taxable, Market, Market Value

standard text
improvval Improvement Value standard double precision
landval Land Value standard double precision
parval Total Parcel Value standard double precision
agval Agricultural Value standard double precision
homestead_exemption Homestead Exemption

An assessor-provided attribute indicating if the parcel has any tax exemption due to homestead status.

premium text
saleprice Last Sale Price standard double precision
saledate Last Sale Date standard date
taxamt Annual Tax Bill standard double precision
taxyear Tax Year

An assessor-provided attribute indicating the tax year the assessor data applies to.

standard text
owntype Owner Type standard text
owner Owner Name standard text
ownfrst Owner First Name standard text
ownlast Owner Last Name standard text
owner2 Second Owner Name standard text
owner3 Third Owner Name standard text
owner4 Fourth Owner Name standard text
previous_owner Previous Owner Name

The previous owner or grantor of a parcel.

standard text
mailadd Mailing Address

This is the address where the tax and other assessor's communications are sent. It is often thought of as the owner's mailing address. It is often the same address as the parcel physical street address, but very commonly it is a different address than the parcel address itself.

standard text
mail_address2 Mailing Address Second Line standard text
careof Mailing Address Care Of standard text
mail_addno Mailing Address Street Number

Examples: 402

standard text
mail_addpref Mailing Address Street Prefix

Examples: S

standard text
mail_addstr Mailing Address Street Name

Examples: FOURTH

standard text
mail_addsttyp Mailing Address Street Type

Examples: AVE

standard text
mail_addstsuf Mailing Address Street Suffix

Examples: NW

standard text
mail_unit Mailing Address Unit Number

Examples: APT # 2

standard text
mail_city Mailing Address City

Examples: Ann Arbor

standard text
mail_state2 Mailing Address State

Mailing Address State 2-Letter abbreviation

Examples: MI

standard text
mail_zip Mailing Address ZIP Code standard text
mail_country Mailing Address Country

Examples: US, Bolivia, Canada

standard text
mail_urbanization Mailing Address Urbanizacion (Puerto Rico) standard text
address Parcel Address

This is the address of the parcel itself. Also called the "situs address" or "site address". Not every parcel has a street address, especially in agricultural areas and other large parcels.

Examples: 12109 KATZ RD

standard text
address2 Parcel Address Second Line standard text
saddno Parcel Address Number

Examples: 12109

standard text
saddpref Parcel Address Prefix

Examples: N

standard text
saddstr Parcel Address Street Name

Examples: GLENN

standard text
saddsttyp Parcel Address Street Type

Examples: RD

standard text
saddstsuf Parcel Address Street Suffix

Examples: NW

standard text
sunit Parcel Address Unit

Examples: Apt 2, Unit B, 6th floor

standard text
scity Parcel Address City

Examples: GRASS LAKE

standard text
original_address Original Parcel Address

Parcel Address fields as originally provided by the county, encoded as a JSON object. This field was originally separated by a semicolon and a space and data will exist in that format as a migration happens over time.

Examples: {"address"=>"12109 Katz Rd", "saddno"=>"12109", "saddstr"=>"Katz Rd", "scity"=>"Ann Arbor", "szip"=>"48105"}, 12109 Katz Rd; NW; Ann Arbor; MI; 48105

standard text
city US Census County Subdivision

Used for organizational purposes. Refer to scity for the city associated with the site address.

standard text
county Parcel Address County standard text
state2 Parcel Address State

Examples: MI

standard text
szip Parcel Address Zip Code

Examples: 48103, 48104-3423

standard text
szip5 5 Digit Parcel Zip Code

Examples: 48103

standard text
urbanization Parcel Urbanizacion

A postal address field commonly used in Puerto Rico

Examples: Caguas

standard text
ll_address_count Regrid Calculated Total Address Count

Total number of primary and secondary addresses on the parcel as calculated by Regrid

premium integer
location_name Location Name

A name commonly associated with this parcel

standard text
address_source Primary Address Source

Default source if none is listed is the county.

Examples: openaddresses, county

standard text
legaldesc Legal Description standard text
plat Plat

Plat number the parcel is recorded on

Examples: A

standard text
book Book

Book/Liber the parcel is recorded in

Examples: 231

standard text
page Page

Page/Folio the parcel is recorded on

Examples: 2

standard text
block Block standard text
lot Lot standard text
neighborhood Neighborhood standard text
subdivision Subdivision standard text
lat Latitude

On parcel centroid latitude decimal coordinate

standard text
lon Longitude

On parcel centroid longitude decimal coordinate

standard text
fema_flood_zone FEMA Flood Zone premium text
fema_flood_zone_subtype FEMA Flood Zone Subtype premium text
fema_flood_zone_raw FEMA Flood Zone Raw Data premium text
fema_flood_zone_data_date FEMA Flood Zone Data Date premium date
qoz Federal Qualified Opportunity Zone

Is this parcel in a US Federal Qualified Opportunity Zone

Examples: Yes, No

standard text
qoz_tract Qualified Opportunity Zone Tract Number

Census tract number as it was defined in Dec 2018 when QOZs were designated.

Examples: 30059000100, 30107000100

standard text
census_tract Census 2020 Tract standard text
census_block Census 2020 Block standard text
census_blockgroup Census 2020 Blockgroup standard text
census_zcta Census Zip Code Tabulation Area

The Census Zip Code Tabulation Area (ZCTA) in which the center of the parcel is located.

standard text
census_elementary_school_district Census Provided Elementary School District premium text
census_secondary_school_district Census Provided Secondary School District premium text
census_unified_school_district Census Provided Unified School District premium text
ll_last_refresh Last County Refresh Date

The last date Regrid refreshed the data from the County.

standard date
sourceurl Source URL

A county-provided URL to the county parcel record online

standard text
recrdareatx Recorded Area (text) standard text
recrdareano Total Square Footage of Structures

An assessor-provided number in square feet that indicates the total habitable / taxable area of buildings on the parcel.

standard integer
gisacre County-Provided Acres standard double precision
sqft County-Provided Parcel Square Feet standard double precision
ll_gisacre Regrid Calculated Parcel Acres

Parcel acres as calculated by Regrid from the parcel geometry

standard double precision
ll_gissqft Regrid Calculated Parcel Square Feet

Parcel square feet as calculated by Regrid from the parcel geometry

standard bigint
ll_bldg_footprint_sqft Regrid Calculated Building Footprint Square Feet

Total building footprint in square feet as calculated by Regrid

premium integer
ll_bldg_count Regrid Calculated Building Count

Total number of buildings on the parcel as calculated by Regrid

premium integer
cdl_raw Cropland Data Layer Raw Values

This is an array of [value,percentage] pairs that represent the pixel classes present in the parcel and their percentage of the total pixels.

Examples: 36, 60.0, 75, 20.0, 87, 10.0, 190, 10.0

premium text
cdl_majority_category Cropland Data Layer Majority Category

This is the human readable Category name for the land cover type that is most common on the parcel.

Examples: Alfalfa

premium text
cdl_majority_percent Cropland Data Layer Majority Percent

This is the actual percentage of pixels for the majority category.

Examples: 60.0

premium double precision
cdl_date Cropland Data Layer Date

The year of the Cropland Data Layer data set the current attributes are derived from.

Examples: 2021

premium text
plss_township PLSS Township

Public Land Survey System Township reference.

standard text
plss_section PLSS Section

Public Land Survey System Section reference.

standard text
plss_range PLSS Range

Public Land Survey System Range reference.

standard text
reviseddate Date of Last Revision

The last date of last revision as provided by the county assessor's office if available.

standard date
path Parcel Path

Regrid's human-readable identifier for this parcel. Not guaranteed to be stable between updates.

Examples: /us/mi/wayne/detroit/123, /us/ny/new-york/manhattan/375553

standard text
ll_stable_id Stable ID Status

Indicates if the path and ll_uuid values have changed during the last refresh from the county. A value of 'preserved' means the 'll_uuid' was matched during county refresh to the previous data. A 'null' indicates a new ll_uuid was generated because the new data was not matched to the existing data during the county data refresh process.

Examples: preserved (if unchanged),

standard text
ll_uuid Regrid UUID

Uniquely identifies a single parcel with a v4 uuid. A stable parcel id across county data refreshes. This field should be used for tracking individual parcels.

Examples: 4cc9eda6-883c-4f38-9a07-b44900a64b16

standard uuid
ll_stack_uuid Parcel Stack UUID

Uniquely identifies a group of parcels with exact duplicate geometries using one stack member parcel's ll_uuid assigned to all the parcels in the stack. This field should be used for identifying and working with groups of stacked parcels (parcels with exactly duplicated parcel geometry). The parcel ll_uuid chosen for the ll_stack_uuid is arbitrary and does not indicate a primary parcel.

Examples: 4cc9eda6-883c-4f38-9a07-b44900a64b16

standard text
ll_row_parcel Regrid Right-of-Way Parcel Flag

Identifies a parcel as being a likely right-of-way parcel. These are usually roads, streetsets, railways, utilities, rivers, etc. Values are text strings identifying the trait of the parcel that led to it being flagged.

Examples: parcel_number, land_use, perimeter_ratio, hull_ratio

premium text
ll_updated_at Last Modified

Timestamp of the last modification of any kind to this row.

Examples: 2019-06-06 12:45:21.285102-04

standard timestamp with time zone
placekey Placekey

Full description TK

Examples: 227-223@5vg-82n-pgk

premium text
dpv_status USPS Delivery Point Validation

Examples: V, N

premium text
dpv_codes Delivery Point Validation Codes premium text
dpv_notes Delivery Point Validation Notes premium text
dpv_type Delivery Point Match Type

Examples: H (High Rise), S (Street)

premium text
cass_errorno CASS Error Codes premium text
rdi Residential Delivery Indicator

Examples: Y, N

premium text
usps_vacancy USPS Vacancy Indicator

Examples: Y

premium text
usps_vacancy_date USPS Vacancy Indicator Date

Date the vacancy indicator was collected

premium date
padus_public_access PAD-US Public Access Designation

United States Geological Survey Protected Areas Database of the United States Public Access designation.

Examples: Open Access, Restricted Access, Unknown (Closed), Closed

premium text
lbcs_activity Land Use Code: Activity

Actual activity on land, eg farming, shopping, manufacturing.

premium numeric
lbcs_activity_desc Land Use Code Description: Activity

Description of the LBCS numeric code

premium text
lbcs_function Land Use Code: Function

Economic function or type of establishment, eg agricultural, commercial, industrial

premium numeric
lbcs_function_desc Land Use Code Description: Function

Economic function or type of establishment, eg agricultural, commercial, industrial

premium text
lbcs_structure Land Use Code: Structure

Type of structure or building, eg single-family house, office building, warehouse

premium numeric
lbcs_structure_desc Land Use Code Description: Structure

Type of structure or building, eg single-family house, office building, warehouse

premium text
lbcs_site Land Use Code: Site

What is on the land

premium numeric
lbcs_site_desc Land Use Code Description: Site

What is on the land

premium text
lbcs_ownership Land Use Code: Ownership

Ownership structure, eg public, private

premium numeric
lbcs_ownership_desc Land Use Code Description: Ownership

Ownership structure, eg public, private

premium text
  • Please note: Due to file format restrictions the ogc_fid column is not included in the geojson, kml, shp, and csv bulk data file formats.