New data source for DERR > Environmental Incidents

agrc / deq-enviro

DEQ Environmental Data Viewer

MIT License

6 stars 1 forks source link

New data source for DERR > Environmental Incidents #665

Open nathankota opened 2 months ago

nathankota commented 2 months ago

The ERSpillsDatabase is to be replaced by the new Environmental Incidents Salesforce app. We can palletjack from SalesForce to DEQ AGOL once the data/views are made available to us from SalesForce. The tables/views forklift currently uses in ERSpills are:

DEQmap_EnviroIncidents
vwDryCleaners
DEQmap_Chemical
DEQmap_ImpactedMedia

stdavis commented 1 month ago

These two spreadsheets will help determine how palletjack gets the data from salesforce. It will likely need to implement some of the business logic that previously was contained in the SQL views.

DEQMapFileUGRC.xlsx

Spills Table To IM View Mappings.xlsx

I'll ask Barry about getting connected to the salesforce app.