System Design Document Template

1 Atlanta Regional Commission MSAA System Design Document 09/30/2017 Document Number: Federal Award ID Number: GA-26-0008-01 System Design Document Table of Contents SDD Version ii ARC SGT SDD> Table of Contents 1. Introduction .. 6 Purpose of the SDD .. 7 Audience .. 8 Executive Summary .. 8 System Overview Summary .. 8 Design Constraints .. 10 Future Contingencies .. 10 Document Organization .. 11 2. General Overview and Design Guidelines/Approach .. 12 General Overview .. 12 Current .. 12 Proposed Solution - Statement of Need.

2 13 Stakeholder Roles/Responsibilities/Concerns .. 13 Roles .. 14 Responsibilities .. 15 Concerns .. 18 System Assumptions/Constraints/Dependencies/Ris ks .. 18 Assumptions .. 18 Constraints .. 18 Dependencies .. 18 Risks .. 18 Alignment with National/Regional ITS Architectures .. 18 3. Design Considerations .. 18 Goals and Guidelines .. 19 Operational Environment .. 19 Development Methods & Contingencies .. 20 Architectural Strategies .. 20 Performance Engineering .. 23 4. System Architecture and Architecture Design .. 24 System Architecture 24 External Systems diagram.

3 24 Functional/Logical diagram .. 24 Hardware Architecture .. 25 Security Hardware Architecture .. 28 Performance Hardware Architecture .. 28 Software Architecture .. 29 Software Elements .. 30 Security Software Architecture .. 31 Performance Software Architecture .. 32 Information Architecture .. 33 System Design Document Table of Contents SDD Version iii ARC SGT SDD> Records Management .. 34 Internal Communications Architecture .. 35 Security Architecture .. 35 Performance .. 35 5. System Design .. 36 Business Requirements .. 36 Priorities.

4 Error! Bookmark not defined. Database Design .. 37 Data Objects and Resultant Data Structures .. 37 File and Database Structures .. 45 Data Conversion .. 47 User Machine-Readable Interface .. 47 Inputs .. 47 Outputs .. 47 User Interface Design .. 47 Section 508 Compliance .. 48 6. Operational Scenarios .. 49 Major Operational Scenarios .. 49 Major Use Cases .. 50 Customer Resources .. 50 Vehicle Resources .. 55 Driver Resource .. 58 Reservations .. 60 Scheduling .. 63 Dispatch .. 66 Analytics .. 69 7. Detailed Design .. 72 Hardware Detailed Design .

5 72 Software Detailed Design .. 72 Security Detailed Design .. 73 Performance Detailed Design .. 74 Internal Communications Detailed Design .. 74 8. System Integrity Controls .. 75 9. External Interfaces .. 76 ATL Transit .. 76 Google Maps .. 76 76 Rideshare .. 76 Taxi Fare 76 Transportation Network Companies (TNC) .. 77 System Design Document List of Figures SDD Version iv ARC SGT SDD> GTFS Real Time .. 77 GTFS Flex .. 77 Emerging Business Models .. 77 Third Party Commercial Application Integration .. 77 Transportation Clearinghouse.

6 78 Adapter API .. 78 Points of Interest .. 78 Public Transit .. 78 GTFS .. 79 Agencies .. 79 Specialized Service Providers .. 79 Providers .. 79 Services .. 80 Geocoding .. 80 Maps .. 81 Google Street View .. 82 Interface Architecture .. 82 Interface Detailed Design .. 82 10. Appendix A: Record of Changes .. 85 List of Figures Figure 1: SGT Roles .. 15 Figure 3: Amazon Web Services model .. 21 Figure 4: External systems diagram .. 24 Figure 5: Hardware architecture .. 25 Figure 6: Security architecture .. 28 Figure 7: Software architecture 29 Figure 8: SGT high level architecture.

7 30 Figure 9: Security authentication .. 32 Figure 9: Performance architecture scalability .. 33 Figure 11: Example of a database Design .. 37 Figure 12: Example of balsamiq mockup .. 48 Figure 13: Example of web application hosting .. 72 Figure 14: Security detail Design .. 74 System Design Document List of Tables SDD Version v ARC SGT SDD> Figure 14: Sample uber API responses .. 77 List of Tables Table 1: Project members contact information .. 14 Table 2: System Design roles .. 15 Table 3: Software descriptions .. 23 Table 4: Systems descriptions .. 25 Table 5: Server requirements.

8 27 Table 6: Software elements and descriptions .. 30 Table 7: SGT future enhancements .. 36 Table 8: Data objects and schemas .. 37 Table 9: Major operational scenarios .. 49 Table 10: Customer use cases .. 50 Table 11: Vehicle use cases .. 55 Table 12: Driver resource use cases .. 58 Table 13: Reservation use cases .. 60 Table 14: Schedule use cases .. 64 Table 15: Dispatch use cases .. 67 Table 16: Report use cases .. 70 Table 17: 1-Click Points of Interest File Format .. 78 Table 18: Public Transit Agency Attributes .. 79 Table 19 - Specialized Services Provider Attributes.

9 79 Table 20: Provider Services 80 Table 21: Map API pros & cons .. 81 Table 22: Record of changes .. 85 Page 6 System Design Document SDD Version 6 ARC SGT SDD> 1. Introduction ARC serves as the Metropolitan Planning Organization (MPO), the Area Agency on Aging (AAA) serving as the Aging and Disability Resource Center (ADRC), the Workforce Board (for a 7-county area) and the Regional Transit Committee (RTC). This structure facilitated collaboration between the AAA and the MPO regarding the need to increase transportation access for older adults and persons with disabilities and the development of the region s first Human Services Transportation (HST) Plan.

10 In 2008, ARC successfully administered the Federal Transit Administration s (FTA) Mobility Services for All Americans (MSAA) grant for a feasibility study for the Atlanta Regional Transportation Management Coordination Center (TMCC). Findings from the 2008 TMCC study supported the development of an HST Advisory Committee and an update of the HST Plan to facilitate greater coordination of HST transportation services throughout the region. Many Americans have difficulty accessing some of their basic needs, particularly seniors, persons with disabilities and the economically disadvantaged, because they must rely on human service transportation systems which are often fragmented, unreliable, and inefficiently operated.