Cleanup and storage-tank files, by address

The register search a Phase I environmental assessment starts with, already joined to the parcel it sits on. What the state has a file on, whether that file is open or closed, and whether a legal restriction is recorded on the property's use.

The file

5,587 parcels carrying 7,149 MPCA cleanup or tank files

7,149 rows

Counties in this file: Hennepin, Ramsey · 18 columns available · free, no account, no rate limit.

Download CSV Download XLSX Download JSON Download GeoJSON

Joins to an address on parcel_id, so it can be pointed at one property rather than read whole.

What the rows look like

10 real rows from this file, spread evenly across it rather than taken off the top — every file here is written in some order, so its first rows are never a fair sample of it. These are the default columns, which is what the download button hands over.

address	site on file	address on the MPCA file	open or closed	what the file is	cleanup or tanks	parcel id
15 Washington Ave S, Minneapolis	Nicollet Hotel	Hennepin Avenue at Washington Avenue	open	Multiple Activities	cleanup	2202924410147
955 Wells Street, Saint Paul	Former 3M Campus	881 E 7th St	open	Petroleum Remediation, Leak Site	cleanup	282922310145
10751 89th Ave N, Maple Grove	Waste Management - Maple Grove	10633 89th Ave N	open	Multiple Activities	cleanup + tanks	1311922320007
764 Vandalia Street, Saint Paul	Commercial Kitchen Services	764 Vandalia St	open	Multiple Activities	cleanup	292923440019
809 Selby Avenue, Saint Paul	Tobasi Stop 1	809 Selby Ave	open	Multiple Activities	cleanup + tanks	022823120288
6200 Bloomington Rd, Fort Snelling	Common Bond Communities Property	211 Bloomington Rd	open	Multiple Activities	cleanup	2902823120001
—	County Road E and 12th Ave NW	County Road E and 12th Ave NW	open	Site Assessment	cleanup	203023110001
3023 50th St W, Minneapolis	Southwest Firestone	5009 Xerxes Ave S	open	Multiple Activities	tanks	1702824420114
53 Woodlynn Avenue, Little Canada	Fuel Economy Contracting Co	95 W Woodlynn Ave	closed	Multiple Activities	cleanup + tanks	062922220032
—	Island Lake Elementary School	2555 N Victoria St	closed	Underground Tanks	tanks	143023310264

An em dash means the record is blank, and that is the source's gap rather than ours. Across the whole file: address is blank on 4.3% of rows.

The cuts of this file

Every cut is the same columns, filtered. Pick one and the row count changes; the file does not.

4 scopes
Cut	Rows	File
every cleanup and tank file	7,149	CSV
still open	6,001	CSV
storage tanks	3,666	CSV
a legal restriction on the property's use	554	CSV

Every column in this file

Columns marked default come down unless you pick your own with &columns=.

18 columns
Column	What it is	In the default file
`address`	address	default
`site`	site on file	default
`site_address`	address on the MPCA file	default
`status`	open or closed	default
`activity`	what the file is	default
`kind`	cleanup or tanks	default
`tanks`	storage tanks	optional
`cleanup`	cleanup file	optional
`institutional_controls`	use restricted	optional
`assessed`	assessed	optional
`all_activities`	every activity on file	optional
`programs`	MPCA programmes	optional
`industry`	industry	optional
`lot_sqft`	lot sq ft	optional
`city`	city	optional
`county`	county	optional
`parcel_id`	parcel id	default
`mpca_record`	MPCA record	optional

Where it comes from

Minnesota Pollution Control Agency — What's In My Neighborhood

Records retrieved 2026-08-18 — the oldest capture date among the layers behind this file, because data is no fresher than its stalest input.

What this layer cannot answer is stated in full on the system card — read it before quoting a figure.

What you may do with it

Creative Commons Attribution 4.0 International (CC BY 4.0). Share it, change it, build a product on it, sell that product — all fine. The one condition is credit: say it came from Brick & Mortar and link back.

Records published by Minnesota Pollution Control Agency. Government data held by a Minnesota state agency or political subdivision, presumed public under the Minnesota Government Data Practices Act (Minn. Stat. ch. 13) and published by the agency itself.

Read the full licence · how we license every dataset, and the two we do not

Without the page

/api/export?dataset=contamination&format=csv returns the same file. Call /api/export with no arguments for the whole catalogue.

Point an AI at it

Every file carries its own source, its capture date and the layer's own warnings in the header, so a model reading one gets the caveats with the numbers rather than the numbers alone. Paste this at an assistant that can fetch a URL:

Read https://brickandmortar.dev/api/export?dataset=contamination&format=csv
Everything above the header row is provenance and limits. Read it first,
then answer using only what the rows support.

llms.txt describes the whole warehouse the same way — what each dataset holds, which counties it really covers, and what it cannot answer.