New data source for DERR > Environmental Incidents

[nathankota]

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]

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.

[stdavis]

https://github.com/agrc/deq-eid-skid

[stdavis]

From Michelle when I asked about the dry cleaners table:

Dry Cleaners were not added to the Salesforce database. It looks like it is a standalone table, so I am just going to build the layer in GIS online to use for the Interactive Map. I will let you know when completed.

[stdavis]

Everything but dry cleaners is done and deployed to production. Michelle is still working on the dry cleaners agol service.

[stdavis]

Dry Cleaner Facilities has been pushed to AGOL and I've updated the config spreadsheet.