You are here: Documentation/Zone Web>DevelopmentEventHistory (04 Feb 2010)

Development Event History

The development_event_history table provides historical data, usually over a period of 10 years, of observed development events. For the zone version of the model system, these are preferably individual development projects, but they can be aggregated to a single event per year, zone and building type. Note that aggregation of the observed historical data reduces the number of observations available to estimate the development project location choice models, however.

Column Name Data Type Required Description
zone_id Integer Y Unique id for the zone
building_type_id Integer Y Unique id for the building type
scheduled_year Integer N 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) N Values are A (add), D (demolish), or R (replace)

Changed scheduled_year and change_type to be optional fields. I am able to run the entire model system sans these fields. This leads me to believe that they are optional fields.

-- JesseAyers - 04 Feb 2010

 

-- PaulWaddell - 08 Dec 2009

Edit | Attach | Print version | History: r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r2 - 04 Feb 2010 - 14:35:47 - JesseAyers
 
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