Regrid Blog

October 2023 Parcel Data Update

Written by Team Regrid | Oct 5, 2023 12:30:00 PM

 

A detail of updates in September of 2023 and a preview of the upcoming counties in our pipeline is below. 

Parcel Schema Changes in October - We have extensive additional information on the fields below coming out over the next two months on our blog. Please see https://regrid.com/blog/schema-changes-2023 for a detailed discussion of these changes. That post has been updated and will be updated again toward the actual roll out. A summary of the changes is below.

 

While the final names are still subject to change, these are the columns we will be adding to both our Standard and Premium datasets:

  • state_parcelnumb - The parcel number used by the state

  • account_number - The assessor/tax collector's account number associated with the parcel

  • tax_id - The assessor/tax collector's tax id number

  • census_zcta - The US Census Bureau's Zip Code Tabulation Area zip code 

  • previous_owner - The previous parcel owner, seller or grantor where available

  • numrooms - The number of rooms associated with the parcel as tracked by the assessor

  • szip5 - The USPS 5 digit zip code

 

The following columns are being added to our Premium dataset only:

  • census_elementary_school_district - US Census listed elementary school district

  • census_secondary_school_district - US Census listed secondary school district

  • census_unified_school_district - US Census listed unified school district

  • fema_flood_zone - FEMA Flood Zone Type

  • fema_flood_zone_subtype - FEMA Flood Zone Subtype

  • fema_flood_zone_raw - FEMA Flood Zone full raw data

  • fema_flood_zone_data_date - The FEMA effective date of the flood zone data

We will be removing the following columns from both our Standard and Premium datasets. These columns were identified as redundant with other columns or being of low utility, and all have very low fill rates: 

  • sourceagent

  • multistruct

  • subsurfown

  • subowntype

  • sourceref

  • sourcedate

New Export Format - We are now exporting our premium dataset as EWKB csv files. These are primarily used for importing into AWS Redshift.


Past Data Update Emails - The full archive of our monthly data update emails can be found on our main website: https://regrid.com/blog/tag/parcel-data-updates

Coverage Report - Updated for this month and available here.

 

A machine-readable version of this list is included in the `verse` table available in all the formats above as well as CSV format for use in spreadsheets. To find the latest updates in verse, sort by 'last_refresh' and use the 'filename_stem' column to identify the file.


Data refreshed or added from the county in September and live now: (Asterisk * indicates newly added county)

AK - North Slope Borough

AL - Baldwin, Madison

AR - Pulaski

AZ - Graham, Maricopa, Mohave, Pima, Pinal, Yavapai

CA - Alameda, Fresno, Santa Cruz, Tehama, Tulare

CO - Adams, Arapahoe, Boulder, Broomfield, Crowley*, Denver, Douglas, Elbert, Hinsdale*, Jefferson, Larimer, Mesa, Rio Blanco

CT - Capitol Planning Region

DE - Kent

FL - Broward, Hillsborough, Lee, Orange, Sarasota, Volusia

GA - Clayton, DeKalb, Forsyth, Fulton, Gwinnett, Richmond

HI - Honolulu

IA - Linn

ID - Ada, Bannock

IL - Lake, McHenry

IN - Hamilton, Lake, Marion

KS - Douglas, Saline, Sedgwick, Shawnee

LA - Lafayette, Orleans, St. Helena*, Tangipahoa

MD - Anne Arundel, Baltimore City, Carroll, Cecil, Charles, Dorchester, Garrett, Harford, Howard, St. Mary's, Talbot, Wicomico

MI - Charlevoix, Eaton, Ionia, Montcalm, Oakland

MN - Anoka, Carlton, Dakota, Ramsey, Washington

MO - Franklin, Greene, Jackson, Jefferson, Pettis

MS - DeSoto, Forrest

NC - Brunswick, Buncombe, Carteret, Forsyth, Granville, Guilford, Mecklenburg, Wake

ND - Williams

NE - Hall, Lancaster

NJ - Monmouth

NM - Valencia

NV - Douglas, Nye, Washoe

