BUS STOP MANAGEMENT Washington Metropolitan Area Transit Authority

PRESENTER SAKSHI MEHTA SENIOR GIS ANALYST WASHINGTON METROPOLITAN AREA TRANSIT AUTHORITY EDUCATION- M. S. IN GIS AND TRANSPORTATION PLANNING PAST EXPERIENCE- GIS DATABASE CONSULTANT, WISCONSIN DEPARTMENT OF TRANSPORTATION (4 YEARS) Washington Metropolitan Area Transit Authority

INTRODUCTION- AGENCY • MULTI-JURISDICTIONAL AGENCY, 1500 SQUARE MILE SERVICE AREA • METRORAIL (RAPID TRANSIT SERVICE) 106 MILES OF TRACK, 86 STATIONS, 1116 RAIL CARS • METROBUS (FIXED-ROUTE BUS SERVICE) §FLEET OF NEARLY 1500 BUSES §MORE THAN 11500 BUS STOPS • METROACCESS (PARATRANSIT SERVICE) § 1. 7 MILLION TRIPS PER YEAR SOURCE Washington Metropolitan Area Transit Authority

CHALLENGES IN BUS STOP DATA MANAGEMENT Asset & Accessibility Data Service Status Data • MULTIPLE LEGACY DATA SOURCES a. DATA MISMATCH / RECORD COUNT DISCREPANCY b. MINIMAL DATA QUALILTY CONTROL c. DATA REDUNDANCY / DUPLICATION d. NON STANDARD / INCONSISTENT VERBIAGE e. WHAT IS A BUS STOP? ? – DEFINITION • DIFFERING (BUSINESS AND FUNDING) PRIORITIES Service Related • WMATA’S SCALE OF OPERATIONS- RIPPLE EFFECT Announce ment Data Washington Metropolitan Area Transit Authority

CHALLENGES IN BUS STOP DATA MANAGEMENT (Cont’d) Asset & Accessibility Data Service Status Data Service Related Announce ment Data Washington Metropolitan Area Transit Authority

NEEDS ASSESMENT IDENTIFY A SINGLE COMPREHENSIVE DATA MANAGEMENT SOLUTION WITH DUAL CAPABILITY LEGACY DATA INTEGRATION FUTURE / ONGOING DATA MANAGEMENT • INTEGRATE THE LEGACY DATA SETS • PROCESS / MANAGE NEW DATA • ADOPT SUSTAINABLE QUALITY CONTROL METHODS • ELIMINATE DATA REDUNDANCY • OPTIMIZE HANDLING OF CRITICAL DATA PROPER GOVERNANCE PROCESS (WHO DOES WHAT) Washington Metropolitan Area Transit Authority

OUR SOLUTION WMATA GIS ENTERPRISE DATABASE FOR BUS STOP MANAGEMENT DATA MODEL BACKEND (DATA MANAGEMENT) • ADVANCED DATA MODEL DESIGN • IN BUILT CONTRAINTS FOR DATA ERROR FILERTING • ORACLE 10 G DATABASE ORACLE DATABASE FRONTEND (USER ACCESS, DATA SHARING & QUERY) ARCMAP • DESKTOP BASED ARCGIS- POWERFUL ANALYSIS GIS APPLICATION • WEB BASED GIS APPLICATION- QUERY/PUBLICATION ARCCATALOG Washington Metropolitan Area Transit Authority

BACKEND- DATA MANAGEMENT Regional Inventory Database GIS ENTERPRISE DATABASE FOR BUS STOP MANAGEMENT • RELATIONSHIPS Planning Database • RI CONSTRAINTS • DOMAINS • DATA INTEGRITY Voice Annunciation Database DATA QUALITY CHECKS • NO REDUNDANCY AND ERROR FILTERING Washington Metropolitan Area Transit Authority

FRONTEND- DATA RETRIEVAL, QUERY AND ANALYSIS WMATA GIS METROVIEW- QUERY ENVIRONMENT Washington Metropolitan Area Transit Authority

WMATA GIS METROVIEW- QUERY ENVIRONMENT- SEARCH RESULTS

WMATA GIS METROVIEW- QUERY ENVIRONMENT DOCUMENT SEARCH RESULTS Washington Metropolitan Area Transit Authority

DATA REVIEW DATA EFFORT- REVIEW AND CLEANUP BY VENDOR • COMPARE RECORDS FROM 2 23’ DATABASES • REVIEW/CORRECT MAPPED LOCATIONS 40’ • REFER DISCREPANCIES (DUPLICATES, UNMATCHED RECORDS) TO WMATA. • SUBSEQUENTLY MATCH GOOD 225’ RECORDS WITH THE THIRD DATABASE. • REFER DISCREPANCIES TO WMATA 30’ EXAMPLE- DATA ERROR- IMPRECISE MAPPING YELLOW- EXISTING MAPPING; RED- CORRECT MAPPING Washington Metropolitan Area Transit Authority

SUMMARY WMATA GIS ENTERPRISE BUS STOP DATABASE PROVIDES A ONE STOP SOLUTION FOR WMATA’S DUAL- FACETED BUSINESS NEED LEGACY DATA CURRENT AND NEW DATA • LEGACY BUS STOP DATA MANAGEMENT • NEW BUS STOP DATA MANAGEMENT • LEGACY DATA INTEGRATION VIA A MULTI • DATA INTEGRITY ASSURANCE VIA A MULTI LEVEL QUALITY CONTROL PROCESS • ZERO POTENTIAL FOR ERRONEOUS DATA- DATA MODEL DESIGN HAS INHERENT CHECKS TO ALLOW ONLY DATA THAT MEETS CONSTRAINTS TO BE LOADED STEERED WMATA’S BUS STOP DATA MANAGEMENT FROM CHAOS TO ORDER Washington Metropolitan Area Transit Authority

QUESTIONS - COMMENTS PRESENTER CONTACT INFORMATION SAKSHI MEHTA SR. GIS ANALYST WASHINGTON METROPOLITAN AREA TRANSIT AUTHORITY WASHINGTON DC SMEHTA@WMATA. COM; 202 -962 -2503 Washington Metropolitan Area Transit Authority