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 age - 248 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:
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:
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!
By Sahana Murthy
on April 28, 2020
Big Announcement: Updated Puerto Rico data from 2020, now available at Landgrid.com.
We are thrilled to announce that we now have the most recent, 2020 data available for Puerto Rico.
Well, we’ve had Puerto Rico data for some years -- and helped develop a plan and budget for a community-driven island-wide property survey that could still come to life one day if the time is right -- however, since 2016, we were unable to get updated, refreshed data for the island.
Not anymore! We recently received the most recent & updated data for all of Puerto Rico for 2020. That’s right - straight from a PR source.
We have added 38,635 additional parcels for Puerto Rico to our dataset: that brings us up to 1,523,802 parcels in total.
If you're looking for the latest data for all of Puerto Rico, and we know many of you are since we get asked for this a lot, you can see it on the site at https://landgrid.com/store/us/pr.
If you need to export the raw data for use outside the site, email us at email@example.com. It’s available for download and via API.
It is also available for self-serve download by the municipality on the Landgrid parcel data store: https://landgrid.com/store/us/pr
Loveland team members have made numerous visits to Puerto Rico and developed some good friendships on the island since Maria. We look forward to being back when the pandemic passes and it's safe to travel, and we hope to be helpful on more local projects in the future.
Below, find some notable improvements & updates between the data we had in 2016 and the data we have now:
Data from 2016
NEW PR Data (2020)
Ll_uuid (total number of unique parcels)
715,569 (Woo Hoo)
Last Sale Date
Hurricane Maria - Brief Analysis:
Our latest data update for PR also gave us some key insights into the possible impact of Hurricane Maria on the island’s property landscape - since Hurricane Maria hit Puerto Rico on Sept. 20, 2017, we have one dataset prior to the hurricane and one after.
Please bear in mind that the data we discuss below can NOT be directly a result or impact of Maria (although speculatively, they could very well be). It's also not possible for us to know the details of how the data is updated and maintained, and what might be missing that would add additional insight or otherwise impact the conclusions we draw below. We share some observations from the data here to help prompt further research and greater understanding of how things are changing over time.
Topo map, rainfall amounts, and Hurricane Maria’s path across Puerto Rico. Image from USGS. ^
A 'mailing address' is the place of record where an owner wants information (tax bills, other correspondence to property owners from the municipal government) to be sent. This makes it interesting data for analysis.
properties with non-Puerto Rico mailing addresses ^
- About 9% of Puerto Rico’s parcels for which we have owner mailing info list a non-PR mailing address currently. There are a further 1,600 properties that list a P.O. Box as the mailing address, for which location is difficult to determine.
It’s worth noting here that it’s not possible to break out how much of this ownership is former Puerto Rico residents who now live abroad, and how much represents external investment / non-Puerto Rican ownership.
Top 5 states with non-PR mailing addresses:
New York: 8,756
New Jersey: 3,294
- There were 4,064 purchases in the 2.5 years since Maria (ie from Maria until March 2020) that list a non-PR owner mailing address. For context, there were 3,081 out-of-state purchases in the 2.5 years prior, showing a 24% increase since Hurricane Maria.
Sale Data (Pre & Post Maria)
In an attempt to compare apples to apples as much as possible within this quick analysis, we took Hurricane Maria as the inflection point. Since we’re just about 2.5 years after Maria as of this writing, we took a corresponding 2.5 years prior to Maria (March 2015). All post- and pre- Maria data below, unless otherwise noted, are working with this 2.5 year span on either side.
- In terms of overall sales numbers, we see a 10% decrease in volume:
- There was a corresponding decline in sales greater than $100,000:
Sales pre-Maria over $100,000
Sales post-Maria over $100,000
- In general, median sales prices fell in Puerto Rico after the hurricane. One exception was the San Juan area, which saw a rise in prices. While one might think that this market activity in San Juan might be related to outside investment, we found nothing to indicate that that was the case: sales in that area were no more likely to have non-PR addresses than on the island as a whole (right around 10%).
There's much more to be learned from this dataset. If our software or the data itself can be helpful to your work, research, or advocacy in Puerto Rico please email us at firstname.lastname@example.org.
- The Landgrid Team
By Nick Downer
on April 21, 2020
Hey all, this is Nick with Landgrid. I thought I’d do a quick blog post to talk a little bit about how excited we are to be able to offer white labeling services to our clients, and explain why we’re so stoked.
You already know that Loveland makes fantastic GIS software for visualizing and managing property information out of the box via our flagship platform, Landgrid.com. However, many of our most powerful projects have customized the look and feel of our software to the exact needs of a business, government, or community development organization (the Flint Property Portal is a great example).
In the past these projects were one-offs, meaning that the cool features that we made for one client we couldn’t easily replicate for others. What we have now for the first time is the ability to create these for pretty much any Enterprise customer who would like one, at scale.
What this means:
No matter what you’re using our platform and/or data for, we can customize a site that’ll make it all about you and your needs. We can change the look and feel of the site visually, as well as highlighting the information you need and removing anything you don’t. If you’ve ever thought “I wish I could do X thing with this data”, the time has come - now you can. I think you’ll agree, that’s pretty compelling.
So, what exactly is a white label? Glad you asked, and here’s a handy graphic to help explain.
As you can probably gather, white labeling is a broad concept and can apply to a lot of potential use cases, which is one of the reasons I think it’s so cool. For existing clients, white labeling can really supercharge the impact, utility, and visibility of their work with Landgrid; in addition, I also anticipate a whole swath of potential new customers for whom we suddenly become relevant and attractive.
Rather than continuing in generalities, I thought I’d lay out some specific examples of things that white labeling now allows us to get into via some friendly hypotheticals. If any of these spark an idea for you, your business, or someone you know, please check out our revamped Enterprise page and shoot me an email at email@example.com. As always, we’re more than happy to talk through the details as they relate to you specifically - we're a friendly bunch and love to take customers all the way from concept to finished product.
You’re a real estate company with a portfolio of properties which you hold and/or manage. Your investors want to be able to quickly and easily see which properties are owned, status updates as they occur, and track potential future investments.
With a white labeled site, you can give your investors access to a private site at a URL of your choosing, with your companies’ branding, that color-codes properties by ownership or as potential leads. Property managers during their daily work or staff scoping out potential acquisitions use the Landgrid app to snap photos and make notes about properties, all of which shows up in real time on a customized field.
You’re a realtor whose primary interest is in a specific region (or regions) of the country. You want the latest property transfer data as well as any other metrics you can get your hands on that will help you determine which properties to take on and how to market them.
We’re bulking up our customizations so that you could set up a white label solution that pulls the metrics you’re interested in onto an Insights dashboard. You could see the number and sales value of properties sold in an area over time, bookmark properties you want to check out, and set up a data integration so that other sales data you have access to flows into your Landgrid account automatically.
You’re a real estate investor, and you specialize in certain types of properties (commercial, vacant lots, residential rehab, etc). You need access to data that will give you an edge on finding these properties before your competitors.
Here, we’d set up some customizations on an Insights dashboard that could flag properties that fit your criteria as soon as they become available, in addition to some premade maps that would (for example) color code vacant commercial structures as yellow, vacant residential structures as blue, etc. Using this information, you could either go out and visit them in person with our survey app, or use it as a starting point to do outreach to the owners of those properties or other research.
You’re a land bank, and you need a way to track properties from abandonment and vacancy, through acquisition, all the way to sale and transfer to new owners. You have hundreds of these properties, and it’s becoming a huge hassle to keep track of them all and make sure you have the most current data for any given property!
First of all, if you were using a database software to track properties, we could integrate with that - so that changes you make there get reflected onto our map. If you were doing it more, let’s say, “old school” via paper or a simple spreadsheet, we would be happy to consult, design and set up a new workflow for you that uses Landgrid primarily, making far more efficient use of you and your staff’s time going forward.
You’re concerned with the increasing number of tax delinquent properties in your area, and you need segmented data, as well as a way of tracking outreach to residents.
We could set you up with a custom site that would have a handful of premade maps: one highlighting tax delinquent properties, one highlighting properties that have had outreach (what, when, and status), and a handful of other premade maps showing things like valuation and transfers so that you can anticipate which areas to pay special attention to in the coming months.
You're a municipal government looking for a user-friendly way to publicly show the various investments and projects being undertaken by the city, because you value transparency and open data.
We’d set up for you an attractive public-facing interface as well as the training needed for staff to input data; premade maps for each area (streetscape improvements, paving projects, tree planting, etc) could be created. All data could be integrated with an existing Open Data portal if it exists for easy resident download, and/or we could host those downloads on the white labeled site itself.
You’re digitizing hard-copy historic data (Census, building records, sales data, photos, etc) and you need a platform to input this data and tie it to the current parcel. You want the final product to be available to other researchers in the future.
Rather than recreate the wheel, you can use a site with Landgrid’s parcels as a georeferenced base on which to append your data. This site can be used by any number of staff while digitizing to submit records, and once the project is complete, you could work with Landgrid staff to visualize the data in whatever way feels most compelling. Project leaders could view productivity stats for staff working on the project, review digitized records, and flag any in need of further review.
You want a dashboard that can track investments you’ve made in a given city, or nationwide. In addition, you want to be able to easily see specific information that might inform data-driven decisions around equitable funding, and identify existing gaps in the funding you provide.
We can create an attractive interface that you can use to generate needed metrics for funders quickly ("we have funded 20 projects in ZIP code XYZ, 3 of which were arts & culture grants, and invested $3m") on a map which can be private or public.