Dewatering permits since April 2019.
This dataset has the following 18 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| ID | id | number | 97738 61224 120744 58222 60505 view top 100 | |
| Full Address | full_address | text | 325 Main St, Cambridge, MA 02142 40 Thorndike St, Cambridge, MA 02141 290 Binney St, Cambridge, MA 02142 250 Binney St, Cambridge, MA 02142 1557 Massachusetts Ave, Cambridge, MA 02138 view top 100 | |
| Latitude | latitude | number | 42.389 42.3691 42.3626 42.366 42.3695 view top 100 | |
| Longitude | longitude | number | -71.087 -71.0868 -71.0871 -71.0796 -71.0981 view top 100 | |
| Status | status | text | Active Complete view top 100 | |
| Submit Date | applicant_date | calendar_date | 2019-10-10T00:00:00.000 2019-10-11T00:00:00.000 2021-05-11T00:00:00.000 2020-01-31T00:00:00.000 2022-08-24T00:00:00.000 view top 100 | |
| Issue Date | issue_date | text | 2024-01-08 2021-10-15 2019-12-06 2020-01-08 2019-07-30 view top 100 | |
| Company Name | company_name | text | John Moriarty and Associates Bond Brothers Turner Construction Dellbrook JKS Consigli Construction view top 100 | |
| Contractor Name | contractor_name | text | C-98 C-48 C-28 C-66 C-721 view top 100 | |
| Type of Dewatering | type_of_dewatering | text | Construction Activities view top 100 | |
| Location of Dewatering | location_of_dewatering | text | Location of dewatering activity | Separated Storm Drain Sanitary or Combined Sewer view top 100 |
| Description | description_of_dewatering | text | Description of dewatering operation | Dewatering during excavation for foundation of the building Removal of ground water to facilitate concrete foundation construction activities Periodic dewatering of foundation hole during rain events and discharge of rain water during the construction of the building. A dewatering system will be installed for the S.O.E pit located on the East Service Rd. Pending test results, it will be sent through a frac tank and treated as required prior to discharge into City main Catch Basin. Dewatering for this project will consist of pumping from various sump locations as needed within the excavation. The pumped water will travel through a dewatering treatment system before being discharged into an approved drain in attached sketch. The dewatering system will consist of a sedimentation tank, bag filters, and a flow meter. Water sampling and testing will be completed prior to discharge. view top 100 |
| Discharge Rate | discharge_rate | number | gallons per minute | 50 200 100 150 25 view top 100 |
| End Date | end_date | calendar_date | 2023-03-31T00:00:00.000 2020-04-30T00:00:00.000 2023-12-31T00:00:00.000 2023-04-01T00:00:00.000 2022-07-31T00:00:00.000 view top 100 | |
| Dewatering Permit Number | dewatering_permit_number | text | EPA/DEP dewatering permit | MAR1002UP MAR000598979 MAG9100842 MAG910983 MAG910000 view top 100 |
| MWRA Number | mwra_sewer_use_discharge | text | Massachusetts Water Resources Authority Sewer Use Discharge Permit Number | 09406589 09408080 09409374 09409427 Pending- submitted to CPWD view top 100 |
| Source of Discharge | source_of_discharge | text | Commercial Residential Industrial view top 100 | |
| Start Date | start_date | calendar_date | 2019-12-09T00:00:00.000 2021-04-06T00:00:00.000 2021-08-03T00:00:00.000 2019-08-06T00:00:00.000 2023-07-25T00:00:00.000 view top 100 |