×   Landgrid Letter from the CEO on the upcoming July Launch & Rebrand

The Loveland Blog

Page 2

Loveland's Standardized Land Use Codes

By Ray Visser on February 19, 2021 · How-To

 

The parcel data made available by counties across the US varies widely in how land use is classified (if that information is available at all). Our standardized land use codes describe each parcel across five dimensions (Activity, Function, Structure, Site, and Ownership). These codes are 4-digit numbers, with the first digit denoting the broadest category, and each successive digit describing the parcel in more detail. For example, in the Activity dimension:

 

  • An Activity code of 3000 means 'Industrial, manufacturing, and waste-related activities'.

  • An Activity code of 3100 has one more digit of detail--it still falls under the above description, but it refers to 'Plant, factory, or heavy goods storage or handling activities'.

  • An Activity code of 3120 means 'Primarily goods storage or handling activities'--still industrial in nature, and related to plant, factory, or heavy goods storage or handling, but much more specific!

 

In the image below, where codes are indented to show their hierarchy, you can see how an Activity code of 3120 is just one of several different codes (e.g. 3110, 3120, 3210, 3220, 3230) at the same level of specificity (three digits):

 

A block of text, indented to show the hierarchical relationships between each line. The text reads "3000 # Industrial, manufacturing, and waste-related activities; 3100 # Plant, factory, or heavy goods storage or handling activities; 3110 # Primarily plant or factory-type activities; 3120 # Primarily goods storage or handling activities; 3200 # Solid waste management activities; 3210 # Solid waste collection and storage; 3220 # Landfilling or dumping; 3230 # Waste processing or recycling"

 

When you expand this potential for specificity across five dimensions, each intended to describe an aspect of the land use for a particular parcel, you can see how useful Loveland's standardized land use codes can be to identify land used for general or specific purposes.

 

Our standardized land use codes are derived from the Land-Based Classification System (LBCS), a method devised by the American Planning Association. Activity describes the actual human activities that take place on the parcel, while Function describes the broader economic or social use the parcel serves. Structure and Site describe the type of structure on a parcel and, independently, whether the parcel is developed or not. Ownership describes whether the owner of the parcel is a public or private entity.

 

The five-dimension approach gives a sense of what is actually there for any given parcel, and we fill as many of the five dimensions as we can when we apply our standardized land use codes. This work is done manually, county by county, matching each place's assessor-provided land use information (where available) to the applicable codes for each dimension. For example, a parcel that is used as a parking lot for a public school would be encoded like this using our system:

 

  • Activity: 5210 (Vehicular parking, storage, etc.)

  • Function: 6100 (Educational services)

  • Structure: 5200 (Automobile parking facilities)

  • Site: 5300 (Developed site with roads, train tracks, and other linear structures)

  • Ownership: 6100 (Nonprofit educational)

 

Whereas, in a traditional single-dimension system, a choice would have to be made between classifying that same school parking lot as simply "parking" or "educational", or possibly even just "public property".

 

Currently, in the top 50 metro areas in the country, over 80% of parcels have codes for Activity and Function, and over 60% have codes for Structure and Site. In Loveland's entire nationwide dataset of more than 147 million parcels, two-thirds of all parcels have a standardized land use code for Activity and Function. We continually add new places and fill in codes for existing ones. You can stay up to date on which places have standardized land use codes using our coverage report.

 

In addition to the standardized land use codes, our data also includes human-readable '_description' fields for each dimension. To use the same example from earlier, an 'lbcs_activity' value of 3120 would have an 'lbcs_activity_description' value of 'Primarily goods storage or handling'. We keep the standardized land use codes and text descriptions separate to allow for easier processing and sorting of our data.

 

Users of Loveland's data and the mapping platform can perform queries to find patterns across the dataset, or to count certain types of parcels. Our Border Parcels project shows how our standardized land use codes can be used to generate insights into how land is used across areas of interest that span multiple states and counties, each of which provided entirely separate and incompatible land use data.

 

 

Likewise, finding and mapping all the residential parcels in a city could help with understanding and tracking the spread of disease outbreaks like the current COVID-19 pandemic. If you are a local government or a fellow mapping and data company that could use parcel data to push forward your study, outreach efforts and research on COVID-19, or if you have questions about LBCS in general, please contact us at team@landgrid.com, or check out the parcel data FAQ.

 

Happy Mapping!

 

Ray Visser

ray@landgrid.com

Loveland Data Team

313-649-LAND

 

 

Jan 2021 - Parcel Data Update

By Sahana Murthy on January 15, 2021 · How-To

Dear Friends of Loveland Parcel Data and landgrid.com,

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

Key Data Stats:

  • Average parcel age - 205 days, up from 193 last month.
  • Average county age - 277 days, up from 254 last month.
  • Added 41,571 parcels and refreshed 82 counties since last month. 


In keeping with these stats, please take a moment to review our end of the year parcel data report from 2020 - This report shows all the key improvements we made to our data in 2020 - https://landgrid.com/reports/2020report 



USPS Vacancy, Residential indicators: Now updated monthly. Updated in December 2020, next update in January.

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

California - El Dorado

Georgia - Chatham, Cobb, DeKalb, Gwinnett

Indiana - Allen, Hamilton, Lake, Madison, Marion, St. Joseph, Vanderburgh

Kentucky - Oldham

Michigan - Branch, Menominee, Oakland

Minnesota - Mower

Missouri - Adair, Cole, Jackson, Madison, St. Louis City, Ste. Genevieve, Wayne

Northern Mariana Islands - Rota, Saipan, Tinian

North Carolina - Mecklenburg, Wake

Ohio - Pickaway

Oregon - Multnomah

Pennsylvania - Philadelphia

South Carolina - Abbeville, Aiken, Allendale, Anderson, Bamberg, Beaufort, Berkeley, Calhoun, Charleston, Cherokee, Chester, Chesterfield, Colleton, Darlington, Dillon, Dorchester, Edgefield, Fairfield, Florence, Georgetown, Greenville, Greenwood, Hampton, Horry, Jasper, Kershaw, Lancaster, Laurens, Lee, Lexington, Marion, Marlboro, McCormick, Newberry, Oconee, Orangeburg, Pickens, Richland, Saluda, Spartanburg, Sumter, Union, Williamsburg, York

Tennessee - Shelby

Texas - Tarrant

Virginia - Mecklenburg, Rockingham

Wisconsin - Milwaukee

In the current pipeline for updating in January 2021
--------------------------------------------------
West Virginia
Wyoming

Washington
North Carolina
Oregon


In the pipeline for updating in February 2021
--------------------------------------------------
Alaska
Hawaii
Indiana
Pennsylvania


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

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!