380 likes | 550 Views
Overview. Background DOT Software Tools - ArcMap RIMS Extension DOT Utilities Focused Applications – ArcIMS and Visual Basic Traffic Information Map Road Conditions Map Road Construction Map Design Cover Sheet Right-of-Way Plats. How did I get into GIS??.
E N D
Overview • Background • DOT Software • Tools - ArcMap • RIMS Extension • DOT Utilities • Focused Applications – ArcIMS and Visual Basic • Traffic Information Map • Road Conditions Map • Road Construction Map • Design Cover Sheet • Right-of-Way Plats
How did I get into GIS?? • No one else in IT wanted the job • Learned OTJ • Started from the programming side • Patient Managers • Patient Users • Helpful Colleagues with a LOT of knowledge • Rod Bassler (Master Yoda) - SWC • Gerald Kautzman – NDDOT • GISTC Members
DOT Software • ArcMap 9.0 - 104 Installations • 7 Concurrent ArcInfo • 13 Concurrent ArcView • ArcView 3.3 - 46 Installations • Windows 2000 Server • ArcSDE 9.0 • SQL Server 2000 • ArcIMS 9.0 • IIS 5.0 - Tomcat Jakarta • Development Languages • VBA • VB 6.0 • VB.Net • ASP
What’s the POINT? Using small applications to integrate GIS into everyday workflows
ArcMap Tools • DOT Utilities Tool • Roadway Inventory Management System (RIMS) Tool
DOT Utilities Tool - ArcMap • “Zoom To” common features • Longitude Latitude • XY • Section Township Range • Highway - Mile Point • City • County • Add XY text to mouse click
RIMS Tool - ArcMap • Adds commonly used spatial data sets • Route Events • XY Events • Symbolizes each category of features • Back End Info • Read only tables on SDE • Data transferred from DB2, Oracle, and Access • One stop for table data
Highways By District By Section Highway Components Highway Projects Billboards Bridges Centerline Pipes Curves – Vertical Curves - Horizontal Fences Functional Class of Road Guardrails Inslope Ratio Lights Remarks Right-of-Way Rumble Strips Signs Speed Zones RIMS Data
Focused Applications • Traffic Information Map • Road Conditions Map • Construction Map • Design Cover Sheet • Right-of-Way Plats
Transportation Information Map • Traffic counts by class of vehicle • Volume traffic counts • Turning movements • Breakpoint counts • Portable count locations • Automated traffic counter locations • Functional Classes
Transportation Information Map • Benefits • 10-40 hits per day • 50% reduction in current count requests • 1-2 hours per day saved in researching counts • Internal requests reduced close to 0 • Traffic information in one place • Next Step • Move to external web site
Road Conditions Map Application • Access Application feeds ND Hub • Downloads event table from legacy Road Report application • Downloads reference point table (contains route measures) from DB2 • Calculates from and to route measures for each event. If it can’t find a reference point, it walks the reference point table 3 miles forward and backward to find a close reference point. • Creates an event layer in memory and uploads it as a feature class to the Hub • ArcMap feature classes draw considerably faster than route events • Sends an ArcXML file to create a static maps • Sends link to ASP page to update the “Date” text file • Opens web page for user to verify everything uploaded correctly
Road Conditions Map • Benefits • Errors eliminated - Maps exactly the same each upload • Information is more timely • 5 minutes reduction in preparation time • October 5th and 6th Hits • Interactive Map • 5,450 • Static Maps • 654,665 (Please Note: Pages refresh every 60 seconds)
Road Construction Map Application • Access Application feeds ND Hub • Downloads road construction event table from Construction Automated Records System (CARS) • Creates an event layer in memory and uploads it as a feature class to the Hub • ArcMap feature classes draw considerably faster than route events • Sends an ArcXML file to ArcIMS. Parses the response to build an image map and map tip text files • Uploads text files • Sends an ArcXML file to create a static maps • Sends link to ASP page to update the “Date” text file • Opens web page for user to verify everything uploaded correctly
Road Construction Map • Benefits • 4 minutes versus 2 hours of preparation time • Maps are updated multiple times per day instead 3 times per week • Maps created dynamically with field data • Multiple maps can be created depending on the density of road construction projects • Paper maps are no longer sent out
Scale Tool – Design Cover Sheet • Used to zoom to specified scale.
Export Map – Design Cover Sheet • Creates any of following files for download • PDF, JPEG, PNG8, TIFF, etc • Files can be imported into other documents such as Microstation or Word • Restricted Haul (county) roads is a layer in this application
Design Cover Sheets • Benefits • 5 minutes versus 30 minutes of preparation time • County haul roads electronically available • These used to be maintained with tape on paper maps • Maps are more consistent • External web site – Available to contractors
Right-of-Way Plats • Benefits • 4 hours saved per day per ROW designer • 2 hours per project for Flight planner • Scanned plats are imported into Microstation • Anyone within the DOT can view them without contacting ROW • Sending scanned plats to consultants • Next Step • Move to external web site
Questions ? Contact Information Brian Bieber ND Department of Transportation Information Technology Division 701-328-2649 bbieber@state.nd.us