Mobile Data Terminals (2007)

Below is the uncorrected machine-read text of this chapter, intended to provide our own search engines and external engines with highly rich, chapter-representative searchable text of each book. Because it is UNCORRECTED material, please consider the following text as a useful but insufficient proxy for the authoritative book pages.

27 Section A1-1. Transit Use of Mobile Data Terminals Survey Instrument Worksheet: Long Form—Case Study Section A1-2. Transit Use of Mobile Data Terminals Survey Instrument Worksheet: Short Form—Standard Section A1-3. Mobile Data Terminals Synthesis Study On-Line Survey Maps Section A1-4. Mobile Data Terminal Relationship Database Structure Section A1-5. 2004 National Transit Database Relational Database Management System APPENDIX A1 Survey Instrument and Associated Database Documentation

28 SECTION A1-1 Transit Use of Mobile Data Terminals Survey Instrument Worksheet Long Form—Case Study A. Transit Agency (TA) Respondent Information 1. National Transit Database (NTD) ID (a.k.a. Trs_ID) [entering ID number fills in name below]. 2. Name of the agency: [If Trs_ID is unknown; pick NTD reporting entity by state, city, sort]. a. Acronym, if applicable from NTD: [filled in by file] b. Address of agency: i. City: [filled in by file] ii. State/province: [filled in by file] iii. State/province code: [filled in by file] iv. Country: [filled in by file] v. Country code: [filled in by file] vi. Zip/postal code: [filled in by file] c. Respondent: i. Contact name: ________________________________________________________________ ii. Contact title: _________________________________________________________________ iii. Contact phone: _______________________________________________________________ iv. Contact e-mail address: _________________________________________________________ B. Transit Service Using MDTs [Choose NTD Mode Code, as applicable:] 1. Motor bus (MB): Y/N? 2. Demand response (DR): Y/N? 3. Heavy rail (HR): Y/N? 4. Light rail (LR): Y/N? 5. Commuter rail (CR): Y/N? 6. Other(s): _______________ C. Types and Brand of Equipment Used 1. Manufacturer name: [Choose from list of MDT manufacturers]. a. Other: ____________________________ 2. Model name: [Choose from MDT model list. See Mobile Data Terminal Specifications File Structure and graphics of models for example]. 3. If other (1.a above), address of MDT manufacturer: a. Address 1: _____________________________________________________________________ b. Address 2: _____________________________________________________________________ c. City: __________________________________________________________________________ d. State/province: __________________________________________________________________ e. State/province code: _____________________________________________________________ f. Country: _______________________________________________________________________ g. Country code: __________________________________________________________________ h. Zip/postal code: _________________________________________________________________ i. Contact name: __________________________________________________________________ j. Contact phone: __________________________________________________________________ k. Contact e-mail address: ___________________________________________________________ l. Web address: ___________________________________________________________________ 4. How many MDT units are currently installed? ________ 5. How many MDT units will be installed within one year? ________ D. ITS Supplier Information 1. ITS supplier name [Choose from list of ITS suppliers]. a. Other: ______________________________________ 2. If other (1.a above), address of ITS supplier. a. Address 1: _____________________________________________________________________ b. Address 2: _____________________________________________________________________ c. City: __________________________________________________________________________ d. State/province: __________________________________________________________________ e. State/province code: _____________________________________________________________ f. Country: _______________________________________________________________________

