1 / 20

John Cherney Wisconsin Dept. of Transportation Library AASHTO RAC TKN Task Force Oct. 1, 2009

Increasing Data Access: Librarian as Data Broker at WisDOT. John Cherney Wisconsin Dept. of Transportation Library AASHTO RAC TKN Task Force Oct. 1, 2009. Why did this happen?. Repeated customer requests for same information.

nevin
Download Presentation

John Cherney Wisconsin Dept. of Transportation Library AASHTO RAC TKN Task Force Oct. 1, 2009

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Increasing Data Access:Librarian as Data Broker at WisDOT John CherneyWisconsin Dept. of Transportation LibraryAASHTO RAC TKN Task ForceOct. 1, 2009

  2. Why did this happen? • Repeated customer requests for same information. • Frustrated researchers could not access internal WisDOT information. • Remnants of Data Integration efforts.

  3. State Highway Programs Attribute Catalog • Internal WisDOT database – Microsoft Access. • Includes information on seven different data systems. • Librarian named a ‘data broker’ for this information. • Librarian has own copy and uses database to answer basic questions.

  4. State Highway Programs Attribute Catalog home screen, dropdown menu, report example …

  5. State Highway Programs Attribute Catalog data catalog example …

  6. Highway Structures Information System • External WisDOT database – Oracle. • Resides on WisDOT extranet; difficult to navigate • Integrates data from WisDOT and Google (for mapping). • Great ‘data mining’ example; contains a wealth of information

  7. Highway Structures Information System home screen …

  8. Highway Structures Information System a few features …

  9. Highway Structures Information System advanced search features …

  10. Highway Structures Information System documents …

  11. WisDOT Traffic Counts & Rustic Roads • Repeated customer requests; occupied staff time. • Involved IT Bureau, Data Management Section, Office of Public Affairs, Scenic Byways Coordinator and Library. • Library created Web sites and added meta data. • Downloads and lack of phone calls/email requests indicate HUGE SUCCESS!

  12. WisDOT Traffic Counts & Rustic Roads home pages …

  13. WisDOT Traffic Counts & Rustic Roads navigation features …

  14. WisDOT Traffic Counts & Rustic Roads map examples … basic, but standard metadata …

  15. WisDOT Acronym Database • Internal database – data entry in Microsoft Access – connected to intranet with Oracle • ‘Donated’ to the Library. • Library is data steward. • Library is responsible for access and maintenance.

  16. WisDOT Acronym Database Oracle connection for Web …

  17. WisDOT Acronym Database intranet home page … search feature …

  18. DOT State Measures – Missouri DOT • Online pathfinder to transportation statistical, annual and performance reports. • Launched August, 2009. Collaboration space for MoDOT analysts. • Involves librarian (A.J. Million, Missouri DOT) as a data host/conduit as well as a provider of searching expertise. • Hosted on secure portion of MTKN Web site. • Uses Content Management System software (Drupal) to engage practitioners to collaborate, provide content.

  19. DOT State Measures – Missouri DOT home page,data example …

  20. Conclusion and next steps … old extranet guide … • Create department-wide data catalog/guide • Update Extranet User’s Guide • Well worth the effort!!

More Related