Sometimes I give myself research projects and this is where I write up my findings.
emailHabitat 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).
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 |
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:
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 |
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