Gerrit VanderWaal

Sometimes I give myself research projects and this is where I write up my findings.

email
linkedin
github
openstreetmap

Identifying potential corporate partners for habitat restoration

  1. Research
  2. Data
  3. Processing
  4. Result
  5. Discussion
  6. Next Steps

Habitat restoration can be expensive work. One way of making dollars go further is partnering with businesses that own land of interest to conservation: the business contributes money and access to their land, and the entity conducting restoration can achieve its goals.

Friends of the Mississippi River (FMR), a local nonprofit focused towards restoring and enhancing the environment in the watersheds around the Mississippi National River and Recreation Area (MNRRA), selectively partners with local businesses to manage their land in pursuit of conservation goals. How could FMR identify other businesses for similar parterships?

One way would be to generate a site suitability scheme for identifying areas ideal for conservation, then calculate which largest land parcels contain land that scores highly.

Fortunately, the Minnesota Department of Natural Resources (DNR) has already generated a suitability scheme that could fit FMR's purposes. In pursuit of the DNR's conservation goals, they use the Marxan software to identify priority areas for protecting biological diversity and have published a layer of such areas for the whole state, which will be referred to here as "SNACOA".

But how to identify landowners? The easiest way is through parcel data. Fortunatley, the Metropolitan Council aggregates parcel data for the seven metro counties (Anoka, Carver, Dakota, Hennepin, Ramsey, Scott, and Washington), which provides an effecient means of acquiring parcel data.

Accoring to FMR's "How we choose sites to protect and restore" page, FMR focuses their resources on the Twin Cities metropolitan area and "essential tributaries and lands that drain to the metro river". What this specifically means is ambiguous, but based on FMR's map of current restoration sites (see the "Protection and restoration sites" section), FMR generally limits their work areas to the seven metro counties and the six DNR Major Watersheds intersecting the MNRRA (Lower Minnesota River, Mississippi River - Lake Pepin/St. Cloud/Twin Cities, North Fork Crow River, and Rum River).

Accordingly, to identify only landowners in the seven metro counties with land of interest to FMR, the SNACOA can be clipped to the seven metro counties, then by the six watersheds.

To identify the entities owning land best suited to conservation efforts, the clipped SNACOA can be rasterized (using a 10 meter by 10 meter resolution), used as an input to Zonal Statistics in conjunction with the clipped parcel dataset, and queried with SQL to identify the top 10 parcels with the largest areas with the most land of conservation interest.

The output of this workflow reveals the largest landowners with the most land critical to conservation are farmers (or landlords of farmland).

Table 1: Top 10 Largest Parcels with Highest Priority for Conservation
Majority Mean Median
Acreage Taxpayer Acreage Taxpayer Acreage Taxpayer
483 Sever Peterson Family Trust 483 Sever Peterson Family Trust 483 Sever Peterson Family Trust
218 P Farm Hdg #3 Lp And H Notermann Tr 257 Spring Meadow Inc 218 P Farm Hdg #3 Lp And H Notermann Tr
214 Cargill Inc 218 P Farm Hdg #3 Lp And H Notermann Tr 214 Cargill Inc
155 Minnesota Valley Lands LLC 214 Cargill Inc 155 Minnesota Valley Lands LLC
154 Mid America Festivals Corp 155 Minnesota Valley Lands LLC 154 Mid America Festivals Corp
125 Valleyfair LLC 154 Mid America Festivals Corp 125 Valleyfair LLC
120 Shakopee Mdewakanton Sioux Community (SMSC) 125 Valleyfair LLC 115 Wellens Jr Charles A
115 Wellens Jr Charles A 120 SMSC 111 Merriam Properties LLC
111 Merriam Properties LLC 116 Tousley Douglas S [et al.] 111 Spring Hill Golf Club
111 Spring Hill Golf Club 115 Wellens Jr Charles A 103 MN Valley Lands Inc
Table 1: The most likely owner is linked. "Majority/Mean/Median" refers to the Zonal Statistics calculation: majority is the most common cell value in the parcel, mean is the mean cell value in the parcel, and median is the median cell value in the parcel. "Acreage" refers to the parcel acreage as calculated by the county. "Taxpayer" is the entity paying property taxes for the parcel and is assumed to also be the property owner.

