The Loveland Blog

November 2020 - Landgrid Parcel Data Update

By Sahana Murthy on November 5, 2020 · How-To

Dear Friends of Loveland Parcel Data and landgrid.com,

A summary of updates in October of 2020 and the upcoming pipeline is below. 

Key Data Stats:

  • Average parcel age - 207 days, the same as last month.
  • Average county age - 248 days, down from 249 last month. 
  • ~ 214K parcels added & 225 counties refreshed.


Loveland Parcel Schema - Upcoming changes
Please review the Data Dictionary below for the proposed attribute columns to add. Cropland Data Layer attributes will be added to the schema for next month's export. We are also adding in an additional mailing address related field, 'mail_country'. This month, the schema is the same as is has been, all the schema changes start with next month's exports.

USPS Vacancy, Residential indicators: Now updated monthly. Updated in October 2020, next update in November.

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 September and live now:
( Asterisk * indicates newly added county)
--------------------------------------------------
Delaware - Kent, New Castle, Sussex
Illinois - Adams, Bond, Boone, Bureau, Calhoun, Champaign, Christian, Clark, Clay, Clinton, Coles, Crawford, Cumberland, De Witt, Douglas, DuPage, Edgar, Effingham, Fayette, Ford, Franklin, Fulton, Gallatin, Grundy, Hamilton, Hancock, Henderson, Henry, Iroquois, Jackson, Jasper, Jefferson, Jersey, Kane, Kankakee, Kendall, Knox, Lake, Lawrence, Lee, Logan, Macon, Marion, Marshall, Mason, Massac, McDonough, McHenry, McLean, Menard, Monroe, Morgan, Moultrie, Peoria, Perry, Piatt, Pike, Randolph, Richland, Rock Island, Sangamon, Schuyler, Shelby, St. Clair, Stark, Stephenson, Tazewell, Vermilion, Warren, Washington, White, Whiteside, Will, Williamson, Winnebago, Woodford
Michigan - Missaukee
New York - Erie
Ohio - Lucas
Pennsylvania - Delaware, Lehigh
Tennessee - Blount, Bradley, Carter, Cheatham, Davidson, Hamilton, Jefferson, Knox, Lincoln, Maury, Montgomery, Robertson, Sevier, Sullivan, Tipton, Unicoi, Warren, Washington
Texas - Milam
Virginia - Accomack, Albemarle, Alexandria, Alleghany, Amelia, Amherst, Appomattox, Arlington, Augusta, Bath, Bedford, Bland, Botetourt, Bristol, Buchanan, Campbell, Caroline, Carroll, Charles City, Charlotte, Charlottesville, Chesapeake, Chesterfield, Clarke, Colonial Heights, Covington, Culpeper, Danville, Dinwiddie, Emporia, Essex, Fairfax City, Falls Church, Fauquier, Floyd, Fluvanna, Franklin, Franklin City, Frederick, Fredericksburg, Galax, Giles, Gloucester, Goochland, Grayson, Greene, Greensville, Halifax, Hampton, Hanover, Harrisonburg, Henrico, Henry, Highland, Hopewell, Isle of Wight, James City, King George, King William, King and Queen, Lancaster, Lee, Lexington, Loudoun, Louisa, Lunenburg, Lynchburg, Madison, Manassas, Manassas Park, Martinsville, Mathews, Mecklenburg, Middlesex, Montgomery, Nelson, New Kent, Newport News, Norfolk, Northampton, Northumberland, Norton, Nottoway, Orange, Page, Patrick, Pittsylvania, Poquoson, Portsmouth, Powhatan, Prince Edward, Prince George, Prince William, Pulaski, Radford, Richmond, Richmond City, Roanoke, Roanoke City, Rockbridge, Russell, Salem, Scott, Shenandoah, Smyth, Southampton, Spotsylvania, Stafford, Staunton, Suffolk, Surry, Sussex, Tazewell, Virginia Beach, Warren, Washington, Waynesboro, Westmoreland, Williamsburg, Winchester, Wise, Wythe, York
Wisconsin - Milwaukee

