practical applications for highway infrastructure and asset management n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Practical Applications for Highway Infrastructure and Asset Management PowerPoint Presentation
Download Presentation
Practical Applications for Highway Infrastructure and Asset Management

Loading in 2 Seconds...

play fullscreen
1 / 67

Practical Applications for Highway Infrastructure and Asset Management - PowerPoint PPT Presentation


  • 96 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - 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