Model Run Growth and Change
1 Overview
1.0.1 Households
Community designation | Census 2010-2020 | BAU | UrbanSim Draft Preliminary Forecasts (run_203: prelim run + prelim developments & updated housing capacities) | UrbanSim Draft Preliminary Forecasts (run_211: new travel skims, updated base data, updated housing capacities, updated housing mix finalized developments,) |
---|---|---|---|---|
Agricultural | 0.25% (302 hh) | 1.39% (4,580 hh) | 2.16% (6,999 hh) | 0.8% (2,584 hh) |
Diversified Rural | 0.78% (945 hh) | 3.42% (11,254 hh) | 3.05% (9,883 hh) | 1.92% (6,225 hh) |
Emerging Suburban Edge | 15.04% (18,318 hh) | 11.1% (36,466 hh) | 15.58% (50,553 hh) | 18.31% (59,407 hh) |
Non-Council Area | 0.27% (326 hh) | 0.13% (439 hh) | 0.27% (864 hh) | 0.33% (1,086 hh) |
Rural Center | 1.92% (2,334 hh) | 2.38% (7,819 hh) | 2.77% (8,991 hh) | 3.31% (10,732 hh) |
Rural Residential | 0.81% (991 hh) | 4.06% (13,330 hh) | 3.03% (9,822 hh) | 1.78% (5,784 hh) |
Suburban | 18.23% (22,197 hh) | 21.14% (69,469 hh) | 26.09% (84,642 hh) | 27.05% (87,746 hh) |
Suburban Edge | 21.71% (26,432 hh) | 16.88% (55,477 hh) | 16.28% (52,819 hh) | 15.71% (50,975 hh) |
Urban | 8.46% (10,297 hh) | 12.48% (41,020 hh) | 5.39% (17,472 hh) | 5.32% (17,272 hh) |
Urban Center | 32.55% (39,635 hh) | 27.02% (88,788 hh) | 25.39% (82,371 hh) | 25.46% (82,605 hh) |
Total | 100% (121,777 hh) | 100% (328,642 hh) | 100% (324,416 hh) | 100% (324,416 hh) |
1.0.2 Employment
Community designation | DEED 2010-2019 | BAU | UrbanSim Draft Preliminary Forecasts (run_203: prelim run + prelim developments & updated housing capacities) | UrbanSim Draft Preliminary Forecasts (run_211: new travel skims, updated base data, updated housing capacities, updated housing mix finalized developments,) | Census 2010-2020 |
---|---|---|---|---|---|
Agricultural | 0.48% (1,136 jobs) | 0.46% (2,348 jobs) | 0.59% (3,054 jobs) | ||
Diversified Rural | 2.03% (4,817 jobs) | 1.81% (9,309 jobs) | 1.74% (8,963 jobs) | ||
Emerging Suburban Edge | 9.86% (23,348 jobs) | 14.19% (72,975 jobs) | 14.22% (73,401 jobs) | ||
Non-Council Area | 0.21% (493 jobs) | 0.15% (762 jobs) | 0.31% (1,600 jobs) | ||
Rural Center | 0.45% (1,059 jobs) | 1.85% (9,502 jobs) | 1.95% (10,086 jobs) | ||
Rural Residential | 0.79% (1,877 jobs) | 1.48% (7,637 jobs) | 1.34% (6,933 jobs) | ||
Suburban | 25.91% (61,339 jobs) | 27.6% (141,977 jobs) | 27.19% (140,332 jobs) | ||
Suburban Edge | 19.48% (46,115 jobs) | 16.62% (85,504 jobs) | 16.89% (87,174 jobs) | ||
Urban | 8.99% (21,283 jobs) | 11.77% (60,523 jobs) | 10.29% (53,099 jobs) | ||
Urban Center | 31.79% (75,270 jobs) | 24.07% (123,792 jobs) | 25.46% (131,385 jobs) | ||
Total | 100% (328,642 jobs) | 100% (324,416 jobs) | 100% (324,416 jobs) | 100% (121,777 jobs) |
1.0.3 Land use
NOTE: land use calculations are NOT a core output of the land use model. Rather, they are roughly estimated using back-of-the-envelope calculations to translate changes in people and jobs into changes in land use by leveraging: 1) minimal on-the-ground data about non residential floor area ratios and density of new residential developments, and 2) a simplistic land consumption framework which primarily consumes agricultural and developed land uses in equal proportions.
2 Geographic segmentation of results
UrbanSim produces results at the census block level. It is preferable to “roll-up” blocks into larger geographic summaries (based on best practices and the results from our model validation phase). We have produced a set of figures that looks at a single variable (total population) across various ways of “rolling up” blocks. These examples are not an exhaustive list of ways that blocks can be rolled up. This process can be repeated for any output variable (like total jobs or the number of multifamily housing units for instance).
Rather than show example results below, instead we have shown maps indicating the geographies in which blocks results can be aggregated up to. In all cases, if blocks fell into multiple geographies, the intersecting geography with the largest overlap was used as the block assignment.
We provide aggregated results to these different geographic levels as different tabs within the .xlsx file.
2.1 MUSA
Source: Metropolitan Urban Service Areas (MUSA) Composite, MN Geospatial Commons.
2.1.1 MUSA Tables
2.2 City, township, unorganized territory (CTU)
Source: Counties and Cities & Townships, Twin Cities Metropolitan Area, MN Geospatial Commons.
2.2.1 CTU Tables
2.3 Community designations
Note: The Optimizing Regional Planning process has convened a staff team to recommend modified community designations for the 2050 planning cycle. A preliminary proposal will be available later in 2022.
Source: ThriveMSP 2040 Community Designations, MN Geospatial Commons.
Model difference by year and geography
2.3.1 Community Designation Tables
2.4 Transportation Analysis Zones (TAZs)
2.4.1 TAZ Tables
2.4.2 Households
3 Apendix: Variable output names
This data dictionary defines the column names in the excel sheet output files.
Variable | Definition | Broad category |
---|---|---|
model | name of the model | model information |
year | model year | model information |
CTU_NAME | city, township, or unorganizied territory name | geography information |
COMDESNAME | community designation name | geography information |
dws_vul_c | drinking water supply vulnerability | geography information |
Metershed | sewer metershed | geography information |
MUSA_2040 | metropolitan urban service area status | geography information |
park_search | park and trail search areas | geography information |
parkimp_agency | park and trail implementing agency | geography information |
TAZ | transportation analysis zone | geography information |
tract_id | 2010 era census block geographic identifier | geography information |
TransitMarketArea | transit market area | geography information |
Watershed_ | Watershed identity | geography information |
watershed_soil | Watershed identity (_) dominant soil type | geography information |
accessibility_jobs20minutes_sov | jobs accessible within 20 minutes, by car | accessibility |
area_sqmeters_land | square meters of land area | geography information |
hh_0k_30k | households with income 30k or lower | households |
hh_30k_60k | households with income 30-60k | households |
hh_60k_100k | households with income 60-100k | households |
hh_100k_150k | households with income 100-150k | households |
hh_150k_200k | households with income 150-200k | households |
hh_200k_max | households with income 200k or higher | households |
hh_ami_0_50percent | households with income 0-50% of area median income | households |
hh_ami_51_80percent | households with income 51-80% of area median income | households |
hh_ami_81_120percent | households with income 81-120% of area median income | households |
hh_ami_121_maxpercent | households with income>120% of area median income | households |
hh_income_mean | mean household income | households |
hh_nocars | households without a vehicle | households |
hh_race_bipoc | households with a BIPOC head of householder | households |
hh_race_white | households with a white head of householder | households |
hh_size_1 | one person households | households |
hh_size_2 | two person households | households |
hh_size_3 | three person households | households |
hh_size_4plus | four or more person households | households |
hh_size_avg | average household size | households |
hh_tenure_owners | households who own their residence | households |
hh_tenure_renters | households who rent their residence | households |
hh_total | total number of households | households |
hh_type_lte50ami_gte3size | working age households, income 0-50% ami, size 3+ persons | households |
hh_type_lte50ami_lte2size | working age households, income 0-50% ami, size 1-2 persons | households |
hh_type_lte80ami_gte3size | working age households, income 51-80% ami, size 3+ persons | households |
hh_type_lte80ami_lte2size | working age households, income 51-80% ami, size 1-2 persons | households |
hh_type_lte120ami_gte3size | working age households, income 81-120% ami, size 3+ persons | households |
hh_type_lte120ami_lte2size | working age households, income 81-120% ami, size 1-2 persons | households |
hh_type_gt120ami_gte3size | working age households, income >120% ami, size 3+ persons | households |
hh_type_gt120ami_lte2size | working age households, income >120% ami, size 1-2 persons | households |
hh_type_retired | retired age households (age 65+), any ami, any size | households |
jobs_sector_const_waste | jobs in Construction, Waste (NAICS 23, 56) | jobs |
jobs_sector_edu | jobs in Education (NAICS 61) | jobs |
jobs_sector_ent_serv | jobs in Entertainment, Other Serv. (NAICS 71, 81) | jobs |
jobs_sector_gvt | jobs in Government (NAICS 92) | jobs |
jobs_sector_health | jobs in Health (NAICS 62) | jobs |
jobs_sector_hosp | jobs in Hospitality (NAICS 72) | jobs |
jobs_sector_prof_fin | jobs in Professional, Finance, HQs (NAICS 51-55) | jobs |
jobs_sector_retail | jobs in Retail (NAICS 44-45) | jobs |
jobs_sector_util_mfg | jobs in Utilities and Mfg (NAICS 21-22, 31-33) | jobs |
jobs_sector_wareh_trans | jobs in Warehouse, Transport (NAICS 42, 48-49) | jobs |
jobs_total | total jobs | jobs |
jobspaces_educational | job spaces for educational (school, college) workers | non-residential |
jobspaces_industrial | job spaces for industrial workers | non-residential |
jobspaces_institutional | job spaces for institutional workers | non-residential |
jobspaces_office | job spaces for commericial and office workers | non-residential |
jobspaces_total | total job spaces | non-residential |
lu_ag | agricultural land use, acres (glu 100) | land use |
lu_airport | airport land use, acres (glu 203) | land use |
lu_extractive | extractive land use, acres (gravel pits and quarries, glu 153) | land use |
lu_gc | golf course land use, acres (glu 173) | land use |
lu_highway | highway land use, acres (glu 201) | land use |
lu_industrial | industrial land use, acres (glu 142) | land use |
lu_institutional | institutional land use, acres (glu 160) | land use |
lu_mf | multifamily land use, acres (glu 115) | land use |
lu_mfdhousing | manufactured housing park land use, acres (glu 116) | land use |
lu_mixed_commercial | mixed use commerical and other land use, acres (no residential, no industrial) (glu 143) | land use |
lu_mixed_industrial | mixed use which contains any industrial, but no residential, acres (glu 142) | land use |
lu_mixed_residential | mixed use which contains any residential, acres (glu 141) | land use |
lu_officecom | commercial and office land use, acres (glu 120, 130) | land use |
lu_park | park land use, acres (glu 170) | land use |
lu_railroad | railroad land use, acres (glu 202) | land use |
lu_sfa | single family attached land use, acres (glu 114) | land use |
lu_sfd | single family detached land use, acres (glue 111, 112, 113) | land use |
lu_undev | undeveloped land use, acres (glu 210) | land use |
lu_water | open water land use, acres (glu 220) | land use |
persons_age_0_17 | number of persons age 0-17 | persons |
persons_age_18_20 | number of persons age 18-20 | persons |
persons_age_21_29 | number of persons age 21-29 | persons |
persons_age_30_39 | number of persons age 30-39 | persons |
persons_age_40_49 | number of persons age 40-49 | persons |
persons_age_50_59 | number of persons age 50-59 | persons |
persons_age_60_64 | number of persons age 60-64 | persons |
persons_age_65_69 | number of persons age 65-69 | persons |
persons_age_70_79 | number of persons age 70-79 | persons |
persons_age_80_max | number of persons age 80 or older | persons |
persons_groupquarters | number of persons in group quarters | persons |
persons_households | number of persons in households | persons |
persons_total | total population | persons |
units_manufactured | manufactured home residential units | residential |
units_price_attached | average value (price) for single family attached units (2010 dollars) | residential |
units_price_detached | average value (price) for single family detached units (2010 dollars) | residential |
units_price_largelot | average value (price) for large lot (>1acre) units (2010 dollars) | residential |
units_price_multifam | average value (price) for multifamily units (2010 dollars) | residential |
units_rent_attached | average rent for single family attached units (2010 dollars) | residential |
units_rent_detached | average rent for single family detached units (2010 dollars) | residential |
units_rent_multifam | average rent for multifamily units (2010 dollars) | residential |
units_total_residential | total residential units | residential |
units_type_largelot | single family large lot (>1acre) residential units | residential |
units_type_multifam | multifamily residential units | residential |
units_type_singlefam_attached | single family attached residential units | residential |
units_type_singlefam_detached | single family detached residential units | residential |