By Sahana Murthy
on July 7, 2021
· How-To
Dear Friends of Loveland Parcel Data and landgrid.com,
A summary of updates in June of 2021 and the upcoming pipeline is below.
Key Parcel Data Stats:
- Average parcel age - 212 days, down from 223 last month
- Average county age - 240 days, down from 265 last month
- Added 8 new counties and refreshed 364 counties since last month
Upcoming Rebrand Update
As you're aware, we are in the process of moving away from the Landgrid brand to a new corporate brand and a new domain. The launch is scheduled for later this month. However, rest assured, all the links, API endpoints and bulk data delivery directories will remain un-impacted from this change. You will still be able to access our data and links without issues.
Loveland Parcel Record Schema additions
Please note - We have a few upcoming schema changes coming soon. In the next 30-45 days, we will be adding the following additional attributes to our Loveland Parcel Record Schema:
'lat' - Centroid coordinate (Basic, Standard, Premium)
'lon' - Centroid coordinate (Basic, Standard, Premium)
'taxyear' - A county-provided date that indicates which tax year the assessor's attributes apply to. (Standard, Premium)
Verse Table Attributes Notice
Our 'verse' table is an internal table we use as part of our pipeline process. It is provided in several file formats and contains meta data about every county in our data set. We have not been maintaining all the fields in that table and are removing those attributes from our exported verse tables. Going forward our verse table will consist of these fields that we consider the essential meta data for every county:
id, wkb_geometry, county, state, seat, population, sqmi, geoid, city, total_objects, assessor_data_date, last_refresh, path, canonical_path, accuzip_status, table_name, filename_stem, date_added, shapefile_size_flag
Technical support email address: We have a dedicated email address that goes directly to our senior technical and support folks! Please use tech@landgrid.com for any technical or support questions related to our data or APIs.
USPS Vacancy, Residential indicators: Now updated monthly. Updated in June 2021, next update in July.
Coverage Report: Updated for this month and available here:
https://docs.google.com/spreadsheets/d/1q0PZB72nO8935EMGmsh3864VjEAMUE-pdHcPkoAiS5c/
For all full dataset customers, the updated data is available for download to bulk data clients in these formats: GeoPKG .gpkg (suggested), GeoJSON, Shapefile, and Postgres SQL files. In addition, this data has been updated on the landgrid.com website.
If your organization uses a custom export we are updating your data at the moment and if you don’t see the latest updates, please drop us a line.
A Data Dictionary for the Loveland 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 or added from the county in June and live now:
( Asterisk * indicates newly added county)
--------------------------------------------------
AL - Baldwin, Blount, Bullock, Calhoun, Cherokee, Colbert, Cullman, Dallas, DeKalb, Elmore, Etowah, Franklin, Hale, Houston, Jackson, Jefferson, Lauderdale, Lawrence, Lee, Limestone, Macon, Madison, Marshall, Montgomery, Morgan, Randolph, Shelby, St. Clair, Talladega
CO - Routt
IA - Adair, Crawford, Franklin, Grundy, Hancock, Hardin, Johnson, Linn, Marshall, Shelby
IL - Adams, Hancock, Lee, Menard, Sangamon, Stephenson
KS - Allen, Atchison, Barber, Barton, Bourbon, Brown, Butler, Chase, Chautauqua, Cherokee, Cheyenne, Clark, Cloud, Coffey, Comanche, Crawford, Decatur, Doniphan, Edwards, Elk, Ellis, Ellsworth, Finney, Geary, Gove, Graham, Grant, Gray, Greeley, Hamilton, Harvey, Haskell, Hodgeman, Jackson, Jefferson, Jewell, Kearny, Kingman, Kiowa, Lane, Leavenworth, Lincoln, Logan, Marion, Marshall, Meade, Mitchell, Montgomery, Morris, Morton, Nemaha, Neosho, Ness, Norton, Osage, Osborne, Pawnee, Phillips, Pottawatomie, Pratt, Rawlins, Reno, Republic, Rice, Riley, Rooks, Rush, Russell, Saline, Scott, Sedgwick, Seward, Shawnee, Sheridan, Sherman, Smith, Stanton, Stevens, Sumner, Thomas, Trego, Wabaunsee, Wallace, Washington, Wichita, Wilson, Woodson, Wyandotte
MN - Aitkin, Anoka, Becker, Beltrami, Carlton, Carver, Cass, Chippewa, Chisago, Clay, Clearwater, Cook, Cottonwood, Crow Wing, Dodge, Fillmore, Goodhue, Hennepin, Hubbard, Isanti, Itasca, Jackson, Kandiyohi, Koochiching, Lake, McLeod, Meeker, Mille Lacs, Mower, Norman, Olmsted, Otter Tail, Pipestone, Polk, Pope, Ramsey, Renville, Rice, Scott, Sibley, Stearns, Steele, Stevens, St. Louis, Todd, Traverse, Wadena, Waseca, Washington, Wilkin, Winona, Wright, Yellow Medicine
MO - Adair
NC - Mecklenburg
ND - Burke, Divide, Dunn, Mountrail, Williams
NE - Dodge, Garfield, Jefferson, Nuckolls, Saline, Seward, Thayer, Valley, York
OH - Warren
PR - Adjuntas, Aguada, Aguadilla, Aguas Buenas, Aibonito, Añasco, Arecibo, Arroyo, Barceloneta, Barranquitas, Bayamón, Cabo Rojo, Caguas, Camuy, Canóvanas, Carolina, Cataño, Cayey, Ceiba, Ciales, Cidra, Coamo, Comerío, Corozal, Culebra, Dorado, Fajardo, Florida, Guánica, Guayama, Guayanilla, Guaynabo, Gurabo, Hatillo, Hormigueros, Humacao, Isabela, Jayuya, Juana Díaz, Juncos, Lajas, Lares, Las Marías, Las Piedras, Loíza, Luquillo, Manatí, Maricao, Maunabo, Mayagüez, Moca, Morovis, Naguabo, Naranjito, Orocovis, Patillas, Peñuelas, Ponce, Quebradillas, Rincón, Río Grande, Sabana Grande, Salinas, San Germán, San Juan, San Lorenzo, San Sebastián, Santa Isabel, Toa Alta, Toa Baja, Trujillo Alto, Utuado, Vega Alta, Vega Baja, Vieques, Villalba, Yabucoa, Yauco
SD - Aurora, Clay, Davison, Douglas, Faulk, Hanson, Jerauld, Sanborn, Union
TN - Shelby
TX - Bandera, Blanco, Bosque, Brazos, Briscoe, Burleson, Callahan, Camp, Carson, Coke, Concho, Coryell, Cottle, Crane, Dallam, Dimmit, Duval, Ellis, Erath, Fannin, Fisher, Garza*, Gray, Gregg, Grimes, Hansford, Hardin, Hartley, Hays, Henderson, Howard, Kaufman, Lamar, Lee, Liberty, Limestone, Live Oak, Llano, Madison, Marion, Mason, McCulloch, McMullen, Medina, Milam, Mills, Moore, Nacogdoches, Navarro, Ochiltree, Orange, Parmer, Pecos, Rains, Real, Red River, Reeves, Roberts, San Patricio, San Saba, Schleicher, Shackelford, Somervell, Titus, Travis, Upshur, Van Zandt, Walker, Waller, Wilbarger, Wood, Young
In the current pipeline for updating in July 2021
--------------------------------------------------
Arizona
Connecticut
Iowa
North Dakota
South Dakota
Tennessee
In the pipeline for updating in August 2021
--------------------------------------------------
Arkansas
Georgia
Kentucky
New Jersey
Wisconsin
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, 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 Loveland!
Happy Mapping!
Loveland Data Team
By Sahana Murthy
on May 6, 2021
· How-To
***This blog is a part of the "All you need to know about parcel data." blog series.***
I have been working at Loveland for a little over 2 years now. Everytime I meet anyone new, when asked what my company does - I often find myself explaining what land parcels are. Because without the explanation, most folks who aren’t familiar with the term “parcel data”, would automatically assume parcels aka packages, transportation and freight industry. Makes for a great conversation starter because I then go on to explain “what land parcels are”, how land is divided & owned but also about how parcel data essentially comprises geometry - polygons with shapes & boundaries ...and as I explain, I see their eyes widen with fascination. Such is the power of land parcels.
As our CEO - Jerry Paffendorf - puts it: “I am on a parcel, you are on a parcel, everyone is on a parcel for most part of their day!”
It really is the most FUNDAMENTAL piece of information that is applicable to absolutely everyone.
That’s why parcel data matters!
At the end of the day, parcel data is made of public record facts about how the country is subdivided, owned, taxed, and used. The public nature of the subdivision of land in the US stretches back to the earliest days of the country and big public programs like the US Public Land Survey which started in 1785. At Loveland, we see ourselves as providing a missing service by aggregating all these local datasets together into a big picture of how we own, use, and inhabit the country, at an affordable price.
So essentially, what we do as the cadastral kind is collect this information from over 3000 counties across the country, weave it into a beautifully
standardized schema and license it to our customers in multiple formats.
And that’s right - I did refer to us as the “Cadastral kind” - we believe it takes a different kind of DNA and tenacity to put this dataset together without compromising quality and accuracy. Our team is brimming with this DNA for sure. ;)
Which is why our customers choose and trust us over collecting all this data themselves and normalizing it.
Why is this such a tall order, you ask?
-
For starters, tirelessly collecting, cleaning and standardizing such a comprehensive dataset of ~150 million parcels across the country is no small feat. Takes years of tenacious effort, a combination of some level of tested/trusted automation but a lot of manual Qc’ing and continuous improvements of the data on a monthly basis. A mammoth task, one that’s best left to the experts - aka the incredible Loveland Data Team!
-
Secondly and most importantly,normalizing such a massive disparate raw dataset is really the hardest part of this process.We do rely on a very robust set of open source geo tools like PostGIS, QGIS, and GDAL. There’s still a lot of manual work backed by the judgement and experience of our parcel team.
Nearly every one of the 3,200 counties in the US manages its data independently. There’s very little consistency from place to place even for basic columns like “owner name”: it could be referred to as “firstname”, “fname”, “deedholder, “propow”, or pretty much anything else. And you’d think that a field called “Parcel ID” or “APN” might be unique — but it rarely is. Which is why we built in a universal parcel ID to make ingestion and working with this data at scale easy for everyone.
Generally, counties within states are more like each other than counties outside of those states, but not necessarily. Also, cleaning the data can be quite tricky at times. Working with this data makes it apparent how much human error can be involved, especially when it comes to casting columns that should be integers or double precision from text. Date field conversion can also be quite tricky at times, depending on the formatting used by a place. A lot of rules built up over time through these learnings plus the keen eyes of our data team help us keep quality high.
-
And finally, this data while is technically public data, it doesn’t necessarily mean open data and freely available for downloading. And with 3,200 counties nationwide, one can imagine what might go into acquiring this data before we can weave our magic into it.
That said, the real magic is really what one can do with this data when normalized at scale. The opportunities and the use cases are limitless - from real estate to renewable energy, utilities, manufacturing, insurance, GIS and tech, outdoor recreation to urban planning to using the data to bring upon positive change in your city or drive academic research on property landscape, COVID, on tax foreclosures, on disparity in land ownership - phew - just to name a few.
I didn't make this list up. These are the very real use cases that our customers have come to us with over the years and have found our parcel dataset to be THE solution to help solve these problems.
Such is the power of parcel data and THAT IS WHY IT MATTERS and that is why Loveland matters!
If you’d like to evaluate our data and learn more about how it can help your next project, please email us at
parcels@landgrid.com.
About this blog series - All things you need to know about Parcel Data!
Join me - Sahana Murthy, the Chief Product Officer at Loveland Technologies, as I embark on this educational journey about land parcels, our parcel dataset, what goes into it, how you can use it and much more.
With every blog, I will dig deeper into the key facets about our parcel dataset, so keep an eye out for our next blog in this series. If you have a particular subject in mind that you’d like me to cover as part of this blog series, please write to me directly at
sahana@landgrid.com. We are always looking for feedback and suggestions.
By Sahana Murthy
on May 4, 2021
· How-To
Dear Friends of Loveland Parcel Data and landgrid.com,
A summary of updates in April of 2021 and the upcoming pipeline is below.
Key Data Stats:
- Average parcel age - 210 days, up from 208 last month.
- Average county age - 260 days, up from 258 last month.
- Refreshed 15,302,140 parcels and 271 counties since last month.
USPS Vacancy, Residential indicators: Now updated monthly. Updated in April 2021, next update in May.
Coverage Report: Updated for this month and available here
A Data Dictionary for the Loveland Parcel Record Schema is always 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 April and live now:
( Asterisk * indicates newly added county)
--------------------------------------------------
CA - Mendocino, Orange, San Diego
DC - Washington
FL - Lee
IA - Delaware, Floyd, Fremont, Keokuk, Mahaska, Mills, Page, Plymouth, Sioux, Winnebago, Worth
IL - Fulton, Grundy, Jersey, Knox, McLean, Peoria
IN - Adams, Allen, Bartholomew, Benton, Blackford, Boone, Carroll, Cass, Clark, Clay, Clinton, Crawford, Daviess, Dearborn, Decatur, DeKalb, Delaware, Dubois, Elkhart, Fayette, Floyd, Fountain, Franklin, Fulton, Gibson, Grant, Greene, Hamilton, Hancock, Harrison, Hendricks, Henry, Howard, Huntington, Jackson, Jasper, Jay, Jefferson, Jennings, Johnson, Knox, Kosciusko, LaGrange, Lake, LaPorte, Lawrence, Madison, Marion, Marshall, Martin, Miami, Monroe, Montgomery, Morgan, Newton, Noble, Ohio, Orange, Owen, Parke, Perry, Pike, Porter, Posey, Pulaski, Putnam, Randolph, Ripley, Rush, Scott, Shelby, Spencer, Starke, Steuben, St. Joseph, Sullivan, Switzerland, Tippecanoe, Tipton, Union, Vanderburgh, Vermillion, Vigo, Wabash, Warren, Warrick, Washington, Wayne, Wells, White, Whitley
KS - Anderson, Clay, Cloud, Coffey, Dickinson, Jewell, Mitchell, Smith
MD - Allegany, Anne Arundel, Baltimore, Baltimore City, Calvert, Caroline, Carroll, Cecil, Charles, Dorchester, Frederick, Garrett, Harford, Howard, Kent, Montgomery, Prince George's, Queen Anne's, Somerset, St. Mary's, Talbot, Washington, Wicomico, Worcester
MN - Benton, Big Stone, Mahnomen, Marshall, Martin, Sherburne, Swift
MO - Atchison, Holt
ND - Grant, Hettinger, Sioux, Traill
SD - Deuel, Grant, Hamlin, Kingsbury, Lincoln
TX - Anderson, Andrews, Angelina, Aransas, Armstrong, Atascosa, Austin, Bastrop, Baylor, Bee, Bell, Borden, Bowie, Brazoria, Brewster, Brown, Burnet, Caldwell, Calhoun, Cameron, Cass, Castro, Chambers, Cherokee, Childress, Clay, Cochran, Collin, Collingsworth, Colorado, Comal, Comanche, Concho, Cooke, Crockett, Culberson, Dallas, Dawson, Deaf Smith, Delta, Denton, DeWitt, Dickens, Eastland, Ector, Edwards, El Paso, Falls, Fayette, Foard, Fort Bend, Franklin, Freestone, Frio, Gaines, Galveston, Gillespie, Glasscock, Goliad, Gonzales, Guadalupe, Hale, Hall, Hamilton, Hardeman, Haskell, Hemphill, Hidalgo, Hill, Hood, Houston, Hudspeth, Hunt, Irion, Jack, Jasper, Jeff Davis, Jefferson, Jim Hogg, Jim Wells, Johnson, Jones, Karnes, Kendall, Kenedy, Kent, Kerr, Kimble, King, Kinney, Kleberg, Lampasas, La Salle, Lavaca, Loving, Lubbock, Lynn, Martin, McLennan, Menard, Midland, Mitchell, Montague, Montgomery, Morris
VA - Culpeper, Prince William
In the current pipeline for updating in May 2021
--------------------------------------------------
Maine
Montana
New Hampshire
Texas
In the pipeline for updating in June 2021
--------------------------------------------------
Alabama
Connecticut
Texas
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, 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.
Happy Mapping!
By Sahana Murthy
on April 9, 2021
· How-To
Dear Friends of Loveland Parcel Data and landgrid.com,
A summary of updates in March of 2021 and the upcoming pipeline is below.
Key Data Stats:
- Average parcel age - 208 days, down from 209 last month.
- Average county age - 258 days, down from 267 last month.
- Added 936,443 parcels and refreshed 214 counties, added 52 new counties since last month.
- In Q1, we refreshed a total of 666 counties.
USPS Vacancy, Residential indicators: Now updated monthly. Updated in March 2021, next update in April.
Coverage Report: Updated for this month and available here:
https://docs.google.com/spreadsheets/d/1q0PZB72nO8935EMGmsh3864VjEAMUE-pdHcPkoAiS5c/edit#gid=333965283
Full Dataset Export - We have exported the full dataset again this month for all clients to reflect improvements we made based on feedback regarding our Loveland Standardized Use Codes.
For all full dataset customers, the updated data is available for download to bulk data clients in these formats: GeoPKG .gpkg (suggested), GeoJSON, Shapefile, and Postgres SQL files. In addition, this data has been updated on the landgrid.com website.
If your organization uses a custom export we are updating your data at the moment and if you don’t see the latest updates, please drop us a line.
A Data Dictionary for the Loveland 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 or added from the county in March and live now:
( Asterisk * indicates newly added county)
--------------------------------------------------
Alaska - Anchorage, Denali Borough*, Dillingham Census Area, Fairbanks North Star Borough, Haines Borough, Juneau, Kenai Peninsula Borough, Kodiak Island Borough, Matanuska-Susitna Borough, Nome Census Area, North Slope Borough, Petersburg*, Sitka, Skagway, Wrangell, Yakutat
California - Los Angeles
Colorado - Chaffee*, Prowers*
Iowa - Benton, Clay, Dickinson, Fayette, Howard, Jasper, Lyon, Mitchell, Poweshiek
Idaho - Ada, Adams, Bannock, Bear Lake, Benewah, Bingham, Blaine, Boise, Bonner, Bonneville, Boundary, Butte, Camas, Canyon, Caribou, Cassia, Clark, Clearwater, Custer, Elmore, Franklin, Fremont, Gem, Gooding, Idaho, Jefferson, Jerome, Kootenai, Latah, Lemhi, Lewis, Lincoln, Madison, Minidoka, Nez Perce, Oneida, Owyhee, Payette, Power, Shoshone, Teton, Twin Falls, Valley, Washington
Illinois - Cass*, Champaign, Christian, Macoupin, Montgomery*, Ogle
Indiana - Brown
Kansas - Chase, Doniphan, Harvey, Kingman, Marion, Ottawa, Reno, Republic
Michigan - Allegan, Baraga*, Berrien, Branch, Charlevoix, Cheboygan, Eaton, Emmet, Gladwin, Hillsdale, Ionia, Jackson, Kalamazoo, Kent, Keweenaw, Leelanau, Lenawee, Macomb, Midland, Missaukee, Montcalm, Muskegon, Newaygo, Oceana, Ogemaw*, Roscommon, St. Clair, St. Joseph, Washtenaw, Wayne
Minnesota - Blue Earth, Dakota, Douglas, Faribault, Grant, Houston, Kanabec*, Kittson, Lake of the Woods, Morrison, Murray, Pennington, Red Lake, Redwood, Roseau, Wabasha, Watonwan*
Missouri - Pettis, Platte
North Dakota - Burleigh, Emmons, Morton, Sheridan
Nebraska - Scotts Bluff
Nevada - Carson City, Churchill, Clark, Douglas, Elko, Eureka, Humboldt, Lander, Pershing, Washoe, White Pine
New York - Bronx, Kings, New York, Queens, Richmond
Ohio - Crawford, Lucas, Washington
Oklahoma (all newly added) - Adair, Atoka, Beaver, Blaine, Bryan, Carter, Cherokee, Choctaw, Cimarron, Cleveland, Comanche, Cotton, Craig, Creek, Custer, Delaware, Dewey, Ellis, Garfield, Garvin, Grady, Grant, Greer, Harmon, Harper, Hughes, Jefferson, Kay, Kingfisher, Latimer, Le Flore, Logan, Love, Major, Marshall, Mayes, McClain, McCurtain, McIntosh, Noble, Nowata, Okfuskee, Oklahoma, Okmulgee, Osage, Ottawa, Pawnee, Payne, Pittsburg, Pontotoc, Roger Mills, Seminole, Sequoyah, Stephens, Texas, Tillman, Tulsa, Wagoner, Washington, Washita, Woods, Woodward
Oregon - Washington
Pennsylvania - Clearfield
Rhode Island - Bristol, Kent, Newport, Providence, Washington
South Dakota (all newly added) - Brookings, Brown, Clark, Codington, Haakon, Harding, Hughes, Hyde, McCook, Walworth
Texas - Harris
Vermont - Addison, Bennington, Caledonia, Chittenden, Essex, Franklin, Grand Isle, Lamoille, Orange, Orleans, Rutland, Washington, Windham, Windsor
Wisconsin - Milwaukee
In the current pipeline for updating in April 2021
--------------------------------------------------
Indiana
Maryland
Puerto Rico
In the pipeline for updating in May 2021
--------------------------------------------------
Alabama
Connecticut
Texas
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, 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 Loveland!
Happy Mapping!
.svg)