In the current pipeline for updating in November 2020
--------------------------------------------------
Colorado
Florida
Ohio



In the pipeline for updating in December 2020
--------------------------------------------------
South Carolina

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!

October 2020 - Parcel Data Update

By Sahana Murthy on October 8, 2020 · How-To

 

Dear Friends of Loveland Parcel Data and landgrid.com,

A summary of updates in September of 2020 and the upcoming pipeline is below. 

Key Data Stats:

  • Total parcel age down by 2.6% from last month
  • Average parcel age - 207 days, down from 213 last month
  • Average county age - 249 days, up from 240 last month
  • ~160K new parcels, 9 new counties added & 236 counties refreshed since last month.

Q3 Update:

  • Total # counties refreshed in Q3 2020 - 648 

General data update process -  We are improving our data set export process over the coming quarter and the first stage is documenting our current method which is below.

Monthly, we update every data tier with the refreshed counties for the month, usually 100 - 300 counties per month.

Monthly, premium attribute data tiers are updated for every county in the data set, because every county's USPS related attributes have been updated for the month.

Quarterly, at the start of the calendar quarter, every data tier will have every county exported. We make improvements to the nationwide data set on a regular basis, often based on feedback from clients. Quarterly, full data set exports ensure every data tier has all of the improvements across the data set, even if the data was not refreshed directly from the county that quarter. We are working to provide an easily sharable change log for data set wide fixes, but currently give a notice to significant updates in our monthly data update emails.

This month's October data set export will be the full Quarterly export for the 4th calendar quarter of 2020, which means every data tier and county has been exported. Please see the 'verse' file for the 'last_refresh' date from the county source for any individual county. 

USPS Vacancy, Residential indicators: Now updated monthly. Updated in September 2020, next update in October.

Loveland Parcel Schema - Upcoming changes
Please review the Data Dictionary below for the proposed attribute columns to add. We expect to add the Cropland Data Layer attributes to our Loveland Parcel Schema in October. We also hope to review the needed schema changes for the Census School Districts, which we expect to be 2 - 4 additional attribute columns and get those finalized, but those might be added in November.

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 landrid.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 September and live now:
( Asterisk * indicates newly added county)
--------------------------------------------------
Alabama - Hale
Illinois - LaSalle, Macoupin, Putnam
Maryland - Allegany, Anne Arundel, Calvert, Caroline, Carroll, Cecil, Charles, Dorchester, Frederick, Harford, Howard, Kent, Queen Anne's, St. Mary's, Talbot, Wicomico, Worcester
Montana - Beaverhead, Big Horn, Blaine, Broadwater, Carbon, Carter, Cascade, Chouteau, Custer, Daniels, Dawson, Deer Lodge, Fallon, Fergus, Flathead, Gallatin, Garfield, Glacier, Golden Valley, Granite, Hill, Jefferson, Judith Basin, Lake, Lewis and Clark, Liberty, Lincoln, Madison, McCone, Meagher, Mineral, Missoula, Musselshell, Park, Petroleum, Phillips, Pondera, Powder River, Powell, Prairie, Ravalli, Richland, Roosevelt, Rosebud, Sanders, Sheridan, Silver Bow, Stillwater, Sweet Grass, Teton, Toole, Treasure, Valley, Wheatland, Wibaux, Yellowstone 
South Carolina - Barnwell*, Clarendon*, Lee
Texas - Harris
Virginia - Buckingham
Wisconsin - Milwaukee

In the current pipeline for updating in October 2020
--------------------------------------------------
Virginia
Florida

In the pipeline for updating in November
--------------------------------------------------
Ohio
South Carolina

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!

August Parcel Data Update

By Sahana Murthy on August 10, 2020 · How-To

Dear Friends of Loveland Parcel Data and landgrid.com,

