The Loveland Blog

July 2020 - Parcel Data Update

By Sahana Murthy on July 2, 2020 · Democratizing Data

Dear Friends of Loveland Parcel Data and landgrid.com,

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

Key Data Stats:

  • Total parcel age down by 5% from last month
  • Average parcel age - 205 days, down from 217 last month
  • Average county age - 239 days, down from 241 last month
  • ~500K parcels added online since last month

Quarterly Stats:

  • Q2 2020 - We refreshed 918 counties
  • Q1 2020 - We refreshed 929 counties


Land Based Classification System (LBCS) Use Codes update: We have been steadily standardizing county use and zoning codes into the LBCS standardized use codes for land use activity and function and have made some big improvements over the past month. We now have over 70% of our parcels with an LBCS code.

Readable LBCS code descriptions - new columns: Use codes are pretty dry and hard to understand when just numbers, so we added the description for each code to every parcel. Please take a look at these columns if land use or use codes are important to you, feedback is welcome.

Shapefile Important Information: We have had some support questions around shapefiles and have made some improvements to help with the issues shapefiles present. 

The shapefile format itself has a 'soft limit' of 2 gigabytes (GB) data. That means it is just a rule of the format "no data larger than 2GB" with no technical limit preventing more data being encoded as a shapefile. When we export large counties, our tools inform us the resulting shapefile is over that soft limit.

We can confirm that some software handles 2GB and larger shapefiles just fine (OSGeo tools), but some software will just silently ignore attribute data above the 2GB limit (ArcGIS). A sincere  thank you to the Loveland client who did a lot of in depth research and testing on this and shared their results with all of us.

Starting this month we have made the following changes to help flag the counties who's data exceeds the 2GB soft limit. Please double check how you are handling these files.

  1. The filenames themselves will indicate the county generated the 2GB warning on export. '2GB_WARN' will be added to the file names so you can know just by checking the name.
  2. We also added a column to our 'verse' table, named 'shapefile_size_flag' so you can check against the 'verse' table to see if a place is one that needs a different format than shapefile or generate a list of places you need to pull the alternate format for.


USPS Vacancy, Residential indicators: Now updated monthly. Updated in June 2020, 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 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)
--------------------------------------------------
California - Contra Costa
Florida - Miami-Dade
Georgia - Douglas, Fayette, Henry
Indiana - Elkhart
Michigan - Berrien*, Hillsdale*
New Jersey - Atlantic, Bergen, Burlington, Camden, Cape May, Cumberland, Essex, Gloucester, Hudson, Hunterdon, Mercer, Middlesex, Monmouth, Morris, Ocean, Passaic, Salem, Somerset, Sussex, Union, Warren
Nevada - Carson City, Churchill, Clark, Douglas, Elko, Eureka, Humboldt, Lander, Lincoln, Lyon, Mineral, Nye, Pershing, Storey, Washoe, White Pine
New York - Steuben
Ohio - Lucas, Medina, Portage
Texas - Briscoe*, El Paso, Hale, Hall, Hamilton*, Hansford, Hardeman*, Hardin, Harris, Harrison, Hartley, Haskell, Hays, Hemphill*, Henderson, Hidalgo, Hill, Hockley*, Hood, Hopkins*, Houston, Howard, Hudspeth*, Hunt, Irion, Jack*, Jackson*, Jasper, Jeff Davis, Jefferson, Jim Hogg, Jim Wells, Johnson, Jones, Karnes, Kaufman, Kendall, Kenedy*, Kent, Kerr, Kimble, King, Kinney, Kleberg, Knox*, La Salle, Lamar, Lamb, Lampasas, Lavaca, Lee, Liberty, Limestone, Lipscomb*, Live Oak, Llano, Loving, Lubbock, Lynn, Madison, Marion, Martin, Mason, Matagorda, Maverick, McCulloch, McLennan, McMullen, Medina, Menard, Midland, Milam, Mills, Mitchell, Montague, Montgomery, Moore, Morris, Motley*, Nacogdoches*, Navarro, Newton, Nolan, Nueces, Oldham*, Orange, Palo Pinto*, Panola, Parker, Parmer, Pecos, Polk, Potter, Presidio, Rains, Randall, Reagan, Real, Red River, Reeves, Refugio, Roberts*, Robertson, Rockwall, Runnels*, Rusk, Sabine*, San Augustine, San Jacinto, San Patricio, San Saba, Schleicher, Scurry, Shackelford, Shelby, Sherman*, Smith, Somervell, Starr, Stephens*, Sterling, Stonewall, Sutton, Swisher, Tarrant, Taylor, Terrell, Terry, Throckmorton, Titus, Tom Green, Travis, Trinity, Tyler, Upshur, Upton, Uvalde, Val Verde, Van Zandt, Victoria, Walker, Waller, Ward*, Washington, Webb, Wharton, Wheeler, Wichita, Wilbarger*, Willacy, Williamson, Wilson, Winkler, Wise*, Wood, Yoakum, Young, Zapata, Zavala

