Bilingual environmental intelligence platform prototypeV17: Community Reports + EPA ECHO + EPA TRI data layers
V17 Bilingual 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 V16?

V17 adds English/Chinese language switching while preserving source discipline: a public complaint, a regulatory compliance record, and a toxic release inventory filing are not the same thing.

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.

Report an Environmental Incident

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

For emergencies, chemical exposure, fire, injury, or immediate public safety concerns, contact 911 or local authorities immediately.
Submission simulated. Production version would save this to the Community Reports layer.

V17 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.

EPA ECHO + TRI Connector Blueprint

V17 keeps the front-end bilingual while preparing the database model for real public-data ingestion.

EPA ECHO

Use ECHO as a facility compliance and enforcement context layer. It should not be labeled as a new pollution incident.

/api/echo/facilities?state=CA&county=Los%20Angeles\nfields: registry_id, facility_name, program, inspections, violations, enforcement_actions

EPA TRI

Use TRI as an annual toxic release and waste management inventory layer. It supports risk screening and trend analysis.

/api/tri/releases?year=2024&chemical=Toluene\nfields: facility_id, chemical, release_year, air, water, land, waste_management
V17 EPA Data Connector Dashboard

EPA Data Connector Dashboard

A production-facing blueprint for importing EPA ECHO and EPA TRI data into EcoSignal through backend sync jobs, normalized database tables, and source-aware interpretation rules.

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

Connector Status

V17 does not pretend to have live EPA ingestion inside a static file. It shows the correct production architecture: backend connector, scheduled sync, cache, database import, and source attribution.

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');

Recommended Data Pipeline

This is the pipeline that keeps the platform credible, fast, and defensible.

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.

Field Mapping

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.

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 V16

EcoSignal is an independent bilingual environmental intelligence platform prototype. V17 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.