29 i. Contact name: __________________________________________________________________ j. Contact phone: _________________________________________________________________ k. Contact e-mail address: ___________________________________________________________ l. Web address: ___________________________________________________________________ E. What Applications/Built-In Functionalities Are Supported by MDTs 1. MDT functions used (list below from assumes GPS integration and real-time communications): a. Fixed-route service: i. Down load manifest to vehicle: Y/N? ii. Driver sign-on: Y/N? 1. GPS date/time, latitude/longitude: Y/N? 2. Digital odometer reading: Y/N? iii. Start run (revenue service): Y/N? 1. GPS date/time, latitude/longitude: Y/N? 2. Digital odometer reading: Y/N? iv. End run (revenue service): Y/N? 1. GPS date/time, latitude/longitude: Y/N? 2. Digital odometer reading: Y/N? v. Driver sign-off 1. GPS date/time, latitude/longitude: Y/N? 2. Digital odometer reading: Y/N? vi. Fixed-route passenger counting 1. GPS date/time, latitude/longitude: Y/N? 2. Digital odometer reading: Y/N? 3. Passenger boarding a. Automatic: Y/N? If yes, i. Mechanical treadle: Y/N? ii. Break electronic beam: Y/N? b. If manual MDT entry of passengers: i. Single entry (1 per pax) ii. Multiple rider value (e.g., number of riders boarding at stop) 4. Passenger alighting a. Automatic: Y/N? If yes, i. Mechanical treadle: Y/N? ii. Break electronic beam: Y/N? b. Manual MDT entry: Y/N? i. Single entry (1 per pax) ii. Multiple rider value (number of riders boarding at stop) 5. Use of mobility aids: Y/N? If yes, a. GPS date/time, latitude/longitude: Y/N? b. Digital odometer reading: Y/N? 6. Loading bicycle on rack: Y/N? If yes, a. GPS date/time, latitude/longitude: Y/N? b. Digital odometer reading: Y/N? 7. Fixed-route fare collection: a. Automatic: Y/N? If yes, i. Magnetic stripe: Y/N? ii. Smart card: Y/N? iii. RF Proximity card: Y/N? iv. Combination of RF/stored value on card: Y/N? v. Other:____________ 8. Fixed-route emergency alarm: Y/N? If yes, a. GPS date/time, latitude/longitude: Y/N? b. Digital odometer reading: Y/N? c. Function key on MDC: Y/N? d. Covert alarm (e.g., foot treadle): Y/N? e. Communicates immediately to Transit Ops Center dispatch: Y/N? f. Communicates directly to local public safety: Y/N? g. Initiates video feed to: i. Transit operations center ii. Local public safety iii. Other: _____________ h. Video feed sends buffered images prior to alarm: Y/N? h. Zip/postal code: _________________________________________________________________ g. Country code: __________________________________________________________________

30 b. Paratransit service: i. Download daily manifest to vehicle: Y/N? ii. Updates schedule changes to/from MDT automatically: 1. Cancelled trips: Y/N? 2. No shows: Y/N? iii. Paratransit passenger counting 1. Passenger pick up: a. GPS date/time, latitude/longitude: Y/N? b. Digital odometer reading: Y/N? 2. Passenger drop off: a. GPS date/time, latitude/longitude GPS date/time, latitude/longitude: Y/N? b. Digital odometer reading: Y/N? 3. Driver sign-on a. GPS date/time, latitude/longitude: Y/N? b. Digital odometer reading: Y/N? 4. Start run (revenue service) a. GPS date/time, latitude/longitude: Y/N? b. Digital odometer reading: Y/N? 5. End run (revenue service) a. GPS date/time, latitude/longitude: Y/N? b. Digital odometer reading: Y/N? 6. Driver sign-off a. GPS date/time, latitude/longitude: Y/N? b. Digital odometer reading: Y/N? 7. Use of mobility aids: a. GPS date/time, latitude/longitude: Y/N? b. Digital odometer reading: Y/N? c. Wheel chair: Y/N? d. Walker: Y/N? e. Service animal: Y/N? f. Other: ____________________ F. Communications Infrastructure 1. How does the MDT communicate with the Operations Center? a. Conventional Private Radio Network: (e.g., 450 MHz) b. Public Data Networks (e.g., cellular) i. Verizon Wireless: Y/N? ii. Cingular (GSM/GPRS): Y/N? iii. Sprint/Nextel (iDEN): Y/N? iv. T-Mobile: Y/N? v. Other: _____________________ c. WiFi or Wireless Local Area Network (IEEE 802.11 a/b/g) i. 2.4 GHz unrestricted (IEEE 802.11 b/g): Y/N? ii. 5.0 GHz unrestricted (IEEE 802.11 a): Y/N? iii. 5.0 GHz restricted public safety (4.9) or ITS DSRC (5.9): Y/N? d. WiMAX (IEEE 802.20): Y/N? e. Integrated WiFi and WiMAX: Y/N? 2. Types of information communicated to MDTs versus other means? a. Communication of data files from scheduling software to individual vehicles: Y/N? b. Polling of GPS data (NMEA GPS string) from individual vehicles: Y/N? If yes, refresh rate of (choose one) i. 1–5 seconds ii. 6–10 seconds iii. 10–60 seconds iv. 60–120 seconds v. 2–5 minutes vi. 6 or more minutes c. Communication of video to or from vehicle, through MDT: Y/N? d. Communication of canned text messages from dispatch to vehicle: Y/N? e. Communication of canned text messages from vehicle to dispatch: Y/N? f. Communication of canned text messages from vehicle to vehicle in fleet: Y/N? g. Communication of free formed text messages from dispatch to vehicle: Y/N? h. Communication of free formed text messages from vehicle to dispatch: Y/N?

