How to Use the Phase I ESA Records Review Prompt to Organize Findings for the Environmental Professional
Summarize the records review portion of a Phase I Environmental Site Assessment: environmental database hits filtered by distance and gradient, historical use by decade from fire insurance maps, aerials, and directories, adjoining property concerns, draft REC classifications for the environmental professional, and every data gap.
The records review is one of the most time consuming parts of a Phase I Environmental Site Assessment. A database report can list dozens of sites, historical sources span decades, and the environmental professional needs it all organized by distance, gradient, and decade before making any calls. The Phase I ESA Records Review Summarizer: ASTM E1527-21 Database Hits, Historical Sources by Decade, Adjoining Property Findings, RECs vs CRECs vs HRECs, and Data Gaps prompt turns your database findings and historical source notes into a timeline, a findings table, draft classifications, and a list of data gaps that the EP can review and finalize.
What the prompt produces
- A historical use timeline by decade, citing each source and noting decades with no source.
- A database findings table with distance, direction, gradient, status, and whether each listing warrants discussion.
- Adjoining property notes on uses that could affect the subject.
- Draft classifications labeled draft REC, CREC, HREC, or de minimis, each with the supporting record.
- A vapor and migration note for nearby up gradient releases.
- Data gaps with a note on whether each looks significant.
- Items the user must provide, such as lien and AUL search results.
- A short summary paragraph the EP can edit.
How to fill the inputs
SubjectProperty includes address, acreage, current use, parcel ID, and the purpose of the assessment, such as a lender requirement.
DatabaseFindings should list each site with database name, distance, direction, gradient, and status. Include subject property listings.
HistoricalSources lists every source you reviewed and its date: fire insurance maps, aerial photographs, city directories, topographic maps, and permits. Listing dates lets the prompt find decade gaps.
GroundwaterGradient explains the inferred flow direction and how you estimated it.
AgencyAndUserInfo covers file reviews, interviews, and what the user has or has not provided.
Reading the example output
The example is a warehouse on 2.3 acres in Dayton, Ohio. The timeline shows vacant land in the 1910s and 1930s, no source for the 1940s, a building by 1950, a machine shop from 1965 to 1990, and warehouse use with RCRA small quantity generator status after that.
The findings table marks a former dry cleaner 0.05 mile up gradient with regulatory closure and a groundwater use restriction for discussion, and sets aside a closed LUST case down gradient. The machine shop history becomes a draft REC because there are no records of how oils and degreasers were handled. The dry cleaner becomes a draft CREC candidate for EP judgment, with a note to consider vapor screening.
The data gap table lists the missing 1940s source and a fire department records request that went unanswered.
Tips for better results
- Paste gradient and status exactly as the database report shows them.
- Include owner and occupant interview notes. They often explain uses that directories miss.
- Record the date of every records request so unanswered ones show up as gaps.
- Keep classifications labeled as drafts until the EP signs off.
Mistakes to avoid
- Do not fill a missing decade with an assumption. Record it as a gap.
- Do not drop a listing just because it is far away without checking gradient and status.
- Do not treat a regulatory closure as proof that no condition exists. Closures can carry restrictions.
Who it is for
Environmental consultants, staff scientists supporting environmental professionals, and due diligence teams at lenders and buyers who review Phase I reports.
A practical routine
After the database report and historical sources arrive, fill the inputs and run the prompt. Hand the timeline, table, and draft classifications to the EP, update after site reconnaissance and interviews, and carry the final language into the report.
Related PromptDig links
Open the Phase I ESA Records Review Summarizer: ASTM E1527-21 Database Hits, Historical Sources by Decade, Adjoining Property Findings, RECs vs CRECs vs HRECs, and Data Gaps prompt with your next records review. For more research prompts, Browse more prompts. If your team has a review template that works, Share a prompt.