cambridgema-gov/cambridge-property-database-fy2016fy2022-eey2-rv59
 
Readme
Updated 2 months ago
Indexed 7 hours ago

Cambridge Property Database FY2016-FY2022

Extract of Cambridge Assessing Department on-line property database file for FY2016, FY2017, FY2018, FY2019, FY2020, FY2021, and FY2022. Contains residential, condo, commercial and exempt data. Please see attached Cambridge Property Data Metadata for field descriptions. Please refer to Cambridge's property database website for official assessment data: https://www.cambridgema.gov/propertydatabase

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Systems_CentralAirsystems_centralairsystems_centralairText
Parking_Garageparking_garageparking_garageNumber
UnfinishedBasementGrossunfinishedbasementgrossunfinishedbasementgrossNumber
TaxDistricttaxdistricttaxdistrictText
YearOfAssessmentyearofassessmentyearofassessmentNumber
LandArealandarealandareaNumbersquare feet
PropertyClasspropertyclasspropertyclassText
StateClassCodestateclasscodestateclasscodeNumberUse as defined by the MA Dept of Revenue
LatitudelatitudelatitudeNumber
AddressaddressaddressText
BldgNumbldgnumbldgnumNumber
GISIDgisidgisidTextUnique ID to link property on map
ResidentialExemptionresidentialexemptionresidentialexemptionTextOwner occupied tax exemption
UnitunitunitText
Condition_OverallConditioncondition_overallconditioncondition_overallconditionText
AssessedValueassessedvalueassessedvalueNumber
SaleDatesaledatesaledateCalendar dateDate of last deed transaction
PreviousAssessedValuepreviousassessedvaluepreviousassessedvalueNumber
Owner_Addressowner_addressowner_addressText
Owner_Cityowner_cityowner_cityText
Owner_Stateowner_stateowner_stateText
Owner_Zipowner_zipowner_zipText
Exterior_Styleexterior_styleexterior_styleText
Exterior_occupancyexterior_occupancyexterior_occupancyText
Exterior_NumStoriesexterior_numstoriesexterior_numstoriesNumber
Exterior_WallTypeexterior_walltypeexterior_walltypeText
Exterior_WallHeightexterior_wallheightexterior_wallheightNumber
Exterior_RoofTypeexterior_rooftypeexterior_rooftypeText
Exterior_RoofMaterialexterior_roofmaterialexterior_roofmaterialText
Exterior_FloorLocationexterior_floorlocationexterior_floorlocationNumber
PropertyTaxAmountpropertytaxamountpropertytaxamountNumberProperty task for the fiscal year
Map/Lotmap_lotmap_lotTextUnique assessor's ID
ZoningzoningzoningTextUnofficial zoning per City of Cambridge
LongitudelongitudelongitudeNumber
PIDpidpidNumber
Systems_Plumbingsystems_plumbingsystems_plumbingText
Interior_Layoutinterior_layoutinterior_layoutText
Exterior_Viewexterior_viewexterior_viewText
Interior_LivingAreainterior_livingareainterior_livingareaNumber
Interior_NumUnitsinterior_numunitsinterior_numunitsNumber
Interior_TotalRoomsinterior_totalroomsinterior_totalroomsNumber
Interior_Bedroomsinterior_bedroomsinterior_bedroomsNumber
Interior_Kitchensinterior_kitchensinterior_kitchensText
Interior_FullBathsinterior_fullbathsinterior_fullbathsNumber
Systems_HeatTypesystems_heattypesystems_heattypeText
Parking_Openparking_openparking_openNumber
Interior_LaundryInUnitinterior_laundryinunitinterior_laundryinunitText
Condition_OverallGradecondition_overallgradecondition_overallgradeText
FinishedBasementGrossfinishedbasementgrossfinishedbasementgrossNumber
Parking_Coveredparking_coveredparking_coveredNumber
Condition_InteriorConditioncondition_interiorconditioncondition_interiorconditionText
Systems_HeatFuelsystems_heatfuelsystems_heatfuelText
Interior_Flooringinterior_flooringinterior_flooringText
Interior_Fireplacesinterior_fireplacesinterior_fireplacesNumber
Owner_Address2owner_address2owner_address2Text
Owner_CoOwnerNameowner_coownernameowner_coownernameText
Condition_YearBuiltcondition_yearbuiltcondition_yearbuiltNumber
Owner_Nameowner_nameowner_nameText
Book/Pagebook_pagebook_pageTextBook and page of last deed recorded at registry of deeds
SalePricesalepricesalepriceNumber
LandValuelandvaluelandvalueNumber
Interior_HalfBathsinterior_halfbathsinterior_halfbathsNumber
BuildingValuebuildingvaluebuildingvalueNumber
Upstream Metadata