November 2024 Parcel Data Update
A detail of updates in October of 2024 and a preview of the upcoming counties in our pipeline is below.
Parcel schema changes and data enrichments rescheduled for Q1 2025 - As we mentioned last month we will be making a schema change in Q1 of next year to add greater value to our premium schema.
We will be adding the below fields with this change:
- original_mailing_address - uncleansed owner field encoded as a JSON object
- regrid_owner - owner name with predictable punctuation and common government owner names standardized. Example “B.L.M.” and “BLM” would be standardized to “Bureau of Land Management”
- deeded_acres - acreage reported by the government source as the deed acreage.
- neighborhood_code - alphanumeric code from the local source associated with a neighborhood
- preciselyid - unique identifier maintained by Precisely to assist with parcel level matching to other industry datasets
At the same time we are planning on some exciting data enrichments to our Premium Schema. Regrid customers will have received a sneak peak to these enrichments in their email inboxes.
Further details, full fields definitions, and sample Premium Schema output including all new fields will be available in the coming months. These changes will likely begin to be made available near the end of January, though that could push back, we’ll make sure to communicate final timelines as we get closer to the go live date.
Updates to our Verse table coming in Q1 - In conjunction with our upcoming schema change in Q1 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:
type: text
values:
name: Country
description: Two-letter country abbreviation
Source: Automatic
- admin2_type:
type: text
values:
name: Admin 2 Type
description: The type of administrative boundary for admin 2.
source: Hand
- sq_km:
type: int4
values:
name: Square Kilometers
description: The area of the place, in square kilometers
source: Automatic
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.
Standardized Zoning continues to expand coverage - In February, we launched our Standardized Zoning Add-on with coverage for over 85 million parcels in 6,000 unique municipalities across 900 counties. As of today, we have coverage for over 93 million parcels in 7,100 unique municipalities across more than 1,200 counties. Coverage continues to expand, and we want to hear from you about areas where you need zoning so we can target the arenas you need the most.
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 October and available now:
AL - Jefferson, Monroe
AZ - Mohave
CA - Butte, Calaveras, Los Angeles, Mono, Nevada, Ventura
CO - Archuleta, Gilpin, Jackson
FL - Clay, Lee
GA - Appling, Baker, Banks, Barrow, Bibb, Bleckley, Carroll, Catoosa, Chattooga, DeKalb, Dodge, Early, Elbert, Evans, Forsyth, Glascock, Hancock, Harris, Hart, Henry, Jasper, Lamar, Lee, Long, Lowndes, Randolph, Seminole, Stewart, Walker, Warren, Wheeler
IA - Butler, Monona
ID - Ada, Bannock
IL - Bond, Fayette, Ford, Hancock, Mercer, Vermilion
IN - Hamilton
KS - Cheyenne, Clark, Dickinson, Franklin, Geary, Graham, Gray, Greeley, Hamilton, Harvey, Leavenworth, Linn, Logan, Ottawa, Rice, Scott
KY - Clark
LA - Acadia, De Soto, St. Bernard
MD - Frederick
MN - Cass, Chisago, Clay, Cook, Koochiching, Lincoln, Mahnomen, Mille Lacs, Nobles, Otter Tail, Pipestone, Rock, St. Louis, Washington, Wilkin, Winona
MO - Adair, Andrew, Audrain, Bates, Benton, Buchanan, Camden, Christian, Clay, Cooper, Dade, Dallas, DeKalb, Douglas, Franklin, Henry, Jasper, Jefferson, Lafayette, Lawrence, Lincoln, Livingston, Maries, Marion, McDonald, Miller, Moniteau, Monroe, Morgan, Newton, Oregon, Osage, Phelps, Polk, Pulaski, Ralls, Scott, St. Charles, St. Clair, Ste. Genevieve, St. Louis City, Stone, Warren, Wayne, Webster, Worth
MS - DeSoto, Grenada, Jasper, Jones, Lauderdale, Leake, Madison, Monroe, Noxubee, Oktibbeha, Panola, Scott, Simpson, Tate
MT - Beaverhead, Cascade, Chouteau, Deer Lodge, Fallon, Flathead, Missoula, Petroleum, Powder River, Richland, Roosevelt, Rosebud, Stillwater, Teton, Toole, Treasure, Valley, Wheatland
NC - Avery, Brunswick, Buncombe, Guilford, Hertford, Jones, Mitchell, Onslow, Person, Transylvania, Wake
ND - Burke, Emmons, Morton, Mountrail
NE - Hall, Lancaster, Lincoln
NH - Carroll, Grafton
NJ - Monmouth
NV - Douglas, Washoe
NY - Chenango
OH - Knox, Mahoning, Morrow, Paulding, Seneca, Tuscarawas, Williams
OK - Lincoln, Ottawa, Roger Mills, Rogers
OR - Crook
PA - Bradford, Carbon, Erie, Washington
SC - Kershaw, Marion
SD - Spink
TN - Williamson
TX - Bailey, Bandera, Castro, Clay, Donley, Ector, Guadalupe, Hamilton, Hardin, Irion, Lamb, Lubbock, Nolan, Ochiltree, Palo Pinto, Potter, Randall, Runnels, Sabine, Stephens, Tom Green, Trinity, Upshur, Waller, Willacy, Wilson
VA - Rappahannock, Richmond, Westmoreland
WI - Dane, Milwaukee
In the current pipeline for updating in December 2024:
Note: In December we’ll continue to provide updates for the remainder of the year at our regular volume and pace, but they’ll be less focused on individual states and more so focusing on refreshing some of our older places across the country or those that are deserving of additional updates.
In the pipeline for January 2025:
The timeline for 2025, including January is currently being framed and scheduled based on the most up to date information we have on the local and state government data release schedules. We’ll have a better update for you on what to expect in January with our December message so stay tuned and let us know if there are areas you would like us to focus on as your feedback helps ensure we deliver you what you need when you need it to the best of our ability.
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