Buildings

The buildings table in the parcel version of the model system is an individual building located on a parcel. There can be multiple buildings on a parcel (a many to one relationship). Buildings that are mixed use, such as retail on the first floor and apartments above, can be represented as two separate buildings, on the same parcel. The land area would generally be assigned by the user to each component as a pro-rated amount.

Column Name	Data Type	Required	Description
building_id	Integer	Y	Unique id of building (one per zone and building type)
building_quality_id	Integer	Y	Building quality that can be used in development templates
building_type_id	Integer	Y	Unique id of the building type of this building
improvement_value	Integer	Y	Value in dollars of buildings on parcel
land_area	Integer	Y	Land area in sqft used by the building
non_residential_sqft	Integer	Y	Total non-residential sqft in building
parcel_id	Integer	Y	Unique id of the parcel in which this building is located
residential_units	Integer	Y	Total residential units in building
sqft_per_unit	Integer	Y	Average square feet per residential unit in building
stories	Integer	N	Number of stories in the building
tax_exempt	Integer	N	1 if tax-exempt building, 0 otherwise
year_built	Integer	Y	Average year built of this aggregated building

-- PaulWaddell - 09 Dec 2009

---