Bilingual environmental intelligence platform prototypeV22.3 Professional Environmental Intelligence: Methodology + Risk Score
V22.3 Professional Environmental Intelligence Database

Community Signals + Public EPA Records

EcoSignal separates community incident reports, EPA ECHO compliance records, and EPA TRI toxic release inventory data into distinct intelligence layers for screening, research, and responsible referral.

What changed in V21.2?

V21.3 adds Supabase EPA cache sync on top of the live EPA display and cache layer: live ECHO results can be saved as structured cached records, reviewed in a cache table, exported for audit, and later synchronized into Supabase without confusing public regulatory records with community complaints.

Static bilingual demo with production-ready data model. Live EPA connection requires backend connector, scheduled jobs, caching, and source attribution.

Three-Layer Data Architecture

The commercial value comes from integrating multiple trusted data layers while keeping each source type clear and defensible.

Community Reports

Field Observations

Structured reports from residents, NGOs, or local organizations. Best for early signals, local awareness, and potential case leads.

EPA ECHO

Regulatory & Compliance Layer

Facility compliance, inspections, violations, and enforcement context from EPA public records.

EPA TRI

Toxic Release Layer

Facility-reported toxic chemical release and waste management data for long-term risk profiling.

Community Reporting

Environmental Incident Reporting

Submit environmental observations, community concerns, and field evidence to support responsible environmental awareness and follow-up review.

Report an Environmental Incident

Submit observable facts. Do not speculate or accuse without evidence.

Latitude
Longitude
Enter an address or use your current location.
No files selected
For emergencies, chemical exposure, fire, injury, or immediate public safety concerns, contact 911 or local authorities immediately.
Report submitted successfully. Your report and photo links have been saved to the Community Reports database.

V21.1.1 Intake Principle

Community reports remain open and low-friction, while EPA records are imported separately through verified public data connectors.

Anonymous reporting remains available

Do not force registration at the reporting stage. Registration should be optional for tracking, following cases, and receiving alerts.

EPA data is not a complaint

ECHO/TRI records are public regulatory records. They should support context and risk screening, not be treated as direct allegations.

Integrated Intelligence Workspace

Environmental Intelligence Database

Filter community reports, ECHO regulatory records, and TRI toxic release records in one database while preserving source identity and evidence logic.

0Records Shown
0Community
0EPA ECHO
0EPA TRI
0Avg Trust
All records displayed

United States Integrated Environmental Layer

Color = source layer. Click a marker or row to open record detail.

CommunityECHOTRI
IDSourceTitle / FacilityLocationCategoryStatusEvidenceTrustKey DataLast Updated

Select a record

Click a marker or table row to inspect record source, evidence, trust score, and interpretation limits.

Evidence
Trust
Source
Status

Interpretation Limit

Community reports are signals; ECHO records are compliance context; TRI records are facility-reported release inventory data. Do not merge them into a single allegation.

Location-Based Environmental Intelligence

Understand the Environmental Conditions Around Any Address

Search an address, ZIP code, city, or current location to identify nearby regulated facilities, compliance history, community signals, and environmental risk indicators.

Address → Map → RiskLocation-based screening
Step 2 · Environmental Snapshot

Environmental Snapshot

Give users a fast answer first: what is around this location, what deserves attention, and how the area compares with broader environmental context.

Environmental Risk Score64Moderate Screening Level

Preliminary score based on regulatory records, toxic release indicators, community signals, and data completeness.

24Nearby EPA Facilities
5Facilities with Violations
2Enforcement Actions
13Community Reports
4TRI Facilities
How to read this: The snapshot is a screening overview. It helps identify patterns and nearby sources that may deserve follow-up review; it does not prove contamination, liability, or health risk.
Step 3 · Map Display

Interactive Environmental Map

Map nearby EPA-regulated facilities, violation indicators, TRI facilities, and community reports around the searched location.

EPAViolationsTRIReports
Step 4 · Risk Score
Environmental Risk Score
64/100
Moderate Screening Level

This score helps prioritize review. It is not a health-risk determination or legal conclusion.

How the Score Is Structured

EcoSignal separates data sources before generating a preliminary area-level screening score.

EPA Compliance Records
40%
Toxic Release Indicators
30%
Community Reports
20%
Data Completeness
10%
Future production version: score updates dynamically from facility count, violation history, enforcement actions, TRI releases, and nearby community reports.
Step 5 · Community Comparison

Compare This Area With Broader Community Context

