Home

Guide - Transportation Research Board

1. Close FIPLib This function provides easy access to electronic documents in the transit planning areas The function 15 still being developed and it includes only a few simple links in the current version When completed it will allow you to search and access a wide variety of transit planning literature FIPLinks This function provides an interface for direct links to the websites of various agencies The screen for this function 1s shown in Figure 4 4 You may add a new web link or edit an existing one using the Add and Edit buttons respectively To access a specific web site on the list double click the desired list item to activate your default web browser SECTION 4 MISCELLANEOUS COMPONENTS Figure 4 4 Agency Website List Select Organization Bay County Council on Aging Broward County Mass Transit Central Florida Regional Transit Agency City of Miami Beach THA City of Tallahassee LCOMSIS Mobility Services County of V olusia vU T HAN Escambia County Transit FOOT Public Transit Office Gainesville Regional Transit System Hillsborough Area Regional Transit Agency Indian River County COA Jacksonville Transportation Authority Lakeland Area Transit District Lee County Transit Lehman Center For Transportation Research FILI Manatee County Area Transit Martin County Council Aging Miami Dade Transit Agency National Transit Database NTO Pra
2. ee e e EE pO 568 8 42 21 00 E pO x O e D lt lt Back The following two functions can be applied to a cross table e Youmay select whether to Include the agency name for each NTD ID by applying the Agency Name function e You may swap the row and column variables quickly by applying the Swap Row and Column function 2 38 SECTION 2 INTDAS Plotting Tabulated Data INTDAS provides an interactive plotting capability in the Plot view The operations of this view are similar to that of the Cross Table view Instead of displaying the data in a cross table the Plot view displays data on a graph Figure 2 25 shows a screen of the Plot view See Creating a Cross Table for a detailed description of the operations Figure 2 25 INTDAS Plotting Screen INTDAS Graph view ET 1 x File Setup View Tools Reports Help slala cef 25 s r ptions Row variable Column variable Mode Code Service Type Value variable AG Mode Code DR PT Service Type HR Service Type VP Annual Total Unlinked Passenger Trips Select all Annual Total Unlinked Passenger Trips Vehicles Operated in Maximum Service Vehicles Available for Maximum Service Annual Total Passenger Miles Te 007 Te 007 6 007 5 007 4 007 4029 Broward County Commission Public Service Department 4034 Metro Dade Transit Age
3. e itat ED uS 24 pelectine Variables by NID a et del du tnt e e 24 selecting Variables by Variable LiIst 26 selecting Variables by Variable E DO unum aa upya 27 Saving System and Variable Selections 28 View ino Retitey NC DD Dal uu sunan a t aaa 28 Viewine Retrieved Data by NID FOTS uuu ua aaa PEE Tete exa Een 29 Viewing Retrieved Data by Tables and Graphs 30 ZAppiyineFunctonsto Platclableuuuu uy ka E 30 porno 32 Computime Table SEdUsHCS ocio u kanha ea 33 OA uum a mi hun 33 ING We LCS c H 34 ns Tornano caeco eere u uuu OR uuu Zn ma sa asss 35 Transteming Tabulated Data uuu 36 C G o C danda i m uhu 27 P lottime TrapulaterDa u nuan Sau 39 What Peer Selecdon Pro66 887i u inte 40 How is Flor
4. To select additional features hold down the shift key while clicking the left mouse button Cancel Back Figure 3 28 shows the screen for Step 3 It allows you to specify the width of the buffer in a select unit whether to dissolve buffer barriers and to change the buffer zone color Click Next to proceed to create buffer Figure 3 29 shows an example of a buffer that is performed for the whole Taltran bus route layer with buffer barriers resolved Once the buffer zones are created the screen shown Figure 3 30 will pop up 3 25 SECTION 3 FTGIS Figure 3 28 Screen for Step 3 of Buffer Zone Analysis 3i Setup bulfer step How da vou want to create buffers B a specified distance 0 25 C meters feet miles B Dissolve bamer between buffers Ma Bi Butter shape color Click to change Cancel lt Back Figure 3 29 Resulting Buffer 4 GIS Database Tallahassee Transit Taltran E 8 x File Edit View Tools Table Help 274 Aalena Dellal lel BLOCK2000 SHP BLOCKGROUP2000 SHP m CENSUS_TAZ2000 SHP u prius SHP OLD SHP STREET2000 SHP TRACT2000 SHP TRACTSO SHP Ratio scale 1 31206 381810 94 712242 1 Image MapTips 3 26 SECTION 3 FTGIS Figure 3 30 Screen for Selecting and Viewing Buffer Output Buffer Statistics E X Layer to be buffered block2000 shp Total
5. e Total Gallons Consumed Total gallons of fuel consumed by the vehicle fleet e Total Energy Consumed Kilowatt hours of propulsion power consumed by a transit system rail and automated guideway e Average Age of Fleet The number of active vehicles of each fleet of the same mode and service type multiplied by their years of manufacture divided by the total active vehicles e Number of Incidents Total number of unforeseen occurrences resulting in casualty injury fatality collision or property damage in excess of 1 000 For an incident to be reportable 1 must involve a transit vehicle or occur on transit property 2 9 SECTION 2 INTDAS e Number of Vehicle System Failures Total number of failures that occur during revenue service deadheading and layovers A failure is classified as the breakdown of either a major or minor element of the revenue vehicle s mechanical system Failures are tabulated regardless of whether they result in a vehicle completing or not completing its trip e Weekday Span of Service The number of hours that transit service is provided on a representative weekday in the operation of the transit agency This indicator Is determined by computing the number of hours between the values reported for average weekday time service begins and time service ends on Form 406 For transit agencies with more than one mode the system total span of service takes into account the hours of operation for all modes and r
6. oo uu 103 2034 2032 300 331 402 403 404 4051 4052 406 408 sm Transit Agency Service Form A06 LEY tes EY Mode Type of Service TI select 9 Peak Peak Other Total Total Total Total Maximum Service Vehicles IE leer 01 Vehicles operated in maximum service E All 02 Vehicles available for maximum service EE IM Periods of Service vine crine H H H Time service ends D 1 T CE Service Supplied Modes mPi rFririninin n Total actual vehicle miles Cancel Total actual vehicle hours TF D o Total actual vehicle revenue miles Total actual vehicle revenue hours Total scheduled vehicle revenue miles Charter service hours School bus hours Service Supplied Rail Modes Number of trains in operation Number of passenger cars in operation Total actual train miles Total actual train hours Total actual train revenue miles Total actual train revenue hours Total actual passenger car miles Total actual passenger car revenue miles Total scheduled passenger car revenue miles Total actual passenger car hours Total actual passenger car revenue hours Service Consumed 24 Unlinked passenger fT E11 OF OF FEP 24a AD 4 elated unlinked passenger trips onlul es Ng i 25 Passenger mile
7. 22 il concise mapya 23 Duet uuu uum z m m ntpote 24 Create 28 C roi C emade MaiS uu aun Saha me pn eee emer ere 29 AdO rere mene asan an AA eon TTD QE ae ee TENE ee 30 r IU hea 31 Select PAU UES S uuu ohana E kabuuan sa uentus manua ie fotu Sn unt eee ua 31 M Morkine with LAMS Database gee paqa Database tor DO Vet uuu tea SECTION 1 INTRODUCTION INTRODUCTION This guide provides detailed guidance on how to use the various component programs in the Florida Transit Information System FTIS effectively It assumes that the user 1s familiar with the general operation of Microsoft Windows For general help on using Windows such as managing the environment the file system and printing refer to the Microsoft Windows User s Guide What is FTIS FTIS 16 a user friendly software tool that contains two major program components e A database system for the retrieval and analysis of the 1984 2000 National Transit Database NTD for all U S transit systems that reported data to the Federal Transit Administration FTA e A stand alone GIS system customized
8. Florida Transit Information System User s Guide System Selection A m I Developed for Public Transit Office Florida Department of Transportation Developed by Lehman Center for Transportation Research Florida International University MI March 2002 ACKNOWLEDGEMENTS The development of FTIS Is supported by the Public Transit Office PTO of the Florida Department of Transportation FDOT Ike Ubaka AICP of the PTO serves as the project manager and was closely involved in the FTIS software specification and verification Albert Gan Assistant Professor of Civil Engineering at the Florida International University FIU integrated the multiple year NTD database and serves as the software designer Jun Zheng and Kaiyu Liu both computer specialists with FIU Lehman Center for Transportation Research LCTR performed most of the software coding The following graduate students at the LCTR helped with various development tasks Sijong Jo Emani Saraswathi Joan Shen Yifei Wu and Allan Yue The assistance of many individuals who reviewed the software and provided the data and feedback is gratefully acknowledged ll TABLE OF CONTENTS SECTION I INTRODUCTION uu a luu w au sQ cid Eoi ia eoa iae I AV eh mg Bd PC l Why l TIS uu c T 1 PUTS COMpOnemts and Dat u vacent pedum I Mimm n Sy Stem u u teneo tapa udo i SS ente IESU O 2 Tascam E
9. H of Vertices Y pogr 4a S02 Y 659974 Y 669980 450 Y 669969 41 Y B83352 53E Y B83335 03z Y 5989946 612 Point 229547 4284384 530015 3901 Point zz 223487 965019522 Edit Insert Delete Y 22 1 Point 278457 RANNAN e To edit the data associated with a selected feature click the Edit Fields button The screen shown in Figure 3 20 will pop up Double click a Value cell to edit the value Figure 3 20 Screen for Editing Feature Data 3i Edit properties x Field Value al TLID Integer LENGTH Double b354 18134 Integer 2510 THODE Integer 1883 FEDIRP String String FE TYPE String FEDIRS String CFCC String A4 FHADDL Integer 1 Double click on value cell to edit 3 19 SECTION 3 FTGIS FTGIS also allows you to add a feature by drawing a line by mouse or select features from another layer and add them to the current layer To do so e In the Editing mode select the Edit Add New Features dropdown menu item The screen shown Figure 3 21 will pop up Figure 3 21 Screen for Adding Features by Drawing or from Another Layer 3i Add New Feature d E x do want to create new feature and add to the curent layer Based on features selected from visible point or line layer C Draw aline by mouse Now click select features from the select
10. Daye not operated due to strikes not operated due ta declared emergencies 0m 002 103 2034 2032 300 30 331 402 403 404 405 1 4052 Transit Agency Service Form 406 Location Ma State FL Average ls 6 30 AM 10 30 AM 2 00 400 AM 4 15AM _ d E 4 Peak Total tate e Tatal Mode MB Type of Service DO DO ae M cE 16 Co G e a a a a E 699 330 E 774 EE 156 a 558 ia 844 LM 55821 0489 LEDs 453 KE 452 En 811 sro 212 601 8f em x6 2 29 SECTION 2 INTDAS Viewing Retrieved Data by Tables and Graphs If you are interested in only select variables of multiple years INTDAS provides three different ways for viewing the retrieved data Flat Table View It displays all the retrieved records and variables in a flat table It is the default table option and 1s the first screen after you click the View Tables button Cross Table View It displays attribute values that are cross classified by any two selected variables Plot View It is similar to the Cross Table view in that it also displays data for any two variables at a time The only difference 15 that this one displays data in a graph while the other in a table
11. Min Max Count and Mean The Total statistics sum all values from each buffered subareas that make up the total buffer The Count statistics give the number of 3 27 SECTION 3 FTGIS subareas in a buffer The Min and Max statistics give the minimum and maximum values respectively among the subareas The Mean statistics are for only non additive variables of which total values are not meaningful 4 Inthe case when there are multiple buffers you may select to display the statistics for a specific buffer from the Select buffer dropdown list The selected buffer on the map will blink to indicate the selected buffer 5 You may repeat the above steps for another layer 6 You may click the Save button to save the buffer zones and the associated statistics as a new layer which will automatically appears on the map legend as soon as they are saved You may also save the statistics to a text or an Excel file Create Charts The Create Charts function allows you to create pie or bar charts based on one or more attributes of the active layer To create a chart 1 Click the Create Charts tool button or select the Tools Create Charts dropdown menu item The screen shown in Figure 3 31 will pop up Figure 3 31 Screen for Creating Charts 000 shp Chart Bar Chart Please select Fields Chart size RACE Draw Outline Cancel 3 28 SECTION 3 FTGIS 2 Click th
12. St Lucie Council on Aging SunTran Tri County Commuter R ail Double click to select Report Problem This function provides a convenient form for you to record and report to the developer any FTIS problems you encountered while using FTIS The report form is activated either when you click the Report Problem button on the main screen or when the program encountered an error In the later case FTIS will automatically activate the form and insert the error information needed for the developer to pinpoint the source of the problem In either case you should complete to your best ability all the fields on the screen Figure 4 6 shows the screen for the report form You may click the Save as default button to save the general information you entered so that it will be automatically loaded when the form is reactivated again next time In the Problems Suggestions Comments box you may enter all the information you wish to send to the developer Please provide as much details as you can The developer may contact you for additional information if necessary After you have completed your form you can click the Print button to print out a hardcopy of the completed form for your record or fax it to the developer If your computer is connected to the Internet you 4 5 SECTION 4 MISCELLANEOUS COMPONENTS may click the Send button to email the report to the developer The problem report will be automatically attached
13. in terms of FTEs classified as maintenance employees who are directly or indirectly responsible for vehicle maintenance e Administrative Employee FTEs All personnel positions in terms of FTEs classified as administrative in nature It includes all general administration ticketing fare collection and system security employees as classified by FTA in Form 404 e Vehicles Available for Maximum Service Number of vehicles available for use by the transit agency to meet the annual maximum service requirement Vehicles available for maximum service include spares out of service vehicles and vehicles in or awaiting maintenance but exclude vehicles awaiting sale and emergency contingency vehicles e Vehicles Operated in Maximum Service Number of revenue vehicles operated to meet the annual maximum service requirement 1 e the revenue vehicle count during the peak hours of the peak days weeks of the peak season typically the rush period Vehicles operated in maximum service exclude atypical days or one time special events e Spare Ratio Vehicles operated In maximum service subtracted from vehicles available for maximum service divided by vehicles operated in maximum service This measure is an indicator of the number of spare vehicles available for service A spare ratio of approximately 20 percent is considered appropriate in the industry However this varies depending on the size and age of fleet as well as the condition of equipment
14. 4035 Orange Seminole Osceola Transportation Authority 4036 T altran City of Tallahassee 4037 Florida Transit Management Inc 4038 Escambia County Transit System 4040 Jacksonville Transportation Authority 4041 Hillsborough Area Regional Transit Authority 4046 Sarasota County Transportation Authority 4050 Smyrna Transit System 4063 Space Coast Area Transit 4074 Pasco Area Transportation Service 4075 Comprehensive Paratransit Services 4077 Tri County Commuter Hail Authority 4084 Okaloosa County Coordinated Transportation Inc 4085 Bay County Council on Aging Bay Coordinated Transportation 4097 St Lucie County Inc 4104 Indian River County Council on Aging 4106 COMSIS Corporation 4109 B amp L Services 41120 CA am Anima nf hd actin Inn Mode Code Value variable Service Type Annual Total Unlinked Passenger Trips for Maximum Annual Total Service in Maximum Service Passenger Miles 655984 12 16 5 15 25 4 53 2700332 4206605 1251 4 11747684 2282824 42066050 12516469 2700335 18 117476848 58 amp 12123240 _ 188 594 4756823 42922 5 14285100 50 270212681 1 2 119559791 2 9806121 559 42080442 18926 33 2411633 87 5 5 14 45732532 4 38556385 48 28 4 10366340 9020093 1368M2 1 0 1 41e 135167 1
15. CMD Chevrolet Motor Division General Motors Corp Coach and Equipment Company COL Collins Bus Corporation Collins Industries Inc Coons Manufacturing Inc CAC Crown Coach Corporation DIA Diamond Coach DTD Dodge Division Chrysler Corporation DUT Dutcher Corporation Ell Eagle Bus Manufacturing El Dorado Bus Inc EDM El Dorado N ational Bus volvement ehicle body final vehicle manufacturer as the orporation fing Source Comments Manuf Model Number 222 211 Mew Database Database Transfer Database Close 4 2 SECTION 4 MISCELLANEOUS COMPONENTS Submitting Database to FDOT After you have completed your database and are ready to submit it to the FDOT click the Transfer Database button in Figure 4 3 The screen shown in Figure 4 3 will pop up By default the first data entry lists the current database You may click the Browse button to select another database The second and the third fields allow you to specify the FTP site and the email address respectively to submit the database to The last entry lets you enter your NTD ID which is required Figure 4 3 Screen for File Submission x E File to transfer Es Program FilessF TIS 15D ataXPTMS data Times37 md Browse FTP fileto homesfiiedu Email file ikeubaka dotstateflus ID
16. City of San Angelo Texas San Angelo 11 18 174335 1845 27 4001 Chattanooga Regional Tran Chattanooga TH 9 63 195290 1058 28 BE 4009 Fayetteville Area System of Transit Fayetteville 21 34 459022 2060 02 4019 Transit Authority of Northern Kent Ft wright KY 15 51 405172 2014 68 BE 4021 City of Huntsville Alabama Depar Huntsville AL 11 49 25679 1073 3 6059 BVCAA Brazos Transit System Bryan Ts 14 37 185182 1733 13 BE City Transit Management Compan Lubbock Ts 15 04 432730 1723 31 5 Central Arkansas Transit Authority Marth Little Rock 16 39 392066 1364 68 5 604 Handitran Special Transit Division Arlington Ts 13 58 426968 3134 47 5 4002 Knasville T ransit K Tranz TH 16 29 259798 1659 79 5 4015 City of Jackson Transit 5ustem Jackson 5 14 02 315214 1724 83 5 4051 Chapel Hill Transit Chapel Hill NC 14 34 308713 2349 92 Clarksville Transit System Clarksville TH 15 42 138535 331 21 Selected local systems Selected peer systems FL 4085 Bay County Council on Aging Bay Coordinated Transportation 5040 Abilene Transit System FL 4104 Indian River County Council on Aging 5 4014 Mississippi Coast Transportation Authority FL 4127 Polk County Transit Services AL 4068 Northwest Alabama Council of Local Governments 4012 Winston Salem Transit 4uth Trans 4id of Forsyth CountyRidesha Ts 6020 City of Mesquite Parks amp Recreation Save
17. Figure 2 15 shows the tool buttons for accessing the different views It also shows the tool buttons for a number of functions that can be applied to the data retrieved The next three sections describe the different views in more detail Figure 2 15 Table Tool Buttons INTDAS Flat Table View File Setup Tools Reports Help e A lo x ri ER ogg 2 Eg Fee AS 208958 p m m B5 c o T o B CERE E 5228 e t i 5 S m 3 Applying Functions to Table Figure 2 16 shows a sample flat table for data for select variables for multiple data years for multiple transit systems The following functions may be applied to the flat table 2 30 SECTION 2 INTDAS Freeze It allows you to toggle between whether to freeze or unfreeze the system variables When the system variables are frozen they do not move when you scroll the table horizontally to the right This function 15 useful when the table contains many variables and you want to be able to always see the system variables when you move to the right of the flat table Figure 2 16 Sample Flat Table 8s INTDAS Flat Table View E 1 xl File Setup View Tools Reports Help ae ells 23 10 084 73 2513 41 37 553 06 504 86 377 04 30 1983 4036 Tatran City of Tallahassee Tallahassee FL DO 4037894 31 1983 4037 Florida Transit Manage
18. It allows customized map background color line color line width and line style Map Legend It includes an ArcView like map legend which allows the users to choose which layers to display and in what order the layers are to be displayed 3 3 SECTION 3 FTGIS Map Labeling It includes a set of functions to display labels based on a selected variable The user can change the text color font type font size location and style Map Queries It includes the usual Identity function to retrieve data for a specific spatial unit and a Find function to search for spatial units containing a search text Map Select It allows the users to select spatial units by point line circle rectangle and polygon Selected items can be saved to a new data layer Thematic Map It includes a set of functions for creating different thematic maps Map Charting It allows the users to create pie and bar charts on the map based on one or more data attributes Map Graphics It allows the users to add texts lines points circles rectangles and ellipses to the map Map Editing It allows the users to edit point and line shapes The editing functions include delete a line or a point move a line or a point and insert a point Data Editing It allows the users to modify the data for a selected feature Buffer Zone Analysis It allows the users to perform buffer zone analysis for either selected features of a layer or for a whole layer Im
19. Save as a group button 1s clicked Figure 2 13 Screen for Saving System or Variable Selections ats Create variable Group Create anew group Group name Modify an existing group Existing groupe Florida Effecti Cancel Help e The first bullet allows you to save all the transit systems listed in the Selected systems list box under a new group name e The second bullet allows you to overwrite an existing system group with the transit systems listed in the Selected systems list box e Once the selections are saved the name of the group of transit systems will appear on the System groups tab The operations for creating and modifying a variable group are similar Viewing Retrieved NTD Data INTDAS allows you to view retrieved data in forms tables or graphs The following sections describe each of these options in detail 2 28 SECTION 2 Viewing Retrieved Data by NTD Forms INTDAS If you are Interested in retrieving comprehensive data for a small group of transit systems you may want to display the data on the emulated NTD forms The screen in Figure 2 14 shows an emulated NTD form Form 406 that 1s loaded with data for a selected system The tab allows you to navigate from one form to another easily The following functions are available for each emulated NTD form e Use the left right up and down arrow buttons to go to the next previous first and last record respectively Alter
20. Transportation Orlando DO 189521 84 293 C C 1103156509 27 28 1999 4036 City of Tallahassee Tallahassee 1 08 DO 44670 17 39 70 29 1999 4036 Talran City of Tallahassee Tallahassee 2 39 8G 4 49 10094781 84 504864 t y 35 1999 4038 Escambia County Transit System Pensacola FL MB po 1 602 980 7232 73 1999 ANANI lack Trancnortation lack sansilla AG nn R70 716 122 Value is for the whole transit system 126 records lt lt Back e Sort It sorts the flat table based on one or more variables e Get Statistic It computes the general statistics associated with each of the data attributes in the flat table Compute Total It computes the total values based on one or more system variables For example to find the combined values of both directly operated DO and purchased transportation PT for a transit system e Create New Variable It lets you create a new variable based on a formula 2 31 SECTION 2 INTDAS Adjust for Inflation It converts financial values to the equivalent dollars of a specific year 1 constant dollars based on the standard inflation rates derived from the Consumer Price Indexes CPIs Save It lets you save a flat or a cross table into either a comma delimited text file or an Excel file Send It lets you e mail a flat or a cross
21. a feature using your mouse cursor You select this option by clicking the second radio button Figure 3 26 Screen for Step 1 of Buffer Zone Analysis iy Setup buffer step 1 gt Around which Feature layer do you want to buffer f Visible layers route2000 shp C Draw a shape by mouse Cancel I 3 24 SECTION 3 FTGIS Figure 3 27 shows the screen for Step 2 It allows you to select a method to select features to create buffer from the selected layer e You may choose to select only some or all features Choose the first radio button if you want to select only some features Several methods are available to select features e You may use your mouse to either point to a feature draw a line that overlaps the desired features draw a circle that encloses all features within a certain radius or draw a rectangle that encloses the desired features e As soon as you have chosen one of the feature selection methods some instructions will appear on the screen to guide you through the selection e To perform multiple selections hold down your Shift key while making additional selections Once you have completed your selections click Next to proceed to Step 3 Figure 3 27 Screen for Step 2 of Buffer Zone Analysis 3i Setup buffer step 2 77 X point shape drawn with the cursor features the whole layer How Point the mouse cursor ower a feature and then click the left mouse buttan
22. as a group Close 2 43 SECTION 2 INTDAS This page left blank Intentionally 2 44 SECTION 3 FTGIS FTGIS FTGIS Florida Transit Geographic Information Systems is a stand alone GIS component developed using the MapObjects 2 0 library of the ESRI It is designed to completely replace the previous version of FTGIS developed by the Center for Urban Transportation Research CUTR As with the previous version this version 1s customized for easy access to several GIS shape files that come with FTGIS for Florida s transit systems FTGIS includes functions ranging from the very basic zoom in and zoom out operations to the highly customized buffer zone analysis Why FTGIS The transit industry has been a major user of GIS because transit facilities and planning information are highly spatial oriented Good examples of GIS applications by the transit industry include service planning service evaluation bus stop inventory etc 5 serves as a common repository for spatial data important for transit planning The stand alone nature of FTGIS provides the users access to a customized GIS system without an expensive commercial GIS system installed in their computer Because FTGIS Is developed at the source code level with the aid of a GIS library it has the flexibility of being tailored for specific application needs Getting Started FTGIS 1s accessible from the FTIS Main Menu screen Clicking the FTGIS button on the FTIS Mai
23. by system variables Select systems by query States Select all Clear all Individual modes EET CA Califomia Click item to select CO Colorado 4 Click selected item 40 Automated Guideway LT Connecticut In unselect Cable Car DE Delaware LH Commuter District of Columbia DH Demand Response FB Ferribnat Systems 34 Select all Clear all e m COMSIS Corporation JT Jitnev Council an Aging of Martin County Inc LR Light Rail Streetcar East Volusia Transportation Authority Escambia County Transit System Monorail Florida Transit Management Inc Gainesville Regional Transit System Mode aggregate for only Hillsborough 4rea Regional Transit Systemwide Total FL 4104 Indian River County Council on FT Total all exce FL 4040 Jacksonville Transportation Authority HT Rail 4031 Lakeland Area Mass Transit District MT Total DR FB k FI A28 Caunu Transit gt k Selected systems 4 Delete Clear all Save as a group FL 4029 Broward County Commission Public Service Department FL 4030 Gainesville Regional Transit System FL 4041 Hillsborough Regional Transit Authority FL 4040 Jacksonville Transportation Authority 2 18 SECTION 2 INTDAS To select transit systems 1 Select the Select systems by system variables tab on the INTDAS main screen It is the defaul
24. expense per peak vehicle Operating expense per passenger trip Operating expense per passenger mile Operating expense per revenue mile Operating expense per revenue hour Maintenance expense per revenue mile Maintenance expense per operating expense OPERATING RATIOS e Farebox recovery e Local revenue per operating expense e Operating revenue per operating expense VEHICLE UTILIZATION Vehicle miles per peak vehicle Vehicle hours per peak vehicle Revenue miles per vehicle mile Revenue miles per total vehicle Revenue hours per total vehicle LABOR PRODUCTIVITY e Revenue hours per employee e Passenger trips per employee ENERGY UTILIZATION e Vehicle miles per gallon e Vehicle miles per kilowatt hour FARE e Average fare SECTION 2 INTDAS The following section provides the definition of each of the variables listed Table 2 3 Most of these definitions are taken directly from the annual transit performance analysis reports produced by the Center for Urban Transportation Research CUTR of the University of South Florida General Performance Indicators e Service Area Population The population in the service area as defined in the Americans with Disabilities Act ADA the U S Department of Transportation Federal Register Vol 56 No 173 Rules and Regulations FTA began requiring transit systems to provide service area population as part of Form 001 m 1992 e Service Area Size The size of the area as defined in
25. for transit planning for Florida transit systems Why FTIS Transit agencies rely on various sources of data to help plan manage and improve transit facilities and services Examples of these data include the NTD data from the FTA socioeconomic data from the Census Bureau and planning agencies transit route and stops data from transit agencies land use data from county tax appraisal offices etc Although these data are available for use by transit agencies they are not easily accessible to the general users FTIS greatly improves the accessibility of these data by integrating the different data components into a common data depository and developing user friendly customized functions for easy data retrieval and analysis FTIS Components and Data FTIS consists of the following system components and data 1 1 SECTION 1 INTRODUCTION e Integrated National Transit Database Analysis System INTDAS This component contains the 1984 2000 NTD data for all U S transit systems reported data to the FTA for the National Transit Database e Florida Transit Planning Geographic Information System FTGIS This component contains the GIS shape files including streets routes stops TAZ and census tract for all Florida transit systems e Transit Asset Management System TAMS This component allows users to enter and submit transit asset data to FDOT e Florida Transit Planning Library FTPLib This planned component provides quick acc
26. hours to traverse all of the system s total route miles Finally this time figure divided by the system s number of peak vehicles then multiplied by ta convert tine in hours to minutes to determine the number of minutes it takes For a vehicle to complete its portion of the total route miles one time When New or the Modify button 15 clicked the Formula Editor screen shown Figure 2 2 will pop up To start creating a new variable 1 Enter the name of the formula to be created 2 Specify the data type for the resulting values from the formula 3 Specify whether the values are to be calculated for directly operated DO only purchased transportation PT only or both plus the aggregate values of both 1 The default 15 to compute values for DO PT and DP If a variable applies to only purchased transportation then you should select PT Failing to do so will result in values being calculated for DO and DP which is incorrect 2 14 SECTION 2 INTDAS Figure 2 2 Screen for Formula Editor 3 Formula editor E gt Varable name bverage Headway iri minutes in a keyword to find D1 Fr Month 001 001 ear 001 Primary UZA 001 Other 1 Other Other UZA 3 Farmula BU 2 403 Man rail T otal Dir Route Miles 30 3 H ail T otal Dir Rou
27. is given for each of the three primary measures How is Florida Peer System Process Implemented in INTDAS Figure 2 27 shows the main interface for the Florida peer selection process Figure 2 27 Main Interface for the Florida Peer Selection Process iy Peers selection input specifications E E E B x Peer systems Local systems Select mode code State Year Modes SL South Carolina DA Demand Response FL Florida foo ME Mototbus SD South Dakota MB Matorbus Service hype Directly operated DD Purchased transportation Combined Original NTE Florida standard User defined Varable groups fi lt 1806 Vehicles Operated in Maximum Service lt 10 Groups Delete Get systems 4085 Bay County Council on Aging Bay Coordinated Transportation 4104 Indian Hiver County Council on Aging 4127 Polk County Transit Services Local systems 3 Selected variables 8 Delete Clear all Save as a group FLA Average Speed HM RH Standard Deviation based Percentage based FLA Passenger Trips Scaring criterion FLA He venue Hours m Pm Sec FLA Revenue Miles Selection methodology within 1 0 Standard Deviation gt Score 1 5 10 FLA Service area population density Within 20 Standard Deviation Score 1 0 05 FLA Total Operating Expense checked primary unchecked secondar The step
28. layer 3 6 SECTION 3 FTGIS Figure 3 3 FTGIS Map Legend and Map Viewing Areas 3 GIS Database Tallahassee Transit Taltran x File Edit View Tools Table Help alte BLOCK2000 SHP BLOCKGROUP2000 SHP CENSUS_TAZ2000 SHP ROUTE2000 SHP J STOPS_OLD SHP STREET2000 SHP TRACT2000 SHP TRACTSO SHP Ratio scale 1 314233 943 09 Y 731096 69 Image MapTips Out of all the available layers there is always a current layer referred to as the active layer The active layer is one that is highlighted with a raised bar in the legend Many FTGIS functions are automatically assumed to apply to the active layer The Map view on the right occupies the first of the two tabs which are accessible from the bottom of the view The second tab is for the Table view Figure 3 4 shows an example of a table view You may switch from one tab to another by clicking the tab The Table tab will always display the data table for the active layer You can switch from one table to another by clicking a new layer 1 reset the active layer in the legend The Table dropdown menu allows you to select whether to display all records or selected records only You can save the displayed records as either an Excel file or a comma delimited text file by selecting the File Save into a File dropdown menu item 3 7 SECTION 3 FTGIS Figure 3 4 FTGIS Table Viewin
29. layers 3 matches found County Road 2201 County Road 2301 FEM AME County Road 2301 FEM AME County Road 2301 FEM AME County Road 2301 4 Select the operation ta perform Highlight Pin Pan To oom 2 Enter a search string 3 Check the layers you would like to search or check the Select all layers box to select all layers 3 23 SECTION 3 FTGIS 4 Click the Find button to start finding features matching the search string 5 After the search is completed and features are found click a feature on the Pick a feature list 6 Click the Highlight button to blink the feature The feature may or may not be positioned the visible map extent 7 Click Insert Pin button to insert a pin at the feature 8 Click the Pan To button to position the selected feature at the center of the screen 9 Click the Zoom To button to zoom into the selected feature Buffer Zone Analysis FTGIS allows you to create buffer zones around point or line features You may also select one or more features or all features 1 e the whole layer to buffer A buffer zone analysis is performed in several steps A wizard is used to guide you through these steps Figure 3 26 shows the screen for the first step It allows you to choose the layer of which the features are to be used to create buffers Only visible layers are listed Instead of creating a buffer around an existing feature you can also choose to draw
30. number of butters 1 variables Average variable Weighting variable 0 total population e g income Family total Famil PERIMETER aREA TQTAL WHITE 2 BLACK v INDI_LALASE gt O PACIFIC e Select all Clear al select butter HULITE 132 Featureld 668 Count Mean hab n a hab nra hab n a heb n a In the Buffer Statistics screen you l select one of the layers to be buffered AII data attributes for the layer will appear in the Total variables list box as well as the Average variable and the Weighting variable dropdown list Select the variables for which you want to retrieve data from the buffer s In the Total variable list box you should select only the variables that are additive 1 e summation is meaningful by checking the checkbox in front of each variable Click Select all to select all variables or click Clear all to clear all selections For non additive variables such as population density you should select from the dropdown list and specify the corresponding weighting variable The default weighting variable is AREA which is suitable for variables weighted by area such as population density Click the Get Buffer Statistics button to compute buffer statistics The output 1s shown on the bottom half of the screen The output statistics include Total
31. of the screen to start the peer selection process When it is completed the scores for all potential peers are listed as shown in Figure 2 28 A high score means that the transit system is similar to the local group of transit systems Select the top transit systems on the list as peers by clicking the corresponding checkboxes As shown in Figure 2 28 the selected local and peer systems are listed on the two list boxes on the lower half of the screen respectively The selected systems can then be saved as a peer group and retrieved as a group A wizard option of the same peer selection process is also available It is accessible from the Setup Peer Groups Wizard dropdown menu item This option takes the user through the selection process step by step with instructions provided for each step The multiple screens associated with this option perform the very same steps described above 2 42 SECTION 2 INTDAS Figure 2 28 List of Ranked Potential Peers for Selection it Peers selection E m EF D gt Potential peer susterns 9 B040 Abilene Transit System Abilene Ts 14 81 358871 338 48 g 4014 Mississippi Coast Transportation Gulfpart 5 16 05 543574 2295 2 9 4068 Northwest Alabama Council of La Muscle Shoals AL 10 83 313715 642 8b Bh 4012 Winston Salem Transit Auth Tra Winston Salem 12 48 3r1044 1514 23 a5 600 City of Mesquite Parks Mesquite Ts 13 33 242060 2830 9 BE BUS
32. per vehicle mile in that the vehicle speed 1s factored out This is often important since vehicle speed is strongly influenced by local traffic conditions SECTION 2 INTDAS e Maintenance Expense Per Revenue Mile Maintenance cost divided by the revenue miles e Maintenance Expense Per Operating Expense Calculated by dividing maintenance expense by operating expense expressed as a percent of total operating expense e Farebox Recovery Ratio of passenger fare revenues to total operating expenses an indicator of the share of total operating costs that is covered by the passengers fares e Local Revenue Per Operating Expense Ratio of total local commitment with respect to total operating expense e Operating Revenue Per Operating Expense Ratio of revenue generated through operation of the transit agency directly generated non fare revenue plus passenger fare revenue with respect to total operating expense Operating revenue includes passenger fares special transit fares school bus service revenues freight tariffs charter service revenues auxiliary transportation revenues subsidy from other sectors of operations and non transportation revenues e Vehicle Miles Per Peak Vehicle Vehicle miles divided by the number of vehicles operated in maximum service It is an indicator of how intensively the equipment is used and is influenced by the bus travel speeds as well as by the levels of service in the off peak time periods A more un
33. pointers SECTION 2 INTDAS INTDAS INTDAS Integrated National Transit Database Analysis System is a major FTIS system component designed to facilitate the retrieval and analysis of multi year multi system data from the National Transit Database NTD What is NTD Each year more than 500 of the nation s transit agencies report data to the FTA for inclusion in the NT D a uniform data set required by the Urban Mass Transportation UMT Act as a prerequisite for the nation s transit systems to receive the FTA grant funds Known formerly as the Section 15 database NTD includes data on transit organization characteristics vehicle fleet size and characteristics revenues and subsidies operating and maintenance costs safety and security vehicle fleet reliability and inventory and services consumed and supplied These data have been used extensively to derive values for transit performance measures and have become the sole source of standardized and comprehensive data for use by all constituencies of the transit industry Why INTDAS As a major source of performance data for the transit industry an important application of NTD has been for use trend analyses that require multiple years of NTD data However accessing multiple years of NTD data is currently a very tedious process One major reason 1s because NTD data are collected and distributed annually on separate files To perform a trend analysis for example one must learn abou
34. table as a file attachment See Figure 2 15 for the tool buttons for accessing these functions A corresponding menu item can be found in the drop down menu for each of the tool buttons The following sections provide additional details for some of these functions Sorting Tabulated Data INTDAS allows a flat table to be sorted by one or more variables To sort the table based on one variable you can simply click the column header of the variable you want to sort Clicking the header once will sort the table in the ascending order Clicking the same variable again will re sort the table in the descending order To sort the table based on more than one variable select Tools Sort or click on the Sort tool button The screen shown in Figure 2 17 will pop up variables available for sorting will be listed on the list box on the left You can select up to five variables to be sorted in either the ascending or the descending order Click OK to sort the table in the order of the variables listed Figure 2 17 Screen for Specifying Sorting Variable and Sorting Order Sort variables 1 Ver Ascending Descending 2 Ascending Descending 3 P Ascending Descending 4 C Ascending Descending Ei C Ascending Descending Records will be sorted in the order of variables above Cancel Help 2 32 SECTION 2 INTDAS Computing Table Statistics INTDAS computes basic statistics for all
35. tells INTDAS not to stratify the resulting table by any system variables In this case INTDAS sums up values for each column 2 33 SECTION 2 INTDAS e Checking Year NTD ID and Mode Code will ask INTDAS to add values for DO and PT for each transit mode of a transit agency for each NTD year e Checking only Mode Code will compute totals for each mode code e Checking all boxes will result in no change to the current flat table You may click the Reset Table tool button or select the Tools Reset Table menu item from the dropdown menu to go back to the original flat table Creating New Variables This function allows you to create a new variable through a formula just like in a spreadsheet program The steps for applying this function are as follows 1 Select Tools Create New Variable from the dropdown menu The screen in Figure 2 20 will pop up This option is selectable only when you are in the Flat Table view Figure 2 20 Input Screen for Computing New Variables New Variable Creator X New variable name Total Actual Miles keyword to find Reset Annual Total Actual Vehicle Miles Annual Total amp ctual Train Miles Farmula Annual Total Actual Vehicle Miles Annual Total Actual Train Miles Help 2 34 SECTION2 C C C C 1 INDAS 2 Enter a name for the variable 3 Optional Type in a keyword to shortlist the variable list 4 Compose a formula by selecting
36. the install will ask if you want to remove or modify the existing version before installing another version of FTIS It is advisable that you choose to remove the previous version Technical Support and Problem Report If you need technical support or additional information please contact the developer through one of the following four channels e Email your request to gan eng fiu edu e Call 305 348 3116 for Albert Gan e Fax your request to 305 348 2802 attention Albert Gan e Sendto Albert Gan Lehman Center for Transportation Research Florida International University UP Campus EAS 3685 Miami Florida 33199 Note Please report to the FTIS developer any problems you encountered while using FTIS You may do so using the Report Problem button on the FTIS main screen Your comments and suggestions are also welcome User Interface Conventions The following general conventions are used in FTIS e Ifa button or a menu item is grayed out it may be due to one of the following two reasons 1 the needed input to execute the function has not been completely specified and 2 the function is not applicable e g the up arrow button in the NTD s View Forms screen is not selectable when first record 15 displayed e A single click on an item on the list box selects the item Clicking a selected item will deselect the item e In the GIS system component a right click will return to the arrow mouse pointer from any other mouse
37. them to the current layer This version only allows point and line layers to be edited To start editing e Click the Start Editing tool button or select the Edit Start Editing menu item This will take you into the editing mode and bring up the Edit tool panel in Figure 3 17 Figure 3 17 Edit Tools Panel 3 Edit Move de Undo Help Move Move Line fe Add Mode Add Line XD Delete Node Delete Line Edit Nodes Edit Fields e Select a feature to edit by clicking on it The selected feature and its associated nodes will be highlighted in red as shown in Figure 3 18 applicable buttons in Edit tool panel will become active 3 17 SECTION 3 FTGIS Figure 3 18 Selected Feature 16 Database County Council on Aging x File Edit View Tools Table Help m altal zal BLOCK2000 SHP z BLOCKGROUP2000 SHP L CENSUS_TAZ2000 SHP L1 ROUTE2000 SHP STOPS OLD SHP m STREET2000 SHP gt TRACT2000 5HP TRACTSO SHP Undo e Gra m Move Node Move Line or SA zn Add Node Add Line iSS Edit Nodes Edit Fields Ratio scale 1 60788 245993 23 Y 683243 23 Image m MapTips M e Click one of the tool buttons on the Edit tool panel to select an editing function The button for the selected function will be depressed Figure 3 17 shows that the selected e
38. variable list box or e Highlight the variable name in the Selected variables list box and then click the Delete button Selecting Variables by Variable Group This option allows you to quickly select a group of pre defined variables It is done by selecting an item on the Groups list box as shown on the screen in Figure 2 12 To delete an existing variable group highlight the variable group name and then click the Delete button on top of the list See the section on Saving System and Variable Selections to learn how to create and modify a variable group Figure 2 12 Screen for Selecting Variables by Variable Group Select variables OnginalNTO Florida FSV User defined Groups Groups Delete Clear all Florida Efficiency Measures Florida General Performance Indicators Selected variables 14 Delete Save az a group FLA Vehicle Miles Per Capital FLA Passenger Trips Per Capital FLA Passenger Trips Per Revenue Mile FLA Passenger Trips Per Revenue Hour FLA Average Speed AM AH FLA Average Headway in minutes FLA Average of Fleet in years 2 27 SECTION 2 INTDAS Saving System and Variable Selections INTDAS allows selected transit systems or variables to be saved as a group The ability to save a group of transit systems and a group of variables allows data for trend and peer comparison analyses to be retrieved quickly The screen shown in Figure 2 13 will pop up when the
39. variables through a user defined formula See the section on Defining or Modifying a Formula to learn about how to create a new user defined variable or edit an existing one Creating Modifying or Deleting a Variable INTDAS allows you to create a variable by setting up a formula that consists of one or more original NTD variables Existing formulas can be modified or deleted To do these e Select Setup Derived variables from the INTDAS dropdown menu The Formula Setup screen shown in Figure 2 1 will pop up Two tabs are provided one for the Florida standard variables FSV and another for any other user defined variables e Select the appropriate tab The tab you select here will determine the tab that the variable will be listed in the Select Variables tab in the main INTDAS screen e In either the Florida standard or the User defined tab you can select any variable on the Variables list by clicking the variable name The corresponding formula and the variable definition will be displayed as shown In Figure 2 1 To create a new variable simply click the New button e To modify an existing variable click the variable in the Variables list box The variable is highlighted The existing formula is shown in the Formula box The definition description for the variable is shown in the Definition box Click the Modify button e To delete an existing variable click the variable in the Variables list box The variable 15 highlight
40. 299 74199 82841216 81 151 82897 82841218 75 64 47795 82841219 54 264 23314 State Highway 2 82841222 36 162 23412 82841227 105 315 14863 Lanier 82841228 113 84 85833 Blount 82841231 37 249 63529 Lone Star 82841232 111 125 11753 Lake Talquin 82841241 584 148 15811 82041242 RAR 197 1 Williams andina 4 Ratio scale 1 314233 3353956 55 693943 18 Image MapTips Map Properties The Map Properties screen as shown in Figure 3 5 allows you to set the properties of the Map view To access the Map Properties screen select View Map Properties from the dropdown menu The screen allows you to select whether to have a map border the map view e whether you want the Escape key to take no action stop drawing all layers or stop drawing the active layer whether you want to have scrollbars on your map view whether you want to have depressed map view to create a 3D appearance and e the color of your map background the default is plain white 3 8 SECTION 3 FTGIS Figure 3 5 Map Properties Screen Map Properties Map border style Fixed single M Cancel action wher Escape key is pressed Stop drawing all layers What map units are your layers using Meters X Click to select map Scrollbars on map background canvas color 3D appearance Close Layer Properties The Layer Properties screen allows you to set the appe
41. 40 111999 4029 Broward County Commission Public PompanoBeach FL MB DO 2535931342 0 22 112270023 12 1999 4029 Broward County Commission Public PompanoBeach FL MB PT 510494 a 2 466 635 13 1999 4030 Gainesville Regional Transit System Gaiesvile FL 08 DO 3 4 14 1999 4030 Regional Transit System Gainesville FL MB DO 4404653 5 ef 7 10042509 15 1999 4031 Lakeland Area Mass Transit District Lakeland FL DR 100 57 01 14 C 814003 16 1999 4031 Lakeland Area Mass Transit District Lakeland FL DO 1393016 2 3 472358 17 1999 4031 Lakeland Area Mass Transit Lakeland FL PT 56 373556 18 1999 4032 East Volusia Transportation Authority South Daytona FL DR DO 15 4 3 5 1536 548 19 1999 4032 East Volusia Transportation Authority South Daytona FL DR PT 1927 3 4 2123679 20 1999 4032 East Volusia Transportation Authority South Daytona 1 DO 5 14608132 21 22 1999 4034 Metro Dade Transit Agency FLAG 0 405212 9 4166830 23 1999 4034 MetroDade TransitAgency FL DO 136045270 00 107 591 590 24 1999 4034 MetroDade TransitAgency Mim FL DO 6382728 284 5 82 25 1999 4035 Drange Seminole Dsceola Transportation Orlando FL pR 5597 1 74 18 C C 7 580437 26 1999 4035 Orange Seminole Osceola
42. 408 Data year NTD ID mode code service type 901 Data year NTD ID mode code service type Only Uses of Capital Funds is reported by mode code Only directly operated passenger fare revenue is reported by mode code The reporting of this information 15 optional Florida Standard Performance Variables Table 2 3 includes a complete list of the Florida standard performance variables The variables are divided into three groups general performance indicators effectiveness measures and efficiency measures The FDOT has been using these variables in its annual performance analysis for the Florida transit systems since 1988 These variables are defined based on one or more original NTD variables For example the average headway is computed based on the following NTD variables directional route miles revenue miles revenue hours and the number of vehicles operated in maximum service See the section on Defining or Modifying a Formula to learn how to create a new performance variable or edit an existing one Note Since the Florida standard variables FSV are computed from the original variables the available data years for these variables are limited by the available data years shown in Table 2 1 If a formula involves two variables one is from Form 406 and another from Form 405 Page 2 then the resulting available data years for the formula will be 1995 2000 Refer to Table 2 1 for available data years In some cases particula
43. 5P2 are used 2 21 SECTION 2 INTDAS Steps for constructing the example query 16 17 18 Click the button Click the System State variable fourth variable on the list on the Variables list box Click the button Click the FL list item on the Value list box which lists all the available states Click the or button Click the System State variable again Click the button Click the CA list item on the Value list box Click the button Click the and button Click the System Mode Mode Code variable Click the button Click the MB list item on the Value list box Click the and button In the Type in a keyword to find text box type In an appropriate keyword or a partial keyword to find the variable for maximum vehicles e g type The Variable list box should list all the variables that contain the keyword Click the 406 Vehicles Operated in Maximum Service variable Click the gt button Type 500 without the quotation marks Selecting Transit Systems by System Groups This option allows you to quickly select a pre defined group of transit systems The interface for this option is shown in Figure 2 7 To apply this option I 2 Select the Select systems by groups tab Select an item on the Groups list box Select the desired mode codes from the Individual modes list box and the desired mode ageregates from the Mode aggregate list box Tr
44. COMPONENTS This page left blank Intentionally 4 8
45. age Background It allows display of aerial photographs as the background Table It allows the user to view the tabulated data for all records or selected records only Selected data can be exported to an Excel or a text file Miscellaneous other features Other features include map tips map printing add or delete a layer etc GIS Data Included FTGIS currently includes the ArcView shapefiles for the following layers SS NAN SOS Street Transit route Bus stop Census tract Census blockgroup Census block Census Traffic Analysis Zone SECTION 3 FTGIS Table 3 1 gives the attributes that are currently Included in all the census layers Table 3 1 Available Attributes in Census Layers Total American Indian and Alaska Native population Total population of some other race Population of two or more races 3 5 C FTG Notes e Unless specified otherwise the data are updated to the year 2000 or later e The street layers were developed based on the 2000 TIGER Line files e The route layers were either obtained directly from the transit agencies or were updated from the old route layers using hardcopy route maps provided by transit agencies e Only a few up to date bus stop layers have been obtained from transit agencies Stops layers that have not been updated are labeled old as part of the shapefile name e The census tract blockgroup block and TAZ data were developed based on the 2000 TIGER L
46. ansit systems belonging in the selected group and serving at least one of the selected modes will be listed in the Selected systems box To delete an existing system group highlight the system group name and then click the Delete button on top of the list Note See the section on Saving System and Variable Selections to learn how to create or modify a system group 2 22 SECTION 2 INTDAS Figure 2 7 Screen Area for Selecting Transit Systems by System Groups Select systems by system variables Select systems by query Select systems by groups Select states System groups Delete Individual modes E ATE individual modes Peer Group 2000 10 to 49 buses AG Automated Guideway Peer Group 2000 50 te 200 buses Cable Car LR Commuter DH Demand Response FB Fermboat HH Heavy Hal Rapid R IP Inclined Plane JT Light Rail Streetcar Motorbus Monorail Mode aggregate for FSW anly ST Systemwide Total FT Total all exci HT MT Hon ral Total DRE4FB 1 Selected systems 3 4085 Bau County Council on amp ging B Coordinated Transportation 4104 Indian River County Council on Aging 412 Polk County Transit Services 4072 City of Key West S069 City of Danville Mass Transit System B03 City of San Angelo Texas Display definition Selecting States for Statewide Data This option allows you to select states for which st
47. arance of a specific layer for display Depending on the shapefile type point line or polygon the property items are slightly different Figures 3 6 3 7 and 3 8 show the property setting screens for point line and polygon layers respectively Settings for point layers include point color style and size Settings for line layers include line color style and width Settings for polygon layers include polygon outline or border color outline width fill color and fill style The operations for the three screens are similar For example to invoke this screen for a point layer and make changes to the settings Double click the target layer in the legend or select the View Layer Properties dropdown menu item The listed layer is the active layer and cannot be changed while you are on the screen e Click the Marker Color box to invoke the screen in Figure 3 9 to change to a different feature color Color a color grid and then click OK to select a color e Click the Style dropdown list to define a shape for feature display e Click the spinner button to set the line width e Click Apply to preview the results of your selections e Click OK to retain changes and exit the screen or click Cancel to exit without changes 3 9 SECTION 3 FTGIS Figure 3 6 Screen for Setting Point Layer Properties its Layer properties for STOPS2000 5HP layer X Layer name stops2000 shp Marker Color E Style Square mar
48. at is used to identify a transit agency For statewide data this variable is replaced by the standard two digit state codes e g FL for Florida e A mode code to identify the transit systems motorbus high speed rail etc operated by the transit agency 2 3 SECTION 2 INTDAS service type to identify whether the transit service 15 operated directly by the transit agency or 1s purchased from another company e Because INTDAS includes NTD data from multiple years the data must also be indexed by the NTD data year which is considered another system variable Table 2 1 NTD Forms and Available Data Years NTD Form NTD Form Name Available Data 3 001 Transit Agency Identification 1984 2000 002 Contractual Relationship Identification 1993 2000 005 Supplemental Information 103 Capital Funding 1984 2000 203 Operating Funding 1984 2000 300 Operating Expenses Summary 1984 2000 301 Operating Expenses 1984 2000 321 Operators Wages 1984 2000 331 Fringe Benefits 1984 2000 402 Revenue Vehicle Maintenance and Energy 1984 2000 403 Transit Way Mileage 1985 2000 404 Transit Agency Employee 1992 2000 405 Page 1 Transit Safety and Security Form Safety Items 1995 2000 405 Page 2 Transit Safety and Security Form Security Items 1995 2000 406 Transit Agency Service 1984 2000 408 Revenue Vehicle Inventory 1984 2000 901 Federal Funding Allocation Statistics 1984 2000 Data not available from FTA NTD reporting
49. atewide data are to be retrieved The interface for this option 15 shown in Figure 2 8 To apply this option 1 Select the Select states tab 2 Select one or more states from the States list box The selected states will be displayed in the Selected states list box 3 Select the desired mode codes from the Individual modes list box and the desired mode aggregates from the Mode aggregate list box Note Statewide data are available for only the Florida standard and user defined variables 2 23 SECTION 2 INTDAS Figure 2 8 Screen Area for Selecting States for Statewide Data Select systems by system variables Select systems by groups Select systems by query Select states This option iz available for only Florida standard and user defined variables States Select all Clear all CT Connecticut DE Delaware District of Columbia FL Florida G4 Georgia Display definition Selecting Data Variables Individual modes All individual modes G Automated Guideway Cable Car Commuter Fail Demand Response Heavy Inclined Plane Light Streetcar Motorbus Monorail Other Publico Trolleybus Aerial Tramway Vanpool Mode aggregate for FS only 5 Systemwide FT Fixed route Total all except HT Hal Total amp G CC CR HB4 MT Hon al Total OA FB T h Ii For the selection of NTD variables INTDAS allows you to select variables b
50. attribute variables a flat table The statistics include maximum minimum total number of records and average An example output is shown in Figure 2 18 The next version of INTDAS will include additional statistical capabilities including regression modeling Figure 2 18 Sample Statistical Output Annual Total Unlinked Passenger Trips 1431 65821045 125 64550098 Vehicles Operated in Maximum Service 53 E548 Vehicles Available For Masimum Service Annual Total Passenger Miles 2804151882 126 1979229994 Computing Totals INTDAS allows records in a flat table to be combined to obtain totals for one or more system variables The screen for specifying the variables for which the flat table is to be summarized is shown in Figure 2 19 Selections are made by checking the system variables that are to remain in the resulting flat table 1 the flat table will be stratified by the variables that you checked Only the check boxes for the system variables that appear in the current flat table can be selected Figure 2 19 Input Screen for Computing Totals Compute Totals E X Find totals stratified bu Year Motes Iv NID ID Ta reset to the orginal table click Tools Reset T able Mode Code Total values for some variables Service Type may not be meaningful Cancel Examples e leaving all check boxes unchecked and click OK will result In only one record This
51. aucun O 3 Technical Support and Problem Report e 4 Dser Intertaee C ofvelll lO Stent a o apu 4 SECTION 2 PTDAS oes S I Woar e NTD m 1 I Ty TINO 1 INIDAS Feature oo dune adt so de Do uuo 2 Jb A gi Dk u a 2 One ima NA D D East tut oid mda x bei tu niu 3 Florida Standard Performance 5 ania Dies 13 Creating Modifying or Deleting a E a 13 Minimum User Input Needed to Retnieve N TD Data tieu l n esent eaae Pea eon ate 16 Selecime Cars and Service celu diae a aiiud cel uid 17 SEICCUNG Transit Sysilia 18 selecting Transit Systems by System Varlables 18 Selecon Transit Systems by OUSES arsi tese duod on hanka 20 selecting Transit Systems by System Groups 22 seleetmg States Data s E tbe ein COUR 23 Selene Data Variables
52. de Code and 406 Vehicles Operated in M asimum Service gt 500 Selected systems 3 Clear all Save as a group 4034 Metro D ade Transit Agency 8014 Alameda Contra Costa Transit District 9154 Los Angeles County Transportation Display definition To apply this option 1 Select the Select systems by query tab 2 Either search through the list or type in a keyword in the search box to narrow down the list of variables 3 Identify and select a variable from the variable list box listed below the search box Click a variable to send the variable to the Query Editor box possible data values for a selected variable are listed on the Values box 2 20 SECTION 2 INTDAS Note The Values box will automatically show all values of a system variable i e variable preceded by system For attribute variables you must click the Get values button to show the values 66 22 4 Click a math operators such as or gt 5 Click a value from the Values list box or type in the value from the keyboard Repeat the steps above for more query conditions which are usually separated by and or 29 Or 6 Click the Run Query button to run the query to identify transit systems that meet the query conditions If the query Is correctly constructed the resulting transit systems will be listed In the Selected Systems list box If the query contains invalid input an error message will pop up E
53. dit and re run the query Warning You may key in any query specifications using the keyboard However keying in the variable names is not advisable since most variables are long and are vulnerable fo typos Notes e All character values must be bounded by double quotations e All conditions in parentheses are executed together e The like operator allows you to enter a text pattern to search This option can only be used for text related variables For example to find all the transit systems that have Miami as part of the transit system name you may enter the following query System Company Name like The quotation marks must be included as part of the query Example You are interested In only the motorbus transit systems in Florida and California that have at least 500 vehicles operated in maximum service The query will be System State FL or System State CA and System Mode Mode Code MB and 406 Vehicles Operated in Maximum Service gt 500 Note Each variable name on the list box consists of two bracket components The first set of brackets lists the source of the variable generally the NTD form of the variable The name of the variable is listed in the second set of brackets For system variables the source is the System table in the database For system attributes the source is the three digit NTD form number For Form 405 which has two pages 405P1 and 40
54. diting function is to move a node e To move a feature left click a highlighted node the highlighted node will turn white hold down the button and drag the node to a new location In the case of moving a line select the Move Line button place your cursor across the feature hold down your left mouse button and then drag it to a new location Click the Undo button to undo a change e To add a node select the Add Node button and then left click at the location where the node is to be added e To delete a feature select the feature to delete and then click the Delete Node or Delete Line button This action cannot be undone 3 18 SECTION 3 FTGIS e If you know the specific coordinate for a node you may want to edit the node coordinate manually To do so click the Edit Nodes button The screen shown in Figure 3 19 will pop up The screen lists all the node coordinates To select a node to edit click an item on the list The corresponding feature will blink Click the Edit button to enter a new coordinate Click the Delete button to delete the node Click the Insert button to insert a node Figure 3 19 Screen for Editing Nodes Manually 3i Edit Feature Shape Shape Polline Paint 2320630 671 90469 29 Paint 250547 200639829 Point 250219 0132497 77 Point 230134 507033693 Paint 25005 235713102 Point zz 229835 325332533 Paint 223540 543703035 Point 229595 152619362
55. e and color for the labels Check whether to draw features allow duplicates use splined text or flip Drag the scroll bar to specify the degree of rotation Click Apply to display the lables You can go back and change some of the settings or click OK to exit the screen Clear All The Clear All function allows you to clear all labels themes and charts and return to the original map setting Select Features The Spatial Features function allows you to select features by pointing at a feature drawing a line that intersects one or more features see Figure 3 34 drawing a circle that intersects one or more features or drawing a rectangle or a polygon that intersects encloses or crosses one or more features For this option you can also select to enclose intersect cross or contain the centroids of the features being selected Figure 3 35 shows selected features based on drawing a rectangle with the cross option Selected features may be saved as a new map layer by selecting the Tools Save Selected Set into a New Shapefile dropdown menu item Data associated with the selected features may be saved into a text or an Excel file by selecting the Table Save into a File dropdown menu item The Table menu 15 active only when you are the Table view SECTION 3 FTGIS Figure 3 34 Select Features by Drawing a Line Gy GIs Database Metropolitan Dade Transit Authority File Edit View Tools Table Help S
56. e of the retrieved results 1s shown in Figure 3 24 Figure 3 24 Screen Showing Identified Results I Identify Results E xi Location 57 548 23511 7 1 feature found Feature 9 03 Attributes HH WZ PERS 42 HH iw PERS B VACANT 148 HH 195 PERS 213 TOTAL HH 1717 AGE 9 569 HH w PERS 424 124 PACIFIC WHITE 4313 HH 2 PERS 342 MEDIAN AGE 322 HH SIZE 328 HH ww PERS 479 18 19 128 OTHER 136 Theme tract2000 hp Shape Foluqon 3 22 SECTION 3 FTGIS The Feature field lists the features in all the visible layers that come close to the location of the mouse click After you have selected an item from the Feature list the corresponding feature in the map will blink to signal the feature of which the results are being displayed The results are displayed in the Attributes list box Find The Find function lets you search for all features that match a search string in the selected layers To find features 1 Click the Find tool button or select the Tools Find dropdown menu item The screen shown in Figure 3 25 will pop up Figure 3 25 Screen for Finding Features Find Features 1 Enter 4 search string County Haad 2301 2 Choose which layers to search 15 2000 stops old shp Find Mj 000 2000 shp 90 shp Select all
57. e radio button to select the chart type 3 Click one or more variables on the variable list Click a selected variable to unselect a variable 4 Drag the Chart Size bar up and down to select a chart size 5 Uncheck the Draw Outlines box to remove the chart outlines Create Thematic Maps The Create Thematic Maps function allows you to quickly create a thematic map based on a selected attribute in the active layer To create a thematic map 1 Click the Create Thematic Maps tool button or select the Tools Create Thematic Maps dropdown menu item The screen shown in Figure 3 32 will pop up Figure 3 32 Screen for Creating Thematic Maps 3 Themetic for the TRACT2000 SHP X Layer name 2000 shp Select Field Number of classes w F Style m Color anis C Size Dot Density Color and Size Unique Color ramp Start Draw outlines End 2 Click the Select Field dropdown list and select an available field for classification A thematic map will be created instantly 3 Click the Number of classes dropdown list and select the desired number of classes 3 29 SECTION 3 FTGIS 4 A default thematic type is set for you The Range type divides the field values into the specified number of classes of constant intervals The Dot Density type plots the number of dots based on the attribute values and the number of classes The Unique type plots each distinct value with a unique co
58. e service vehicles in active revenue service e Route Miles Number of directional route miles as reported NTD data defined as the mileage that service operates In each direction over routes traveled by public transportation vehicles in revenue service 2 7 SECTION 2 INTDAS e Total Operating Expense Reported total spending on operations Includine administration malntenance and operation of service vehicles e Total Maintenance Expense Sum of all expenses categorized as maintenance expenses a subset of total operating expense e Total Capital Expense Dollar amount of spending related to the purchase of tangible property or other items eligible to be capitalized Property includes tangible assets with an expected life of more than one year at the time of their installation and a unit cost greater than 1 000 e Federal Contribution Financial assistance obtained from the Federal government to assist in paying the operating costs of providing transit service Such assistance 15 available from the Urbanized Area Formula Programs of 49 U S C Formerly Section 9 other transportation grant programs administered by the U S Department of Transportation as well as other Federal agency programs e State Contribution Financial assistance obtained from a State government or agency to assist in paying the operating costs of providing transit service e Total Local Revenue All revenues originating at the local level excluding s
59. e six management systems previously required by the Intermodal Surface transportation Efficiency Act ISTEA of 1991 The National Highway System NHS Act of 1995 made the management systems optional to the States The Florida Department of Transportation intends to continue the collection of PTMS data Working with TAMS Database TAMS is accessible from the third button of the FTIS Main Menu screen see Figure 1 1 Clicking TAMS button will invoke the screen shown in Figure 4 1 The screen allows you to specify whether to work on an existing database or to create a new database Once a database is selected TAMS will take you into the screen shown in Figure 4 2 The screen consists of a set of five tabs for entering and displaying different categories of transit assent data If you have selected an existing database it will load all the available data onto the fields in each tab The fields are empty if you have chosen to work on a new database Enter the data in each field Use the Tab key to move from one field to another For fields that take only standard input TAMS will prompt you a dropdown list to select a list item as shown in Figure 4 2 After you have completely entered your data click the Save Record button to save the record The newly saved record should show in the table grid at the bottom half of the screen To delete a current record click the Delete Record button SECTION 4 MISCELLANEOUS COMPONENTS Figure 4 1 Scree
60. ed Click the Delete button and answer Yes when prompted to confirm the deletion 2 13 SECTION 2 INTDAS Figure 2 1 Main Screen for Formula Setup Jih Formula setup _ Florida standard variables User defined variables Administrative Employee FTEs Average Age of Fleet in years Average Fare Average Headway iri minutes Average Speed AMARAH Directly Generated Non F are Rev Fareba Recovery 2 Delete Formula Mew Modify BU 403 Non rall T otal Dir Route Miles 30 3 Rail T otal Dir Route Miles 406 Annual Total Actual Vehicle Revenue Miles 406 Annual Total Actual Train Revenue Miles 405 amp nnual Total Actual Vehicle Revenue Hours 406 Annual Total Actual Train Revenue Hours 406 Vehicles Operated in M asimum Service definitian Average headway in minutes Far the system as a whole that Is computed utilizing the following performance indicators directional route miles revenue miles revenue hours and the number of vehicles operated in maximum service The equation used to determine this measure first doubles the directional route mileage ta produce an estimate of system size in terms of total non directional route miles The resulting mileage figure is then divided by the system s calculated average speed revenue miles per revenue hour ta produce an estimate of the time it would take in
61. ed visible layer and then click the Add Line button ori the Edit Panel to add the selected feature Cancel e Select the first radio button if you want to select features from an existing layer Once this radio button is selected the dropdown list will display all the visible layers Select one visible layer Instructions on how to proceed from this point will appear at the lower half of the screen Click OK e Left click a feature to select it To select additional features hold down the Shift key while making the selection Features must be connected for any successive selections e Click the Add Line button in the Edit tool panel to add the selected features to the current layer To draw a line by mouse 1 Select the second radio button Once the button 15 selected instructions on how to proceed from this point will appear at the lower half of the screen Click OK 2 Start drawing a line Single left click to draw the beginning and intermediate nodes of a line and double left click to end the line 3 Click the Add Line button in the Edit tool panel to add the selected features to the current layer 3 20 SECTION 3 FTGIS To stop editing either click the Start Editing tool button again or select the Edit Stop Editing dropdown menu item Set Snapping Tolerance When the ends of two adjacent lines come close to within a certain distance during editing you may want them to be connected by snapping the two ends toget
62. eports the span of hours that any transit service 1s provided on a typical weekday Effectiveness Measures e Vehicle Miles Per Capita Total number of annual vehicle miles divided by the service area s population This can be characterized as the number of miles of service provided for each man woman and child in the service area and is a measure of the extensiveness of service provided in the service area e Passenger Trips Per Capita Average number of transit boardings per person per year This number is larger in areas where public transportation is emphasized and in areas where there are more transit dependents and 1s a measure of the extent to which the public utilizes transit In a given service area e Passenger Trips Per Revenue Mile The ratio of passenger trips to revenue miles of service a key indicator of service effectiveness that is influenced by the levels of demand and the supply of service provided e Passenger Trips Per Revenue Hour The ratio of passenger trips to revenue hours of operation reports on the effectiveness of the service since hours are a better representation of the resources consumed in providing service Average Speed Average speed of vehicles in revenue service operation 1 not including travel to and from the garage or any other deadhead calculated by dividing total revenue miles by total revenue hours e Average Headway Average headway in minutes for the system as a whole that is compu
63. ess to electronic publications related to transit planning Only a small number of publications are included in this initial version It will be greatly expanded in the 2002 version in terms of the number of publications interface and functionalities e Florida Transit Planning Links FTPLinks This planned component provides a gateway to transit planning related websites It will be expanded 2002 version e Contact This component provides direct email links to various agencies e Report Problem This component provides a convenient means for users to report problems and provide suggestions and comments to the FTIS developer FIU and the sponsor FDOT e Help This component provides access to various FTIS help documents Figure 1 1 shows the FTIS Main Menu that provides icons for access to each of these components The icons are arranged the order listed above from top right to the bottom left To open a component simply single click the appropriate icon The next three chapters provide details on each of these components Minimum System Requirements FTIS 15 a typical Windows installation designed to run on all Microsoft Windows operating systems For successful installation and application of FTIS your system must have e A monitor capable of at least 800x600 display resolution e minimum of 1 3 GB hard disk storage space for a full installation e A minimum of 50 MB storage space on the system drive usuall
64. g Area 3 GIS Database Tallahassee Transit Taltran E I si j x File Edit Tools Table Help al S 4 BLOcK2000 SHP TNUDE LENGTHIFEDIRP FENAME EOS n 82676870 17059 17052 469 01328 82841141 108 114 83 38563 Lanier Ci BLOCKGROUP2000 SHP 82841142 113 114 117 00231 Lanier St 82841143 106 113 158 31012 Lanier St 82841144 106 105 40 98282 CENSUS_TAZ2000 5HP 82841146 124 122 178 14736 Lanier St 82841147 111 115 73 99273 Lake Talquin Rd v ROUTE2000 SHP 82841150 104 107 154 45486 Rd 82841152 95 97 1915 Lone Star Rd 82841154 125 132 73 09288 Bloxham STOPS_OLD SHP 82841157 109 95 367 68783 Lone Star Rd m 82841158 103 344 53735 Jackson Bluff Rd STREET2000 SHP 82841153 53 575 35133 2000 5 O E E BE Ei 82841150 86 142 34309 Smith Creek Rd 82841161 92 322 68216 82841162 73 465 05976 Smith Creek Rd ia 82841163 659 56978 Ford Rd Rs 82841165 70 776 18918 Blazing Star Ln 82841166 134 893 43918 Um 531 I iss PS TRACTSO SHP 82841175 66 462 47958 Jackson Bluff Rd 82841175 101 315 20922 Jesse 82841173 83 297 80472 Smith Creek Rd 82841185 52 48 39322 State Highway 20 82841198 147 126 16998 Blount St 82841207 95 247 00173 82841208 83 147 35763 82841209 30 27 78743 82841212 68
65. her You can set a tolerance for determining whether to snap the nodes by selecting the Edit Set Snapping Tolerance dropdown menu item which brings up the screen shown in Figure 3 22 To enable the snapping function select the Edit Enable End Snapping dropdown menu item When this menu item is disabled the snapping will not take place even when two end nodes come to within the set tolerance Figure 3 22 Screen for Setting Snapping Tolerance Please enter the snap Curent snapping tolerance 50 meters Lancel Measure Distance The Measure Distance function allows you to draw a line of multiple segments and calculate the total distance in feet meters and miles To perform this function Click the Measure Distance tool button or select the Tools Measure Distance dropdown menu item Left click at the location of the starting location Move the mouse to the second location and left click Continue this step for additional line segments Double left click the last point of the line The resulting distances in different units will be displayed a pop up screen as shown in Figure 3 23 3 21 SECTION 3 FTGIS Figure 3 23 Output Screen from Distance Measurement The total distance i5 3039 15 meters 12551 15 feet 2 40 miles Identify The Identify function allows you to retrieve and display data attributes associated with all features near the point of a mouse click An exampl
66. hority 20000000 10000000 1994 1995 1996 1997 1998 1999 2000 I4 4 MI NCharti Sheet1 Sheet2 Z Sheet3 14 What Is Florida Peer Selection Process The Florida peer selection process attempts to identify comparable transit systems through a point scoring system based on the following eight original or derived variables or measures Service area population density Revenue miles Average speed Service area population Vehicles operated in maximum service Passenger trips Revenue hours Total operating expense The first three variables are considered primary and the rest are secondary Under the scoring system primary variables are given extra points The performance of each of the potential non Florida peers is compared to the average of the Florida systems for each of 2 40 SECTION 2 INTDAS the eight measures A peer receives one point for each measure for which it 1s within one standard deviation of the Florida systems mean One half point is given for each measure that fell between one and two standard deviations from the Florida systems mean The scoring system can also be based on percentage rather than standard deviation In the percentage based method a peer receives one point for each measure for which it was within 10 percent of the Florida systems mean One half point is given for each measure that fell between 10 and 15 percent from the Florida systems mean In both cases an extra one half point
67. iables All Florida Standard Variables are preceded by FSV e User defined variables These are variables created by users using FTIS formula setup function All user defined variables are preceded by USER Important Data for the original NTD variables are available at only the transit system level Data for the Florida standard and user defined variables are available at both the system and statewide levels The following subsections introduce the three groups of variables in more detail Original NTD Variables NTD data were reported on a total of 16 different forms for various characteristics associated with individual transit agencies Two of the forms are further divided into two sub forms called pages The total number of data entries on these forms totals over 1000 In general data for most of the variables are available for data years that trace back to the 1984 However because of major changes to NTD forms and some data from different years cannot be converted to fit the latest NTD form format and are thus excluded from the INTDAS database Table 2 1 lists all the NTD forms and the associated data years for which data are accessible in the current version of FTIS The original NTD variables can be divided into two categories The first category involves variables that are used to identify transit agencies and systems These are referred to as the system variables They include e unique four digit ID 1 NTD ID th
68. ically activates the default email system and attaches either a data file or a BMP file to the email 2 36 SECTION 2 INTDAS Creating Cross Tables A cross table allows you to view values cross classified by two variables at a time To create a cross table click the Cross Table tool button or select the View Cross Table menu item from the dropdown menu A screen similar to that In Figure 2 23 will appear Figure 2 23 Screen for Creating Cross Tables Gm INTDAS Cross Table View File Setup View Tools Reports Help sWe gl 21 gt a 53 Options Row variable Column variable Mode Code Service Type Value variable Select all AG Annual Total Unlinked Passenger Trips Mode Code CR PT Vehicles Operated in Maximum Service Mode Code Service Type DR Vehicles Available for Maximum Service Service Type HR Annual Total Passenger Miles VP 4026 Manatee County Area Transit 4027 Pinellas Suncoast Transit Authority 4028 Lee County Transit 4029 Broward County Commission Public Service Department 4030 Gainesville Regional Transit System 4031 Lakeland Area Mass Transit District Citrus Connection 4032 East Volusia Transportation Authority 4034 Metro Dade Transit Agency 4035 Orange Seminole Osceola Transportation Authority 4036 T altran City of Tallahassee 4037 Florida Transit Management Inc 4038 Escambia County Transit System 4040 Jacksonville Transportation Authority 4041 H
69. ida Peer System Process Implemented INTDAS a 41 SECTION 3 EI GIS iini tnt ete Du 1 WDY E TOIS M 1 ne 1 FEGI DUC HOTIS mite ton f Oe 3 GISData TCIM esis a asa 4 Lesend Map Views and Table VIEW ecni 6 Properties 9 PrODOL lle uu u 9 c bo uns manus el Ee ee ae ee eee ee 11 REMOVE ACtIVSOr ATLESVOUS ime ates ten ti Quan 12 IMACS 12 Change Feature Colorat Mouse Cursor ges uu au nonce eee 13 COM A stators E 13 Map Pnu ted 15 Due May ees eee 15 ma 16 NI Edin NCC 17 Ser Snappras tae 21 Measure aicu basa 21
70. iform demand for service over the day would result in a higher number e Vehicle Hours Per Peak Vehicle Substitutes vehicle hours for vehicle miles and again reflects how intensively equipment 15 utilized e Revenue Miles Per Vehicle Mile Reflects how much of the total vehicle operation 1s in passenger service Higher ratios are favorable but garage location training needs and other considerations may influence the ratio e Revenue Miles Per Total Vehicles Total revenue miles of service that are provided by each vehicle available for maximum service e Revenue Hours Per Total Vehicles Total revenue hours of service that are provided by each vehicle available for maximum service e Revenue Hours Per Employee FTE Ratio of total revenue hours of service to system total FTEs reflects overall labor productivity e Passenger Trips Per Employee FTE Ratio of total passenger trips to system total FTEs Another measure of overall labor productivity 2 12 SECTION 2 INTDAS e Vehicle Miles Per Gallon Vehicle miles of service divided by total gallons consumed and 15 a measure of energy utilization e Vehicle Miles Per Kilowatt Hour Vehicle miles of service divided by total kilowatt hours consumed and 15 another measure of energy utilization e Average Fare Passenger fare revenues divided by the total number of passenger trips User Defined Variables INTDAS allows you to define a new variable based on two or more original NTD
71. illsborough Area Regional Transit Authority 4046 Sarasota County Transportation Authority 4050 Smyrna Transit System 4063 Space Coast Area Transit 4074 Pasco Area Transportation Service 4075 Comprehensive Paratransit Services 4077 Tri County Commuter Rail Authority 4084 Okaloosa County Coordinated Transportation Inc 4085 Bay County Council Aging Bay Coordinated Transportation 4097 St Lucie County Inc 4104 Indian River County Council on Aging 4106 COMSIS Corporation 4109 B amp L Services 4113 Council on Aging of Martin County Inc 4120 SunTran 4127 Polk County Transit Services 657588 671713 635500 650770 6538709 666520 655984 267277 254 70 2 4803 58175 136142 ee opo du 1 38052 454 61479 66482 62604 20262 24762 37265 74304 153768 __ Plot lt lt Back The top of the screen shows five list boxes for system and variable selections The first four list boxes allows you to select each of the four system variables namely year NTD ID mode code and service type The last list box lists all the data attributes The second half of the screen shows the cross table that displays data cross classified by two variables at a time The cross table is updated instantly accordingly to your selections
72. ine files and the 2000 Census The TAZ layers are available for only those urban areas that submitted the TAZ census equivalency tables to the Census Bureau for inclusion in the 2000 Census In addition to the census data aerial photographs are included for the following transit systems Broward County Transit Miami Dade Transit Tallahassee Transit and Palm Beach County Transportation Authority Map Legend Map View and Table View Once you have double clicked to select a transit system and you have selected FTGIS as your GIS interface you will enter the FTGIS main screen All available layers for the selected systems will be automatically loaded The Street and the Route layers are automatically displayed By default the Route layer 1s displayed on top of the Street layer and has a thicker line width The viewing area of the screen Is made up of map legend on the left and the map view on the right as shown in Figure 3 3 The map legend lists all of the available GIS layers by their shapefile names for the selected transit system In front of each shapefile name 1 e a layer a check box allows you to choose the layers you want to display 1n the map view Notes e The layers with their box checked are displayed in the map view in the same order as listed in the map legend e reorder the map layers for example to display a route layer above the street layer drag the route layer in the map legend to a location above the street
73. ine help The following sections provide additional details for some of these functions 3 14 SECTION 3 FTGIS Map Printing To print your map shown in the map view you click the Print Map tool button or select the File Print dropdown menu item to invoke the screen shown in Figure 3 13 The screen will ask you to select a scale to print For example 1 2 scale will print to your map to cover half of the page The default is full scale and will print to cover the full page After you have selected a print scale click Next to invoke the standard Windows print screen which allows you make additional selections including printer paper orientation and number of copies Click Print to start printing Figure 3 13 Screen for Map Printing evn Map x Please select a scale to print 3 4 scale C 1 2 scale C 1 4 scale Cancel Add Layer The Add Layer function allows you to add a layer or an image file You may add any files with any of the following extensions ESRI Shapefiles shp ESRI Coverages adf tat pat rat GRID hdr adf CAD drawings dwg def VPF pft lat aft tft standard and military image formats Figure 3 14 shows the screen for finding and selecting a layer of a particular file type It is invoked from the Add Layer tool button or the Layer dropdown menu item 3 15 SECTION 3 FTGIS Figure 3 14 Screen for Adding a Layer Select file f
74. irect access to two GIS systems FTGIS and ArcView The selection 15 made at the bottom of the screen The radio button for ArcVirew is active only if your computer is installed with ArcView The default GIS interface 1s FTGIS If for any reason you either prefer or need to use ArcView you can simply select the ArcView option as the interface you want to launch Refer to ArcView manuals for instructions on how to use ArcView As shown in Figure 3 1 the System Selection by List option also allows the list to be modified to either add a new transit system or delete an existing one Note that update to the list does not automatically update the System Selection by Map option In other words any new systems you added can only be accessed by the By list option 3 2 SECTION 3 FTGIS Figure 3 2 Screen for Selecting a Transit System by Map System Selection g acksonvilia gia rion gBrevard sco Pine fas goi County tan atan parasotz River don Beach gri Ra gianni FTGIS C Arcview Double click to select Full enter Close FTGIS Functions FTGIS currently supports the following GIS functions Map Viewing It allows maps to be zoomed in zoomed out panned zoomed to extent of all layers and zoomed to the extent of the current layer v Map and Layer Properties
75. ker SIze Cancel Layer name route2000 shp Line Calor umm Style Solid Line width 2 Cancel Layer name blockgroup2000 shp Outline Color Fill Color Style Soia f Outline width 1 Draw outlines Cancel 3 10 SECTION 3 FTGIS Figure 3 9 Screen for Defining a Layer Color Basic colors _ j E P H m Custom colors T P 11 E E NE NN j j j j Define Custom Colors gt gt Describe Layer Figure 3 10 shows the screen that gives the basic information for a layer including the file path to shapefile shape type map units number of records and data fields and associated data type The screen is accessible from the View Describe Layer dropdown menu item Figure 3 10 Screen for Describing a Layer ij Describe Shapefile E E x Shapetile C FTIS FTGIS GISFILES talran street2000 shp Fields Shape type TLID Long L ae FNODIE Long N TNODE Long Map unit LENGTH Double Mete String FEN AME String String Number of records FEDIRS Shing 034 CFCC String SECTION 3 FTGIS Remove Active or All Layers If for any reason you want to remove the active layer or all the loaded layers you may select the View Remove Active Layer or View Remove All Layers dropdown menu item respectively Image Background FTGIS allows you to displa
76. le years for trend analyses peer comparisons and general data inquiries Y SQL query editor for identifying transit systems that meet a certain profile An automated Florida peer selection process for identifying comparable transit systems for peer analyses v Easy selection of NTD variables via NTD forms and list boxes v Create new variables from original NTD variables through user defined formulas Y Display retrieved data in tables and forms Y Automated VB and Excel plots Y Interactive cross tables to display two variables at a time Y Adjustment of financial variables to constant dollars Create Excel reports Y Perform data sorting and data summation Generate table statistics Y Convenient data transfer etc INTDAS Data Variables INTDAS includes the following three basic groups of variables its database 2 2 SECTION 2 INTDAS e Original NTD Variables These are the vartables for which data are submttted each year by transit agencies Each variable corresponds to one data entry ina NTD form In FTIS the names for the original NTD variables are preceded by the respective NTD form numbers in brackets For example all variables from NTD Form 001 will be preceded by 001 e Florida Standard Performance Variables These are the variables used in the FDOT Ss annual transit performance analysis Each of these performance variables was pre computed based on a formula involving one or more original NTD var
77. lor The number of unique values in an attribute cannot exceed 100 5 A Color default style is set for you For point and line layers you may choose either size or a combination of color and size as your style 6 If you have chosen Color as your style a default color ramp is set for you Click the Start and End color boxes to change the color ramp If you have chosen Size as your style a default color is also set for you Click the color box to change the color 7 Uncheck the Draw outlines box to remove the polygon outlines 8 Click OK to exit the screen Add Label The Add Label function allows you to label the active layer with a select variable in a preferred format To create labels 1 Click the Create Labels tool button or select the Tools Create Labels dropdown menu item The screen shown in Figure 3 33 will pop up Figure 3 33 Screen for Creating Labels Layer name Text Field Draw features Horizontal alignment Allow duplicates 5plined text Center m Vertical alignment Center Rotation Font 4 k MS Sans Serif 3 30 SECTION 3 FTGIS 2 Click Text field dropdown list and click field that has label you want to display Click the Horizontal alignment dropdown list and click an alignment for the labels Click the Vertical alignment dropdown list and click an alignment for the labels Click the Font button and select the font style siz
78. manuals treats this as part of Form 301 and names it as Form 301 Form 405 Page 2 did not exist before 1995 Table 2 2 lists the system variables for each NTD form This information 1s important for the users to understand the level of data availability For example the data except total passenger fare revenue reported in Form 203 are available at the systemwide level only The second category of variables consists of over 1000 data attributes that are used to record the various characteristics associated with each transit agency Examples of these variables include service area population unlinked passenger trips etc Note For detailed information on NTD forms and variables refer to the NTD reporting manuals which are accessible from the Help NTD Report Manuals menu item in the INTDAS main menu SECTION 2 INTDAS Table 2 2 NTD Forms and Stratifying System Variables NTD Form Stratifying System Variables 001 Data year NTD ID 002 Data year NTD ID 103 Data year NTD ID service type 203 Data year NTD ID 300 Data year NTD ID 301 Data year NTD ID mode code service type 321 Data year NTD ID mode code 331 Data year NTD ID 402 Data year NTD ID mode code service type 403 Data year NTD ID mode code service type 404 Data year NTD ID mode code service type 405 Page 1 Data year NTD ID mode code service type 405 Page 2 Data year NTD ID mode code service type 406 Data year NTD ID mode code service type
79. ment Inc FL DR PT 401493 32 1999 4037 Florida Transit Management Inc WestPalm FL DO 5477364 33 195 4037 Florida Transit Management Inc WestPalm FL PT 304874 34 1999 4038 Escambia County Transit System Pensacola 0 PT C 54366 Annual Total Vehicles Vehicles No Year NTD ID Company Name s Service Unlinked perated in Available for Annual Total ode Type Passenger Maximum Maximum Passenger Miles Service Service 1 4026 Manatee County Area Transit Bradenton FL IDR i 8 8 2 1999 4026 Manatee County Area Transit C Bradenon FL pR PT 18632 4 A 174396 3 1999 4026 Manatee County Area Transit __ Bradenton DO 666528 njoo tef 2151 76 4 1999 4026 Manatee County Area Transit Bradenton FL VP DO 24 7849 5 1999 4027 Pinellas Suncoast Transit Authority Clearwater FL DR PT 22921 6 86 1885241 6 1999 4027 Suncoast Transit Authority Clearwater FL 0 9290 C 38428300 z 1999 4028 Lee County Fort Myers DR PT gt 42 626 034 8 1999 4028 Lee County Transit Fort Myers FL MB DO 1855535 4 5 10 223 985 9 1999 4 28 Lee County Trans VP 0 229 17 1 62 10 1999 4029 Broward County Commission Public DR PT 88500 54 225 9 399 8
80. n Menu will invoke the screen shown Figure 3 1 e The first tab lists the transit systems for which GIS data are currently available Double click a list item to select a transit system and enter the GIS interface e The second tab allows you to identify and select a transit system by a map shown in Figure 3 2 Each point on the map corresponds to an urban area where a transit system 1s located Double click a city to select a transit system and enter the GIS interface 3 1 SECTION 3 FTGIS Figure 3 1 Screen for Selecting a Transit System by List di System Selection E 3 X By list By map Florida Transit Systems Bay County Council on Aging Broward County Mass Transit Division County of Volusia VD TRAN Escambia County Area Transit Gainesville Regional Transit System Indian River Council on Aging Jacksonville Transportation Authority West Department of Transporation Lakeland Area Mass Transportation Lee County Transit Transit Orlando Manatee County Area Transit Marion County Transit Metropolitan Dade Transit Authority Palm Beach County Transportation Authority Pasco County Transit Pinellas Suncoast Transit Authority Falk County Transit Sarasota County Area Transit Space Coast Transit Authority Tallahassee Transit T Tri County Commuter Authority FTGIS ArcView D auble click ta select FTIS provides d
81. n for Selecting a Working Database O Files C Program Files FTIS TdataSPTMS data Time Cancel Figure 4 2 TAMS Data Entry and Display Screen tts TAMS file MDT Transit Asset mdb ial x File Help Agency ID Buildings Facilities Inventory Equipment Inventory Revenue Vehicle Inventory Support Vehicle Inventory Agency Wheelchair Capacity Agency ID 2 Period Vehicle Mileage Record Vehicle Type Code NENNEN Lifetime Vehicle Mileage Ownership Code Vehicle Purchase Price Save Year of Manufacturer Estimated Replacement Cost Record Vehicle identification number 1 Most Recent Rehab rear Model Number D Estimated Replacement Year Delete Manufacturer Code 2271 Physical Condition Score Record Active AR Air Stream Corporation a ition Rating ADA Access AA Allen Ashley Inc wner Import General Corporation Records Emergency Contingency Vehicle Fuel Type Seating Capacity American Corporation American Transportation Corporation BBB Bluebird Corporation BOY Boyertown Auto Body Works Enter the three letter manufacturers BIA Bus Industries of America manufacturer 1 enter vehicle w Agency Name ID FF Fleetwnnd F nternrises Record h ri of 4 CBW Carpenter Body Works CMC Champion Motor Coach Inc Chance Coach Inc Chance M anufacturir
82. natively you can use the Enter key in lieu of a mouse click e Click the Printer or Email button to print the form on a printer or e mail the form to a third party INDTAS will automatically capture the screen store it as a BMP graphics file activate your email system if it 15 not already activated open a new email and attach the graphics file as a file attachment Figure 2 14 Retrieved Data on NTD Forms Setup wiew Help fear 2000 NTO Ip 4034 Maximum Service Vehicles Vehicles operated in maximum service Vehicles available for maximum service Pernods of Service Time service begins Time service ends Service Supplied Modes Number af vehicles in operation Total actual vehicle miles Total actual vehicle hours Total actual vehicle revenue miles Total actual vehicle revenue hours Total scheduled vehicle revenue miles service hours School bus hours Number of passenger cars in operation Total actual train miles Total actual train hours Total actual train revenue miles Total actual train revenue hours Total actual passenger car miles Total actual passenger car revenue miles Total scheduled passenger revenue miles Total actual passenger car hours Total actual passenger car revenue hours Service Consumed Unlinked passenger trips a 404 related unlinked nassenaer trios IOA Passenger miles Service Operated D aus 2b Days schedule operated
83. ncy 3 007 4035 Orange Seminole Osceola Transportation Authority 4040 Jacksonville Transportation Authority 4041 Hillsborough Area Regional Transit Authority 2e 007 1 007 2 Line Style Colo Marker width 2 point Excel Plot lt lt Back the Plot view you can customize the color line width line type legend and label using the dropdown lists at the bottom of the plot You may also change any of the variables selected on the five list boxes to instantaneously update your plot If your computer 15 installed with MS Excel you may obtain an equivalent Excel plot by clicking the Excel Plot button at the bottom right of the screen INTDAS will automatically activate Excel import data into Excel and then create an Excel plot as shown in the example screen in Figure 2 26 2 39 SECTION 2 INTDAS Figure 2 26 Excel Plot E Microsoft Excel Book1 File Edit Yiew Insert Format Tools Chart Window Help ID 587 Bm gt iig gt s ms B ENS K Cu 0 00 00 10 5 4A Annual Total Unlinked Passenger Trips 70000000 60000000 50000000 m 4029 Broward County Commission Public Service Department 40000000 m 4034 Metro Dade Transit Agency Legend 4035 Orange Seminole Osceola Transporta Authority 30000000 4040 Jacksonville Transportation Authority m 4041 Hillsborough Area Regional Transit Aut
84. ola amp a BLOCK2000 SHP B BLOCKGROUP2000 SHP ROUTE2000 SHP STOPS OLD SHP B STREET2000 SHP v TRACT2000 5HP TRACT1990 SHP Ratio scale 1 63119 771627 14 201098 91 Image MapTips Figure 3 35 Select Features by Drawing a Rectangle gt GIS Database Metropolitan Dade Transit Authority File Edit View Tools Table Help alse 224 2 BLOCK2000 5HP BLOCKGRDUP2000 SHP m ROUTE2000 5HP STOPS_OLD SHP STREET2000 SHP v TRACT2000 SHP TRACT1990 SHP Ratio scale 1 63119 784083 33 21245 1 4 008 height 2 867 mi Image ips 7 3 32 SECTION 4 MISCELLANEOUS COMPONENTS MISCELLANEOUS COMPONENTS This chapter introduces all the other components accessible from the FTIS main screen TAMS TAMS Transit Asset Management System is a FTIS component designed to perform the same tasks as the TimesLink program developed previously by the Center for Urban Transportation Research CUTR The program was redesigned to make it work more seamlessly with FTIS As with TimesLink TAMS allows transit agencies to electronically transmit PTMS Public Transportation Management System data to FDOT PTMS is designed to collect analyze and disseminate information on the condition of Florida s transit assets is one of th
85. olumbia Sree DR Demand Response _ Enter here to select variables by standard NTO forms Ferruhbnpat or lupe keyword to find Systems 34 Select all Clear all S 22 7 Reset Select all Clear all Services JT 301 Fr Month Bay County Council Aging B ay Lc LA Light Rail Streetcar Broward County Commission Public 5 Motorbus City of Key west Monorail gt City of Miami Beach Miami Beach Tre Comprehensive Paratransit Services Mode ao greg ale for FS only 001 Address Lity COMSIS Corporation iS c ustemwide otal 001 Address State Council on Aging of Martin County Ire FT Fired route Total all exce East Volusia Transportation Authority HT Total AG C0 CR F m Escambia County Transit System m MT Total DH FB J11 Rerinient F States Select all Clear all E Caliarnia Click item to select Florida Transit M anaaement Inr Selected variables 0 Delete Save as group Selected systems 0 Display definition View Forms View Tables Close Help Selecting Data Years and Service Types The selections of NTD data years and service types are straightforward Both selections are done at the top right corner of the INTDAS main screen as shown in Figure 2 4 Figure 2 4 Data Years and Service Types x tabase Analysis System Select data years and service type s From DU Directly Opera
86. on of data variables is not needed when you want to display retrieved data on NTD forms This display option will display all data for all variables on all NTD forms regardless of which variables you have selected or whether you have selected a variable As soon as a transit system is selected and 15 listed In the Selected systems list box the View Forms button at the bottom of the screen will be turned on Note The number in the brackets next to the list box name indicates the number of systems selected Important 7o activate the View Tables button at least one transit system and one variable must have been selected The following three sections describe the process of selecting the four basic variables in detail 2 16 SECTION 2 INTDAS Figure 2 3 INTDAS Main Screen x File Setup view Help Integrated National Transit Database Analysis System TERR Select data years and service tupe s Dia eS bud 1984 DO Directly Operated Set as Select systems by system variables Select systems by query default Purchased Transportation Instructions A o 2000 DP Service aggregate DO PT for FS only Individual mades Reset All individual modes Select variables Colorado 4 Click selected item 1406 Automated Guideway CT Connecticut as CE Cable Car Original Florida 5 User defined DE Delaware CA Commuter Fail District of C
87. on the five list boxes which have the following operational characteristics e The first two list boxes specify the row and column variables of the cross table Ifa variable is selected in one of the two list boxes it will not be listed in another list box 2 37 SECTION 2 INTDAS e The third and fourth list boxes will list all possible values associated with each of the remaining two system variables One value must be selected on each of these boxes The default selection In each of these boxes 15 the first item on list e One or more attribute variables may be selected on the fifth list box When more than one data attribute 15 selected as is shown Figure 2 24 the second list box will list the possible values for one of the system variables rather than list the system variables The cross table will be cross classified by the first and fifth list boxes Figure 2 24 Cross Table with More Than One Attribute Variable Gm INTDAS Cross Table View File Setup View Tools Reports Help mec 2021 0 as Dptions Row variable Mode Code Service Type 4026 Manatee County Area Transit 4027 Pinellas Suncoast Transit Authority 4028 Lee County Transit 4029 Broward County Commission Public Service Department 4030 Gainesville Regional Transit System 4031 Lakeland Area Mass Transit District Citrus Connection 4032 East Volusia Transportation Authority 4034 Metro Dade Transit Agency
88. or dropdown menu item The default is not to have the color changed Toolbar Commands The common commands in FTGIS are implemented in a toolbar in the main screen Placing your mouse cursor across a button will reveal a tooltip for the button The commands in the FTGIS toolbar are shown in Figure 3 12 Figure 3 12 FTGIS Toolbar Gy GIS Database Bay County Council on Aging File Edit 4294 um s g UMPA View Tools sorqdeacy 9 1 E29 AT Help e amp o e alc E B XD dun TY dm PP ee S Se F SF Baa H gt uu B B Be B DEO NS ESE oF S o 5 gt ES dM hoo on uM 8 o T 0 5B B Ne gt e Return to System Selection allows you to return to the System Selection screen see Figures 3 1 and 3 2 to switch to another transit system e Print Map allows you to print the current map view to your default printer e Add Layer allows you to add a new layer e Graphics allows you to invoke the graphics toolbar to write text and draw geometric features on the tacking layer e Start Editing allows you to invoke the editing toolbar to start editing the active layer 3 13 SECTION 3 FTGIS e Measure Distance allows you to draw one or more connected line segments and measure the distance between the starting and ending points e Map F
89. or new layer Look Sy FrIS1 Data Computer Al My Network Files of type ESRI Shapefiles shp Cancel Open as read only 2 Graphics The Graphics function allows you to draw the following graphics on the map view texts points lines rectangles polygons and ellipses Clicking the Graphics tool button or selecting the Edit Draw Graphics dropdown menu item will activate the tool buttons shown in Figure 3 15 for drawing each of the graphics Figure 3 15 Tool Buttons for Drawing Graphics tosAjod DDV Gi is a r _ eh To add text click the first tool button in Figure 3 15 move your mouse cursor to the desired map location and then left click The screen shown in Figure 3 16 will pop up Enter the text label and then click OK 3 16 SECTION 3 FTGIS Figure 3 16 Screen for Specifying Text Label Enter text label mm To draw a point click at the desired location for the point To draw a line a rectangle a polygon or an ellipse point your mouse cursor at the desired start location hold down your left mouse button drag your mouse cursor to the desired end location and then release the left mouse button Map Editing The map editing function allows you to edit an existing feature add a new feature by drawing with the mouse or select features from another layer and add
90. or the Cancel button to exit without changes If the formula is valid INTDAS will compute the values for the new variable according to the formula s you entered 2 15 SECTION 2 INTDAS Note The execution of the Save function may take up to several minutes depending on the complexity of the formula and of course the speed of your computer The steps for modifying an existing variable are similar In this case all the specifications involved in the above steps will be automatically loaded and available for changes Minimum User Input Needed to Retrieve NTD Data INTDAS provides several alternatives for quick and easy data retrieval To retrieve NTD data four basic selections based on the system variables must be made v Select the range of NTD data years of interest v Select the type s of service v Select the transit systems of interest In the case of statewide data available for Florida standard and user defined variables only select the states of interest v Select the data variables for which data are to be retrieved Note All four basic selections may be performed in any sequences Figure 2 3 shows the INTDAS main screen that allows you to make these selections The left side of the screen allows you to identify the transit systems or states in the case of statewide data of interest The right side of the screen allows you to select the data years the service types and the NTD data variables Note The selecti
91. pect Site Home Okaloosa County Coordinated Transit Palm Tran Pinellas Suncoast Transit Sarasota County Transit Agency Space Area Transit St Lucie Council on Aging SunTran Tri County Commuter R ail Double click ta select Contact This function provides an interface see Figure 4 5 for direct email links to various agencies You may add a new email link or edit an existing email link using the Add and Edit buttons respectively To email any of the agencies on the list double click the desired list item to activate your default email system 4 4 SECTION 4 MISCELLANEOUS COMPONENTS Figure 4 5 Email Contact List Select Organization Bay County Council on Aging Broward County Mass Transit Central Florida Regional Transit Agency City of Miami Beach THA City of Tallahassee LCOMSIS Mobility Services County of V olusia vU T HAN Escambia County Transit FOOT Public Transit Office Gainesville Regional Transit System Hillsborough Area Regional Transit Agency Indian River County COA Jacksonville Transportation Authority Lakeland Area Transit District Lee County Transit Lehman Center For Transportation Research FILI Manatee County Area Transit Martin County Council Aging Miami Dade Transit Agency National Transit Database NTO Prapect Site Home Okaloosa County Coordinated Transit Palm Tran Pinellas Suncoast Transit Sarasota County Transit Agency Space Area Transit
92. r data item is added to an existing form in a certain data year in which case the available data years will be based on the data year the item is added rather than the data years shown in Table 2 1 for an entire form 2 5 SECTION 2 INTDAS Table 2 3 Florida Standard Performance Variables General Performance Effectiveness Measures Efficiency Measures Indicators e Service area population e Service area size e Passenger trips e Passenger miles e Vehicle miles e Revenue miles e Vehicle hours e Revenue hours e Route miles e Total operating expense e Total maintenance expense e Total capital expense e Federal revenue e State revenue e Local revenue e Total employees e Transportation operating employee e Administrative employees e Vehicle available in maximum service e Vehicle operated in maximum service e Spare ratio e Total gallons consumed e Total energy consumed SERVICE SUPPLY e Vehicle miles per capita SERVICE CONSUMPTION e Passenger trips per capita e Passenger trips per revenue mile e Passenger trips per revenue hour QUALITY OF SERVICE e Average speed e Average headway e Average age of fleet e Number of incidents e Number of vehicle system failures e Revenue miles between failures AVAILABILITY e Revenue miles per route miles e Weekday span of service e Route miles per square mile of service area 2 6 COST EFFICIENCY Operating expense per capita Operating
93. s EI fF FF M Service Operated Days Wkdys Sat Sun 26 Days schedule operated tT j Ct D 2 Davus not operated due to strikes m m M 2 Days not operated due to declared emergencies LL TI ft LL 2 25 SECTION 2 INTDAS You may select all variables on a form by clicking the Select All button Click the Clear All button will clear all the check boxes in the current form The selected variables are listed on the Selected variables list box and can be viewed after you click OK to exit to the INTDAS main screen To unselect a variable e Click the variable name on the variable list box or e Click the Go button to return to the form to uncheck the check box Selecting Variables by Variable List This option allows you to select variables from a list It 1s available for all three variable types 1 original NTD Florida standard and user defined as shown in Figure 2 11 which shows one tab for each of the three variable types Figure 2 11 Screen for Selecting Variables by List Select variables Original NTD Florida FSV User defined Enter here to select variables by standard N TD forms or type in keyword to find miles Reset Select all Clear all 406 Annual Total Actual Passenger Car Revenue Miles 406 Avg Wkdy Peak Total Scheduled Passenger Car 406 wk du Midday Total Scheduled Passenger Car Re 406 avg PM Peak Total Scheduled Pa
94. s for setting up a peer group are as follows 2 41 SECTION 2 INTDAS 1 Select the state default 1s Florida for which its transit systems 1 local are to be compared with peers from the other states Enter a range for the local grouping variable to find a group of local transit systems that are of comparable size Click the Get Systems button to find transit systems that satisfy the input conditions Select a scoring method and the corresponding scores to be assigned to different ranges of standard deviation or percentage for both primary and secondary variables Select one or more peer states The default peer states are Alabama Arkansas Georgia Kentucky Louisiana Mississippi North Carolina South Carolina Tennessee Texas and Virginia You may reset the default peer states by first selecting your desired states and then click the Set as Default button Select the mode code s that are to be considered The Select mode code list box lists only those modes available for the selected local systems Select primary and secondary measures from list of available variables This 15 done by first selecting the measures from the lists of variables and then checking the variables that are to be used as the primary variables Variables that are unchecked are treated as the secondary variables See the previous section on the difference between the primary and the secondary variables Click the Next button at the bottom
95. ssenger Car F 406 avg Wkdy Other Total Scheduled Passenger Car Reve 406 Avg ww kde Total Scheduled Passenger Car Revenue k 406 Avg Sat Total Scheduled Passenger Revenue Mile 306 Sun Total Scheduled Passenger Car Revenue Mil 406 Annual Total Scheduled Passenger Car Revenue Miles Total 404 Related Inlink ed Miles Selected variables 4 Delete Clearall Save as a group 406 Annual Total Unlinked Passenger Trips 406 Annual Total Actual Train Revenue Miles 406 Annual Total Actual Passenger Car Revenue Miles 406 Annual Total Scheduled Passenger Car Revenue Miles To identify and select a variable 1 Enter or partial keyword to search for all variables that match the keyword matched variables will be listed on the Selected variables list box In the case of Figure 2 11 the keyword entered is miles Instead of a keyword you may enter a 2 26 SECTION 2 INTDAS form number to short list to variables of a particular form For example typing in 406 will cause the list to include only Form 406 variables 2 Select all variables by clicking the Select All button or any of the listed variables by clicking the specific variable names on the list box All selected variables are highlighted on the variable list box and are listed on the Selected variables list box To unselect a variable e Click the variable name on the
96. t tab when you first enter INTDAS Select state s from the States list box Select the desired mode codes from the Individual modes list box and the desired mode aggregates from the Mode aggregate list box The default state is Florida and the default for transit modes is to select all modes Note Mode aggregate output records that represent the aggregate values of all modes operated by a transit system Mode aggregate output is only available for the Florida standard and user defined variables The following four aggregate options are available e Systemwide Total ST This aggregate option provides aggregated values of all modes of a transit system Fixed Route Total FT This aggregate option provides aggregated values of all fixed route modes of a transit system i e all except demand response e Rail Total RT This aggregate option provides aggregated values of all rail modes i e AG CC LR HR IP LR MO of a transit system Non Rail Total NT This aggregate option provides aggregated values of all none rail modes i e DR FB JT MB PB TB TR VP OR of a transit system On each list box clicking a list item once will select the item Selected items are highlighted Clicking a selected item again will unselect the item All transit systems matching the selected states and have at least one mode matching the selected modes will be listed on the Systems list box Note tems on the Systems list box ma
97. t the file structures that may vary from year to year identify the specific variables of interest from the vast number of potential NTD variables and then extract the corresponding data values from the specific files for the specific transit systems For a ten year trend analysis for example this process must be repeated ten times one for each data year After the trend values are separately extracted for each of the ten years they must be entered manually into a spreadsheet or a statistical program for analysis This process is very cumbersome and is prone to errors Clearly a solution to the data accessibility problem 15 to develop an integrated database system such as INTDAS that 1 combines the individual NTD data files from multiple years into a single standardized database and 2 provides customized tools for quick and easy data retrieval visualization and analysis 2 1 SECTION 2 INTDAS INTDAS Features INTDAS is useful for both the practitioners and researchers who use the NTD data to improve transit performance and services Although INTDAS was developed mainly for Florida it 15 fully applicable to users from the other states Major INTDAS features Include Y Original NTD data for all transit systems reported to the NTD program for 1984 2000 data years v Statewide and systemwide NTD data for over 60 Florida standard performance variables v Quick and easy retrieval of data for multiple transit systems of multip
98. tate and federal assistance This represents the sum of local contribution directly generated non fare revenue and passenger fare revenue e Local Contribution Any financial assistance obtained from a local government agency below the State level to assist In paying the operating costs of providing transit service e Operating Revenue All revenues except passenger fares generated through the operation of the transit agency Includes special transit fares school bus service revenues freight tariffs charter service revenues auxiliary transportation revenues subsidy from other sectors of operations and non transportation revenues e Passenger Fare Revenue Revenue generated annually from carrying passengers in regularly scheduled service e Total Employee FTEs Total number of payroll employees of the transit agency in terms of full time equivalents FTEs It 1s useful to note that the increasing tendency to contract out for services may result in some significant differences in this measure between otherwise similar properties It is important to understand which services are contracted before drawing conclusions based on employee levels All employees classified as capital are not included 2 8 SECTION 2 INTDAS e Transportation Operating Employee FTEs All employees In terms of FTEs classified as operating employees vehicle drivers supervisory personnel direct personnel e Maintenance Employee FTEs All employees
99. te Miles 406 Annual Total Actual Vehicle Revenue Miles 406 4nnual Total Actual Tran Revenue Miles Annual Total Actual Yehicle Revenue Hours 405 Annual Total Actual Train Revenue Hours 14 406 Vehicles Operated in M asimum Service Definition Average headway in minutes Far the system as a whole that is computed utilizing the following performance Indicators directional route miles revenue miles revenue hours and the number of vehicles operated in maximum sevice The equation used to determine this measure first doubles the directional route mileage to produce an estimate of system size in terms of total nan directional route miles The resulting mileage figure is then divided by the system s calculated average speed revenue miles per revenue hour to produce an estimate of the time it would take in hours to traverse all of the system s total route miles Finally this time Save Cancel Help Sae Came Hep 4 Enter a search string to find the target original NTD variable s 5 Construct a formula by clicking variables and math operators The clicked items will be sent to the Formula box Note nstead of using the mouse the keyboard may be used to edit the formula However keyboard input for inserting a variable name is not recommended because of potential typos 6 Optional Enter the definition of the new variable 7 Click the Save button to execute the formula
100. ted SEA PT Purchased Transportation digicam DP Aggregate DO PT e For data years enter the range of data years for which the data are to be retrieved The From year must be greater than the To year 2 17 SECTION 2 INTDAS e Three check boxes are provided for each of the three service type options directly operated DO purchased transportation PT or service aggregate DP or DO PT The service aggregate option is for retrieving records that aggregate the DO and PT values of each transit mode option At least one service type must be selected Note The DP option is available for only the Florida standard and user defined variables e You may set your selections for data years and service types as the default by clicking the Save as Default button When you enter INTDAS the next time the selections will be automatically loaded Selecting Transit Systems INTDAS provides the following three options to facilitate the selection of transit systems to meet different application needs Selecting Transit Systems by System Variables This option allows you to use the system variables to quickly identify transit systems from a set of list boxes It 1s best suited if you already know the specific transit systems you are interested in Figure 2 5 shows the interface for this option Figure 2 5 Screen Area for Selecting Transit Systems by System Variables Select systems by groups Select states Select systems
101. ted utilizing the following performance indicators directional route miles revenue miles revenue hours and the number of vehicles operated in maximum service The equation used to determine this measure first doubles the directional route mileage to produce an estimate of system size In terms of total non directional route miles The resulting mileage figure is then divided by the system s calculated average speed revenue miles per revenue hour to produce an estimate of the time it would take in hours to traverse all of the system s total route miles Finally this time 2 10 SECTION 2 INTDAS figure is divided by the system s number of peak vehicles then multiplied by 60 to convert time in hours to minutes to determine the number of minutes it takes for a vehicle to complete its portion of the total route miles one time e Revenue Miles Between Incidents Number of revenue miles divided by the number of incidents reports the average interval in miles between incidents e Revenue Miles Between Failures Number of revenue miles divided by the number of vehicle system failures an indicator of the average frequency of delays because of a problem with the equipment e Revenue Miles Per Route Mile Number of revenue miles divided by the number of directional route miles of service an indicator of the availability of transit service e Route Miles Per Square Mile of Service Area Number of directional route miles of service divided b
102. the Americans with Disabilities Act ADA the U S Department of Transportation Federal Register Vol 56 No 173 Rules and Regulations FTA began requiring transit systems to provide service area size as part of Form 001 in 1992 e Passenger Trips Annual number of passenger boardings on the transit vehicles A trip 1s counted each time a passenger boards a transit vehicle Thus if a passenger has to make one transfer to reach a destination he she is counted as making two passenger trips e Passenger Miles Number of annual passenger trips multiplied by the system s average trip length in miles This number provides a measure of the total number of passenger miles of transportation service consumed e Vehicle Miles Total distance traveled annually by revenue service vehicles including both revenue miles and deadhead miles e Revenue Miles Number of annual miles of vehicle operation while in active service available to pick up revenue passengers This number is smaller than vehicle miles because of the exclusion of deadhead miles such as vehicle miles from the garage to the start of service vehicle miles from the end of service to the garage driver training and other miscellaneous miles that are not considered to be in direct revenue Service e Vehicle Hours Total hours of operation by revenue service vehicles including hours consumed in passenger service and deadhead travel e Revenue Hours Total hours of operation by revenu
103. the listed variables and math operators In Figure 2 20 the application is to add the total actual vehicle miles and the total train miles to obtain a variable for total actual miles regardless of whether the modes are rail or non rail Adjusting for Inflation INTDAS allows you to adjust the financial variables in a flat table for inflation to a specific year from 1984 to the current year if inflation rate is available based on the national inflation rate Inflation adjusted dollars provide a more accurate representation of spending changes resulting from agency decisions by factoring out the general price inflation The inflation rate reported is the percentage change in the Consumer Price Index CPI for all items including commodities and services from year to year The steps for applying this function are as follows 1 Select Tools Adjusment for Inflation from the dropdown menu The screen shown in Figure 2 21 will pop up The screen allows you to select the base year and the financial variable s to adjust Only financial variables are listed 2 Select the base year you want to convert the dollar values to 3 Select one or more variables by single clicking the desired variables As soon as you have clicked the OK button INTDAS will start the conversion and a new variable with the equivalent values will be listed side by side each of the original variables selected The name of each adjusted variable will be attached with the equi
104. to the email as a file attachment Figure 4 6 FTIS Problem Report Form d Report Problem General Hame John Doe Organization ane and John Transit Authority Phone 305 348 111 305 348 1112 Operating system windows 2000 Display resolution 800 BOO Set default Problems Suggestions Comments I was not able to find data for our company for years 1979 1983 Did I something wrong Frint Send Close Help Help This button provides access to this user s manual the on line help and the About FTIS box which is shown in Figure 4 7 4 6 SECTION 4 MISCELLANEOUS COMPONENTS Figure 4 7 FTIS About Box Florida Transit Information System FTI5 Version 2001 March 4 For Windows 96 98 Me 2000 NT Copyright c 2001 Florida Department of Transportation All nights reserved Developed for Public Transit Office Florida Department of Transportation BOS Suwannee Street 5 26 Tallahassee Florida 32399 Tel 850 414 4532 Email Developed by Lehman Center for Transportation Research Florida International University University Park Campus EAS 3680 Miami Florida 33199 Tel 305 348 3116 Fax 305 345 2802 System Info Exit This button allows you to exit from the FTIS completely It serves the same function as the standard Close button on the top right corner of the screen 4 7 SECTION 4 MISCELLANEOUS
105. ull extent allows you to change the map extent in the map view to include all features In all map layers e Active Layer Extent allows you to change the map extent to that of the active layer Zoom In allows you to change the map extent to span two points that you set by dragging the mouse in the map view Zoom Out allows you to decrease the map scale by a factor of two centered on a point you click with the mouse e Pan allows you to change the map extent of the map view by dragging the mouse from one point to another e Identify allows you to identify features at or near where you click with the mouse e Find allows you to invoke the Find Features screen which allows you to locate features by matching attribute values e Buffer Zone Analysis allows you to invoke the steps for performing buffer zone analysis e Stop Processing allows you to stop the buffer zone processing e Draw Charts allows you to invoke the Draw Charts screen to draw pie or bar charts for the active layer e Thematic Maps allows you to invoke the Thematic Maps screen to create thematic maps based on attribute values of the active layer e Label allows you to invoke the Label screen to add label based on attribute values of the active layer e Clear All allows you to clear all graphics themes charts and labels e Send Map allows you to email a screen capture of the current map view as a file attachment e Help allows you to access the FTGIS onl
106. valent year in parentheses Figure 2 21 Screen for Specifying Year and Variables for Inflation Adjustment Dl Which varable s do you want to convert to the equivalence of the REE dollars Federal Contribution Local Contribution Operating Revenue Passenger Fare Revenues State Contribution Total Capital Expense Total Local Revenue Total Operating Expense 2 35 SECTION 2 INTDAS A set of standard inflation rates derived from the federal consumer price indexes are defined in INTDAS and are used for the conversion Although it is generally desirable to use these standard inflation rates INTDAS allows you to modify them if necessary through the following steps e Select Setup Inflation Rates from the dropdown menu The screen shown in Figure 2 22 will pop up Figure 2 22 Screen for Specifying Inflation Rates 4 Inflation rates ear Aae 0 0431 e Click an existing cell to enter a value This overwrites existing value e Click the Add New button to add the inflation rate for a new year e Click the Close button to exit All changes or additions are permanent Note You are not allowed to specify an inflation rate for a year beyond the current year Transferring Tabulated Data To ease data transfer INTDAS allows retrieved data to be saved as an Excel file xls or a comma delimited file txt Forms and plots can be saved as a BMP file With a mouse click INTDAS automat
107. y aerial images in the map background Figure 3 11 shows an example of an image background To display images click the Image checkbox at the bottom right corner of the main screen To remove images simple uncheck the checkbox The checkbox is active only if image files are found in the file folder for the selected transit system To view information related to the image files select the View Image Documentation dropdown menu item Figure 3 11 Image Background Gy GIS Database Metropolitan Dade Transit Authority File Edit View Tools Table Help alya 2 2593 BLOCK2000 5HP El BLOCKGROUP2000 SHP 44 EAn OMS 4 v ROUTE2000 SHP aes IL ka h S A sat ste teen usa dela A ing STOPS_OLD SHP LESSE STREET2000 SHP TRACT2000 SHP TRACTSO SHP E se E N ms e 7 BRR rs j oM sg ams E ence MapTips Map View Table View Ratio scale 1 27495 3777454 S8 206079 93 v Image Note When images displayed the vertical horizontal bars the window are not available 3 12 SECTION 3 FTGIS Change Feature Color at Mouse Cursor You can have the color of the feature at the mouse cursor change to a different color to highlight the feature To activate this function select the View Change Feature Color at Mouse Curs
108. y be re ordered by clicking the Sort button which allows you to sort the list by State NTD ID or transit agency name Select final systems by clicking the transit systems listed on the Systems list box Selected transit systems will be listed on the Selected systems list box To unselect a system Click the transit system name on the Systems list box or Highlight the transit system name in the Selected systems list box and then click the Delete button 2 19 SECTION 2 INTDAS Selecting Transit Systems by Query This option allows you to identify and select transit systems by constructing and executing a SQL Structured Query Language query It is best suited if you want to identify systems that fit a certain profile e g all Florida motorbus transit systems that operates less than 10 maximum service vehicles Figure 2 6 shows the interface for this option Figure 2 6 Screen Area for Constructing Query for Transit Systems Selection Select transit systems by groups Select states Select systems by system variables Select transit systems by query in keyword to find variables Get values max Reset 002 Weh Operated in Sere Under Contract E lt gt 002 Veh Operated in Serv Under Contract m eh E Ita amara Avalable for Mee Service 3 EET Query editor System State FL System State CA and System Mo
109. y forms by variable list or by pre defined variable groups The following sections describe each option in detail Selecting Variables by NTD Forms This option allows you to select the variables through the emulated NTD forms It 15 only available for the selection of the original NTD variables and is especially suitable if you are familiar with the NTD forms This option is accessible from the Enter Here button on the Original NTD tab shown in Figure 2 9 After the Enter Here button is clicked all the available NTD forms will be displayed one tab for each form Figure 2 10 shows the tab for Form 406 To select a variable Select the NTD form that contains the desired variable 2 Identify the variable from the form 2 24 SECTION 2 INTDAS 3 Click the check box for the variable Figure 2 10 shows that the following two variables are selected 1 checked total unlinked passenger trips and total passenger miles Figure 2 9 Screen Area for Entering NTD Forms for Variable Selection Original NTD Florida FSV User defined Groups Enter here to select variables bu standard NTO Forms type in keyword to Find Reset Select all Clear all 2001 FP Month Day 001 Fr ear 001 Company 001 Street 001 P ddress L itu 001 Address S tate 001 Zip Cade 001 URL Recinient I File Setup wiew Help
110. y the C drive SECTION 1 INTRODUCTION Figure 1 1 FTIS Main Menu a FTIS Main Menu E la x Florida Transit Information system version 2001 DEPARTMENT OF TRANSPORTATION Florida International University ol Help Problem Contact FT PLinks Installing FTIS Insert your FTIS CD and wait for a few seconds for the FTIS install to automatically start the FTIS setup program Follow the instructions on the screen to complete the installation The FTIS install includes the following three install options e Typical This option installs the complete FTIS system including all NTD GIS and aerial image data for all transit systems The aerial image data are included only for the following four transit systems Broward County Transit Miami Dade Transit Tallahassee Transit and Palm Beach County Transportation Authority This option requires a minimum of 1 3 GB of disk storage space e Minimum This option is similar to the Typical install except that it does not include the aerial image data This option requires a minimum of 800 MB of disk storage space 1 3 SECTION 1 INTRODUCTION e Custom This option lets you choose the transit systems for which you want to install the GIS and aerial image data This minimum required disk storage space ranges from 400 MB to 1 3 GB depending on the number of transit systems you selected Note f your computer is already installed with a version of FTIS
111. y the service area size in square miles another indicator of the availability of transit service within the service area Efficiency Measures e Operating Expense Per Capita Annual operating budget divided by the service area population a measure of the resource commitment to transit by the community e Operating Expense Per Peak Vehicle Total operating expense per vehicle operated in maximum service peak vehicle provides a measure of the resources required per vehicle to have a coach In operation for a year e Operating Expense Per Passenger Trip Operating expenditures divided by the total annual ridership a measure of the efficiency of transporting riders one of the key indicators of comparative performance of transit properties since it reflects both the efficiency with which service is delivered and the market demands for the service e Operating Expense Per Passenger Mile Operating expense divided by the number of passenger miles takes into account the impact of trip length on performance since some operators provide lengthy trips while others provide short trips e Operating Expense Per Revenue Mile Operating expense divided by the number of revenue miles of service a measure of the efficiency with which service 1s delivered and is another key comparative indicator e Operating Expense Per Revenue Hour Operating expense divided by revenue hours of operation a key comparative measure which differs from operating expense

Guide - Transportation Research Board

Contents

Download Pdf Manuals

Related Search

Related Contents