Excavation Permits

data.cambridgema.gov | Last Updated 6 May 2024

Excavation permits since April 2019

Tags: excavation, permits, department of public works - dpw

This dataset has the following 103 columns:

Column Name	API Column Name	Data Type	Description	Sample Values
ID	id	number		56615 45590 55169 166316 92820 view top 100
Address	address	text		147 Hampshire St, Cambridge, MA 02139 300 Bent St, Cambridge, MA 02142 145 Broadway, Cambridge, MA 02142 300 Binney St, Cambridge, MA 02142 301 Binney St, Cambridge, MA 02142 view top 100
Latitude	latitude	number		42.3676 42.3622 42.3713 42.372 42.3726 view top 100
Longitude	longitude	number		-71.0977 -71.1133 -71.0888 -71.0851 -71.131 view top 100
Status	status	text		Complete Active view top 100
Applicant Submit Date	applicant_submit_date	calendar_date		2021-12-08T00:00:00.000 2019-06-14T00:00:00.000 2021-09-22T00:00:00.000 2022-05-23T00:00:00.000 2023-05-18T00:00:00.000 view top 100
Issue Date	issue_date	calendar_date		2020-01-28T00:00:00.000 2022-09-30T00:00:00.000 2024-04-11T00:00:00.000 2022-09-28T00:00:00.000 2020-01-21T00:00:00.000 view top 100
Company Name	company_name	text		Eversource Gas Mattuchio Construction Cambridge Water Department Phoenix Communications Pike Engineering view top 100
Contractor	contractor	text		C-46 C-15 C-87 C-75 C-11 view top 100
Number of Inspections	number_of_inspections	number		1 2 3 4 5 view top 100
Other Utility	other_utility	text		Eversource Electric Eversource Gas Test Pits CNS Eversource Gas view top 100
Subcontractor Company Name	subcontractor_company_name	text		Feeney Bros Feeney Brothers Riley Brothers Sheerin Construction G. Greene view top 100
Utilities	utilities	text		Eversource Gas Sewer Service Cambridge Water Department Stormwater Verizon view top 100
Number of Metered Parking Spaces to Reserve	number_of_metered_parking	text		view top 100
Number of No Parking Signs Required	number_of_no_parking_signs	number		0 4 2 6 3 view top 100
City Contract Name	city_contract_name	text		9921 FY19 Remedial Contract 8106 Miscellaneous Sidewalks FY19 Remedial Contract view top 100
Department Responsible for City Contract	department_responsible_for	text		Public Works Traffic, Parking & Transportation Department Electrical Department Community Development City Manager's Office view top 100
Dig Safe Number	dig_safe_number	text		N/A n/a N/a Will call tomorrow morning when we get on site. NA view top 100
Approved curb cut	approved_curb_cut	checkbox		false true view top 100
City contract	city_contract	checkbox		false true view top 100
Permit Type	permit_type	text		Trench No Trench view top 100
Private Roadway	private_roadway	checkbox		true false view top 100
Private Sewer	private_sewer	checkbox		true false view top 100
Private Sidewalk	private_sidewalk	checkbox		true false view top 100
Private Site Work	private_site_work	checkbox		true false view top 100
Private Stormwater	private_stormwater	checkbox		true false view top 100
Private Utility/Comm	private_utility_comm	checkbox		true false view top 100
Private Water	private_water	checkbox		true false view top 100
Public Roadway	public_roadway	checkbox		true false view top 100
Public Sewer	public_sewer	checkbox		true false view top 100
Public Sidewalk	public_sidewalk	checkbox		true false view top 100
Public Site Work	public_site_work	checkbox		true false view top 100
Public Stormwater	public_stormwater	checkbox		true false view top 100
Public Utility/Comm	public_utility_comm	checkbox		true false view top 100
Public Water	public_water	checkbox		true false view top 100
Utility Permit Number	utility_permit_number	text		N/A pending na n/a PENDING view top 100
Water Permit Number	water_permit_number	text		N/A n/a na N/a TBD view top 100
Work performed on private property	work_performed_on_private	checkbox	Will the work be performed on private property?	false true view top 100
Work performed on the public right-of-way	work_performed_on_the_public	checkbox	Will the work be performed on the public right of way?	true false view top 100
Cutting the street and/or sidewalk	cutting_the_street_and_or	text	Will you be cutting the street and/or sidewalk?	Yes - Street Yes - Street & Sidewalk FALSE Yes - Sidewalk view top 100
Length of Sidewalk Cut Five	length_of_sidewalk_cut_five	number		5 1 8 3 2 view top 100
Length of Sidewalk Cut Four	length_of_sidewalk_cut_four	number		5 8 1 10 2 view top 100
Length of Sidewalk Cut One	length_of_sidewalk_cut_one	number		5 0 8 4 10 view top 100
Length of Sidewalk Cut Three	length_of_sidewalk_cut_three	number		5 10 2 4 8 view top 100
Length of Sidewalk Cut Two	length_of_sidewalk_cut_two	number		5 4 2 10 6 view top 100
Material of Sidewalk Cut Five	material_of_sidewalk_cut	text		Concrete Brick Other Asphalt view top 100
Material of Sidewalk Cut Four	material_of_sidewalk_cut_1	text		Concrete Brick Other Asphalt view top 100
Material of Sidewalk Cut One	material_of_sidewalk_cut_2	text		Concrete Brick Other Asphalt view top 100
Material of Sidewalk Cut Three	material_of_sidewalk_cut_3	text		Concrete Brick Asphalt Other view top 100
Material of Sidewalk Cut Two	material_of_sidewalk_cut_4	text		Concrete Brick Asphalt Other view top 100
Number of sidewalk cuts	number_of_sidewalk_cuts	number		1 0 2 3 4 view top 100
Width of Sidewalk Cut Five	width_of_sidewalk_cut_five	number		5 3 1 2 4 view top 100
Width of Sidewalk Cut Four	width_of_sidewalk_cut_four	number		5 4 6 1 2 view top 100
Width of Sidewalk Cut One	width_of_sidewalk_cut_one	number		4 5 0 6 3 view top 100
Width of Sidewalk Cut Three	width_of_sidewalk_cut_three	number		5 4 3 2 6 view top 100
Width of Sidewalk Cut Two	width_of_sidewalk_cut_two	number		5 4 6 2 1 view top 100
Area of Street Cut 1 Calculated	area_of_street_cut_1	number		0 100 60 40 20 view top 100
Area of Street Cut 10 Calculated	area_of_street_cut_10	number		0 12 16 1 0.25 view top 100
Area of Street Cut 2 Calculated	area_of_street_cut_2	number		0 36 25 1 4 view top 100
Area of Street Cut 3 Calculated	area_of_street_cut_3	number		0 36 4 25 1 view top 100
Area of Street Cut 4 Calculated	area_of_street_cut_4	number		0 36 4 1 25 view top 100
Area of Street Cut 5 Calculated	area_of_street_cut_5	number		0 36 1 4 60 view top 100
Area of Street Cut 6 Calculated	area_of_street_cut_6	number		0 36 1 4 25 view top 100
Area of Street Cut 7 Calculated	area_of_street_cut_7	number		0 1 36 4 9 view top 100
Area of Street Cut 8 Calculated	area_of_street_cut_8	number		0 1 4 36 25 view top 100
Area of Street Cut 9 Calculated	area_of_street_cut_9	number		0 1 36 4 25 view top 100
Depth of Street Cut 1	depth_of_street_cut_1	number		4 2 5 10 6 view top 100
Depth of Street Cut 10	depth_of_street_cut_10	number		1 6 10 3 1.5 view top 100
Depth of Street Cut 2	depth_of_street_cut_2	number		5 2 4 6 8 view top 100
Depth of Street Cut 3	depth_of_street_cut_3	number		2 5 6 4 8 view top 100
Depth of Street Cut 4	depth_of_street_cut_4	number		2 5 4 8 6 view top 100
Depth of Street Cut 5	depth_of_street_cut_5	number		2 8 6 5 4 view top 100
Depth of Street Cut 6	depth_of_street_cut_6	number		2 5 6 4 8 view top 100
Depth of Street Cut 7	depth_of_street_cut_7	number		5 6 8 1 2 view top 100
Depth of Street Cut 8	depth_of_street_cut_8	number		5 1 6 2 4 view top 100
Depth of Street Cut 9	depth_of_street_cut_9	number		5 6 8 2 4 view top 100
Length of Street Cut 1	length_of_street_cut_1	number		10 6 8 5 20 view top 100
Length of Street Cut 10	length_of_street_cut_10	number		6 1 2 5 8 view top 100
Length of Street Cut 2	length_of_street_cut_2	number		10 6 5 1 2 view top 100
Length of Street Cut 3	length_of_street_cut_3	number		6 2 5 1 10 view top 100
Length of Street Cut 4	length_of_street_cut_4	number		2 6 1 10 5 view top 100
Length of Street Cut 5	length_of_street_cut_5	number		6 1 2 5 10 view top 100
Length of Street Cut 6	length_of_street_cut_6	number		6 1 2 8 5 view top 100
Length of Street Cut 7	length_of_street_cut_7	number		1 6 2 3 20 view top 100
Length of Street Cut 8	length_of_street_cut_8	number		1 2 6 5 8 view top 100
Length of Street Cut 9	length_of_street_cut_9	number		1 2 5 6 0.5 view top 100
Number of Street Cuts	number_of_street_cuts	number		1 2 3 0 4 view top 100
Width of Street Cut 1	width_of_street_cut_1	number		2 6 10 5 4 view top 100
Width of Street Cut 10	width_of_street_cut_10	number		1 2 6 4 8 view top 100
Width of Street Cut 2	width_of_street_cut_2	number		5 6 4 2 1 view top 100
Width of Street Cut 3	width_of_street_cut_3	number		5 6 2 4 1 view top 100
Width of Street Cut 4	width_of_street_cut_4	number		6 2 5 1 4 view top 100
Width of Street Cut 5	width_of_street_cut_5	number		6 1 5 2 4 view top 100
Width of Street Cut 6	width_of_street_cut_6	number		6 1 2 5 4 view top 100
Width of Street Cut 7	width_of_street_cut_7	number		6 2 1 5 3 view top 100
Width of Street Cut 8	width_of_street_cut_8	number		1 2 4 6 5 view top 100
Width of Street Cut 9	width_of_street_cut_9	number		1 4 5 2 6 view top 100
Hoisting License Expiration Date	hoisting_license_expiration	calendar_date		2022-10-12T00:00:00.000 2022-12-31T00:00:00.000 2021-12-31T00:00:00.000 2023-12-31T00:00:00.000 2024-10-12T00:00:00.000 view top 100
License Grade	license_grade	text		2A 1A 2B 1C 4E view top 100
Massachusetts Hoisting License Number	massachusetts_hoisting_license	text		on file 044115 HE-087237 100028 HE119693 view top 100
Work between standard hours 7AM–6PM	work_between_standard_hours	checkbox	Do you plan to work between the standard hours of 7am to 6pm?	true false view top 100
End Date	end_date	calendar_date		2023-06-30T00:00:00.000 2020-11-20T00:00:00.000 2022-02-28T00:00:00.000 2020-07-31T00:00:00.000 2021-12-31T00:00:00.000 view top 100
Start Date	start_date	calendar_date		2022-10-03T00:00:00.000 2022-06-21T00:00:00.000 2019-06-25T00:00:00.000 2019-06-17T00:00:00.000 2021-12-20T00:00:00.000 view top 100