Wisconsin - Milwaukee

In the current pipeline for updating in July 2020
--------------------------------------------------
We have a wider range of states, but fewer counties in each one than the past few months. These will let us add some missing rural counties and refresh some larger metro areas.

California - 3
Georgia - 2
Illinois - 2
Louisiana - 1
Massachusetts - Statewide
Michigan - 2 
Missouri - 26 counties
New York - 4
Oklahoma - 1
Oregon - 2
Pennsylvania - 1
South Dakota - 6


In the pipeline for updating in August
--------------------------------------------------
Arizona
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, 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!

 

Blake Girardot

blake@landgrid.com

Loveland Data Team

313-649-LAND

Free as in Speech, Not Free as in Beer: Why Free and Open-Source Technology Benefits Everyone

By Sahana Murthy on June 27, 2020 · Democratizing Data

 

"We are excited to publish a guest blog post by the CEO - Pablo Fuentes & the team of our partner organization, makepath.

Please read to learn more about the power of open source. As long time proponents of open source technologies ourselves, many of which have helped power the Landgrid solution suite, we couldn't agree more with Pablo. Read on to learn how you could leverage open source tools to build the next best thing in your industry."

 

 

“...widespread use of open-source software tends to increase its value, as users fold in their own fixes and features (code patches). In this inverse commons, the grass grows taller when it’s grazed upon.”

Eric S. Raymond, Cathedral and the Bazaar: Musings on Linux and Open Source by an Accidental Revolutionary

 

Pioneers of the Free and Open-Source Software (FOSS) movement, such as Eric S. Raymond, lived by a simple mantra: if they liked a software program, it was their obligation to share it.  To them, making software “free” didn’t represent a more convenient choice or optimal solution. It was the most ethical decision one could make.

Initially, many business leaders balked at the idea of freely distributed software, but over time, it has gained wider acceptance and a devoted community of creators and developers.

Our company, makepath, specializes in geospatial technology and full-stack application development. We are active contributors to many open-source projects, such as Datashader and Bokeh, and our co-founder Brendan Collins created the xarray-spatial library for large scale spatial analysis. If you’re interested, here’s a recent blog post detailing our favorite open-source spatial analysis tools.

We are FOSS evangelists and believe that open-source technology not only encourages innovation and collaboration, but also makes businesses more profitable.

 

Free?! What do you mean free?

The idea of free software making businesses money may seem counterintuitive, so let us explain. 

“Free” doesn’t mean “costs zero dollars.” We think companies should charge whatever customers will pay for their software. 

“Free” in this context means that creators share the knowledge that powers this software with others, so that they can understand it, build upon it, and spread it further.

Open-source advocates describe this as the difference between “free beer and free speech,” an idea that is broken down in this blog post by How-to-Geek. 

To sum it up, a “free beer” is a wonderful present that begins and ends with you drinking the beer. The provider expects nothing in return, and it’s assumed that you’ll never ask for the recipe nor sell it to anyone else.

“Free Speech,” on the other hand, offers true freedom rather than an item that costs nothing. Anyone is free to study it, use it, spread it around, or build upon it, hopefully in ways that benefit the public good. This is the ideal that we aspire to.

 

But How is That Good for Business?

Here are a number of ways in which FOSS can strengthen your business: 

  1. Open-source tools are affordable, easily accessible, and customizable to individual needs.
  2. They can save time and energy, particularly with tools that are commoditized or that don’t offer a competitive advantage. Pendo Systems, a Fintech firm, estimates they saved 9,000 hours of labor and $500,000 by downloading open-source software instead of developing their own code for calculation engines.
  3. Users can continually iterate upon programs, meaning that there are frequent improvements, bug-fixes, and updates.
  4. Companies don’t have to spend money on licensing or expensive anti-piracy programs.
  5. Businesses also have the opportunity to give back, by adding their own innovations, sharing them, and enriching the entire FOSS community.

 

Case Study: The GeoNode Project

 

Source: Geonode.org

 

In 2009, The Global Facility for Disaster Reduction and Recovery (GFDRR), an organization run by the World Bank, started the GeoNode Project

GeoNode is an open-source platform designed to easily share geographical information, helping global communities respond quickly to natural disasters.

GFDRR adopted a strong open-source investment strategy to power GeoNode. In 2016, they commissioned a report to evaluate its performance.

