List of permits related to the construction or the alteration of existing buildings in Cambridge. These permits cover construction that changes the structure, the footprint, or the volume of the building. This includes decks, porches, and additions, as well any reconstruction, renovation or repair to an existing structure. This dataset derives from Cambridge's ViewPoint permitting system.
This dataset has the following 86 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Record Number | id | number | 17034 17036 17038 17052 17100 view top 100 | |
| Address | address | text | City address where the work will take place. | 100 Cambridgeside Pl, Cambridge, MA 1 Main St, Cambridge, MA 301 Binney St, Cambridge, MA 55 Cambridge Pkwy, Cambridge, MA 150 Cambridgepark Dr, Cambridge, MA view top 100 |
| Address for Mapping | address_geocoded | location | Address along with latitude and longitude coordinates for mapping data within the Socrata open data platform. | view top 100 |
| Latitude | latitude | number | 42.372 42.373 42.3696 42.3707 42.361 view top 100 | |
| Longitude | longitude | number | -71.1299 -71.0802 -71.1044 -71.0904 -71.1167 view top 100 | |
| Status | status | text | Active permits are still in the process of being submitted. Complete permits have been submitted. | Active Complete view top 100 |
| Submit Date | applicant_submit_date | calendar_date | Applicant submit date | 2020-12-22T00:00:00.000 2020-12-21T00:00:00.000 2020-06-30T00:00:00.000 2020-09-09T00:00:00.000 2019-06-11T00:00:00.000 view top 100 |
| Issue Date | issue_date | calendar_date | Date permit was issued | 2020-12-14T00:00:00.000 2020-06-28T00:00:00.000 2020-06-26T00:00:00.000 2020-12-29T00:00:00.000 2020-12-21T00:00:00.000 view top 100 |
| Units Added | number_of_residential_units | number | Number of residential units to be added | 1 3 0 2 13 view top 100 |
| Units Removed | number_of_units_to_be_removed | number | Number of units to be removed | 1 2 4 3 5 view top 100 |
| Number of Units | current_number_of_dwelling | number | Current Number of Dwelling Units | 1 2 3 4 0 view top 100 |
| Change in Units (Increase) | unit_increase | number | Proposed Number of Dwelling Units (Increase) | 0 1 2 3 4 view top 100 |
| Change in Units (Decrease) | unit_decrease | text | Proposed Number of Dwelling Units (Decrease) | 1 0 2 3 4 view top 100 |
| Change in Units | change_residential_units | checkbox | Will the number of residential units change as a result of this permit? | false view top 100 |
| Current Property Use | current_property_use | text | The current property use of the building to be altered. | Multi-Family (3 units or greater) One-Family Two-Family Townhouse Commercial / Mixed Use view top 100 |
| Proposed Property Use | proposed_property_use | text | The proposed property use of the building to be altered. | One-Family Two-Family Multi-Family (3 units or greater) Accessory Townhouse view top 100 |
| Change in Property Use | will_the_property_use_change | checkbox | Will the property use change as a result of this permit? | false true view top 100 |
| Building Cost | building_cost_of_construction | number | Building Cost of Construction | 5000 10000 20000 4000 25000 view top 100 |
| Electrical Cost | electrical_cost_of | number | Electrical Cost of Construction | 0 5000 2000 1000 10000 view top 100 |
| Plumbing Cost | plumbing_cost_of_construction | number | Plumbing Cost of Construction | 0 5000 10000.00 4000 3000 view top 100 |
| Gas Cost | gas_cost_of_construction | number | Gas Cost of Construction | 0 5000 1000 10000.00 2000 view top 100 |
| HVAC Cost | hvac_cost_of_construction | number | HVAC Cost of Construction | 0 25000 30000 10000 20000 view top 100 |
| Total Cost | total_cost_of_construction | number | Total Cost of Construction | 5000 4000 20000 25000 10000 view top 100 |
| Final Cost | final_cost_of_construction | number | Final Cost of Construction | 400000 250000 70000 80000 500000 view top 100 |
| Fire Prevention Cost | fire_prevention_cost_of | number | Fire Prevention Cost of Construction | 0 5000 1000 500 2000 view top 100 |
| Description | detailed_description_of_work | text | Detailed Description of Work | Insulation work as part of the MASS Save program. Residential weatherization/air sealing. No structural changes. Insulation work as part of the MASS Save program. weatherization Insulation work as part of the MASS Save program view top 100 |
| Size of New Addition | size_of_the_new_addition | text | Size of new addition in gross square feet | 0 1 00 120 100 view top 100 |
| Change in Floor Area or Dimensions | floor_area_change | checkbox | Will the work result in any changes to the floor area or any dimensional changes to the building? | false true view top 100 |
| Change in Exterior | exterior_change | checkbox | Does the proposed work change or alter any part of the building's exterior? | false true view top 100 |
| Change at least 25,000 square feet | large_area_change | checkbox | Will the project add and/or alter 25,000 square feet or more of gross building area? | false true view top 100 |
| Change in Food Establishment | food_establishment | checkbox | Will the proposed work result in a new or renovated food establishment? | false true view top 100 |
| Change in Bicycle Parking | bicycle_change | checkbox | Will the proposed work alter the number or type of available vehicle or bicycle parking spaces? | false true view top 100 |
| Energy Compliance Option | energy_code | text | Which energy code compliance option do you intend to take? | Prescriptive Performance (energy modeling required) view top 100 |
| LEED Certification | leed_certification | checkbox | Do you plan to pursue Leadership in Energy and Environmental Design Certification? | false true view top 100 |
| Home Energy Rating (HERS) | hers_rating | checkbox | Do you intend to obtain a Home Energy Rating (HERS)? | false true view top 100 |
| Industrial Sewer Connection Units | industrial_sewer_connection | text | Number of industrial sewer connections from the project | 0 26 view top 100 |
| Commercial Sewer Connection Units | commercial_sewer_connection | text | Number of commercial sewer connections from the project | 5 6 15 11 7 view top 100 |
| Residential Sewer Connection Units | residential_sewer_connection | text | Number of residential sewer connections from the project | 3 4 5 16 12 view top 100 |
| Discharge to Sewer or Storm Water System | drains | checkbox | Addition or alteration of a roof or foundation drain that discharges to the City’s sanitary sewer or storm water system | false true view top 100 |
| New or Replaced Storm Sewer | storm_sewer | checkbox | Will the proposed work result in new, abandoned, or replaced sanitary storm sewer connections? | false true view top 100 |
| Construction Dewatering | dewatering | checkbox | Will the proposed work require construction dewatering during any phase of the project? | false true view top 100 |
| Increase in Impervious Cover | impervious_cover | checkbox | Will the proposed work result in an increase to the property’s impervious cover? | false true view top 100 |
| Public Right-of-Way | public_right | checkbox | Will the proposed work result in a new, abandoned or modified curb cut into the public right-of-way? | false true view top 100 |
| Basement Plumbing Fixture | basement_plumbing | checkbox | Will the proposed work result in the addition or replacement of basement plumbing fixture? | false true view top 100 |
| Change in at least half of total area | half_area | checkbox | Will the proposed work renovate over 50% of the total building area, with 10 or more fixtures replaced or installed? | false true view top 100 |
| Firm Name | firm_name | text | Name of the firm performing the addition or alteration | HomeWorks Energy Romain Strecker Wise Construction Siena Construction Corporation pella windows view top 100 |
| Debris Disposal | construction_debris_will | text | Construction debris will be disposed at/by: | CL Noonan truck Dynamic Waste EZ Disposal Waste Management view top 100 |
| Description of Demolition | description_of_demolition | text | R/R WINDOWS Removal of existing windows. Remove interior doors, trim and frames, Remove floor and wall surfaces in kitchen and bath 1 door Removal of existing view top 100 | |
| Method of Removal | method_of_removal | text | Method for removing debris from the demolition | Daily Removal Dumpster Minimal Container None view top 100 |
| Type of Demolition | type_of_demolition | text | Minor interior demolition in work area only No demolition required Exterior demolition in work area only. Substantial work area demolition or complete interior demolition. Substantial demolition of any structural element or demolition of more than 25% of existing building. view top 100 | |
| Describe the outbuilding | outbuilding_description | text | 1 car Garage 1 Room addition for home office 2 car garage. 2-car garage with 2nd floor storage only. 4-story underground parking garage view top 100 | |
| Changing exterior elements | reconstruction_or_change | checkbox | Reconstruction or change to any existing exterior building element (porch, deck, etc.) | true false view top 100 |
| Construction of exterior stairs | exterior_stairs | checkbox | false true view top 100 | |
| Create Openings | openings_or_doors | checkbox | Create new openings for any window, door, or skylight | false true view top 100 |
| Deck Construction | construction_of_a_deck | checkbox | Construction of a deck (including roof decks) | false true view top 100 |
| Location of Deck | location_of_deck | text | At first floor level Over 1st or 2nd floors Multiple Over existing 1st or 2nd floors view top 100 | |
| Balcony/Landing/Porch Construction | porch_balcony_dormer | checkbox | Construction of dormers, bays, balconies, landings and/or porches | false true view top 100 |
| Exterior Stairs Type | exterior_stairs_type | text | Uncovered Both (Covered and Uncovered) Covered view top 100 | |
| Excavation of a basement | excavation_of_a_basement | checkbox | false true view top 100 | |
| Change in Ceiling Height | change_any_floor_or_ceiling | checkbox | Change any floor or ceiling height | false true view top 100 |
| Outbuilding Construction | outbuilding | checkbox | Erect an outbuilding (ex: shed or garage) | false true view top 100 |
| Number of Stories (Above Grade) | stories_above_grade | text | 3 4 2 5 1 view top 100 | |
| Building Height | building_height_feet | text | Building height in feet | 0 30 40 35 60 view top 100 |
| Gross Square Footage | gross_square_footage | text | 0 3000 30411 1 10000 view top 100 | |
| Building Use | building_use | text | One or Two Family Dwelling Commercial / Mixed Use Multi Family (3 or more dwelling units) Townhouse view top 100 | |
| Owner-Occupied | owner_occupied | checkbox | Is the property owner-occupied? | true false view top 100 |
| Condo Association | condo_association | checkbox | Is the property part of a condo association? | false true view top 100 |
| Building Construction Type | building_construction_type | text | Wood (Type (IV/V) Steel/Concrete, Non-Combustible (Type I/II) Masonry / Wood (Type III) view top 100 | |
| Off-Street Vehicle Parking Spaces | off_street_parking | text | Number of Proposed Off-Street Vehicle Parking Spaces | 0 2 1 3 4 view top 100 |
| Proposed Loading Bays | proposed_loading_bays | text | Number of Proposed Loading Bays | 0 1 3 2 5 view top 100 |
| Existing Off-Street Vehicle Parking Spaces | existing_off_street_vehicle_parking | text | Number of Existing Off-Street Vehicle Parking Spaces | 0 2 1 3 4 view top 100 |
| Existing Off-Street Bicycle Parking Spaces (Long Term) | existing_off_street_bicycle_parking_long_term | text | Number of Existing Off-Street Bicycle Parking Spaces (Long Term) | 0 3 5 17 295 view top 100 |
| Proposed Off-Street Bicycle Parking Spaces (Long Term) | proposed_off_street_bicycle_parking_long_term | text | Number of Proposed Off-Street Bicycle Parking Spaces (Long Term) | 0 3 12 5 2 view top 100 |
| Existing Off-Street Bicycle Parking Spaces (Short Term) | existing_off_street_bicycle_parking_short_term | text | Number of Existing Off-Street Bicycle Parking Spaces (Short Term) | view top 100 |
| Proposed Off-Street Bicycle Parking Spaces (Short Term) | proposed_off_street_bicycle_parking_short_term | text | Number of Proposed Off-Street Bicycle Parking Spaces (Short Term) | view top 100 |
| Change to Off-Street Parking Spaces | off_street_parking_change | text | 0 1 -2 -4 2 view top 100 | |
| Curb Cut | curb_cut | checkbox | Is there an existing curb cut? | true false view top 100 |
| Other Cooking Equipment | other_cooking_equipment | text | Coffee Machines cut fruit and blenders only Existing Microwave N/A view top 100 | |
| Finish Materials | finish_materials | text | Describe the finish materials for the floor, walls, ceiling and cove | smooth and easily cleanable SMOOTH AND EASY TO CLEAN SMOOTH AND EASILY CLEANABLE All finish materials are existing. Work scope limited to repairs only. Floor: hard wood. Walls: dry wall. Ceiling: plaster. Cove: n/a. All finish materials within food preparation areas are smooth, non-porous, washable surfaces. view top 100 |
| Open Air Windows | open_air_cafe | checkbox | Will the food establishment include open air cafe windows? | false true view top 100 |
| Cooking Equipment Type | cooking_equipment_type | text | Gas & Electric Electric Gas Other view top 100 | |
| Certificate of Occupancy Required | certificate_of_occupancy | checkbox | Is a certificate of occupancy required for this project? | true false view top 100 |
| Board of Zoning Appeal (BZA) Case Number | bza_number | text | BZA-015433-2018 BZA-014892-2017 BZA-017148-2019 BZA-017091-2019 BZA-017211-2019 view top 100 | |
| Planning Board Special Permit Number | planning_board_number | text | 179 N/A PB-360 PB303 PB-038 view top 100 | |
| BZA Case | bza | checkbox | Is this application subject to a Board of Zoning Appeal (BZA) Case? | false true view top 100 |
| Planning Board Special Permit | planning_board | checkbox | Is this application subject to a Planning Board Special Permit? | false true view top 100 |