NY - Erie, Ulster, Washington

OH - Allen, Ashland, Ashtabula, Auglaize, Belmont, Brown, Butler, Clark, Clermont, Clinton, Columbiana, Coshocton, Defiance, Delaware, Fairfield, Franklin, Gallia, Greene, Guernsey, Holmes, Jefferson, Knox, Lake, Licking, Logan, Lorain, Mahoning, Marion, Medina, Miami, Montgomery, Morrow, Muskingum, Ottawa, Perry, Pickaway, Portage, Preble, Putnam, Ross, Scioto, Seneca, Shelby, Stark, Summit, Tuscarawas, Union, Wayne, Williams

 

OK - Caddo

 

OR - Deschutes, Lane, Marion, Multnomah

PA - Berks, Bradford, Bucks, Butler, Cambria, Carbon, Chester, Clinton, Dauphin, Erie, Lehigh, Monroe, Montgomery, Northampton, Philadelphia, Westmoreland, York

SC - Anderson, Beaufort, Berkeley, Charleston, Colleton, Georgetown, Greenville, Greenwood, Horry, Laurens, Lexington, Newberry, Oconee, Orangeburg, Pickens, Richland, York

SD - Aurora, Beadle, Bennett, Bon Homme, Brule, Buffalo, Butte, Campbell, Clark, Codington, Davison, Day, Deuel, Edmunds, Faulk, Grant, Hanson, Hutchinson, Lawrence, Lyman, Marshall, McPherson, Mellette

TN - Anderson, Bedford, Benton, Bledsoe, Blount, Bradley, Campbell, Cannon, Carroll, Cheatham, Claiborne, Clay, Cocke, Coffee, Crockett, Cumberland, Davidson, Decatur, DeKalb, Dickson, Dyer, Fayette, Fentress, Franklin, Gibson, Giles, Grainger, Greene, Grundy, Hamblen, Hamilton, Hancock, Hardeman, Hardin, Hawkins, Haywood, Henderson, Henry, Houston, Humphreys, Jackson, Jefferson, Johnson, Knox, Lake, Lauderdale, Lawrence, Lewis, Lincoln, Loudon, Macon, Madison, Marion, Marshall, Maury, McMinn, McNairy, Meigs, Monroe, Moore, Morgan, Obion, Overton, Perry, Pickett, Polk, Putnam, Rhea, Roane, Robertson, Rutherford, Sequatchie, Sevier, Smith, Sullivan, Tipton, Trousdale, Union, Van Buren, Warren, Washington, Wayne, Weakley, White, Wilson

TX - Aransas, Armstrong, Atascosa, Austin, Bailey, Baylor, Bell, Brazoria, Brewster, Brooks, Calhoun, Camp, Castro, Childress, Clay, Collingsworth, Comal, Denton, DeWitt, Edwards, Falls, Fisher, Galveston, Hamilton, Hartley, Henderson, Houston, Howard, Jeff Davis, Johnson, Karnes, Kendall, Lamb, Liberty, Loving, Lubbock, Lynn, Martin, Menard, Morris, Nueces, Potter, Refugio, Smith, Stephens, Sterling, Williamson

UT - Davis, Duchesne, Utah, Weber

VA - Bedford, Chesterfield, Hampton, Henrico, Mecklenburg, Pittsylvania, Shenandoah, Smyth, Suffolk

WA - Clark, Columbia, King, Pacific, San Juan, Snohomish, Thurston, Whatcom

WI - Columbia, Milwaukee

 

In the current pipeline for updating in October 2023:

Kansas

Oklahoma


In the pipeline for updating in November 2023:

Alabama

Georgia

South Carolina

Virginia


Based on feedback and county challenges, pipeline planning is always subject to change. As always, please contact us if you have any questions about accessing or using the data, if you find issues with any of our data, or you have any comments or questions about our data in specific areas or states. We also love to hear from you about which counties or regions you'd like to see us update next, as it helps inform our planning process.


Thank you for being a part of Regrid!

 

 

Best Wishes,
The Regrid Data Team

tech@regrid.com