Next: The development_type_group_definitions table
Up: Database Tables about Development
Previous: The development_types table
Index
The development_type_groups table
See above. Each row defines one development type group, but not the group's
membership - the memberships are defined in the development_type_group_definitions table.
| Column Name |
Data Type |
Description |
| group_id |
integer |
Unique identifier for this row. |
| name |
varchar |
Unique name of the development type group. |
| non_overlapping_groups |
varchar |
Name of the non-overlapping-group or
empty for no non-overlapping-group. |
- group_id must be unique, and greater than zero.
- name must be unique. The required development type groups must be lower
case with underscores between words e.g. high_density_residential. We recommend
that all names follow this style.
- names and non_overlapping_groups names must not contain spaces.
- names and non_overlapping_groups names must be lower-case.
- Development types must not overlap across the groups in the same
non_overlapping_groups.
The set of required development type groups and non-overlapping-groups is
determined by the set of variables used by the models being estimated or
simulated. Thus, there is no way to a-priori specify which development type
groups will be needed for your application of UrbanSim. There are two exceptions:
First, the model Events Coordinator is internally using groups 'residential', 'mixed_use', 'commercial',
'industrial', and 'governmental'. Second, the Land Price Model (8.4.2) is using by default a filter
that requires a group called 'developable'. Therefore, if you do not change this settings, make sure your
table contain these entries.
UrbanSim requires some non-overlapping-groups and requires those to have
certain groups within them, though they may have additional groups as well.
The example above would involve these two tables: (note: R1=1, R2=2, R3=3,
M4=4, M5=5, C4=9, etc)
| |development_type_groups| |
| group_id |
name |
non_overlapping_groups |
| 50 |
residential |
dynamic_land_use_variables |
| 51 |
mixed_user |
dynamic_land_use_variables |
| 52 |
commercial |
dynamic_land_use_variables |
| 100 |
high_density_residential |
|
| 101 |
noisy_commercial |
|
|
| |
| |development_type_group_definitions| |
| development_type_id |
group_id |
| 1 |
50 |
| 2 |
50 |
| 3 |
50 |
| 4 |
51 |
| 5 |
51 |
| 6 |
52 |
| ... |
|
| 3 |
100 |
| 5 |
100 |
| 9 |
101 |
| 5 |
101 |
|
Note that:
- R3 belongs both to groups ``residential'' and
``high_density_residential''.
- R1 belongs to group ``residential''.
- M5 belongs to groups ``mixed_use'', ``high_density_residential'', and
``noisy_commericial''.
Next: The development_type_group_definitions table
Up: Database Tables about Development
Previous: The development_types table
Index
info (at) urbansim.org