31 i. Communication of free formed text messages from vehicle to vehicle in fleet: Y/N? j. Is two-way mobile radio voice communications also available to the driver: Y/N? k. Other communication? G. Information Technology Supporting the MDT 1. What operating system is being run where the MDT database resides? a. MSDOS b. MS Windows Server 2000 c. MS Windows Server 2003 d. MS Windows XP e. MS Windows XP Professional f. Apple OS g. Linux h. Unix i. Sun SPARC OS j. Other 2. What database technology is supporting the MDT deployment? a. Microsoft SQL Server 2000 b. Microsoft SQL Server 2003 c. Microsoft SQL Server 2005 d. Oracle RDBMS e. MS Access f. MS Excel g. Other ______________________ H. Applications of MDT-Collected Data 1. What are current applications of MDT-collected data? a. Driver time keeping b. Route and schedule adherence i. Fixed-route service on-time performance: Y/N? ii. Paratransit on-time performance: Y/N? c. Fraud prevention and detection i. Time fraud by staff or contractors: Y/N? ii. Fare fraud by staff or contractors: Y/N? iii. Third-party payment fraud by human service clients: Y/N? d. Real-time web mapping of automatic vehicle location data: Y/N? e. Dynamic calculation of estimated time of arrival (ETA) by vehicle i. At bus terminals: Y/N? ii. At bus stops: Y/N? iii. On-board the bus: Y/N? iv. Display of ETA on web: Y/N? f. Quality assurance/quality control (QA/QC) of service [verification of approved service configuration/fraud prevention] i. Fixed-route service: Y/N? ii. Paratransit service: Y/N? g. Alarming for preventive maintenance scheduling based on automatic odometer reading: Y/N? h. Verification of performance of scheduled maintenance and repair: Y/N? i. Aggregation of fueling and consumable supplies by vehicle and driver to verify operations performance and detect fraud and abuse: Y/N? j. Calculation of periodic performance measures based on MDT data collection: i. Passengers carried: Y/N? ii. Revenue received: Y/N? iii. Passenger miles: Y/N? iv. Revenue miles: Y/N? v. Passengers per vehicle mile: Y/N? vi. Passengers per revenue mile: Y/N? vii. Passengers per vehicle hour: Y/N? viii. Passengers per revenue mile: Y/N? ix. Mean time between failures (equipment breakdown): Y/N? x. Mean miles between failures (equipment breakdown): Y/N? xi. Other: _______________________________________________________________

32 2. How are these applications integrated? a. Integrated data collection device (hardware) on vehicle: Y/N? (e.g., GPS temporal and spatial stamp sent with data record). b. Integrated data files through relational database on central server (software): Y/N? [e.g., data integrated through linking key fields—VID, latitude/longitude, GPS date/time] c. Manually integrated through spreadsheet analysis: Y/N? d. Not integrated: Y/N? I. Installation, Maintenance, and Data Analysis Costs 1. Costs to install and maintain MDTs a. What was the unit cost of the MDT for your most recent deployment? _______ b. What was the unit cost of installation of the MDT for your most recent deployment? ________ c. How many labor hours were expended to install an individual MDT for your most recent deployment? ____________ d. What is the average annual unit cost to maintain/repair an individual MDT for your deployment? _____________ e. What are the average annual labor hours to maintain/repair an individual MDT for your deployment? _______________ 2. Staffing requirements to maintain the equipment and utilize the data a. Does the TA provide the information technology and communications infrastructure for the MDT deployment: Y/N? i. If yes, what is the annual personnel cost dedicated to IT and communications? _________________________________________________________________ ii. If no, how is the IT and communications provided? _______________________ b. Are there transit staff dedicated to the analysis and reporting of data collected by the MDTs: Y/N? iii. If yes, what is the annual personnel cost for analysis and reporting? ___________ iv. If yes, what are the annual labor hours for analysis and reporting? _____________ v. If no, how is analysis and reporting accomplished? ________________________ __________________________________________________________________ J. Staffing Acceptance 1. How would you rate the acceptance of staff to the deployment of MDTs (choose range 1–5, where 5 is greatest acceptance)? a. Executive staff: 1 2 3 4 5 b. Administrative/clerical staff: 1 2 3 4 5 c. Operations supervisory staff: 1 2 3 4 5 d. Drivers: 1 2 3 4 5 e. Maintenance staff: 1 2 3 4 5 K. Operational/Technical Problems Encountered and Solutions 1. What types of problems were encountered: a. MDT equipment design flaws: Y/N? b. MDT equipment manufacturing defects: Y/N? c. MDT installation problems: Y/N? d. MDT reliability in operating environment: Y/N? e. MDT driver training problems: Y/N? f. MDT installer/maintainer training problems: Y/N? g. MDT manufacturer/vendor warranty compliance: Y/N? h. MDT communications infrastructure problems: Y/N? i. MDT sabotage: Y/N? j. Other: __________________ 2. If yes to above, what solutions were developed to the above problems? a. MDT equipment design flaws ___________________________________________________________________ _______________________________________________________________________________________________ b. MDT equipment manufacturing defects___________________________________________________________ _______________________________________________________________________________________________ c. MDT installation problems_____________________________________________________________________ _______________________________________________________________________________________________ _______________________________________________________________________________________________ d. MDT reliability in operating environment__________________________________________________________

