"user manual"
Contents
1. Selected Crossroads Your selected parameters will appear in the boxes at the top of the form Step 3 Click the Timeframe Date and Impacts Selection tab which is located at the top of the form to select the timeperiods days and impacts to include in the query 11 Metro Incident Selection Tool 169 TH 122 00 172 127 00 813 2003 3 Highway Begin Ref Pt End Ref Pt Year Month Highway Z Month Timeframe Date and Impacts Selection Utilities Reports Save Data Only include incidents from Count Incidents 06 00 15 00 to and to 03 00 18 00 INCLUDE Hint Each line represents 30 minutes E Ora You can chan ge the 12 00 AM 12 00 12 00PM E iW ath 12 30 AM 12 30 12 30 PM values 1n the top 1 00 AM 13 00 1 00PM cc i MTW Th F five boxes by 1 30 AM 13 30 11 30 PM a 2 00 AM 1400 2 00PM Sat Sun hand instead of on py mkt 2 30 going back to the 6 UL UU PH E No Impact 3 30 AM 1530 3 30PM first tab 4 00 AM 16 00 4 00 PM V Minimal Impact 4 30 AM 16 30 4 30PM l 5 00 AM 17 00 5 00PM M 1 2 mile ie This way you can 7 37 5 31 Ph igher impact incidents 10 00 0 UU AM unknown included for 18 30 6 30PM older data month for the same 19 00 7 00 PM set of parameters 19 30 7 30 PM 20 00 8 00PM 08 30 9 30 AM 20 30 8 30 PM 09 00 9 00AM 21 00 9 00PM 09 30 9 30AM 21 30 9 30 PM 10 00 10 00AM 22 00 10 00 PM 10 30 10 30 AM 22 30 10 30 PM 11 00 11 00AM 23 00 112. sNNESO gt gm Minnesota A Department of Transportation G OF TRA Q RY LOO RTAT O N 3 O gt Metro Division Traffic Engineering Data Extraction Cookbook September 2 2003 D data extraction cookbook doc Table of Contents I CHAPTER 1 INTRODUCTION eeeseseoccsccococococococosocesecosececeseseseseseseseseo I CHAPTER 2 BACKGROUND esssccsccccococococososocococosecececececeseseseseseo A USER REOUIREMEN I Sorena B USER SUPPOR T aec a A C FOCU MIN ee a E T D STARTUP PROCEDURE rariora kenara a eds HI CHAPTER 3 DATA REQUIREMENTS eosseoossecosseosseeosseecoseossseoo A WEATHER IMPACT Sei sree erste a a vanantaresadedendiecactadanoetds yascatenssue B INCIDENTS IMPAGC PS seicinteietetvcndacee a tee a aaa C DETERMINE PEAK PERIODS cscescscecscoscccecscescscecsccscscscecesescecececens D IDENTIFY MODELING PROJECT LIMITS cccccceccecscecceccscesceccscescecees IV CHAPTER 4 EXTRACT SYSTEM DATA ccecesceccecs A IDENTIFYING DETECTOR NUMBERS ccssceccececcecceccscecceceecscecescescesees B DECIDE ON THE DATA PULL OPTION cccccecescecescecescscescscecesceceeees C SELECTING THE MAINLINE AND RAMP DETECTOR NUMBERS 2 D DEFINE DATA PULL PARAMETERS ccscesceccecesceccecescescecescscecescescesees E EXTRACTING THE DATA ooosesesesesesesseseseseseseseseresesossesesesesoroeseseseseroesenes F SAVE DA A a ete coeds oto t
3. Dansiiy EES Oeanehy TEES Oanaiy 1160 Densily i1161 Dsnaily 1162 Density i ja UAir FRE TO eT TESOL TaN Bao TO 162002 IAB 1a eaoe OME 2002 Ta BT 1162002 Oe ao IDM E02 IO 106207 IDE BOT2 iiig IIRA Den LELA n E TOE iteng Bae 1 Bao 6 15 Ohi 15 Shab 14 as 121 0E 29 4119 19 7236 ELETAN TEE SERE BEET 30 Baro ET 2057941 30 08677 19 623 Tmz 0331111 4 aa TH SEATI 1a 13a 24 75128 War 24 Fea 1368 6 30 AM 16 26567 35 SEE 371 Oa oe TET aT 3 19151 26 5916 10 01556 77 306 36 39148 a TEES 2 GTE TREES 71 13i ei B52277 576 BEE 444111 Mae 2815508 Za 276127 2 41111 6 45 Ae a as 44 10664 46 HdE 411391 4097468 HH 49 30190 14 57 TTE 26 254 47 0606 BOTs 31 7445 el ad 26 33736 40 0716 6 20007 1341776 EE IEEE Tad 31 52205 20 4766 ALO 2501776 Oa SAS a E SA OG rA 7 36 AES arat aa I Se id SWEDE SE 15603 W101 3 46 6046 13 EEE 2 TAA 1 SCO LART EE 31 22916 W Midd 5 37 61081 36 65216 7 E HEES 1d 18 24445 2b AETH 31 53645 25 24566 3 51665 41 205 5 Po Af 7 d 17525 Bz Tbe T 45 01801 CE EEES oe 41 B165 11 76 HATH z He 5 IE METE 2 20 5266 e 2443063 oo Ed BES ear at 7 CSS aata ff 17 SES oo 20Gb 2 23 0601 SUEETRE J 6 18 36 6571 1 Moab teem Jal 4065111 40 45 d E657 23 06539 3 62555 16 B5593 28 6061 73 6696 z4 15291 2d
4. 169 TH h Month 100 TH 110 TH Optional e points 163 TH Accum Miles Entire Highway 130TH P22 TH 113 685 CR 18 380 TH 114 526 Minnesoka 394 I 115 015 Selected Crossroads 108th St leggy i 116 351 When pour selections Pioneer Tr FO 117 098 appear above go to Anderson Lakes Pk 1204 00 129 118 345 the More Selections Anderson Lakes 1204 00 820 119 036 PEIRE Highwood Dir 121 00 570 115 686 November 494 l 122400 172 120 023 December Waley View Ad 123 00 131 120 971 G62 TH 124 00 345 122 189 212 THI 124400 358 122 198 Cea Aecio Lincoln Dr 124400 944 122 r04 Bren Ad 124400 944 Tee r04 ith St 125400 949 125 789 Excelsior Blyd 126 00 70 4 124 544 T TH 127 00 449 125 299 bth St 127 00 813 125 653 Minnetonka Blvd 128 00 272 146 112 orm F Figure III 4 Selection Tool Main Form Highway Month Tab Step 1 Select a Year and Month A year must be entered The current year is entered by default Select a month by clicking on the drop down button and clicking on the month Step 2 Select a Highway Start by selecting the Highway from the drop down menu or just type in its number in the box The program will automatically generate a list of crossroads You have the option to select the entire roadway or a segment of the roadway by clicking either Entire Highway or if you have selected two crossroads
5. 57 16 47 55a 19 66054 36 391 22 14 64461 13 01 W 1 r 444444 11 73778 1j Siit 24 691 HJ 30 5136 dr 1234 20 10278 30 68778 B45 AM 13 023778 23 93543 15 07m 2 3444 13 16617 2 46127 3449155 12 0667 24 40 162 4259 FEF adid 9 640972 a2 41 059 24 84809 30 24214 54 a OBB 10 6933 7 Erim 2475225 3 00372 ar JE TEE 5 11445 Poe f g ETS wi fore a 18 S50 THIFSA 11 SSVWEBTH TISH 12 IDAE RTH ISM EEEE NE TE i eo CA ers B WEB Data S minuaa i Y Values Chea Baas ce Eae Ghare 5A ery aoa Etsem Soanten EN tg m E Extracting the Data Once all of the parameters have been set the data is ready to be pulled Simply click on the File menu at the top left corner on the tool bar and select Extract Data Data Extract will notify the user when the extraction is complete e Verify the data file was created and stored to hard disk Go to the d temp directory and open the file e Verify the data is in the correct format This is a good time to note the detector s that are bad e Rename the default Excel files if you have selected the Data file format For example if an extraction was performed in which volume data was pulled into a Data file the file will be named data You will need to open and rename 394EB Data this file after the extraction is complete 32 SHEB Daia F Sav
6. M M M765 100 M M M esd coon We ee el A a AE 0 M M M634 83 M M M orice rae ed NJS T 0 0 0 M M M206 27 M M M 14 69 54 62 MM 3 00 24 0 0 0 M M M452 60 M M M i5 cee N 7 o 0 o0 00 o M M M753 100 M M M i6 6 49 66 M O0 10 00 0 0 0 M M M750 100 M M M i7 ere B3 eo M y0 m d 000a 0 0 0 M M M65 87 M M M 1 amp 8 76 6z 69 M O0 40 09 0 0 0 M M M440 59 M M M Figure III 3 Local Climatological Data Step 4 Check the weather information recorded in the Mn DOT s Incident log Step 5 Update the calendar of possible date s and proceed by checking for incident impacts B Incidents Impacts The IncModeling mdb is a front end database linked to a copy of the Mn DOT Incident Log database This front end program streamlines the preprocessing of the Incident Log database to help identify incident impact days that should be eliminated The end user is able to query the database by specific criteria year month highway and impact type which is selectable from the main screen To access the front end application click on the MIST Metro Incident Selection Tool icon on the desktop This will automatically bring up the front end form and link you to the database 10 This is the opening form Metro Incident Selection Tool e ae TS Yd a Highway Begin Ret Pt End Ret Pt Tear Month Highway Month Timeframe Date and Impacts Selection Utilities Reports Select a month and a highway Year 2003 Highway
7. Metro Modeling Unit Pannen Moneda manone inde Tylor 51 634 2126 Table Il 1 1 Support Area Contact List C Equipment The workstation provided has been configured to facilitate your data extraction process The system is set up to allow you access only to the systems information data and software packages required to perform the functions necessary to access select extract and store data identified within the Data Extraction Cookbook Desktop icons have been developed for each application software package 1 Office Packages The following office packages are loaded on the workstation e Access 97 This is the version of software currently used by RTMC for their detector ramp meter and incident databases Office 2000 Word Office 2000 Excel WipZip version 8 0 Ez CD creator version 5 0 Several data extraction programs have been developed internally over time for different purposes Below provides a listing of the tools programs available to you and a brief description of how they can facilitate the data extraction process a DataPlot Program DataPlot is a program for visualizing freeway traffic data in the Twin Cities Metropolitan Area DataPlot has access to 3500 traffic detectors on the instrumented freeway system The All Detector Report provides a listing of available detectors This document is available to you in many formats e lt A hardcopy format can be found in Appendix A All Detector Report e On li
8. Periods The peak period varies considerable across the Twin Cities Metropolitan Area roadway system Mn DOT typically uses 6 00 to 9 00 A M for the AM peak and 3 00 to 6 00 P M for the PM peak This peak period changes significantly as you move away from the central business district toward the outer beltline The DataPlot program is used to review the mainline detector stations and to determine the peak periods Step 1 Select the DataPlot icon from the desktop This will bring up the DataPlot main screen 16 DataPlot 2 1 13 MN DOT Traffic Data File View Time hour of day 4 6 8 H 12 14 16 18 a 40 E Flow vehicles hour A lt Beg July 2003 Ea E Smoothing 20 Minutes EE Eee ce sc ee a i 2 fag Se ea ee ee 24 A 25 26 30 34 Enter detectors a a e a eure I 9 DataPlot Main Screen Step 2 Select the date from the calendar by using the arrow tabs to select the year and month Click on the date to select the day Step 3 Select 15 minutes under the smoothing tab Step 4 Enter the mainline detectors by entering the detector identification Example On TH 100 WB the mainline station is 419 Station 419 is made up of three detectors 1298 1299 and 1300 Make sure that all the detectors entered are actively recording data 17 Dat aPlot 2 1 13 MN DOT Traffic Data ____Detector__ _Field _ Sample Volume 1298 100 66St51 24
9. Speed CSV sanean a aa edn area dm 29 Figure IV 5 Data File Example Volume CSV erann E O a 30 Figure IV 6 Data File Example DeMsity Csv nossssssssoenesssssssscerrsssssssscererssssssseeeeresssss 31 Figure V LIRIS Report Main Men masrana ieentenhie aaseaesGebedavasatiueeiec 34 Feur V 2 Ramp Me Er Anail StS er enia teste da miuntausamenetaewetehetes 35 Figure V 3 Ramp Meter Timing Example aiurria a E 38 Acknowledgements I want to acknowledge the contribution of the following individuals for making the Data Extraction Cookbook a reality Tim Johnson developed and customized the DataExtract program to meet our modeling needs This task reduced the time to extract system data from days to a few minutes Denise Hesselroth developed Metro Incident Selection Tool MIST and supportive documentation MIST is the front end application to Mn DOT s Incident log database Denise took this opportunity to work with RTMC staff and make enhancements to the Incident Log Jim Cray was instrumental in setup and configuring the data extraction workstation at the Waters Edge facility and working through the security issues Teresa Hyde provided valuable supportive system data and information including the All Detector Report Ramp Metering Status and Ramp Control System that included in the Appendix I also want to thank Deb Bishop for reviewed and edited the Data Extraction Cookbook Chapter 1 INTRODUCTION This Data Extraction Cookbook was put t
10. belor looks suspicious or you do not fully trust the source do not open or save this file File name mptl4b5e cev File type Microsoft Excel Comma Separated Values File From tm tomcat dot state mn us Would pou like to open the file or sawe it to your computer Open Save Cancel More Info M Always ask before opening this type of file Step 4 Enter a unique filename for each meter We recommend using the metering identification in the filename _ Microsoft Officeg _ Microsoft Visual Studia 3Corm _JInsternet Explorer Accessories J Adobe J American Systems _J Intel _ NetMeeting __ Network Associates _ Of ficeUpdate _ Oracle _ Outlook Express _ Roxio Sign 4D _ TextPad 4 _ Trafficware _ Internet Explorer InterPlot Client _JISPILOT JJAMAR _ Java J Java Web Start A hicTrans J Borland _ common Files ComPlus Applications I CORSIM Tools My Documents Adirectx My Computer ec i z is wj File name My Network F _ microsoft frontpage _ Dualmgr _ Microsoft Office _ FHWA Save as type Microsoft Excel Comma Separated Values File Cancel eee eee ee eee ee eee eee eee eee ere eet eee eee reer et rere rer ere eter terete eer er terre rere eter ere ere ree eee eee ete eee ee teeter eee eee eee rere rer Step 5 Repeat this process until you have stored ramp meter timing for all affected ramp meters St
11. html Figure II 2 National Weather File Step 3 Build a Calendar The calendar should identify all possible data extract days Start by eliminating Fridays Saturdays Sundays and Mondays and any days following a major holiday When selecting dates in September and October remember to exclude the day after Labor Day and Halloween Review the weather information provided Pay particular attention to columns 7 WTR precipitation 8 SNW snowfall amounts and 16 unusual events Snow dates and dates flagged in column 16 should be eliminated Precipitation of 20 inches or greater should be eliminated PRELIMINARY LOCAL CLIMATOLOGICAL DATA WS FORM F 6 2LATION CHANHAS SEN MONTH SEPTEMBER YEAR 2002 LATITUDE 44 50 H LONGITUDE 93 34 W TEMFERATURE IN F PCPN SNOW WIND SUNSHINE SEY PE WND Oe ee ee ee ey a T EMI ee ec aa eoe T Te AVG MX 2MIN DY MAX MIN AVG DEP HDD CDD WTR SNW DPTH SPD SPD DIR MIN PSBL 3 3 WE SPD DR 1 Se or ae GO aie ood Oe o M M M460 60 M M M 2st eA a Siler a Oem 0 MoM M713 390 M M M 3 6 amp 2 55 63 M O0 40 00 0 0 0 M M M790 100 M M M 4 6 amp 4 55 70 M O0 50 00 0 0 0 M M M766 100 M M M 5 g4 6T re Mo 0 1i 059 00 0 M M M458 55 M M M 6 54 63 74 M O0 92 65 0 0 o M M M637 82 M M M 7 91 71 51 M O lie Demo 0 0 0 MoM M707 91 M M M 5 69 67 75 M O 13 0 00 0 0 0 M M MO 31 M M M 5 69 69 79 M O 14 TAE 0 M M M643 83 M M M aH e slg Cee 0 8 La o M M M307 40 M M M ile re a2 yegane i oro o0 S00 0
12. 00PM 11 30 11 30AM 23 30 11 30 PM Figure III 5 Timeframe Data and Impact This 1s the second tab Incident Selection Form 169 TH i22 00 172 127 00 813 2002 js Highway Begin Ref Ft End Ref Ft ear Month Highwap Month Select More Selections and SAWE Data Tables Reports Only include incidents from Count Incidents Save Data 06 00 15 00 to and to fos 00 18 00 INCLUDE 12 00 AM 12 00 12 00 PM 12 30 4M 12 30 12 30 PM 1 00 AM 13 00 1 00PM 1 30 AM 13 30 1 30 PM TM 7 Ww Th F 2 00 AM 1400 2 00PM Sat Sun 2 30 AM 14 30 2 30 PM 3 00 AM 15 00 3 00 PM No Impact 3 30 AM 15 30 3 30 PM 4 00 AM 16 00 4 00PM I Minimal Impact 4 30 AM 16 30 4 30PM 5 00 AM 1700 5 00 PM M12 mile Impact 5 30 AM 17 30 8 30 PM de impact Ean 0600 6 00 AM 18 00 6 00 PM fe wage eect 18 30 6 30 FPM older data 19 00 7 00PM 19 30 7 30 PM 20 00 8 00PM 08 30 5 30 AM 20 30 6 30 Fh 03 00 9 00 AM 21 00 9 00PM 09 30 9 30 AM 21 30 9 30PM 10 00 10 00 AM 22 00 10 00 PM 10 30 10 30 4M 22 30 10 30 PM 11 00 11 00 AM 23 00 11 00 PM 11 30 11 30 4M 23 30 11 30 PM Figure III 6 More Selection and Save Tab 12 From here you can further narrow down the selection of incidents Choose a timeframe for the AM rush hour and the PM rush hour O If you want to include all times just click on the pre selected times to deselect them If you select more than two times the program will only use the first two selected ti
13. 15625 2 opp r E2555 11 56567 14 04 od BF cab 29 Cir44 2 04 r 20 AG 53 0727 B 15AM AH 641 i 0 30851 42 4511 48 B5268 69 26015 J2 5429 43 7766 17 45313 25 04572 35 9574 18 47556 30 20618 J6 02538 20 1065 dd 62582 1 791111 8 06889 1055111 4 41333 24 DEF HZ 10 6424 26 7 600G 26 e608 48 5089 Figure IV 6 Data File Example Density csv 6 Select the Export Options There are several data export options available including values sum average time median day median and sample Select the export options by clicking on the box next to the value For example if you want the raw data values volume density and speed select the Values option by clicking on the box in the lower right section of the Data Extract window 7 Select the Time Ranges Configuration Use the Time ranges in drop down box to select the configuration of the time field in the 394EB Data file that is about to be pulled To set time ranges to a columns format click the drop down menu and select Columns Either Column or Rows can be selected but be aware that the number of columns are limited within Excel This may cause a problem when extracting large datasets To set time to be in rows click the drop down menu and select Rows We recommend selecting the Rows time range format to eliminate this problem 31 E30 AM DAN EFE p3 30 31111 AH 2h653 61 03621 42 004 42 S210 10 34 25 0225d 35
14. 2 JST Ed SO OTHE 62 ro Sul Gi Fay 53 A maisar 53 Bile 61 ay 23 FEE 60 57156 63 1078 a ar BOTs a 0S 51 61T41 25 AET 24 1 Parada 73 SE Pagar T Le Haus E P00 Ar 4053315 23 06 26 fai 12 i BSAS 43 BDE mo TTBS 51478 15 ere 35 12506 19 0 7 aver 20 oo Bo Sul 26 1574 1 61 308 23 25108 47 2155 26 A013 HNE TOT 727212 EET ELETT 2 REE H T15 A a0 AE 2b 00S 73 P3166 3h TESS ETE pre La Ea Sae 20 TAGS BD 1D 61 12236 ALOT ES BO dii p2 Tie ED SE 51 1906 WAIHI 51 0537 77 BEES 28 ESS Fa T gr 72 OT GEG 156 bo S136o 33 47635 r a Ai Sd EEO 4 00176 26 aa 11 Bul Te 42 35545 66 tare oF oe 2 CECE 61 60115 ba 206 B SES een EEA Bo EDES 62 31606 BO Feast DAT S15 7S 66125 26 SES TIBIE Fip E4245 G TORS 35 Po Ia PS AF EAR THEE 2a ZEEE 255 1S SB 1ESE 7 ose fe 606 Sa CUS 21 6275 61 See 6S 7146 20 0542 Bo cues B36 1858 cece Lo MT Pe 2G Sse 51 e756 76 BOGE 36 23506 Pd Be 72 S00E3 EE TEHA be Scar 55 406s pe a0 4M 22 02455 22 236 24 20404 35 2 soo 4 36 TEHA ES 7D 56 HEG Pa ie Pate HAIr 56 ES GOGH 21 ESOS Bl E2 Fa 0626 Bt ooeao BSCE DE 61 745 za 24151 7D BMS 733416 722203 78 251 SERS 20AT Ce oeei Bd 7464 8 ED onece Bd BESO 31 51991 eret 75 31161 EEA eN 1 Gb 72 20006 PARESE E 2 Bott ty Figure IV 4 Data File Example Speed csv 2
15. 4 99 97 18 936 Example On TH 100 EB the mainline station 377 detectors 1260 1261 and 1262 Detectors 1260 and 1261 are bad fa Field Sample Volume 1260 100 66StN4 94 13 0 1261 100 86StN2 99 13 1262 100 KRSIN3 22 3 100 18 Step 5 Select the view tab in the left hand corner of the screen Highlight the Y axis and select speed parameter This will display the speed profile for the same date and year selected File Time hour of day 6 8 10 2 14 4 18 a A a M Flow yuu z 1 Headway cy z 2000 7 Occupancy re G Density E ee am i Cal 1000 Speed a Speed miles shou E E lt lt lt October 2002 gt gt Smoothing 15 Minutes m S M Tu W Th r S Date Wednesday October 16 2002 Field Sample Yoluma 16 1298 100 56StS1 24 4 100 18 393 1300 100 6583 23 9997 12 535 1299 100 56StS2 24 7 99 97 18 286 Enter detector s k Average field length Clear Detectors Clear Dates Refresh Step 6 Clear detectors and enter another series of mainline detectors Repeat step 4 for several mainline station detectors Record the AM and PM peak periods Step 7 Review the results and determine AM and PM peak periods for modeling D Identify Modeling Project Limits The modeling project limits are defined and
16. 9 3 4ReG4 40 72156 61 6443 54 6 22 0595 FA S426 64 2608 3 774 E r ES 0E2972 Bi 061 46 Ed BEGGS 31 55191 El aT E 2 3093 2 7 SiT E AON 06 4 33578 EH 4E7 1 2 Bl P22 34 56042 B45 AM 69 40021 hd ESTA 49 4043 TREIE 65 529097 55 63549 65 7564 11 46507 60 05523 i5 oodi 29 E5079 A A BS EBIBd E0 2S5 56 45097 20 57755 51 66419 27 20025 8 0046 ay 20957 74 1470 7 57696 rda 94 2459 SS ee ee ee The volume file provides the volume data for each detector and timeframe identified You should note that this file is structured in the same sequence as the speed and density file This format is helpful in identifying suspect and bad detectors Et ric note Facel Youme a I ace E E NRO Leas Sia SREY S L LE amp 1 EHG il i TE B E J E H i l H L EISSAM BS04AM BISAM FDOAM TISAM TIAM 745 4M S00 OM 0154M A I AM g5 AM IC m 1665 Volume 1062007 230 FE a 135 FER 330 4 411 51 ETE 273 d IFO volume 101R 485 572 S73 A76 a2 4 aza 40 ii an 7B Ton 1671 Yoluma 10 62002 135 15 FET FET 119 lr WT 341 136 200 EE ag lata volume 10A62007 335 ai2 aay I 4nd 1a w0 LIE TE Ta 11E 1673 Volume 10462002 495 610 Fe 599 50 Sor 549 Sig E7 e eT en 1674 Volume 104 62002 323 40g J75 a air a7 a0 3 1E wA 4 EA 1675 Yoluma 10 p002 g0 544 639 g3 aH ati T ar aa BS E 1676 Volume 10462002 J5 ia 70 a5 4 5 Gl T3 Gd 55 65 Sata EFF volume 10A 62007 300 J71 416 75 a qa 35 3 NE 51 55
17. Date mm ddiyyyy 10 16 2002 mu M T W Th F Sa Submit Query on 203 a os or 10 12 E 14 15 16 17 18 19 Minnesota Government nes Morthstar Governors rs 20 21 22 23 24 25 26 E TE ne EE EE ree 2 2325 sof 3 Double click to select a date 36 4 Interpreting Output Figure V 3 provides a sample of the meter timing output The cycle time is the time between the beginnings of one green to the beginning of the next green for one signal This includes the red yellow and green portions of the meter For ramp meter m100n32 at 7 15 am there is 10 seconds between greens for each meter Approximately 2 seconds 1s used for the yellow and green The green 1s allocated 1 3 seconds and the yellow 7 seconds This is true for any ramp meter The green count is the number of cycles in a 30 second time period This is also the number of vehicles that pass the meter in 30 seconds For m100n32 at 7 15 am the green count is 3 This means that each meter is letting 3 vehicles pass during that 30 second interval As we are using dual metering 6 vehicles can enter the freeway during this 30 second period For the parameters use 2 vehicles per green with the headway set to the cycle length This should account for the dual metering that is used at these locations Clock Time Meter Properties xj Time i x Ho metering this period Continue fom previous period f Change parameters Vehicles per Greer
18. Diki ik a Ai Hal A BL ae oe et 1 Pagar Pal tad liek kun fni eer ue ol al an web le jiii Minik oe ikad a i re Frere a E r my Pag Loco Bet ipo yori 4a MEG ih apioa A ed oe Yari Wid Fral ori Toe eater HAR Cre 5 Damparer Hig a N EHE Data Extraction Flowchart Log on workstation Determine eee Screen for Screen feasible dates I bad weather Incidents Good dates itl YES Document Aly amp Ph peaks Determine peak periods Document Determine boundary Influence area conditions Extract Identify Select data Define data pull Byers system data detectors pull option parameters No Good data Save and store data YES Identify ramp Pet einine Extract cave and Extract ramp ae control data meters metering rates store rates operations Mo ramp data YES Figure III 1 Data Extraction Flowchart Step 2 Select the appropriate file Typically the dataset used is the previous year and either late September or early October timeframe For example for September 2002 weather data select the file mpxsep2002 html Index of mpx mpxmoncli Parent Directory mpxapr 1999 html mpxapr2000 html mpxapr200 1 html mpxapr2002 html mpxapr2003 html mpxaue 1999 html mpxaue2000 html mpxaue2001 html mpxaue 2002 html mpxdec1999 html mpxdec2000 html mpxdecZ00 1 html mpxdecZ00 2 html mpxteb 1999 html mpxteb2000 html ropeteh 2001 html mpeteh 2002 html mpsteb 2003
19. En 1676 Volume 10M 62002 612 are 23 zl T 613 SEA Say TE SEE S Ie volume 10462002 i 1 A zal al an 111 m 53 75 EF 1220 Volume 10762007 725 a ave Poa TA 4i qr ao TE re Pier 1661 Volume 10462007 493 ae BOS ard 5J ahh sa SH SA Eral E5 1663 Volume 104600 199 939 Vv an a aT 307 a2 y4 E JE 1664 Volume 10162007 avo 5g Bot 555 ars sor 55i 52 Sid TE Fien IBES voluma 10 R02 7 1 g F 13 E a 1a 14 B 11 1662 Volume 1062007 G2 7d 103 7d gi as Gi 35 ogi za i00 1666 Volume 10462002 ay fd ai 75 qa m Ki a3 Ta BI 70 i 1667 Volume 10162007 7 B a F a 114 E 103 ice 15a it ry IEEE Volume 116207 144 370 323 aad a2 il 3 Lie L2 H16 410 BE 1669 Volume 10162003 463 F G7G ard SEF aun E Sii Sa coe 511 at 1160 Volume 1046 2002 70 401 449 a4 0 a2 a ie Ta 13 455 ES TIA Yoluma iUi B00 448 44 od 4 ba cs Jra a4 495 477 410 Aout E 1162 Volume 10162007 180 714 140 744 7a 27 Poy 6 2 27 D a eai 7 4 J 3 13 50 4 4 NS E m a i441 P IR yobe ie ee Ready A a a Mi See Figure IV 5 Data File Example Volume csv 30 Below is an example of the density file created El Microsoft Facel Censi cry A g pos Ede wew Deet Foret Toos Daa Windoa Helo i i H ha f Eae sie fei ha ea nd sft dle cael rd sf TEES Density EFO Oenstiy 1671 Oansity let Denety 1 amp 3 Dansity 1674 Density E75 Danaity 1476 Density le Oensily 1676 Oansity laa Deaneiiy THEO Oansiy 1661 Densily TEES Danaily 166d Density IFES Canstiy TEE Density ES Denahy TEE
20. P9494 eC ee O 6640M Figure III 7 Data Table Tab The subdirectory where the output files will be saved is shown You can change this to save to another location However if using this database on the network then all users should have access to this subdirectory Saving to the C drive lets all users save their own work without being overwritten The look up table for the highway selection list is shown If incidents start being logged for new highways you can add them to this list Those highways will only be found if they exist on the MilePointTBL table which is linked from the database copied from RTMC Metro MIS can help to make sure all underlying tables are up to date 15 Incident Selection Form 169 TH 122 00 172 127 00 813 2002 E Highway Begin Ret Pt End Ret Pt Tear Month Highway Month Select More Selections and SAME Data Tables Reports List of Reports DETAIL Basic information on each incident rotSummaryl nfo SUMMARY Summary of incidents selected View Report Can print to default printer from here Print Report Can choose a printer from here Figure III 8 Report Tab Select a report You can view and or print the report Reports are based on the selection criteria defined in the five boxes at the top and the selections on the More Selections and SAVE tab You do not need to click the Count Incidents or SAVE DATA buttons to run a report C Determine Peak
21. TOMBS 200 al d16 Ez did afd Bi 5 c Fia XI i67 Dansiy 10e E ia 2 ed Se So Ar drda 1441940 15 1053 73 066 Oe ee 2 0 E7 Speed IDB Be So EDRED DAMEA BE e EN 170 BLED G1 E0932 63 03732 BARS 5 pA TEE Volume TA EiS Siz EJT B23 CEI Cob 614 gea GAF 553 555 TEFB Density TONED en Sede M E A a eG Je AGT da bbs asa gr e pae ee abe Faj 16B paad TWIG E BOO Ei a07 COMBORE Gi 12596 612295 G3 7idbi 636091 G36 63240 3 1679 Volume 10162002 11 25 AF Ea E1 FI i1 T aa 7a IFS Danahy 10156700E L Ta SD7 167A 12164 10 24009 24 31111 15 05333 10 47555 15 47555 W 169 Speed TOGO 00 2e TE 170 ea 16 5894 20 00542 21 69075 20 41773 22 77034 a EED volume TOE 20o2 LS E at 462 BB 451 ara ai dal SEE aT J660 Dansi 10H22 2051641 262746 3 T45 5i 22 SORA 29 5706 3544 B98 30 2910 2 04554 Hia Hicem EEE EEE a i i Hye Rash er a i ar Ga Oe Figure IV 3 Composite File Example The Data File format creates a comma separated value csv file for each data type selected The files are stored on the hard disk in D temp directory For example if you selected volume density and speed the following default files would be created based on the data extract criteria selected Default filenames Stored filename speed csv 394EBspeed csv volume csv 394EBvolume csv density csv 394EBdensity csv 28 These files should be renamed and stored on disk prior to proceeding with y
22. aller modeling projects involving less than about 100 detectors per extraction An easy straight forward approach to pulling data You don t need to build Excel tables 20 Disadvantages Detectors may be missing because of human errors oversight typographical errors etc 2 Indirect Data Pull using Importing Function This option allows the user to import a list of detectors directly into the Data Extract program The user will to create an input file in any text editor Common editors include notepad textpad and Microsoft Word The document format requirement are 1 one entry per line 2 line start with either a d or s and a space then 3 the detector or station number Below outlines the procedure using Excel program and building the list of detectors and import it into the Data Extract Program This is just one way to facilitate the date extraction procedure for a large complex modeling projects For example to model I 394 from I 494 to TH 100 Step 1 Open a blank Microsoft Excel spreadsheet Step 2 Open the All Detector Report to the I 394 page Starting at 494 make a list of the entire detector numbers on J 394 in the eastbound direction by typing them into the left most column in Excel For example 1645 1646 1647 Be sure to keep the list of detector numbers organized so that they are sorted in the direction that traffic flows Step 3 Save this list of detectors as an Excel file and n
23. ame it 394EB Detectors Step 4 Insert a column to the left of the column containing the detector numbers Type a lower case d in each cell of the column next to the detector numbers 21 Step 5 Save this new list as a Formatted Text Space delimited prn file with the same name 394EB Detectors ES Hirosi teori HIY THEN l B Ble Eee em pst Famst Took Da Window Heb alaj Dea N Ee OBER NM fl ee eee A SAE O33 bal EENT Jeng XA Took MJA query is Bi Ses pt Ct _Iridents at ca 1008 oe ACY 1008 ite Hoy TTA editore Debectors Pron Common sh aiim Dim 4 _ oo palca te Docunente tip De sthop JHOY Debs Sey akin onl Cistechors Fron Conmara as fa Data HEE cE Data ee ke Data SHEE di Data SFAR E iD 0 A e DAF 2 deR Se Ii h Tra ex T ai h Me mi ras r B mr Ted force tati Tai H O Est Bos 172 coe Wa PM Sheets aes sheets 7 l ef pe la rail Beco na Mesiyas eeommein come E ENMEN BAS sm Figure IV 1 Save File Formatted Text Step 6 Open Data Extract program by clicking on the desktop icon Now the list of detectors can be directly imported into Data Extract program Step 7 In the upper left section of the Data Extract window select the detector button Step 8 Click the Import button Step 9 Select the file name 394EB Detectors prn and click OK This detector selection proce
24. e Data The data extraction for the mainline and ramp loops is complete at this point You can now proceed to store the data to disk The wipzip software has been provided to aid you in storing these files in an efficient format 33 V CHAPTER 5 RAMP CONTROL DATA This section explains the IRIS report options available and walks you through the process of identifying a list of the affected ramp meter query data to determine the ramp metering timing to use within CORSIM Below is a listing of IRIS Report Options available to assist you in extracting ramp metering information and verifying detector data The Continuity Report and Ramp Metering Analysis Reports are the most useful The IRIS user manual can be found in Appendix D i J ntelligent Traffic Management Center pe Roadway IRIS Report a nformation TMC Home Index 3 Sys tem 170 Controller Algorithm Continuity IRIS reports avallable online Detector Volume Ramp Meter Queue Passage e 170 Controller Sheets Queue Wait e Algorithm Report Vining e Continuity Report e Loop Detector Volume e Ramp Meter Analysis e Queue Passage Analysis Queue Wait Analysis 4 s Timing Report Northstar aa inol Mn DOT Home Minnesota Government links Northstar Governor s Office Search Internal Web Site MnfOOT External Web site General questions infotidot state mnus Feedback Suggestions Figure V 1 IRIS Report Main Menu A Continuity Report The continuity repor
25. e many different file format structures available within the Data Extraction program Two file formats Composite and Data have been formatted to facilitate the extracting data for modeling projects The same data and information is available through both options The data is just presented and formatted differently depending on the option selected 2J The major difference between the two options is that the composite file option places all the data in one file and the user defines the file name while the data file option creates a file for each data type selected with a default name The Composite File format allows the end user to enter a file name and writes all the data to this file filename csv Below is the Excel file created for this option Notice that the detector information volume density and speed is provided in sequential order for each timeperiod El Microsoft Fagel coeposibe serials ss E ge cocs Ed ew Inert Foma Took Daa eidon Help Dae Sa SS E So SMM al ial Ee fe rr a Ss 6 15 Aft BAAM GAM TOO aM TIAM Fae Pe AM 1668 Volume 1E 2000 z0 Finni iaf a S46 542 440 414 IEEE Denshy TAG 13546 IB2ESST 2S 1752 SRP SSS A017529 710004 67 21623 59 09311 AP neds 1902370 19 4 THES Speed TOGO0R BR TS656 Game SSSR 4055515 S025 74 Boe 12A 22 2 FP 980 J 9 49001 a i le Volume TOE 200 IEE Wa BFS ATH 4h 485 423 410 i aor arg TE Danany TONB00e 27 79736 365000 dA EE G2 EEE 71407 G2 7EBBA 7760774 g
26. ep 6 Verify that all the files have been stored on CD or Floppy drive Step 7 Data extracted from the ramp meter timing is complete Step 8 Shutdown the computer Step 9 Sign out in the logbook and enter any suggestions or comments 39 C IRIS Ramp Analysis Help Any numbers that are followed by an asterisk indicate that there is a missing value or number If a number is replaced by a question mark this means that either all of the values for that total were missing or the result of the calculation was not a number ie division by zero 1 Column Descriptions Time The start time in hh mm ss format for a 30 second interval Cycle Time The number of seconds to complete the cycle of red yellow green Green Count The number of greens given in that 30 second time interval Greens Merge The ratio of the number of greens given to the merge detector volume Queue Occupancy The occupancy on the queue detector for the 30 second interval Queue Volume The volume measured by the queue detector for the 30 second interval VI APPENDIX 40
27. ers Caoa E Tataee Soetandrec ERE Nem zm NOTE Be sure to clear the dates selected on the calendar if you are pulling data for a different project This is to ensure that no dates are selected that are not supposed to be selected This can be done by simply clicking Clear button located below the calendar in the upper middle section of the Data Extract window 3 Selecting the Type of Data to be gathered Locate the upper right section of the Data Extract window Click on the box next to the type s of data that needs to be extracted Typically for modeling examples we recommend selecting volume density and speed data These data types can be selected by clicking on the boxes next to the corresponding word 26 10 AWTR 11 SSWEBTH te 12 SWE BTH Tash Seana oo e Fame minutes amas ce Eae Ghare Bsa eers aoa Etas Soanten EN at ata am 4 Define the File Name and Storage Location To enter the file name move the cursor to the white box next to File Name in the lower right section of the Data Extract window and type filename For example for the 394 eastbound data extraction example mentioned in section 1 above enter 394 EB Data in the white box Define the file storage location by simply click Browse and select the drive and direction location where 394EB Data is to be saved 5 Select the File Format Structure There ar
28. i snus eetedd eee reoeeeeieted V CHAPTER 5 RAMP CONTROL DATA 0 0 ec cccccccrrceeeessccneee A CONTINU Y REPOR annie io ei acceteees a eae B RAMP METER ANALY SISicices solace cies based ees C IRIS RAMP ANALYSIS HELP ccceccscoscecceccsceccecescesceceecscecescescesees VEe APPENDICE E A Appendix A All Detector Report Appendix B DataPlot User Manual Appendix C DataExtract User Manual Appendix D IRIS User Manual Appendix E Stratified Zone Metering The Minnesota Algorithm Appendix F Ramp Metering System Status List of Figures Figure UFI Data Extraction PlOW Chart reeuei a E E 8 Pieyre HEZ National Weather Ie esrar a etc E Ge eels che E Wisaie vale Doan 9 Figure III 3 Local Climatological Data cc iceeeesssssseseeeeceeeceeceeeeaeaaeasaseeseeeeeeeeeeeeeeees 10 Figure III 4 Selection Tool Main Form Highway Month Tab cccccssssssseeeeeeeeeees 11 Proure TES Vimetrame Data and TMAA i eyre E O 12 Figure MFO Mor Selection and Save Ta xiccice scnciccstenessenisdiavaraenedsandtbateccteowniandsbiavenneneta 12 Pieure IE Data Table Ta Dreamen dsc ena ei tonticpdecnu ewe achasaasicestanc Un daut op decau ewe atasneveaauenes 15 Prove IFS Repon La eec a AR AS a 16 Figure Leo Data P loc Man S Cree iene eE E E EN 17 Figure Vl Save File Formatted Text resaiieseroreer dtuen e e 22 PreurelV 2 Data xtact Marni Mentinerea 23 Figure TV 3 Composite File Example serce N 28 Picure IV A Data Fie Example
29. line and or ramp detectors that are problematic The RTMC Operations unit uses this program to evaluate the existing system Reference Appendix D for a copy of the IRIS User manual D Startup Procedure Below outlines the procedure for accessing the Metro data extraction workstation e Sign in at the Water s Edge front desk and receive a visitor badge Take the elevator to the second floor turn right to the Metro Traffic Engineering office The traffic receptionist will direct you to the data extract computer workstation e Sign the data computer logbook located at the computer workstation The workstation positioned behind the receptionist desk e Turn the computer on by selecting the power switch on the central processing unit Once the computer 1s power on the main screen is configured to facilitate the extraction of system data and information lll CHAPTER 3 DATA REQUIREMENTS This chapter walks you through the process of extracting system data using the data and tools provided by Mn DOT The system data extraction flowchart is documented in Figure 1 This flowchart will be reiterated throughout the text to reinforce the steps in the process The first step in the process is to determine feasible dates that can be used to pull system data Outlined below are the steps in the process Step 1 Start by selecting and printing out a calendar for September October timeframe for the previous year Step 2 Eliminate Fridays Saturda
30. lities and equipment to extract data and information Please contact Gabriella Tsurutani at 651 634 5277 if you have a large data pull that could impact the Freeway Management System or computer network e Register at the Front Desk External clients are required to register at the Waters Edge front desk The data extraction computer is located on the second floor in Traffic Engineering The receptionist on the second floor will direct you to the workstation e Data pulls are conducted during off peak period Data extraction should be conducted during the off peak periods between the hours of 9 00 A M and 3 00 P M e Bring CD or Floppy Disks The external customer is responsible for supplying their own CD or floppy disks to store the extracted data e Sign the Log Book We ask that you sign in the logbook and record any problems questions and or comments that you may have on the documentation tools or equipment provided This will allow us a way to continuously improve this service B User Support Below is a list of resources available to you if you experience problems with the equipment and software tools or if you have technical questions Computer Physical computer Metro MIS Unit network amp office packages Jim Cray 651 582 1202 IRIS reports Tim Johnson 651 634 5252 Technical Ramp Metering status or RTMC Operation S D frame gle 651 245011 Teresa Hyde 651 634 5311 Data Extraction Modeling data requirement
31. mes If you select only one time it Add selected dates ta uses that as the From time INCLUDE the excluded list Save Data Click date s to be EXCLUDED then click the Count buthon again Ih Tow Th Thursday 9 5 42002 2 Choose at least one set of days from A ae P D W T Th F Tuesday 9717 2002 3 the center two boxes l Sat Sun Tuesday 9 24 2002 2 Wednesday 9 25 2002 1 Choose to include the smaller E Thursday 3 26 2002 4 impact incidents if you wish A Click Count Incidents Ml 1 2 mile Impact Higher impact incidents are always included P 2 unknown included far Incidents will be counted by date EEE EXCLUDED dates To eliminate holidays days after holidays days of bad weather etc Click on the day s you want to remove Click Add selected dates to the excluded list button The selected dates are added to the EXCLUDED dates list 13 i T t Incident Click date s to be EXCLUDED arash _ Count Incidents _ then click the Count button again Add selected dates to Clear all dates from INCLUDE the escluded list _ the excluded list Hint Bo Dap of week Date ____ IncCount The text of the buttons turns black Tuesday 97342007 1 F LW Th ee Serie or gray to remind you that new Tuesday 9 10 2002 2 selections may have changed the Wednesday 9 11 2002 1 M MTW Th F Tecan Se ore results that are showing Sat Sun Tuesday 9242002 2 Wednesday s 2o 200e 1 Ho
32. mutually agreed upon at the initial modeling meeting Section 2 1 2 in the Advanced CORSIM manual outlines the criteria used to identify the modeling limits Do not assume that the construction limits are the modeling limits Microscopic modeling packages CORSIM AIMSUN and VISSIM all require you to start the modeling in an uncongested state for the model to work This may require you to expand the model several miles outside of the construction limits or to modify the modeling time increments The procedure for identifying the modeling projects limits is similar to determining the peak periods The DataPlot program is used to evaluate the mainline station detectors You should be looking at the system data to determine freeflow conditions and or uncongested traffic flow 19 IV CHAPTER 4 EXTRACT SYSTEM DATA This section explains the process used to identify and make a list of the detectors that are needed to gather data for modeling projects A Identifying Detector Numbers Once the start and end points of a modeling project has been determined make a list of the detector numbers using the All Detector Report Break up the data by major freeway and direction Detectors should be recorded in the sequential order of the direction of traffic flow This same sequencing will be used in the output format Splitting up the files in this fashion helps keep the file smaller and more manageable In addition queue detectors are typically
33. ne copy is accessible from the Waters Edge workstation by selecting the All Detector Report icon e Electronic copy is available on the Mn DOT web Http www dot state mn us metro tratficeng modeling Traffic data is available from 1994 to present day This program allows the user to graphically plot system detectors The DataPlot program is capable of plotting either one detector with multiple dates or multiple detectors up to 10 with one date Refer to Appendix B for the hardcopy of the DataPlot program This program is very useful in determining if a detector is malfunctioning and to determine peak periods b DataExtract Program Data Extract is a graphical program for retrieving historical traffic data for the Twin Cities Metropolitan Area It is designed to simplify the extraction process and is not intended to be a tool for data manipulation although a limited set of manipulation tools are available A copy of the DataExtract User manual is located in Appendix C c IRIS Reports The IRIS reports were developed over time to address specific needs by the operations maintenance and integration staff for accessing system data The ramp meter analysis and continuity reports are useful for modeling The Ramp Meter report provides the ramp meter timing for a specific day This information replicates the ramp metering timing within CORSIM The Continuity report provides a means to quickly review a roadway segment and identify main
34. not extracted however this information may be useful if there is a missing or bad detector HOV ramp volumes are usually very low and not considered unless the project specifically calls for this information B Decide on the Data Pull Option This step provides two examples of ways that data can be extracted Each process has advantages and disadvantages You need to decide which option works best for your project This may change with the project size volume of data extracted and post processing tools available to manipulate the data 1 Direct Data Pull Directly enter all of the necessary mainline and ramp detectors into the Data Extract program For example to model I 394 from I 494 to TH 100 e Open the All Detector Report to the I 394 page e Starting at 494 make a list of all the detector numbers on I 394 in the eastbound direction For example 1645 1646 1647 Be sure to keep the list of detector numbers organized so that they are sorted in the direction that traffic flows e Save this list of detectors as an Excel file and name it 394EB Detectors e Open the All Detector Report to the I 394 page e Starting at TH 100 make a list of all the detector numbers on 394 in the westbound direction Be sure to keep the list of detector numbers organized so that they are sorted in the direction that traffic flows e Save this list of detectors as an Excel file and name it 394WB Detectors Advantages Faster for sm
35. oa 70 5051 66 ese Hg E ED Speed IDHAA Ti Erd EE E M E 2 60 J4 07e 24 20670 22204 2 05541 20 126 r Bre 181 Volume IUE 1 166 edo 2 29 24 ob oat 156 20 133 167 Density TOMBS 14 2756 Si Codd de ddd SS a EES FB 50 0777 51 69333 42 43111 30 71112 1507555 127 E71 Speed IDET 4558556 FATT AT PRP BI2 2765 20 63209 23 51377 24 29404 TRS ra 1A SE 162 Volume 10E 15 diz dB 461 443 458 440 416 4241 404 ig I Denahy IOE EG SVE A 44 M An 45 0180 51 66AAa 90 7519 405 46 E AM a E72 Spaad AEALOG EA JEJEG E2 C007 426E 26 16092 41 EA7950 36 6102 5 60 V FF asd i6 Ea 1673 Volume TOME O02 155 B10 ara a bea EAN 5a 5a Bid oar oJ Sad 1673 Dangly TOG 24119 5637777 49S 146R 661060 EA EASE SA OBBES 6214127 6S 0960 592815 61 PEA JN Be 1673 Speed 10E a00 6 E Ed Ee BASE JA BOSDG W ar d2 2555 o oo ra 99 2099 A ar Gee ea lune Oe TE 20S ae 400 475 458 437 433 44 25 415 45 164 Densiiy TOO 19 Tee 2h ISS S S60 OBS Fei 9910895 209598 Tbs 320da Erd Speed TOBE Bb SeSo BOG SBS SPR ol Ob ab ad MoA FoF 022 512d 35 dd 1675 Volume TOM Eria car Hl Fe B54 ba I 609 84 ari ari Sar 4 IS Dennehy TO EID Seri 366E dp db Bh 45 BRBh2 41 MBAG 44 2713 de 437700 A2 M2r TES Spaad ONBO0 EE SEE EGORA G2 42E2 Gj ddA7 09 63 7036 57 56532 54 04121 55 41643 54168 S4817 16E Volume 101E ao ES rD za 45 59 El rd Bd 6 1B Danai OMB BBS 10916 WV SBE Sarr 11 76 114 14 30657 12 4579 1039 TEE Speed TONBSO02 216066 SD BDRS SO BIEe Ad SD dE 22 DBRS 71 24071 1A NERS IRA IBF volume
36. ogether to aid external clients in pulling system data and information The demand for system information has steadily increase over the years as the instrumented system expanded to cover the majority of the TCMA roadway network The system data is used for many purposes including planning design and research Mn DOT is looking into creatively ways of providing this information more efficiently and effectively Some of the factors that precipitated this need include the new Federal modeling requirements State budget shortfall and limited staff resources The instrumented portion of the Freeway Management system is the primary source of this data The system data includes volume and occupancy data from mainline and ramp loop detectors and ramp metering rates The data is stored every 30 seconds twenty four hours a day The data extraction cookbook tool documentation and resource materials are available on the Mn DOT Metro Division web site http www dot state mn us metro trafficeng modeling and can be downloaded A copy of this resource document is available at the Mn DOT s Water Edge facility and should not leave the work area located in Traffic Engineering ll Chapter 2 BACKGROUND This chapter outlines the user requirements contacts for user support hardware and software available to customers and the startup procedure to access the data A User Requirements Below explains the user requirements for customers using Mn DOT faci
37. ogram Below outlines the direct option for pulling detector information e Print a copy of the Excel file 394EB Detectors e Open Data Extract In the top left section of the Data Extract box click the Detector button Place the cursor in the white box that is about two inches to the right of the word Search e Type the first detector number and press enter The cursor will remain in that white box Enter the remaining detector numbers in this fashion Continue to enter all affected detectors If the detector number is entered incorrectly select the detector and click on the Remove button Below is an illustration of how to enter the detector numbers 23 Db That abietiect 20 MA ADOT Troli Dais 1636 LAGE 4637 USAM sn EH 1638 Halau iiaa Leroi L 4600 USSC hEN iii iaar EUER AGa USCarlsnez hil my all 1082 UAAC IEH 46448 USIA arene 4645 LOE 1648 LISAA 38 seconda w amaj ce Eare Ghare 5A erary aoa Etas Sotana EN a tag om D Define Data Pull Parameters 1 Selecting the Time Frame and Interval Length Locate the lower left section of the Data Extract window This is where the time frame and interval length are entered For example if a project calls for volume counts from 6 00 9 00AM and 3 30 6 30PM at count intervals of 15 minutes follow this procedure Move the cursor to the white Start box and enter 6 00 Nex
38. our next data extraction Caution The default files are over written with each data extraction query Below are the sample default files created using the data file format The speed file contains speed data for each detector and time period identified This data is very useful when calibrating the existing system El Microsoft Farel Speed scr E ge DCE Edt view peat Fome Toole Data indon Heip Dea Ske eS OBE ANg 2 om al 1664 Speed IEFO Speed 1671 Spaad le Speed 1 amp 3 Spaad 1674 Speed 165 Speed 167 6 Speed IEF Speed 1675 Spaad Ea Speed 1220 Spaad 1661 Speed 1EES Spaad 1664 Speed IBES Spaad 1662 Speed BEG Speed 1667 Spaad EES Speed 1665 Spaad 11680 Speed 1161 Speed 1162 Speed bel eto ta be SY vad ja fee H al Hf Speed i 1A LEU LETE m EE LETA ne TIET 10e TARAL IAAI i in TOE 202 10d lor e200 idiei waea 1A 11202 lO 62002 idna LD Letem E Pa idna LEU LEAP a ideni 10162002 IAAI iaiia E B15 AM LS See a marar 43 Soo fl 16355 BF 84629 is JI 66 S056 21834 Bl S578 Br AT 31 30131 6475511 bb ar E 1 467 55 43636 Pin Abe Pon Pl 52 407 Sb 17 12705 5d 1257 ro arise mAH WEITE ir EEs t aT avai E 6 30 AM 63 a35 55 12938 Arri 635527 6410667 65 7031 bo Od mawa 6552033 65 Bare 23 07838 Gi 20838 65 ParrS esis Ga Pane 25 6516 52 55606 24 3855S 31315 pE SSS T5 209 ET 73 988 4101031 E p45 i 55 Sedo Sul STEW 2
39. raa a e submit Query Minnesota Soyvermment links Morthstar Sovernors Office Search Internal Web Site khinfDOT External Web site General questions infotidotstate mn us Feedback Suggestions Figure V 2 Ramp Meter Analysis 35 Click on the Ramp Analysis desktop icon to extract ramp metering rates using the IRIS Ramp Analysis program Step 1 Enter the ramp metering identification number For example m100n32 Step 2 Enter the start and end time in hh mm ss format For example 6 00 00 means 6 00 A M Step 3 Select the date This date field can be either entered directly or through the calendar icon Direct Entry Entering the date directly in the following format mm dd yyyy Example 10 16 2002 Calendar Entry Start by clicking on the calendar icon Select the month and year and then double click on the date to fill in the date field Step 4 Submit the Query Review the output file and write the information to disk I ntelligent p Roadway Traffic Management Center i j IRIS Report Info rmation ELE Home Ramp Meter Analysis System 170 Controller Algorithm Continuity Enter the Ramp Meter Start time End time and date then click the Subtrut Query Detector Volume button to see the report Ramp Meter Queue Passage Queue Wait Rarnp Twleter m100n32 a Start time hhrmm ss z 5 00 4 Calendar Microsoft dox End timethh mm ss fa 5 00 October 2002
40. ro fe 3 and headway of 10 0 SEC Take effect sec from start of time period Note if tine period 1 parameters take effect at 0 seconds metenng will begin at initialization before time period 7 begins Cancel Help Example of how the ramp meter timing is coded into CORSIM 37 5 Save and Store Files Step1 Select the Download csv file from the Ramp Meter output query screen Step 2 Select the option to save this file to disk q Intelligent Roadwa 7 Traffic Management Center Eas i M 7 Mormaiion IRIS Report S 2 UL Ramp Meter Analysis results yrem 170 Controller Algorithm i Continuity Ramp Meter M100N32 Excelsior Blvd Detector Volume October 16 2002 Ramp Meter Queue Passage Download csv file Queue Wait Cycle Green Greens Queue Queue Timing Time Time Count Merge Occupancy Volume OF 14 00 10 0 4 0 6 14 2 a OP 14 350 10 0 4 1 0 0 0 0 aL 07 16 00 10 0 4 1 0 ae 5 nof Mn DOT Home Die a00 4 1 0 19 9 9 r Northstar Ue de oeron 4 1 0 A 2 07 17 30 10 0 4 1 0 ee A E 07 18 00 100 3 10 22 3 g 07 18 30 10 0 4 1 0 0 0 0 gnnEso 07 19 00 10 0 4 1 0 2e 1 07 19 30 10 0 4 1 0 15 5 at amp OF 20 00 10 0 3 1 0 ie l gt 07 20 30 10 0 3 1 0 a2 5 E OE or re PT et A E 1s erg Fy E te A a E T rn i Ae a A Figure V 3 Ramp Meter Timing Example Step 3 Select the drive from the pop down menu on the Save as screen 38 File Download Some files can harm your computer IF the file information
41. ss is now complete The detector numbers have been selected in Data Extract without having to manually enter each one Advantages The end user can easily check and verify that all impacted detectors have been identified These Excel files can be built in advance The files can be easily edited and updated if there are changes to the project limits or missing detectors or detector incorrectly entered 22 Disadvantages The end user needs to be familiar with Excel and data format structure PS Gotathtrset 1 2 8 PA IWY Trait Beta l Fie Help a t a E 2 S300 aera i ib H keaz 3 gaan C 94 aenea 7 HO SS Acicitiona E ATADNI NE HOV SOOKE ern HON SMELL pen ake pn C HEW ANE ats C HOV MER ats 7 WESSE C How st0S6prn E H rn H ATH 7 How 00s6ale C ROW eds a eee T HOW 250 addtional Detectors Fram Commons gre 7 ROW EB pen 10 THIS 1i FABATHIJSN EE 12 HAER H Poe A a i a e E Facile S84E8 Decors em _ a s Fikes of Type AN Pilas x Fie Frnt Composite Eeaoer J Veues 1 Sanni Suna irago Whiten Feat Drege Metam Tir famy ine Columns ert iis rouwe H s igeni baunert 4 baa 2 Osta Eetr A naterntr ee Pe rf Ry a 71 PM Figure IV 2 DataExtract Main Menu C Selecting the Mainline and Ramp detector numbers The data extract option selected will determine how the detector information is entered into the Data Extraction pr
42. t move the cursor to the white End box and enter 9 00 Click on the drop down box next to Smoothing and select 15minutes Click Add Move the cursor to the white Start box and enter 15 30 Military Time Next move the cursor to the white End box and enter 18 30 Military Time Click Add Verify the correct time period has been selected 24 This procedure is illustrated below 1636 UI2HenLkEZ AGI US snk WH 1618 UAE ARID LCE 140 LEA ilar ee Wet Lear ee 7 iii LAS eee Wiii LEADS CerlssEH 1608 USi2Caerleneo 1645 MAEHE 4646 Loe nar SIZE seen ee r b d Ta 18 20 15 minea amie j Time ranges in Clumnins Maart 1 Elaes hiResd Mpctourane 5 4 tients ya Data ETE cooatarxtrac ya bone TLA ae 24h PRI 2 Selecting the Date Locate the upper right section of the Data Extract window that contains the calendar Click on the day s that data is to be pulled from For example to extract data from October 2 and 10 2002 simply find the October 2002 calendar and click the days For modeling the date selected should represent a typical day which is not impacted by incidents or weather 25 aaj om s a a eaja amp HVABESIME ipni a 30 E aH D PATHI 10 EWATH1351 11 S5WERTH EIS 12 SUWERTH ISH AECE TE z la Eire e ininutes w cie aasa Aa Ejem mResd Qporoutwe BESA en
43. t provides a quick review of the current status of the detector system The report can be used to help identify detectors that are not functioning undercounting or off line The Ramp Meter Analysis allows the user to query for the ramp meter timing on a specific day and time period 34 B Ramp Meter Analysis Below outlines the procedure for acquiring the ramp metering timing in the affected project area using the IRIS Ramp Meter Analysis program 1 Identify affected ramp meters Refer to the Mn DOT Traffic Management map or list of ramp meters in Appendix G Identify and develop a list of meters within the modeling project limits 2 Determine ramp meter operations Cross reference the list of ramp meters with the current operating ramps by checking Appenidx H listing of stratified ramps meters Contact the Mn DOT s RTMC Operation unit at 651 634 5311 to verify the ramp meters operations during peak periods 3 Extract ramp meter rates TMC Home 170 Controller Algorithm Continuity Detector Volume Ramp Meter Queue Passage Queue Wait Timing ge nof Mn DOT Home 4 Northstar Intelligent a a Road way nformation System Traffic Management Center IRIS Report Ramp Meter Analysis Enter the Ramp Meter Start time End time and date then click the Submit Query butten to see the report Ramp Meter start time fhh rn ss ss End tune thhminss O P
44. wever the buttons are still Thursday 9 26 2002 4 Bl ple tinsel active no matter what color their T text 1S z Minimal Impact M 1 2 mie Impact Higher impact incidents are always included unknown included for older data EXCLUDED dates g3 2002 972672002 You must click the Count Incidents button again to exclude them from the results Click the SAVE DATA button to Click datef to be ESCLUDED eae the details of the selected Serer then click the Count button again incidents to an Excel spreadsheet Yord h to click t Add selected dates to Clear all dates from ou do not have to clic oun the excluded ist the excluded list Incidents before clicking SAVE DATA Dap of Week Dates Inout Thursday 95 002 2 The file is given the name of the Tuesday 9 10 2002 2 highway year and month like Wednesday 3711 2002 l his Tuesday a1 772002 3 Tuesday grz 2002 2 o US169_2002_9 xls or Wednesday 9 25 2002 1 394_2002_10 xls The file is saved in the subdirectory noted on the Data Tables tab see next page 14 169 TH 122400172 fi27 00 813 202 oi c downloads _ Roadint Road iLog Road GIS PP STH M5 o Py toto TH uso M22 TH us E sn 5 E ESE Oo OOOO Bw Bw Py 886TH MN Py 2 saw 2 PSH MNS eH set Py 62 62TH MND Py 65 STH MNES Pp rH MN E sjun a O 100100 TH MNOO PTH MNO O es te9 TH US169 E nn tus2i2 Py 202800TH MND
45. ys Sundays and Mondays Step 3 Eliminate holidays and the days proceeding or following a holiday Step 4 Eliminate bad weather days Step 5 Eliminate dates that the roadway is impacted by incidents A Weather Impacts The weather information can be accessed from the National Weather Service Forecast Office This site has weather information by month and year for the Twin Cities Metropolitan Area Select the month and year of interest Typically this is last year for September and October timeframe Below outlines the steps necessary to identify days that should be eliminated due to bad weather Step 1 Log onto the National Weather Service web site E ethical idle LiL arrier Poorer vat Mice Tria Coheed Thanhaasir HH Miranit Ener rest Dagon o E Fie Bio Wee Faes e Help e sabe ep al A rera o pe ad BF a Aim p he Verran cv ren gorge z Fae irs u BATA TAPE Patch he Der E mei aiki aei fi j 7 e Ea O Twin Cities MN ae Sade Uap bisa Oise E AS Seen Training Classes Scheduis Cisr Cuwa Hara ik E Conners Peo Dhene needecin several binna nia iene Cope eee e Exeorinesial Graphical Forecads Rater Take 3 itok ty cickieg on he J Ela Raia Hia Dab iabe link in We foneranis Seckon Of Ge bed fed onion ona ah Baer i HA Sub Slonm Papert ie Ha Salety Fades j n Cine Coig Heemi HA Cee DaHa higas Hai nes 1 Bader ina Tenn Caine Heda Mati bios Hrm Harlaar Gree
Download Pdf Manuals
Related Search