December 2024 Parcel Data Update
A detail of updates in November of 2024 and a preview of the upcoming counties in our pipeline is below.
Parcel Schema Changes and Data Enrichments forthcoming in early Q1 2025 - We continue to move forward with our schema change in Q1 of next year. This change is currently scheduled to occur during the last week of January so you will see the changes coming at that point. You will be receiving additional communication related to these details from your Customer Success Manager in the coming weeks. If you haven’t heard from them by the 2nd week of December drop us a note to tech@regrid.com and we’ll make sure to get you all the information you need. We will have the schema fully locked within the first few weeks of December and will have some sample data files ready for testing in early January.
Updates to our Verse table coming in Q1 - As a reminder, in conjunction with our January schema change we will be making some updates to our verse table. With our expansion into Canadian parcels, we will be internationalizing our verse table to be less USA-specific. What this means is that we’ll be a) adding three new columns, and b) renaming five columns.
The three new columns will be as follows:
Columns Added:
- Admin0: Two-letter country abbreviation
- Admin2_type: The type of administrative boundary for admin 2.
- sq_km:The area of the place, in square kilometers
The columns that we’ll be changing are as follows:
- state => admin1
- county => admin2
- seat => admin2_center
- city => admin3
- msa => metropolitan_area
These changes won’t have any effect on your continued use of the data files themselves. However, depending on your use of the verse table, there may be some small changes needed to your ETL processes. We will have a version of the new verse table available to test as early as the middle of November.
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: https://docs.google.com/spreadsheets/d/1rvRYv6_ppZlwbmyi2kbzemot6FOEm2EEPdHPyENTQPE/edit#gid=1284673582
A technical Data Dictionary for the Regrid Parcel Record Schema is always available here: https://docs.google.com/spreadsheets/d/14RcBKyiEGa7q-SR0rFnDHVcovb9uegPJ3sfb3WlNPc0/
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 from the county in November and available now:
AK - Kodiak Island Borough
AL - Blount, Lawrence, Lee
AZ - Maricopa, Pima, Yuma
CA - Alpine, Del Norte, El Dorado, Glenn, Humboldt, Imperial, Lake, Lassen, Madera, Marin, Mariposa, Modoc, Monterey, Napa, Orange, Placer, San Diego, San Joaquin, Santa Cruz, Shasta, Siskiyou, Sutter
CO - Adams, Arapahoe, Clear Creek, Delta, Garfield, Hinsdale, Montezuma, Morgan, Park, Pitkin, Rio Blanco, Saguache
CT - Northwest Hills Planning Region
FL - Hillsborough, Volusia
GA - Bacon, Charlton, Cherokee, Clayton, Gwinnett, Jenkins, Lincoln, Lumpkin, Macon, Madison, Marion, Morgan, Pickens, Rockdale, Schley, Toombs, Turner, Ware, Webster, Wilkinson, Worth
IA - Cedar, Chickasaw, Decatur, Fayette, Hardin, Marshall
IL - Bureau, Calhoun, Coles, Henry, Jackson, Johnson, Kane, Lake, Lawrence, Piatt, Pope, Stephenson, Union, Will, Winnebago
IN - Marion, Vigo
KS - Finney, Ford, Jefferson, Labette, Pottawatomie, Sedgwick, Seward, Stafford
KY - Simpson
LA - Lafayette, Orleans, Ouachita, St. Landry, Terrebonne
MA - Barnstable
MI - Alcona, Arenac, Branch, Macomb, Missaukee, Oceana, Van Buren, Wexford
MN - Beltrami, Carver, Itasca, Lyon, Nicollet, Red Lake
MO - Nodaway, Pettis, Sullivan, Taney, Washington
MS - Adams, Alcorn, Choctaw, Forrest, Harrison, Holmes, Issaquena, Jackson, Lawrence, Lee, Marshall, Neshoba, Prentiss, Smith, Sunflower, Winston
MT - Prairie, Sweet Grass
NC - Bertie, Forsyth, Robeson, Rowan, Sampson, Scotland, Swain, Tyrrell, Vance, Warren, Wayne
ND - Divide, McLean, Sargent, Sioux, Traill
NE - Adams, Douglas, Hamilton, Hayes, Holt, Seward
NH - Rockingham
NJ - Burlington
NM - Colfax, Curry, De Baca, Harding, Lincoln, Los Alamos, Luna, Roosevelt, Sierra
NV - Churchill, Clark
NY - Hamilton, Herkimer, Rockland, Schuyler, Sullivan, Ulster
OH - Ashtabula, Auglaize, Belmont, Butler, Coshocton, Crawford, Fayette, Greene, Henry, Hocking, Jefferson, Lake, Licking, Miami, Monroe, Noble, Ottawa, Perry, Preble, Putnam, Sandusky, Scioto, Stark, Washington, Wayne
OR - Benton, Clackamas, Columbia, Curry, Deschutes, Douglas, Gilliam, Jackson, Jefferson, Klamath, Lake, Linn, Marion, Morrow, Umatilla, Wallowa, Wasco, Wheeler, Yamhill
PA - Blair, Butler, Chester, Clarion, Crawford, Fayette, Lebanon, Lehigh, Northumberland, Perry, Snyder, Somerset, Venango
SC - Anderson, Beaufort, Calhoun, Colleton, Darlington, Lancaster
SD - Bennett, Butte, Clay, Dewey, Hamlin
TN - Hamblen, Hamilton, Henderson, Knox, Lake, McMinn, Montgomery, Sevier, Shelby, Stewart, Wilson
TX - Brazos, Comanche, Dallam, Jackson, Jones, Kaufman, Leon, Medina, Montague, Pecos, San Jacinto, Starr, Sutton, Tarrant, Taylor, Titus, Williamson, Wise
UT - Garfield, Rich, Wasatch
VA - Albemarle, Bath, Buckingham, Carroll, Charlotte, Fauquier, Floyd, Giles, Hopewell, Northumberland, Norton, Patrick, Portsmouth, Richmond City, Roanoke City, Rockingham, Scott, Southampton, Tazewell, Washington, Wythe
WA - Chelan, Cowlitz, Island, Jefferson, King, Kitsap, Kittitas, Lewis, Mason, Okanogan, Pend Oreille, San Juan, Skagit, Thurston, Yakima
WI - Kenosha, Langlade, Milwaukee, Sauk, Washington
WY - Albany, Big Horn, Converse, Hot Springs, Sublette, Sweetwater, Teton
In the pipeline for updating in January and February:
Alaska, Florida, Montana, Pennsylvania, Puerto Rico, Washington D.C, Wyoming
Based on your 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