33 e. MDT driver training problems___________________________________________________________________ _______________________________________________________________________________________________ f. MDT installer/maintainer training problems ________________________________________________________ _______________________________________________________________________________________________ g. MDT manufacturer/vendor warranty compliance____________________________________________________ _______________________________________________________________________________________________ h. MDT communications infrastructure problems______________________________________________________ _______________________________________________________________________________________________ i. MDT sabotage_______________________________________________________________________________ _______________________________________________________________________________________________ j. Other: ______________________________________________________________________________________ _______________________________________________________________________________________________ L. Security and Resilience of Communications (after disruption) 1. Do you have security measures in place for the communications system supporting the MDT? a. Secure base station: Y/N? b. Secure radio tower(s): Y/N? c. Secure auxiliary power generation for a and b above: Y/N? d. Encryption and decryption of data radio transmission: Y/N? e. Secure storage of mobile equipment, when not in service: Y/N? 2. Do you have resilience built into the design of the communication system? a. Mobile to mobile transmission when base station and/or central tower is/are down: Y/N? b. Self-healing autonomous mesh networks for radio communications (e.g., multi-hop transmission and Internet communications protocols): Y/N? c. Cooperative agreements with surrounding jurisdictions with duplicate communications systems in-place that can temporarily replace central dispatch functionality: Y/N? M. MDT Uses Desired Beyond the Capabilities of the Existing Equipment 1. What additional functions are desired beyond current capabilities? ________________________________________________________________________________________________ ________________________________________________________________________________________________ ________________________________________________________________________________________________ ________________________________________________________________________________________________ ________________________________________________________________________________________________ N. Future Applications and Technologies 1. What additional technology applications are you planning to deploy? ________________________________________________________________________________________________ ________________________________________________________________________________________________ ________________________________________________________________________________________________ ________________________________________________________________________________________________ ________________________________________________________________________________________________

34 SECTION A1-2 Transit Use of Mobile Data Terminals Survey Instrument Worksheet Short Form—Standard A. Transit Agency (TA) Respondent Information 1. National Transit Database (NTD) ID (a.k.a Trs_ID) [entering ID number fills in name below]. 2. Name of the agency: [If Trs_ID is unknown, pick NTD reporting entity by state, city, sort]. a. Acronym, if available from NTD: [filled in by file] b. Address of agency: i. City [filled in by file] ii. State/province code: [filled in by file] iii. Country: [filled in by file] iv. Country code: [filled in by file] v. Zip/postal code: [filled in by file] c. Respondent i. Contact name: ______________________________________________________________ ii. Contact title: _______________________________________________________________ iii. Contact phone: _____________________________________________________________ iv. Contact e-mail address: _______________________________________________________ B. Transit Service Using MDTs [Choose NTD Mode Code, as applicable:] 1. Motor bus (MB): Y/N? 2. Demand response (DR): Y/N? 3. Heavy rail (HR): Y/N? 4. Light rail (LR): Y/N? 5. Commuter rail (CR): Y/N? 6. Other(s): _________________________ C. Types and Brand of Equipment Used 1. Manufacturer name: [Choose from list of MDT manufacturers]. a. Other __________________________________________ 2. Model name: [Choose from MDT Model list. See Mobile Data Terminal Specifications File Structure and graphics of models for example]. 3. If other (1.a above), address of MDT manufacturer: a. Address 1: _____________________________________________________________________ b. Address 2: _____________________________________________________________________ c. City: __________________________________________________________________________ d. State/province: __________________________________________________________________ e. State/province code: _____________________________________________________________ f. Country: _______________________________________________________________________ g. Country code: __________________________________________________________________ h. Zip/postal code: _________________________________________________________________ i. Contact name: __________________________________________________________________ j. Contact phone: __________________________________________________________________ k. Contact e-mail address: ___________________________________________________________ l. Web address: ___________________________________________________________________ 4. How many MDT units are currently installed? ____________ 5. How many MDT units will be installed within one year? ____________ D. ITS Supplier Information 1. ITS supplier name [Choose from list of ITS suppliers]. a. Other: ______________________________________ 2. If other (1.a above), address of ITS supplier. a. Address 1: _____________________________________________________________________ b. Address 2: _____________________________________________________________________ c. City: __________________________________________________________________________ d. State/province: __________________________________________________________________ e. State/province code: _____________________________________________________________ f. Country: _______________________________________________________________________

