Building Permits: 1 and 2 Family - DEPRECATED
Building Permits: 1 and 2 Family - DEPRECATED
This dataset has been deprecated and replaced by two new building permit datasets:
Building Permits: Addition/Alteration
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.
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| BZACaseNumber | bzacasenumber | bzacasenumber | Text | Board of Zoning Appeal case number |
| SubstantialDemo | substantialdemo | substantialdemo | Checkbox | Extent of demolition - substantial |
| ConfirmedLEEDRatingLevel | confirmedleedratinglevel | confirmedleedratinglevel | Text | Confirmed LEED rating level (LEED means Leadership in Energy and Environmental Design) |
| EnergyConservUValueofWindows | energyconservuvalueofwindows | energyconservuvalueofwindows | Text | U-Value of windows |
| ZoningDistrict | zoningdistrict | zoningdistrict | Text | Zoning district of property |
| DetailedDescriptionofWork | detaileddescriptionofwork | detaileddescriptionofwork | Text | Description of work to be completed |
| HVACCostofConstruction | hvaccostofconstruction | hvaccostofconstruction | Number | Cost of HVAC work |
| GasCostofConstruction | gascostofconstruction | gascostofconstruction | Number | Cost of gas work |
| BuildingCostofConstruction | buildingcostofconstruction | buildingcostofconstruction | Number | Cost of building construction |
| BldType_SingleFamily | bldtype_singlefamily | bldtype_singlefamily | Text | Single Family |
| Applicant | applicant | applicant | Text | Name of applicant |
| Complete_Date | complete_date | complete_date | Date | Plan application completion date. |
| APPLICATIONDATE | applicationdate | applicationdate | Date | Date of Application |
| UNITORSUITE | unitorsuite | unitorsuite | Text | Unit/Suite Number |
| ADDRESS (address) | address_address | address_address | Text | |
| PLANNUMBER | plannumber | plannumber | Text | Auto-created plan number |
| DescriptionofDemolition | descriptionofdemolition | descriptionofdemolition | Text | Description of demolition |
| DesignedLEEDRatingCredits | designedleedratingcredits | designedleedratingcredits | Number | Number of Designed LEED rating credits (LEED means Leadership in Energy and Environmental Design) |
| EnerConservOther | enerconservother | enerconservother | Text | Other type of insulation |
| ProposedWorkNotReg | 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. |
| PBCaseNumber | pbcasenumber | pbcasenumber | Text | Planning Board case number |
| ProposedUse | proposeduse | proposeduse | Text | Proposed use of property |
| TotalCostofConstruction | totalcostofconstruction | totalcostofconstruction | Number | Total cost of all work to be completed |
| PlumbingCostofConstruction | plumbingcostofconstruction | plumbingcostofconstruction | Number | Cost of plumbing work |
| BldCnstrType_MW_VALUE | bldcnstrtype_mw_value | bldcnstrtype_mw_value | Text | Type of building construction |
| ADDRESS (zip) | address_zip | address_zip | Text | |
| PARCELNUMBER | parcelnumber | parcelnumber | Text | Property parcel number |
| SubstDemoStructuralElements | substdemostructuralelements | substdemostructuralelements | Checkbox | Extent of demolition - structural elements |
| ExteriorDemoWorkAreaOnly | exteriordemoworkareaonly | exteriordemoworkareaonly | Checkbox | Extent of demolition - work area only |
| StretchCodeExempt | stretchcodeexempt | stretchcodeexempt | Checkbox | Is project stretch code exempt |
| WindTurbinesLocation | windturbineslocation | windturbineslocation | Text | Location of wind turbines |
| EnergyConservBlowninCellulose | energyconservblownincellulose | energyconservblownincellulose | Checkbox | Blown in insulation |
| EnergyConservSprayFoam | energyconservsprayfoam | energyconservsprayfoam | Checkbox | Spray foam insulation |
| ElectricalCostofConstruction | electricalcostofconstruction | electricalcostofconstruction | Number | Cost of electrical work |
| ADDRESS (state) | address_state | address_state | Text | |
| ADDRESS (city) | address_city | address_city | Text | |
| LEEDRating_Schools | leedrating_schools | leedrating_schools | Text | Type of LEEDS rating system (LEED means Leadership in Energy and Environmental Design) |
| ConfirmedLEEDRatingCredits | confirmedleedratingcredits | confirmedleedratingcredits | Number | Number of Confirmed LEED rating credits (LEED means Leadership in Energy and Environmental Design) |
| ConfirmedHERSRating | confirmedhersrating | confirmedhersrating | Text | Confirmed HERS rating (HERS means Home Energy Rating System) |
| CogenerationSystemLocation | cogenerationsystemlocation | cogenerationsystemlocation | Text | Location of cogeneration systems |
| ProposedWorkPrchStrsDeck | 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. |
| TwoYearVacancy | twoyearvacancy | twoyearvacancy | Text | Was property vacant 2 years prior to application |
| ParkingSpaces | parkingspaces | parkingspaces | Number | Number of parking spaces |
| ChangeinNumberofUnits | changeinnumberofunits | changeinnumberofunits | Text | Was there a change in the number of units |
| LEEDRating_CoreShell | leedrating_coreshell | leedrating_coreshell | Text | Type of LEEDS rating system (LEED means Leadership in Energy and Environmental Design) |
| BldType_AccessoryBuilding | bldtype_accessorybuilding | bldtype_accessorybuilding | Text | Accessory Building |
| BldCnstrType_NC_VALUE | bldcnstrtype_nc_value | bldcnstrtype_nc_value | Text | Type of building construction |
| LEEDRating_ComercialInteriors | leedrating_comercialinteriors | leedrating_comercialinteriors | Text | Type of LEEDS rating system (LEED means Leadership in Energy and Environmental Design) |
| LEEDRating_NewConstruction | leedrating_newconstruction | leedrating_newconstruction | Text | Type of LEEDS rating system (LEED means Leadership in Energy and Environmental Design) |
| WindTurbines | windturbines | windturbines | Number | Number of wind turbines |
| CurrentUse | currentuse | currentuse | Text | Current use of property |
| BldType_TwoFamily | bldtype_twofamily | bldtype_twofamily | Text | Two Family |
| ProposedWorkEnergyEnv | proposedworkenergyenv | proposedworkenergyenv | Checkbox | Work does not access energy envelope |
| BldType_TownHouse | bldtype_townhouse | bldtype_townhouse | Text | Town House |
| MinorInteriorDemo | minorinteriordemo | minorinteriordemo | Checkbox | Extent of demolition - minor |
| cambridge_zipcodes | :@computed_region_rcj3_ccgu | :@computed_region_rcj3_ccgu | Number | |
| LEEDRating_Homes | leedrating_homes | leedrating_homes | Text | Type of LEEDS rating system (LEED means Leadership in Energy and Environmental Design) |
| SolarPanels | solarpanels | solarpanels | Number | Number of solar panels |
| LEEDRatingsCredits | leedratingscredits | leedratingscredits | Text | LEED rating credits (LEED means Leadership in Energy and Environmental Design) |
| LEEDRatingsLevel | leedratingslevel | leedratingslevel | Text | LEED rating level (LEED means Leadership in Energy and Environmental Design) |
| ProposedWorkNewConst | 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. |
| ProposedWorkReconst | proposedworkreconst | proposedworkreconst | Checkbox | Proposed work includes reconstruction of an existing exterior building element (porch, deck, etc.). |
| ExteriorAlteration | exterioralteration | exterioralteration | Text | Is work to be performed on exterior |
| BldCnstrType_WOOD_VALUE | bldcnstrtype_wood_value | bldcnstrtype_wood_value | Text | Type of building construction |
| Class | class | class | Text | Work class |
| ADDRESS | address | address | Point | Address where work is to be performed |
| DesignedLEEDRatingLevel | designedleedratinglevel | designedleedratinglevel | Text | Designed LEED rating level (LEED means Leadership in Energy and Environmental Design) |
| EnerConservFiberglass | enerconservfiberglass | enerconservfiberglass | Checkbox | Fiberglass insulation |
| ChangeInNumberOfUnitsQuantity | changeinnumberofunitsquantity | changeinnumberofunitsquantity | Text | The number of units added or subtracted |
| Census Blocks 2010 | :@computed_region_e4yd_rwk4 | :@computed_region_e4yd_rwk4 | Number | |
| cambridge_cdd_zoning | :@computed_region_swkg_bavi | :@computed_region_swkg_bavi | Number | |
| cambridge_neighborhoods | :@computed_region_rffn_qbt6 | :@computed_region_rffn_qbt6 | Number | |
| Police Response Districts | :@computed_region_v7jj_366k | :@computed_region_v7jj_366k | Number | |
| CavitiesInsulatingMaterials | cavitiesinsulatingmaterials | cavitiesinsulatingmaterials | Checkbox | Type of insulation being used |
| Police Neighborhood Regions | :@computed_region_guic_hr4a | :@computed_region_guic_hr4a | Number | |
| WindTurbinesSize | windturbinessize | windturbinessize | Text | Size of wind turbines |
| SolarPanelsUseforHotWater | solarpanelsuseforhotwater | solarpanelsuseforhotwater | Checkbox | Are solar panels used for hot water |
| CogenerationSystem | cogenerationsystem | cogenerationsystem | Number | Number of cogeneration systems |
| CogenerationSystemSize | cogenerationsystemsize | cogenerationsystemsize | Text | Size of cogeneration systems |
| ProposedHERSRating | proposedhersrating | proposedhersrating | Text | Proposed HERS rating (HERS means Home Energy Rating System) |
| EnvelopeInsulationReq | envelopeinsulationreq | envelopeinsulationreq | Checkbox | Meets or exceeds energy code |
| LEEDRating_Retail | leedrating_retail | leedrating_retail | Text | Type of LEEDS rating system (LEED means Leadership in Energy and Environmental Design) |