The report found that GFDRR earned at least a 200% return on their investments during that time period. Organizations around the world implemented GeoNode’s software, and the project’s success attracted investment from public and private entities alike

In short, their commitment to open-source was a resounding success.

 

Democratizing Knowledge 

Open-source tools benefit users by liberating them from the constraints of proprietary software licenses. 

These tools embody the true spirit of the Internet - a free marketplace of ideas and services, a place where information is democratized for the greater good.

As Paul Ramsey said, “You get what you pay for, everyone gets what you pay for, and you get what everyone pays for….what could possibly be better than that?”

 

What are your favorite open-source tools?  Please let us know in the comments. If you have questions about how to deploy open-source spatial analysis tools, please reach out at contact@makepath.com.

 

Pablo Fuentes & the makepath team.

makepath

 

May 2020 - Parcel Data Update

By Sahana Murthy on May 11, 2020 · Democratizing Data

Dear Friends of Loveland Parcel Data and landgrid.com,

Key Data Stats:

  • Total age down by 5.9% from last month
  • Average parcel age - 221 days, down from 235 last month
  • Average county age248 days, down from 310 last month
  • 193k new parcels added online since last month

Updated Puerto Rico Data - We recently were able to get updated data from April 2020 for Puerto Rico. We refreshed our existing data last week and is available for download now. You can read all about the changes in the data we had and the data we have now in this blog - https://landgrid.com/blog/2020puertoricodata

SPECIAL NOTE - USPS Vacancy, Residential indicators: Updated in March 2020, next update in May!

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 updated or added from the county in April and live now:
--------------------------------------------------
( * Indicates newly added county)
Connecticut - Fairfield, Hartford, Litchfield, Middlesex, New Haven, New London, Tolland, Windham

Illinois - Grundy, Marshall, Mason*, McLean, Morgan, Putnam*, Schuyler, Woodford

Kansas - Allen, Anderson*, Atchison, Barber, Barton, Bourbon, Brown, Butler, Chase, Chautauqua, Cherokee, Cheyenne, Clark, Clay, Cloud, Coffey, Comanche, Cowley, Crawford, Decatur, Dickinson, Doniphan, Douglas, Edwards, Elk, Ellis, Ellsworth, Finney, Ford, Franklin*, Geary, Gove, Graham, Grant, Gray, Greeley, Greenwood*, Hamilton, Harper*, Harvey, Haskell, Hodgeman, Jackson, Jefferson, Kearny, Kingman, Kiowa, Labette, Lane, Leavenworth, Lincoln, Linn*, Logan, Lyon, Marion, Marshall, McPherson, Meade, Miami, Mitchell, Montgomery, Morris, Morton, Nemaha, Neosho, Ness, Norton, Osage, Osborne, Ottawa, Pawnee, Phillips, Pottawatomie, Pratt, Rawlins, Reno, Republic, Rice, Riley, Rooks, Rush, Russell, Saline, Scott, Seward, Shawnee, Sheridan, Sherman, Smith, Stafford, Stanton, Stevens, Sumner, Thomas, Trego, Wabaunsee, Wallace, Wichita, Wilson, Woodson, Wyandotte

Maine - Androscoggin, Aroostook, Cumberland, Franklin, Hancock, Kennebec, Knox, Lincoln, Oxford, Penobscot, Piscataquis, Sagadahoc, Somerset, Waldo, Washington, York

Minnesota - Aitkin, Anoka, Becker, Beltrami, Benton, Big Stone, Carlton, Carver, Cass, Chippewa, Chisago, Clay, Clearwater, Cook, Cottonwood, Crow Wing, Dakota, Dodge, Douglas, Faribault, Fillmore, Freeborn, Goodhue, Grant, Hennepin, Hubbard, Isanti, Itasca, Jackson, Kandiyohi, Kittson, Koochiching, Lake, Lake of the Woods, Le Sueur, Lyon, Mahnomen, Marshall, McLeod, Meeker, Mille Lacs, Nicollet, Norman, Olmsted, Otter Tail, Pennington, Pipestone, Polk, Pope, Ramsey, Red Lake, Renville, Rice, Roseau, Scott, Sherburne, Sibley, St. Louis, Stearns, Steele, Stevens, Swift, Todd, Traverse, Wadena, Waseca, Washington, Wilkin, Winona, Wright, Yellow Medicine

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

North Dakota - Billings, Burleigh, Dunn, Golden Valley, McKenzie, Stark

New Hampshire - Belknap, Carroll, Cheshire, Coos, Grafton, Hillsborough, Merrimack, Rockingham, Strafford, Sullivan