35 h. Zip/postal code: ________________________________________________________________________ i. Contact name: _________________________________________________________________________ j. Contact phone: ________________________________________________________________________ k. Contact e-mail address: __________________________________________________________________ l. Web address: __________________________________________________________________________ F. Communications Infrastructure 1. How does the MDT communicate with the Operations Center? a. Conventional Private Radio Network: (e.g., 450 MHz) b. Public Data Networks (e.g., cellular) i. Verizon Wireless: Y/N? ii. Cingular (GSM/GPRS): Y/N? iii. Sprint/Nextel (iDEN): Y/N? iv. T-Mobile: Y/N? v. Other: ______________________________________ c. WiFi or Wireless Local Area Network (IEEE 802.11 a/b/g) i. 2.4 GHz unrestricted (IEEE 802.11 b/g): Y/N? ii. 5.0 GHz unrestricted (IEEE 802.11 a): Y/N? iii. 5.0 GHz restricted public safety (4.9) or ITS DSRC (5.9): Y/N? d. WiMAX (IEEE 802.20): Y/N? e. Integrated WiFi and WiMAX: Y/N? 2. Types of information communicated to MDTs versus other means? a. Communication of data files from scheduling software to individual vehicles: Y/N? b. Polling of GPS data (NMEA GPS string) from individual vehicles: Y/N? If yes, refresh rate of (chose one) i. 1–5 seconds ii. 6–10 seconds iii. 11–60 seconds iv. 61–120 seconds v. 2–5 minutes vi. 6 or more minutes c. Communication of video to or from vehicle, through MDT: Y/N? d. Communication of canned text messages from dispatch to vehicle: Y/N? e. Communication of canned text messages from vehicle to dispatch: Y/N? f. Communication of canned text messages from vehicle to vehicle in fleet: Y/N? g. Communication of free formed text messages from dispatch to vehicle: Y/N? h. Communication of free formed text messages from vehicle to dispatch: Y/N? i. Communication of free formed text messages from vehicle to vehicle in fleet: Y/N? j. Is two-way mobile radio voice communications also available to the driver: Y/N? k. Other communication? H. Applications of MDT-Collected Data 1. What are current applications of MDT-collected data? a. Driver time keeping b. Route and schedule adherence i. Fixed-route service on-time performance: Y/N? ii. Paratransit on-time performance: Y/N? c. Fraud prevention and detection i. Time fraud by staff or contractors: Y/N? ii. Fare fraud by staff or contractors: Y/N? iii. Third-party payment fraud by human service clients: Y/N? d. Real-time web mapping of automatic vehicle location data: Y/N? e. Dynamic calculation of estimated time of arrival (ETA) by vehicle i. At bus terminals: Y/N? ii. At bus stops: Y/N? iii. On-board the bus: Y/N? iv. Display of ETA on web: Y/N? f. Quality assurance/quality control (QA/QC) of service [verification of approved service configuration/fraud prevention] i. Fixed-route service: Y/N? ii. Paratransit service: Y/N? g. Alarming for preventive maintenance scheduling based on automatic odometer reading: Y/N? g. Country code: _________________________________________________________________________