SQL Query used to generate these results

SELECT * -- Return all columns from the selected feature layer
FROM input1 -- How the tool refers to its inputs; the number is iterated by one for each input
WHERE
[Zonal Statistics majority/mean/median field] > 4 AND -- 4 because that's the value associated with a "high" priority level in the SNACOA
(tax_name NOT LIKE '%north oaks%' AND tax_name NOT LIKE '%wildlife%' AND tax_name NOT LIKE '%natural resources%' AND tax_name NOT LIKE '%park district%' AND tax_name NOT LIKE '%city of%' AND tax_name NOT LIKE '%united states%' AND tax_name NOT LIKE '%state of%' AND tax_name NOT LIKE '%university%' AND tax_name NOT LIKE '%county%' AND tax_name NOT LIKE '%hennepin park%') -- removes taxpayers whose names indicate they're part of a governmental body since that's not the class of entities of interest
ORDER BY acres_poly DESC LIMIT 10 -- Return only the features with the top 10 largest surface areas by acres


In the Majority columns, taxpayers Sever Peterson Family Trust, P Farm Hdg #3 Lp And H Notermann Tr (possily "Peterson Farm Holding #3 LP and Howard Notermann Trust?"), seem to be agriculturally-related in some manner based on google searches and the land use of these parcels based on the 2023 FSA aerial imagery. Cargill Inc likely supports Cargill's river shipping operations (although there's no obvious current land use). Minnesota Valley Lands LLC is potentially owned by the Minnesota Valley Land Trust, Mid America Festivals Corp operates the local Rennaisance Fair, Valleyfair LLC comprises half an amusement park, SMS comprises a commercial composting initiative owned and operated by the SMSC

But farmers often need their land freely available to grow crops and don't often have a lot of extra cash laying around to particpiate in habitat restoration. This is the output when farmers are removed from consideration:

Table 2: Top 10 Largest Parcels with Highest Priority for Conservation, sans Farmers
Majority Mean Median
Acreage Taxpayer Acreage Taxpayer Acreage Taxpayer
214 Cargill Inc 214 Cargill Inc 214 Cargill Inc
125 Valleyfair LLC 125 Valleyfair LLC 125 Valleyfair LLC
120 SMSC 120 SMSC 111 Merriam Properties LLC
111 Merriam Properties LLC 111 Merriam Properties LLC 111 Spring Hill Golf Club
111 Spring Hill Golf Club 111 Spring Hill Golf Club 100 Dem-Con Landfill LLC
100 Dem-Con Landfill LLC 98 Brian J Colvin 98 Brian J Colvin
98 Brian J Colvin 125 Valleyfair LLC 125 Valleyfair LLC
95 Valleyfair LLC 92 Riverbend Industrial LLC 92 Riverbend Industrial LLC
92 Riverbend Industrial LLC 92 Merriam Properties LLC 92 Merriam Properties LLC
92 Merriam Properties LLC 85 Mid America Festivals Corp 85 Mid America Festivals Corp
SQL Query

SELECT *
FROM input1
WHERE
[Zonal Statistics majority/mean/median field] > 4 AND
(tax_name NOT LIKE '%north oaks%' AND tax_name NOT LIKE '%wildlife%' AND tax_name NOT LIKE '%natural resources%' AND tax_name NOT LIKE '%park district%' AND tax_name NOT LIKE '%city of%' AND tax_name NOT LIKE '%united states%' AND tax_name NOT LIKE '%state of%' AND tax_name NOT LIKE '%university%' AND tax_name NOT LIKE '%county%' AND tax_name NOT LIKE '%hennepin park%') AND
(useclass1 NOT LIKE '%ag%' AND useclass1 NOT LIKE '%farm%') -- removes taxpayers whose names indicate they're agriculturally-related in some way
ORDER BY acres_poly DESC LIMIT 10