The development_event_history table

The development event history records the development events that occurred prior to the base year. It is used by the developer project transition model, and for ``unrolling'' the baseyear to create versions of the gridcell data for prior years.

This table uses a subset of the schema used for development_events_exogenous. It can be considered an extension back in time of the development_events_exogenous table, though with additional constraints, specified below.

Column Name	Data Type	Description
grid_id	integer	Grid cell where the event takes place
scheduled_year	short	Year where the event will be implemented
starting_development_type_id	integer	(optional) This will be the value of the development_type for this gridcell after ``unrolling'' this development event.
residential_units	integer
commercial_sqft	integer
industrial_sqft	integer
governmental_sqft	integer
residential_improvement_value	integer	See description, above
commercial_improvement_value	integer	See description, above
industrial_improvement_value	integer	See description, above
governmental_improvement_value	integer	See description, above

• grid_id must be a valid id in the gridcells table or zero
• development_type_id must be a valid index into the development_types table or zero
• scheduled_year must be between absolute_min_year and absolute_max_year
• residential_units must be greater than or equal to zero and <= absolute_max_cell_residential_units
• commercial_sqft must be greater than or equal to zero and <= absolute_max_cell_sqft
• industrial_sqft must be greater than or equal to zero and <= absolute_max_cell_sqft
• governmental_sqft must be greater than or equal to zero and <= absolute_max_cell_sqft
• residential_improvement_value must be greater than or equal to zero and <= absolute_max_cell_dollars
• commercial_improvement_value must be greater than or equal to zeroand <= absolute_max_cell_dollars
• industrial_improvement_value must be greater than or equal to zero and <= absolute_max_cell_dollars
• governmental_improvement_value must be greater than or equal to zero and <= absolute_max_cell_dollars
• starting_development_type_id is ignored on input, and updated (to be the ending development type for that gridcell in that year) as the developer model estimation data writer runs. It must not be a member of the vacant_undevelopable group.

In addition, the following will produce warnings:

• Warn if scheduled_year is greater than or equal to the base year. Such entries will not be used.