A lot of important information in this one!
A summary of updates in July of 2020 and the upcoming pipeline is below. 

Key Data Stats:

  • Total parcel age down by 3.5% from last month
  • Average parcel age - 196 days, down from 205 last month
  • Average county age - 215 days, down from 239 last month
  • ~903K new parcels, 71 new counties added & 146 counties refreshed since last month

Land Based Classification System (LBCS) Use Codes update:
We now have over 70% of our parcels with an LBCS code.

Readable LBCS code descriptions - new columns: 
Added the description for each code to every parcel. 

Shapefile Important Information:
Starting this month we have made the following changes to help flag the counties whose data exceeds the 2GB soft limit. Please double check how you are handling these files.

Duplicate Parcel Records:
We are in the process of identifying and removing about 218,000 truly duplicated parcel records across our dataset. Many counties 'stack' parcels to record multiple owners or multiple units, natural resource rights, etc. These situations are expected and they are still considered good data. As a result, these stacked parcels are not affected.

However, we have found a number of parcel records that are actual duplicates, with nothing unique or different between them in any way aside from the 'll_uuid' we assigned each duplicate record.

We will be removing those in August and exporting the corrected counties (918) in September. About 40 counties account for most of the duplicates, and 800 had less than 1% affected parcels. 

We are not sure what caused the issue, but we will put monitoring in place to determine if these are duplicates in the sources or something else is happening to cause them.

USPS Vacancy, Residential indicators:
Now updated monthly. Updated in July 2020, next update in August.

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 landrid.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 July and live now:
( Asterisk * indicates newly added county)
--------------------------------------------------
Alabama - Houston

Arizona- Apache, Cochise, Coconino, Gila, Graham, Greenlee, La Paz, Maricopa, Mohave, Navajo, Pima, Pinal, Santa Cruz, Yavapai, Yuma

California - Glenn, Mendocino, San Benito, San Francisco

District of Columbia - Washington

Georgia (55 new counties) - Appling*, Baker*, Banks*, Barrow*, Bleckley*, Butts*, Calhoun*, Candler*, Catoosa*, Chattahoochee*, Chattooga*, Clay*, Clinch*, Colquitt*, Decatur*, Dodge*, Dooly*, Early*, Elbert*, Emanuel*, Franklin*, Glascock*, Hancock*, Harris*, Hart*, Heard*, Jasper*, Jefferson*, Jenkins*, Johnson*, Lamar*, Lanier*, Madison*, Marion*, Meriwether*, Miller*, Montgomery*, Morgan*, Oconee*, Peach*, Pickens*, Pike*, Quitman*, Rabun*, Schley*, Spalding*, Stewart*, Taliaferro*, Tattnall*, Terrell*, Toombs*, Towns*, Treutlen*, Twiggs*, Upson*, Walker*, Walton*, Warren*, Wayne*, Webster*, Wheeler*, Wilkinson*, Worth*, Baldwin, Ben Hill, Brantley, Dade, Evans, Gilmer, Grady, Greene, Laurens, Lee, Lincoln, Long, Lumpkin, Mitchell, Pulaski, Randolph, Rockdale, Seminole, Stephens, Talbot, Taylor, Ware, White, Whitfield 

Illinois - Adams, Crawford, DeKalb, Effingham*, Hancock, Lee, Menard, Pike, Sangamon, Tazewell, Whiteside

Indiana - Grant, Porter

Louisiana - Ouachita

Massachusetts - Barnstable, Berkshire, Bristol, Dukes, Essex, Franklin, Hampden, Hampshire, Middlesex, Nantucket, Norfolk, Plymouth, Suffolk, Worcester

Michigan - Allegan, Arenac, Charlevoix, Cheboygan, Eaton, Emmet, Grand Traverse, Ingham, Ionia, Iron, Jackson, Kent, Lapeer, Leelanau, Lenawee, Marquette, Midland, Montcalm, Muskegon, Newaygo, Oceana, Ottawa, Roscommon, Saginaw, St. Clair, Tuscola, Washtenaw

