Building Permits: Commercial and Multi-Family Buildings - DEPRECATED

data.cambridgema.gov | Last Updated 14 May 2019

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 commercial buildings and multifamily homes. The PLANNUMBER column uses "BLDC" to indicate commercial buildings and "BLDM" to indicate multifamily 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 commercial buildings.

Tags: building, permit, inspection, construction, business

This dataset has the following 88 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
PLANNUMBERplannumbertextAuto-created plan number. "BLDC" signifies commercial buildings, and "BLDM" multifamily buildings.
PARCELNUMBERparcelnumbertextProperty parcel number
ADDRESSlocation_1locationAddress where work is to be performed
UNITORSUITEunitorsuitetextUnit/Suite Number
APPLICATIONDATEapplicationdatecalendar_dateDate of Application
Complete_Datecomplete_datecalendar_datePlan application completion date
ApplicantapplicanttextName of applicant
Classclasstext
BldCnstrType_NC_VALUEbldcnstrtype_nc_valuetextType of building construction
BldCnstrType_MW_VALUEbldcnstrtype_mw_valuetextType of building construction
BldCnstrType_WOOD_VALUEbldcnstrtype_wood_valuetextType of building construction
BldType_SingleFamilybldtype_singlefamilytextSingle Family
BldType_TwoFamilybldtype_twofamilytextTwo Family
BldType_TownHousebldtype_townhousetextTown House
BldType_AccessoryBuildingbldtype_accessorybuildingtextAccessory Building
CurrentNumDwellingUnitscurrentnumdwellingunitstextCurrent number of dwelling units
ProposedNumDwellingUnitsproposednumdwellingunitstextProposed number of dwelling units
BldgCommSprinklerSystembldgcommsprinklersystemtextBuilding has a commercial sprinkler system
BldgCommFireAlarmbldgcommfirealarmtextBuilding has a commercial file alarm
BldgCommSmokeDetectionbldgcommsmokedetectiontextBuilding has a commercial smoke detector
GrossSquareFootagegrosssquarefootagetextGross square footage area
TwoYearVacancytwoyearvacancytextWas property vacant 2 years prior to application
BuildingCostofConstructionbuildingcostofconstructionnumberCost of building construction
ElectricalCostofConstructionelectricalcostofconstructionnumberCost of electrical work
PlumbingCostofConstructionplumbingcostofconstructionnumberCost of plumbing work
GasCostofConstructiongascostofconstructionnumberCost of gas work
HVACCostofConstructionhvaccostofconstructionnumberCost of HVAC work
FireProtectionSysCostofConstfireprotectionsyscostofconstnumberCost of fire protection system construction work.
TotalCostofConstructiontotalcostofconstructionnumberTotal cost of construction
MoreThan25000SqFtmorethan25000sqfttextBuilding is more than 25,000 square feet in area.
BuildingHeightbuildingheighttextBuilding height
NumberofStoriesnumberofstoriestextNumber of stories
ExistingOffStVehicleParkingexistingoffstvehicleparkingtextNumber of off street parking spots associated with site
ProposedOffStVehicleParkingproposedoffstvehicleparkingtextChange in number of off street parking spots
ExistingOffStBicycleParkingexistingoffstbicycleparkingtextOff street bicycle parking associated with site
ProposedOffStBicycleParkingproposedoffstbicycleparkingtextChange in number of off street bicycle spots
ExistingOffStBicycleParkingSTexistingoffstbicycleparkingsttext
ProposedOffStBicycleParkingSTproposedoffstbicycleparkingsttext
ProposedLoadingFacilitiesproposedloadingfacilitiestextProposed number of loading facilities.
NumberofProposedLoadingBaysnumberofproposedloadingbaystext
NumberofExistingLoadingBaysnumberofexistingloadingbaystextNumber of existing loading bays
DetailedDescriptionofWorkdetaileddescriptionofworktextDescription of work to be completed
CurrentUsecurrentusetextCurrent use for the site
ProposedUseproposedusetextProposed use for the facility
ZoningDistrictzoningdistricttextZoning district of property
BZACaseNumberbzacasenumbertextBoard of Zoning Appeal case number
PBCaseNumberpbcasenumbertextPlanning Board case number
ProposedWorkReconstproposedworkreconsttextProposed work includes reconstruction of an existing exterior building element (porch, deck, etc.).
ProposedWorkPrchStrsDeckproposedworkprchstrsdecktextProposed 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.
ProposedWorkNewConstproposedworknewconsttextProposed 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.
ProposedWorkNotRegproposedworknotregtextProposed 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.
StretchCodeIECCstretchcodeiecctextThe stretch code applies a performance-based code to commercial buildings, with the option of a prescriptive code for small and medium-sized commercial buildings. Buildings smaller than 5,000 square feet are exempt, as are building renovations, and “specialty” buildings – supermarkets, laboratories, and warehouses – below 40,000 square feet in size, due to their widely differing energy needs. These exempt buildings remain subject to the „base‟ Massachusetts energy code (IECC 2009 and ASHRAE 90.1-2007).
BldgCommLightingSystemChangesbldgcommlightingsystemchangestextChanges to building's lighting system
StretchCodeOptionsstretchcodeoptionstextThe stretch code has two options: a performance approach (HERS) and a prescriptive approach
ProposedWorkEnergyEnvproposedworkenergyenvtextWork will affect building's energy envelope
EnergyConservUValueofWindowsenergyconservuvalueofwindowstextEnergy conservation value of windows
LEEDRatingsLevelleedratingsleveltextLEED rating (LEED means Leadership in Energy and Environmental Design)
LEEDRatingsCreditsleedratingscreditstextLEED rating credits (LEED means Leadership in Energy and Environmental Design)
SolarPanelssolarpanelstext
SolarPanelsUseforHotWatersolarpanelsuseforhotwatertext
CogenerationSystemcogenerationsystemtext
CogenerationSystemSizecogenerationsystemsizetext
CogenerationSystemLocationcogenerationsystemlocationtext
WindTurbineswindturbinestext
WindTurbinesSizewindturbinessizetext
WindTurbinesLocationwindturbineslocationtext
ProposedHERSRatingproposedhersratingtextRating on the HERS scale for energy performance
StretchCodeExemptstretchcodeexempttext
ConfirmedHERSRatingconfirmedhersratingtext
LEEDRating_NewConstructionleedrating_newconstructiontextType of LEEDS rating system (LEED means Leadership in Energy and Environmental Design)
LEEDRating_ComercialInteriorsleedrating_comercialinteriorstextType of LEEDS rating system (LEED means Leadership in Energy and Environmental Design)
LEEDRating_CoreShellleedrating_coreshelltextType of LEEDS rating system (LEED means Leadership in Energy and Environmental Design)
LEEDRating_Schoolsleedrating_schoolstextType of LEEDS rating system (LEED means Leadership in Energy and Environmental Design)
LEEDRating_Retailleedrating_retailtext
LEEDRating_Homesleedrating_homestext
DesignedLEEDRatingLeveldesignedleedratingleveltextType of LEEDS rating system (LEED means Leadership in Energy and Environmental Design)
DesignedLEEDRatingCreditsdesignedleedratingcreditsnumberType of LEEDS rating system (LEED means Leadership in Energy and Environmental Design)
ConfirmedLEEDRatingLevelconfirmedleedratingleveltextType of LEEDS rating system (LEED means Leadership in Energy and Environmental Design)
ConfirmedLEEDRatingCreditsconfirmedleedratingcreditstextType of LEEDS rating system (LEED means Leadership in Energy and Environmental Design)
NumberofTentsnumberoftentstextNumber of tents on building site
SizeofTentssizeoftentstextNumber of tents on building site
DatetobeErecteddatetobeerectedcalendar_dateDate tents to be erected
DatetobeRemoveddatetoberemovedtextDate to be removed
MinorInteriorDemominorinteriordemotextExtent of demolition - minor
SubstantialDemosubstantialdemotextExtent of demolition - substantial
ExteriorDemoWorkAreaOnlyexteriordemoworkareaonlytextExtent of demolition - work area only
SubstDemoStructuralElementssubstdemostructuralelementstextExtent of demolition - structural elements
DescriptionofDemolitiondescriptionofdemolitiontextDescription of Demolition