The Loveland Blog

Why Parcel Data Matters?

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? 
 
  1. 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!
     
  2. 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.
 
  1. 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.  
 
Here’s a quick read on how & why parcel data is valuable to the renewable energy industry - https://landgrid.com/blog/renewables
 
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!
 
You can read up on our data, coverage and customers here - https://landgrid.com/parcels
 
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.
 

Landgrid Parcel Data - May 2021 Update

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!

 

April 2021 - Parcel Data Update

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!

 

 

March 2021 - Parcel Data Update

By Sahana Murthy on March 16, 2021 · How-To

Dear Friends of Loveland Parcel Data and landgrid.com,

A summary of updates in February of 2021 and the upcoming pipeline is below. 

Key Data Stats:

  • Average parcel age - 209 days, up from 198 last month.
  • Average county age - 267 days, down from 275 last month.
  • Added 105,129 parcels and refreshed 161 counties since last month.


USPS Vacancy, Residential indicators: Now updated monthly. Updated in February 2021, next update in March.

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 Standard 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 February and live now:
( Asterisk * indicates newly added county)
--------------------------------------------------

Hawaii - Hawaii, Honolulu, Kalawao, Kauai, Maui
Illinois - Vermilion
Kentucky - Jefferson
Nebraska - Adams, Antelope, Arthur, Banner, Blaine, Boone, Box Butte, Boyd, Brown, Buffalo, Burt, Butler, Cass, Cedar, Chase, Cherry, Cheyenne, Clay, Colfax, Cuming, Custer, Dakota, Dawes, Dawson, Deuel, Dixon, Douglas, Fillmore, Franklin, Frontier, Furnas, Gage, Garden, Garfield, Gosper, Grant, Greeley, Hall, Hamilton, Harlan, Hayes, Hitchcock, Holt, Hooker, Howard, Jefferson, Johnson, Kearney, Keith, Keya Paha, Kimball, Knox, Lancaster, Lincoln, Logan, Loup, Madison, McPherson, Merrick, Morrill, Nance, Nemaha, Nuckolls, Otoe, Pawnee, Perkins, Phelps, Pierce, Platte, Polk, Red Willow, Richardson, Rock, Saline, Sarpy, Saunders, Seward, Sheridan, Sherman, Sioux, Stanton, Thayer, Thomas, Thurston, Valley, Washington, Wayne, Webster, Wheeler, York
Oregon - Benton
Pennsylvania - Adams, Allegheny, Beaver, Bedford, Berks, Blair, Bradford, Bucks, Butler, Cambria, Carbon, Centre, Chester, Clarion, Clinton, Columbia, Crawford, Cumberland, Dauphin, Delaware, Erie, Fayette, Forest, Franklin, Fulton, Greene, Huntingdon, Juniata, Lackawanna, Lancaster, Lawrence, Lebanon, Lehigh, Luzerne, Lycoming, McKean, Mercer, Mifflin, Monroe, Montgomery, Montour, Northampton, Northumberland, Perry, Philadelphia, Pike, Potter, Schuylkill, Snyder, Somerset, Sullivan, Susquehanna, Tioga, Union, Venango, Warren, Washington, Wayne, Westmoreland, Wyoming, York
Texas - Bexar
Wisconsin - Milwaukee

In the current pipeline for updating in March 2021
--------------------------------------------------
Alaska
Idaho
Minnesota
Oklahoma
Rhode Island
Vermont
Michigan


In the pipeline for updating in April 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!

 

Blake Girardot

blake@landgrid.com

Loveland Data Team

313-649-LAND