Users need more than a raw facility list. Comparison helps answer whether the searched area appears higher, lower, or similar to the surrounding county baseline.

Your Area vs. County Average

Example comparison for the searched radius.

IndicatorYour AreaCounty Avg
EPA Facilities2413
Facilities with Violations52
Community Reports134
TRI Facilities41

Interpretation

A higher count does not automatically mean the area is unsafe. It means the location has more nearby records that may deserve review. EcoSignal should explain whether the issue is facility density, compliance history, toxic release reporting, or community concern signals.

Product value: EPA.gov gives public records. EcoSignal turns those records into a neighborhood-level environmental screening view.
Step 6 · Nearby Facilities

Nearby Facilities Ranked by Relevance

After a search, results should be sorted by distance and then flagged by violations, enforcement, TRI reporting, or community reports nearby.

Southern California Gas Company - Aliso Canyon

Distance: 0.8 mi · Program: EPA ECHO · Location: Porter Ranch / Los Angeles County · Registry ID available after live query
8Inspections
2Violations
1Enforcement
Risk 72

Example Industrial Facility

Distance: 1.7 mi · Program: Clean Air Act / RCRA · Facility-level context shown after search
4Inspections
1Violations
0Enforcement
Risk 55

Facility Profile Preview

Clicking a facility should open a detailed profile with source-aware interpretation.

OverviewComplianceInspectionsViolationsMapNearby Reports
Distance
0.8 mi
Risk
72
Source
ECHO
Status
Review

Production profile should include facility name, address, EPA programs, inspections, violations, enforcement actions, TRI releases, and nearby community reports.

Step 7 · Environmental History

Environmental History Timeline

Users understand risk better when records are organized over time, not just listed as disconnected data points.

2015
Major regional environmental event

Example: significant community concern or publicly known incident relevant to area context.

2019
EPA inspection or enforcement record

Facility-level regulatory activity can be shown when available from EPA records.

2024
Community reports or recent observations

Nearby public observations can be displayed as separate signals, not as EPA violations.

Data Layers

What EcoSignal Uses for the Analysis

Each source is useful, but each means something different. EcoSignal must keep those meanings separate.

🏭

EPA ECHO Compliance Records

Facility compliance and enforcement context, including inspections, violations, enforcement actions, and EPA identifiers.

Nearby regulated facilitiesInspection and violation historyEnforcement and program informationFacility identifiers for database matching
🧪

EPA TRI Toxic Release Inventory

Annual facility-reported chemical release and waste-management data for long-term environmental screening.

Reported releases to air, water, and landChemical names and reporting yearWaste-management quantitiesFacility-level release trends
📍

Community Reports

Local observations submitted by residents or community users. These are signals, not regulatory determinations.

Odor, dumping, spill, or air/water concernsPhotos and location-based reportsNearby report clustersFollow-up investigation leads
Admin Tools: Cache / Export / Supabase Sync
Review Cache

Cached EPA Records

Use this controlled review layer before syncing selected EPA records into Supabase.

FacilityLocationCompliance MetricsSourceCached At
Admin Sync

Sync Cached Records to Supabase

Administrative ingestion control for EPA cached records. This should remain a controlled workflow in production.

For a real public website, do not leave public insert open permanently. Use Edge Functions or authenticated admin sync before production.
⚖️

Important Regulatory Notice

EPA records represent regulatory information, facility reporting, and compliance history. Community reports represent public observations. Appearance in an EPA dataset does not by itself establish contamination, health risk, or legal liability. EcoSignal uses these records as context for screening, community awareness, follow-up investigation, and historical compliance review.

V21.1.1 Environmental Intelligence Methodology

Environmental Intelligence Methodology

A structured framework for integrating community observations, regulatory records, environmental datasets, and professional interpretation.

2EPA Sources
3Database Tables
1Unified View
7Field Groups
PostGISGeo Ready

Data Sources & Integration

EcoSignal preserves source identity while converting community reports, EPA ECHO records, and EPA TRI data into a reviewable environmental intelligence workflow.

Ready for Backend

EPA ECHO Connector

Facility compliance, inspections, violations, and enforcement context. Recommended sync: daily or weekly depending on usage.

GET /api/connectors/echo/sync?state=CA&county=Los%20Angeles Target table: epa_echo_records Mode: scheduled import + cache
Demo Mode

EPA TRI Connector

Annual toxic release and waste-management data. Recommended sync: annual full refresh plus correction update checks.