36 h. Verification of performance of scheduled maintenance and repair: Y/N? i. Aggregation of fueling and consumable supplies by vehicle and driver to verify operations performance and detect fraud and abuse: Y/N? j. Calculation of periodic performance measures based on MDT data collection: i. Passengers carried: Y/N? ii. Revenue received: Y/N? iii. Passenger miles: Y/N? iv. Revenue miles: Y/N? v. Passengers per vehicle mile: Y/N? vi. Passengers per revenue mile: Y/N? vii. Passengers per vehicle hour: Y/N? viii. Passengers per revenue mile: Y/N? ix. Mean time between failures (equipment breakdown): Y/N? x. Mean miles between failures (equipment breakdown): Y/N? xi. Other: ______________________________________________________________ M. MDT Uses Desired Beyond the Capabilities of the Existing Equipment 1. What additional functions are desired beyond current capabilities? ________________________________________________________________________________________________ ________________________________________________________________________________________________ ________________________________________________________________________________________________ ________________________________________________________________________________________________ N. Future Applications and Technologies 1. What additional technology applications are you planning to deploy? ____________________________________________________________________________________________________ ____________________________________________________________________________________________________ ____________________________________________________________________________________________________ ____________________________________________________________________________________________________

37 SECTION A1-3 Mobile Data Terminals Synthesis Study On-Line Survey Maps

38 Enter MDT Survey web site Exit Survey .pdf display of Trs_ID and Agency Name by state and city Do you need to find your FTA NTD Trs_ID Number? Do you want to be included as a national case study on MDTs? Download long form survey and gather information for on-line survey Download short form and gather information for on-line survey Enter on-line survey (click short form link) Do you want to be included in the synthesis study on MDTs? 2 Enter on-line survey (click on long form link) 1 Y N N Y Do you need to find your FTA NTD Trs_ID Number? Y N Y N TCRP J-7 SC-08 Mobile Data Terminals Synthesis Study On-Line Survey Map

39 1 Transit Service Using MDTs Exit Survey Transit Agency (TA) Respondent Information MDT Types and Brands of Equipment Used ITS Supplier Information MDT Functionality Communications Infrastructure Supporting MDT Information Technology Supporting MDT Applications of MDT Collected Data Installation, Maintenance and Data Analysis Costs MDT acceptance by Staff MDT Problems and Solutions Security and Resilience of Communications MDT capabilities desired in future Future ITS applications at TA Pictures of MDT Models MDT Manufacturer DB Add Mfgr Web Display of ITS List ITS Supplier DB Add Splr Display Respondents List and Charts Update on-line survey DB TCRP J-7 SC-08 Mobile Data Terminals Synthesis Study On-Line Survey Map – Case Study (long form) Option

40 2 Transit Agency (TA) Respondent Information Transit Service Using MDTs MDT Types and Brands of Equipment Used Pictures of MDT Models MDT Manufacturer DB Add Mfgr ITS Supplier Information Web Display of ITS List ITS Supplier DB Add Splr MDT Functionality Communications Infrastructure Supporting MDT Applications of MDT Collected Data MDT capabilities desired in future Future ITS applications at TA Exit Survey Display Respondents List and Charts Update on-line survey DB TCRP J-7 SC-08 Mobile Data Terminals Synthesis Study On-Line Survey Map – Standard (short form) Option

41 SECTION A1-4 Mobile Data Terminal Relationship Database Structure

