Home

ENVISION TOMORROW PLUS (ET+) USER MANUAL

1. 17 Ir in iml nn 67 Page ENVISION TOMORROW PLUS USER MANUAL As we already know the ET Scenario Builder has four input tabs Project Info Building Inputs Dev Type Streets and Dev Type Building Mix tabs When users start inputting data in the Scenario Builder they first enter data in the Project Info tab The Project Info tab consists of several tables that allow users to set up their scenario planning assumptions in terms of physical socioeconomic and environmental aspects of the target site At the top of the tab users first define the Metropolitan Statistical Area MSA to which the target site belongs The tables coming after the project location table allows users to establish assumptions of their scenarios in term of the following aspects Tables Categories Household Population Assumptions Setting up avg unit size hh size gross sq ft per resident max hh size and vacancy rate f Existing avg household incomes Setting up average household incomes by housing types i _ Existing avg monthly housing costs Monthly housing costs for rental or mortgaging housing types Wage Estimator Envision Wage _ Annu
2. Behan to Emit T8 m meem Physical output data are produced zb TOS equa ten based on data in the physical input al Burm bel tab Gap Fnanong Options Physical Outputs Gap Fancng Defnitions Resdentilc Pimi Fe ENVISION TOMORROW PLUS USER MANUAL The Basic Financial Tab a top figure gives users the flexibility to make assumptions for costs and revenues for your prototype building Users can test the impacts of financial changes to the financial feasibility of developing buildings In the Advanced Financial Tab a bottom figure users can make additional more detailed assumptions about the financial characteristics of your development These range from building efficiency to permit fees and demolition cost to loan terms These two tabs contain information about cost of constructing and operating prototype buildings E 1 Site Layout P Housing Linils Hot Fraarma 43 itd wom re 3 NEU Jets 8 4 _Houmng HotelRoomDenegy Perce 430 VEN 5 Job Denashy Per Acre B prieg aun rant im bedding 5 FR Uris ed e Nii space Prototype 7 Met RenianleSellatie Square Feel u Builder Dashboard Cagh on Cash Aller Tear J iR on Projeci Cos Linkeveraged Retum Project Rate of Ratun Basic Financial
3. Select Avg Income of Workers field wl Legend Classification Job Workers Balance Income Balance Now search average income of residents and workers fields in the attribute table Add these fields in the tool 136 Page 137 Page Te fe ek mmer J al aa 00000 0 Fe Ma AREI amica d Ls artiraen e id gee rg dei Beim e RT Bon bee Beem n 7 CENE T 5 TEEEM T Tm Re 2S o a her Rp domu oe et eee H Ii H M i at r t HI i a eaj w En i 8 nw LI 1 i Ig EET i E WM H a Vaud Hi 8 mun LI MH AMI aa Ig EL V BTE E 5 X2 EI EL BEN L TI E g E T Wi EE Rs ih LI ta A Kn cra iT H 3 F NI MED iH quet Li Wi tangi L 11 Wi R 1 E i C E ii E i i iy had ak 2 ae E J i om i Eje eem mmn dues m nnn ENVISION TOMORROW PLUS USER MANUAL Defma Buffer Dwtanca 3 Select Employed Resgents heid Reqiorken Saed Avg Income of Residents faid Salat Avg Income of Workers field Now every input field is entered in the window Make sure if you click the J ob Workers Balance option and click Run Define Buffer Distance 3 Select Employed Residents field Select workers field Select Avg Income of Residents fed Select
4. Showing the attribute table for the scenario layer GIS shapefile ENVISION TOMORROW PLUS USER MANUAL In the ET scenario planning collected datasets are used to create an attribute table for a scenario layer GIS shapefile and fill in input data blanks of ET spreadsheets In particular creating this attribute table in a scenario layer GIS shapefile is very important in the ET scenario planning because it contains existing land use data produced from external raw data resources and is used to estimate attributes of each development type based on painted areas When users get parcel level data from various data resources the attribute table of a scenario layer GIS shapefile will include the following GIS attribute fields Attribute Fields Function Comments OBJECTID Shape Shape_Length Shape_Area Res_Units Res_SF Land_Val Physical and market value Imp_Val properties of each parcel Tot_Val Yr Bit LU CAT or PT DESCRIPTION etc Contains basic information ArcGIS default fields about types length and areas included in a GIS of each GIS polygons shapefile Imported from Assessor s data Existing land use description of each parcel You can check these attribute fields by using the ArcGIS function Open Attribute Table or the ArcCatalog Etl ENVISION TOMORROW PLUS USER MANUAL Except for attribute fields automatically generated by ArcGIS OBJECTID Shape Length etc attribute fi
5. Selecting a Bucares data layer F cichrun m Teszhireg C aisoglaticn Wie ucprummi Pula imu ari nll err MUS gms 81 Page ENVISION TOMORROW PLUS USER MANUAL Constructing a New File Geodatabase by Using the ET Project Setup function As another main part of ET the Envision Project Setup tool plays a role in defining many preliminary options before producing scenarios By following steps in the tool users can determine various constraints or assumptions that their scenarios should consider Five steps of the Envision Project Setup tool are as follows e Step 1 Project Settings e Step 2 Constraints e Step 3 Land Use e Step 4 Field Map e Step 5 Subareas Preliminary Step Adding GIS shapefiles Before operating the ET Project Setup function users should add a GIS shapefile that will be used as scenario layers This is because the ET Project Setup function itself cannot produce a file geodatabase without pre loading a GIS shapefile Therefore it is very important to add these GIS shapefiles in ArcGIS To add GIS shapefiles we should use the ArcGIS function Add Data Click the icon at the top of the ArcGIS screen to add data oca ariu C C REEEBR kR amp ES IsssrE EIEEE n n 0 m IE LESE Rua b aa E F cm RESF rnm iii ma Click 82 Page ENVISION TOMORROW PLUS USER MANUAL Another window pops up at the center of the screen To select GIS
6. areara ekini BI Cameron att 1 Bl ahai Ej EB te cut ct 382 Selected Domania 1 ACTES Srpk footy Genera Er PUNK i BEU ALT Er ay imi o c S u e olo ceno nF iray Fraas Tha Nee dang Only the calculation output EMP field is added to the attribute table in the scenario layer ENVISION TOMORROW PLUS USER MANUAL The attribute field manager also provides a function that allows users to select reference field groupings based on land use categories easily At the bottom of the Attribute Field Manager window you can find the Quick Reference Field Groupings section When you click the checkbox fields directly related to land use categories are automatically selected to produce output fields and add them to the attribute table of the scenario ee mE eres Ae Peel piri eee Be Tuo Pere rre Tr eh Ce ee Se Bal Lai login bey Demy m 1 Varden lal rgi Meet Ileni ee scr Diei ET s r F Disie LAN dy De PD Limi i CR EME EP DE OM Mea MET CHE NMDD PUN ETL E imm dorm aeui rue uumwnud dies ae dd Check the Track box CER EERE TTRI le rm VE LFCLEDILIDM Output fields are integrated into the scenario attribute table To erase the output field in the scenario attribute table choose the column you want to erase first and right click the column name In the menu select the Delete Field menu an
7. 4 Stap 3 Land Use Step 4 Field Map Clas Feature Layer Pi i n Parce ayer ld levelopad Vacant je Attnbute Freld Select the Land Use Attribute Field ENVISION TOMORROW PLUS USER MANUAL The following screenshot shows up In this example you cannot select the attribute field because the original scenario layer shapefile does not include the land use description field However when you have a land use description field within the shapefile you will see a list of land use descriptions shown in the right figure and choose development status If you set up TRUE in the Vacant column ET assumes that land areas designated are considered as vacant land If you set up TRUE in the Developed column ET assumes that all land areas designated as this category are considered as developed land If you do not put any TRUE mark in both this means that land areas designated as this category are redeveloped in scenarios a INVISION PRONCT SETUP Sieg T Proje Songs iep Constants Step 3 LandUse Siep 4 Field Map np l A eaa Sepa Consraenr Step 5 Subs Shen E Ruf das Lr kh md ut bag rm l mum emm Mit Land Use Feature Layer Ingots Cet A uin a urt Pes erige o oe rum Check the Development Potential for each Land Ure Land Lise Desorption EX LU GS NAME Sawai Qu Qo Check he einen Porentu fes
8. Listing up land use description from the original shape Matching with the EX LU classification scheme Sip J acd Ld den d Fao Man Selecting development status Developed Va cant Redevelo file ped EST Previews Maxt EP When you finish matching land use descriptions with the ET EX LU classification names click Next at the bottom of the window to go to the step 4 92 Page Check the Map box to match input parcel field name with the ET existing conditions field uJ ENVISION PROJECT SETUP E raject Settings Step 2 Const ainis Step 3 Land Use Step 4 Field Map ENVISION TOMORROW PLUS USER MANUAL Step 4 Field Map The step 4 allows users to select GIS attribute fields of the original scenario layer shapefile that explain existing conditions and match them with the ET Existing Conditions GIS field name This step is usually used when data included in the attribute table of the original scenario layer GIS shapefile need to be converted into the ET existing condition classification scheme which is numeric land use categories mentioned in the previous step For example as shown in the figure below if you need to match the input parcel field name Res Units with the ET existing conditions matching field you can click the Map checkbox and find the appropriate ET existing conditions fields on t
9. First before installing the program Installing the Program 1 Download the ET software a zip file and extract files You can download the latest version of the ET software from the Frego Associates website http www frego com services envision tomorrow download The filename may be different according to the version but it does not have any problems to extract and install the program ENVISION TOMORROW PLUS USER MANUAL Mame Date modified Type P EmanenGlSApn lasai 1012500012 10 rk FRETE 2 QAAE AUE Campresced npp Open Fi Open in new window Extract AIL Right 7 Zip Click di Scan with Microsoft Security Essentials Open with Rectore previous Versions Send to Cut Copy Create shortcut Delete Rename Properties If your computer has other file compression program like a 7Zip the process for unzipping the ET software may be different from the screen shot shown above It is up to you to decide which unzipping program you want to use Anyway unzip the ET setup software in the folder where you want to locate in your computer 2 When extracting the file you will have two extracted files Among these two files double click the file setup exe Name Date madihied 18 EnvisionGISApp 10 25 2012 9 52 AM Windows Installe 43 Setup 10 25 2012 amp 57 AM Application Double Click 50 Page 51 Page ENVISION TOMORROW PLUS USER MANUAL 3 The following windo
10. Summary New Summary Total tabs Dev Type Attribute tab Prototype Builder ROI Physical Inputs Outputs FIT Standalone App Tool Numerical data inputs amp outputs Indicators The Summary tabs in ET Standalone tools Household HH Travel Mixed use Development 7 MXD Travel All tabs in FIT Standalone App Tool Numerical data dub a E Ms Prototype Builder ROI p i P Basic Advanced Equations Financial tabs Indicators Gap Financing Options tab Numeric data Inputs amp outputs Equations Prototype Builder ROI ROI templates for each building types FIT Standalone App Tool Summary Output tab Time tab Numerical data inputs Equations Indicators Coefficients ET Scenario Spreadsheet Project Info tab Building Inputs tab Summary New Summary Total tabs Numerical data inputs amp ouputs Coefficients Equations Indicators Household Travel App MXD Travel App Standalone tools Summary tab Traffic Safety Elasticities tab County Crash Rates Tabs inputs amp outputs Indicators Estimating the number of housing units and jobs created within a buffer distance Estimating the peak parking demand for a proposed development area with a mix of land uses MXD development Numerical data Inputs amp outputs Equations ET analytic tool ET Scenario Spreadsheet The Summary New tab The Summary Total
11. Redevelopment Candidate Method Depreciation Select Parcel Layer Mesdowitrock Pecas ACTIVE Select Effective Year Bust field eati 1 Select Improvement or Buddeng Value field Bdg Vsle 1 Select Land Value field ERS Select Square Footage field Enter Number of Class Breaks Enter Current Year 4 digit Enter Building Lifespan ENVISION TOMORROW PLUS USER MANUAL When you click Run you see a thematic map of redevelopment candidates in the target area The parcels or areas in red color indicate that they need to be redeveloped as soon as possible Parcels in yellow or beige color shows that they are still newly developed and can be redeveloped years later You can see the legend of redevelopment candidates in the Table Of Contents area which is located on the left side of the screen in the figure below gom etm Fla d um eee Bua i r Add P Fe tm it Mp M Lanes Bes te TA a YE Wn rir TEC LO i EN mi A Legend added A thematic map of redevelopment candidates in the target site is created Also when you right click the shapefile Meadowbrook Parcels lt ACTIVE gt in this example and click Open Attribute Table menu a new column called REDEV_ YR is added in the attribute table like the figure below The redevelopment years of each parcel are calculated and a new field is added in the attribute tabl
12. of raw ied coat 5 E lanis amiar eee fees i ngu edd mi 7 prafeaazeal fora W al hard coals EM Rays land E 10 Deeekipmen d Costs 11 aiding Canstractian Coria 12 Demon Cogis 1J zig Grvebpment Coste i i 14 Brown ied Reredancn Coste X31 i i if edema pexirucben Costs X31 5 TED 5 ran 16 Fetal Constructs Costs E41 z 110 S uu8s5 Costs of the project are 17 Ohice Constrecbon Coats VF 4 gt i z 18 Paarl Consmechon Coan Sar a5 3 esti mated by mu Iti plyi ng 19 Pubic Coratructen Coats Bat j 8t q m 2 Fdussien Cenatuesen Coan Lai g 100 the cost coefficients by the zl Heal ld bel Cocairuchen Coste E31 i 120 total square footage of the Fr Additions n takructurg echeccement coms 3 z em z3 Paring Construction amp nem buildi ng prototype 24 25 indirect Costs 7 impact lers 2T budding parmin m FAuranzs d ena cei a baxed during corcliectios CN ras Jared w 3t Developer F 282 18 Xx 313 Loetingency 349 X47 35 x Showing cost E Development and Land Costs rcluding Parking Total Costs allocation by nl Parking Coat By Line wed 79 peicea ESS i080 HZIM ETH eT building uses of ao 0 1 77010 2404 94 mrs TET s the building prototype and development cost types Wy Buking Envelope Calcubtor Development Costs Sca ENVISION TOMORROW PLUS USER MANUAL Based on the what if scenario approach in using a wide range of public leveraging tools
13. sbaglia ker O Quien LI A Ebay th CTs I F iesl Haoc stal AO SS ETE SSE Davy Faas Picea i i al tt SERRE EE m unt HM T ELELE T orsi Fl Read ney Tyre X iimis GAT ATES MAD ATES nga Family Benicantal iaa Se WHITES T Pa nga F aciy ect ERASE N Open Attribute Tatie ron erra ard Rari ja x B amp hi pj Dun ef Sul oriens EH Letan Certs n i EE Town enia 4 Doce Te layt iomano 1 s CThitr Attribute ual Webbing Wibi Seale Pange B MasarPlan feleti Nem are added at Lr i npa vm Lobel Feature Aika Firm a a oe Ey Edit Fgatuemi EE E Cones Ir Gie Fark a x Ag Cement Features b Geaphece H E m m A TUN m E Bl Herc led arta mbiieg re Pigier B aina ES EE EAR n Gusta Eni 3 Sume suas BI mese wii s Malls QC hmi Layer File E oic ish Es aids ru Create Laver Package LI nnt pamm ve ES IE L ueezines zhiyi G Pepsi E mermem s atas y ou pm 1 aie E i ua enn h ipe sites OM en a on ic i E m eee nene Piney Haie al 117 Page Ho d bru me arr J a ATE El dead l 53 2 bde ENVISION TOMORROW PLUS USER MANUAL However as you see in the attribute table of the scenario layer all values in that field have null value This is because ET cannot recognize the extent to which you want to synchronize the calculation outputs Therefore you should determine which outputs of parcels or areas you want to synchronize If you wa
14. Avg Income of Workers held Legend Classification Job Workers Balance D lingers Balance In the ArcGIS workarea you will see a thematic map of the J ob Workers Balance owe bess te s a Seem Py 1 i ET SAP HIE meir E j i r j aw pe LIE zi T T ea aem e H i a ae iz EN ul J ep e d odo mm m F a m BIN ENELG Tu e tum da Emm di b md mma mr Bie iin L prm m m s ENVISION TOMORROW PLUS USER MANUAL For an income balance thematic map all input fields are the same as the job workers balance You just change the legend classification option and click Run E E Select your polygon dataset ViismaichFront Dafine Buffer Distance 3 Mies Select Ernployed Residents field ResWorkers vll Select Workers field Wokes Select Avg Income of Residents field RsWkMnincm Select Avg Income of Workers field UAGA Legend Classification In the ArcGIS workarea you will see the thematic map of income balance based on input fields of the attribute table r i C 74507 f mee Ed GSES ep Oe ihe Vd a HADO Mii AQ RSD AEA X Cees Clee Fem nay Py Pale ak a zE i Hi es l E 138 Page 139 Page ENVISION TOMORROW PLUS USER MANUAL STEP 6a Modifying Scenarios While and after producing scenarios users m
15. ET software is also available from the Fregonese Associates ET ewiki website http www frego c om etwiki doku php id support ENVISION TOMORROW PLUS USER MANUAL Prototype Builder ROI Model Spreadsheet The Prototype Builder is a versatile easy to use spreadsheet tool that is used to test the physical and financial feasibility of proposed development and to better understand the effects of existing and or proposed development regulations The Prototype Builder considers a range of factors including parking requirements height and use requirements fees rents subsidies and construction costs The Prototype Builder then works to create a spectrum of feasible prototype buildings for a specific place Planners and policy makers use the Prototype Builder in a number of ways ranging from a site specific to neighborhood scale It can be used as a stand alone tool or in conjunction with the Envision Tomorrow Scenario Builder As a stand alone tool the model can help to compare options for future infrastructure or amenities investments in different areas of a city to increase housing affordability The model can also evaluate the effects of specific regulations like parking or height requirements on the feasibility of desired development Or by using a various mix of single use and mixed use building prototypes it can be used to understand and evaluate the implications of different styles of development As part of an ove
16. Shapefiles hold the Ctrl key and click the shapefiles to load in ArcGIS workarea Then click Add Your selected GIS data show up in the screen You are now ready to operate the ET Project function The site boundary shapefile and the satellite imagery data in this example are optional You do not necessarily prepare for these data The parcel level layer shapefile is what you actually use ges BR dd Hum hissi muse eee Ley ee a H Das ea mann tum ne BSG fy E i ns ARo Ties Fo OO RS AGA Ny ee remm 1 i Li a z I I A em 83 Page ENVISION TOMORROW PLUS USER MANUAL Step 1 Project Settings Based on GIS data you added in the preliminary step you can now operate the ET Project Setup function At the top of the ArcGIS screen you can find the button called ET Project Setup Click this button to operate the ET Project Setup If you do not find the Envision Tomorrow extension tools go to the Customize Toolbar menu and check if the Envision Tomorrow toolbar is already marked If you cannot find the Envision Tomorrow toolbar in that menu it means that you did not install the ET software Therefore install the program and check the ion Fr b i Pew echoes beet oii L xri 18 LL 6n uma He TES RARE 5n d Fi Babi ics A new window called ENVISION PROJ ECT SETUP pops up at the center of the screen As you see the window the STEP 1 Project Se
17. etc e Land Cost e The Total Project Value e Subsidy In scenario planning using ET categories and values of the building prototype in this tab represent final data This means that when users paint the areas in the target site all of these numbers are used as basic measures for estimating the full impact of the painted areas on the future growth or development of the target site In particular each development type shown in the Scenario Builder is made by mixing various building prototypes This will be mentioned in the next section the ET Scenario Builder E 1 Dsrputz fnr miriin Fomore Sol Spa ub T eel The building prototype The units for measuring name is imported from the size of development the Site Inputs table in mav be different but the Physical Inputs tab m ec enced Lr mm ort 26 Page ENVISION TOMORROW PLUS USER MANUAL ET Scenario Builder Scenario Spreadsheet The ET Scenario Builder Scenario Spreadsheet file is a Microsoft Excel spreadsheet file that is linked to an ET file geodatabase Scenario Layers When you first open your file geodatbase in ET you will be asked to open or select your ET Scenario Builder file so that ET can link these two files together When they are linked information of the painted parcels or areas in the scenario layer will be sent to the Scenario Builder to calculate various scenario outcomes by using baseline data already d
18. if you want to track the calculation outputs of housing density HUDen and housing unit HU you should check the Irack box on the left side of the Field Name column Check all Envision Attribute fields you would like to have Envision track Envision Attributes Check All Quick Reference Field Groupings Land Usa MU EM SR TH MF MH RET OFF IND FUB EDL MOTEL The Gets following Beitr are egored rmran feios DevTye Vacant Acres Dec Aces and Conmstmned Acme Check the Track box 116 Page ENVISION TOMORROW PLUS USER MANUAL When you click the Apply button at the bottom of the window ET automatically tracks the attribute field you select and shows the completion message when done Check all Envision Attribute fields you would like to have Envision track Check ll _ Uncheck At Envision Attributes Quick Reference Field Groupings Lans Use HU EMP TH MF MH RET O F IND PUB EDU HOTEL P Right Click Click When you right click your scenario layer in the Table Of Contents window and select the Open Attribute Table function vou will see the attribute table for that scenario laver In the attribute table you will also find that the housing unit density HUDen and the housing unit HU fields are added to the right end of the table ZH MA HER MTI LII IE ei Tidal PUN reed fe mc no SLE ed TA Bi P Es ITILEDILM sd ERLI GEGEN INTENTI
19. make the building prototype more feasible and how much each leveraging tools selected by users can reduce land and or construction costs or improve cash flow for development of the building prototype When the physical input output tabs and the basic advanced financial tabs are completed this tab show users how much they can get some benefits from the leveraging tools included in the tab to improve financial feasibility when development of the building prototype occurs Based on these total costs users can set up percentage cash amount and projected support terms For example if users choose the property tax abatements to eliminate or reduce property taxes over a scheduled period of time the total amount of property tax abatement is determined by building uses and users can input the local property tax rate available for abatement based on the local property data and determine what percentage of the property tax abatement users want to use over certain period of time for the building prototype The Gap Financing Options Tab Dashboard Showing the basic financial status and targets of the building prototype Users can choose any leveraging tools that they think are the most suitable for improving fiscal feasibility of the building prototype Views apport 5 Users set up the extent to which they want to use this option to improve financial feasibility of the building prototype ENVISION TOMORROW PL
20. scenarios in terms of transportation and fiscal impacts Mii Travel Abn inpr Subheader Cell Light Blue Linkage Cell Green lO Page ENVISION TOMORROW PLUS USER MANUAL Apps and Indicators in ET 20 Apps in ET The term Apps can be defined as a series of models that link onto the Envision Tomorrow Plus frame Envision Tomorrow Plus consists of four different levels of frame Building Prototypes Development Types Scenario Painting and Indicators as Outputs Fach app can link at different points in the framework and produce the estimation results by incorporating localized spatial analysis ET apps are constructed based on physical social economic and environmental data at various spatial levels Using these data ET apps produces various estimation equations or results Occasionally some apps use results or data of other apps as basic data For example in order to calculate Housing Transportation Energy H I E costs by housing types the H I E cost app uses the data and results of the Building Energy Consumption app BUILDING DEVELOPMENT SCENARIO OUTPUTS PROTOTYPES TYPES PAINTING INDICATORS Se GIS dg ao a Gum Oe e y a Be eer 4 1 T a a F i mi Ei PER ETA 9 M 3 Lp 2 Apps that directly affect the ET scenario outcomes me Apps that uses outputs from other apps Building Energy Consumption 7D Transportation Effects etc H T E C
21. 11083 HA Sg V aray Hasriental Wars aT ESO Senge Famy Reactor tail 17077 581348 Sansa Faray Amea Scenario 1 SC TEs 119 Page Mos p n BUE Bout of 392 Selected ENVISION TOMORROW PLUS USER MANUAL For attribute fields that can produce additional attribute variables you may want to write the calculation outputs only In the Attribute Field Manager window you can find the checkbox Write Calc Output Only Check the box of the field you want to add to the attribute table of your scenario layer and press the Apply button For example if you want to add the calculation output of the number of employment check the Track box to track the attribute field the Cale by Acres to calculate the number of jobs and the Write Calc Output Only box to add the calculation output field only Then synchronize the calculation outputs with the attribute table of your scenario layer to show the values EG api Pinca Lan oe Check all Envition Attribute fields you would like to have Envition track Envision Attributes Drei i Lipan Dad MP Den Quick Referance Field Groupings Land Use HU EMP SP TH MF HH RET OFF IND PUB EDU HOTEL click e a vule UI me T Mull Tae Ula Bs ELT rl I CNNEI T in 15 7234 4 TECH T T 34385858 x 7 pes 3525551 uz sat E B Ma Pari Rearea EI ES LI ay NE
22. AB era inest 97 Page ENVISION TOMORROW PLUS USER MANUAL After adding the input features meadowbrook shp enter the output feature class name ex Scenario 1 in this example This will be your scenario polygon shapefile when you operate ET and paint your scenarios Then click OK at the bottom of the window Leave the Expression Optional parts in blank Feghore Clana bo Feature Clas eum ZH Inout leatunes SET Plata UNDO 5 Demo Sw Ceca te Parceiro 5 Cua Leben e I DET Dats 0O 3 Demo z5eiMesdanbrook 3cmarmt gdo UN B parcel jd 1 Text d H prepeety i rai b vem 2 Debie m ii Anal wal 1 Detit EISI F Bido nur 1 Double H T sq fl Dn g Bum pin 1 Dile amp Click L H Land Vale t Debe i E Let Lew A i iiot bne 1 Tet Com memo lt lt ricer Toole Now when you click your file geodatabase in the Catalog Tree you will find that the shapefile Scenario_1 is added under your file gzeodatabase Meadowbrook This file will be your Envision file geodatabase Repeat this process four times until you have five scenario shapefiles inside your file geodatabase Now vou are ready to open your Envision file geodatabase in ET Attribute tables are automatically created when users open a file geodatabase for the first time wo DET E H Bets 3 EZ 30 5 Dea 546 E CB Base Dring m L Catahytic Pancekt gab HD
23. ET Scenario Spreadsheet Project Info tab Summary New tab FIT Link tab Scenario Summary tabs FIT Standalone App Tool Prototype Builder ROI Basic Advanced Financial Gap Financing Options 12 Page ET Apps Employment Growth Public Health Development Capital Redevelopment Timing Water Consumption Transportation Safety Jobs Housing Balance Amenities Parking Demand 13 Page Definition Function Estimating future employment changes ex wages employment by commercial types by scenarios Identifying the impact of sprawl on employment and economic resilience Physical activity related with active transportation Estimating costs and revenues including tax revenues for various development and building types Allows users to identify when redevelopment should be conducted by development types uses financing flow modules for 30 years Estimating landscape internal waste water consumptions Estimating the number of traffic accidents injury and fatal and percent changes Estimating the jobs to housing ratios of each scenarios Using the number of new housing units and new jobs created in the painted polygons in the Development Type Attribute tab of the Scenario Builder ENVISION TOMORROW PLUS USER MANUAL Forms Numerical data inputs amp outputs Equations Indicators Where within ET ET Scenario Spreadsheet Project Info tab
24. Existing Energy and Carbon Residential Commercial Energy Coefficients Metro Cooling Degree Days CCD and Heating Degree Days HDD and Household HH Travel Model Tabs mostly consists of basic reference data or information that are used to calculate indicators in the two summary tabs For example the Existing Energy and Carbon Tab provides users with information of annual residential and commercial energy uses based on the ET existing land use classification Also based on nation wide building energy survey data the Residential and Commercial Energy Coefficient Tabs offer users background information about how energy use by land uses is estimated In the summary tabs coefficient data in this tab are used to produce some environmental indicator results such as the Monthly Household Costs H I E and the Energy Use per Household The Metro CDD and HDD Tab lists up average precipitation temperature and Heating Cooling Degree Days of all MSAs in U S It serves as reference data for estimating sustainability attributes of development types or building prototypes The Household HH Travel Model Tab lists up constants household variables and accessibility variables for calculating Vehicle Mile Traveled VMT and trip generations by modes bike walk transit trips Outputs of VMT and trip generation by modes are calculated by existing and scenarios Although there are many input red cells value
25. File Geodatabase Name your file geodatabase file ex meadow brook Scenarios Corterts Fresca Desorption Pierer Type CD face Dengi file Gendaiabais i3 E 208 5 Demo Site LI Catalytic Parcehi gdis fie Geodalalbeic L fare Data gdb L CatalyticSeteiieundaries 27N90 7011 gdb Fia Gendstakene E GD Catahtie Parcels gdb Ld Meadcwbrock gde Vite Gepcatabase z r AREA ui Qf Demo Site Bareerap 10 1 rad Map Document UM ae CRM H SEL ETAT Beta 1 17 13mx fore Ede QU Uer Ste Racer P0 mad E j T FET Beta 1 17 1324x C WFRE TAZwlebPnplr cech Lie C wkRC TAfalabPemirrs yv iB EZ 2900 5 Derno Sete NEW Copy Cec E hum 2 aH 3 C3 Small Bugs BS ieiet x Ej M ii Right EJ Whauntambead aibodenti 815836 Jab eor Click m Mg Toniborri j E nj w Database Gersert H Vile Gecdataboce har E z B d Cennectons Gi Peona Geadatatare S ds D Spatial Databeie Connection Qj en Sonn Connrxtien C Layer Q Exi true Lirgei took E d AM Tehe Address Locator Composite Address Locator Fi XML Dessus CI Dare Dring Fike Gerdie CO Cathe Parcels gdb Fike Geodutabaie Fila Predati F r acc at aee Fur Grccataterur od Hier sie Haterhap TI mad Map Diesoarrerel Daae Sa Beene Mom Qj Demo Seg Exsermap 101 mus Map Decument terno Ste Basemnag Mila E ETeITT Beta 1 17 1dn Lscel file x Bi ETAT Sete 1 715 G WrRCTAZuictPopAconls Lave gt wie TAZ edobP opbecs Nr x
26. Inputs Entering basic costs revenues data that consist of general fiscal properties of the building prototype ex construction costs land cost subsidy GapFnancng Definkions Residential Owner B Bulsing esprint aLr OF open qaa Paring wee naxt i budding Urured cr lacis mad Prototype Builder Dashboard Tanem AcmaRehm 250 NIA Project Rate of Retum eee l5 ei fee Advanced Financial Inputs Entering additional and detailed fiscal data ex building efficiency pre development costs propvertv taxes debt etc NUN Gap Fnancng Dafra 18 Page 005 wil omases be used icd B5 single fami ape H est rif ic Til buichneas H Labea Tas Rhaiasca e He ede GS RES Bb AR o epp Phe total amount of money for this leverging option is shown Pite Geach Hri oaa E ara Pape CTE 19 Page beer freee ENVISION TOMORROW PLUS USER MANUAL In order to make the building prototype more fiscally feasible users can consider various financing support options improving annual project cash flow obtaining grants to buy down land and or building costs having loan to reduce equity requirements or having tax credits to reduce construction costs In ET Prototype Builder the Gap Financing Options Tab allows users to show which leveraging tool options can be available to
27. It can be obtained from various sources Existing Average Monthly Housing x Costs Rant or Mortgage 68 Page ENVISION TOMORROW PLUS USER MANUAL The Building Inputs tab includes a range of properties for each prototype buildings ET can load up to 50 different building prototypes Building prototype data can be obtained from the individual Prototype Builder excel spreadsheet files that contains information of each building prototype Properties of each building prototype are summarized into one row of the Building Inputs tabs Loading up to 50 Showing 31 properties of the building prototype from the Prototype Builder building prototypes Building and Site Characteristics Land Use Mix Housing Type etc ug a j i i F i T y i F eee Les t eng M ao E Rp qeu m ee E AA ma Input cells for properties of building prototypes automatically added Actually all data in this tab comes from the ET Prototype Builder It means that users can load individual building prototypes To load up individual building prototypes click the Load Buildings at the left top of the tab E pmi TE e p pesepem p uU x a Ca cad voir m EE IE E E LE Click Exp puts Bu ding and Site Characteristics Lre mra iy I5 an Dong Larter P usbimggloe Fea Pin uud t Evi Eg ug F1 Loue I ka DE Lone cep fe I WHYMU R
28. MANUAL Although many output cells are included the Proximity tab can be considered as an input tab However input data in this tab can be generated through the ET tool Proximity Summary and users cannot enter input data before operating ET and painting scenarios reject ins Bekdng pas ibit es Type egi De Type Abus Se oe q e Although it may not be input data users actually enter to operate ET and produce scenarios two link tabs Travel App Link and Fiscal Impact Tool FIT Link tabs serve as baseline data for the three ET standalone app tools When users finish producing scenarios in ET some of input and output data in the Scenario Builder are exported to these three tools These data can be imported in these standalone tools by using an excel macro button Users can import or clear data from the Scenario Builder by using buttons with excel macro functions on them 74 Page 75 Page ENVISION TOMORROW PLUS USER MANUAL Inputting Data in the ET Prototype Builder Before you get started with the Prototype Builder spreadsheet the first thing is to collect information related to the building prototype you want to create As a site specific tool the prototype builder requires the following data as basic and place specific parameters e Zoning Regulations v Height limits Y Floor area ratio FAR limits Y Landscaping and set back requirement v Parking requirements e De
29. OD CatahybcsiteEeundanes 27HevXr Hi Fit Grerdatelsaue Petre Clics fie Cepdataberne l agture Class EI El ornari 5 Qi Dama Ste Bateenap 10 1 end gi E ETAT Beta 1 17 0 3 25 C WEC TAZwlebPanAcnt hor 4 E 3900 5 Der te NEW E D Document E 5 Small Bug i ES imre m J Gi u E T d PS imeahidi ub 6A S Lele cor Bs Toclboom E HJ Decshase Sercers gt Lg Database Coneechenca a B3 GH Servant mrn namm EL EH GES GEO GEO GEO o E GEL GRO LOGS ET can support up to five scenarios so create five scenario shapefiles in the i um AA GA S HAAS AE u uH uM GEO d u AC AA X AD E 9 amp 8 Page ENVISION TOMORROW PLUS USER MANUAL Opening the Envision File geodatabase You now have your file geodatabase file so the next step is to open your Envision file geodatabase file in ArcMap However the process of opening your Envision file geodatabase is slightly different according to whether you open your file geodatabase file for the first time or not When you first open your new Envision file geodatabase ET performs several functions behind the scenes as follows e Generates several tables within the geodatabase for tracking scenario results e Generate a list of all layers included in the geodatabase each layer is a potential scenario layer This means that many tables and data layers will be produced when you first open your Envision geodatabase Now let s open your Envision file geodatabas
30. all output cells within these scenario tabs change on real time basis when the Scenario Builder is linked with the File Geodatabase Scenario Layers within the ET software system All outputs of the painted areas are arranged by development type 33 Page Changes in demographic physical economic and environmental aspects for painted polygons are calculated by development types on reai time basis ae Poajact Ines Boking Feun Gay Tipe Streets Durs Type Bekiro Hi fey Type Atebau Pe ee ee 00000 MONARHA AETSTIUURGEEGEUS YI EET TET FE ENVISION TOMORROW PLUS USER MANUAL Another output tab that allow users to analyze their scenarios is the Detailed Building level outputs of Each Scenario Tabs Unlike the Detailed Analysis Results of Scenarios by Development Type tab this tab allows users to figure out demographic physical socioeconomic and environmental changes occurred by each building prototype loaded from the Prototype Builder As we already know each development type is created by mixing various building prototypes imported from the Prototype Builder When users paint areas each polygon consists of certain proportion of building prototypes defined by each development type Through calculation of acres of each building uses this tabs sums up the total acres of each building prototypes based on total acres of the painted polygons and estimates physical demo graphical socioeconomic and environmental impacts o
31. and parking requirements should be considered All input data entered in the physical tabs help update information in the prototype summary dashboard such as the Key Building Stats table Also the before tax leveraged internal rate of return IRR and the target project profit will be determined by users for feasibility of prototype buildings A B i E Site Layout M Prototype 2 Bac ung p 1 x F Housing i Hotel Room Derady Per ie O Eo RES So ie is bd 5 Jab Density Per Acre a3 pens saree trea Dashboard at TT Unsnad gr Hla So CN p E Setting up the physical fiscal targets of the building prototype Propel Raie of Retum zf E f Entering physical af input data of the Ee 360r eren proce ege em zs building prototype 26 T Peed pa cad ege 27 a AL Gh enter paecana age Site Layout Housmg Units Hotel Rooms r qe Pnp hl 3 m Bagg Poepie and Rees Hate Ronn Dery Per Aerei 410 a Lendycipeng or agen ace z Tas Denuty Per Aere a a alin parua rart im bustling Prototype Bui Ider FAR let hentabe Selene Square Feet impe or fa bee space Dashboard Setting up the physical B si fiscal targets of the building prototype Preuect Pane a1 TU o m Me
32. area Rectangle Brush Paint all parcels areas within a rectangle area Circle Brush Paint all parcels areas within a circle area Polyline Brush Paint all parcels areas where a polyline passes through 5 Page ENVISION TOMORROW PLUS USER MANUAL ET Work Area As an extension tool of ArcMap the Envision Tomorrow Plus work area can be illustrated in the figure below The actual ET work area consists of four parts ET Extension Toolbar Scenario Task Area ET Status Bar and Mapping Scenario Visualization Area Since ET is an extension tool of ArcGIS it can also use ArcGIS functions When you first open your file geodatabase for scenario planning you will also open the excel scenario spreadsheet to link your file geodatabase to the spreadsheet Processes you operate can be indicated in the status bar at the left bottom of ArcMap When you choose one scenario layer you will see the shape of the target site in the mapping scenario visualization area All menus and icons for editing scenarios are placed in the scenario task area In particular if you want to create your own scenarios you need to choose colors shown in the scenario task area Each color stands for development types you can choose for scenario planning ArcGIS ET Extension Toolbars Toolbar ET Status Bar Table Of Contents ArcMap Scenario Mapping Scenario Visualization Task Area Area 58 Page 59 Page ENVISION TOMORROW PLUS USER MANUA
33. catalytic site in Salt Lake City Utah as a scenario planning example offered by Envision Utah Another Method Constructing a New File Geodatabase by using ArcCatalog In principle you create a file geodatabase through the ET Project Setup function However if the target site does not have any constraints and subareas you can use functions of ArcCatalog to create a file geodatabase This may require you to have skills and a little bit background of ArcGIS system Envision Tomorrow Plus is a GIS extension tool using a file geodatabase as a base layer In the file geodatabase you need to add a GIS shapefile shp that contains a range of datasets by the area unit To create a new file geodatabase you should run the ArcCatalog one of utilities of ArcGIS software Now go to your data folder and you will see one of the screens shown below Before creating a file geodatabase by adding a shapefile creating a GIS shapefile for operating ET is a very tedious task because it contains a lot of dataset ex land use type year built land values etc How to make a GIS shapefile for ET will be dealt with in the advanced level manual Nemo necs Hii D ma l ces aL j tu aine Qe i tt i e 3x uer t ES Vere zu Vis Gacdatalats 95 Page ENVISION TOMORROW PLUS USER MANUAL First you need to create your new file geodatabase you will use for producing scenarios Right click the screen and select New
34. e ENVISION DEVTYPE FIELD TRACKING fil SCENARIO3 e DEVELOPMENT TYPE ATTRIBUTES ff SCEMARIO4 e FIVE DETAILED SCENARIO TABLES 1 5 fi SCENARIOS e SCENARIO SUMMARY jJ SCENARIO SUMMARY e TRAVEL INPUTS D TRAVEL INPUTS e EXISTING LU REFERENCE 100 Page 101 Page ENVISION TOMORROW PLUS USER MANUAL Also when you open your Envision file geodatabase you will be automatically prompted to select an Excel scenario spreadsheet file By linking the scenario spreadsheet file with the ET scenario tables data related to the painted area in ET will be written in both the scenario layer you work on and the scenario spreadsheet In this example Meadowbrook Catalytic Site select the excel file named ET Scenario Spreadsheet v3 1 BETA 022013 xlsm as a scenario spreadsheet file Q trum am ERES Dum fig i j amp N t mra x o poc y Lj E T m Click vo n Now you will see the selected file open in Microsoft Excel In opening the scenario spreadsheet however you will be asked if you want to retrieve the latest data of the scenario spreadsheet or use the previous information In this case you choose the Don t Update option because you open your Envision file geodatabase for the first time and the scenario spreadsheet you selected may contain datasets for existing conditions of the target site only n c click Sates Tax Bavenus per Acre ENVISION TOMORROW PLUS USER MAN
35. external parcel level data resources especially parcel data from Assessor s data will be automatically reclassified through the ET Project Setup function These generated fields are also automatically added to the attribute table of each scenario layer shapefile 66 Page ENVISION TOMORROW PLUS USER MANUAL STEP 3 Inputting Data When you finish collecting and cleaning up data the next step is to enter these data into input cells and tabs within the ET excel spreadsheet Particularly in this step users should enter their input data to fill in blanks within the ET Scenario Builder and Prototype Builder In fact collecting and cleaning up data from external resources require users to spend a lot of time and efforts Fortunately when all input data are ready filling in input blanks may be very easy because names of input cells and tabs are very straightforward Also some of input cells and tabs can be automatically filled in by importing data from other ET excel spreadsheet Inputting Data in the ET Scenario Builder As we already learned in the previous chapter the ET spreadsheets aggregate all input cells into four tabs Therefore users easily input the data Also when all input data are entered they serve as baseline data to produce results of 61 scenario indicators The figure below shows how each tab relates to one another
36. in the ET Project Setup Function Other Options Census Tract Block Parcel Cell Grid Cell Hybrid Cell Block Groups TAZ etc Advantages e Can produce very e Uniform detail of e Provides ability to e Uses readily detailed analysis add precision in available and alternatives and e Can be a variety of specific locations familiar with data estimates of sizes depending on e Analysis can be done outcomes need quickly allows multiple alternatives to be evaluated Disadvantages e Requires more e Requires work to e Requires setup of e Results are general resources to adapt existing data data at two e Difficult to refine construct and run to match new grid different alternatives cell boundaries geographic scales e Quality of parcel level data may vary Best for e Communities with e Communities e Areas where is a e Preliminary analysis detailed GIS data where more mix of large and or a quick and capability detailed small census assessment of e Incorporating information is not blocks grid cells or existing plans scenario planning available parcels do not e When resources are into ongoing e Uncertainty about provide the level of limited community how scenario precision desired e More detailed data is planning and planning fits into not available analysis long range planning and analysis Source Oregon Department of Transportation ODOT 2013 Oregon Scenario Planning Guidelines Resources for Developing and Evaluating Alternative Land Use and Transporta
37. layer and select Open Attribute Table Then vou will find that there is a new field added at the end ofthe table FTIIT c C DAET Det GEOS S Dema Sarileadewbeneku ug Val pat sah Ez mieli Miles E3163 E333 12871 CiT ie 218 i Fb ie 55 wipe Scala Panga M sumo uus eiiim A new field Val per sqft E d is added to the attribute bli Fon table of the parcel layer 9 n EN cut of so Setected Meaclosdbeank Parcels AC TIVES 130 Page 131 Page ENVISION TOMORROW PLUS USER MANUAL In the Bottom Quartile method ET estimates redevelopment opportunities based on relative value within in area by using the following simple equation Building Value PM aia Eee JS B Improvement Value Land Value Value pt acre Lot Square Feet Occasionally you might have an error message called Legend Renderer Error This is because there are zero or even negative values in the lot square feet of the attribute table in the parcel layer Meadowbrook Parcels lt ACTIVE gt in this example Or you may not have the area square footage data in the parcel layer In either case you need to calculate or recalculate the area square footage of these parcels In the attribute table of the parcel layer click the icon 5 and select Add Field Name a new field and select the type The Double type is selected in this example amp Click In Find a
38. means that although there are many input and output cells in one large table all data in this tabs are imported from the Prototype Builder tab called the Scenario Spreadsheet tab Therefore what users should do in this tab is to load properties of the building prototype from the Prototype Builder To fill in input blanks of this tab users only click the button Load Buildings at the top left of the spreadsheet All values of each individual building prototype are automatically written in one row The Building Input tab can load up to 50 building prototypes for scenario planning Building prototypes loaded in the Building Input tab serve as basic units for creating a set of development types in the Development Dev Type Building Mix tab The Development Type Building Mix tab will be mentioned in the next section If users want to remove all building prototype inputs in the tab they can click the button Clear Buildings Using these buttons users can load clear building prototypes E 1 Load your sz Prototype buildings Bineg rea y ctas i dari Uta Fern 14 Curs Ubri lH Lar 15 Esci a Nein tita Fin b Shee I kredia Fara Fem KE ailra an 15m J Baunilha Fan aea Tus H Chana i Hes T LH esr 1 pim Tb Taker baa nfl E ina x aues Ls Dia l Ste 2 Tirania mira 9 Misr P THs 1T zs ro Y ils 24 Taram Pr l a mo Mum Ub Cote 29 Page that they developed through the Prototype Builder Building and
39. model buildings and test the physical and financial feasibility of development The Scenario Builder adds scenario building functionality to ArcGIS for creating unique land use scenarios and allows real time evaluation of each scenario through a set of user defined benchmarks or indicators Prototype Builder ROI Model ENVISION TOMORROW PLUS USER MANUAL Basic Features of ET Basically Envision Tomorrow Plus is an ArcGIS extension tool that allows users to conduct scenario analysis analyze their own key priorities and understand the full impacts of scenarios In addition since ET is developed as an open source scenario analysis tool users can download the software anytime and use it within the ArcMap program Two primary Microsoft Excel spreadsheets the Building Prototype Builder and the Scenario Spreadsheet are linked with actual painted scenarios and play a role in showing the outputs of each scenario in the comprehensive and visual way Second Envision Tomorrow Plus is a versatile and expandable tool that can easily be adapted to accommodate various uses Unlike most planning software Envision Tomorrow allows the user to easily and transparently change the assumptions of the prototype buildings development types and scenario inputs By making the tool transparent you can quickly and easily adjust the assumptions to more accurately reflect the dynamics of your particular neighborhood city or region This transparency
40. planning assumptions in terms of physical economic social and environmental aspects It consists of many tables in which users should input the relevant data These data should be based on the Metropolitan Statistical Area MSA to which the target site belongs and users should collect data of the MSA and develop their scenario assumptions The first table of the Project Info tab allows users to define the MSA of the target site T How to input data in each table of the project info tab will be mentioned in the section of the next chapter site belongs map Peewee hono aca um UR m r p hate irani Train d Trma i inurman im Wage Td evar zs Taian Waga Ditibreiad j mnr p Er pra 4 F r iera ip p pum hi ra E SE i Pemi ieie Bebi r ee Fee a Se eg el el F Defining the MSA to which the target The project info tab contains many tables with many input d a 28 Page ENVISION TOMORROW PLUS USER MANUAL The Building Input Tab in the ET Scenario Builder allows users to use individual building prototypes that they worked on in the Prototype Builder It is directly related with the Prototype Builder ROI Model and includes all physical and fiscal properties of the individual building prototypes This
41. scenario outcomes are called Constraints and users should include these existing physical conditions as another variable for their scenarios Fortunately ET allows users to analyze the full impacts of scenarios considering these physical constraints When users create a file geodatabase through the ET Project Setup function they can define the constraint layers and determine the buffer distance of the constraint layers However the constraint layers used in the ET Project Setup function are not included in the file geodatabase In the ET scenario planning system constraint layers play an important role in analyzing each scenario by using various ET tools In particular when users operate the Proximity Summary constraint layers such as river and natural parks can be used as amenity layers to estimate the number of housing units and employment close to these layers Constraint layers are not included in the file geodatabase so users should add them manually T aisle OH Conteris Gi E Wl Mevepolten Center E Urban Center EN Seven Center Corrsemunr Dy Cosi iei Foaral Village E Muti Fami Fendenmial Tradkusal Fieighberhand Muster Planned Community D Sege Fanuly Heiosendial Adobe Hore CITT er Lie Bl Hewes Induiknal Bg EDN DEVTVPE FIELD TRACKING BE DEVELOPMENT TYPE ATTERUTES m ScEHAFJOL BE SCEMAPIO E sCEMAFJOS E SCEHAFdON ED SCENARIOS Un SCENARIO SUMMARY E TRAVEL INPLI
42. tabs allows users to identify data from various resources and define assumptions used in their scenarios such as household income by housing type Metropolitan Statistical Area MSA single family housing lot size assumptions and so on Colored in blue output tabs helps users to understand the full impact of each scenario on the target site by using input data in the input tabs and information of the painted areas in the file geodatabase These outcomes are represented in many tables and graphs so that users can understand the impact of each scenario in both detailed and comprehensive ways Last colored in light blue reference tabs generally provides baseline information or data for calculation of scenario outcomes Occasionally depending on the features of the spreadsheet these tabs can be categorized in a different way For example in case of the ET Prototype Builder ROI Model spreadsheet tabs can be grouped into four main parts according to its features Physical Tabs that allows users to enter basic information of the building prototype Financial Tab that helps users to enter financial data and understand their fiscal impacts Calculator Tabs for tracking all calculation outputs and summary tabs for summarizing all outputs of the building prototype Fajai Tab el en m Turks h pai Tat Buking outs Dey Typa Mre Dev Type Buldng Hii Dev Type Attributes AP rne Fg Quick Sht Guile hyi Inne Pinar Duetai Bosc Frari advanced F
43. the FIT Standalone App spreadsheet input data are imported from the Travel App Link tab of the Scenario Builder After entering all input data this tool automatically estimate household outcomes using the household 7D model app absorbed in the tool The household travel outcomes are trips by transit modes vehicle walk bike and transit vehicle miles traveled VMT change in traffic accidents transportation costs per household and transportation carbon emission All household outcomes produced in this tool are also summarized in the Summary tab in tables and graphs b brn 5 m etm 1 IER CR L mE Fu s k m FE uw us b kre z PF re eA m af a i Li a 1 r5 ner I 3 peg Tif Leia m ELI ma te MITTIT j m Fu m pu i a en eed By E Spud aly ho PE pom e pus su f d F a i E a am m i m dm ux gris 1 m he i 2 heres mre n LEDID TE ITI i di iim Lus E E im Ai aes ki r x num E a es 1 i Bola Dei Ami as LU E I Il 18 Drwriegasi Lal Bepi Aiia Peg FF Mud Pr Ig bm Tr ke LI 2 LI ai Veil Las ad Pi F1 E PELA A pP RERO UN D a n m d coved oum ea D Wade uui iiri bAa si Sy mec camel gd a Kay manm id mo HgREES gi ihn nmm bm m d Vete Ba edi ictu atem del E aor p Leo By ce Wa um Rm m T a A j E mat T es le Sor j J LE a i keg Sp p Lal gm m m PE a r I rrr fone GTTTUEY 46 Page ENVISION TOMORROW PLUS USER MANUAL Mi
44. umm cmt D L 1 I MXD Travel App inputs inb E Existing Scenado1 Scenario Scenarios Scenario4 Scenario 5 zs a i change in ieriection Danaity arm aw eu as gu LN imitation D rnifty a B Bg oO n T AW ay In amp ereertlona kes i Si ka _ 38 s nf d Way be Sens ars Jar Sir SAT A SS change en dean aqu ans irs eu s 41 Mibi ani oer Within 1 Mile fuller qo 100 100 100 100 Lo aa Aree of 1 Mile Dulfer digand MED buntar ipu mila l Lo LOG TOU 1 00 1 00 1 00 43 LN iteration Denim Within 1 Nile 451 a st aay A81 4 81 4 01 44 Hoanehoid Characteristics Demographic I5 ose hold Sine Aa Ota Lr LI eo e d X 46 LN Hecreheole Sine Enn c0 eo 6 00 5 00 Weserkis hod Sis 4 4H UN Hosope bois Lize SF noo on oo foo oo nno r Biene hold Sipe Oih D LA Hiocupehgld Sipe ones Da Ca Pane i Cu a00 w 51 Birdin Hassehold incom Q5 1 Melon Ferusadhold income 5 resi P Tes ci Co z a 3 E H UN Median He uiehelad itor SF modiy po 1983 CPI DoD DoD COO pog Goo 0 00 5d Medlen Howwrhnld inccene other edi Haxusahinld income ther pmodety to 987 CP 5 5 Shi LH Median Howse hodd ircome Cheer drdi To 1982 Cli 0 00 tu eun Fis eun To 1 Vehicles Per SF Hii r Es i ES F i r c i Go O00 E UM wWakarles Per SF Fila pom DOC ELO 0 00 e Goo Vehicles Per Dihs HH r ES T nc nen T ana T mou l non i UN Vehides Por Oihar HH aio nop mg Goo ooo pony l Vehicles Per Capita T n
45. BNVISION Qe tomorrou ENVISION TOMORROW PLUS ET USER MANUAL Keuntae Kim Metropolitan Research Center University of Utah ENVISION e tomorrow CHOOSING YOUR MANUAL Followed by the former version of Envision Tomorrow new Envision Tomorrow Plus not only reflects a wide range of existing condition data but also produces various outputs of each scenario Therefore in order to explain these new or updated functions of ET it is necessary to document every detail of each step for producing scenarios when user operates ET The main purpose of the ET user manual is to help people understand how to use Envision Tomorrow Plus ET for creating their own scenarios Based on their level of knowledge of ArcGIS and ET users can choose either of the two manuals a beginner s manual or an advanced group manual A beginner s manual is designed to help people who are not familiar with scenario planning tools or ArcGIS It contains general information about the ET software and explains how to operate ET when all required data are ready to produce scenarios An advanced group manual is targeted to urban planning professionals or developers and designed to fully operate ET from the scratch It includes more technical contents such as comprising their own data resources fitting into ET and analyzing scenario outcomes in the more detailed and comprehensive way The table shown below explains target users and contents of each manual envision
46. DUO 24S IRI Lower Y Custom PUR e Click The last thing in this step is to select the Scenario Builder file where the data are imported to create attribute tables and that is linked with a file geodatabase throughout operation of ET When you click the folder shaped icon on the right ET asks you to select the Scenario Builder spreadsheet file you want to use Go to the folder where the Scenario Builder file exists click it and hit OK a a EU IM c Sy md ated un bone and is va i Capit dh r Cempe o Rerrerveble edi Uh e ETe Lerple sto Banini ET Exavple UR amp Sy B Bron Beer p pe Mims bini Pearl Pim d Eae Dang nci 3 L z m SEXE E CE Dara rn b Sieh ha de Fritters ai ma un x B mirri ot P eta ue TAn d rem Ti ET Scerunse Sprencubert_ 01 1 Mure Parcel WithDela rium LUE i m 3 M iE Eu ei E Stele Desi i Fes rare ET n pur ne eee E Pele Pani E NLE Pleh ENVISION TOMORROW PLUS USER MANUAL However while loading a scenario builder spreadsheet file you see a message about whether you want to update the spreadsheet or not In this case click Don t update This is because we do not create any file geodatabase yet and it is unnecessary to update this spreadsheet without creating a file geodatabase and linking them together Marsan Fac d a imi im B LL ied a Mi ee ita I 1T ras eer Fa ee mo
47. E A Eee ARE m 3 pT The Building Envelope Calculator tab dashboard Showing the total lot size and building square footage of the building prototype Maximum Required Parking Area for Full Build eut Providing two calculation outcomes based on ia suface structure 47 VW Resgental Rental Meta Oiice Industral Motel Commence Darang medis summary Budding Envelope xaleulator 20 Page ENVISION TOMORROW PLUS USER MANUAL The Development Costs Tab helps users to understand how much pre development and development costs will be when the building prototype is actually built in scenario planning Pre development costs generally include land costs and legal fees for development or building permit These costs are estimated based on percentages of raw land costs or hard costs In the development costs construction costs are calculated by multiplying construction costs per square foot by the total square footage of the building prototype The construction costs per square foot are previously determined based on national average development costs Indirect costs can be estimated according to local development taxes or fees Coefficients for estimating development costs are determined based on the national averages of development costs The values come from the basic and advanced financial tabs in the Prototype Builder A D E F TI H d if Pre Development Come a duse djeme 5 land cory
48. EZ 00 5 Dema Ste NEW Ell Corwen Co teal Buss X E Shear s EJ E GUT ied Vfcuntismiesdrtudenty abcr Name your file geodatabase 96 Page 4 Feature Class to Feature Class amp rout Fears Cie e Lang nan d Output cake Chis BET casali a Sca eleackowbrook Soman gdb ENVISION TOMORROW PLUS USER MANUAL Now you need to import a GIS shapefile with a range of data for the target site In this example you can find a GIS shapefile named meadowbrook shp under the file geodatabase Catalytie Parcel To import the shapefile select your file geodatafile tmeadowbrook right click it and choose Import Feature Class Single iH Rare Dara gets File Gerla ae rib L Coptic Parcel cef m Li Cats iiia I hex e LOB ee a Klaadratsork anamar pit Deme ete Bap ID mog Decus b e Blei Jj een a Ee OT ETT Esta 1 17 2 ete i E Viuen te o8 84 abes Right DLE cuolbrwER i6 Ej Databare Servers Click th G3 Dalabaie Cenni j Pubiihs ha datil Geren i HJ GB teres Erdribsal rd Godar Pippen You will see another window pop up In the Input Features click the icon 4 and choose a shapefile meadowbrook shp under the file geodatabase Catalvtic Pacel You will find that shapefile when you double click the file Catalytic_Parcel 03 ro enan cadi ETa FIT ta L21728 ako WRC T Z mlobPcpacrs lr Shure nl ture
49. Ej te E mad PSLT ma V deg ini ep diam Pap Petey Lal aya den ug as imag Pew Cr RI E d T iya Phi lg wur eg para ER dtd Bi d LIES pra baec Per L m icm no iry Cee k png rar EI zm brg oma eum ua d Yom mun dim mr gee erni pr FM dA maiin ov ies r d DEVELOPMENT TYPE ATTRIBUTES x m ua n uu Ec HEE pue od cm Loe LL iim mun Pre Dae o 00e bo ines Es mi ie eee g TIT 7E E La 3 Town Contr Toc M de re a bm om Commu ty Center pee feed i 12867 124 Ham gom das Sera vila 31858 1 ENEY HEN fert Pork E Muti army Hender I 18005 Darras Dsi pr imini o r Tiatira liegt chor hard I BATE 351334 Osean 1488 1 Maier Py County ED VERE DTE DT LI Sige F amiy Resdenal 7506 XM eal E w Mabla Homes 8 a z 1 Spaced Parm Hapdi 3008 95138 Q t 12 Commercm 158068 nazi 01 n ene 13 Office Par Doo 435311 O 390057 E 14 Lig 204008 CEFL 0 355552 14 m 1411311 D E 1 n 2 i 1T a p 18 g E 8 44 Page ee enini 45 Page LA Ee eT mct gama m dd gr PLS NER a ENVISION TOMORROW PLUS USER MANUAL ET Standalone Tools In order to conduct additional scenario analyses about specific issues such as transportation and fiscal impacts ET provides three separate standalone tools Household HH Mixed use Development MXD Travel and Fiscal Impact Tool FIT Although they can be operated separately input data come fro
50. Feature Consiructeon usn Click Georndmg Geodatabare Hrac Geometric Iieteork Eding Georefenencing Coeestatisbeal Amii Graphics Image Classification Labeling Layout Map dence Publcphing Metweuk Analyst Parcel Editar Fubirher Raster Painting Pepresentatien Peul Editing Sobarnatig Schematic Editor Schematic Meteor Analyst Snipping Spatial Adjuitrrerni Spatial Analyst iw Standard TIN Editing Tablet Tools Topology Tracking Analyst Utility Network Analyst Yazinin 52 Page ENVISION TOMORROW PLUS USER MANUAL Now you will see the ET toolbar at the top of ArcMap When you click the ET paint tool another window will pop up the screen However for your convenient use of the ET tool it would be better to place the toolbar on the left side of ArcMap workspace T bio Rum lea ee mm ls n gt aS rg ie ae Mii badii TL Aes me i m Fm dM eR ied EE WEEE 06 ce Wr iy aii e ae M i omm 3h Eu An WU a B un m sl LU 53 Page ENVISION TOMORROW PLUS USER MANUAL Envision Paint Tools Menus The ET paint tool consists of three separate main menus File Fdit Scenarios and Subareas Also there are four icons beneath the menu bar and they play a role in painting and editing scenarios When you create scenarios by using ET most of your works are done by using the File menu In the File menu there are six sub menus Open Envis
51. L STEP 1 Selecting Geometry Before collecting data and producing scenarios using ET the very first thing is to determine the scale of scenario geometry based on the scale of the project One good thing about scenario planning is user can conduct scenario planning analysis at various spatial levels However this also means that scenario planning tools are heavily dependent upon the geographic scale of the target site area to analyze different impacts of changing land use patterns and combinations throughout the different spatial levels Without defining the appropriate geometry scale users cannot get scenario outcomes that they expect to know The second important factor that affects users choice in selecting the scale of scenario geometry is data availability As we already know in the previous chapter ET spreadsheets and a file geodatabase require users to enter a lot of input data from various sources In particular based on the scale of scenario geometry most of EIT indicators are directly related to land use transportation and financial data If users cannot obtain data that fit into the scale of scenario geometry they will not produce accurate scenario outcomes The last important factor for selecting scenario geometry is the extent of details users to which users want to produce scenarios At small sites or neighborhood level parcel level scenario layers should be required to see changes by scenarios However in large
52. S STEP 0 Preliminary setup Understanding the basic 49 Structure of ET Software STEP 1 Selecting Geometry 59 STEP 2 Collecting Data 61 STEP 3 Inputting Data 67 STEP 4 Opening Data 81 STEP 5 Painting Editing Scenarios 107 ANALYZING SCENARIOS STEP 6 Interpreting Scenarios Tools in ET STEP 6a Modifying Scenarios STEP 7 Choosing a Final Scenario 121 124 139 139 ENVISION etomorrou 1 Page ENVISION TOMORROW PLUS USER MANUAL INTRODUCTION What is the Envision Tomorrow Plus ET Envision Tomorrow is an innovative set of urban and regional planning tools that can be used to model development feasibility on a site by site basis as well as create and evaluate multiple land use scenarios test and refine transportation plans produce small area concept plans and model complex regional issues The software also provides a real time evaluation of relevant indicators such as land use energy consumption and financial impacts that measure a scenario s performance It can also provide baseline carbon emissions analysis of different land use patterns enabling planners to model the relationship between greenhouse gas emissions and land use and transportation decisions Envision Tomorrow Plus consists of two primary tools the Prototype Builder an ROI model spreadsheet tool and the Scenario Builder an ArcGIS add on The Prototype Builder a return on investment ROI spreadsheet tool can be used to
53. Site Characteristics Land Use Mix z La Z E X um oe FSI B B al ddzid233 3 22122594222212232222328 IaassldNas x wmm NM MEX NS 22312232132232323221232131273313 i P 2223222222223222232222223222232328 PM E F 338233232332233223223223222322323 222232323232222322332222332222222328M a m Au S E HE GE Gh Vm ES E UM FR Od Au og E aA SE ER HG US T F2213222722212223227233221232737 0 me Li ns as x im 7 p P FR m m ra P FP m Ph L7 m HER RH 12242221 re Each individual building prototype is automatically added to the table in the Building Input tab ENVISION TOMORROW PLUS USER MANUAL In the Development Dev Type Streets Tab users can define physical and fiscal properties of blocks and streets by development types such as block size street characteristics net land reductions and construction costs In this tab users first define what development types they want to use for their scenario planning in ET Each row of the tab represents block and street characteristic data by development types Output cell in the tab are calculated based on the input data and all input output cell data are used to estimate development potentials and transportation outcomes of each scenarios Like the Building Input tab the Dev Type Street tab can define block and street characteristics for up to 50 different development types Along with the Project Info tab this tab is what users ne
54. TS E DGSTIMHG LU RIFIRZHCE 43 Page 9 ox TOHANI TOOLS Fale Fel Satnatics Sata E Apes Start Edit Symbol Development Type ee SOMBRA Lister Urban Carie Tawa Cete T Carmmaurdy Garnier Rona isse Mute Fari Fiasssecias Tiree Hexzhibre haod Hasier Pinsnad Comer turpe V arre Places tes Mot Homra Sgae Aural Residential Cormmarcad Offer Park Light kodera Fen mama incur a x ag EMWESJON PROJECT SETUP H i HUN Sip Project Settings oigo a Cons Shop J Land Use Sons if Fipig Map Sieg Sub Amas Gf Check Al Layers Bil oo Sa Layers emne Check the Constraint Layerts Duete Constrained Areal fram Cuts Bote Lisiane Mega o Aide Alden Laver Hama Bufer Depts PRT PARCELE A8 TL Piipa Users can select shapefiles added in ArcGIS system to use them as constraint layers Q previous Next EP ENVISION TOMORROW PLUS USER MANUAL Scenario Attribute Tables Along with the attribute tables of each scenario layer the file geodatabase also contain additional attribute tables used in scenario planning in ET As with scenario layers these scenario attribute tables are created and added to the file geodatabase through the ET Project Setup function These attribute tables severs as output tables that writes outcomes of each scenario or reference tables whose reference data are imported from the S
55. UAL Then ET starts retrieving and checking required scenario datasets that are included in the scenario spreadsheet In the Envision Paint Tools you will find that several symbols colors are added according to development types Table Of Contents X ENVISION PAINT TOOLS 2x Bes B a Fie Edit Scenarios Subareas 3 Layers LE ONET Oata 3900_5 Demo Site Meac Apply Start Edit t ENVISIOM DEVTYPE FIELD TRACK GD DEVELOPMENT TYPE ATTRIBUTE Development Typa SCENARIOL g SCEMARIO2 UD SCENARIO3 Metropolitan Center D Scenarios Urban Center SCENARIOS Town center UU SCENARIO SUMMARY rae 4 H TRAVEL INPUTS ceu S m EXISTING LU REFERE Rural Village Mul Femiy Residential TradtionalNeighborhood Single Family Residential Mobile Homes SpscedRursResi ential Commercial Office Park Light industrial Flex Heavy industrial After finishing retrieving and checking the data in the scenario spreadsheet you will see another message in ArcMap Defining the Scenario Layer When you open your Envision file geodatabase for the first time ET does not recognize which scenario layer you like to work on Therefore you need to determine which scenario layer you want to work For now click OK to define your scenario layer o Please use the options under pull down manu FILE Def
56. US USER MANUAL The Calculator Tabs contain all of the formulas and calculation behind the model in the Prototype Builder spreadsheet This tab helps users understand exactly how the Prototype Builder works and allows them to track the results of the building prototype performance As reference tabs the calculator tabs include the following tabs e Building Envelope Calculator e Return On Investment ROI Templates by building uses e Development Costs Outputs produced through the Prototype Builder are summarized Unlike physical and into one spreadsheet row in the scenario spreadsheet and integrated into the Excel Scenario Spreadsheet file as one building prototype data financial tabs users do not need to enter the data in the calculator and Using physical input and output data the Building Envelope summary tabs will Calculator Tab calculates physical requirements of the building prototype by providing users with a possible build out range when it is actually built To help users track the physical requirements of the building prototype this tab provides two different calculation outcomes one assuming that the building prototype has underground and tuck under but no surface structure and the other assuming that the building prototype has surface parking or be mentioned later As reference tabs most of cells there are output tabs and already set up Therefore do not try to modify it structure ENSE S ORA
57. Y NEY ode oad od doe eu ale I REM EH RHE Oe ORR COR ee ee E ET 69 Page ENVISION TOMORROW PLUS USER MANUAL You can see another window pop up Select your building prototype Excel spreadsheet file and click Open T UEL GEI E13 Fid Van foo TELEL LLH AF Tirini PERMI IT PASO be za mepe T bi ot ind 5 Ped Parm ee ii CERGZZHTIIPAS Vii een eee i wii 07 Lea kia 512 TA EFIE For hein POLE 1 Lbhd Pis Lice znb Then all data in the Scenario Spreadsheet tab of your Prototype Builder Excel file start integrating into the ET scenario spreadsheet Excel file After integration you can see that your building prototype data is added to the Building Inputs tab of the scenario spreadsheet ET Scenario Spreadsheet Loading aa your building prototype The Scenario Spreadsheet tab in the Prototype Builder BuSsHEdk Eae A new pad building Prototype j Is added i 4 1 a 4 DX Lr j dassa zcsdsa WazcH mNMedAu 92 2222222252228 5 70 Page ENVISION TOMORROW PLUS USER MANUAL In the Development Type Streets tab various street properties by each development type such as block size physical characteristics of streets net land reductions to buildable land from public space construction costs and so on are included Fach property can be determined by using the national averages or the local averages but users can also
58. a ET can provide several useful functions so that user can analyze existing conditions of the target site or area In the File Tools menu ET provides many analytic tools to help users understand the current conditions of the target site as well as the future changes in each scenario Among these tools the Redevelopment Candidate App and Local J obs Housing Balance function are basic and easy to use analytic tools for analyzing the current conditions and the future changes of the target site Therefore using a Meadowbrook catalytic site base map this section will explain how to use these two functions As you see in the File Tools menu there are other functions that helps users analyze the current conditions of the target area in the more comprehensive way However in order to use other tools very well users need to have more knowledge of ArcGIS Therefore other functions will be explained in the ET Advanced Group manual for those who have enough skills and background of GIS The Redevelopment Candidate Apps Tool As one of the most important indicators produced in ET the redevelopment candidate app is used to find out which parcels in a given area are candidates for redevelopment in the short to medium term This can help planners identify the parcels or neighborhoods that are ripe for redevelopment and predict which areas may be more suited for redevelopment at some time in the future It can al
59. abs which are then analyzed in this tab For example if users create the building prototype mixed with residential owner rental retail and office the corresponding ROI template input and output data are populated At the top of this tab the mixed use performance indicator provides users with a measure of each type of use within the building prototype It also shows users a summary for all rental property and separate summary for residential owner property Based on these summary performance indicators this tab shows analysis results of the building prototype as a whole according to categories the seven ROI templates includes The Mixed Use summary Tab follows the same basic calculations as the seven ROI templates with the exception that it is the summary of the applicable land uses within the building prototype Again the tabs mentioned previously are reference tabs so users do not need to enter input data Do not try to modify it The mixed use performance indicator table shows target and actual measurements of each use within the building prototype Summary tables of the applicable building uses within the building prototype are provided according to the categories of the ROI templates such as public leveraging tools Net Operating Income Analysis Debt Financing etc 24 Page A D D ENVISION TOMORROW PLUS USER MANUAL When cells in all tabs of the Prototype Builder are filled in or has their own value
60. ad a scenario spreadsheet because it does not know which scenario spreadsheet you used last time If you painted areas in the target site the work area in ArcMap will show painted areas that you did last time This means that ET only shows you the scenario you worked last time lamento ri us Ro Game bambis bumi binim mpg aim ee ahy zi d su m amp u H all meas mm PST MM a oe As you see the figure below you can see your recent work by opening your file geodatabase but your geodatabase file is not linked to your scenario Excel spreadsheet file yet Therefore you should assign your scenario spreadsheet file so that ET can link values of the scenario spreadsheet with the file geodatabase In the File menu select the Open Envision Excel File Select Die diina te le d TI we Ce moe rum L1 11 n icc UU ue ie BZ uw A X 33 a x IT Basset n L e 4 i Rare a svg E ng jw 1 r ESTEE Fani 000 jo rus r rm You can save your scenarios in the ArcMap document 104 Page ENVISION TOMORROW PLUS USER MANUAL When another window pops up select your Excel scenario spreadsheet file you worked on before In the example of this manual select the Excel file named ET Scenario Spreadsheet v3 1 BETA 022013 xlsm de Gace Prin mie b Cimi eogi b rriei a g Wi tad Pd Mosoti M Dec
61. al Setia coru Final urit 16 une in ET G shapefiles prot bypes bry uximg extention tool in Leng varius pent late i the ETa ireran through Pare awe Lasers Ehe Probotype Bkh Aran brush Tos Sor rr eel pima H Mik cor flock Dorniraints Er CA DORTuES gros Subarezs Losing buddesy Creare a fie einn scenane Comparing capui cing District ew aa DIA protocgpe E gecdataturie by ung E ears ond ecktinag of wach scenario onenig muli hehborhood Preparing tank HETH EH nibo the Eretan Pe pect peni hied ion qoas areal Peit of the fina City a Carni ET sereiuihieets pranan Arena Lahn I5 pap Suse uaria Opi for regio hma i Producing additional Socr ki pierra Cleaning up data Entering mipuli daba in COprring itr Fe Gatti by nara ET TROT vanus sores cae of Scena Pelee nnd boo te fir hem ibn Dur Corea f amp rking a en rhe ET ET system Defining dev types ups Chath mp exe dna aanumptiionm im The famines Secradvurt UEM er Adele are nm Ole tial Reiss he iran each scenario yen des mar Sek anu sues 5 Page ENVISION TOMORROW PLUS USER MANUAL Who uses the ET Just as Envision Tomorrow the former version of Envision Tomorrow Plus has been used by municipalities regional governments and private organizations around the nation Envision Tomorrow Plus can be used by these planning parties to create more comprehensive scenarios at various levels from a building to region Currently although Envision Tomorrow Plus is
62. al payroll number of paid employees and avg wage by industries _ Affordability Standards Setting up max housing expenditures Single Family Lot Size Assumptions Defining average lot size by housing types Student Generation Rates _ Number of students generated by school levels based on housing density Property Tax Annual property tax rates by residential and commercial 1 Sales Tax Annual sales tax revenues per retail sq ft Costs of new roads streetscape sewerage utilities above ground and New Infrastructure Costs i water lines Electrical Energy Fuel Mix CO2 per million BTU by different energy resources Coal Fuel etc Energy Costs Costs per 1 000 BTU by residential and commercial l Landscaping Water Consumption _ Water per sq ft of lawn area Max watered lawn area Internal Water Consumption Average gallon of water per day by building types and uses f Waste Water Production Average gallon of waste water per day by building types and uses Solid Waste Production Average Ib of solid waste per day by building types and uses _ Abandoned Structure Value _ Average abandoned structure value units acre value acre by land uses premium eren irme ert J Selecting the MSA which the target site belongs to Bag Pie hale tise Manos Gevehupnient Do tenailo Somnath i Seer is i Somnath T serai ln i ao Existing Average Household Incomes Inputting baseline information of the target site
63. allows planners to adjust assumptions in the scenario process if necessary Third by using nationwide and recent datasets ET is developed based on many separate apps and produces indicators as evaluative outputs of each scenario As a series of models apps are linked onto ET frame and indicators help users evaluate their own scenarios on a real time basis Also the main goal of ET is to incorporate cutting edge analysis in all aspects of planning for example private and public sector economics transportation and housing planning environment and sustainability quality of life and affordability Lastly operating ET begins with creating various prototypes for scenarios so the spatial range of ET can cover from buildings to regions This means that users can customize any prototypes according to the spatial scope of the target site For example users may use various building prototypes for neighborhood or district development projects For city level or regional level development block level or even county level prototypes can be used 2 Page ENVISION TOMORROW PLUS USER MANUAL Considering these features the basic framework of Envision Tomorrow Plus can be illustrated in the figure shown below Users first create building prototypes by inputting various physical and fiscal properties of each building prototypes from zoning or building regulations In the Scenario Builder each building prototype is used to create developm
64. and output cells Since the Prototype Builder is a tool for economic feasibility analysis of new development most tabs are closely related to the economic impacts of each building prototype Tabs in the Prototype Builder spreadsheet can be grouped into five major categories based on theme functions of each tab e Physical Tabs e Financial Tabs Basic Advanced Gap Financing e Building Calculator Tabs e Summary Tabs As shown in the figure below physical and financial tabs have their own dashboards that tell users goals to achieve through the building prototype All important impacts and performance outcomes of the development can be included in the scenario spreadsheet tab Prototype Builder Spreadsheet Work Area as Hem Hi Paige Limar Vater TT rire Vibe Airmhe a o m m A M i Ea i mide S Hr Tee Coral F E Parcera 3 Hanai Bpod fira z Fe dy E f eh a or A VILET p IS IIS d L F e cComorow T GORESE Fy FREGON Emision Tamortaey Return en investment Medel Yahi sat Nigel FRA E i Quick Guide Input Tab Output Tab Reference Tab 16 Page ENVISION TOMORROW PLUS USER MANUAL The Physical Input Output Tabs allow users to set the parameters that guide the building envelope of your prototype building It requires a lot of baseline information such as site building uses building form parking open space and so on Also some building or zoning regulations such as building heights setbacks
65. another while producing scenarios Users should input data from various resources in input tabs of the spreadsheets and outcomes generated by each scenario are automatically calculated and shown in tables and graphs Using some input and output data of the Scenario Spreadsheet three standalone tools allow users to compare and evaluate scenarios in terms of travel and fiscal impacts Users can operate ET without using the results of these tools but these tools are helpful for those who are interested in estimating the impacts of each scenario in certain aspects such as transportation planning and real estate development Prototype Builder Building Prototype Library Pod Engl Fidei el Dodhnd man im j a W5 s zm me T x d Leading up te 5D buking Pony ee eon conma eed echo i HousghotdiHH Travel Standalone App a mper datis Inaem fma Tia ei App Les hab 2 Ethm b Grape Bey Dico oS ao oe D Varr inda s Calcular VIT lEmeuena Ger En tonnes ET4 Scenario Builder x y m t bad s A Shaewiaed Tarr Lege unn Gui inputs a Creglsvr drgne bip based on buda pen c yes oF ari Caer renale a Chu pali Econ v Garin Dad x Mixed use Development MXD Travel Standalone App a Pei te imum ghe lia amp pp wis pa a Ettm bng infest genered Ey we Te COT HT Geer LS Mere meri Cotia VIT Emit sii by ET File Geodatabase Scenario Layers 2 ere B LA MAJOR Lua
66. as Along with the ET Scenario Builder these GIS shapefiles are integrated into one single file geodatabase through five steps of the ET Project Setup function When users go through the ET Project Setup function a file geodatabase that contains ten attribute tables and up to 7 different scenario layer shapefiles when choosing the hybrid cell option in the Step 1 is created While painting scenarios changes in land use patterns are visualized in each scenario layer and scenario planning outcomes are saved in both the Scenario Builder and the attribute tables within a file geodatabase IM a up L GE Shapetie o OTe i Laer L ENVISION PROJ GHA hAg Lite of py dixaa Cd Ard erga e Gating an Cees elem is Shadgehie tor Cana nnn SCENARIO LAYERS ECh ckirg Bus Dank Lage Barcel deg ncg Cites ird hinia PROJECT PAMET PeOgECT PhOGDCT PhDUECT a FART z ape A orbe entrer Smp CELS m MAK ACHES MIM ACHE ama x Tig Lors joa ri File x Riam eer x Hili Paes unii Ge odatabase Aner VA ann Pepi rele an a ae ee Po Pia a h S Shapes HH amp Lrgruwin Gees St ke ATTRIBUTE TABLES SCEMAHRE 1 eC Ea ZCEHABR 3 REHAS d PEELE 4 Ao o ERTIGA DUDVTTPE DEVELOPMENT EXMES TERE PELO SC E hk RC Te A VEL Lahti LSet TEA BS ATTHEEITES ETET PUTS REFERENCE Tonnage upremizhect a STEPS Subarane i i a
67. ate and local governments or private data companies Users should enter input data in the four input tabs and keep repeating this process until they create multiple building prototypes fitting well into your scenarios The important thing in producing building prototypes is that all building prototypes should follow zoning and building regulations in advance Now let s begin with the Physical Input tab The Physical Input tabs consist of nine tables that include physical properties of the building prototype users want to create By using data like Assessor s data users should define the physical characteristics of the building prototype Like the Scenario Builder all input cell and tab names are very clear to understand The following table shows detailed list of input data users should collect and enter Tables Input Cells Building Name location site area site net to gross ratio landscape area building height stories Under built Site Inputs FAR amp Density Check amp Density Checks FAR Residential density used Max FAR Max Residential Density amp percentages of allowed Building Uses Mixing the ratios of building uses ex residential commercial office Residential Unit Size Estimator Avg unit size and of units in building by housing type Residential Unit Size avg sq ft user defined average residential unit size across housing types Gross sq ft per em
68. aun tam inm m Sood puru imime i wem em SS eb rt Co E ee ee o CE mm i dad ha Mars um x LEE raram 22 Page a a Ol Template Retail ENVISION TOMORROW PLUS USER MANUAL As with the residential rental ROI template the other non residential Retail Office Industrial Hotel Commercial Parking ROI templates use the same template format The difference among these ROI templates is the units that they use to measure the size of each development For rental the units used in each development are as follows e Residential Rental per unit e Retail Office Industrial Commercial Parking per square foot year e Hotel per unit Like the residential rental ROI template various public sector supporting tools and private investment cash flow tables are used to understand how to make each development financially feasible when the building prototype contains them 23 Page Wir dtr es eure Ge fear Graa m T The units for measuring the size of development may be different but non residential ROI templates use the same format as the residential rental ROI template has ENVISION TOMORROW PLUS USER MANUAL The Mixed Use Summary Tab utilizes all seven ROI templates There are no direct user inputs in this tab from other data sources outside the Prototype Builder However they go through each individual development type analysis and enter the necessary information or data from ROI template t
69. ay check results of the 61 indicators by each scenario and recognize that some of scenario planning outcomes may not be what they expected to see In this case users should consider how to modify scenarios or correct data errors There are three cases that users consider going back to the previous steps First if scenario planning outcomes are not what they expected they may think about changing land use patterns in scenarios In this case users just go back to the step 5 painting scenarios and repaint their scenarios to get the expected results Second scenario planning outcomes may be wrong due to data users have used throughout the ET workflow process If they use out of date datasets for scenario planning they should go back to the step 2 collecting data and collect updated datasets again If the input data itself have problems they should also change their data by searching and obtaining appropriate data from external data resources Finally even if scenario outcomes and data used in scenarios are appropriate setting up wrong targets or scenario planning assumptions may affect users interpretation of scenarios In this case they cannot find solutions within the ET workflow process They should go much further back to the general scenario planning process and start discussing and establishing a set of goals and assumptions based on the current development trends or urban planning contexts STEP 7 Choosing a Fina
70. blank spreadsheets If possible it is better for users to download or get new blank spreadsheets When users prepare for blank spreadsheets using ones with input data they should remove only data in input cells Do not attempt to remove data in the reference or output tabs and cells In some tabs users can initialize spreadsheet by using a macro functions button that erase all data in the spreadsheet To enter input data for scenario planning all excel spreadsheets that users utilize in ET should be prepared as blank spreadsheets o3 Page ENVISION TOMORROW PLUS USER MANUAL Getting data for ET Scenario Planning When all GIS shapefiles and excel spreadsheets are ready users should collect data Since ET can produce scenarios at various spatial levels ranging from a building to a region the scope of collecting data for ET scenario planning can vary according to the selected geometry For example if the spatial scope of the target site is a neighborhood users may collect physical socioeconomic environmental datasets at the parcel level so that users can analyze the impact of land use changes occurred by each scenario in a comprehensive way If users want to produce scenarios at one parcel users should collect data that allows users to analyze the impact of each building use on development of a target building For region level scenario planning users collect datasets that explains characteristic
71. cenario Builder users selected in the ET Project Setup function While users paint polygons in ET these attribute tables continuously interact with the Scenario Builder and scenario layers The table below lists up the attribute tables in the file geodatabase and their functions and fields Below the table are the attribute tables seen in ET Attribute Table Name Function Lists all attribute fields that users can track by scenarios through the ENVISION_DEVTYPE_FIELD_TRACKING Attribute Field Manager function will be mentioned in the later chapter of the manual Showing physical economic environmental and financial characteristics of each development prototypes The data are imported from the Development Dev Type Attribute tab in the Scenario Builder DEVELOPMENT_TYPE_ATTRIBUTES Summarize changes in population land uses and vacant developed SCENARIO1 2 3 4 5 acres T 4 SCENARIO SUMMARY Shows changes in total vacant and developed acres by scenarios T Includes basic information of speed distance miles and time by travel TRAVEL INPUTS modes Shows existing land use categories based on the ET land use classification scheme EXISTING_LU_REFERENCE CG PEA FEE The FELE Am nnb same reis eai ri n l dsi wi bun LIESS Pa LH Ida I imj Big 1 Li sd rem Bak i mugs
72. color is removed An area to erase Symbol Development Type Click Spaced fural Reviderdial Comer nal Ohea Dari Light Inds amp trial Fare Heavy indastral The development type color is removed 1lll Page ENVISION TOMORROW PLUS USER MANUAL When you remove the colors of specific areas you will also find that output values in the Summary New and Summary Total tabs of i your scenario spreadsheet change because the scenario spreadsheet tracks all changes in your scenarios Generally you produce multiple scenarios to evaluate outputs of each scenario for shaping the more possible and better futures ET can support up to five different scenarios for this purpose If you want to work on other scenarios you need to define scenario layers in the File Define Scenario Layers menu and select the scenario you like to work on in the Edit Scenarios menu Now lets create another scenario Click the File Define Scenario Layers Scenario 2 Then select the scenario shapefile you like to use In this example select the Scenario 2 for scenario 2 scenario layer at a time It may be much better to define all scenario layers before you start creating your scenarios It may help you saving your time to work on multiple scenarios Also before you move to work on the next scenario DO NOT FORGET TO PRESS THE End Edit Save BUTTON so that you can keep the outputs of the previous sce
73. customize them based on their target values for scenarios 9 properties for the streets of each development type m zu Fa Fa zh E re T F F Pe Input cells Red and output cells white values of the Development output cells are automatically calculated based on the Type Names data in the input cells bue fe Hola Pres De mer Ra Bae lues Rubi ne feed ee li The following table shows detailed physical environmental fiscal properties of streets and blocks where users should input their data Properties Input Cells Development Type Users define their own development type names for Names scenario planning Block Size Two average block widths by different development types Number of drive lanes drive lane width on street Street parking width bike land sidewalk width total Characteristics landscaping width and cul de sac as percent of all _ intersections Net Land Reductions to Buildable Land Net land reductions for civic and park uses from Public Space Construction Costs Percentage of publicly financed roads 71 Page ENVISION TOMORROW PLUS USER MANUAL In the Development Type Building Mix Dev Type Building Mix tab you can adjust the extent to which you like to mix prototype buildings In the tab you can define up to 50 different develop ment types When you press the buttons such as 1 2 and you can see hidden col
74. d already contain baseline information of each polygon such as land use description lot size land building value years built and so on When users open a file geodatabase each GIS shapefile can be assigned to each scenario layers through the File Define Scenario Layers function Also users can edit other scenarios any time by selecting the scenario they want to edit in the Edit Scenarios menu a1 How to use the ET Project Setup function and clean up the data for the original GIS shapefile used as scenario layers will be mentioned in the next chapter BINARNI IMAP Scenario layers can be added by using the Define Scenario Layers function a ee pce Ema WE ERIS iu CRI St ee a Sy ett Scenario layers also contain the attribute tables imported from the original GIS shapefile The geography image of the shapefile is shown here 42 Page ENVISION TOMORROW PLUS USER MANUAL In producing scenarios there may be some important physical environment that can affect scenario outcomes For example if there is a river passing through the target site a buffer area within a certain distance of that river cannot be developed Also it can affect many scenario outcomes such as land use patterns around the riverfront development density accessibility and so on In ET these existing physical settings that affect
75. d click OK when you see the message A field erased is Right E Click E sa sirr Lerm 7 Tomes F Ori Peirat nbn Cher 3 E ELFELE aj Sai Fee Click a E cernis AZTME 120 Page 121 Page ENVISION TOMORROW PLUS USER MANUAL ANALYZING SCENARIOS STEP 6 Interpreting Scenarios When you create your scenarios all changes and outputs of each scenario will be written in the scenario spreadsheet Therefore in order for user to compare each scenario they should compare various outputs and values of each scenario with one another that are all included in the scenario spreadsheet As we know scenario outcomes in ET automatically calculated when users paint polygons in the target site and the painted polygons change over 60 scenario planning indicators on a real time basis Also we already understand that these indicators can be categorized into 7 distinct groups Each group can affect the overall interpretation of scenarios users produce When you finish painting all scenarios you can compare scenarios with one another by using indicators included in the summary New and Summary Total tabs of the ET Scenario Builder Results of each indicator are organized as both tables and graphs by scenarios so users can intuitively compare scenario outcomes In fact there is no single way of interpreting scenarios How to interpret scenarios you produce can vary according to your scenario planning a
76. e OFF Industrial iz IND Public Civic p PUB Educational EDU Hotel Hospitality HOTEL Utilities Infrastructure iz UTIL Agricultural AG Open Space Jo OS 90 Page 91 Page ENVISION TOMORROW PLUS USER MANUAL Also based on this EX LU classification scheme and existing condition data within the original scenario layer GIS shapefile ET also creates numeric land use fields inside the attribute table of each scenario layer shapefile through the ET Project Setup function All GIS field names in this numeric land use scheme begin with EX and their land use counts and numbers are imported from the ET Scenario Builder GIS field names and unit types that match these GIS fields are as follows GIS Field Name Double Format EX POP EX HU EX EMP EX MF EX TH EX SF EX SF SM Unit Type Population Housing Units Jobs Multifamily Townhouse Single Family Single Family Small Lot Single Family Conventional Lot EX SF MD Single Family Large Lot EX SF LRG Now let s go through the step 3 First click the Land Use Feature Layer Inputs button Then you will see menus Feature Layer and Attribute Field In this example select a parcel layer shapefile and the attribute field 4j ENVISION PROJECT SETUP Step f Proje ct Settings Siep 2 Constraints Step 5 Sub Areas Wes Land Use Feature Layer Inputs e Set s e Clear DESE XA c3
77. e Run the ArcMap Under the File menu in ArcMap select Open Envision File Geodatabase Va Y mu Chi PEC fap HE eas n gt sc EGIT alg Men h J A Gi desi i irU A d ct Oris t O AMS Dg ito HT at dioE KK e J click ay I 213298 LGB REO Urikrsreee Lied 99 Page ENVISION TOMORROW PLUS USER MANUAL You will see another window pop up at the center of the screen Select your file geodatabase and click the Add button When you select your Envision file geodatabase ET creates many tables and scenario layers under your file Therefore DO NOT DOUBLE CLICK IT AND TRY TO OPEN THE SHAPEFILE UNDER THE FILEGEODATABASE Eur ul Lun aal ar a cu me usi a e a a a EE cu T CR m M CEN T uu nu i i im ca d Ha a C o n o tm E ur Ne Be i ap ar Hl Base Data gdb T Catalytic_Parcels gdb CatalyticSiteBoundanes_27Now2012 gdb UJ Meadowbrook gdb E ET FIT Beta 1 17 13 xlx When you add your Envision file geodatabase you can find that there are many table created in the Table Of Contents part of ArcMap When you paint a certain area these tables automatically caleulate values related to the painted areas and write values by themselves Table Of Contents a x Ug DAET XData 3900 5 Demo _Site Meax ENVISION _DEVTYPE_FIELD_TRACK HH DEVELOPMENT TYPE ATTRIBUTE New attribute tables are added to Gi SCENARIO1 the file geodatabase Hg SCENARIO2
78. e o nm aw T aw T aw T aw 4 LA Veracled Per Capita Do TEXT ELO rar i Boo O00 Average Vehicle Tawri sperd MPI Pa Fat P D Ji toral and Regional Access Dentinatian amp 5 Presporile of MEP Covered iy 0 25 Mile lxilier of Transit Steps RTA EA Bys wk Pr ars Area od NOT plus 0 75 Male Buhar fugare miles 2400 o TO TO tan 2 00 Tret hog b MIAD are within e 25 NIbe Budfer of SEXE 1 1 1 1 1 i EA LN Trieiit Piopi im 0 23 Mile TaT a3 1 6 n o OF Da lE rmpilmpment within 1 Mile nf MAD Boundary E Tr Y TT E Tr YT BRL Amz Trav App ings ae ee 47 Page ENVISION TOMORROW PLUS USER MANUAL Summary Before you start producing your scenarios by using ET it is very important to understand how each component of ET works within the whole system In the ET file structure ET consists of three major components and three minor components Three major components the Prototype Builder the Scenario Builder and a File Geodatabase Scenario Layers are key parts of the scenario planning process in EIT Users cannot operate ET and produce scenarios without them In the ET scenario planning workflow the Prototype Builder creates building prototypes used in producing scenarios After individual building prototypes are made the Scenario builder allows users to import data of all building prototypes establish scenario planning assumptions enter input data and analyze the full performance of each scenario through indicators in th
79. e descriptions into the ET land use classification scheme and establish assumptions about development status of each existing land use developed or vacant As we briefly learned in the previous sections ET has its own land use reclassification scheme When you collect raw parcel level data from Assessor s data it also includes one column that briefly explains existing land use description In this step when users select the land use feature layer inputs which is your scenario layer GIS shapefile in the ET Project Setup ET automatically recognize the existing land use description Also ET ask you to define two main issues what ET 4 land use reclassification category each existing land use description belongs to and whether each existing land use is assumed as developed or vacant When you go through this step ET will add one important GIS field called EX LU inside the attribute table of each scenario layer shapefile In ET existing land use description can be reclassified into 16 EX LU categories The following table shows these 16 EX LU categories and definitions Existing Land Use Classification ET EX_LU GIS Name Mixed use MU Multifamily Jo MF Townhouse E TH Single Family Small Lot SF SM Single Family Conventional Lot B SF MD Single Family Large Lot SF LRG Mobile Home E MH Retail n RET Offic
80. e in the parcel shapefile L rr i E af LL aE L Bc e b d biasdimpck Pareh AE Tii ted eee vel el D JE zai Irem T abii m perm abii uw ET a P siidi Phil HI ahi lai T a cde EM mau o 9I e EI ace ER Y EDO MAE TA mh ee Tear LTSEITTUE me ie IHIT EIN L5 XD Gay 3212215 BBE TIOTA BEBET T34TRT vise HA aui MIA MEUS Madras eh tor 208 LUN Iesu 243078 riaja ky FATE dui Manca ford Egger Hg PES ee se dE Larr ETE Hah Lange P cue Mes cde Tanz T acu Deel Cangas l arer DEAETE rpi py Deere 128 Page ENVISION TOMORROW PLUS USER MANUAL In the Depreciation Appreciation method ET calculates the redevelopment year by using the following equation Redevelopment Year Improvement Value Land Value Improvement Value T Land Value x Building Lifespan Current Year Ef fective year Built Land A i i Current Year With this complicated equation there are three conditional statements for calculation of the redevelopment year as follows 1 If land value is Errare than im ovement 2 If 1 the current year r minus effective ctive year b built is UE than the building lifespan then the redevelopm a unknown The result is 0 The building could be historic 3 If the current year minus effective year built is equal to the building lifespan then the redevelopment year
81. e two Summary tabs When all major excel spreadsheets are ready users create their file geodatabase consisting of scenario layers GIS shapefiles and attribute tables While painting polygons using the ET paint tools users can find that scenario outcomes in the summary tabs of the Scenario Builder change on a real time basis Three standalone components the Household HH Travel Standalone App the MXD Travel Standalone App and the FIT Standalone App are optional tools but they help users understand performance and impacts of each scenario in term of specific issues such as transportation and financial planning Input data are imported from the two Link tabs in the Scenario Builder and users also enter scenario planning assumption data to make these tools work If you understand this chapter well you may be ready to go to the next chapter Based on the ET scenario planning workflow the next chapter will explain every detail of how to collect and enter input data in each components how to paint scenarios using ET However while following each step in the next chapter going back to this chapter and reading this chapter are recommended because you cannot understand what each step means in the ET scenario planning process without understanding each component and the relationship among them 48 Page 49 Page ENVISION TOMORROW PLUS USER MANUAL SCENARIO PLANNING IN ET As mentioned in the Introduction the ET workflow c
82. e window you should select your polygon dataset It is the shapefile you just added in ArcGIS Also define a buffer distance In this example let s keep the default buffer distance value ai Local Jobs Housing Balance App ci mm Select your polygon dataset Ee Defme Buffer Distance 3 Select Employed Residents field Select Workers freld Select Avg Income of Residents field Select Avg Income of Workers field Legend Classification 9 Job Workers Balance Income Balance Then select the employment residents field When you open the attribute table of this shapefile you will find a GIS attribute field called ResWorkers Select that field ENVISION TOMORROW PLUS USER MANUAL do ee oe yoo XL es Select Employed Residents field Select Workers field m Select Avg Income of Residents field x Select Avg Income of Workers field Legend Classification A Job Workers Balance O income Balance Next find the Workers field in the attribute table and select it dem ox D T m E emn LES WIS OK Kun UK arm TE CEEOL SALIM n b MAE ions TILE E che REE as x qo a iLLELILIA JI IE I j I NE ote tat tari ffer Distance 3 Select Employed Residents field FasWerem sanc wore tea mem Select Avg Income of Residents field
83. ect costs 1 634 278 sudden zi 25 2h PAHKING amp OPEM SPACE CONSTRUCTION COSTS EJ Residennia p arking ipacesperuniT 1 00 Parking Contruect on 28 Retail parking spaces per 10000 4 00 Surface 3000 pars 2n Offic parking ipce par T0048 M A Sriuctur d Above ground 10 000 ipyace 30 Total parking spaces 11 Underground 35 000 pace 1 Landicaping and open space area p V uck Undet 20 000 space 32 Building Corrtructiorr 11 Revidential 100 fst 34 Retail 5100 ssf 34 Office 295 fil Trew drin lew bere ere oor sere a rmm m pene rmm ril an ul koci bie 3B H 4 H Quick Start Guide Physical Inputs Mise Financial Advanced Financial Resefential aner Resdertiol Rental 25 Page ENVISION TOMORROW PLUS USER MANUAL All input and output data that explain physical and financial properties of the building prototype are also summarized in the Scenario Spreadsheet Tab This tab summarizes all input and output data necessary to export to the Scenario Builder in one long row The categories and values imported to the Scenario Builder are as follows e Building Square Footage Mix by building uses e Residential Physical and Financial Inputs and Outputs the number of units housing type square footages sales prices etc e Employment Total J obs per Acre e Non residential Physical and Financial Inputs and Outputs e Commercial Parking Parking Inputs and Outputs Parking Spaces Parking square foot Parking space construction cost
84. ed to focus on for their scenario planning because they should find the relevant data from various sources and enter them manually based on the goals of scenario planning If users want to remove all data in this tab they only press the Clear Street button at the top left of the spreadsheet Using the Clear Streets button users can remove all street data in the tab Het Land Reduction to Land Public amp Tora in amp ersorica 1 Die Eli Sti Ewa x Mes per serenity pst er Acre per Sq Wi hera ig Mi Sine Paving 1 Sa Fi iper ETER Total beck o m Onaga A Tetal z Cul de 43 ai Ferel Users should find information and data to fill in these input blanks They should enter the data manually Exstng Piire Vrsrng Heuang amp Incsma Poking Faun Huista bed teers Chea Types Sireta Caw Type Open Saace Oey Type Bulking Mx D Type armii A Pe ea Ee orna 30 Page 31 Page ENVISION TOMORROW PLUS USER MANUAL The Development Dev Type Building Mix Tab allows users to create their own development types by using input data from the Building Input Development Type Street Development Dev Type Attributes tabs Development type names are automatically imported from the Development Type Street tab Next to the Development Type Name column this tab also imports several basic development potential data such as average densities by housing employment types and land use mix from t
85. ed in response with the painted area This means that users can tie the scenario results to the community values guiding principles and future goals they developed at the beginning of the scenario planning process This is also why ET is very useful and effective for scenario planning Since all variables and datasets in ET are automatically tracked and calculated users can track all indicator results on a real time basis In particular the two summary tabs Summary New and Summary Total tabs in the ET Scenario Builder provide 61 indicators that allow users to understand the impacts of each scenario in a comprehensive and accurate way These indicators are divided into seven categories 15 indicators for transportation 13 for economy 10 for housing 7 for environment 5 for baseline information 2 for growth and 2 for land use What indicators ET has and how to interpret them will be discussed in the next chapter of this manual by using scenario examples Also You can download the Envision Tomorrow Scenario Indicators Apps User Guide from the website http www frego com etwiki lib exe fetch php mediaz indicator onesheets mar2013 pdf Example Outputs of Indicators in ET Housing Mix SELE fie ahs 3 ME I EE i5 jii Distribution of Employment Space baim bekam Coe p M wc i ey Mite 14 Page The Prototype Builder soreadsheet is included in the zipped file of the ET software The
86. eld names imported from external data resources like Assessor s data can be different in The key thing here is that users should collect appropriate datasets required to operate ET and enter those data by adding GIS attribute fields To figure out how to edit attribute tables please check the ArcGIS tutorials or books ee the table shown in the previous page However it does not matter When users go through the ET Project Setup function to create a file geodatabase ET automatically generates additional GIS attribute fields in the attribute table of the scenario layer shapefiles These attribute fields contains information about existing land uses reclassified by the ET land use classification scheme numeric land use counts and basic demographic and economic properties of each land use reclassified in the ET land use scheme These attribute fields are generated based on data users collected and physical properties of painted polygons Also these data are sent to the ET Scenario Builder spreadsheet and used to calculate outcomes of 61 indicators defined in the Summary New and Summary Total tabs of Scenario Builder How to codify raw land use descriptions into the ET land use classification scheme and details of the ET land use classification categories will be mentioned in the next section LIJBRIRIDIIPDIDCTISEI LS IISN TI g SE 1 i J a Existing land use description from
87. elopment gma Lot Song Conwenbonal LA Lange Let Seale Mhina Tonia Singe Farndy z E um E Pay fet ET ALL All development type attributes are set up in one single row aie Land Use Gating Gewelnpead iud Gang deat atng Housing amp eae Dey Type Artrieutaa fielding Fout Meuriauai and Incerma wy Tec Streets Der Tapa Dosen Spats Dev Tree Buking M AE re i 36 Page ENVISION TOMORROW PLUS USER MANUAL The Existing Developed Area Tab helps users figure out how much each scenario changes land uses in the target site and bring about additional redevelopment by painting polygons within the site The total acres of painted and or redeveloped polygons are calculated by existing land uses and arranged by scenarios In this tab users first enter input data about existing developed acres by existing land use categories These existing developed acres and square feet by land uses are also used as the Unpainted Unchanged acres and square feet in the Scenario 1 5 columns The Painted Redeveloped columns of each scenario are automatically calculated when users paint polygons in the ET software As shown in the figure below ET provides its own existing land use categories Therefore when cleaning up their land use data at the beginning phase of operation ET scenario planning users should reclassify their existing land use descriptions into the ET classification scheme The ET existing land use classification are als
88. enario Builder and the painted areas the Output Tabs allows users to get detailed scenario outcomes and analyze their impacts on the future growth of the target site When users paint the areas the output tabs automatically calculate expected outcomes according to multiple indicators that are already developed through 20 different ET apps These indicator outcomes are shown as tables or graphs within these tabs The EIT Scenario Builder provides the following tabs e Summary New e Summary Total e Detailed Analysis Results of Scenarios by Development Type SCENARIO 1 5 e Detailed Building level outputs of Each Scenario BUILDING 1 5 e Proximity Among these tabs tabs that users should focus on are the Summary_New and Summary_Total Tabs All 61 indicators that analyze the full impacts physical socioeconomic and environmental aspects of scenarios are located in these two tabs Therefore when users paint the areas using ET Paint Tool in ArcGIS they generally spend most of their time and effort understanding changes in numbers and graphs of indicators Based on changes in numbers and graphs users can answer the following questions while they produce and modifying scenarios e Howare scenarios different from existing conditions e Considering scenario planning goals do indicators show right direction that you expected before producing scenarios If not what do you do to correct changes e Assuming t
89. ent types Development types are created by mixing various prototypes users produced and serve as a basic unit for painting scenarios In the ArcMap users open their scenario file geodatabase and paint their own scenarios by coloring the target areas When users paint parcels or areas the Scenario Spreadsheet automatically calculate the full impacts of the painted areas in terms of physical environmental economic and social aspects The full impacts of each scenario can be illustrated as many graphs for each indicator or tables with values Generally the procedure of operating ET has linear characteristic but the process can be iterative depending on scenario planning assumptions or conditions Users can add or edit prototypes while painting scenarios and change their development types anytime Changing properties or values are automatically reflected into indicators or outputs of the scenario spreadsheet on a real time basis Building Prototypes Development Types Scenario Painting Indicators Prototype Builder Scenario Builder ET GIS Extension Tool Scenario Builder Dew Jn P iu Thematic Mapping ENVISION TOMORROW PLUS USER MANUAL When is ET used As a scientific and iterative decision making process scenario planning generally consists of five steps defining problems gathering data generating plan evaluating choosing plan and implementing plan Based on this procedure the scenario
90. envision Target Users Readers Introducing ET Overview of Apps Indicators and Scenario Spreadsheet Details of Apps Indicators and Scenario Spreadsheet Understanding the Basic Structure of ET Base Map Data Mining Techniques Inputting Data in the Scenario Spreadsheel Using the ROI Model Basic Operation of ET Opening files Using the ET Project Setup Painting Editing Scenarios Attribute Field Manager Interpretation of the Scenario Spreadsheet ET Tools e tomorrow ul BEGINNERS MANU AL Citizen or people who are not familiar with ArcGIS and ET T Using Parcel level and Neighborhood level Practice Examples Only Summary Tabs Only Buttery Feature 5ummaries Redevelopment Candidate App Local J H Balance Only Comorow ADVANCED GROUP MANUAL Professional users who have background of both ArcGIS and ET sses i Using Examples at All 5patial Levels Parce Neighborhood District City Region All Tabs Explaining All the Other Tools 7Ds 1 to Many Export Attribute Aggregation to Neighborhood etc TABLE OF CONTENTS INTRODUCTION What is the Envision Tomorrow Plus ET 1 Basic Features of the ET 2 When is the ET used 4 Who uses the ET 6 BASIC COMPONENTS OF THE ET ET System Framework 8 Tabs and Cells in ET Spreadsheets Apps and Indicators in ET 11 Prototype Builder 15 ET Scenario Builder 27 ET File Geodatabase 41 ET Standalone Tools 45 Summary 48 CREATING SCENARIO
91. etermined in the Scenario Builder file Based on the definition of tabs and cells in ET all tabs and cells in the ET Scenario Builder can be categorized into the three basic tabs and the five cells The Scenario Builder input tabs represents physical social and economical properties of all planning dimensions and the reference tabs contains baseline information of current conditions within the target site Work Area Inputting Editing Calculating Data Dir eaves porr mal w pem ceil KE Roe e s w 2 IgE icr ee ae Bod 8 mA mw m diee a t fe em mji meem ehi E envision e Lomorrou Introduction Input Tab Reference Tab Output Tab Quick Guidelines Entering physical social nputting information about Includes calculation characteristics used in existing conditions results of each scenarios scenarios 27 Page ENVISION TOMORROW PLUS USER MANUAL Input Tabs In the input tabs users can define the planning geometry enter the baseline data and set up their assumptions for scenario planning The input tabs of the ET Scenario Builder include the following four tabs e Project Info e Building Inputs e Development Type Dev Type Streets e Development Type Dev Type Building Mix When users open the ET Scenario Builder for scenario planning they generally start working on the input tab called the Project Info Tab The Project Info tab allows users to establish a set of baseline data and scenario
92. eum x ARRET ag eee DA Fosw TU tmd Pe ee rt A DOu 3 7 Rahs E wc ice shia ly Linke anil ama B oom on ELATI STR LE ll eoi The SCENARI table SUMMARY ma am om the S If you want to show more tables that you saw in your first opening your file geodatabase you can right click the file geodatabase filename in the Table Of Contents window and select the Add Table Then another widow will pop up at the center of the screen By clicking tables you can choose whatever table in the file geodatabase you want to add Table Of Contents ax Click EB Metropoltan Certe EH Urban Center EN Town Center Commentby Canter Rural Village img Mhulr Farmby Bexsdentud mu Traditional Neighborhood O Munster Flenmed Coremunsty E fumglm Fasnisby Facsidandtial 0 Mobile Homes Spacad Rusa Pairdentud EN Commercial gm Office Park EH Light Industrial Ale B Hery Industrial ED SCENARIO SUMMARY aa Tu z 106 Page 107 Page ENVISION TOMORROW PLUS USER MANUAL STEP 5 Painting Editing Scenarios Once you finish all preliminary settings mentioned in previous chapters you will be ready to paint and develop your own scenarios Actually after all preliminary settings are done painting your scenarios is very simple and easy This section will explain how to use the paint tools in ET and edit your scenarios Painting Areas ET provides multiple paint brush options The paint brus
93. f the polygons by building prototypes Outputs in this tab are as follows e Physical Properties of Each Building Prototype Acres The Estimated Number of Buildings e Demographic Properties Household e Economic and financial Properties Employees Employment Square Footage Parking Subsidy Tax Revenues etc e Sustainability Properties Energy Use CO2 Emissions by building prototypes etc e Residential Units Square Foot Hotel Rooms As with the other output tab all outputs in this tab are automatically calculated and tracked on real time basis All outputs for the painted polygons are arranged by building prototypes Demographic physical economic and environmental aspects are summarized by building prototypes used in the scenario TEA Feah brg peir Da Ta Boer Qu Type ig a Bn Tpm iay r ee eae se ee arme manap ro meer tr mun T UY Gm gb ee eee 34 Page i ENVISION TOMORROW PLUS USER MANUAL Occasionally the target site where users produce scenarios may have various kinds of existing amenities that attract more residents or employment such as open spaces urban parks public transit or streetcar lines and stations and so on Depending on scenarios development types of parcels blocks or districts within a certain distance of these amenities can affect residential and employment density These density changes can have positive or negative influence on the future physical socioeconomic and en
94. h tool is placed beneath the menu bar as an icon and you can choose any brush tools to paint your scenarios When you click the a little triangle mark v the following paint brush tools will be shown e Point Brush P e Rectangle Bru sh Ed e Polygon Brush amp amp e Circle Brush J e Polyline Brush 29 Any one of these five tools have the same function painting areas that overlap the shapes or paths of the paint tools so you can choose whatever you like to use for painting areas Perhaps which brush tool you use to paint scenarios may depend on the shape of the areas you need to paint Now let s paint the areas to produce your scenario Run ArcMap and select File Open Envision File Geodatabase If you open your file geodatabase for the first time ET performs several things like adding scenario tables to your file geodatabase and you need to select your scenario spreadsheet and scenario layer you like to edit If you open the file geodatabase you have worked on before choose File Open Envision Excel File Select to open your scenario spreadsheet and select the scenario you like to edit in the Edit Scenarios menu Just in case keep your original file geodatabase and scenario spreadsheet as your backups Sometimes you may start your scenario planning from the scratch In that case your original files will be very useful Also using two monitors is helpful with painting scenarios so your sce
95. hat scenarios are realized what direct indirect impacts is the target site expected to occur Are they positive or negative impacts It usually takes a lot of time and efforts for users to understand the relationships among all indicators and interpret them based on scenario planning goals Detailed characteristics of the 61 indicators mentioned above and how to interpret scenario outcomes will be mentioned in the Chapter 5 Analyzing Scenarios 32 Page ENVISION TOMORROW PLUS USER MANUAL If users want to understand more detailed impact analysis of each scenario the ET Scenario Builder also provides the Detailed Analysis Results of Scenarios by Development Type for Scenario 1 through 5 When users paint areas this tab arrange changes occurred by the painted areas according to development types The following output data are estimated and written e Demographic changes in the painted polygons population children household employment housing etc e Change in Land and Building Value e Lost in population children employment value etc e New acres consumed e New population children household e New housing units by type e Hotel Rooms e New J obs e Employment Mix by industrial type Retail Office etc e Sustainability Energy Use GHG Emissions Water Consumption etc e Parking e Financials Land Cost Subsidy New Road Lane Miles Property Sales Tax Revenues etc As with the summary tabs
96. he Summary New tab shows only the impacts of new development the Summary Total tab incorporated existing housing units jobs population and land use to show the total impacts of a scenario ET has 61 indicators and both tabs consist of indicators that show outputs of scenarios based on the definitions of each tab The indicators in these tabs include the following Indicators Summary_New Summary_Total Population e e Net New Population Displaced Population School Aged Children Average Household Size People per Net Acre Housing Units per Net Acre Developed Acres with 96 Infill Development Land Area Mix Land Mix Score Entropy Land Use 5 Building sqft Mix Building sqft Score Entropy Average Floor Area Ratio FAR Walk and Transit Friendliness 0 1 scale Parking Spaces Parking Spaces per 1 000 sq ft of Development Parking Lot Coverage Transportation Parking Cost as Percent of Building Value 15 New Road Land Miles New Road Cost Walk Trips Transit Trips Vehicle Trips e Baseline Info 7 Growth 2 122 Page ENVISION TOMORROW PLUS USER MANUAL Indicators Summary_New Summary_Total Internal Trips e External Trips Vehicle Miles Traveled VMT Mixed Use District Travel VMT per Capita ULI Shared Parking Savings Employment Mix Employment by Type e Net New Jobs Displaced Jobs Job Housing Balance e Jobs per Net Acre e Household Income Needed to Afford the Average Home Cost i
97. he Building Mix and Development Type Attributes tabs The development types can be created by mixing prototype buildings loaded from the Building Input tab In the top of the spreadsheet the Development Type Building Mix tab shows users what building prototypes exist in the Building Input tab To create development types users assign percentages to each building prototype until the total percentages of the Building Checks column is 10096 This means that the total square footages of each building prototype are allocated by multiplying the total square foot of the development type by the percentage of each building prototypes Let s say you create the mixed use urban center type with a combination of 4096 of commercial and 60 of office When you paint the 10 000 square feet area for this development type it means that 4 000 square feet of commercial use and 6 000 square feet of office use will be assigned for this area Development type names are automatically imported from the Building Input tab Basic development type Building prototype names are automatically information and data come loaded at the top users can create development from several other tabsin types by inputting percentages of each individual E Drake pran Dew Typesa Duy aig Prints Maitre the ET Scenario Builder building prototype to be mixed in the development type ENVISION TOMORROW PLUS USER MANUAL Output Tabs Based on input data in the ET Sc
98. he featureclass attributes and scenario household 7D apps spreadsheet 56 Page Editing the scenario ENVISION TOMORROW PLUS USER MANUAL As shown the figure below The Subareas menu also has three separate sub menus Allowing users to zoom into user defined places to create more detailed designs and track outputs for the area This will be explained in Chapter 3 Selecting subarea names Zooming to the location and performing a Quick Sync to update the scenario spreadsheet values for that smaller area Select Subarea Field Select Subarea Clear Subarea Definition Clearing all user defined smaller areas Beneath the menu bar there are four icons that are used for painting scenarios and editing a scenario spreadsheet The following figure explains definitions of each icon The Painting tool includes several sub functions to help users paint their scenarios easily spreadsheet You can choose saving not saving changes ii Mite to Soredihud OH E Enable to write to the babe basi Applying scenario spreadsheet changes in the IS Wiha be Speesaiaat OFF Map me E t xl Disable to write to the scenario Pob ch scenario spreadsheet spreadsheet e Synchronizing only a painted parcels cells Apply Start Edit nO Point Brush Paint all parcels areas where points are placed Polygon Brush Paint all parcels areas within a polygon
99. he right Like this example if the input parcels fields are already organized based on the ET numeric land use classification scheme you do not need to go through this step For now you do not need to follow the figure below It is an example of how this step is operated Listing up input parcel field names included in the attribute table of the original scenario layer shapefile lc ic Rea Units Res F Land Val Imp Val T i Val HRSF Footprint Im a Acres FA ID EX WU EX MF m EX TH EX Sf EX SF 5M Ex SF ND tX 5f LRG EX HH EX EMP EX RET EX OFF EX IND Select t Existing Condition Field Name Man Input Parce Field NE 2g 93 Page Ewing Condsons Mach Field B M iii L LLL A OOoe EOO A Vec_ ACRE DEW ACKE EX LAWD VAL EX RE amp VAL EX OOM VAL EX POP Selecting the ET existing EX 5CL CHLDRN E EX HH conditions GIS attribute fields that matches the input parcel EX TH field names EX 5F iA nbi 7 ENVISION TOMORROW PLUS USER MANUAL Step 5 Subareas Subareas are areas that users like to focus on in producing scenarios Also when the target site is located across several different jurisdictions it can be divided into several subareas based on the number of jurisdictions where the target site is located As the last step of the ET Project Setup function the step 5 allows users to add subarea layer GIS
100. her window pops up Go to the folder you like to use as a workspace directory and click OK You can create a new folder by using the Make New Folder option In this example make a new folder called test select that folder and dick OK rm E ge Removable Disk k P 201 308 1 7 PAD fer Fall 2013 d 20130820 Research Proposal Funding Incentive Seed Grant Program Je QUISIOOZ Readeng Matenals about Scenario Planning Ji Quixars 18 T Certificate Training Sessions A ETe l a ET Sample Data Broar For Fader CUI 1 t ET bAaster Data Laver select tat zi E Streetcar ET Example Ucf Base Data gdb ol CD Deve d Jo GE Data a am armis Deck Lij je MacterParcelt gdb d QUIXM lI FRO fos Fast 201 k Prototypes hasterParcels de UEM eaae Prepared Fandag Ims entice Sac oriri Priim jj wee de LOS rade Mate aer hemes Penang d BOLE MT Certifec Ting letter Jp Library Free Workthopes Preparations au Je MasterParceis gdb b Ts impa Dota r Je Materials Data about Economic Resilience de KT Meter Data Leyi 4 jo Brai ET xaenqia Url di Bis Data git A Ri fete Create a new workspace folder i win de ldem ti roa Fha teca a 1 ete qe ENVISION TOMORROW PLUS USER MANUAL Then name your new envision file geodatabase In this example let s call it Envision Project Test In ArcGIS it does not recognize the space So your file geodatabase should no
101. ibutes are included e Physical Properties Lot amp Structure Parking Street Characteristics Housing Mix Housing Density Land Development Square Footage etc e Economic Financial Properties Employment Financials Subsidy Tax Revenues etc e Environmental Properties Sustainability Energy Use CO2 Emissions Waste Water etc e Social Properties Affordability Household etc Information of each development type is written in this tab in one row When users open the File Geodatabase the Scenario Layer file in the ET software and link it with the Scenario Builder this tab serve as baseline data so that ET can analyze each scenario by calculating various indicators based on attributes of each development type Also ET recognizes the RGB color data included in the Symbology Color RGB column of this tab and assigns each development type to different colors Yaca Gros Density Roday Groa Density Jee eee eee PPT 2 e m mj m T E D Prejaet tfc Boling ipo Des Tepe Sresti Dev Tyee Buking Mi LI r Development type names are imported from the Dev Type Streets tab listed up in one large table All development type attributes are set up in one single row 38 Page z E Existing Energy and Carbon Pias iem ua Rumi Residential Energy Coefficients Commercial Energy Coefficients aod 39 Page ENVISION TOMORROW PLUS USER MANUAL The five reference tabs
102. inations this indicator is measuring person destination match ET automatically tracks the balance of both existing and new jobs and housing within the scenario layer Users can zoom into particular subareas cities or neighborhoods for assessment of localized jobs housing balance Now let s operate local jobs housing balance tool As with other GIS shapefiles in ET you should check your scenario layer GIS shapefiles to see if there are GIS fields for the number of housing units and jobs in the target site In this example let s add the Shapefile in the blank ArcMap document You can click the Catalog button at the right of the ArcMap screen go to the file click it and drag it to the ArcMap workarea D im E nn M GEO e a lis a d am notum AO Ej 1 whe uU 134 Page au IEUUENETSAA uppppmpmp Click and drag ith N E a a tT eel aia 135 Page ENVISION TOMORROW PLUS USER MANUAL Now go to File Tools Local jobs housing balance in the ENVISION PAINT TOOL not the File in ArcGIS ie m T TA 1 A x Tat 4m T 5 J mM i E Click A new window pops up In the window there are several input fields users should define Also at the bottom of the window you will find that there are two options in the Local J obs Housing Balance tool Jobs Workers Balance and Income Balance For now let s analyze the J obs Workers Balance First at the top of th
103. ine Scenario Layers to designate scenario layer amp Click lO2 Page ee a ENVISION TOMORROW PLUS USER MANUAL To define your first scenario layer select the File Define Scenario Layers Scenario 1 in the Envision Paint Tools When you select the Scenario1 you see the scenario shapefiles you included in your file geodatabase by using the ArcCatalog Select the shapefile Then ET will remember your selection and add the Scenario 1 shapefile to the Table Of Contents window of ArcMap Also in the Table Of Contents window and the Envision Paint Tools symbols colors for each development are shown File ka Open Envision File Geodatabase 1 Scenano2 m i Scenario 3 Open Enviceon Boce File Scenario 4 t ScenanoS Synchronize Data i Arinbute Field Manager Ernii n Temerrew Plus v1 0 Dausa n KANO it gt er ce aj au E ermm Ei 103 Page lem E 8 Ded arg REN Dee Sap dna i a ee eS aio rhum a ESR Ia amp d EE k Ta i Dmie Pee Tue a jreiierergm tie h ae n g mu inn A TELET PLLEZOCC NOB Fa ENVISION TOMORROW PLUS USER MANUAL If you open your file geodatabase that you already edited before ET does not create scenario layers or tables again because you already made them when you open your file for the first time Also ET does not automatically lo
104. ion To understand how to use a clip function check ArcGIS tutorials or books Site Boundary Parcel Layer Constraints Satellite Image Optional LU TEILTE S pow F 1 L1 ey u Mfg ihe LES D iri F fen Ln ate DIT aig ER ak L B E TOTU aor NL 62 Page ENVISION TOMORROW PLUS USER MANUAL Preparing ET Spreadsheets Along with GIS shapefiles users need to prepare for ET excel spreadsheets so that they can enter input data in the next step To operate ET users should prepare for at least two blank excel spreadsheets Scenario Builder and Prototype Builder spreadsheets Users can download these blank excel spreadsheets in the Envision Tomorrow website http www envisionto morrow org For building prototypes users may also download the building prototype library package which contains 50 possible building prototypes via the website Fven if Scenario Builder and Prototype Builder spreadsheets already contain input data or numbers users can only erase these numbers or data to get blank spreadsheets Some tabs of ET spreadsheets have an excel macro function button that allows users to erase all data within the tab If users want to analyze their scenarios in terms of transportation and fiscal aspects they also need to prepare for three blank standalone app tool spreadsheets Preparing for blank spreadsheets from used ones is the last thing that users can choose when they cannot get
105. ion File Geodatabase Define Scenario Layers Open Envision Excel File Synchronize Data Attribute Field Manager and Tools The following figure explains functions of each sub menu Before opening an Envision file geodatabase the five submenu functions Define scenario Layers Open Envision Excel File Synchronize Data Attribute Field Manager and Tools are not activated e o e umo nem uem uem emo uem umo uem i mo mo mo d The next two chapters will explain in detail about how to use these functions in producing scenarios in ET Open Envision File Geodatabase for creating scenarios Define Scenario Layers Open Envision Excel File Synchronize Data Attribute Field Manager scenario layer D a A Envision Tomorrow Plus v1 0 scenarios EGE IST Allows users to define which attributes of the development types are written and tracked in the Opening a parcel level or polygrid GIS file geodatabase Choosing scenario layers within the geodatabase you want to work on up to 5 scenarios Defining a scenario spreadsheet file you like to work on When you paint areas in a scenario the spreadsheet automatically updates information of the scenario Quickly ensures that the scenario layer matches the results displayed in the scenario spreadsheet Tools for analyzing physical or socioeconomic features of 54 Page ENVISION TOMORROW PLUS USER MANUAL Under the Open E
106. is the current year Otherwise the equation results in a divide by zero error In the Bottom Quartile Method select the Bottom Quartile button at the top of the redevelopment candidate window and a parcel layer to use Select the other three fields and define how many class breaks you want to have Click Run and you will get another thematic map of redevelopment candidates in your target site ijj Redevelopenent Candidata Redevelopment Candidate Method Depreciation i amp Click Select Parcel Layer Meadowbrook_Parvets ACTIVE Select Effective Year Built field Select a parcel layer Select Improvernent or Building Value field Select Land Value field TA Enter the building value land value and square footage fields and Enter Current Year 4 digi wa determine the number of class breaks Select Square Footage field Enter Mumber of Class Breaks Enter Building Lifespan Enter Annual Land Appreciation 200 o per year us ETII amp click 129 Page ENVISION TOMORROW PLUS USER MANUAL Cea a nz de oia RRR o Dee RU Oe ae om U eiue Eal a Fo DO A A T uc Fm T Rae tae gn ee ay 5 s hm 7 Bii a ispi Baiji ii Symbology for the field Val per sqft is created tT As shown in the above figure vou can find that a new field called Val per sqft is added to the parcel layer To check the result right click the parcel
107. itional Neshborhood 7 Click Eh ie ea ee es Mob e Homea iSpaced Rural Residential Commercial Office Par Light idurira Flex Heavy ldustnal Click Circle Brush One of them Polyline Brush Spaced Rural Residential Commercial Office Park Light Indusirial Flex Heavy induatreal 108 Page ENVISION TOMORROW PLUS USER MANUAL Now using the paint brush tool the rectangle brush tool in this example adjust the size of the brush tool shape by holding the left click and cover the area you like to paint The covered area will be painted by releasing the left click Adjusting the size of the The area painted brush tool shape Repeat this process for other areas until you complete your scenario The figure shown below is a scenario example 15300075889 74159513733 Fel 109 Page ENVISION TOMORROW PLUS USER MANUAL Tracking Changes in the Scenario Spreadsheet As a scenario planning tool plugged in ArcGIS ET can produce various outcomes of each scenario you create by linking the file geodatabase with the spreadsheet Therefore when you paint the areas in the target site shown in ArcMap ET automatically calculates different values These changes will appear within the scenario spreadsheet Based on the last figure in the previous section let s say you want to paint additional commercial area like the figure below By selecting commercia
108. jecien MAD 1927_SintePlana_Utsh_Central_FIPS_4302 Kk parcel layer should be Enter your new file geodatabase name for scenario planning in 86 Page aj ENVISION PROJECT SETUP Step gt Pract Seis Slap 2 Constants Stag 1 gen 3 Sube ae ee ee ee Ernwrsion Project Workspace Directory J4ET _Sormole Data Sireetiecar_ET Exnmnle Lic Mew Envision File Geodatabase Marne Enver _Prejees_ Tad Faature Source Parcels res Grid Call ce Select Parcel Layi Parc Liper Marrum Parcel Sine 10 Agrela Setect the Project Extent E Dumani Yeaw Extenl Piere Laser Enter uiui Select Envio Excal Fide Data Frome Projection HAD 1927 BiuaePune Umh Cena PEE A307 87 Page Cid Geliy i Foot 1 ENVISION TOMORROW PLUS USER MANUAL Based on GIS shapefiles added in ArcGIS you can choose the project extent There are three options you can use for the project extent the current view extent that allows you to set up the project extent based on the current ArcGIS view the parcel layer extent that decides the project extent based on the scope of a parcel layer shapefile and the custom option that users define the project extent by inputting x and y axis coordinates In this example select the current view extent for your convenience Select the Project Extent Current Vige Extent Upper X 189731807547283 Upper Y 889089 218894168 Parcel Layer Extent PP ai Lower X TERZA
109. l Scenario ET supports up to five different scenarios so in the long term users should select one final scenario that meets their goals and assumptions In this aspect we can say that ET is a highly personalized scenario planning tool because users only need one computer with ET software data and excel spreadsheets At the individual level each user can choose one final scenario based on questions mentioned in the step 6 Interpreting Scenarios If each member of a group operates ET they may have a set of final scenarios each member think about In this case ENVISION TOMORROW PLUS USER MANUAL members in a group can discuss choosing the best scenario among these final scenarios Maybe an organization such as local governments may operate ET In this case a lot of discussions and feedback will be exchanged among members of an organization or between an organization and citizens outside the ET workflow process Through a wide range of discussion and negotiation among each interest group one final scenario will be drawn in the end In any case ET can be used as a comprehensive and effective scenario planning tool to estimate the full impact of scenario on a real time basis and reach consensus quickly Although ET does not cover the entire scenario planning process it can serve as a medium that helps both people and planners share their information and knowledge with one another to think about the possible urban futu
110. l symbol as a development type and covering that area with the paint brush tool you can easily paint that area to add more commercial area Then what changes will be occurred in the scenario spreadsheet You may notice changes throughout the scenario spreadsheet but you can see the difference more easily in the Summary New and Summary Total Tabs For example developed acres of the scenario T in the Summary Total tab will change based on the size of the new painted area A new area is painted Developed Acres Existing Scenario 1 Existing m Vacant Land Developed Acres Scenario 1 E New Vacant Developed Land New Developed Infill B Existing Developed Acres 110 Page ENVISION TOMORROW PLUS USER MANUAL Editing Scenarios This section will explain how to edit your scenarios As a user friendly scenario planning tool ET provides following editing functions so that users can edit their scenarios easily e Erasing the painted areas e Choosing a new scenario layer and painting it e Synchronize Data Menu Quick Sync Full Sync Existing Condition Sync e Using Attribute Field Manager When you have areas to erase their development type colors choose the ERASE symbol at the top of the development type bar Then place the mouse arrow on the area and select the area by holding the left click and dragging the area When you release the left click button you will see that the area
111. lopment Candidate Method Depreciabon D Bottom Quartile Select Parcel Layer Meadowbrook Pomes ACTIVES Salact Effective Year Bast field f yesi Selecting fields Select Improvement or Building Value field gaz vsus 1 from the parcel Select Land Value field EEE layer Select Square Footage field Enter Mumbar of Clacc Breaks Enter Current Year 4 dt Enter Budding Lifespan Enter Annual Land Appreciation 126 Page 1277 Page ENVISION TOMORROW PLUS USER MANUAL Enter the current year and define building lifespan and annual land appreciation Although ET has default building life span 50 years and annual land appreciation 2 00 per year you can change them as you like In this example let say that the building lifespan of the Meadowbrook catalytic site is 50 years and the annual land appreciation will 2 0096 per year default values Redevelopment Candidate Method Depreciation Select Parcel Layer Maadowbecek Parcels cACTIVES Select Effective Year Built field yearkt_ Select Improvement or Building Value field Eds Vale 1 Select Land Value field TER Select Square Footage field Enter Number of Class Breaks Enter Current Year 4 digit Enter Building Lifespan Enter Annual Land Appreciation Inputting year building lifespan and annual land appreciation ratio Now click Run to identify redevelopment candidates of the target site a d
112. m the ET Scenario Builder This also means that it is optional for users to use these tools However in scenario planning using ET they provide users with additional scenario outcomes that are useful in comparing scenarios Fiscal Impact Tool FIT Standalone App Spreadsheet Using the data in the FIT Link tab of the Scenario Builder the Fiscal Impact Tool FIT Standalone App spreadsheet allows users to analyze the full fiscal performance of scenarios such as costs revenues and taxes Also users can reflect their fiscal assumptions of scenarios into the tool such as inflation rates additional revenues years and so on After entering input data this tool gives users fiscal performance summary in tables and graphs about how much the total benefit of scenarios will be This tool includes the following six tabs DataEntry TaxOutput CostModuleOutput SummayOutput Time and Data tabs User can load or initialize scenario inputs by using these buttons Scenario input data are automatically loaded Users can enter fiscal assumptions manually ENVISION TOMORROW PLUS USER MANUAL Household HH Travel Standalone App Spreadsheet Using 6D variables density density diversity design destination accessibility and distance to transit for buffers around their places of residence as independent variables this standalone app spreadsheet allows users to estimate household travel outcomes for each scenario As with
113. m il ee ieee Por annii das aF ema dur apr iom rin mr odi uer Pe rena ee HW Tl LP HELRIADS md E PE ed LIC RSC TRE ed p Click Then you will see the scenario builder spreadsheet file is selected and the STEP 1 Project Settings is done Click Next to go to the next step the STEP 2 Constraints wj ENVISION PROJECT SETUP a Step 1 ProjectSetings Step2 Constaints Step 3 Land Use Step 4 Field Map Heo 5 SubAregss Envision Project Workspace Directory JWET Sample DataWStreetcar_ET Example UofUWTest E New Envision File Geodatabase Name Ermision Project Test Feature Source Parcels Only Gnd Cells Only Parcels Gnd Cell Hybnd Grid Cell Size 290 Foot US Select Parcel Layer Parcel Layer Maximum Parcel Size 10 Acre s Select the Project Extent 9 Current View Extent Parcel Layer Extent Upper X 190026379020504 Upper Y 891405 359854443 C Lower X 1854139 858256149 Lower Y 887 499 118854443 s ustpm Select Envision Excel File JWET _ Sample Data WStreetcar ET Example Lat Data Fram Projection MAD 1927 StatePiane Utah Central FIPS 4302 Click 88 Page The step 2 also allows users to make their scenario planning close to the reality by limiting development based on slope and elevation of the target site 89 Page ENVISION TOMORROW PLUS USER MANUAL Step 2 Constraints In the step 2 users can check constraints layers for scenari
114. mercial Parking Hh 2a Retail IT 25 Office EL 256 industnal i 27 Pus Lain Pi 23 DOccepancy Rate 5 Rae m Year 1 Long Term Aale Holes t aia Secure Residential d m 11 HolevMpli Ty Aragi dai Domspacca 3X2 Retail ms rw X3 Gfce he neia 24 industrial adn Bd 45 Commercial Parking TO Average laih kke ast J8 Pus his af me devgence 1 E E mas illy ii Lupe M AD Land cry 08 Ot riw Land cee i ma Erzar ochre ee 41 Land enitisment egal fees 95 rau land ee Eaque anli irai 1 Praies tibl teas i at hard cos E D sper EIE 79 Page ENVISION TOMORROW PLUS USER MANUAL Based on the input data in basic advanced financial tabs users can choose proper financing support tools in the Gap Financing Options tab In this tab users enter the target amount of money or percentages so that they can figure out the impact of each financing support tools on development of the building prototype and make development of the building prototype fiscally feasible by using several financing support options For definitions of each financing support tool the Prototype Builder also provides users with a reference tab Gap Financing Definition next to this tab Listing up various gfinancing support options that help make development of the building prototype feasible iiitiiiti Ox E When users select financing support options they can determine the target fiscal support goals and a
115. mp Replace Gly Select By Attributes fo Switch Selection FH Select All 5 Click Turn All Fields Gn iv Show Field Aliases Arrange Tables i Restore Default Column Widths Restore Default Field Order Name a new field and select the type lains and Relates i Related Tables k Create Graph Add Table to Layout E alow MOLL Vaes Ves Reload Cache i Detnut Vaio Print Reports L Export Op t Appearance Place the mouse arrow on the new field name and right click the new field and select Calculate Geometry ENVISION TOMORROW PLUS USER MANUAL i A new field AREA sqft is added LIT TILPUIILBEbR PLE rali IE i ld a d gw VEI alate lt Mi 2 m 3 click pgs The following message will appear When you click OK to continue the task another window pops up In that window select Area as a property and choose Use coordinate system of the data sources Then units will be automatically set up Click OK when everything is ready ies bud AAR A Fuss KS Felt uad rey Select Area to calculate the square footage of each parcel iTA amp l I DIM iz R RT n Wee Use the existing coordinate Use coordinate system of the data frame system of the parcel layer PES NAD 1983 5tatcPlanc Utah Central FIPS 4302 Feet amp amp Click 1 Calc
116. n Each Scenario Average Wage in Each Scenario Subsidy Financial Subsidy per Unit Property Tax Revenue per Acre Sale Tax Revenue per Acre Monthly Household Costs H T E Housing by Type Housing Mix e Net New Housing Units Redeveloped Housing Units Owner Renter Mix Average Rent Average Rental Unit Size Average Home Price Average Owner Unit Size Housing Distribution by Income Housing by Building Type Impervious Cover of New Development 96 Energy Use per Household Carbon Dioxide CO2 Emission per Household Landscaping Water Use per Household Internal Water Use per Household Waste Water per Household Solid Waste per Household Transportation 15 Economy 14 Housing 11 Environ 7 TOTAL 61 Indicators 45 Indicators 38 Indicators Note Indicators colored in blue are ones that are used in both the Summary_New and the Summary_ Total tabs As shown in the table above indicators can be grouped into seven categories according to the general characteristics of each indicator and general purpose of each scenario spreadsheet tabs baseline information land use growth transportation economy housing and environment Also both scenario spreadsheet tabs shares some indicators 123 Page ENVISION TOMORROW PLUS USER MANUAL Tools in ET Actually the ArcGIS shapefile you use as a base map in ET contains many existing condition datasets By using these existing condition dat
117. nalyze feasibility of development of the building prototype After experimenting with your building prototype you will see that inputs and outputs are summarized into one row in the scenario spreadsheet tab This means that all input and output data in the Prototype Builder can be sent to the Scenario Builder to create development types for scenario planning by mixing building prototypes users create here All input and output data are summarized in a one row table These data are exported to the Building Input tab of the Scenario Builder and used as baseline data for creating development types used in painting scenarios 80 Page ENVISION TOMORROW PLUS USER MANUAL STEP 4 Opening the Data Now that you finish preparing all ET components with data one last step before painting scenarios is to create a file geodatabase open it in ET and linking it with other ET components especially the ET Scenario Builder However before creating a file geodatabase we need to understand the structure of a file geodatabase A file geodatabase can be defined as a big container box that can contains both attribute tables imported from ET spreadsheets and scenario layer shapefiles for saving painted scenarios As shown in the figure below a file geodatabase is made from GIS shapefiles that represents the physical form of the target site based on geometry units constraints and subare
118. nario spreadsheet can be open on one monitor and the ET software open on another monitor However this is optional ENVISION TOMORROW PLUS USER MANUAL ee ee Now in the File and Edit Scenarios menus define your scenario layers and select the scenario you like to edit When preliminary setups are ready the first thing you need to do is to make your scenario spreadsheet Excel file ready to write values and calculate indicators when you paint the area Beneath the menu bar there is an icon named Start Edit Click it so that your scenario spreadsheet can write and calculate outcomes of your scenarios When you are done Click End Edit Save button to save your outputs Metropoldan Center Urban Center Town Center m Community Center Rural Vilage i M uBti F array Residential Mutti Famiy Residential 1l In order to paint the area you should select the development type that is shown under the icon menus Each development type has its own color Select the development type you want to paint the target site and select the paint brush tool NVISION PAINT TOOLS ax File EditSceneios Subareat amp Apply Start Edit Hu Symbol Development Type Matropoiean Center Urban Genter Town Center Cemmun y Canter Pomt Brush Palygon Erush Rectangle Brush Rural Village Muk Famiy Fieaidental Trad
119. nario you worked on la ul ur ur uu UP us a a a e i ecu d Re er us COR d a I P md E e e uu e E aUe P OC HS uA RI UR CEN mr a imr P A A P ul OR ee ud iu a Y Open Envision File Geodatabase Scenario 3 Open Envision Excel File b Scenario 4 Scenario 5 Scenario 4 Scenano 5 Synchronize Data Attnbute Field Manager Click Envision Tomorrow Plus v1 0 112 Page ENVISION TOMORROW PLUS USER MANUAL When you select the scenario layer to edit ET automatically starts checking data requirements for editing that selected scenario Now go to Edit Scenarios menu and select the scenario you just defined and want to edit In this example go to the menu and choose SCENARIO 2 Then ET automatically adds another shapefile data in the Table Of Contents window of ArcMap as the former scenario did Also ET automatically activates the scenario you want to work on and shows a blank map so that you can produce your next scenario ima irmis damn SS UEPULy epe mra nae re Jal Md d n ah ri tm i e me T ig AE r ee ee E ge Elm ia T Preeti P DOETE 347724 T1 bemi Another scenario shapefile A blank map for the scenario is shown in the data Scenario_2 is added mapping scenario visualization area In the SCENARIO SUMMARY table you can find that a new scenario layer name Scenario_2 in this example and acres information are added Scenario 2 is added id 4 I hi
120. narios the file geodatabase saves the ET analytic tool results and represent in the scenario shapefile in a visual way The elements of the ET file geodatabase can be grouped into two main parts that includes e GIS Shapefiles Scenario Layers and Constraints shapefiles e Scenario Attribute Tables File Geodatabase shown in AreCatalog Paes Denon Mere MEERE 41 Page File Geadatabase in Arc Map ENVISION TOMORROW PLUS USER MANUAL GIS Shapefiles Scenario and Constraints Layers Scenario layers in a file geodatabase are basemaps like a canvas where users can actually paint the polygons to produce their scenarios The basic unit of scenario layers can vary according to the spatial scale of the target site or users scenario planning goals As ArcGIS shapefiles scenario layers can be created when users operate the ET Project Setup function In that function ET provides users with three options for creating scenario shapefiles Parcel Only Grid Cell Only and Parcel Grid Cell Hybrid When users choose one of the options ET automatically creates GIS shapefiles that users use as scenario layers in scenario planning Although users can produce up to 5 scenarios ET can provide up to 7 GIS shapefiles as scenario layers based on the type of scenario layers Also while setting up scenario layers in the ET Project Setup function the original GIS shapefile used in that function should be added in advance an
121. ncial targets and so on Therefore most of input data in this tab requires users to define their fiscal assumptions for development of the building prototype Detailed input data in this tab can be summarized as follows Advanced Financial Tables amount of space that is rentable _ Occupancy Rate Setting up the target amount of due diligence land carry of raw land cost Land entitlement legal fees and percentage of professional costs Estimating demolition costs site development costs Development costs land brownfield remediation costs and additional infrastructure enhancement Setting up impact fees building permit fees taxes and insurances during construction developer fee contingency costs based on the local construction and tax regulations Property taxes Property tax ratios and assessment rates by building Property taxes uses Setting up financial stats of the building prototype F Target Usu Kee used for the dashboards of the input tabs Financial setting up sales debts cap rates etc Assumptions Setting up max LTV interest rate and amortization Primary Debt i M period years by building uses Advanced Financial Inputs Input Cells Pre development costs Indirect costs j Building Emhciency ZU Togs Fu let Square Fnctape M Hernisi x Hafen Cada Xourre 1m wiii deatur elt tu uiri He sidenhtgl sim dor aimgla lamilg zicplas cr 24 RES uu eg y3 Holepi ETA 23 Com
122. ncpopmenm lype emo i wits Lonkup Taide 1 z COMPONENTE Enea Lat pun Fan T 1 u i Ops 1 Irae ons 2 3 a lrg i ay hak at dain Wren Enara LU Uipnenco the cnn F Tus Uo Taba Ew ahi Pare 1 a a a T rae pui w a irren T r TF y 1 TH Ye am i utc eT Hi Edi i Fl Boerner Tabies t 5 poner mn i a a GEPLERNI pohsgeon ener Bendre date 1 fam shapes Gf har Ga iad pare gl ure onm ore hey eel PEL Cesar Dub al z 2 x Fiscal Impact TooWFIT standalone App e importing data from ine TIT Ln Lam Danii Pug I o fc pe Be ach uDpnarm wey cisia ne ruin Sra STANDALONE TOOLS Egira La ems casts gend ny 2ronmnem 8 Page TABS IN ET SPREADSHEETS Helier Pads Boerne Builder ik Gre 1 Pe um Sranang Spreadsheet i Pratotype Budder EOV RH Mee Heusehokdi HH Travel S1arxdalone App Tool Fiscal Impact Text FIT 51andalone App Tool Mixed uge Diecslapmenti MED Travel Dili AEPTEC Sturdalon App Teal 9 Page ENVISION TOMORROW PLUS USER MANUAL Tabs and Cells in ET Spreadsheets Developed by Microsoft Excel ET spreadsheets include many tabs and cells Placed at the bottom of the spreadsheet ET tabs allows users to identify what contents each spreadsheet contains for producing scenario outcomes In terms of basic functions ET tabs can be grouped into three main categories Input Tab Output Tab and Reference Tab Colored in red input
123. nction in the File menu allows users to write and track attributes of the development types by using fields in each scenario layer When you select the Attribute Field Manager function in the File menu another window pops up and you will see dozens of attribute fields that ET can track and write in the scenario layer ET includes 141 attribute fields in total hort d f Check all S on ESETIDMIOS of ET Uncheckali attribute fields button SE 3MD b pe LY Mf nt per SF LR je per BN MH par I ei pem Gulch Relonones Field Grouapines Lasse Lian HU EM SF TH ME HH EET OFF IND PUE EDU HOTEL pee Metals o eres er aere eee Sees Beis mel eeu Posse Sore meu dome annal Corian are ENVISION TOMORROW PLUS USER MANUAL Certain attributes can be multiplied against the land area acres and result in additional variables For instance housing unit density in the figure below can be multiplied against the land area acres and result in housing units This additional variable can be calculated by checking the Cale by Acres box Fields that can produce Multiplying against additional attributes the land area acre Wirta wcby Cac Oupul Cak Only Lu MP Additional attribute variable names that can be added and shown in the scenario layer However vou cannot find these attribute fields in the attribute table of your scenario layer without checking the Track box For example
124. nen Temergos Plus s Redevelopment Candidate Method Depreciation Bottom Quartile Select Parcel Layer Select Effective Year Built freld Select Improvement or Building Value field Select Land Value field Select 5quare Footage field Enter Number of Class Breaks Enter Current Year 4 digit Enter Building Lifespan 50 Enter Annual Land Appreciation 200 amp amp per year Apply Legend RUN Gi 125 Page ENVISION TOMORROW PLUS USER MANUAL In the Redevelopment Candidate window there are some blanks you need to fill in First choose the Depreciation button in the Redevelopment Candidate Method and select your parcel layer In the Meadowbrook Catalytic site example you need to choose the Meadowbrook Parcels ACTIVE as your parcel layer Click A parcel layer is added Select Effectve Year Buik field Select Improvement or Building Value field Select Land Value field Select Square Footage field Enter Number of Class Braaks Enter Current Year 4 digi Enter Bulking Lifespan 50 Enter Annual Land Appreciation 200 per year Apply Legend RUN GE Select the appropriate fields to fill in the Effective Year Built Improvement or Building Value and Land Value fields of the Redevelopment Candidate widow In the Meadowbrook Catalytic site example choose the yearBlt_1 the Bldg Value 1r and the Land_Value_1 respectively Redeve
125. nt to synchronize the attribute field outputs only for painted areas you have to choose the Quick Syne function in the File Synchronize Data menu for all areas choose the Full Syne function Select the Quick Sync function to synchronize the attribute outputs for painted areas only Attribute outputs are now added and traceable when you paint the areas in the scenario layer unum is EM EO 1a ict Tad chai Libia dE S4 riiai UTE ENE Teepe aewy Pace L L TERRAM ape eus Ee ETTA ye Fani orien off boTE Ls ogg Fey Pee ETETT Hina Bee Bee Be EE EEEEEEREL E 1 be on B pra i Tirai i ATT Caes rnm oe BIS COE EUI TAMAT War er vi FEIZE Ce a TTD eh Erga Foes Faucets aiki METE BIEILU Lrojem Famerp Formae am Hile EPT OTME apa Hie ha hia E m rem Lis g IUcRcOGI shale aule tile a iini iaaa ane jam jme magnm me T iig 2588 DT bai Tik Ez aai a si ma L Hae crat inui m trib ea Laya Fus Dee auge mer 3 Fay Derniers m E a Mos por on UE poet ee Saec Togaans 9 oi Tete 118 Page Check all boxes to track calculate and write the calculation output only ELT 37 iube ee Null ees mure aM gm Pre J 117917 ign 1058813 janie aude LL S be j ITE emia Sepa d eue Rgsadeebai TETEI Beene ewe Fare Reqadeetal
126. nvision Excel File Synchronize Data and Tools sub menus there are several detailed functions Functions of these three sub menus can be summarized in the following figures Open Envision File Geodatabase Define Scenario Layers Open Envision Excel File Select Opening a scenario spreadsheet file Synchronize Data Ft Load Development Type Attributes Loading development types defined in the Dev Type Attributes of the excel scenario spreadsheet Attribute Field Manager Save changes in the Envision Tomorrow Plus w1 0 excel scenario spreadsheet Close the excel scenario spreadsheet file Open Envision File Geodatabase Define Scenario Layers Synchronizing only painted parcels cells Open Envision Excel File Quick Sync Synchronizing all parcels cells nchronize Dat i i i Synchronize Data Full Sync including applying zero values to Existing Conditions Sync unpainted cells Attribute Field Manager Calc Null Values Synchronize existing land use information within the scenario layer with the scenario spreadsheet Envision Tomorrow Plus v1 0 55 Page ENVISION TOMORROW PLUS USER MANUAL Allows user to aggregate scenario layer to some larger geography ex TAZ for use in travel demand Open Envision File Geodatabase models Define Scenario Layers Creates summary table with records for each scenario housing unit T Open Envision Excel File l a and job Contains a suite of to
127. o planning in ET Constraints are defined as the geographic conditions that can limit future land use change or development To consider these constraints in ET scenario planning users should prepare for constraints GIS shapefiles before operating the ET Project Setup function As shown below ET automatically recognizes GIS shapefiles currently added in the Table Of Contents window in ArcGIS and show them in this step so that users can check constraints layers Also users can define buffer distances from each constraints layer At the bottom of the window users can limit development of basic unit cells by setting up slope For example if users set up 15 25 slope constraint this means that any parcels or unit cells whose slope is between 15 and 2596 will not be allowed to develop in scenarios al ENVISION PROJECT SETUP x r e Step 1 Project Settings Step 2 Constraints Step 3 Land Use Step 4 Field Map Step 5 Sub Areas set E Parce Layer Users can select GIS shapefiles as their constraints layers define a buffer distance measure unit and a buffer distance In this example we skip this step because the target site does not have any constraints such as a river transit lines etc Output Grid Call Size 1 Previous Next mp ENVISION TOMORROW PLUS USER MANUAL Step 3 Land Use The step 3 allows users to reclassify existing land us
128. o applied to this tab ET divides existing land uses into 16 GIS existing land use names so users should input existing land use acres according to this classification When users operate the Envision Project Setup function to create their File Geodatabase Scenario Layer they can convert existing land use descriptions into the ET existing land use classification How to clean up data and operate the Envision Project Setup function will be mentioned in the section of the next chapter Inputting Data Acres and square feet of existing land uses are used as the unpainted undeveloped acres in each scenario Acres and square feet of both existing and newly Automatically calculated developed areas are calculated by the ET existing when painting polygons land use classification scheme in the target site PAR a ea 37 Page ENVISION TOMORROW PLUS USER MANUAL The most important reference tab that users should concentrate on while producing scenarios is the Development Dev Type Attributes Tab When users create development types by mixing building prototypes output cells in this tab are automatically calculated and filled in by each development type The cells in which users should enter input data are the columns called the Green Streets Assumption and the Symbology Color RGB for defining colors representing each development type in the ET system In this tab the following attr
129. ob changes by E scenarios are E 2 calculated here a rH Pmjectifo buking Inputs Dev Type Streets Dev Type Buling Mk Dev Type Attrbutes AETV AE ITEMS Proximity Aaa eT Mra ea TO arm STENTS 35 Page ENVISION TOMORROW PLUS USER MANUAL Reference Tabs The reference tabs help users identify existing conditions in the target site In ET the reference tabs includes e Existing Land Use e Existing Developed Area e Existing Energy and Carbon e Existing Housing amp Income e Development Type Dev Type Attributes e Residential Commercial Energy Coefficients e Metro Cooling Degree Days CDD Heating Degree Days HDD e Travel App Link e Fiscal Impact Tools FIT Link The Existing Land Use Tab allows users to identify existing development conditions Although this tab contains many input cells these input data serve as baseline information for figuring out changes in indicators between existing conditions and scenarios users produce Basically this tab identifies the spatial scale of the target site existing demographic conditions housing and employment All baseline information is summarized in one single row and linked to attribute tables in the File Geodatabase In order to make ET scenario planning work well users should input existing condition data in this tab as complete as possible to get more accurate and comprehensive comparative analyses between existing development conditions and scenarios Existing Dev
130. ols that prepare scenario outputs for accessibility es Attribute Field Manager and travel apps Create a reference layer for redevelopment 1 to Many Export potential This function Accessibility Functions requires parcel dataset Synchronize Data Attribute Aggregation to Neighborhood Envision Tomorrow Plus v1 0 Redevelopment Candidate App Creates a reference layer for regional jobs housing wage income balance This function requires worker resident counts amp wages Local Jobs Housing Balance In the Accessibility Functions sub menu there are also several detailed functions as follows Allows users to summarize scenario outputs within radial buffers and writes summaries to a new attribute Allows users to summarize point or line features such as intersections or transit lines by a scenario or neighborhood layer New attributes provide total counts and density Buffer Summaries Feature Summaries Creates auto and transit travel time summary buffers based on current and futures network parameters Create Travel summary Buffers T s b Transportation Location Summary Proximity Summary Land Use Mix Summary 7D Model Calculator Estimates the number of housing units and jobs within a buffer distance of amenity GIS layers Summarizes scenario outputs based on travel summary buffers Contains a suite of tools that Writes household 7D app outputs to prepare and allow users to run t
131. onsists of seven main steps maybe eight steps if the Modifying scenarios step is included to produce scenarios When you look at the ET workflow diagram carefully you find that actual operation of ET for producing scenarios is not that complicated What makes you feel complicated may be the preparation steps Step 1 to 3 and the evaluation step Step 6 This means that in order to make the ET scenario planning process work well it is inevitable for you to prepare for data Throughout this chapter you will learn how to prepare your data for ET scenario planning and produce scenario in ET This covers from step 1 to 5 in the workflow diagram Interpretation and finalization of scenario will be mentioned in the next chapter STEP 0 Preliminary Setup Understanding the Basic Structure of ET Since ET is an extension tool for ArcMap it should be installed before using it in the ArcGIS system eB Be BE l 4 The ET software has two separate versions ET for ArcGIS 10 0 and ET for ArcGIS 10 1 Therefore before installing the program you should check the version of your ArcGIS software Also the ET software is made based on Microsoft NET Framework Therefore you may need to install NET Framework
132. ool Gap Firancrg Option Gap Francng Dafintincd Bamert Darm ENVISION TOMORROW PLUS USER MANUAL Cells are defined as basic units of analysis for completing the ET spreadsheets Cells in ET can be grouped into five categories Input Cell Output Cell Linkage Cell Header Cell and Sub header Cell Each cell can be recognized based on its color so that users can understand what they need to do for each cell type In terms of the format of the ET spreadsheets ET provides users with header cells blue and sub header cells light blue These cells tell user what tables or graphs included in the spreadsheets are about Also users can easily collect scenario outcomes that they like to focus on Input output and linkage cells can be determined in terms of their functions and roles in the spreadsheets Input and output cells have the same colors as input and output tabs have However these cells are the actual areas where users should input their data and figure out output values calculated through the spreadsheet Linkage cells which have a green cell color are used to send some input and output data in the Scenario Builder to the three standalone app tools Household HH Travel Mixed Use Development MXD Travel and Financial Impact Tool FIT Standalone App tools By importing data from the Scenario Builder these three standalone app tools calculate additional indicators and produce outcomes so that users can evaluate their
133. osts Public Health Air Quality etc APPS C Spatial Data Employment Housing data Energy Consumption eee ADDITIONAL DATA 11 Page ENVISION TOMORROW PLUS USER MANUAL ET consists of 17 different apps which are developed based on nationwide or recent datasets As a set of models for estimating various scenario outcomes ET apps exist in various forms within the ET system The table below shows how these 20 ET apps exist within ET Growth Location Prediction Return Investment ROI Building Energy Consumption Household Travel 7D Transport ation Effects Mixed use Develop ment Travel Housing Transportation Energy H T E Costs Air Quality and Climate Impacts Fiscal Impacts Even if you do not understand the table for now it is okay Tabs and spreadsheets mentioned in this table will be explained in the later sections of this chapter Definition Function Numerical data T ing Predicting future growth areas by using land inputs Eatiationis uses demographic and social data Allows users to develop building prototypes used in ET and check their fiscal feasibility Indicators A standalone Tool Numerical data inputs Coefficients Equations Indicators Estimating residential commercial energy consumptions and costs Numerical data inputs Equations Coefficients Indicators Stand alone tools Estimating Vehicle Mile Tra
134. planning process using Envision Tomorrow Plus is shows in the figure below Since Envision Tomorrow Plus is a computer aided tool for creating and evaluating scenarios it is actually used in the step 6 Experiment and Learn Scenario Planning Step 1 through 5 is a preliminary process to define future visions set up goals and analyze data Step 7 through 9 is a process after using Envision Tomorrow Plus and participants finally choose a plan A final scenario produced by using ET will be used to set up the final future vision and develop other planning documents like an implementation plan as Create a Framework for Your Scenario Planning Process e Select Evaluation Criteria Step 2 e Set up Scenario Planning Preparation Step 3 Phase step 4 i Evaluate Where You are Now and Where We Are Headed in the Future Step 5 Ii Engage the Community and Stakeholders e Experiment and Learn Scenario Plannin zx 9 L X etomorrou step 7 I Communicate Scenarios to the Public and Key Stakeholders Finalizing Create a Final Vision Step 8 Scenario Phase e Develop an Implementation Plan Step 9 4 Page ENVISION TOMORROW PLUS USER MANUAL J The workflow of Envision Tomorrow Plus is a linear and iterative process When users operate ET for scenario planning they generally follow the seven steps to produce scenarios and finalize one consensus scenario Since ET is an extension tool of ArcMap it requires some
135. ployee by sector average and other uses The average unit size of the residential and or affordable residential units The gross numbers are inputs the net are outputs assuming the efficiency percentages in the Advanced Financial tab The average gross square footage per employee for retail office industrial public Parking S arking Spaces uses Parking Type parking type Parking spaces per dwelling unit room or 1 000 sq ft of commercial Selecting parking types and setting up the number of levels for each Parking Layout Selecting parking space layout Suburban perpendicular Urban perpendicular Structured Mechanical Custom J6 Page 77 Page ENVISION TOMORROW PLUS USER MANUAL pr baa TER d ep oii gt Poot H eed FALT Laad Inputting data bi bee eee qu 2 ee n ki eet ni Bed Er Lied Although the Physical Output tab is not an input tab it allows users to understand what physical properties the building prototype they create look like The Physical Output tab estimates physical properties of the building prototype in terms of the following aspects This output tab is also used to analyze the physical performance of the building prototype Output Tables Output Cells Building Footprint Landscaping or open space Site level Outputs Parking area next to building unused or flexible space usable building total Square Footage by use Gro
136. preparation before users actually use the software In the first step users should determine what their geometric scope is and what the basic spatial unit should be used to fit the geometric scope Is the geometric scope a parcel which focuses on scenarios on a single parcel Is it a region which pays more attention to cities or county instead of smaller areas such as districts and neighborhoods This part will be dealt with in the Step 1 Inputting Data chapter of this manual When all preparations are done scenarios can be produced very easily by creating a file geodatabase painting the areas and producing scenario outcomes in various ET spreadsheets Each scenario produces its own outcomes and users can check the outcomes according to their goals and assumptions of scenario planning If the scenarios are not satisfied with goals or assumptions users can go back to step 3 and adjust their scenarios The final scenario is determined through comparison of all scenarios and users can document the final scenario outcomes All these processes will be explained in the Step 2 Creating Scenarios and Step 3 Analyzing Scenarios chapters of this manual ecovoro ET WORKFLOW DIAGRAM PREPARATION OF DATA PRODUCING SCENARIOS EVALUATION STEF 3 STEP 4 STEP STEP E STEP 7 inputting Guta a Scenario Faimiing Scerara I 1 Finalizing Scenaric Dimi hee biie Preparing Credia budir Opgeriding the ET Pining t5ihares bry Miale irri p
137. rall scenario planning process the Prototype Builder s prototype buildings are combined with other elements of a city such as street types civic uses and open spaces to form development types used by the scenario builder tool After a scenario has been completed the Prototype Builder displays the scenario s performance based on a range of selected benchmarks or indicators unique to each project PROTOTYPE BUILDER AT A GLANCE 4 Tests the physical and financial feasiblity of development based on a specific place selected indicators scenario bullder 15 Page Provides scenario performance evaluation based on _ Tests the impact of existing and proposed regulations for financial feasibility can be used in the scenario planning process Allaws experimentation with the sensitivity of key variables such as height FAR parking landscaping land costs rents subsidies Outputs a range of site specific prototype buildings that Identifies regulatory roadblocks Fa JI Powerful as standalone tool or integrated with the ENVISION TOMORROW PLUS USER MANUAL Work Area and Tabs in Prototype Builder Like a scenario spreadsheet a Prototype Builder spreadsheet consists of three simple tabs input tabs light red output tabs blue and reference tabs light blue Each tab has its own color which shows a function The Prototype Builder cells are also color coordinated to reference input header subheader
138. ree a Maus ee Fertur H ekz Wi Conn L inthe 2 1 i a tate dra Click ig ue tour ig op APTS Pape PT homana ipri 511 6 A 22551 When you open your scenario spreadsheet you also see the message about whether you want to retrieve the latest data or use the previous information in your spreadsheet To use the latest data select the Update option this time ak kt EEE Thy ertha corri nior 12 otter Saca parom s dvo apcace ne licia Page ell acepto rere E latens rara af yeu dort update fa inka Don wal una te previcumr ition Robe Pat dais linke cac be aed in accean acc iare candens pie icme foenum a rena branen d kmen 5 2595552322 moe 4j hoiii gt Vee Lee hlwHE T Shep a qs mn cma pad ATI Ede ae ELIS HERR ESS PSR eee eee se a a ee x Ham el T zy Tihi sare imngindiha ating Deweloped Aaa rateg irase atng herang amp pesma Bing piti bisakakh and enma Oey Type geneet Dav Typa Open Spaca Sev Typa Buking Mie Dav Typa Arbore SOI summery Total a 000008 and TUET 105 Page ENVISION TOMORROW PLUS USER MANUAL Then ET will check values in the scenario spreadsheet and show the scenario shapefiles you recently worked on and the table SCENARIO SUMMARY The SCENARIO SUMMARY table tells you how much vacant and developed acres you have for that scenario now Jg d d g
139. regions or Metropolitan Statistical Areas MSAs parcel level scenario layers may be inappropriate for scenario planning analysis because it is very difficult for users to manage large amounts of parcel level datasets throughout the region Also at the final step users may have a lot of trouble in writing the results To produce scenarios it is very important for users to determine the scale of scenario geometry based on selection criteria such as data availability and level of details ENVISION TOMORROW PLUS USER MANUAL of the final selected scenarios by combining all parcel level changes with the region level planning context Using a smaller unit of geography may help users to make their scenario outcomes more sensitive to localized details but the geometry unit should be adjusted based on the scale of the target site Selecting proper scenario geometry is directly related with determining the feature source of the scenario layer shapefile that users will work on in ET In the ET Project Setup function ET provides three different options for the geographic scale of scenarios parcel based grid based and hybrid scales A parcel cell provides the most precise scenario planning among the three options However it is very hard for users to get uniform data for each parcel due to high variety of parcel level data and users need to spend a lot of time and effort to get the data A grid cell is the most straightforward geometry
140. res 140 Page This manual was produced with funding from a HUD Sustainable Communities Regional Planning Program grant to facilitate implementation of the Wasatch Choice for 2040 Regional Vision Envision Tomorrow Plus is one of the implementation tools that were developed under the grant it is the product of a partnership between Fregonese Associates the Metropolitan Research Center at the University of Utah and Envision Utah etropolitan esearch enter 3 Envision Utah How we grow matters FREGONESE iz FREGONESE Date Released Oct 23 2013 Written by Keuntae Kim Metropolitan Research Center 375 S 1530 E RM 235 Salt Lake City UT 84112
141. rio U out of 5 Selected SC NARIO SUMMARY mille nomm 113 Page ENVISION TOMORROW PLUS USER MANUAL To paint your scenario you just paint the areas as you did in scenario 1 The figure below is an example of Meadowbrook catalytic site F e Ede Wese Bockmas imet ienen Geepeepeeng Cucemess Widows birip Seas Bx ovd as HBBBENOI RANO NK EO kd nc MASS CES Uferietup ET Pint Taol gt ARRON P BIT TOOLS ax aos E p p Lead dor ii CI CT ett S Demo tte H lai DE oA a WI Lipi hiria Fis Meee Iredurtrial D Sama MS pifurr values DE TYPE ECER am INES 4012516315 Fen In the Scenario Spreadsheet you can track changes in the Scenario 2 column of the Summary New and the summary Total tabs Values changed EET tuhsB unuuvuusHssusazcnussase eees Pe ee dena 3 hom ine S s vac Ue rz L fe DE SE OY mIBE g Se eo lU ee L 2599529232523 HE Loma os Topnie wi 3 Et See Pe ee DAD he f s 114 Page Field Names that are actually shown in the attribute table of the scenario layer when users check its Track box on the left 115 Page ENVISION TOMORROW PLUS USER MANUAL Using Attribute Field Manager Occasionally users want to identify some attributes of the development types when they paint their scenario In ET the Attribute Field Manager fu
142. s the Summary Tabs allows users to understand the physical and financial properties of the building prototype they created and what the full impact of the building prototype will be in the scenarios The Prototype Builder provides two summary tabs as follows e Print Summary Tab e Scenario Spreadsheet Tab The Print Summary Tab allows users to produce a one page summary of the building prototype Using a little bit background of Microsoft Excel users can customize the contents of this tab Actually this tab is not password protected so you can change the names and link to elsewhere in the model as you would like There is also a blank area which you can use to post a photo of the site or rendering of the potential prototype building E a l Pm e n mem EE ES M e M Ho 3 Your City USA Mixed Use Building 2 1 BUILDING FORM amp USE E Lat ri 10000 it 5 Lat area 0233 m cr 7 Height stories Flode area ratio 1 18 FAR 5 Aw erage unit size id ef Residential density 459 jlacre I4 Ernpleyrment density G fare 14 FINANCIAL PERFORMANCE 15 Average unit sale price Ny A 16 Average csuf N A fof 17 Average unit rent 1500 00 month 18 Average rent sE maonth 1 50 set 14 Belal rant ofAye sr 16 fof triple net Building footpnnt aj Office rent of year N A sof ttriple net 1 mLandscaping or open 21 Estimated land value 315 sl ipaca a Estimated land valus 5 150 000 oParking Erga Mex ie 23 Total proj
143. s of larger areas than parcels For neighborhood level scenario planning in ET datasets users may look at can be summarized as follows This is not an absolute list of dataset users should use If there are data better than the list below use them Data Resources The Internet links contents e Provides raw data for physical and market value properties of each parcel Assessor s Data e Generally developed at the county level ex http assessor slco org for Salt Lake County e www uli org e Includes general information on datasets for real estate development real estate surveys reports etc www rsmeans com calculator index Construction Costs ie m ca Ma ator index asp paid subscription required e www zillow com e www zilpy com e www apartments com Commercial Rents and e www loopnet com Sales Prices e http factfinder2 census gov faces nav jsf pages index xhtml e demographic household income employment etc General Real estate development Residential Rents and Sales Prices Census Data Assessor Data This one tlog properly information resource is provided as i public service through theo cooperation of municipales amd Real Property Dala Together we ara passed bo make this data easity accezsihia bo yel Search by County and Property Address or Tax Key Number Experiencing probigms er eros Please report any suas Miri i 12055 2013 Real Property Deia All rghbs peered 64 Page 65 Page
144. s that are already defined in the tab are ones drawn from ET Household Travel App Therefore even if users can customize these values based on the planning context they do not need to modify them Metra CDD HDD bia SD e mii bie ee im mem Lan les mcm HH Travel Macel LE Ld v Cum Thim mm e it nme EE XP NM D d jo ETN Be ns hee i 4 ENVISION TOMORROW PLUS USER MANUAL For estimating trips and VMTs for household travel and mixed used development MXD it is necessary for ET to develop a transportation land use model for figuring out what changes in trips VMT and emission will occur in each scenario The Travel App Link Tab collects basic data of land use characteristics and transfer these information to the ET Household Travel and MXD Travel Standalone App spreadsheets Data within the link cells in this tab serve as input data in the two standalone app tools and are used to produce the impact of each scenario in terms of changes in trip generation by modes and orientation departure relationship VMI emission due to increasing trips or VMT and transportation costs As with the Travel App Link Tab the Fiscal Impact Tool FIT Link Tab collects basic data from other tabs in the Scenario Builder and send them to the Fiscal Impact Tool Standalone App spreadsheets As input data for the standalone tool this tab collects data for population land
145. scale in the ET scenario planning because it produces planning units of consistent size throughout the target site but users should aggregate or disaggregate actual existing geography data to make scenarios more accurate A hybrid cell uses grid cell and parcel cell approached at the same time This is very useful when the target site includes mix of small parcels and large areas toward the urban edge that requires more details The advantage of a hybrid cell is that it gives extra precision for scenarios and more details in specific areas In determining the scale of scenario geometry users can set up their scenario layers consisting of larger geographic units according to the goals and scale of scenario planning By aggregating the parcel level data block block group or contract boundaries can be used Occasionally based on users interests in scenario planning Traffic Analysis Zone TAZ plan or zoning district boundaries can be used as the geographic unit of scenario layers in ET Whatever geographic unit users select the important thing is that they need to check if data are available Parcel Based Scale Census Block Based Seale Gud Cell Based Scale Combination Seale P 1 II E i e i Developed Land Vacant Land Water 60 Page ENVISION TOMORROW PLUS USER MANUAL The table below illustrates the major advantages and disadvantages of each geographic unit that can be used in ET Level of Detail Three Options
146. shapefiles and select the definition field that explains subareas Like constraints shapefiles subarea shapefiles should be prepared before operating the ET Project Setup function Also like this example if the target site does not have subareas you do not need to add subarea shapefiles When you go through all these steps you will see the Run button at the bottom of the window with a colored icon If you do not finish all these steps the Run icon has a gray color Click the Run button Then ET operates all process you set up in the ET Project Setup function and show you the success message when a new file geodatabase is created Also next to the Run button you can check status of inputs you did by using the Status of Inputs button r M UMP he a2 ENVISION PROJECT SETUP Lo O0 mme Sup 1 FrojectSetings Step 2 Constraints Siop 3 Land Lise Step 4 Fia Map Step 5 Sub Areas Seiect a Subarea data layer Select the Definition Field com Dapat Field Name Click Based on subarea GIS Select the shapefiles added in definition field of a the Table Of Contents subarea layer window in ArcGIS select a subarea data layer When all steps are done click it to run the ET Project Setup function dn previ Status of Inputs Checking the status of inputs done through the steps 94 Page ENVISION TOMORROW PLUS USER MANUAL 1 Here we will use a sample data of Meadowbrook TOD
147. so help identify whether redevelopment candidates consist of small parcels or large parcels and whether they are scattered or concentrated The indicator generates a list of redevelopment candidates which should be checked for accuracy to eliminate historic publicly owned and low value high income generating properties from consideration 124 Page ENVISION TOMORROW PLUS USER MANUAL The indicator uses two methods to determine time horizons for redevelopment potential The depreciation schedule method compares building depreciation and land appreciation to determine when the building will become worth less than the land it sits on The bottom quartile method identifies parcels that have low value compared to other properties in a given area The indicator requires GIS data including a non residential parcel layer with fields for effective year built improvement value land value building lifespan and annual land appreciation Let s identify redevelopment candidates by using the depreciation schedule method In the Envision Paint Tools click the File Tools Redevelopment Candidate App Then you will see another window pop up in your screen Fe ko Open Envision File Geodatwbase r Define Sc enano Layers i T pen Envision Excel File s Synehrorare Data I E Attribute Foeld Manager Attribute Aggregation ta Meighborhood 1 te Marry Export Accecstibility Functions Ema
148. ss sq ft net sq ft Land Use Output Total dwelling units or rooms of hotels total jobs generated dwelling unit per acre jobs per acre Parking spaces per 1 000 sq ft of development Parking Outputs the number of parking spaces by land uses the number of parking spaces by type few een Dee Ij Bag agra zd tie f Leia nes dp Tiza Il SEa irid Phil E paap i m at H Lead m hekk ph a 9r inca ua 44 Miama pana Hl iani eem w ENVISION TOMORROW PLUS USER MANUAL In the Basic Financial input tab users enter input data about construction costs subsidy parking costs or affordability assumptions The detailed input data are as follows Basic Financial Tables Input Cells The construction costs per square foot Includes core shell and tenant improvements Does not include parking these costs are covered in the Parking tab Depending on use and level of finish could range from under 90 to 200 per sf Land Site Cost Land acquisition cost S square foot Subsid The amount S of test subsidy to quickly assess the subsidy needed to y make a project pencil Construction Costs Per Square Foot or Per Space Core Shell and Improvements Affordable Rent Target Area Median Income AMI and percent of AMI Rent S per sq ft and monthly parking cost S by rental housing types Residential Rent Estimator studio 1 bedroom 2 bedrooms 3 bedrooms 4 bedrooms affordable housing the amount of mone
149. ssumptions or target goals you set up at the beginning phase of the scenario planning process Therefore interpreting scenario outcomes is totally up to you Nevertheless there may be some guidelines that help you interpret your scenarios in a more comprehensive and accurate way The followings suggest questions that you need to consider when comparing scenarios Again this is not an absolute guideline e What are general features of each scenario Are there any highlights we should focus on e Based on scenario planning goals how does each scenario satisfy these goals e Considering scenario planning assumptions we made at the beginning phase are the results of each scenario estimated based on what we expected e What challenges or problems does each scenario have ENVISION TOMORROW PLUS USER MANUAL Two Summary Tabs Summary New amp Summary Total Among tabs in the scenario spreadsheet the two summary tabs the Summary New and the Summary Total tabs play a major role in estimating the impact of each scenario on the future growth and development By summarizing outputs of each scenario in the comprehensive and visualized way summary tabs are very useful to understand and compare results of each scenario The Summary New tab contains tables and graphs that painted areas affect physical socioeconomic and environmental aspects of the scenario independent of existing jobs housing population and land use While t
150. t area users also prepare for the constraint shapefiles As a GIS shapefile it can be added through the ET Project Setup function and users can limit development of the target area by defining a buffer distance of each constraint For example if there is a river passing through the target area users should prepare for a GIS shapefile that represents the river boundary and decide how much they like to set up a buffer distance from the river boundary If users want to analyze the impact of specific areas they are interested in they should prepare for GIS shapefiles as subareas As with other GIS shapefiles it can be also considered through the ET Project Setup function and ET stores land use changes and scenario planning outcomes of these subarea separately from other scenario layer shapefiles In order to make ET work well the most important thing is to create GIS shapefiles with appropriate spatial extent In particular when users prepare for a scenario layer GIS shapefile it would be reasonable for users to create the scenario layer shapefile with polygons within the target area boundary If the scenario layer shapefile contains excessive polygons outside the target site boundary the data processing in ET will be very slow Therefore if users also have a GIS shapefile with the target area boundary polygon users can create a scenario layer shapefile with polygons within the target area boundary by using the ArcGIS clip funct
151. t include any spaces between words You may use the underscore asa space between words L ij ENVISION PROJECT SETUP exi Step 2 Constraints Step 3 LandUse Step 4 Field Map Step Project Seibings Step 5 Sub Areas Envision Project Workspace Directory JAWET Sample DataWStreeicar ET Example UofUWTest ET Now you should choose your scenario planning geometry For a parcel based cell you need to select a parcel layer which you already added in the Table Of Contents within ArcGIS If you select a grid cell you can define the grid cell size If you choose a hybrid cell option you should both select a parcel layer and define a grid cell size In this example we choose a parcel option and select a parcel layer which is the Parcel Layer GIS shapefile added in the previous step aj ENVISION PROJECT SETUP boim ie Step T Proeci Seinge Slop 2 Consrais Siep J Land Lice Siep 4 Field Map Stop 5 SubrAroas Eryaman Project Workspace Deracbary Mew Envision Fla Gecdatabase Manne Ermesi Propect Test J ETs Sample DotaWinrneelcar ET Example Uo FW Tes al Choose a planning geometry option Smert Parcel Layer Fora parcel cell a Maxirmum Parcel mirek Select the Project Extent 9 Curent view Extent defined here Parca Layer Extent Upper X lS OES Lipper T Lower X ea Fi Furl iur Lower T Custom Select Envision Excel File Gata Frame Pra
152. t side of the spreadsheet you can set up ratios of each building prototype that is included in each development type You can list up to 50 building prototypes imported from the Building Inputs tab The sum of building prototype ratios is 100 which can be checked in the Building Check column Showing a list of building prototypes loaded in the scenario spreadsheet enters zero OY values for the blanks pes by mixing Prototype Bulldings Dannlcpmeni Typo hamp Input cells for setting up ratios of building prototypes combined in each development type shown as a percentage of each building prototype Users can check the sum of mixing ratios of building prototype for each development type through the Building Check column in the left of this work area They are used as basic units of analysis in calculating outcomes of each scenario 113333333333333333333333333332333333333 PE i o Poenis Bokirg Badr Lu When users finish inputting data the EIT Scenario Builder summarizes all properties of each development type in the Dev Type Attributes tab When users create a file geodatabase all data in this tab are exported to the attribute table called DEVELOPMENT TYPE ATTRIBUTES All input and output data are summarized here in terms of physical economic social and environmental aspects of each development type Wb Le 5d Le 7J3 Page ENVISION TOMORROW PLUS USER
153. tab ET Scenario Spreadsheet the Proximity tab ET Tool Proximity Summary tool Numeric data inputs and outputs Coefficients Equations Indicators Prototype Builder ROI Physical Input Output Tabs ET Scenario Spreadsheet Dev Type Attributes tab Summary New tab ENVISION TOMORROW PLUS USER MANUAL Indicators of ET Along with apps indicators also play an important role in evaluating scenarios in ET Indicators can be defined as outputs that each scenario produces when users painted areas in the target site In scenario planning these indicators reflect a set of guiding principles and are related to new or emerging community goals and issues such as transit access housing costs or air quality The indicators are used during the development and evaluation of the scenarios within ET to communicate the benefits impacts and tradeoffs of different policy choices and investments Also from quantitative research perspectives indicators in ET are a set of dependent variables that can be estimated through combination of 20 different apps In ET indicators can be found throughout the system framework To help users find scenario outcomes each indicator produces ET spreadsheets contain summary tabs In the summary tabs users can check various indicators results in both tables and graphs When users paint area in the target site indicators show users what kinds of impacts can be expect
154. the Return On Investment ROI Template Tabs allow users to roughly assess financial performance of the building prototype given normal assumptions about cost and market dynamics The Prototype Builder provides users with the ROI templates according to building uses as follows e Residential Owner Residential Rental templates e ROI templates for non residential building uses Retail Office Industrial Hotel Commercial Parking The Residential Owner ROI template aims at measuring financial feasibility when the building prototype facilitates residential development for home owners given public leveraging tools If the building prototype include development for residential rental the Residential Rental ROI template allows users to figare out possible private investments debt financing public sector loans and leveraging tools available to make a desired investment financially feasible Given the investment targets and performance of the building prototype this tab tells users how financial supporting tools available to assist with development of the building prototype can be adjusted Also annual cash flow tables for each public sector supporting tool and annual internal rate of return IRR tables can be used as references for the investment decisions of the building prototype HO Template Residential Owner e m I i nj iind mii go urs Lamm ere eri ad
155. tion Scenarios p 61 Geographic Scale STEP 2 Collecting Data When you decide the geographic unit of scenario planning the next step is to collect the relevant data and prepare for ET components In this step users should prepare for GIS shapefiles that are used as scenario layers constraints and subareas as well as blank ET excel spreadsheets such as Scenario Builder and Prototype Builder Preparing GIS Shapefiles In ET GIS shapefiles identify not only the actual physical extent to which users paint their scenarios but also physical conditions 61 Page ENVISION TOMORROW PLUS USER MANUAL that limit development in their scenarios In operating ET users should prepare three types of GIS shapefiles for their scenario planning scenario layer constraints and subareas Among these GIS shapefiles the most important shapefile is one used as scenario layers in ET The scenario layer GIS shapefiles serve as blank canvas where users paint scenarios Based on the geometry scale users selected ET creates various types of GIS scenario layer shapefiles within a file geodatabase through the ET Project Setup function this function will be mentioned later Using these scenario layer shapefiles users can produce up to five different scenarios in ET and land use patterns of each scenario are stored in separate GIS scenario layer shapefiles When there are physical conditions that can limit development in the targe
156. ttings allows users to define basic project properties This step consists of three sub steps First at the top of the window users first determine which file folder they want to use as an envision project work directory and name their new envision file geodatabase name for scenario planning Second in the middle of the window users can select scenario planning geometry and set up the project extent As we learned in the STEP 1 Selecting Geometry section users can choose one out of the three geometry options parcel grid and hybrid cells Third at the bottom of the window users should choose the Scenario Builder file that will be linked with the file geodatabase Also based on the GIS data added in the preliminary step the coordinate system used in scenario planning is already set up 84 Page Go to the folder where you want to create a new workspace folder 85 Page ENVISION TOMORROW PLUS USER MANUAL d tree CT 00 Smp I Pro Sage OmnI Connuem Stan J Lar Us Spd Fuel Man 1st part m setting workspace purse m ob directory and the file lip 5 is geodatabase name Mkataa Sete C Paras Cey M Go Gata ey C Fass tr Cad put rupi Sa ae 2nd part boo Selecting the planning geometry and the project extent larum Parcel Soom 3rd part Selecting the Scenario Builder spreadsheet file To direct the envision project workspace directory click the gray color folder icon Anot
157. ulate selected records ody 132 Page ENVISION TOMORROW PLUS USER MANUAL Now you have a new field that has the square footage of each parcel in the target site The areas of each parcel are calculated Using this calculation results you can operate the Bottom Quartile Method option in the Redevelopment Candidate Apps tool and get the same result Running the Redevelopment Candidate Apps tool ami Pitara dnas Hol aul ferme Wee pe Budd eum Fami Ma Se deimcl Lamm mium Fut Lans wm deam numm P UP EUH fer uep bup 4i deer ie ue E aaa Lene aa e cam ee ee HE LA B T EFE 45 cu oe e Fe F 2 A LA Laca Ej imm roc j Phare pees P Lr ii r m LB 133 Page ENVISION TOMORROW PLUS USER MANUAL The Local J obs Housing Balance Tool Another important indicator for analyzing existing conditions of the target site is a jobs to housing J H balance The balance or ratio of jobs to households in the various subareas within a region or city can be an important indicator of the health of a region Ifa large mismatch exists between employment and housing in one or more subareas then significant in commuting and out commuting will occur putting pressure on the transportation system and adding to household transportation costs The ratio is all housing relative to all jobs not necessarily jobs where the persons in the households are employed As jobs are a surrogate for dest
158. umns that shows properties of each development type Data such as housing units per gross acre average density by housing type jobs per gross acre average density by employment type Land Use Composition and Mixed Use Score Entropy are automatically calculated or imported from other tabs the Development Type Streets Building Inputs and Development Type Attributes tabs Users only input values in the Population Factors columns such as Abandonment Rate Population Production Factor and Redevelopment Rate For example users can set up the redevelopment rate based on their scenario target goal 100 in general view When you press you can see more hidden data related to the column with that icon eee input data imported from other tabs npa E P amp do 22722222232223 232232322232232123733 3323222223223121312232221232122322311233 13333112332231313332123233323 3 33 330 2332211333332121212323111132323222311133J 312222113321222111322212112332313213333 Input cells Red and output cells white purple and dark red data are imported from other tabs such as the Dev Attribute Building Inputs and Dev Type Streets Development Type Names Imported from the Dev Type Streets tab up to 50 types 72 Page ENVISION TOMORROW PLUS USER MANUAL On the righ
159. under development there are several cases using Envision Tomorrow The Chicago Illinois region uses the tool to conduct housing studies Baton Rouge Louisiana is analyzing future growth scenarios while the Southern California Association of Governments in California is examining the potential for greenhouse emissions reduction through different land use policies In Portland Oregon the regional government Metro is refining their ability to test land use and transportation policies through scenario planning Smaller cities like Waco Texas and Mountlake Terrace Washington have found Envision Tomorrow to be a valuable addition to their planning toolbox Recently as a pilot project using Envision Tomorrow Plus Envision Utah is now working on creating scenarios at 3900 South Meadowbrook catalytic site Salt Lake City Utah etropolitan esearch Ea TAR LITT M Ls k c USEiSI joye How we grow matters 6 Page ENVISION TOMORROW PLUS USER MANUAL A Blank Page for Future Editing 7 Page ENVISION TOMORROW PLUS USER MANUAL COMPONENTS OF THE ET ET System Framework The ET system framework consists of two main parts three major components and three standalone tools Three major components includes two excel spreadsheet templates Prototype Builder and Scenario Spreadsheet and a GIS file geodatabase Without these three components users cannot create their scenarios in ET Each component interacts with one
160. use employment project value and infrastructure cost changes by scenarios In particular in the infrastructure costs table users should enter some input data about scenario time horizon population painted outside existing census defined urbanized area existing annual per capita outlay costs by infrastructure to make the standalone app tool work Travel App Link P Biebie P Phi ida Pe m i WED m H pup fee e bea MB anas m aba Except for a few input cells data in these two tabs are automatically imported from other tabs in the Scenario Builder Also it s up to users which means optionsal to decide whether they use the standalone tools to analyze their scenario in details Fiscal Impact Tool FIT Link 40 Page ENVISION TOMORROW PLUS USER MANUAL ET File Geodatabase The last important component that users should use in scenario planning in ET is an ET File Geodatabase Scenario Layers Linked with the Scenario Builder a file geodatabase allows users to create their scenarios by painting the polygons of the scenario shapefiles and send baseline information areas and development types of the painted polygons to the attribute tables within the file geodatabase and the ET Scenario Builder for producing various outcomes of each scenario Also while painting polygons in the target site users visually understand land use patterns of each scenario If users operate ET analytic tools for their sce
161. veled VMT trips by different transportation modes and change in pollutant emission by housing types and units Numerical data inputs Equations Coefficients Indicators Stand alone tools Estimating Vehicle Mile Traveled VMT trips by different transportation modes and change in pollutant emission by different mixed land use types development Estimating total monthly household costs for various residential types and Indicators Equations Where within ET ET Scenario Spreadsheet Project Info tab Summary New tab ET Prototype Builder spreadsheet ET Scenario Spreadsheet Project Info Building Inputs tabs Summary_New Summary_Total tabs Existing Energy and Carbon Residential and Commercial Energy Coefficients tabs HH Travel Standalone App Tool ET Scenario Spreadsheet Household Travel Model tab E Travel App Link tab MXD Travel Standalone App Tool ET Scenario Spreadsheet Travel App Link tab ET Scenario Spreadsheet Summary Total tab quality and climate changes Numerical data inputs Equations I Indicators Estimating impacts of scenarios on air Numerical data Wem TW inputs Measuring fiscal feasibility impacts of lt n i r building prototypes scenarios or building p yp micao Standalone tools ET Scenario Spreadsheet Project Info tab Summary Total tab
162. velopment Assumptions Y Construction cost square foot v Property acquisition costs v Average rents v Average sales prices Actually when you create scenarios using EI you may need multiple building prototypes However the Prototype Builder spreadsheet can contain data for only one building prototype Therefore you need to keep the original Prototype Builder file as it is and save that template under a new file name for the building prototype you want to work on Therefore click Save As in the File menu rename and save it While creating various building prototypes you will have multiple i Microsoft Excel spreadsheet files In order to manage these file properly creating a new folder and saving these files there are highly recommended Creating a new folder Name your file Click ENVISION TOMORROW PLUS USER MANUAL You are now ready to fill in every blank in the Prototype Builder spreadsheet As we already learned in the previous chapter the ET Prototype Builder also has four input tabs Physical Input Basic and Advanced Financial and Gap Financing Options tabs However the main difference between the Scenario Builder and Prototype Builder input tabs is that the input tabs in the Prototype Builder contain the Dashboard at the top of the tab which explains the performance of the building prototype As mentioned in the previous step data can be obtained from various data sources produced by federal st
163. vironmental development of the target site The Proximity Tab allows users to analyze the extent to which each scenario brings new housing units and jobs into the target site due to amenities Although there are input cells red cells in the tab users do not need to enter input data here because these input data are automatically entered through the ET tool called Proximity Summary When users operate the Proximity Summary tool in ET this tab writes calculation results of additional housing units and jobs by each scenario within a user defined distance of the GIS amenity layer Also this tab calculates percentages of changes in housing units and jobs within the buffer distance How to operate the Proximity tool and interpret the output data will be mentioned in the Chapter 6 Analyzing Scenarios Em i Stenaria Manening Uer SEDIBUS UTER e When operating m 7 EMF u a LEER SEXES s Ep pi E p 1e i1 Summary tool M Ep p E Ji SS pf 1f e iie 4 this tab writes SSS SSS SS SSS SS SS E t H LE pee oen SSS peer pue La EE LESS LLL uet poem Values OT new 7 tel housing units 3 SSS SS SS e p SS SS Se a EEEE and jobs within T EE SS SS E33 SS Zn SS SS SS SS the buffer n Ep j SSS Edi EE 3 Edi i Percent within Buffer T aida mem enm Pme grind sss l artis s Based on the zi cre ni 2 results above i percentages of 34 e g ni housing unit and ni i j
164. w will come up Click Next and follow the instruction to install the ET software Welcome to the Envision Tomorrow Plus Tools Setup Wizard The installer vall guide you through the steps required to install Envision T omorrew Plus Tools on your computer WARNING This computer progam i amp protected by copyright law and intemationa treaties Unauthorzed duplicabion or distnbution of this program or any portion of t may result m severe cral o cnminal penalties and vall be prosecuted to the maamum extent possible under the law Installation Complete Envision Tomonow Plus Tools has been successfully installed Check Olose to ext Please use Windows Update to check for any cntica updates to the NET Framework Now ET is ready to use ENVISION TOMORROW PLUS USER MANUAL Showing the ET toolbar Since ET is an extension of ArcMap you also need to have ArcMap to use the functions of ET Generally when you run ArcMap after installing the ET software ET toolbars are not shown in the ArcMap To show the ET toolbar you click the menu Customize Toolbars In the menu Toolbars there is a toolbar named Envision Tomorrow eee Customize Windosi Heg Advanced Editie Teolban Po Animation Extenisona Archean Add in Manager COGO Custome Mode Data Driven Pages Style Manager Date Frame Tools ArcMap Options E Dimnbuied Ueodatebase i Dee Edit Verbo w Editor
165. xed use Development MXD Travel Standalone App Spreadsheet In ET the term mixed use development is defined as follows e It is development consisting of two or more land uses between which trips can be made using local streets including walk trips without having to use major streets e may include residential retail office and or entertainment e should be 960 acres or less If larger it is out of the bounds of the MXD Trip Generation model As one of the 20 ET apps the 7D Transportation Effect App plays an important role in analyzing the impact of changing land use patterns in scenarios on transportation Based on the assumption that MXDs with good accessibility to external jobs tend to generate more external walk and transit trips and shorter external vehicle trips the MXD Travel Standalone App spreadsheet allows users to estimate trips by different transit modes Vehicle Mile Traveled VMT transportation costs traffic accidents and transportation emissions as the HH Travel Standalone App does Unlike the HH lravel Standalone App tool this tool uses all 7D variables including demographics to characterize residents of developments 1 imn pru b d aimes di E dex ad l SN E 4 sor L L i a a e d f I am Lama mur F ma dt f uut f ma muc s Mull EMERGERE PED EH T im Thies WERL T lj jii aN T F m rm m e E LEZ EGGENHEGS EE
166. y S by parking types Bement n Faskting feriens a Prem mmo firi kpr Hcr js Barman imee ec et dora Tiea Lamm m Np DU a a nig Se Gp Pd ee Hiinani Bih eA ere ee m 24 Vut pusmewpn a rta uid LEE 2J Commu Pans Hn 34 Reti aby zs CH T mg Fy Baty 27 Pubit bey FE 3 2i DOccupascg Rate Pj Es in Tur 1 Lng em Ria hwo Sas ee ee eee 3X9 Repo bs TE J1 My Ig j rage ey ey AZ Rad Ew H 15 LEBCE TY Fia LL Mud BEA mim I5 Ganda Fanin een rue mon dni rear Hi Public CEN iF 3 Pra Direnka eR lola Dada Sere le Dri Sera a Lahe ee oe ee 43 Lone cur A bl ry Hand coa Wo Durand cime ana 41 Lae primer ilg es 5 raw landi 7s Lee che AT Drumddibna d CASH TS andi 34 Lx te ee o ee Unlike the other input tab this tab also includes an output table Basic Financial Output so that users can immediately figure out the basic fiscal performance of the building prototype By calculating hard costs such as building construction and parking construction costs this table summarizes the total costs of development of the building prototype z Basie Financial Inputs ro Dikit Ninatoa Oulpsla 74 Building Consiadion Hard Costs T2 Faring Consincion Hand Costs 73 Total Project Canis 7 8 Page ENVISION TOMORROW PLUS USER MANUAL Input data in the Advanced Financial input tab are closely related to more in depth fiscal assumptions such as building efficiency fina

ENVISION TOMORROW PLUS (ET+) USER MANUAL

Contents

Download Pdf Manuals

Related Search

Related Contents