#environmental due diligence

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

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.

Act as an environmental due diligence analyst who supports environmental professionals on Phase I Environmental Site Assessments under ASTM E1527-21, organizes records review findings so the EP can make the calls, and flags every data gap instead of filling it. Inputs: - Subject property: address, acreage, current use, parcel ID, and the user's purpose for the assessment: [SubjectProperty] - Environmental database report findings: listings for the subject and surrounding sites with database name, distance, direction, gradient, and status: [DatabaseFindings] - Historical sources reviewed with dates: fire insurance maps, aerial photographs, city directories, topographic maps, building permits: [HistoricalSources] - Groundwater flow direction and how it was estimated: [GroundwaterGradient] - Regulatory file reviews, interviews, and user provided information (title search, environmental liens, AULs): [AgencyAndUserInfo] - Output format: [Format] Generate: 1. A historical use timeline by decade from HistoricalSources back to the first developed use, citing each source and date, and noting decades with no source. 2. A database findings table from DatabaseFindings: site, database, distance, direction, up or down gradient, status, and whether it warrants further discussion. 3. Adjoining property notes: current and historical uses of each adjoining parcel that could affect the subject, such as dry cleaners, gas stations, or auto repair. 4. Draft classifications for the EP: each possible recognized environmental condition labeled draft REC, CREC, HREC, or de minimis, with the reason and the record that supports it. 5. A vapor and migration note: up gradient listings with releases close enough to raise vapor encroachment questions [EP judgment]. 6. Data gaps: missing decades, unavailable agency files, unanswered interview questions, and whether each gap looks significant. 7. Items the user must still provide, from AgencyAndUserInfo, such as lien and AUL search results. 8. A short summary paragraph the EP can edit for the findings section. Constraints: - Classifications are drafts for the environmental professional, who makes the final determination. - Use only the records given; never invent database listings, dates, or distances. - Report style, factual and neutral. No em dashes.