1 / 67

Practical Applications for Highway Infrastructure and Asset Management

Practical Applications for Highway Infrastructure and Asset Management. Prepared by: Steven J. Hook, Noble County GIS Coordinator 101 N Orange St. Courthouse, 4th Floor Albion, IN 46701 And Keith A. Lytton P.E., Noble County Highway Engineer 1118 E Main St. Albion, IN 46701.

jakeem-adams
Download Presentation

Practical Applications for Highway Infrastructure and Asset Management

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. Practical Applications forHighway Infrastructure and Asset Management Prepared by: Steven J. Hook, Noble County GIS Coordinator 101 N Orange St. Courthouse, 4th Floor Albion, IN 46701 And Keith A. Lytton P.E., Noble County Highway Engineer 1118 E Main St. Albion, IN 46701

  2. Noble County, Indiana • Demographics • Rural County northwest of Fort Wayne • Population of 48,000 • Approximately 411 sq. miles • Brief GIS History • Contracted with Sanborn (Orthos) and Schneider (GIS) 2002-2003 • GIS system in use since spring 2005 • GIS website in use since summer 2006 • Replaced parcel mapping redundancy among three offices

  3. Noble County GIS History • 1980’s—PLSS grid created • 1990’s—Cadastral layers created using AutoCAD (with FMS) • 2003—GIS project funded: Color Orthophotography Planimetric layers Convert dwg cadastral layers to ArcGIS • 2005—Color orthophotography (State); Schneider GIS Award for Excellence • 2006—IGIC Award for Excellence (Counties Category) • 2008—Pictometry color oblique/orthophotography

  4. GIS Working Environment • Use ESRI and AutoCAD products ArcGIS Desktop 9.2—ArcEditor, ArcView, & ArcReader AutoCAD Map 3D 2008 & Civil Desktop 2007 AutoCAD LT • GIS data storage 2—MS SQL 2005 ArcSDE geodatabases: feature classes & orthophotography shapefiles & dwg files

  5. Noble County’s Enterprise GIS System

  6. Driveway Permit and Speed Limit Ordinances Signs and Culverts Line Striping Average Daily Traffic Figures Bridge Layer Highway Management Topics

  7. 1. Driveway Permit and Speed Limit Ordinances • Why incorporate permits and ordinances into the GIS? • Document storage and preservation issues • since 1987: 3000 permits & • 10,000 supporting documents • (maps, deeds, etc.) • Reduce retrieval time • Increase accessibility

  8. 1. Driveway Permit and Speed Limit Ordinances • A. File Management System Implementation • Field-based Hyperlinks Linking Driveway features to the File Management System • C. Display Driveway Permit Information from Related Microsoft Access Databases

  9. A. File Management System Implementation • Where to locate the information? Highway Dept.—on a central server close to users • How to store the information? Directory hierarchy— one main directory, “Driveway Permits” subfolders for each year, “2008” subfolders for each permit, “NCD-001-08” scanned permit & supporting documents • What image format to use? Documents scanned using a TIFF format— standard format, stable, and non-proprietary

  10. A. File Management System Implementation Driveway permit file management system

  11. B. Field-based Hyperlinks Linking Driveway Features to the File Management System • What method to use to create the hyperlink? Link to a document, URL, or attribute field Field-based vs. dynamic hyperlinks • What components make up a field-based hyperlink? Unique identifier—guarantees a 1 to 1 relationship; value stored in the driveway attribute table “Permit_No” field Hyperlink Base—pathname to the scanned documents; value stored in the hyperlink base (Map Properties dialog box)

  12. B. Field-based Hyperlinks Linking Driveway Features to the File Management System Unique Identifier— uniquely identifying each permit record Driveway layer’s attribute table

  13. B. Field-based Hyperlinks Linking Driveway Features to the File Management System Hyperlink Base— pathway to the permit folders stored on the Highway server; eliminates need to store full pathname along with the unique identifier, reducing redundancy. Map Properties Dialog Box for SHOOKViewer3C.mxd

  14. B. Field-based Hyperlinks Linking Driveway Features to the File Management System Final steps In the driveways layer properties dialog box… • Set attribute field containing unique identifiers as storing hyperlinks • Select the “Permit_No” field as the field containing hyperlinks • Select what the hyperlink is connecting to

  15. B. Field-based Hyperlinks Linking Driveway Features to the File Management System Final settings Driveways Layer Properties Dialog Box

  16. B. Field-based Hyperlinks Linking Driveway Features to the File Management System Click the hyperlink button to view driveways having hyperlinks Hold the mouse over the drive highlighted in blue to reveal hyperlink pathway Driveway Popup Tip showing the folder’s pathway

  17. C. Display Driveway Permit Information from Related Microsoft Access Databases A three step process… • Step 1—Create OLE DB connection to MS Access database in ArcCatalog • Step 2—Add the appropriate MS Access table to the map document • Step 3—Create a Relate between the table and the driveways layer Driveways Access DB @ hdserver.odc database connection

  18. C. Display Driveway Permit Information from Related MS Access Databases Step 1—Create OLE DB connection to MS Access database in ArcCatalog Create OLE DB connection Driveways Access DB @ hdserver.odc database connection

  19. C. Display Driveway Permit Information from Related MS Access Databases Step 2—Add the appropriate MS Access table to the map document Step 3—Create a Relate between the table and the driveways layer Map document Information MS Access table Information Relate dialog box showing linking criteria

  20. C. Display Driveway Permit Information from Related MS Access Databases Identify Results for a selected driveway feature

  21. 2. Signs and Culverts

  22. 2. Signs and Culverts A. Data Acquisition B. Data Transfer to the PC C. Updating the GIS

  23. A. Data Acquisition Trimble GeoXT’s were used to gather field data

  24. B. Data Transfer to the PC Transfer Data from Trimble to PC using GPS Pathfinder Software

  25. Apply Differential Correction from GPS Pathfinder Software

  26. Export from GPS Pathfinder Software to ESRI ArcEditor as Shapefile

  27. Traffic Signs are easily found by selection or performing a query.

  28. Culverts are found the same way by query or individual identifying.

  29. 3. Line Striping

  30. 3. Line Striping • Create Routes • Create Route Events • Updating GIS

  31. A) Create Routes Create Routes Dialog Box

  32. B) Create Route Events A Table is first created that contains all the information that will be wanted for stored information

  33. Add route events dialog creating the SolidStripe.dbf events table.

  34. Solid Stripe Attribute Table

  35. A Route with associated Line Events

  36. Query of Route Events

  37. 4. Average Daily Traffic

  38. 4. Average Daily Traffic A) Make a new layer with the attributes you are interested in having for the layer.

  39. Average Daily Traffic

  40. Start your edit session

  41. Make Roads your selectable layer

  42. Select the road section you want

  43. Copy the road section

  44. Paste

  45. This adds a line to the attribute table with the road section

  46. Highlight the Length column

  47. Left click and Calculate Geometry

  48. Use the Length calculation

  49. This gives the length for the roadway section

More Related