MDT Manufacturer - Contact Information Mobile Data Terminal Specifications Information ITS Prod/Srvc Information Mobile Data Terminal Relational Database Structure Transit Agency Survey Information MDT Mfg Rec ID MDT Mfg ID MDT Mfgr Name MDT Mfg Address 1 MDT Mfg Address 2 MDT Mfg Address 3 MDT Mfg City MDT Mfg State/Prov MDT Mfg Mail Code MDT Mfg Country MDT Mfg Phone MDT Mfg Fax MDT Mfg e-mail MDT Mfg contact name MDT Mfg contact e-mail MDT Mfg web site Edit Date ITS Splr Rec ID ITS Splr ID ITS Splr Name ITS Splr Address 1 ITS Splr Address 2 ITS Splr Address 3 ITS Splr City ITS Splr State/Prov ITS Splr Mail Code ITS Splr Country ITS Splr Phone ITS Splr Fax ITS Splr e-mail ITS Splr contact name ITS Splr contact e-mail ITS Splr web site Edit Date ITS Supplier Contact Information Description MDT Spec Rec ID MDT Mfg ID MDT Model Name MDT Model ID Dim L-H-D Weight Enclosure Processor ProcsrMfgr ProcSpd OS Display Dsply ype Dsply Res Dsply cq Keyboard-input Kbrd Y/N Num Y/N Alpha Y/N Fnctn Y/N Tch Scrn Mag Card Smt Card Interfaces No RS-232C bse No CF slots bse No USB prts bse No Opt RS-232C No of Opt CF No of Op USB Base memory SDRAM bse Flash bse BatteryRAM Expanded memory SDRAM expnd Flash expnd BatteryRAM (KB) Audio Audio out Y/N Audio in Y/N GPS Channels GPS-8 GPS-12 GPS-1 GPS-20 Internal radio modem RM 4800 bps RM 9600 bps Comm_MRI T/B/D Cellular public data modem GPRS Eu GSM/GPRS-CDMA-iDEN T/B/D Mobile power supply Volts 900/1800/1900 MHz GSM/ Amps Portable power supply Re Ni-MH Re Li-Poly T/B/D Ops Environment Min ops temp Max ops temp Min RH Max RH Edit Date Transit Agency Contact Information TA RecID Title FNAME MI LNAME JOBTYPE POSITION NAME TRANSIT AGENCY TA BRAND DEPARTMENT ADDRESS1 ADDRESS2 ADDRESS3 CITY STATE ZIPCODE ZIP4 COUNTRY PHONE FAXPHONE EMAIL1 EMAIL2 Responses to short form Temp file Responses to long form Temp file Consolidated survey responses Description ITS Prod-Srvc ID ITS Splr ID ITS Prod-Srvc Name ITS Prod-SrceType ITS Prod-Srvc Dscrptn Edit Date RDBMS Functions (MS ACCESS 2003) Table Design QueriesInput Forms Standard Reports WEBSITE EntityTYPE VENCODE NTD# FTA REGION KEYWORDS ORGSIZE MODE CODE FUND CODE #FR BUSES #DR VEH #RAILCARS UZACODE ?MDT Y/N ?AVL Y/N ?APC Y/N ?EPS Y/N ?GIS Y/N ?Other tech Y/N COMMENT1 COMMENT2 Edit Date 1 2

43 1 4-25-06 Shrt [Short Form Responses] Description Transit Agency (TA) Respondent Information ID TrsID Contact_FName Contact_Lname Contact_Email Contact_Phone Transit Service Using MDTs MDT_InUse MDT_InUse_Other Types and brand of equipment used MDT_Num_Now MDT_Num_Future MDT_Model MDT_Other_Manuf MDT_Other_Model MDT_Other_Addr1 MDT_Other_Addr2 MDT_Other_City MDT_Other_State MDT_Other_Zip MDT_Other_Country MDT_Other_URL MDT_Other_Contact MDT_Other_Phone ITS Supplier Information ITS_Supp ITS_Other_Supp ITS_Other_Service ITS_Other_Addr1 ITS_Other_Addr2 ITS_Other_City ITS_Other_State ITS_Other_Zip ITS_Other_Country ITS_Other_URL ITS_Other_Contact ITS_Other_Phone Communications Infrastructure Comm_Radio Comm_Radio_Other Comm_CDF Comm_GPS Comm_Video Comm_CTM Comm_FTM Comm_Types_Other Comm_2Way Applications of MDT Collected Data App_DTK App_RSA App_FPD App_AVL App_ETA App_QA/QC App_APM App_VPM App_AFC App_CPP App_Other MDT Capabilities Desired in Future Other_Functions Future ITS Applications at TA Future_Tech

44 2 4-25-06 Lng [Long Form Responses] Description Transit Agency (TA) Respondent Information ID TrsID Contact_FName Contact_Lname Contact_Email Contact_Phone Transit Service Using MDTs MDT_InUse MDT_InUse_Other Types and brand of equipment used MDT_Num_Now MDT_Num_Future MDT_Model MDT_Other_Manuf MDT_Other_Model MDT_Other_Addr1 MDT_Other_Addr2 MDT_Other_City MDT_Other_State MDT_Other_Zip MDT_Other_Country MDT_Other_URL MDT_Other_Contact MDT_Other_Phone ITS Supplier Information ITS_Supp ITS_Other_Supp ITS_Other_Service ITS_Other_Addr1 ITS_Other_Addr2 ITS_Other_City ITS_Other_State ITS_Other_Zip ITS_Other_Country ITS_Other_URL ITS_Other_Contact ITS_Other_Phone MDT Functionality Func_Fixed_General Func_Fixed_Counting Func_Fixed_OtherCounting Func_Fixed_Fares Func_Fixed_FaresOther Func_Fixed_Emer Func_Fixed_Features Func_Fixed_Other Func_Para_General Func_Para_Counting Func_Para_Other Communications Infrastructure Comm_Radio Comm_Radio_Other Comm_CDF Comm_GPS Comm_Video Comm_CTM Comm_FTM Comm_Types_Other Comm_2Way Information Technology Supporting MDT Tech_OS Tech_DB Tech_Other Description cont’d Applications of MDT Collected Data App_DTK App_RSA App_FPD App_AVL App_ETA App_QA/QC App_APM App_VPM App_AFC App_CPP App_Other Integration of Applications App_Integrated Installation, Maintenance and Data Analysis Costs App_UnitCost App_InstallCost App_HoursPerMDT App_CostRepair App_LaborHours OpTech_TASupported OpTech_TASupportedComment OpTech_TAStaff OpTech_TAStaffComment Staff Acceptance Acceptance_Exec Acceptance_Admin Acceptance_Ops Acceptance_Drivers Acceptance_Maint Operational/Technical Problems and Solutions OpTech_Problems OpTech_ProblemsOther OpTech_Solutions Security and Resilience of Communications Security_Measures Security Resilience MDT Capabilities Desired in Future Other_Functions Future ITS Applications at TA Future_Tech