GET /api/connectors/tri/import?year=2024 Target table: epa_tri_records Mode: CSV bulk import + validation
Planned Production Layer

Unified Intelligence View

Community reports, ECHO records, and TRI records remain separate tables, then appear together through a normalized geospatial intelligence view.

SELECT * FROM environmental_intelligence_view WHERE source_layer IN ('Community','EPA ECHO','EPA TRI');

Environmental Intelligence Workflow

This workflow supports transparent screening, defensible interpretation, and clear separation between observations, public records, and analytical context.

1

Fetch

Call EPA API or download CSV files from authoritative sources.

2

Validate

Check required fields, coordinates, dates, and duplicate facility identifiers.

3

Normalize

Convert ECHO/TRI fields into EcoSignal's shared record model.

4

Store

Save raw source data and normalized records in PostgreSQL/PostGIS.

5

Display

Expose clean API endpoints to the website map, table, and detail pages.

Interpretation Principles

The key design rule: do not force ECHO, TRI, and community reports into the same meaning. Normalize them for search and mapping, but preserve interpretation limits.

EcoSignal FieldCommunity ReportsEPA ECHOEPA TRIPurpose
source_layerCommunity ReportEPA ECHOEPA TRIPrevents mixing complaints with regulatory records.
record_typeIncident SignalCompliance / Enforcement RecordToxic Release Inventory RecordClarifies what the record actually represents.
facility_idOptional / unknownEPA registry or facility identifierTRI facility identifierSupports facility-level aggregation.
categoryWater / Air / Dumping / SpillAir / Water / RCRA / SDWA complianceChemical release mediaAllows filtering without implying identical data type.
geomReporter-provided locationFacility coordinatesFacility coordinatesEnables map display and radius search.
interpretation_limitUnverified public signalRegulatory context, not a new incidentAnnual self-reported release inventoryReduces legal and scientific overstatement.

Suggested Database Schema

Use separate source tables and a unified read-only view. Keep raw imports for auditability.

community_reports epa_echo_records epa_tri_records source_import_logs VIEW environmental_intelligence_view AS SELECT normalized fields FROM each source table;

Website API Endpoints

The front-end should query your own API, not EPA directly.

GET /api/records?source=EPA%20ECHO&state=CA GET /api/records/radius?lat=34.05&lng=-118.24&meters=10000 GET /api/facilities/:facilityId/context POST /api/admin/sync/echo POST /api/admin/sync/tri

Example Sync Log

A production dashboard should show when each connector last ran, how many records were imported, and whether validation passed.

EPA ECHO
Last simulated sync: 2026-06-07 · 128 records staged · 0 critical errors
Passed
EPA TRI
Last simulated import: 2026-06-07 · 84 records staged · 3 records need coordinate review
Review
Professional warning: TRI releases are not the same as acute pollution incidents, and ECHO compliance records are not the same as community complaints. The platform must preserve these distinctions in every table, map layer, and public explanation.
Methodology

How EcoSignal Works

From community observations to environmental intelligence: collect, normalize, score, map, analyze, and responsibly refer environmental signals.

How the Platform Works

The key is not collecting more noise. The key is separating, scoring, and interpreting environmental signals responsibly.

1. Collect

Accept public reports and import authoritative public datasets.

2. Normalize

Convert records into a shared schema: source, location, category, date, evidence, trust, and interpretation limits.

3. Score

Apply evidence quality and trust scoring differently for community reports, ECHO records, and TRI data.

4. Map

Display records on geographic layers without claiming every public record is an active incident.

5. Analyze

Identify hot zones, repeated patterns, facility context, and possible referral candidates.

6. Refer

Route high-quality signals to NGOs, attorneys, consultants, or researchers when appropriate.

About EcoSignal

Environmental Intelligence Platform

EcoSignal integrates community observations, EPA public records, geospatial screening, and source-aware environmental interpretation.

About EcoSignal V21.2

EcoSignal is an independent bilingual environmental intelligence platform prototype. V21.2 demonstrates how public reporting, EPA compliance data, and toxic release inventory data can be fused into a disciplined environmental risk intelligence database.


The goal is not to replace regulators or emergency services. The goal is to organize public signals and records into reviewable, searchable, and responsibly interpreted environmental information.

Important Disclaimer

EcoSignal does not provide emergency response, legal representation, environmental remediation, or regulatory enforcement. EPA ECHO and TRI records are public data sources and must be interpreted with care. For emergencies, call 911 or local authorities.