Improving Capital Budget Planning Using GIS - PowerPoint PPT Presentation

1 / 19
About This Presentation
Title:

Improving Capital Budget Planning Using GIS

Description:

Data and Maps. Maintain their project and map data in a central secure enterprise database. Easily link projects/tasks to the street centerline ... – PowerPoint PPT presentation

Number of Views:44
Avg rating:3.0/5.0
Slides: 20
Provided by: fuj51
Category:

less

Transcript and Presenter's Notes

Title: Improving Capital Budget Planning Using GIS


1
Improving Capital Budget Planning Using GIS
Managing
Projects
Tasks
Resources
Funds
And map data
In one integrated environment
Fatjon Ujkani Team Lead / Senior Application
ConsultantIntergraph Canada - SGI P
1.905.740.3446 F 1.905.812.9754 fatjon.ujkani_at_inte
rgraph.com, www.intergraph.com
2
Agenda
  • Need for Capital Planning
  • How can GIS help
  • Case Study
  • TCP Solution
  • Conclusions/questions

3
The Need for Capital Planning
  • Most municipalities have millions if not billions
    of dollars in transportation assets
  • This usually represents a high percentage of
    total asset value
  • A good number of highways and major
    transportation assets are now old and require
    maintenance
  • Timely scheduled preventive maintenance keeps the
    transportation infrastructure in good condition
    and also avoids the large reconstruction costs
  • Usually municipalities plan 10 years ahead

Life
4
Capital Project Lifecycle
  • Surface condition surveys
  • A surface condition index is assigned to each
    roadway segment
  • When a SCI threshold is met a project is entered
    in the capital program
  • Once in the Capital Plan, a project is reviewed
    whether it needs to be advanced or deferred based
    on additional surveys or resourcing and funding
    available
  • When scheduled work is completed project is
    removed from plan

5
Benefits of integration with GIS
  • Visualize physical location of assets
  • Show current condition of each asset
  • Visualize scheduled capital projects for any
    asset
  • Capital Project are tied to the linear road
    network
  • Individual or overall picture showing current
    condition and proposed capital projects
  • Spatially tie with other assets and conduct
    current or historical spatial analysis. For
    example
  • Give all Reconstruction projects on a given area
    that affect Traffic Modernization projects
  • Give all expansion projects where land needs to
    be purchased
  • etc

6
Case Study Region of Waterloo
  • Approximately 975M in Transportation assets
  • Equates to approximately 30 of overall Regional
    assets
  • Due to this high value it is natural to have a
    plan (capital budget)

7
Capital Planning at RoW
  • Two Programs
  • Base Program Maintenance of existing assets
  • Sub-Programs
  • Urban Resurfacing
  • Rural Resurfacing
  • Reconstruction
  • Intersection Improvement
  • Bridge and Drainage Works
  • System Management
  • Traffic Signal Modernization
  • Traffic Engineering
  • 2. Expansion Program New or expansion
  • Sub-Programs
  • Intersection Improvement (Growth-Related)
  • Development Related Left and Right Turn Lanes
  • Funding (Revenues)
  • Types of Funding
  • Subsidy (Federal Gas Tax)
  • Development Charge Reserve Fund
  • RDC Debentures
  • Road Capital Levy Reserve Fund
  • Cycling Facility Capital Reserve Fund
  • Road Rehabilitiation Reserve Fund

8
Internal Circulation Report
9
Mid Year Report
10
CP Old Workflow
11
Limitations ? Requirements
Limitation Requirement
Map is created using separate process Integrate the map with the data
Worksheet is not only the data, but the report as well Store the data efficiently, and report separately
No easy on control what each user is changing and how to merge those changes Multi user environment changing the same dataset in a controlled manner and keeping track of changes
Data is becoming too complex for Excel Ensure efficient new system to remove need to work in Excel
12
Developers Team Considerations
  • Build an application that captures business
    workflows
  • Use existing proven technology and latest
    programming platforms (Oracle Locator/Spatial,
    Workspace Manager, GeoMedia, CR, .NET)
  • Built something practical and easy to use
  • Build an application that is metadata driven and
    easy to configure and manage (metadata system,
    Admin Tool)
  • Allow for extensibility by the users (i.e.
    reporting, open API etc)

13
TCP Application
  • TCP - Transportation Capital Program is an
    application that helps transportation departments
    manage their roadway improvement programs. The
    users can keep track of detailed project and
    tasks information and also identify physical
    project/task location through the integrated map.
    TCP allows for managing
  • Projects/Tasks
  • Resources
  • Budgeting
  • Costing
  • Benchmarks
  • Users
  • Reports

14
TCP Application Cont.1
  • A stand alone .NET based application that allows
    RoW to
  • Data and Maps
  • Maintain their project and map data in a central
    secure enterprise database
  • Easily link projects/tasks to the street
    centerline
  • Visualize project/tasks and other assets on the
    integrated map (driven by GM Library)
  • Track all changes and store for historical
    purposes
  • Be able to take Snapshots of data at any point in
    time and view when needed
  • Users
  • Multiple user environment organized in hierarchy
    of roles (Editor, Admin, Auditor)
  • Have full control on system users and what they
    change
  • Shield LIVE data from user changes until approved
  • Administration, Usability and Reporting
  • Have a user friendly and clean interface that
    makes every task easy
  • Provide an Admin Tool to manage all aspects of
    the application (metadata, users, reports,
    savepoints etc)
  • Automation of some common processes Task
    Creation (templates), Project Deferral/Advancement
    , Funding, Resourcing

15
TCP Application Cont.2
16
TCP Solution Underlying Technology
  • Oracle 10g (with Locator)
  • Multiple user, security, performance,
    scalability, availability etc
  • Oracle Workspace Manager
  • Long Term Transaction, Versioning (Workspaces),
    History etc
  • GeoMedia Objects 6.0 ( Oracle R/W GDO)
  • GeoMedia Libraries and controls to build
    stand-alone application
  • .NET 2005 (C), Crystal Reports 11.5

17
TCP Application Cont.3
18
To Summarize..
  • - By utilizing the power of mapping technology
    in the asset management world we add a new
    dimension to our data that allows to spatially
    reference assets, capital projects and conduct
    complex spatial analysis.
  • - The case study from RoW is specific to
    transportation departments but same concepts
    apply to other type of infrastructure
    (Sewer/Water etc).
  • - For more information and questions come see
    us at our Expo Booth.

19
  • THANK YOU
  • Questions

Fatjon Ujkani Team Lead / Senior Application
ConsultantIntergraph Canada - SGI P
1.905.740.3446 F 1.905.812.9754 fatjon.ujkani_at_inte
rgraph.com, www.intergraph.com
Write a Comment
User Comments (0)
About PowerShow.com