45 SECTION A1-5 2004 National Transit Database Relational Database Management System

2004 National Transit Database (NTD) Relational Database Management System Agency_Info Service(Annual Totals only) Operating_Expenses Agency_Mode_ Service Agency_UZAs Transit_Way_ Mileage Transit_Station Rec ID Trs_ID Agency_Type_Desc Institution_Type_Desc Organization_Type_Desc Fy_Month_Num Fy_Day_Num Fy_Year_Num Company_Nm Street1_Nm Street2_Nm City_Nm State_Desc Zip_Cd Zip_4_Cd Url_Cd Ftavc_Cd Logo_Cd ServIce_Area Service_Area_Population Waiver_Q_Req_Fl Non_Uza Veh_Operated_Comment Institutional_Structure_Desc Other_Url_Cd Po_Box Other_Cap_Use_Comment_Desc Other_Option_B_Comment_Desc Voluntary_Reporter_Fl [Longitude added] [Latitude added] Rec ID Trs_ID Mode_CD Service_CD Time_Period_Desc …. Vehicles_in_Operation Passenger_Cars Vehicle_or_Train_Miles Vehicle_or_Train_Hours Vehicle_or_Train_Revenue_Miles Vehicle_or_Train_Revenue_Hours Passenger_Car_Miles Passenger_Car_Rev_Miles Passenger_Car_Sched_Rev_Miles Passenger_Car_Hours Passenger_Car_Revenue_Hours Vehicle_Sched_Miles Charter_Servie_Hours [sic.] School_Bus_Hours Unlinked_Passenger_Trips Passenger_Miles Operated_Num Days_Operated Strikes Declared_Emergencies ADA_Unlinked_passenger_trips Rec ID Trs_ID mode_cd service_cd expense_category_desc op_sal_wage_amt other_sal_wage_amt fringe_benefi-amt Service_costs-amt fuel_lubricant-amt utility-amt casuality_liabiliy_amt [sic.] tax_amt in_report_amt sep_report_am misc_expense_amt expense_transfer_amt ada_related_amt Totl_ops_expense [calc field] Rec ID Trs_ID mode_cd service_cd vehicles_operated_max_service vehicles_available_max_service option_b_only_fl capital_use_only_fl delete_fl Rec ID Trs_ID Mode_cd Service_cd Ada_Accessible_Station_Cnt Non_Ada_Accessible_Station_Cnt Elevator_Cnt Escalator_Cnt Multi_Mode_Cnt Rec ID Trs_ID Mode_Cd Service_Cd Rail_Grade_Excl_Row_Num Rail_Grade_X_Traffic_Num Rail_X_Traffic_Crossing_Num Rail_Grade_Mixed_Num Rail_Mixed_Crossing_Num Rail_Elevated_Structure_Num Rail_Elevated_Fill_Num Rail_Open_Cut_Num Rail_Subway_Num Non_Rail_Controlled_Row_Num Mixed_Row_Num Rec ID Trs_ID UZA_Name UZA_Code Primary Transit_GIS_Route Spatial Database Transit_GIS_Station_Stops Spatial Database Trs_ID Mode_CD GIS Node DB [lat/long] GIS Line DB [arc data] …… [attribute data] Source Data Date of collection Trs_ID Mode_Code GIS Point DB [lat/long] …..[attribute data] Source data Date of collection Transit_GIS_Service Area Spatial Database Trs_ID Mode_CD GIS Node DB [lat/long] GIS Area DB [polygon] Source Data Date of collection Georeferenced digital orthophotos TA Contact DB Associated GeoGraphics Lab Databases