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