210 likes | 222 Vues
WisTransPortal V-SPOC is a user-friendly system to extract traffic data, with modules for detector selection, result visualization, and data export. Developed using Java and Oracle, it ensures data accessibility, modularity, and security.
E N D
WisTransPortal V-SPOC Volume, Speed, and Occupancy Application Michael RunnelsTOPS Systems Developermrunnels@engr.wisc.edu Steven Parker, Ph.D.TOPS IT Project Managersparker@engr.wisc.edu Traffic Operations and Safety (TOPS) LaboratoryUniversity of Wisconsin – Madison 2007 TRB Annual Meeting January 22, 2007 Washington, DC
V-SPOC Paper Authors • University of Wisconsin - Madison • Steven Parker, TOPS Project Manager • Michael Runnels, TOPS Systems Developer • Shan Di, Graduate Research Assistant • Changxuan Pan, Graduate Research Assistant • Wisconsin Department of Transportation • Douglas Dembowski, WisDOT Project Manager
WisTransPortal V-SPOCChallenges/Objectives • Get the data out of the ‘Black Box’ by providing an accessible and user-friendly data interface system • Create a system that allows for easy expansion • A system rich in functionality and well organized • Portability, available for use in other states
V-SPOC Timeline • August 15, 2005 – start 12 month project • 3 months – functional requirements and system design • 6 months – software development • 3 months – testing and deployment • Additional enhancements and maintenance ongoing as needed
How It Was Accomplished • Oracle 10g Database • Super Thin Client • Java – V-SPOC programming language • Struts – dynamic webpage framework • JSPs – dynamic webpage language • Distributable Plugins (Open Source) • JFreeChart – used to produce our graphs • JExcel – used to write to excel workbooks • Tomcat Application Server
Technology Direction Objectives • Portable System • Accessible • Easily Maintained/Updated • Configurable • Secure • Modular • User-Friendly • Able to handle large amounts of data
Future Directions • Fiber Network to Gather Real Time Data • More Advanced Quality Assurance and Imputation Features • Integrate With Planning Data (TRADAS) • Integrate With Lane Closure System • GIS Mapping Interface • Java Server Faces/Hibernate
Questions? • TOPS Lab: http://www.topslab.wisc.edu • WisTransPortal: http://transportal.cee.wisc.edu • Michael Runnels: mrunnels@engr.wisc.edu • Steven Parker: sparker@engr.wisc.edu