Development Event History

The development_event_history table provides historical data, usually over a period of 10 years, of observed development events. For the parcel version of the model system, these are individual development projects.

Column Name Data Type Required Description
parcel_id Integer Y Unique id for the parcel
building_type_id Integer Y Unique id for the building type
scheduled_year Integer Y Year in which the development event occurs
residential_units Integer Y The number of residential units in this development event
non_residential_sqft Integer Y The number of non-residential sqft in this development event
change_type String(1) Y Values are A (add), D (demolish), or R (replace)

-- PaulWaddell - 09 Dec 2009

Topic revision: r2 - 17 Apr 2010 - 23:53:10 - PaulWaddell
 
This site is powered by FoswikiCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding Foswiki? Send feedback