cambridgema-gov/building-permits-commercial-and-multifamily-24a8-ex6a

  • building
  • business
  • construction
  • inspection
  • permit

Building Permits: Commercial and Multi-Family Buildings - DEPRECATED

Building Permits: Commercial and Multi-Family Buildings - DEPRECATED

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.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
LEEDRating_Homesleedrating_homesleedrating_homesText
BldType_AccessoryBuildingbldtype_accessorybuildingbldtype_accessorybuildingTextAccessory Building
BldgCommSprinklerSystembldgcommsprinklersystembldgcommsprinklersystemTextBuilding has a commercial sprinkler system
ExistingOffStBicycleParkingSTexistingoffstbicycleparkingstexistingoffstbicycleparkingstText
ProposedWorkEnergyEnvproposedworkenergyenvproposedworkenergyenvTextWork will affect building's energy envelope
LEEDRating_ComercialInteriorsleedrating_comercialinteriorsleedrating_comercialinteriorsTextType of LEEDS rating system (LEED means Leadership in Energy and Environmental Design)
ProposedWorkNewConstproposedworknewconstproposedworknewconstTextProposed 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.
CogenerationSystemLocationcogenerationsystemlocationcogenerationsystemlocationText
ConfirmedHERSRatingconfirmedhersratingconfirmedhersratingText
ADDRESS (state)location_1_statelocation_1_stateText
UNITORSUITEunitorsuiteunitorsuiteTextUnit/Suite Number
BldCnstrType_NC_VALUEbldcnstrtype_nc_valuebldcnstrtype_nc_valueTextType of building construction
BuildingCostofConstructionbuildingcostofconstructionbuildingcostofconstructionNumberCost of building construction
BuildingHeightbuildingheightbuildingheightTextBuilding height
ExistingOffStBicycleParkingexistingoffstbicycleparkingexistingoffstbicycleparkingTextOff street bicycle parking associated with site
LEEDRatingsCreditsleedratingscreditsleedratingscreditsTextLEED rating credits (LEED means Leadership in Energy and Environmental Design)
SolarPanelssolarpanelssolarpanelsText
LEEDRating_CoreShellleedrating_coreshellleedrating_coreshellTextType of LEEDS rating system (LEED means Leadership in Energy and Environmental Design)
PLANNUMBERplannumberplannumberTextAuto-created plan number. "BLDC" signifies commercial buildings, and "BLDM" multifamily buildings.
PARCELNUMBERparcelnumberparcelnumberTextProperty parcel number
ADDRESS (address)location_1_addresslocation_1_addressText
Complete_Datecomplete_datecomplete_dateCalendar datePlan application completion date
ApplicantapplicantapplicantTextName of applicant
GrossSquareFootagegrosssquarefootagegrosssquarefootageTextGross square footage area
ElectricalCostofConstructionelectricalcostofconstructionelectricalcostofconstructionNumberCost of electrical work
PlumbingCostofConstructionplumbingcostofconstructionplumbingcostofconstructionNumberCost of plumbing work
GasCostofConstructiongascostofconstructiongascostofconstructionNumberCost of gas work
HVACCostofConstructionhvaccostofconstructionhvaccostofconstructionNumberCost of HVAC work
FireProtectionSysCostofConstfireprotectionsyscostofconstfireprotectionsyscostofconstNumberCost of fire protection system construction work.
TotalCostofConstructiontotalcostofconstructiontotalcostofconstructionNumberTotal cost of construction
ExistingOffStVehicleParkingexistingoffstvehicleparkingexistingoffstvehicleparkingTextNumber of off street parking spots associated with site
ProposedOffStBicycleParkingproposedoffstbicycleparkingproposedoffstbicycleparkingTextChange in number of off street bicycle spots
ProposedOffStBicycleParkingSTproposedoffstbicycleparkingstproposedoffstbicycleparkingstText
ProposedLoadingFacilitiesproposedloadingfacilitiesproposedloadingfacilitiesTextProposed number of loading facilities.
NumberofProposedLoadingBaysnumberofproposedloadingbaysnumberofproposedloadingbaysText
CurrentUsecurrentusecurrentuseTextCurrent use for the site
ProposedUseproposeduseproposeduseTextProposed use for the facility
ZoningDistrictzoningdistrictzoningdistrictTextZoning district of property
BZACaseNumberbzacasenumberbzacasenumberTextBoard of Zoning Appeal case number
PBCaseNumberpbcasenumberpbcasenumberTextPlanning Board case number
StretchCodeIECCstretchcodeieccstretchcodeieccTextThe 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).
CogenerationSystemcogenerationsystemcogenerationsystemText
ProposedHERSRatingproposedhersratingproposedhersratingTextRating on the HERS scale for energy performance
BldType_TwoFamilybldtype_twofamilybldtype_twofamilyTextTwo Family
DesignedLEEDRatingCreditsdesignedleedratingcreditsdesignedleedratingcreditsNumberType of LEEDS rating system (LEED means Leadership in Energy and Environmental Design)
NumberofTentsnumberoftentsnumberoftentsTextNumber of tents on building site
DatetobeErecteddatetobeerecteddatetobeerectedCalendar dateDate tents to be erected
DatetobeRemoveddatetoberemoveddatetoberemovedTextDate to be removed
DescriptionofDemolitiondescriptionofdemolitiondescriptionofdemolitionTextDescription of Demolition
cambridge_cdd_zoning:@computed_region_swkg_bavi:@computed_region_swkg_baviNumber
cambridge_neighborhoods:@computed_region_rffn_qbt6:@computed_region_rffn_qbt6Number
Police Response Districts:@computed_region_v7jj_366k:@computed_region_v7jj_366kNumber
Police Neighborhood Regions:@computed_region_guic_hr4a:@computed_region_guic_hr4aNumber
Census Blocks 2010:@computed_region_e4yd_rwk4:@computed_region_e4yd_rwk4Number
ExteriorDemoWorkAreaOnlyexteriordemoworkareaonlyexteriordemoworkareaonlyTextExtent of demolition - work area only
BldType_TownHousebldtype_townhousebldtype_townhouseTextTown House
NumberofExistingLoadingBaysnumberofexistingloadingbaysnumberofexistingloadingbaysTextNumber of existing loading bays
WindTurbineswindturbineswindturbinesText
WindTurbinesSizewindturbinessizewindturbinessizeText
ClassclassclassText
BldCnstrType_MW_VALUEbldcnstrtype_mw_valuebldcnstrtype_mw_valueTextType of building construction
NumberofStoriesnumberofstoriesnumberofstoriesTextNumber of stories
ProposedOffStVehicleParkingproposedoffstvehicleparkingproposedoffstvehicleparkingTextChange in number of off street parking spots
LEEDRatingsLevelleedratingslevelleedratingslevelTextLEED rating (LEED means Leadership in Energy and Environmental Design)
cambridge_zipcodes:@computed_region_rcj3_ccgu:@computed_region_rcj3_ccguNumber
ADDRESS (zip)location_1_ziplocation_1_zipText
StretchCodeOptionsstretchcodeoptionsstretchcodeoptionsTextThe stretch code has two options: a performance approach (HERS) and a prescriptive approach
SizeofTentssizeoftentssizeoftentsTextNumber of tents on building site
LEEDRating_Retailleedrating_retailleedrating_retailText
DesignedLEEDRatingLeveldesignedleedratingleveldesignedleedratinglevelTextType of LEEDS rating system (LEED means Leadership in Energy and Environmental Design)
BldgCommFireAlarmbldgcommfirealarmbldgcommfirealarmTextBuilding has a commercial file alarm
WindTurbinesLocationwindturbineslocationwindturbineslocationText
BldgCommLightingSystemChangesbldgcommlightingsystemchangesbldgcommlightingsystemchangesTextChanges to building's lighting system
LEEDRating_NewConstructionleedrating_newconstructionleedrating_newconstructionTextType of LEEDS rating system (LEED means Leadership in Energy and Environmental Design)
LEEDRating_Schoolsleedrating_schoolsleedrating_schoolsTextType of LEEDS rating system (LEED means Leadership in Energy and Environmental Design)
SolarPanelsUseforHotWatersolarpanelsuseforhotwatersolarpanelsuseforhotwaterText
CogenerationSystemSizecogenerationsystemsizecogenerationsystemsizeText
SubstDemoStructuralElementssubstdemostructuralelementssubstdemostructuralelementsTextExtent of demolition - structural elements
BldgCommSmokeDetectionbldgcommsmokedetectionbldgcommsmokedetectionTextBuilding has a commercial smoke detector
StretchCodeExemptstretchcodeexemptstretchcodeexemptText
ADDRESS (city)location_1_citylocation_1_cityText
APPLICATIONDATEapplicationdateapplicationdateCalendar dateDate of Application
BldCnstrType_WOOD_VALUEbldcnstrtype_wood_valuebldcnstrtype_wood_valueTextType of building construction
CurrentNumDwellingUnitscurrentnumdwellingunitscurrentnumdwellingunitsTextCurrent number of dwelling units
MoreThan25000SqFtmorethan25000sqftmorethan25000sqftTextBuilding is more than 25,000 square feet in area.
EnergyConservUValueofWindowsenergyconservuvalueofwindowsenergyconservuvalueofwindowsTextEnergy conservation value of windows
MinorInteriorDemominorinteriordemominorinteriordemoTextExtent of demolition - minor
SubstantialDemosubstantialdemosubstantialdemoTextExtent of demolition - substantial
TwoYearVacancytwoyearvacancytwoyearvacancyTextWas property vacant 2 years prior to application
ProposedWorkReconstproposedworkreconstproposedworkreconstTextProposed work includes reconstruction of an existing exterior building element (porch, deck, etc.).
ProposedWorkPrchStrsDeckproposedworkprchstrsdeckproposedworkprchstrsdeckTextProposed 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.
ConfirmedLEEDRatingCreditsconfirmedleedratingcreditsconfirmedleedratingcreditsTextType of LEEDS rating system (LEED means Leadership in Energy and Environmental Design)
ADDRESSlocation_1location_1PointAddress where work is to be performed
ProposedNumDwellingUnitsproposednumdwellingunitsproposednumdwellingunitsTextProposed number of dwelling units
DetailedDescriptionofWorkdetaileddescriptionofworkdetaileddescriptionofworkTextDescription of work to be completed
ProposedWorkNotRegproposedworknotregproposedworknotregTextProposed 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.
ConfirmedLEEDRatingLevelconfirmedleedratinglevelconfirmedleedratinglevelTextType of LEEDS rating system (LEED means Leadership in Energy and Environmental Design)
BldType_SingleFamilybldtype_singlefamilybldtype_singlefamilyTextSingle Family

Upstream Metadata