Puerto Rico - Adjuntas, Aguada, Aguadilla, Aguas Buenas, Aibonito, Arecibo, Arroyo, Añasco, 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, Guayama, Guayanilla, Guaynabo, Gurabo, Guánica, 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

South Dakota - Beadle, Charles Mix*, Clay*, Lincoln, Spink*, Union*

Tennessee - Davidson

Vermont - Addison, Bennington, Caledonia, Chittenden, Essex, Franklin, Grand Isle, Lamoille, Orange, Orleans, Rutland, Washington, Windham, Windsor

Wisconsin - Milwaukee

Wyoming - Albany, Big Horn, Campbell, Carbon, Converse, Crook, Fremont, Goshen, Hot Springs, Johnson, Laramie, Lincoln, Natrona, Niobrara, Park, Platte, Sheridan, Sublette, Sweetwater, Teton, Uinta, Washakie, Weston

Wisconsin - Milwaukee

In the current pipeline for updating in May 2020
--------------------------------------------------
Lousiana - Statewide
Maryland - Statewide
Oklahoma - Statewide
West Virginia - Statewide
US Virgin Islands


In the pipeline for updating in June
--------------------------------------------------
Texas - Statewide

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!

 

Parcel Data Update - April 2020

By Sahana Murthy on April 10, 2020 · Democratizing Data

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

April 2020 - Key Data Stats 
Current average parcel age  - 235,    down from 257 last month 
Current average county age - 310,  down from 350 last month

Q1 2020 - Key Data Stats 

Number of counties refreshed:


Q1 2020: 929 counties

Q1 2019: 610
Q2 2019: 454
Q3 2019: 292
Q4 2019: 722

The Landgrid Data Store: We recently launched the data store, to allow our customers to quickly buy county data on the go. Most of you have our nationwide & statewide data with updates. However, if some of you are interested in individual county data or a handful of counties, you can now just go straight to the data store and buy data by the county, hasslefree and without delays. 
https://landgrid.com/store

SPECIAL NOTE:  USPS Vacancy, Residential indicators:
Updated in March 2020.

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 updated or added from the county in March and live now:
(bold indicates a  newly added county)
--------------------------------------------------
California - San Diego

Hawaii - Hawaii, Honolulu, Kalawao, Kauai, Maui

Iowa - Statewide, all counties refreshed

Illinois - Ford

Kansas - Jewell, Sedgwick, Washington

Michigan - Wayne

Mississippi (7 newly added) - Adams, Alcorn, Amite, Attala, Benton, Bolivar, Calhoun, Carroll, Chickasaw, Choctaw, Claiborne, Clarke, Clay, Coahoma, Copiah, Covington, DeSoto, Forrest, Franklin, George, Greene, Grenada, Hancock, Harrison, Humphreys, Itawamba, Jackson, Jasper, Jefferson, Jefferson Davis, Jones, Kemper, Lafayette, Lamar, Lauderdale, Lawrence, Leake, Lee, Leflore, Lincoln, Lowndes, Madison, Marion, Marshall, Monroe, Montgomery, Neshoba, Newton, Noxubee, Oktibbeha, Panola, Pearl River, Perry, Pike, Pontotoc, Prentiss, Quitman, Rankin, Scott, Sharkey, Simpson, Smith, Stone, Tallahatchie, Tate, Tippah, Tishomingo, Union, Walthall, Warren, Washington, Wayne, Webster, Wilkinson, Winston, Yalobusha, Yazoo

New Mexico - Bernalillo, Chaves, Cibola, Colfax, Curry, De Baca, Doña Ana, Eddy, Grant, Harding, Hidalgo, Lea, Lincoln, Los Alamos, Luna, McKinley, Otero, Rio Arriba, Roosevelt, San Juan, Sandoval, Santa Fe, Sierra, Socorro, Taos, Torrance, Valencia

Pennsylvania (1 newly added) -  Adams, Allegheny, Beaver, Bedford, Berks, Blair, Bradford, Bucks, Butler, Cambria, Carbon, Centre, Chester, Clearfield, Clinton, Columbia, Crawford, Cumberland, Dauphin, Delaware, Erie, 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, Sullivan, Susquehanna, Tioga, Union, Warren, Washington, Wayne, Westmoreland, Wyoming, York

Rhode Island - Bristol, Kent, Newport, Providence, Washington

Wisconsin - Milwaukee

In the current pipeline for updating in April 2020
--------------------------------------------------
Connecticut - Statewide
Kansas - Statewide
Montana - Statewide
Tennessee - Davidson County
Wyoming - Statewide

In the pipeline for updating in May
--------------------------------------------------
Texas - Statewide

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!