Regrid Blog

December 2024 Parcel Data Update

Written by The Regrid Data Team | Dec 2, 2024 4:08:04 PM

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