cambridgema-gov/building-permits-1-and-2-family-deprecated-52p4-36ct
 
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

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.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
CogenerationSystemcogenerationsystemcogenerationsystemNumberNumber of cogeneration systems
SolarPanelsUseforHotWatersolarpanelsuseforhotwatersolarpanelsuseforhotwaterCheckboxAre solar panels used for hot water
WindTurbinesSizewindturbinessizewindturbinessizeTextSize of wind turbines
Police Neighborhood Regions:@computed_region_guic_hr4a:@computed_region_guic_hr4aNumber
CavitiesInsulatingMaterialscavitiesinsulatingmaterialscavitiesinsulatingmaterialsCheckboxType of insulation being used
ChangeinNumberofUnitschangeinnumberofunitschangeinnumberofunitsTextWas there a change in the number of units
BldType_AccessoryBuildingbldtype_accessorybuildingbldtype_accessorybuildingTextAccessory Building
LEEDRating_Retailleedrating_retailleedrating_retailTextType of LEEDS rating system (LEED means Leadership in Energy and Environmental Design)
EnvelopeInsulationReqenvelopeinsulationreqenvelopeinsulationreqCheckboxMeets or exceeds energy code
ProposedHERSRatingproposedhersratingproposedhersratingTextProposed HERS rating (HERS means Home Energy Rating System)
CogenerationSystemSizecogenerationsystemsizecogenerationsystemsizeTextSize of cogeneration systems
PBCaseNumberpbcasenumberpbcasenumberTextPlanning Board case number
BZACaseNumberbzacasenumberbzacasenumberTextBoard of Zoning Appeal case number
ZoningDistrictzoningdistrictzoningdistrictTextZoning district of property
TotalCostofConstructiontotalcostofconstructiontotalcostofconstructionNumberTotal cost of all work to be completed
HVACCostofConstructionhvaccostofconstructionhvaccostofconstructionNumberCost of HVAC work
GasCostofConstructiongascostofconstructiongascostofconstructionNumberCost of gas work
PlumbingCostofConstructionplumbingcostofconstructionplumbingcostofconstructionNumberCost of plumbing work
ProposedWorkNewConstproposedworknewconstproposedworknewconstCheckboxProposed 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.
ElectricalCostofConstructionelectricalcostofconstructionelectricalcostofconstructionNumberCost of electrical work
BuildingCostofConstructionbuildingcostofconstructionbuildingcostofconstructionNumberCost of building construction
BldType_SingleFamilybldtype_singlefamilybldtype_singlefamilyTextSingle Family
BldCnstrType_MW_VALUEbldcnstrtype_mw_valuebldcnstrtype_mw_valueTextType of building construction
ApplicantapplicantapplicantTextName of applicant
Complete_Datecomplete_datecomplete_dateDatePlan application completion date.
APPLICATIONDATEapplicationdateapplicationdateDateDate of Application
PLANNUMBERplannumberplannumberTextAuto-created plan number
ConfirmedLEEDRatingCreditsconfirmedleedratingcreditsconfirmedleedratingcreditsNumberNumber of Confirmed LEED rating credits (LEED means Leadership in Energy and Environmental Design)
ProposedWorkNotRegproposedworknotregproposedworknotregCheckboxProposed 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.
ProposedUseproposeduseproposeduseTextProposed use of property
ADDRESS (address)address_addressaddress_addressText
PARCELNUMBERparcelnumberparcelnumberTextProperty parcel number
EnerConservOtherenerconservotherenerconservotherTextOther type of insulation
ProposedWorkPrchStrsDeckproposedworkprchstrsdeckproposedworkprchstrsdeckCheckboxProposed 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.
DetailedDescriptionofWorkdetaileddescriptionofworkdetaileddescriptionofworkTextDescription of work to be completed
BldType_TownHousebldtype_townhousebldtype_townhouseTextTown House
SubstantialDemosubstantialdemosubstantialdemoCheckboxExtent of demolition - substantial
ConfirmedLEEDRatingLevelconfirmedleedratinglevelconfirmedleedratinglevelTextConfirmed LEED rating level (LEED means Leadership in Energy and Environmental Design)
UNITORSUITEunitorsuiteunitorsuiteTextUnit/Suite Number
DesignedLEEDRatingCreditsdesignedleedratingcreditsdesignedleedratingcreditsNumberNumber of Designed LEED rating credits (LEED means Leadership in Energy and Environmental Design)
ADDRESS (zip)address_zipaddress_zipText
ExteriorDemoWorkAreaOnlyexteriordemoworkareaonlyexteriordemoworkareaonlyCheckboxExtent of demolition - work area only
StretchCodeExemptstretchcodeexemptstretchcodeexemptCheckboxIs project stretch code exempt
WindTurbinesLocationwindturbineslocationwindturbineslocationTextLocation of wind turbines
EnergyConservBlowninCelluloseenergyconservblownincelluloseenergyconservblownincelluloseCheckboxBlown in insulation
LEEDRatingsLevelleedratingslevelleedratingslevelTextLEED rating level (LEED means Leadership in Energy and Environmental Design)
LEEDRatingsCreditsleedratingscreditsleedratingscreditsTextLEED rating credits (LEED means Leadership in Energy and Environmental Design)
SolarPanelssolarpanelssolarpanelsNumberNumber of solar panels
LEEDRating_Homesleedrating_homesleedrating_homesTextType of LEEDS rating system (LEED means Leadership in Energy and Environmental Design)
cambridge_zipcodes:@computed_region_rcj3_ccgu:@computed_region_rcj3_ccguNumber
MinorInteriorDemominorinteriordemominorinteriordemoCheckboxExtent of demolition - minor
ProposedWorkEnergyEnvproposedworkenergyenvproposedworkenergyenvCheckboxWork does not access energy envelope
BldType_TwoFamilybldtype_twofamilybldtype_twofamilyTextTwo Family
CurrentUsecurrentusecurrentuseTextCurrent use of property
WindTurbineswindturbineswindturbinesNumberNumber of wind turbines
LEEDRating_NewConstructionleedrating_newconstructionleedrating_newconstructionTextType of LEEDS rating system (LEED means Leadership in Energy and Environmental Design)
BldCnstrType_NC_VALUEbldcnstrtype_nc_valuebldcnstrtype_nc_valueTextType of building construction
EnergyConservSprayFoamenergyconservsprayfoamenergyconservsprayfoamCheckboxSpray foam insulation
ADDRESS (state)address_stateaddress_stateText
ADDRESS (city)address_cityaddress_cityText
LEEDRating_Schoolsleedrating_schoolsleedrating_schoolsTextType of LEEDS rating system (LEED means Leadership in Energy and Environmental Design)
ConfirmedHERSRatingconfirmedhersratingconfirmedhersratingTextConfirmed HERS rating (HERS means Home Energy Rating System)
CogenerationSystemLocationcogenerationsystemlocationcogenerationsystemlocationTextLocation of cogeneration systems
TwoYearVacancytwoyearvacancytwoyearvacancyTextWas property vacant 2 years prior to application
ParkingSpacesparkingspacesparkingspacesNumberNumber of parking spaces
LEEDRating_CoreShellleedrating_coreshellleedrating_coreshellTextType of LEEDS rating system (LEED means Leadership in Energy and Environmental Design)
Police Response Districts:@computed_region_v7jj_366k:@computed_region_v7jj_366kNumber
cambridge_neighborhoods:@computed_region_rffn_qbt6:@computed_region_rffn_qbt6Number
cambridge_cdd_zoning:@computed_region_swkg_bavi:@computed_region_swkg_baviNumber
Census Blocks 2010:@computed_region_e4yd_rwk4:@computed_region_e4yd_rwk4Number
ChangeInNumberOfUnitsQuantitychangeinnumberofunitsquantitychangeinnumberofunitsquantityTextThe number of units added or subtracted
EnerConservFiberglassenerconservfiberglassenerconservfiberglassCheckboxFiberglass insulation
DesignedLEEDRatingLeveldesignedleedratingleveldesignedleedratinglevelTextDesigned LEED rating level (LEED means Leadership in Energy and Environmental Design)
ADDRESSaddressaddressPointAddress where work is to be performed
ClassclassclassTextWork class
BldCnstrType_WOOD_VALUEbldcnstrtype_wood_valuebldcnstrtype_wood_valueTextType of building construction
ExteriorAlterationexterioralterationexterioralterationTextIs work to be performed on exterior
ProposedWorkReconstproposedworkreconstproposedworkreconstCheckboxProposed work includes reconstruction of an existing exterior building element (porch, deck, etc.).
DescriptionofDemolitiondescriptionofdemolitiondescriptionofdemolitionTextDescription of demolition
SubstDemoStructuralElementssubstdemostructuralelementssubstdemostructuralelementsCheckboxExtent of demolition - structural elements
LEEDRating_ComercialInteriorsleedrating_comercialinteriorsleedrating_comercialinteriorsTextType of LEEDS rating system (LEED means Leadership in Energy and Environmental Design)
EnergyConservUValueofWindowsenergyconservuvalueofwindowsenergyconservuvalueofwindowsTextU-Value of windows
Upstream Metadata