Missouri - Andrew, Atchison, Bates, Benton, Buchanan, Camden, Christian, Cooper, Dallas, Douglas*, Franklin*, Henry, Holt, Laclede*, Lafayette, Lawrence, Lincoln, Linn, Macon*, Miller, Moniteau, Morgan, Phelps, Ralls, Ray, Vernon, Warren

North Dakota - Billings, Bottineau, Bowman*, Burke, Burleigh, Cass, Cavalier, Divide, Dunn, Emmons, Foster*, Golden Valley, Grant, Hettinger, LaMoure, McHenry, McKenzie, McLean, Morton, Mountrail, Nelson*, Pembina, Renville*, Richland, Rolette, Sargent*, Sheridan*, Sioux, Stark, Steele, Traill, Walsh, Ward, Williams

Nebraska - Arthur, Box Butte

New York - Cortland, Genesee, Madison*, Tioga

Oklahoma - Pottawatomie*

Oregon - Columbia, Umatilla

Pennsylvania - Indiana*, Union, Venango*

South Dakota - Aurora, Beadle, Bennett, Bon Homme, Buffalo, Campbell, Clark, Codington, Custer, Davison, Day, Deuel, Douglas, Edmunds, Fall River, Faulk, Grant, Gregory, Hamlin, Hanson, Hutchinson, Jackson, Jerauld, Jones, Kingsbury, Lake, Lawrence, Lincoln, Lyman, Marshall, McPherson, Meade, Mellette, Miner, Minnehaha, Moody, Oglala Lakota, Pennington, Roberts, Sanborn, Tripp, Union, Yankton

Tennessee - Shelby

Texas - Ochiltree

Wisconsin - Adams, Ashland, Barron, Bayfield, Brown, Buffalo, Burnett, Calumet, Chippewa, Clark, Columbia, Crawford, Dane, Dodge, Door, Douglas, Dunn, Eau Claire, Florence, Fond du Lac, Forest, Grant, Green, Green Lake, Iowa, Iron, Jackson, Jefferson, Juneau, Kenosha, Kewaunee, La Crosse, Lafayette, Langlade, Lincoln, Manitowoc, Marathon, Marinette, Marquette, Menominee, Milwaukee, Monroe, Oconto, Oneida, Outagamie, Ozaukee, Pepin, Pierce, Polk, Portage, Price, Racine, Richland, Rock, Rusk, Sauk, Sawyer, Shawano, Sheboygan, St. Croix, Taylor, Trempealeau, Vernon, Vilas, Walworth, Washburn, Washington, Waukesha, Waupaca, Waushara, Winnebago, Wood

In the current pipeline for updating in August 2020
--------------------------------------------------
Michigan - Balance of state
New York - Balance of state


In the pipeline for updating in September
--------------------------------------------------
California
Illinois

Tennessee

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, 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 Loveland!

Happy Mapping!

 

 

June 2020 - Parcel Data Update

By Sahana Murthy on June 11, 2020 · How-To

A summary of updates in May of 2020 and the upcoming pipeline is below. 

Key Data Stats:

  • Total age down by 1.5% from last month
  • Average parcel age - 217 days, down from 221 last month
  • Average county age - 241 days, down from 248 last month
  • 638K new parcels added online since last month


SPECIAL NOTE - USPS Vacancy, Residential indicators: Now updated monthly. Updated in May 2020, next update in June! 

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 landrid.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 May and live now:
( Asterisk * indicates newly added county)
--------------------------------------------------
Alabama - Baldwin, Barbour, Blount, Bullock, Butler, Calhoun, Cherokee, Cleburne, Coffee, Colbert, Coosa, Crenshaw, Cullman, Dale, Dallas, DeKalb, Elmore, Etowah, Fayette, Franklin, Geneva, Greene, Hale, Henry, Jackson, Jefferson, Lauderdale, Lawrence, Lee, Limestone, Macon, Madison, Marshall, Mobile, Monroe, Montgomery, Morgan, Randolph, Russell, Shelby, St. Clair, Sumter, Talladega, Tuscaloosa 

