Location: Data Warehouse and Client/Server Application
Michael Baker International was selected by NJDOT to build a data warehouse and Client/Server application to automate the process of generating Straight Line Diagrams (SLDs). These diagrams are representations of roadway sections on a stick diagram which show the relative location of roadway attribution such as intersecting streets, streams, railroad crossings, etc. Michael Baker recommended incorporating data for both directions of the route where the carriageways are separated by a physical barrier (such as concrete barrier, grass median, etc), into a multi-centerline model that offers a more accurate depiction of the true route alignment and connectivity. Using the multi-centerline model, roadway attribution is more accurately represented. Michael Baker has worked closely with the NJDOT and outside users to analyze workflow, consider future needs, and determine enhancement requirements. Enhancements to the graphic user interface have been implemented, including: contextual graphic representation of the route, interactive diagram content, and a sign viewer that allows users to view sign information by clicking on the symbol. An interactive and integrated Video Log application was also developed that allows the user to "drive" down New Jersey roadways. While viewing roadway images, the application shows route attribution from the SLD database such as posted speed, functional classification and street name. This application has been migrated to a web-based version with the overall system design based on Microsoft .NET Framework, with a Microsoft Silverlight Graphical User Interface (GUI).