This dataset has been deprecated and replaced by two new building permit datasets: Building Permits: Addition/Alteration https://data.cambridgema.gov/Inspectional-Services/Building-Permits-Addition-Alteration/qu2z-8suj/data New Building Permits https://data.cambridgema.gov/Inspectional-Services/New-Building-Permits/9qm7-wbdc/data **** Description for Deprecated Dataset: Approved building permits for 1 and 2 family homes. Building permits are issued to licensed construction supervisors and enable recipients to construct, alter, or demolish a structure or install a sign. The building permit must be obtained from Cambridge's Inspectional Services Department before the start of any work and must be prominently posted at the job site. This dataset includes building permits for the construction of renovation of 1 and 2 family homes.
This dataset has the following 72 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| PLANNUMBER | plannumber | text | Auto-created plan number | BLDR-014675-2017 BLDR-000962-2013 BLDR-015238-2017 BLDR-007546-2015 BLDR-009610-2016 view top 100 |
| PARCELNUMBER | parcelnumber | text | Property parcel number | 199-132 127-147 271-46 217-14 110-42 view top 100 |
| ADDRESS | address | location | Address where work is to be performed | view top 100 |
| UNITORSUITE | unitorsuite | text | Unit/Suite Number | 1 2 3 4 A view top 100 |
| APPLICATIONDATE | applicationdate | date | Date of Application | 2013-02-25T09:31:27.000Z 2013-02-25T09:47:55.000Z 2013-02-27T09:12:17.000Z 2013-02-27T10:31:47.000Z 2013-02-27T14:28:01.000Z view top 100 |
| Complete_Date | complete_date | date | Plan application completion date. | 2013-02-25T16:50:44.000Z 2013-02-25T18:42:33.000Z 2013-02-28T09:29:20.000Z 2013-02-28T15:34:57.000Z 2013-03-04T15:49:58.000Z view top 100 |
| Applicant | applicant | text | Name of applicant | The Home Depot S+H Construction Renewal by Andersen pella windows SunBug Solar view top 100 |
| Class | class | text | Work class | Addition/Alteration Roof Siding New view top 100 |
| BldCnstrType_NC_VALUE | bldcnstrtype_nc_value | text | Type of building construction | 0 Non-Combustible (Type I/II) view top 100 |
| BldCnstrType_MW_VALUE | bldcnstrtype_mw_value | text | Type of building construction | 0 Masonry/Wood (Type III) view top 100 |
| BldCnstrType_WOOD_VALUE | bldcnstrtype_wood_value | text | Type of building construction | Wood (Type IV/V) 0 view top 100 |
| BldType_SingleFamily | bldtype_singlefamily | text | Single Family | 0 Single-Family view top 100 |
| BldType_TwoFamily | bldtype_twofamily | text | Two Family | 0 Two-Family view top 100 |
| BldType_TownHouse | bldtype_townhouse | text | Town House | 0 Townhouse view top 100 |
| BldType_AccessoryBuilding | bldtype_accessorybuilding | text | Accessory Building | 0 Accessory Building view top 100 |
| ChangeinNumberofUnits | changeinnumberofunits | text | Was there a change in the number of units | No Yes view top 100 |
| ChangeInNumberOfUnitsQuantity | changeinnumberofunitsquantity | text | The number of units added or subtracted | 0 no 1 none N/A view top 100 |
| ExteriorAlteration | exterioralteration | text | Is work to be performed on exterior | No Yes view top 100 |
| ParkingSpaces | parkingspaces | number | Number of parking spaces | 0 2 1 4 3 view top 100 |
| TwoYearVacancy | twoyearvacancy | text | Was property vacant 2 years prior to application | No Yes view top 100 |
| BuildingCostofConstruction | buildingcostofconstruction | number | Cost of building construction | 10000 5000 15000 20000 4000 view top 100 |
| ElectricalCostofConstruction | electricalcostofconstruction | number | Cost of electrical work | 0 5000 2000 3000 10000 view top 100 |
| PlumbingCostofConstruction | plumbingcostofconstruction | number | Cost of plumbing work | 0 5000 3000 15000 4000 view top 100 |
| GasCostofConstruction | gascostofconstruction | number | Cost of gas work | 0 1000 2000 5000 3000 view top 100 |
| HVACCostofConstruction | hvaccostofconstruction | number | Cost of HVAC work | 0 15000 25000 30000 20000 view top 100 |
| TotalCostofConstruction | totalcostofconstruction | number | Total cost of all work to be completed | 10000 5000 15000 20000 12000 view top 100 |
| DetailedDescriptionofWork | detaileddescriptionofwork | text | Description of work to be completed | Air sealing and insulation Remove and replace existing siding. Install Pella replacement windows and exterior paint Strip and Re-shingle existing roof air sealing and insulation strip and re roof view top 100 |
| CurrentUse | currentuse | text | Current use of property | One-Family Two-Family Townhouse Vacant Lot view top 100 |
| ProposedUse | proposeduse | text | Proposed use of property | One-Family Two-Family Townhouse Accessory view top 100 |
| ZoningDistrict | zoningdistrict | text | Zoning district of property | B C-1 res residential c-1 view top 100 |
| BZACaseNumber | bzacasenumber | text | Board of Zoning Appeal case number | N/A NA n/a 0 na view top 100 |
| PBCaseNumber | pbcasenumber | text | Planning Board case number | N/A NA 0 n/a na view top 100 |
| ProposedWorkReconst | proposedworkreconst | checkbox | Proposed work includes reconstruction of an existing exterior building element (porch, deck, etc.). | false true view top 100 |
| ProposedWorkPrchStrsDeck | proposedworkprchstrsdeck | checkbox | Proposed work includes - enclose a covered porch, build uncovered exterior stairs, build decks at the 1st floor level, build roof decks over existing 1st or 2nd floors, create new windows (including moving existing windows), doors, or skylights. | false true view top 100 |
| ProposedWorkNewConst | proposedworknewconst | checkbox | Proposed work includes - new construction, additions, dormers, bays, balconies, covered stairs/landings and/or porches, decks at the 2nd floor level or higher, roof decks over the 3rd floor or higher, or to excavate a basement, change any floor or ceiling height, change the use or increase the number of dwelling units of a building, erect an outbuilding, or to do any similar work. | false true view top 100 |
| ProposedWorkNotReg | proposedworknotreg | checkbox | Proposed work does not fall under any of the above categories (reconstruction, porch/deck/stairs, new construction). The proposed work is not of the types listed above and is not regulated by the zoning ordinance. | true false view top 100 |
| ProposedWorkEnergyEnv | proposedworkenergyenv | checkbox | Work does not access energy envelope | true false view top 100 |
| EnvelopeInsulationReq | envelopeinsulationreq | checkbox | Meets or exceeds energy code | false true view top 100 |
| CavitiesInsulatingMaterials | cavitiesinsulatingmaterials | checkbox | Type of insulation being used | false true view top 100 |
| EnerConservFiberglass | enerconservfiberglass | checkbox | Fiberglass insulation | false true view top 100 |
| EnergyConservSprayFoam | energyconservsprayfoam | checkbox | Spray foam insulation | false true view top 100 |
| EnergyConservBlowninCellulose | energyconservblownincellulose | checkbox | Blown in insulation | false true view top 100 |
| EnerConservOther | enerconservother | text | Other type of insulation | n/a 0 na NA door view top 100 |
| EnergyConservUValueofWindows | energyconservuvalueofwindows | text | U-Value of windows | .30 .29 29 0.29 0.30 view top 100 |
| LEEDRatingsLevel | leedratingslevel | text | LEED rating level (LEED means Leadership in Energy and Environmental Design) | 0 n/a NA Certified na view top 100 |
| LEEDRatingsCredits | leedratingscredits | text | LEED rating credits (LEED means Leadership in Energy and Environmental Design) | 0 n/a NA See Attached na view top 100 |
| SolarPanels | solarpanels | number | Number of solar panels | 0 20 16 13 18 view top 100 |
| SolarPanelsUseforHotWater | solarpanelsuseforhotwater | checkbox | Are solar panels used for hot water | false true view top 100 |
| CogenerationSystem | cogenerationsystem | number | Number of cogeneration systems | 0 view top 100 |
| CogenerationSystemSize | cogenerationsystemsize | text | Size of cogeneration systems | 0 n/a na 0.96 ef N/a view top 100 |
| CogenerationSystemLocation | cogenerationsystemlocation | text | Location of cogeneration systems | 0 n/a NA na N/A view top 100 |
| WindTurbines | windturbines | number | Number of wind turbines | 0 view top 100 |
| WindTurbinesSize | windturbinessize | text | Size of wind turbines | 0 n/a na NA N/A view top 100 |
| WindTurbinesLocation | windturbineslocation | text | Location of wind turbines | 0 n/a NA na N/A view top 100 |
| ProposedHERSRating | proposedhersrating | text | Proposed HERS rating (HERS means Home Energy Rating System) | 0 n/a 55 na NA view top 100 |
| StretchCodeExempt | stretchcodeexempt | checkbox | Is project stretch code exempt | false true view top 100 |
| ConfirmedHERSRating | confirmedhersrating | text | Confirmed HERS rating (HERS means Home Energy Rating System) | 55 62-67 view top 100 |
| LEEDRating_NewConstruction | leedrating_newconstruction | text | Type of LEEDS rating system (LEED means Leadership in Energy and Environmental Design) | 0 view top 100 |
| LEEDRating_ComercialInteriors | leedrating_comercialinteriors | text | Type of LEEDS rating system (LEED means Leadership in Energy and Environmental Design) | 0 view top 100 |
| LEEDRating_CoreShell | leedrating_coreshell | text | Type of LEEDS rating system (LEED means Leadership in Energy and Environmental Design) | 0 Core & Shell view top 100 |
| LEEDRating_Schools | leedrating_schools | text | Type of LEEDS rating system (LEED means Leadership in Energy and Environmental Design) | 0 view top 100 |
| LEEDRating_Retail | leedrating_retail | text | Type of LEEDS rating system (LEED means Leadership in Energy and Environmental Design) | 0 view top 100 |
| LEEDRating_Homes | leedrating_homes | text | Type of LEEDS rating system (LEED means Leadership in Energy and Environmental Design) | 0 Homes view top 100 |
| DesignedLEEDRatingLevel | designedleedratinglevel | text | Designed LEED rating level (LEED means Leadership in Energy and Environmental Design) | 0 n/a NA Silver na view top 100 |
| DesignedLEEDRatingCredits | designedleedratingcredits | number | Number of Designed LEED rating credits (LEED means Leadership in Energy and Environmental Design) | 0 64.5 22.5 48 view top 100 |
| ConfirmedLEEDRatingLevel | confirmedleedratinglevel | text | Confirmed LEED rating level (LEED means Leadership in Energy and Environmental Design) | view top 100 |
| ConfirmedLEEDRatingCredits | confirmedleedratingcredits | number | Number of Confirmed LEED rating credits (LEED means Leadership in Energy and Environmental Design) | 0 view top 100 |
| MinorInteriorDemo | minorinteriordemo | checkbox | Extent of demolition - minor | false true view top 100 |
| SubstantialDemo | substantialdemo | checkbox | Extent of demolition - substantial | false true view top 100 |
| ExteriorDemoWorkAreaOnly | exteriordemoworkareaonly | checkbox | Extent of demolition - work area only | false true view top 100 |
| SubstDemoStructuralElements | substdemostructuralelements | checkbox | Extent of demolition - structural elements | false true view top 100 |
| DescriptionofDemolition | descriptionofdemolition | text | Description of demolition | N/A none n/a None R/R WINDOWS view top 100 |