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 'll_uuid' value has changed or was newly assigned during the last refresh from the county. A 'null' indicates a new ll_uuid was generated because the new data was not matched to any existing data during the county data refresh process. If there is any value in this field besides a NULL or empty string, it means we were able to match the refreshed parcel with a parcel in our previous data. The available non-null values are 'parcelnumb', 'address', 'geometry' or 'preserved' and they indicate what attribute we used to match the refreshed parcel to the previous parcel. 'preserved' is a legacy value and just indicates that the ll_uuid was carried forward from the previous data. Examples: preserved (ll_uuid unchanged), parcelnum (ll_uuid unchanged, matched on parcel number), address (ll_uuid unchanged, matched on address), geometry (ll_uuid unchanged, matched on geometry),	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.