State UST, LUST & Spill Registry Screener — National + NY, CA, TX, FL

A national + state-level underground storage tank (UST/LUST) and spill/leak registry screener. Give it a list of asset coordinates and it screens each one for nearby tank leaks, spills, and cleanup cases — records that federal- only screens routinely miss because day-to-day UST/LUST/spill enforcement mostly lives at the state agency, not the EPA. v1.1 adds a national EPA UST Finder baseline (facilities + LUST releases, every US state) on top of deep coverage for New York (DEC Spills + DEC Bulk Storage), California (SWRCB GeoTracker), Texas (TCEQ PST facilities + LPST leak sites), and Florida (DEP petroleum contamination sites). More states can be added the same way, one config block at a time.

Coverage at a glance

Rows without precise coordinates (NY Bulk Storage, TX LPST, and any county-mode fallback) are still returned — matched to the asset's county — rather than silently dropped, so a "clear" result always means "nothing found," not "the query failed."

Who this is for

• Phase I ESA consultants who need a fast, repeatable first pass on federal and state tank/spill records before ordering (or in place of, for a quick triage) a full commercial environmental database report.
• CRE lenders and acquisition teams screening a pipeline of properties for tank/spill red flags before underwriting.
• Environmental attorneys and consultants doing due diligence or litigation support who need to check "is there a known spill or leaking tank near this address," anywhere in the US.

What it does

For each asset (lat, lon, label):

1. Queries the national EPA UST Finder database (unless includeNational is set to false) for nearby registered UST facilities and LUST releases.
2. Queries whichever of NY, CA, TX, FL are selected in states for their own state-level registries (see the coverage table above).
3. Filters everything to your radiusMiles, sorts nearest-first, and returns one row per case/spill/facility. An asset with zero hits still returns exactly one "clear" row (clear_flag: true) so a screening verdict is always explicit and billable — you never have to guess whether an empty result means "clean" or "the query failed."

Example input

{
  "assets": [
    { "lat": 40.678, "lon": -73.944, "label": "Brooklyn NY site" },
    { "lat": 34.052, "lon": -118.243, "label": "Downtown LA site" },
    { "lat": 29.76, "lon": -95.37, "label": "Houston TX site" }
  ],
  "radiusMiles": 1,
  "states": ["NY", "CA", "TX", "FL"],
  "includeNational": true,
  "openCasesOnly": false,
  "maxResultsPerAsset": 20
}

Output fields

Use as an MCP tool

This actor is discoverable and callable by AI agents (Claude, Cursor, etc.) via mcp.apify.com — the input/output schemas are field-documented so an agent can chain this into a larger due-diligence workflow (e.g. alongside epa-contaminated-site-screener, usace-levee-flood-risk-screener, or site-due-diligence-bundle).

FAQ

Can I search for underground storage tanks by address? Geocode the address to lat/lon first (e.g. with the free Census geocoder or your own tool), then pass the coordinates in assets.

Does this cover Texas LPST sites? Yes — states: ["TX"] (or leave the default, which includes TX) returns TCEQ PST facility registrations and LPST leaking-tank cleanup sites, tagged source: "TX LPST" with case_type: "LPST Leak Site".

Is there a national underground storage tank database search? Yes — leave includeNational: true (the default) and every asset is also screened against the EPA's national UST Finder database (registered facilities + LUST releases), regardless of which state it's in.

Does this cover LUST sites in California? Yes — CA GeoTracker case types include LUST Cleanup Site,

Military UST Site

Can I find NY DEC spill records or bulk storage tanks near a property? Yes — NY DEC Spills returns material, quantity, and open/closed status; NY DEC Bulk Storage returns registered PBS/CBS/MOSF tank facilities (matched by county, since that dataset doesn't expose coordinates).

Does this cover Florida petroleum contamination sites? Yes — FL DEP petroleum contamination / discharge sites are returned with case_type: "Petroleum Contamination Site"; coordinates are converted from the source's degrees/minutes/seconds fields.

Is this a substitute for a licensed Phase I ESA? No. This is a fast records screen, not an ASTM E1527 Phase I Environmental Site Assessment. Always confirm findings with the agency of record and a licensed environmental professional before any transaction decision.

Pricing

$10 per 1,000 results (single automatic Result/dataset-item event — no double-charging). An asset with zero hits still bills one result (the "clear" row), matching how the actor's other due-diligence screeners price.

Data sources

• EPA UST Finder: hosted ArcGIS FeatureServer, services.arcgis.com (keyless; service name is resolved at runtime from a short candidate list).
• NY DEC Spills: data.ny.gov/resource/u44d-k5fk.json (Socrata, keyless).
• NY DEC Bulk Storage: data.ny.gov/resource/pteg-c78n.json (Socrata, keyless).
• CA GeoTracker sites: gispublic.waterboards.ca.gov hosted ArcGIS FeatureServer (keyless).
• TX PST facilities: data.texas.gov/resource/jx8f-z4hu.json (Socrata, keyless).
• TX LPST leak sites: data.texas.gov/resource/hedz-nn4q.json (Socrata, keyless).
• FL DEP petroleum contamination: ca.dep.state.fl.us ArcGIS MapServer (keyless).

Disclaimer

Screening aid only — NOT a substitute for a licensed Phase I Environmental Site Assessment (ASTM E1527) or an official state/federal records search. Distances are measured to a database point (often a facility/site centroid, not a property boundary); records without usable coordinates are still returned when a county-level match is available, but cannot be distance-screened. Coverage, field names, and status codes vary by source and can change without notice.