Illinois - Clark, De Witt, Logan, McDonough, Macon, Stephenson

Louisiana - Acadia, Ascension, Assumption, Avoyelles, Beauregard, Bossier, Caddo, Calcasieu, Catahoula, Claiborne, Concordia, De Soto, East Baton Rouge, East Feliciana, Evangeline*, Franklin, Grant, Iberia, Iberville, Jackson, Jefferson, La Salle, Lafayette, Lafourche, Lincoln, Livingston, Natchitoches, Orleans, Plaquemines, Pointe Coupee, Red River, Richland, St. Bernard*, St. Charles, St. James, St. John the Baptist, St. Landry, St. Martin, St. Mary, St. Tammany, Tangipahoa, Terrebonne, Union*, Vernon, Washington, Webster, West Feliciana

Maryland - 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

Missouri - Barry*

North Dakota - Burke, Cass, Dividse, Mountrail, Traill, Williams

Nebraska - Dodge, Fillmore, Frontier, Nuckolls

Oklahoma - Alfalfa, Canadian, Carter, Cleveland, Coal, Comanche, Creek, Delaware, Grady, Harper, Haskell, Jackson, Johnston, Lincoln, Love, McCurtain, Murray, Noble, Oklahoma, Osage, Payne, Rogers, Sequoyah, Tulsa, Woodward

South Dakota - Davison, Douglas, Faulk, Hanson, Hutchinson, Jerauld, Minnehaha, Sanborn

Texas - Anderson, Andrews, Angelina, Aransas, Archer*, Armstrong, Atascosa, Austin, Bailey, Bandera, Bastrop, Baylor, Bee, Bell, Bexar, Blanco, Borden, Bosque, Bowie, Brazoria, Brazos, Brewster, Brooks, Brown, Burleson, Burnet, Caldwell, Calhoun, Callahan, Cameron, Camp, Carson, Cass, Castro*, Chambers, Cherokee, Childress, Clay*, Cochran, Coke, Collin, Collingsworth*, Colorado, Comal, Comanche, Concho, Cooke, Coryell, Cottle, Crane, Crockett*, Culberson, Dallam, Dallas, Dawson*, Deaf Smith, Delta, Denton, DeWitt, Dickens, Dimmit, Duval, Eastland, Ector, Edwards, Ellis, Erath*, Falls, Fannin, Fayette, Fisher, Floyd*, Foard, Fort Bend, Franklin, Freestone, Frio*, Gaines, Galveston, Gillespie, Glasscock, Goliad, Gonzales, Gray, Grayson, Gregg, Grimes, Guadalupe

US Virgin Islands - St. Croix*, St. John*, St. Thomas*

West Virginia - Barbour, Berkeley, Boone, Braxton, Brooke, Cabell, Calhoun, Clay, Doddridge, Fayette, Gilmer, Grant, Greenbrier, Hampshire, Hancock, Hardy, Harrison, Jackson, Jefferson, Kanawha, Lewis, Lincoln, Logan, Marion, Marshall, Mason, McDowell, Mercer, Mineral, Mingo, Monongalia, Monroe, Morgan, Nicholas, Ohio, Pendleton, Pleasants, Pocahontas, Preston, Putnam, Raleigh, Randolph, Ritchie, Roane, Summers, Taylor, Tucker, Tyler, Upshur, Wayne, Webster, Wetzel, Wirt, Wood, Wyoming

Wisconsin - Milwaukee

In the current pipeline for updating in June 2020
--------------------------------------------------
Texas - Remainder of state
Nevada - about 10 counties

In the pipeline for updating in July 
--------------------------------------------------
New Jersey

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, 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 Loveland!

Happy Mapping!