SWAMP Database Links
Database Related Links
This internal website enables users to upload and download files. To upload a shell, select "Incoming" and click the "Add files" button. Shells can be downloaded from the "Outgoing" folder by clicking on the preferred zip file. To gain access to this site, please send a request to: OIMA-Helpdesk@waterboards.ca.gov.
This tool is provided to SWAMP team members and laboratories to check data submission files, within SWAMP 2.5 templates, for formatting, lookup list values, and SWAMP business rules.
Provides status of data submissions to SWAMP Online Data Checker after April 1st 2015
Link to the SWAMP Data Management Resources Web Page (Tools, Documentation, Templates, Links, etc.)
Systems Schedule
Data Warehouse (Full) Refresh (Nightly)
Refreshes data available within the data warehouse. The data warehouse contains all data in the SWAMP database for ease of querying.
SWAMP Online Data Checker Reference Refresh (Nightly)
Refreshes lookup lists and sample data within the SWAMP Online Data Checker to check data against.
Shell auto-loading from FTP site (Nightly: Mon-Thur)
Auto-loader tool will run nightly and data successfully loaded will show up immediately in SWAMP database with "Pend" compliance code.
CEDEN Refresh (Every Sunday)
Data successfully loaded to SWAMP database will show up in CEDEN after weekly refresh.