GIS Steering Committee Project Status report by qiF57a

VIEWS: 5 PAGES: 203

									A= Active
C= Complete                                                                                                                                                                                Red= project completion or resource slippage by 25% or more
H= On hold                                                                                                                                                                               Yellow= project completion or resource slippage by 15% or more
Q= Queue (waiting for resource allocation)                                                                                                                                                                                           Green= on schedule

                                                                                                   GIS Monthly Project Status Report
                                                                                                                     November 2009
                                                        Project Status




                                                          Importance




                                                                                                                                             Projected
Status***




                                                                                                                                              Status**
                                                            Project




                                                                                     June
                                                                       April




                                                                                            July
                                                                               May




                                                                                                                                                                                                                                                          Lead
                                              Project                                               Project     Preliminary   Adjusted End
            Project Name/Description                                                                                                                                                             Comments
                                              Number                                               Start Date    End Date         Date


 C OR-Trans/Pooled Fund Project -             GIS19                    G       G     G      G       6/30/04      6/30/05      12/31/2008       G         2/19/2009: ODOT has received the software requirements for replicating the Pooled Fund
   Phase 6                                                                                                                      3/31/09                  portal at ODOT. The code behind the actual portal will be delivered towards the end of
   - Design and construct Web based                                                                                                                      February after WSDOT has had a chance to clean and finalized the code from any issues




                                                                                                                                                                                                                                                          Tammi Griffin and Chad Brady
   check in and out                                                                                                                                      found during testing. 3/5/2009 Staff is on schedule to have the 33 updates to the OR-
                                                                                                                                                         Trans database by March 31. 5/5/2009 ODOT has revceived the code for the WA-Trans
                                                                                                                                                         data user portal for the Washington transportation framework data. ODOT is looking at
                                                            Medium

                                                                                                                                                         various approaches to implementing a similar portal utilizing the code, software and
                                                                                                                                                         architechture developed from the Pooled Fund Porject. Scoping will begin in May. 6/22/09
                                                                                                                                                         ODOT met with WSDOT on 6/17/09 to learn about the software requirements for the
                                                                                                                                                         portal that was developed through the Pooled Fund project. The meeting was to
                                                                                                                                                         determine if Geocortex Essetials was necessary for the development of the portal.
                                                                                                                                                         It was determined that the web programing could be done without this software.
                                                                                                                                                         Project complete.

 C OR-Trans FY 2007 - Phase 7                 GIS19                    G       G     G      G       5/1/07       6/30/08        7/15/09        G         2/19/2009: ODOT has received updates from GeoSolve again. They added a persistent
   - Statewide data partnership                                                                                                                          unique id to each record in each dataset they maintain for 17 counties. This will aid in
   - Wasco County Pilot project                                                                                                                          future change detection efforts during updating and loading of the database. Shawn




                                                                                                                                                                                                                                                          Chad Brady
   - Develop/Coordinator QA/QC of data                                                                                                                   Snyder has begun loading
                                                            Medium




     with Road Authorities                                                                                                                               all of the 33 dataset updates received since November of 2008. He is working on adding
   - Develop Routing data on State                                                                                                                       error reporting features to the FME workbenches. 5/5/2009 The 34 updated datasets have
   highways                                                                                                                                              been loaded. A contractor is now working to integrate the geometry between the highway
                                                                                                                                                         network and the local road network and establish agreement points. This work will be
                                                                                                                                                         finished by July. 7/15/09 Project complete.

 A OR-Trans/Pooled Fund Project -             GIS19                                         G       7/1/09      06/310/10                      G         9/15/09 The Poole Fund Annual meeting is going to be held in Olympia on 9/23 and 9/24.
   Phase 8                                                                                                                                               Representatives from the participating states will be attending to review the project work
   Continue Pooled fund participation                                                                                                                    for the last year and discuss next years objectives. 11/20/09: No Change.
   - Develop a web portal to to facilitate
   regular data maintenance
   - Develop change detection tools




                                                                                                                                                                                                                                                          Chad Brady
                                                            Medium




   - Integrate data from disparate sources,
   QA/QC: quality, security, data entry
   and data retrieval
   - Develop a web portal to deliver multi-
   jurisdictional, multi-modal statewide
   transportation and location data
   - Create documentation to support of all
   technical aspects of the project




                                                                                                                                                                                                                                                      1
                                                       Importance




                                                                                                                                          Projected
Status***




                                                                                                                                           Status**
                                                         Project




                                                                                  June
                                                                    April




                                                                                         July
                                                                            May




                                                                                                                                                                                                                                                        Lead
                                             Project                                             Project     Preliminary   Adjusted End
            Project Name/Description                                                                                                                                                          Comments
                                             Number                                             Start Date    End Date         Date


 A OR-Trans FY 2009 - Phase 9                GIS19                  G       G     G      G       6/1/09      06/310/10                      G         6/22/09 There are now data sharing issues with the county datasets delivered from OEM.
   - Statewide data partnership                                                                                                                       These datasets cannot be shared as part of OR-Trans to anyone at this point. ODOT and
   - Develop/Coordinator QA/QC of data                                                                                                                DAS are working on the issue to see if this can be resolved. 9/15/09 Data from all road
   with Road Authorities                                                                                                                              authorities has been loaded. Staff is reviewing data for completeness. An FME
   - Dataset updates                                                                                                                                  workbench has been developed to transfer County road number information from previous




                                                                                                                                                                                                                                                        Chad Brady
                                                         Medium
                                                                                                                                                      datasets to the newest datasets if the newest dataset didn't contain that information. The
                                                                                                                                                      workbench looks like it has an 85% match success rate with the remaining 15% sent to a
                                                                                                                                                      "review" dataset where personnel will have to review and approve for updating the latest
                                                                                                                                                      data. 11/20/09: County Rd no. transfer was completed. QAQC and mop up on that
                                                                                                                                                      process will be competed in the following months. QAQC on data is being
                                                                                                                                                      performed to insure that all Functionally Classed above local road are represented
                                                                                                                                                      in OR-Trans.
 C Environmental Data Management             GIS31                  G       G     G      G      Ongoing       6/30/09       7/31/2009       G         5/5/09: Region 2 RAZ meetings are in progress through May. Web application migration to




                                                                                                                                                                                                                                                        Phil Smith / Casey Ragain
   System                                                                                                                    11/20/09                 ArcGIS server platform is underway at Alsea Geospatial (AGI) through June. Currently AGI
   (formerly SR-SAM)                                                                                                                                  is developing archaeological module for Gov to Gov use. Handheld applications for
                                                         Medium
   09-11 Biennium                                                                                                                                     mitigation monitoring and Special Management Areas are in revision at MB&G through the
                                                                                                                                                      end of May. 6/11/09: Region 2 RAZ now going to publication. 9/16/09: EDMS team work
                                                                                                                                                      assignments completed. Waiting on printer. 11/20/09: Final maps being distributed.
                                                                                                                                                      Project completed.


 H Traffic Mobility Management System        GIS39                  Y       Y     Y      Y       3/1/06                      6/1/07          Y        09/14/06: Placed on Hold by Motor Carrier Staff. 10/31/06: Project completed. Motor
   Phase 2                                                                                                                  On-Hold                   Carrier does not need any additional work at this time.
     • Develop data models and business                                                                                                               3/8/07: Dennis, Pete Randall, Erik Havig, OBDP Staff and Ron Winterrowd met to discuss
   processes based on recommendations                                                                                                                 future developer needs. Additional discussions will occur over the next few months. Invited
   and findings from Phase 1.                                                                                                                         Randall Thomas to May Steering Committee to discuss needs for project. 1/4/08: Randall
     • Create/capture and catalogue data




                                                                                                                                                                                                                                                        Dennis Scofield
                                                                                                                                                      Thomas reports that final database testing is underway. GIS portion of this project
   (or secure access to data) that will be                                                                                                            remains on hold.
                                                         High




   used and maintained for managing
   traffic mobility.
     • Develop applications that assist in
   managing traffic and freight mobility.
     • Prototype applications, data and
   business processes.



 C TOC GIS Interface                         GIS42                  Y       Y     Y      G       5/1/06        5/1/07        6/15/09        G         3/8/07: Prototype delivered, waiting for final requirements. 3/17/09: ITS database created
   Phase 2                                                                                                                                            on failover server in Bend (s-reg4toc-115). DBA's created account for read only access.
   - Implementation of viewing tool                                                                                                                   Data loaded to ROC or RTP, depending on the application needs. TOC has been notified
   - Provide GIS expertise to the project                                                                                                             and have been asked to test the new server and data. 5/6/09: Going into production the
                                                                                                                                                      end of May. 07/07/09 Data delivered. Participated in meeting to address need for




                                                                                                                                                                                                                                                        Chuck Jenkins
                                                                                                                                                      notification of data updates to prevent application errors. Manual process to notify
                                                         High




                                                                                                                                                      automation team has been activated. Automated process addressing all GIS users will be
                                                                                                                                                      referred to as part of GIS 11-18, Data Management. 9/11/09: Much of the data
                                                                                                                                                      supporting application specific non-highway search and validation functions has
                                                                                                                                                      been developed and delivered. Some of the larger data requests (addressing, for
                                                                                                                                                      instance) are in progress. Data, it's use and expectations were not defined during
                                                                                                                                                      project development. Our current efforts are work-arounds to address the resultant
                                                                                                                                                      issues.




                                                                                                                                                                                                                                                    2
                                                       Importance




                                                                                                                                          Projected
Status***




                                                                                                                                           Status**
                                                         Project




                                                                                  June
                                                                    April




                                                                                         July
                                                                            May




                                                                                                                                                                                                                                                              Lead
                                            Project                                              Project     Preliminary   Adjusted End
            Project Name/Description                                                                                                                                                            Comments
                                            Number                                              Start Date    End Date         Date


 C OEM & Small Projects (cont.)             GIS23-27                G       G     G      G       9/1/06        2/1/07         2/1/07        G         10/01/06: Data collection complete. Project team cleaning and standardizing data.
   Asset Management Region 2 Pilot                                                                                            6/1/07                  11/01/06: Data being mapped. 12:01/06: Data analysis and GIS presentation being
                                                                                                                                                      defined. 01/03/07: Needs Assessment complete (data identified for uses by GIS
                                                                                                                                                      community). Data will be extracted according to various requirements, symbology will be
                                                                                                                                                      established and data will be passed to TransGIS programmer for implementation.




                                                                                                                                                                                                                                                              Robin Ness
                                                                                                                                                      2/21/2007: Initial delivery complete - in conversion of data layers to TransGIS some
                                                                                                                                                      symbology changes are underway. 3/8/07: All data processed. Map/symbology established
                                                                                                                                                      and provided to ArcIMS programmer. Consultation continues to be provided by GIS Unit.
                                                                                                                                                      5/10/07 Met with customer who had additional requirements for the web version.
                                                                                                                                                      This was primarily symbology and layer color changes. TransGIS's Asset
                                                                                                                                                      Management System will be updated and this will complete the project. Project
                                                                                                                                                      Complete.
 A SPIS Pilot for OR-Trans - Proof of        GIS44                  Y       Y     Y      G       7/13/06      12/31/06       3/31/10        G         1/7/2009: Requirements and High level design has started for the SPIS_PUB project. By
   Concepts                                                                                                                                           end of January or early February, this project will decide on its GIS solution. 07/07/09: GIS
                                                                                                                                                      developed SPIS segment generation routines using FME/Python. Volume data is




                                                                                                                                                                                                                                                              Benny Sexton
                                                                                                                                                      dependent on Upper Functionally Classed road conflation to OrTrans. Working on
                                                                                                                                                      process to create LRS for city streets in OrTrans - Baker County pilot. Using LRS and
                                                         High



                                                                                                                                                      measure applied to crashes, SPIS can then be calculated. 11/16/09: Waiting for testing
                                                                                                                                                      to be completed and SPIS business users to approve the proposed GIS solution as
                                                                                                                                                      a working source for statewide location and ADT data for the new SPIS process.
                                                                                                                                                      Hope to be to the design/construction phase by January 2010.


 H Alternate Fuels Corridor - I5            GIS50-2                 Y       Y     Y      Y                                  On-Hold          Y        02/04/09: Tasking not required, yet - per customer.




                                                                                                                                                                                                                                                            Averbeck
   Potential Sites Research- PHASE 2




                                                                                                                                                                                                                                                              Lynn
   - Make database available to public.


 C TPOD (Transportation Planning             GIS52                  Y       Y     Y      G                     5/1/08        6/1/2008       G         1/26/09: The application is functioning and minor enhancements progress with allotted
   Online Database) Phase 1                                                                                                  07/15/08                 time. Access database is complete, with regards to format and table relations. User
   - Use GIS interface to view scanned                                                                                        9/31/08                 interface for editing is still under construction, however, this does not affect use of the GIS




                                                                                                                                                                                                                                                              Susan Mead / Robin Marshburn
   planning studies using Intranet access                                                                                    12/31/08                 web tool. Data updates are in progress and necessary for proper linkages to documents in
                                                                                                                              2/1/09                  the application. Data edits were on hold during holiday break, however, they have
                                                                                                                             04/15/09                 resumed and should be completed soon. 03/13/09: Project distributed to users. Data in
                                                                                                                             06/30/09                 update/maintenance mode. Application being moved from development to production
                                                         High




                                                                                                                                                      server. 05/18/09: Application updated, however, needs to be move to production server.
                                                                                                                                                      Susan needs to complete several data entry forms for database and update the document
                                                                                                                                                      on the server. Resources limited. 07/07/09: Database interfaces completed. Customer
                                                                                                                                                      trained to update database using new tools. Data inconsistencies reported to
                                                                                                                                                      customer. Reconcilliation in process, however, that is a continued maintenance
                                                                                                                                                      activity for customer. Application complete



 C GIS Right-of-Way Parcel Access            GIS53                  G       G     G      G       3/10/08       6/1/08         7/1/08        G         3/11/08: Prototype developed. Business refining requirements.




                                                                                                                                                                                                                                                            Jenkins
                                                                                                                                                                                                                                                             Chuck
                                                         High




   - Provide public access to a subset of                                                                                                             - Complete 7/1/08
   R/W data using a GIS Web Interface




                                                                                                                                                                                                                                                        3
                                                       Importance




                                                                                                                                                  Projected
Status***




                                                                                                                                                   Status**
                                                         Project




                                                                                          June
                                                                            April




                                                                                                 July
                                                                                    May




                                                                                                                                                                                                                                                                     Lead
                                             Project                                                     Project     Preliminary   Adjusted End
            Project Name/Description                                                                                                                                                                   Comments
                                             Number                                                     Start Date    End Date         Date


 C ODOT Solar Highway                        GIS54                          Y       Y     Y      Y       3/10/08       5/1/08        6/1/2008        Y        3/20/08: Experiencing problems obtaining data from PGE (Portland General Electric).




                                                         Mission Critical
   - Identify ODOT R/W that Solar                                                                                                     7/31/08                 4/4/08: No data from PGE. 04/15/08: Data received. Site maps in progress. 5/09/08: Data




                                                                                                                                                                                                                                                                    Susan Mead
   equipment can be tied into PGE                                                                                                    10/31/08                 analysis and mapping in progress. 06/18/08: Data processing has increased due to data
   transmission lines                                                                                                                                         limitations. Additional map production required from GIS staff to provide detail for analysis.
                                                                                                                                                              10/13/08: Final maps in production. Analysis review scheduled. This will complete the
                                                                                                                                                              project as described. 11/12/08: Complete. Maps produced and delivered to customer.

 C RWDMS II - GIS Component                  GIS55                          G       G     G      G       3/10/08       5/1/08        3/20/08        G         3/20/08: Feasibility testing complete. 11/16/09: Last week the RITS GIS application




                                                                                                                                                                                                                                                                    Chuck Jenkins
   - Enhance GIS connection to R/W                                                                                                                            project completed the User Acceptance Testing. Issues have been categorized and




                                                       Mission
                                                       Critical
   FileNet System.                                                                                                                                            are being address by HDR project staff. An application code review was performed
                                                                                                                                                              on November 13th, and a User Guide is in development. The project is still on track
                                                                                                                                                              to be complete by November 30th.

 H ArcGIS ODOT GUI Update                    GIS56                          Y       Y     Y      Y                     6/1/08       8/1/2009         Y        1/26/09: Some tools under revision, in response to the distribution of data through
   - Update existing template to improve                                                                                            09/15/09                  SQL/SDE. 03/16/09: First draft in review and revision. 05/18/09: Resources limited. Also,




                                                                                                                                                                                                                                                                    Susan Mead
   efficiency and standardization.                       Medium                                                                     On-Hold                   with workstation software update soon, consider holding final review and release until
                                                                                                                                                              agency update plan in place. 07/07/09: Data enhancements complete. Data re-pathing
                                                                                                                                                              complete (SDE, portal, etc). In need of programming resources to develop or incorporate
                                                                                                                                                              new tools and complete this version as an 'extension'. 9/11/09: No resources at this
                                                                                                                                                              time.
 H Interchange Diagramming in GIS            GIS58                          Y       Y     Y      Y       8/1/08        9/1/08       2/1/2010         Y        6/25/08: Waiting for resources.
                                                         Medium




                                                                                                                                                                                                                                                                   Tanner
                                                                                                                                                                                                                                                                    Tricia
                                                                                                                                    On-Hold                   Resource will be available 8/1. 7/10/09: Due to technical issues regarding the new
                                                                                                                                                              database (TCM), this project is on hold Until approx 01/01/2010.

 C Electric Vehicle Charging Stations        GIS59                          G       G     G      G       8/1/08                                     G         9/4/08: Lynn Averbeck has received ArcGIS 2 training and with the assistance of Sarah




                                                                                                                                                                                                                                                                    Lynn Averbeck
   Site Data Collection Assistance                                                                                                                            Abbott, Region 1 GIS support technician are doing the project themselves with a minor
                                                                                                                                                              amount (four hours) of support from Ryan Johnson. 7/13/09: Customer reports that the
                                                         High




                                                                                                                                                              project is no longer GIS enabled. Somebody else has taken over and they will not
                                                                                                                                                              be using GIS to implement the EV Charging Station Installations. Project Complete.


 A Freight Bottleneck Identification         GIS60                          Y       G     G      G       6/1/09       12/31/09                      G         5/6/09: Data delivery to HDR complete. 7/11/09: Continue to provide data standards and
   - Provide to consultant, existing data                                                                                                                     data structure support to consultant. 9/16/09: Preliminary map review complete.




                                                                                                                                                                                                                                                                    Phil Smith
                                                         Medium




   for various infrastructure elements                                                                                                                        Interactive Visualization tool in development, Standard mapping, workflows, and
   - Assist consultant with data structure                                                                                                                    data use limitations in technical consultation with Freight and GIS Unit.
   support
   -standardize, map and publish final
   data products
 A FACS-STIP Tool - Phase 3                  GIS61                          Y       R     G      G       7/1/09      varies per      WOC 6:         G         5/18/09: Project scoping complete, contractor under consideration, supplemental data in
   - GIS Utilities / Intranet Service                                                                                  WOC           04/01/10                 review. Waiting on contract process. 07/13/09: WOC 1 - Master Plan completed by
   - Data enhancements (new data and                                                                                                                          contractor. WOC 2 - Redevelop original desktop STIP Scoping application for Intranet
   additional fields in existing data)                                                                                                                        deployment, completed by contractor. WOC 3 - Develop mobile GIS plan, completed by
   - Reporting mechanisms                                                                                                                                     contractor. WOC 4 - Develop first phase of mobile GIS (data extract to spreadsheet) and




                                                                                                                                                                                                                                                                    Laura Wipper
   - Data Collection options
                                                         Medium




                                                                                                                                                              include additional priority data as identified by customers, in process. Updated and
   - Communication Tools                                                                                                                                      additional data to be delivered to consultant 7/17/09 (GIS resources). Application to be
   - Mobile GIS                                                                                                                                               completed by 7/31/09 (consultant). User testing, fixes and installation/acceptance by
                                                                                                                                                              9/18/09. 9/11/09: user initiation complete. Follow-up survey complete and compiled.
                                                                                                                                                              WOC-5 priorities being established to address enhancements as well as existing bugs.
                                                                                                                                                              11/20/09: User and support staff training in progress using 'Alpha' version of WOC-
                                                                                                                                                              5. WOC-6 contract signed and data updates in progress.




                                                                                                                                                                                                                                                               4
                                                     Importance




                                                                                                                                        Projected
Status***




                                                                                                                                         Status**
                                                       Project




                                                                                June
                                                                  April




                                                                                       July
                                                                          May




                                                                                                                                                                                                                                                        Lead
                                           Project                                             Project     Preliminary   Adjusted End
            Project Name/Description                                                                                                                                                       Comments
                                           Number                                             Start Date    End Date         Date




                                                                                                                                                                                                                                                    Susan Mead /
 A TPOD (Transportation Planning           GIS62                  Y       Y     Y      Y       7/1/09        9/1/09        1/31/10         Y        5/18/09: Waiting on completion of phase 1. 07/07/09: VPN testing in progress in




                                                       Medium
   Online Database) - Phase 2                                                                                                                       development server. 9/15/09: TAD is installing JavaScript API on server. Testing will




                                                                                                                                                                                                                                                       Robin
   - Internet access                                                                                                                                continue, once install is complete. 11/20/09: Waiting for completion of new Web
                                                                                                                                                    BaseMap before promoting to production server. Development version in use by
                                                                                                                                                    customers.
Q Integration of OTIA III GIS data and     GIS63                  Y       Y     Y      Y                    6/20/10                        Y        9/15/09 Funding has been identified and project plans will be developed. Current




                                                                                                                                                                                                                                                    Dennis Scofield
                                                                                                                                                                                                                                                    Benny Sexton /
  systems to ODOT GIS System -                                                                                                                      plans call for a mini-solicitation process of available GIS contractors.




                                                       High
  Phase 1



Q Statewide Traffic Mobility GIS           GIS64                  Y       Y     Y      Y                                                   Y




                                                                                                                                                                                                                                                        Chad Nielsen
  Interface - Phase 2
  Redevelops the 'war room'
  application as an Intranet utility for               High
  use as a freight / mobility
  insurance/planning tool.
A EDMS: Enhance Environmental Data         GIS65                                       G       7/1/09       6/30/11                       G         03/03/09: Begin Work 07/01/09. 9/16/09: GPS field support and data collection in progress
  Management System           09-11                                                                                                                 for field season 2009. Region 1 RAZ workshops scheduled for October and November.
  Biennium                                                                                                                                          GEAR application project plan in draft. Achaeological web application in development.
                                                                                                                                                    11/16/09: The EDMS program is currently in its final week of hosting Region 1 RAZ
                                                                                                                                                    meetings. The meetings are on schedule to publish and distribute Region 1 maps in
                                                                                                                                                    early Spring 2010. The Region 1 Tech Center Environmental Unit withdrew from
                                                                                                                                                    workshop participation due to workloads and immediate demands within project
                                                                                                                                                    delivery. The Geo-environmental section’s natural resource unit staff participated in




                                                                                                                                                                                                                                                        Phil smith
                                                       Medium




                                                                                                                                                    place of the Region Environmental Coordinators. ODF&W participated in the
                                                                                                                                                    meetings and expressed concerns regarding this substitution. Following a joint
                                                                                                                                                    project debrief with ODOT GIS later this year any ongoing issues in this matter will
                                                                                                                                                    be addressed to Office of Maintenance by ODF&W. Field data collection support
                                                                                                                                                    slowing as winter approaches. The first module for archaeology support is
                                                                                                                                                    currently in review with ODOT archaeology staff. Resource map production is
                                                                                                                                                    currently underway for Region 4.



 A GIS Data In Progress                    GIS21                  G       G     G      G      Ongoing       Ongoing       Ongoing         G         Traffic Barriers update
    Projects categorized as:                                                                                                                        ITS update
    OEM or Small                                                                                                                                    Bridge Needs List (STIP Scoping)




                                                                                                                                                                                                                                                        Susan A. Mead
                                                                                                                                                    Pavement Needs List (STIP Scoping)
                                                       High




                                                                                                                                                    Weigh-in-motion Sites (2009)
                                                                                                                                                    Traffic Signal Warrants (2009)
                                                                                                                                                    Fire Stations
                                                                                                                                                    Extremely Hazardous Sites (partial state)
                                                                                                                                                    Highway Network, 3rd quarter version




                                                                                                                                                                                                                                                5
                                                   Importance




                                                                                                                                      Projected
Status***




                                                                                                                                       Status**
                                                     Project




                                                                              June
                                                                April




                                                                                     July
                                                                        May




                                                                                                                                                                                                                   Lead
                                        Project                                              Project     Preliminary   Adjusted End
            Project Name/Description                                                                                                                                                  Comments
                                        Number                                              Start Date    End Date         Date


 A GIS Data Completed                    GIS21                  G       G     G      G Completed         Completed     Completed        G         ODOT Aggregate sites October 2009 (10/09)
                                                                                                                                                  ATRs on State System (07/09)
                                                                                                                                                  Cattle Guards and Passes (10/09)
                                                                                                                                                  City Limits Annual (10/09)
                                                                                                                                                  Congestion (10/09)
                                                                                                                                                  Contract Plan Segments (10/09)
                                                                                                                                                  Crashes 2008 Annual (09/09)
                                                                                                                                                  ODOT Districts (09/09)
                                                                                                                                                  Engineering Stations (10/09)
                                                                                                                                                  Highway Names Lookup (10/09)
                                                                                                                                                  Right of Way Map Index (10/09)




                                                                                                                                                                                                                   Susan A. Mead
                                                                                                                                                  Lane Widths (09/09)


                                                     High
                                                                                                                                                  LiDAR Index (10/09)
                                                                                                                                                  Left turn Lanes (09/09)
                                                                                                                                                  Medians (09/09)
                                                                                                                                                  National Network - nonstate roads (10/09)
                                                                                                                                                  National Network - state highways (10/09)
                                                                                                                                                  Rest Areas on State Highways (10/09)
                                                                                                                                                  RLIS (Metro data) (09/09)
                                                                                                                                                  Right of Way Parcel Centroids (10/09)
                                                                                                                                                  Right Turn Lanes (09/09)
                                                                                                                                                  Safety Investment Program Segments (SIP) (09/09)
                                                                                                                                                  Command Areas (TOC) (09/09)
                                                                                                                                                  Viewpoints (10/09)
                                                                                                                                                  Weigh Stations (10/09)




                                                                                                                                                                                                                   Susan A. Mead
 A GIS Infrastructure Support (cont.)   GIS11-01                G       G     G      G      Ongoing       Ongoing       Ongoing         G         TRAINING RECEIVED: no activity at this time
   Training
                                                     High




                                                                                                                                                  TRAINING DELIVERED:
                                                                                                                                                   Access Management Road Approach Tool: 10 students (10/09)




                                                                                                                                                                                                               6
                                                   Importance




                                                                                                                                      Projected
Status***




                                                                                                                                       Status**
                                                     Project




                                                                              June
                                                                April




                                                                                     July
                                                                        May




                                                                                                                                                                                                         Lead
                                        Project                                              Project     Preliminary   Adjusted End
            Project Name/Description                                                                                                                                                  Comments
                                        Number                                              Start Date    End Date         Date


 A GIS Infrastructure Support (cont.)   GIS11-02                G       G     G      G      Ongoing       Ongoing       Ongoing         G         DEMONSTRATIONS DELIVERED:
   Demonstrations




                                                                                                                                                                                                         Susan A. Mead
                                                                                                                                                   Crash Locator Tool: Metro and WashDOT (10/09)
   (6 month drop-off cycle)




                                                     High
   Target:
     OTC, Area Managers, Project
   Managers, Additional PBLT groups,
   Doug Tindall, Hwy Div Manager
 A GIS Infrastructure Support (cont.)   GIS11-03                G       G     G      G      Ongoing       Ongoing       Ongoing         G         CUSTOMER SUPPORT HOURS:
   Customer Support                                                                                                                                41.25 (5/09)




                                                                                                                                                                                                         Susan A. Mead
   -Help Desk functions including GPS                                                                                                              89.5 (6/09)




                                                     High
   support                                                                                                                                         17.0 (07/09)
                                                                                                                                                   24.0 (08/09)
                                                                                                                                                   28.0 (09/09)
                                                                                                                                                   31.0 (10/09)
 A GIS Infrastructure Support (cont.)   GIS11-04                Y       Y     Y      G      Ongoing       Ongoing       Ongoing         G         METADATA Completed:
   Metadata                                                                                                                                       10/09 - all datasets listed below
                                                                                                                                                  ODOT Aggregate sites October 2009 (10/09)
                                                                                                                                                  ATRs on State System (07/09)
                                                                                                                                                  Cattle Guards and Passes (10/09)
                                                                                                                                                  City Limits Annual (10/09)
                                                                                                                                                  Congestion (10/09)
                                                                                                                                                  Contract Plan Segments (10/09)
                                                                                                                                                  Crashes 2008 Annual (09/09)
                                                                                                                                                  ODOT Districts (09/09)
                                                                                                                                                  Engineering Stations (10/09)
                                                                                                                                                  Highway Names Lookup (10/09)




                                                                                                                                                                                                         Susan A. Mead
                                                                                                                                                  Right of Way Map Index (10/09)
                                                     High




                                                                                                                                                  Lane Widths (09/09)
                                                                                                                                                  LiDAR Index (10/09)
                                                                                                                                                  Left turn Lanes (09/09)
                                                                                                                                                  Medians (09/09)
                                                                                                                                                  National Network - nonstate roads (10/09)
                                                                                                                                                  National Network - state highways (10/09)
                                                                                                                                                  Rest Areas on State Highways (10/09)
                                                                                                                                                  RLIS (Metro data) (09/09)
                                                                                                                                                  Right of Way Parcel Centroids (10/09)
                                                                                                                                                  Right Turn Lanes (09/09)
                                                                                                                                                  Safety Investment Program Segments (SIP) (09/09)
                                                                                                                                                  Command Areas (TOC) (09/09)
                                                                                                                                                  Viewpoints (10/09)
                                                                                                                                                  Weigh Stations (10/09)




                                                                                                                                                                                                     7
                                                         Importance




                                                                                                                                            Projected
Status***




                                                                                                                                             Status**
                                                           Project




                                                                                    June
                                                                      April




                                                                                           July
                                                                              May




                                                                                                                                                                                                                                                        Lead
                                              Project                                              Project     Preliminary   Adjusted End
                   Project Name/Description                                                                                                                                                     Comments
                                              Number                                              Start Date    End Date         Date


 A GIS Infrastructure Support (cont.)         GIS11-06                G       G     G      G      Ongoing       Ongoing       Ongoing         G         In Progress:
   Software                                                                                                                                                ArcGIS Desktop 9.3.1 (I)
   Evaluation/Purchase/Implementation                                                                                                                      Job Tracking for ArcGIS (GIS Unit testing)
                                                                                                                                                           PLTS for ArcGIS (GIS Unit testing)
            (E) - Evaluation                                                                                                                               Google Sketchup 7 (E)




                                                                                                                                                                                                                                                        Chad Nielsen
            (P) - Purchase                                                                                                                                 FME Desktop 2010 - Beta (E)
            (I) - Implementation




                                                           High
                                                                                                                                                        On Hold:
                                                                                                                                                          Intergraph GeoMedia Professional 6.01 (E; GIS unit testing)
                                                                                                                                                          Intergraph GeoMedia Transportation Manager 6.01 (E; GIS unit testing)
                                                                                                                                                          Intergraph GeoMedia Fusion 6.01 (E; GIS unit testing)

                                                                                                                                                        Complete: No Activity


 A GIS Infrastructure Support (cont.)         GIS11-08                Y       Y     Y      Y                     9/4/09                       G         7/9/09: GIS Project Delivery Concept of Operations in draft. Consultation with project




                                                                                                                                                                                                                                                        Phil Smith
   Process Guidelines                                                                                                                                   delivery completed. Project Tracker in review and Project Scheduler in draft. GIS project
                                                           High

                                                                                                                                                        delivery functional flow chart in draft. 11/16/09: Draft GIS Project Delivery Concept of
                                                                                                                                                        Operations submitted for GIS steering review.

 A GIS Infrastructure (cont.)                 GIS11-14                G       G     G      G      Ongoing       Ongoing       Ongoing         G         7/8/09: Coordinating with software vendor to discuss best architecture for implementation
   Hardware                                                                                                                                             of planned and existing services and to address performance issues. 11/20/09: Removing




                                                                                                                                                                                                                                                        Chad Nielsen
                                                                                                                                                        ArcIMS from one server - moving from 3 to 2-tier environment. VPN will move from
                                                                                                                                                        s-salemrev-110 to s-salemrev-112. Data server s-salemrev-114 will be updated to
                                                                                                                                                        E.S.R.I. 9.3.1 version once TOCS data is copied to it's own, dedicated server and the
                                                                                                                                                        predominance of ODOT staff workstations are updated to ArcGIS 9.3.1.




                                                                                                                                                                                                                                                    8
                                                   Importance




                                                                                                                                      Projected
Status***




                                                                                                                                       Status**
                                                     Project




                                                                              June
                                                                April




                                                                                     July
                                                                        May




                                                                                                                                                                                                                                                           Lead
                                        Project                                              Project     Preliminary   Adjusted End
            Project Name/Description                                                                                                                                                       Comments
                                        Number                                              Start Date    End Date         Date


 A GIS Infrastructure (cont.)          GIS11-15                 G       G     G      G      Ongoing       Ongoing       Ongoing         G         8/31/08: Regions 3 and 5 NAS servers are full. The Salem server has more storage space
   Planning                                                                                                                                       and is reaching capacity. Region 5 now has a fiber connection so data access should be
                                                                                                                                                  much faster. We are investigating if perhaps the new connection is fast enough in
                                                                                                                                                  combination with SDE to scale down the Region 5 NAS. Options for Region 3 are still
                                                                                                                                                  being explored. 1/26/09: No resources. 7/8/09: A team has been assembled which
                                                                                                                                                  includes Information Security (IS) and Business to assess ODOT’s computer network
                                                                                                                                                  infrastructure. This team is using network tools to analyze and diagnose congestion and
                                                                                                                                                  utilization. This includes looking at PC switching incompatibilities, insufficient bandwidth,
                                                                                                                                                  topology (how the network is configured), the mapping to non-local servers, business
                                                                                                                                                  processes, back-ups and applications that may not be using the network efficiently. A
                                                                                                                                                  survey in under development right now for release on July 13 to gain more insight into local
                                                                                                                                                  experience with ODOT networks. The project team is working in collaboration with State
                                                                                                                                                  Data Center (SDC) on potential improvements and options for higher network speeds.
                                                                                                                                                  9/15/09 Dennis is working with Dan Handy to
                                                                                                                                                  develop options including State Data Center tape back-up for non-essencial
                                                                                                                                                  GIS data. Interum solution is to purchase additional external drives for LiDAR
                                                                                                                                                  data. Laura Wipper reports that the team evaluating network speeds and
                                                                                                                                                  optimization continues to meet. At last report, some improvements to
                                                                                                                                                  network topology are being undertaken by the State Data Center; an
                                                                                                                                                  automated option was being evaluated for efficient corrections to PC switch
                                                                                                                                                  incompatibilities; and a survey to the regions was delayed until this fall.
 A GIS Infrastructure (cont.)          GIS11-18                 G       G     G      G      Ongoing       Ongoing       Ongoing         G         1/26/09: No resources. 5/18/09: two new 'working' databases have been created on the
   Data Management                                                                                                                                production server. Application pointers to a single image file need redirection. The image
                                                                                                                                                  has been copied to a dedicated server. This will free-up space for several new 'working'




                                                                                                                                                                                                                                                           Susan Mead
                                                                                                                                                  databases. 7/8/09: Working with I.S. to develop a customer notification process to address
                                                                                                                                                  the implications that data changes/updates may have on applications, projects, map
                                                                                                                                                  services, etc. May utilize change detection to provide change details, simplifying the task
                                                                                                                                                  of investigating possible impacts to existing systems. 09/11/09: Data cleaning in process to
                                                                                                                                                  free S6000E Business Server. 11/20/09: LiDAR data being stored on additional
                                                                                                                                                  external drives.
 A GIS Infrastructure (cont.)          GIS 11-22                G       G     G      G      Ongoing       Ongoing       Ongoing         G         03/16/09: Revisions, updates and enhancements in progress. 05/18/09: Server/data




                                                                                                                                                                                                                                                      Phil Smith / Shawn
   GIS Unit Website Maintenance                                                                                                                   location tools in production. 7/11/09: Updates to ArcPad data folders, added water
                                                                                                                                                  authorization maps and links and began build of framework for the new GIS webpage.




                                                                                                                                                                                                                                                            Snyder
                                                                                                                                                  9/16/09: Web site in maintenance while new Intranet site standards are in development.
                                                                                                                                                  11/18/09: Maps page: Added section for the ORS 366.215-State Highways Subject to
                                                                                                                                                  Reduction of Capacity Review Maps; GPS page: Added the ArcPad quick reference
                                                                                                                                                  documents; and general site maintenance.

 A GIS Infrastructure (cont.)          GIS 11-24                                     G       7/1/09                                     G         09/11/09: DRAFT Standard established. Using contractor code from FACS-STIP




                                                                                                                                                                                                                                                      Scofield
                                                                                                                                                                                                                                                      Dennis
   Develop Standard Map Interface                                                                                                                 Tool as base. Code passed to HDR for use in Right-of-way application design.
   Design for ODOT


 C OEM & Small Projects (cont.)        GIS23-02                 Y       R     R      G       5/1/06       7/31/06        11/15/06       G         1/26/09: No resources available. 05/18/09: Application moved to ArcGIS Server platform




                                                                                                                                                                                                                                                  Susan Mead and Robin
   Scenic Byways GIS Implementation                                                                                       5/15/07                 on development server. Graphics in revision. Due to server versioning issues, application
                                                                                                                          5/1/08                  will be moved to production server. 7/13/09: Generated raster image for OpenLayers
                                                                                                                          6/15/08                 version of application. Submitted to customer for review and approval. GIS correcting one
                                                     High




                                                                                                                                                                                                                                                         Ness
                                                                                            ACTIVE                        9/01/08                 spelling error, then, it's considered approved by customer and complete!
                                                                                            12/1/07                       10/1/08
                                                                                                                         11/30/08
                                                                                                                         03/01/09
                                                                                                                         07/01/09




                                                                                                                                                                                                                                                  9
                                                         Importance




                                                                                                                                                    Projected
Status***




                                                                                                                                                     Status**
                                                           Project




                                                                                            June
                                                                              April




                                                                                                   July
                                                                                      May




                                                                                                                                                                                                                                                             Lead
                                              Project                                                      Project     Preliminary   Adjusted End
                   Project Name/Description                                                                                                                                                            Comments
                                              Number                                                      Start Date    End Date         Date


C OEM & Small Projects (cont.)                GIS23-03                        Y       G     G      G       1/29/07      6/30/07         6/30/07       G         1/26/09: Final approval of application received from PM and training plan and scheduling




                                                                                                                                                                                                                                                               Susan Mead and Robin Ness
  Access Management GIS                                                                                                                 6/30/08                 are in progress. 3/19/09: Real-life/user scenarios in development w/ field staff input.




                                                           Mission Critical
  Implementation                                                                                                                        9/01/08                 5/18/09: Training resources redefined and classes should begin before mid-June. 7/10/09:
                                                                                                           3/1/08                      03/01/09                 Updated CHAMPS and Upermit layers. Prepared and presented AMPT Training Session.
                                                                                                                                       07/15/09                 Customer has requested a second session to train additional staff. 09/11/09: No classes
                                                                                                                                       11/19/09                 scheduled by customer as of this report. 11/20/09: Class held November 2009. Support
                                                                                                                                                                for training development complete. Data update will be received 12/01/09 and
                                                                                                                                                                update cycle will be determined as users provide feedback to customer. Project
                                                                                                                                                                complete 11/19/09.

            OEM & Small Projects                                                            G             Ongoing       Ongoing       Ongoing         G         09/14/09:
            (Active Projects Listed)                                                                                                                            23-43 City/County Base Maps and bi-products
                                                                                                                                                                   Completed changes submitted by RICS Unit. Edited and final review of city and county
                                                                                                                                                                atlas series. Analyzed and submitted differences between functionally classified roads in
                                                                                                                                                                city/county base layers vs OrTrans. Updates to Salem and Chiloquin.
                                                                                                                                                                23-48 Director's Office Support: Economic Stimulus Maps
                                                                                                                                                                   Updated JTA Region 5 and statewide map.
                                                                                                                                                                23-51 Safety Section Support
                                                                                                                                                                   Began crash map product for motor carrier.
                                                                                                                                                                23-52 Oregon Transportation Commission Maps, Graphics and Analysis
                                                                                                                                                                   Created maps for meetings and striping crew. Review and confirm locations with
                                                                                                                                                                customer.
                                                                                                                                                                23-56 Safety Section Support
                                                                                                                                                                  Reviewed and edited data for 2010 construction map and provided input requirements to
                                                                                                                                                                customer for support of future data exchanges.
                                                                                                                                                                23-57 SIP-SPIS Maps
                                                                                                                                                                   Reviewed data runs for errors, submitted to data steward.
                                                                                                                                                                23-58 STIP mapping Support:
                                                                                                                                                                   Received list of key numbers, used to extract and map projects. Created Region 5 map
                                                                                                                                                                for public meeting. Created Region 2 maps for draft stip.
                                                                                                                                                                23-59 Official State Map / Tourist Map:
                                                                                                                                                                   Coordination with UofO to complete edits. Printing stopped due to errors.
                                                                                                                                                                23-62 Miscellaneous small mapping projects
                                                                                                                                                                   Develop additional maps for ODOT construction project outreach. Develop exhibit
                                                                                                                                                                map for ODOT/Tillamook county road agreement.
                                                                                                                                                                23-64 Maintenance Maps - Annual product
                                                                                                                                                                   Completed district and region maps. Developed custom maps for Don Jordan.




                                                                                                                                                                                                                                                        10
                                                       Importance




                                                                                                                                          Projected
Status***




                                                                                                                                           Status**
                                                         Project




                                                                                  June
                                                                    April




                                                                                         July
                                                                            May




                                                                                                                                                                                                                                             Lead
                                             Project                                             Project     Preliminary   Adjusted End
                  Project Name/Description                                                                                                                                                Comments
                                             Number                                             Start Date    End Date         Date


            OEM & Small Projects (cont'd)                                         G                                                         G         23-78 TransInfo / I.T.I.S. Rewrite
            (Active projects cont'd)                                                                                                                     Review analysis by RICS Unit and make recommendations regarding OrTrans and Web
                                                                                                                                                      Apps with regards to TransInfo.
                                                                                                                                                       23-79 House Bill 2001
                                                                                                                                                         Georeference scanned maps. Create historical AADT maps.
                                                                                                                                                      23-80 Fire Marshal - Extremely Hazardous Site response planning
                                                                                                                                                         Worked on inset maps, edited point layers and posted data and maps for review by
                                                                                                                                                      customer. Developing an atlas for series.
                                                                                                                                                      23-81 Trip Check GIS Prototype
                                                                                                                                                         Continue work on prototype of basemap and application.
                                                                                                                                                      23-84 RWDMS Phase 3 support HDR Application Development of GIS tools to
                                                                                                                                                      define and access Filenet documents.
                                                                                                                                                        Provide support by updating and posting data for contractor.
 A Transportation Model Development                                 G       G     G      G      Ongoing       Ongoing       Ongoing         G         9/17/09: Deschutes County Model: Base year completed. Future year in progress.
                                                                                                                                                      Brookings and Woodburn Model: Base / Future year complete and awaiting
                                                                                                                                                      applications. OHAS: Fall Survey (Region 2 and LCOG) has begun. GreenStep: large
                                                                                                                                                      majority of input data received, currently developing scenarios to model. Marion
                                                         High



                                                                                                                                                      County Model: Network complete, currently integrating demand from SWIM into the
                                                                                                                                                      structure. Corvallis/Albany/Lebanon (CALM) Model: Model will incorporate
                                                                                                                                                      Jefferson, Lebanon, Albany, Corvallis, Tangent and selected Marion County areas,
                                                                                                                                                      build in progress.




                                                                                                                                                                                                                                        11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
                                                                  COMPLETED PROJECTS

Project #                                                 Start        End     Adjusted
                              Project
                                                          Date         Date    End Date
 GIS09      GIS Software Evaluation Process                          3/01/01    9/30/02
             - Develop GIS software evaluation                        3/1/02    1/23/03
            guidelines (complete)                                               5/22/03
             - Develop test plan template                                       7/24/03
            (complete)
             - Develop template for cost analysis
            (Life cycle costs)

DGIS04      ITS Traffic Counting Equipment                           10/1/00    3/1/01
            (Closed on 3/01/01)




DGIS05      TransGIS (Version 2.0)                                   9/1/01
            - Develop plan for next phase
              - Intermodal (Freight)
              - Pavement
              - Congestion
              - Bridge
              - Traffic Counting




DGIS06      Highway Layer for ArcView                                9/1/00    2/28/02
            - Conversion program from MGE to ArcInfo.
            Allows users to dynamically segment, review
            and display their own highway data.




DGIS07      SMMS Web Based Access                                    2/15/01   5/15/02
            - (DGIS 10 is complete)




 Revised 10/12/00
                                                   COMPLETED PROJECTS

DGIS09   Automated Collision Diagram                  6/30/01
         - Phase 1
           - Study options


DGIS09   Automated Collision Diagram                  5/30/02    9/01/02
         - Phase 2                                              01/01/03
           - Development/Testing




DGIS09   Automated Collision Diagram                  3/1/03    4/01/03
         - Phase 3                                              5/22/03
           - Implementation

DGIS10   SMMS Metadata migration to SQL Server        2/15/01    6/1/01



DGIS11   DMV Project                                  8/1/01    10/1/01

DGIS15   Access Control Demonstration                10/31/02   2/28/03
         - Incorporate resources
         - Changes to CHAMPS database and
         hyperlink to GIS tools
         - Database development for ROW research


GIS01    Base Layer Development                       3/24/98   9/22/98




GIS05    Aggregate Sites                              5/29/00   5/30/01
          Phase 1
           Intranet database application
GIS05    Aggregate Sites                              1/31/01   5/30/01
          Phase 2
           Intranet GIS application




 Revised 10/12/00
                                                      COMPLETED PROJECTS

GIS05   Aggregate Sites                                 12/31/00    5/30/01
         Phase 3
          Desktop GIS application
GIS07   Non-State Hwy Functional Classification          6/1/00     12/1/01
        System Attribution

GIS13   State Highway 1:24,000 road alignments           6/30/01    7/31/01

GIS14   GIS Base Layers Phase 2                          1/24/01    3/1/3102
        - Select 6 new base layers
          1-Pavement Conditions 1999
          2-ITS
          3-Bridge
          4-Intermodal (FIMS)
          5-Crash
          6-Non State Highway Functional Class
          7-Federal Urban Trans Boundary
        Cust.: All GIS users
GIS15   Non-State Hwy Functional Classification and      1/9/01     5/31/02
        National Highway System to SQL




GIS16   Wasco County Pilot Project                      5/01/2001   6/30/01
         Phase 1
          6 target areas

GIS16   Wasco County Pilot Project                       7/23/01    9/30/01
         Phase 2
          All roads GIS coverage


GIS17   Upgrade of GIS related software                 10/25/01    3/31/02
         Phase 1 - testing
GIS17   Upgrade of GIS related software                  1/1/02     3/31/02
         Phase 2 - implementation




Revised 10/12/00
                                                  COMPLETED PROJECTS

GIS18   Road Authority Database                       7/1/01    10/1/01
GIS20   Oregon Statewide Burial Site & Cemetery      4/30/02   12/30/02
        Base Layer
        (Phase 1) (Cultural framework)
        - Develop GIS layer for cemeteries from
        ODOT map bases.
          (Approx. 500)

GIS20   Oregon Statewide Burial Site & Cemetery      4/30/02
        Base Layer
        (Phase 2) (Cultural framework)




Revised 10/12/00
                                     COMPLETED PROJECTS

GIS21   GIS Layers Complete
         Projects categorized as:
         OEM or Sm
           Assign sub-numbers

        (Quarterly drop-off cycle)
        (Mar-Jun-Sept-Dec)




Revised 10/12/00
                                                     COMPLETED PROJECTS

GIS23   OEM & Small Projects(OEM)
        - Other projects completed by the GIS
        Project Team

        (Quarterly drop-off cycle)
        (Mar-Jun-Sept-Dec)




GIS24   Tsunami Inundation Mapping Analysis            3/5/2003    4/4/03




GIS26   On-Line Contractor Emergency Registry          12/15/02   4/01/03
        System                                                     5/1/03
         - Build GIS interface to IS Web developed
        site



        ArcView Lat/Long coordinates                   08/01/00   9/15/00


        Arc View Display of DGN Files                  09/01/00   09/15/00


        ArcView Location Reference System (LRS)        08/01/00   09/15/00
        Highway Milepoint Readout

        GPS Standards                                  05/01/00   05/01/00

        Rail Network                                   08/01/00   03/15/00

        Rail Crossing                                  03/15/00   05/31/00




Revised 10/12/00
                                                   COMPLETED PROJECTS

        Federal benchmark layer (NGS) (Complete)     07/15/00


        Desktop GIS - STIP/SIP (DGIS03a)             06/16/00   10/15/00


        Joint Estimation Model Data Development      05/15/00   09/30/00
        (Medford)
        ODOT Injection Wells Inventory (Phase 1)      6/22/00   09/01/00
        (Complete)
        Statewide Model Application Project           6/1/00    12/1/00
        (Willamette Valley)
        Non-MPO Travel Model Data Support             3/1/00    11/30/00
        (Lebanon)
        Generation 2 Statewide Model                  7/1/99    12/31/01




        Urban Transportation Model Development        6/1/01    12/1/01
        - Coos Bay/North Bend


        Urban Transportation Model Development        9/1/01     6/1/02
        - Woodburn




        Urban Transportation Model Development        3/13/02   5/30/02
        - Roseburg


        Urban Transportation Model Development        5/1/02
        - Wilsonville

        Urban Transportation Model Development        6/1/02    12/31/02
        - Newberg

        Urban Transportation Model Development       12/31/02
        - Redmond




Revised 10/12/00
                                                     COMPLETED PROJECTS

         Urban Transportation Model Development         7/1/02    7/1/03
         - Brookings

         Urban Transportation Model Development         5/1/03    7/1/03
         - Central Oregon

         Urban Transportation Model Development         6/1/03    3/31/04
         - Klamath Falls

         Urban Transportation Model Development         5/1/04    6/30/04
         - Lakeview

         Urban Transportation Model Development        12/31/02   7/01/03
         - Grants Pass                                             8/1/03
                                                                  2/29/04


GIS19    Phase 2 -
         - Refine Database/Procedures
         - Final changes to database model
         - Deploy Road Authority Database to
           internet
         - Impliement Database
         - Obtain Data
            Wasco, Jefferson, Douglas, Umatilla,
            and 5 additional counties

DGIS12   TransGIS 2.1 to Web                            6/1/02    2/28/03
         Phase 1 - Develop test system
         -Provide TransGIS functionality in a web-
         based application utilizing ArcIMS.
         Phase 2 - Testing                              9/1/02    6/01/03
                                                                  6/30/03




 Revised 10/12/00
                                                         COMPLETED PROJECTS

         Phase 3 - Implementation                           6/15/03   10/1/03
         Reporting Functionality




         Phase 4 - Deployment and Training                  10/1/03   6/30/04
         Develop Data Maintenance Agreement

GIS25    Desktop GIS Routing Software                       1/23/03   12/31/03
                                                                       4/1/04
                                                                       5/1/04
                                                                       7/1/04


GIS30    Dynamic Data Display                               12/1/03   3/01/04
         Phase 1A - SRSAM                      6/18/03                4/15/04
                                                                      8/31/04
                                                                      9/30/04




DGIS16   Traffic Counting GIS Implementation   7/22/03     12/31/03   2/28/04
         Phase 3 -                                                    4/31/04
         - Create Internet viewing tool:                              6/30/04
         - Traffic Counts                                              9/1/04
         - Training & maintenance




 Revised 10/12/00
                                                                   COMPLETED PROJECTS

DGIS16   Traffic Counting GIS Implementation             2/1/04       4/15/04    6/30/04
         Phase 4 -                                                               7/30/04
         - Create Annual Volume Table                                            9/15/04
         - Create Annual Traffic Volume Flow Map                                10/15/04
         - Create standard queries




GIS28    Bridge Location Accuracy Enhancement            9/30/04     12/21/04
         Phase 2 - Improve location accuracy for
         remaining bridges & merge into 1 dataset




GIS34    STIP Mapping of Projects Identified by Area     12/1/04     12/31/04   2/15/05
         and unidentified project locations-Draft STIP
         06-09
         Phase 1 - Determine required fields
         necessary for new data and data sources.
         Setup database
GIS36    Alternate Route Mapping               01/04/05              06/30/05
         Phase 1
          Research and consolidate data to
         map all existing detour routes.
         Create a GIS layer to support Traffic
         Management activities for ITS




 Revised 10/12/00
                                     COMPLETED PROJECTS

GIS21   GIS Layers Complete
         Projects categorized as:
         OEM or Sm
           Assign sub-numbers

        (Quarterly drop-off cycle)
        (Mar-Jun-Sept-Dec)




Revised 10/12/00
                              COMPLETED PROJECTS

GIS21   GIS Layers Complete
          Continued




Revised 10/12/00
                                                     COMPLETED PROJECTS

GIS19   All Roads                             07/01/04   06/30/05   09/30/05
        Phase 3 -
         - Develop county-wide GIS data for
        Baker, Malheur, Harney, Lake and
        Klamath under TSD Safety Grant.
        - Load developed data that is
        available from other agencies (fed,
        state, and local).
         - Develop county wide GIS data for
        Grant, Hood River and Coos as part
        of additional OGIC funding.
         - Begin coordination of "edge
        matching" of road segments
        between road authorities.




GIS23   OEM & Small Projects
OEM      - Other projects completed by the
        GIS Project Team
        (Quarterly drop-off cycle)
        (Mar-Jun-Sept-Dec)




Revised 10/12/00
                                                     COMPLETED PROJECTS

GIS27   GeoSpatial Onestop                    01/23/03   04/30/03     5/30/03
         - Central storage & Web retrieval                            7/30/03
        system for transportation framework                           9/30/03
        layers                                                        7/1/04
        Phase 1 - Evaluation                                         10/31/05




GIS28   Bridge Location Accuracy              01/10/05   2/15/2005    6/30/05
        Enhancement                                      3/15/2005    7/31/05
        Phase 4 - Create metadata                                     9/15/05
                                                                     11/15/05




GIS39   Traffic Mobility Mgmt System          07/11/05   10/03/05    08/15/05
        Pilot
        Phase 1




Revised 10/12/00
                                                    COMPLETED PROJECTS

GIS04   Salmon Resource and Sensitive        04/01/02   01/30/04    12/31/05
        Area Mapping Project (SR-SAM)
        Phase 4 - Region 5
         - Deliver final version RES & RAZ
        maps to Maintenance and other
        staff


GIS28   Bridge Location Accuracy             01/10/05   2/15/2005    6/30/05
        Enhancement                                     3/15/2005    7/31/05
        Phase 4 - Create metadata                                    9/15/05
                                                                    11/15/05




GIS30   Dynamic Data Display                 07/01/04   10/31/04     3/31/05
        Phase 1B - Automated Straight-line                          12/31/05
        Charts (RICS Unit Production Line
        Enhancements)




Revised 10/12/00
                                                      COMPLETED PROJECTS

GIS37   Biological Field Data Collection       01/05/05   10/14/05   12/31/05
        Pilot
        Develop two proof of concept pilot
        projects using data, procedures and
        experience developed in SR-SAM
        Project. Pilots are wetland mitigation
        site monitoring and environmental
        scoping.




GIS40   TransGIS Development ver 2.2          07/11/05    08/30/05   11/01/05
        Phase 1




GIS42   TOC GIS Interface
        Phase 1
        - Complete




Revised 10/12/00
                                                       COMPLETED PROJECTS

 GIS 19   OR Trans (formerly All Roads,                     06/30/05   12/30/05
          formerly OTN)                                                 3/31/06
          Phase 3 -
          - Develop county-wide GIS data for
          Baker, Malheur, Harney, Lake and
          Klamath under TSD Safety Grant.
          - Load developed data that is
          available from other agencies (fed,
          state, and local).
           - Develop county wide GIS data for
          Grant, Hood River and Coos as part
          of additional OGIC funding.


 GIS36    Alternate Route Mapping               9/12/2005   3/1/2006   3/31/2006
          Phase 2
           - Create and populate a spatially
          enabled database with Marion
          County data to be available to
          ODOT TOC's as well as local
          authorities for even scheduling and
          routing.



GIS23-19 OEM & Small Projects (Cont)            5/18/2006 unknown      08/15/06
         GPS Access Management
         Demonstration Project




  Revised 10/12/00
                                                       COMPLETED PROJECTS

GIS04   (EDMS) Salmon Project
         Phase 1 - Region 2                  8/01/99     9/01/00    10/15/00
         - Development of base GIS/CAD
        data for Salmon Recovery Project
        for R2
GIS04   (EDMS) Salmon Project                 7/1/01     6/30/02    7/31/02
        Phase 2 - Region 1
         - Development of base GIS/CAD
        data for Salmon Recovery Project
        for R1


GIS04   (EDMS) Salmon Project
        Salmon Resource and Sensitive
        Area Mapping Project (SR-SAM)
        Phase 4 - Region 5
         - Deliver final version RES & RAZ
        maps to Maintenance and other
        staff

GIS04   Phase 6 - Region 2                   04/01/03    06/30/03   08/15/03
        - Delivery of Imagery
GIS19   All Roads
        Phase 1 -                            6/30/02     6/30/03
        - Develop data model, database,
           data collection procedures, and
           documentation
        - Obtain data
           Complete pilot for Wasco County
           Complete State Hwy's
           Complete Upper FC roads




Revised 10/12/00
                                                      COMPLETED PROJECTS

GIS19   Phase 2 -                              06/30/03   06/30/04
         - Refine Database/Procedures
         - Final changes to database model
         - Deploy Road Authority Database
        to
           internet
         - Implement Database
         - Obtain Data
         - Load 5 county/US97 corridor data
         - Develop county-wide GIS data
        (Wasco,
          Jefferson, Douglas, Umatilla,
        Sherman,
          Gilliam and 3 additional counties)



GIS22   ODOT Construction Plans and
        Right-of-Way Map Index



        Phase 2 -
        -To be determined




Revised 10/12/00
                                                    COMPLETED PROJECTS

GIS31   EnviroView - Environmental Data      09/25/03   01/23/04   3/31/04
        Management System                                          5/31/04
        Phase 1
          A- Access to existing software and
        readily available spatial data
          B-Web


                                                        06/30/05   12/31/08




Revised 10/12/00
                                                         COMPLETED PROJECTS

GIS28   Non State Hwy Bridge Location          07/02/03    03/01/04    4/1/04
        Accuracy Enhancement                                           7/1/04
        Phase 1 - Improving location
        accuracy for weight restricted
        bridges




GIS29   Truck Route Permit Mapping and
        Database
        Phase 1 - Map existing database        4/01/03     4/30/03    5/15/03
        Return mapped data to MC for
        review
        Edit using ArcExplorer and Access

GIS29   Phase 2 - Make correction after        05/01/03    06/30/03    8/15/03
        review                                                        10/15/03
        Create PDF files for publication
GIS32   Drainage Facility Management
         - Develop system for inventorying,
        evaluating and tracking condition of
        pipes, culverts and storm water
        facilities
        Bridge Location Accuracy               01/04/05    1/31/05
        Enhancement                                        2/15/05
        Phase 3 - Create 2004 GIS bridge
        file




Revised 10/12/00
                                                        COMPLETED PROJECTS

GIS29   Truck Route Permit Mapping and           11/01/03   03/04/04
        Database
        Phase 3 - Outline processes for
        maintenance by data steward (MC)

GIS34   STIP Mapping of Projects                 12/15/04   02/15/04   02/15/05
        Identified by Area and
        unidentified project locations-
        Draft STIP 06-09
        Phase 2 - Populate New Fields
GIS33   Two Year Implementation                  12/01/04   01/07/05   01/07/05
        Strategy for ESRI Software


        Phase 2 - Thematic Line Charts
        - Utility to add data themes as a line
        chart along the bottom of the SL
        sheet.
        Phase 3 - Corresponding Map
        - SL chart drawn with corresponding
        portion of county map along the top.
        Ability to export drawings to
        additional formats as determined by
        the project team.

        Phase 4 - 3D Enhancements
        - Online creation and viewing, with
        selectable data and map scale
        through the use of check boxes.
        Ability to redline/add user notes.




Revised 10/12/00
                                                      COMPLETED PROJECTS

        Traffic Counting GIS
        Implementation
         Phase 1 -
         - Create GIS layers (complete)
         - Review and Implement Data
        Distribution Model (complete)
         - Create metadata
         - Train TSM staff (complete)




        Phase 2 -                           07/22/03              10/31/03
        - Create GIS database of Counting                         12/31/03
          Equipment Inventory (ATR's)                              2/28/04
        - Training & maintenance                                   4/31/04


GIS42   TOC GIS Interface
        Phase 1
         - Complete
        Imagery Delivery System
GIS04   (EDMS) Salmon Project               6/30/04     6/30/03   9/30/03
        Phase 3 - Region 4                                        3/30/04
         - Development of base GIS/CAD                            4/30/04
        data for Salmon Recovery Project                          6/30/04
        for R4                                                    9/30/04
                                                                  12/7/04
                                                                  2/15/05




Revised 10/12/00
                                                    COMPLETED PROJECTS

 GIS21    GIS Layers In Progress              Ongoing   Ongoing   Ongoing
           Projects categorized as:
           OEM or Sum
             Assign sub-numbers (Sum)




GIS11-01 GIS Infrastructure Support (cont.)   Ongoing   Ongoing   Ongoing
         Training




  Revised 10/12/00
                                                    COMPLETED PROJECTS

GIS11-03 GIS Infrastructure Support (Cont)   Ongoing    Ongoing    Ongoing
         Customer Support




GIS23-05 OEM & Small Projects (cont.)        2/6/2006   03/05/06   12/31/2006
         Connect Oregon                                 Phase 1      07/1/06
                                                                    11/01/06




GIS23-07 OEM & Small Projects (cont.)        3/9/2006   6/1/2007    05/08/07
(TO #11) Water Withdrawal Permitting




  Revised 10/12/00
                                                          COMPLETED PROJECTS

GIS23-27 OEM & Small Projects (cont.)              09/01/06   02/01/07    2/1/07
         Asset Management Region 2 Pilot                                  6/1/07




 GIS16    Traffic Counting GIS                     12/01/04   02/28/05   6/1/20/05
          Implementation                                                  8/15/05
          Phase 5                                                        On Hold
           - Create data entry system for                                11/01/07
          traffic data
           - Create database tables, site
          inspection, vendor info.
           - Equipment Inventory Detail
           - Create data entry interface(s)) for
          equip inventory
           - Provide imagery linking & view
          options




  Revised 10/12/00
                                                           COMPLETED PROJECTS

GIS41    DMV Oregon Automobile Dealers           07/11/05    08/01/05   9/30/2005
                                                                         12/31/05
                                                                         2/01/06
                                                                         04/01/06
                                                                         06/30/06
                                                                         08/01/06
                                                                         10/15/06
                                                                         12/01/06
                                                                         2/14/07
                                                                         3/15/07
                                                                         6/11/07
                                                                         9/13/07
                                                                         10/30/07




GIS43    Crash Coding Tool
         - Create GIS application to assist in
         coding crashes

         - Workstation Based                     2/1/2007    4/1/2007

         - Web Based                              4/1/07     6/17/07
 GIS46 Traffic Counting Field Data               1/7/2007               08/01/07
(TO#10) Collection Conversion




 Revised 10/12/00
                                                        COMPLETED PROJECTS

GIS57   Import 2007 Traffic Count Data        3/10/08     4/15/08    6/1/2008
        - Import traffic volume data to                              07/01/08
        support 2007 production of data and
        publications



GIS53   GIS Right-of-Way Parcel Access        03/10/08    06/01/08   07/01/08
        - Provide public access to a subset
        of R/W data using a GIS Web
        Interface

GIS51   Traffic Volume Junction Analysis                  06/01/08   07/01/08
        - Analyze junctions of Hwys using
        GIS to check traffic volumes




GIS47   STIP TransGIS Scoping Tool            5/10/07     11/15/07   11/30/07
        Phase 1 & 2                                                  12/31/07
                                                                     03/15/08
                                                                      4/1/08
                                                                      6/15/08
                                                                      9/01/08
                                                                      9/30/08

GIS54   ODOT Solar Highway                    3/10/08      5/1/08    6/1/2008
        - Identify ODOT R/W that Solar                                7/31/08
        equipment can be tied into PGE                               10/31/08
        transmission lines




Revised 10/12/00
                                                             COMPLETED PROJECTS

 GIS50    Alternate Fuels Corridor - I5            1/10/08     2/29/08   2/25/2008
          Potential Sites Research                                        06/30/08
          - GIS map and database of all
          available sites associated with the I-
          5 corridor.

TO #23    Traffic Counting Application             1/3/07                3/10/2008
          Features Enhancement                                            06/01/08
          - Contractor will enhance application                            9/1/08
          used by field traffic counting staff                            12/29/08




GIS11-05 GIS Infrastructure Support (cont.)        Ongoing     Ongoing   Completed
         GPS Standards




GIS11-09 GIS Infrastructure Support                6/1/06      8/15/06     2/1/09
         SDE Implementation
         Spatial Reference
         Populate Database




  Revised 10/12/00
                                                 COMPLETED PROJECTS

GIS23-04 OEM & Small Projects (Cont)   1/11/06     3/15/06   12/31/06
         Traffic Counting Field Data                          06/1/06
         Collection                                          07/15/06
                                                             08/01/07




  Revised 10/12/00
                                                                           COMPLETED PROJECTS


                                                       Comments
Outside contracts reviewed. Software evaluated. Project Plan created. ARC IMS Web software received 9/25/00.
Installed and sent through NPE. Approval received to purchase software. Placed on hold for lack of resources.
Returned to active status 1/22/02. Draft of GIS Software Evaluation Guidelines presented to Steering Committee
3/28/02. Dennis will make revisions and bring to 1/23/03 committee meeting. Using purchase of SDE (spatial data
engine) GIS server software to develop and test process. (Will not work with OTS software). Used proposed
ArcSDE acquisition to demonstrate revised Life Cycle template which is currently being revised based on Steering
Committee feedback. Complete

TDD and ITS Unit developing project plan. Gave demo to ITS Unit and field
technicians. Waiting for data needs assessment from ITS Unit. Roll-out
database using Internet GIS viewing tool as pilot. Updating and cleaning data
for pilot. Delivered prototype to customer for testing. Java script rewritten. Roll-out to additional users, distribute to
ITS. The application has been delivered.

Met with Pavement, STIP coordinators, Intermodal (Freight), Congestion, Traffic Safety, Bridge and Transportation
Systems Monitoring. Re-scheduling to meet with Motor Carrier. Developing decision list to prioritize actions.
Integrating data collection and storage for this and Region 2 Corridor Planning. Demo to Steering Committee
3/22/01. Met with Mgmt. System Managers to review data requests and formats. Continue to enhance and add
features to the application (Shaded Relief, Print Functions, Save Settings, etc.). Work continues to enhance
performance and implement changes. Receiving data for all Hwy's: 2000 Pavement Friction, ITS Devices, partial
Bridge data for Hwy 162, ADT's and Speed data. Training complete, roll out from Mark Robinson on 9/28/01.
Complete 10/22/01 will be distributed to 60-70 additional users. In maintenance - to develop project plan for next
phase.


Conversion program from MGE to ArcInfo. Created Measured Shapefile that can be used in ArcView 3.1. Common
alignments, equations and z mileages all displayed correctly. Minor problems uncovered, approx. 150 points did not
plot. Documenting process, resolving problem areas. Testing by GISU is needed to determine if the file should be
made available to others throughout ODOT. Two measured shapefiles of the highway network were created in
January 2002 (1:24,000 network, production road network) with modified processes to improve accuracy. Testing by
GISU continues. Complete 2/28/02

Loaded on test machine. Resources are needed. Software ready for testing, loading 10/2/01. Software DLL
conflicts halted implementation. No conflicts in new version of software. NPE submitted and software testing is
underway. Metaweb and GeoConnect Admin Tools to be loaded when serial number is received from Intergraph.
NPE for new version complete. Loaded on test web. Bruce Westcott from Intergraph is working on problems with
software/hardware connections. Met with DBA and security on 5/3/02, web problem resolved. Testing under way
with Regions 1, 4 and 5. Change Mgmt. scheduled for May 28th, will then implement on production server.
Complete




    Revised 10/12/00
                                                                         COMPLETED PROJECTS

Software reviews complete, demo for Chuck complete, considering re-make of the Maryland model. City of
Portland's negative experience with the newest version of Intersection Magic and our crash data has discouraged its
use. Traffic Engineers requested that we create our own package. The decision was made to design a new
package using the Maryland system as a model. Complete

Prototype in place and will make it similar to the in-house application (Visual Basic). Possible software to use for the
actual drawing (Visio, MapObjects, MS Paint, etc.). 10/23/01 resources identified. Re-writing software. Working on
symbols to depict data. Should have prototype in May, first release in June and final release in September. Demo
for Traffic Managers meeting scheduled for June. Setting up two employees in Region 2 to test the application.
Delivered Beta version to R2 November 2nd. Testing and software revisions complete


Documentation nearly complete. Purchasing visio software. NPE review underway. Deploy 2 copies to each region
HQ traffic management staff. Visio software delivered, Documentation complete, demo to OTMS Steering Committee
3/27/03. Distribution in process. Complete

Replace SMMS 3.1 with SMMS 3.2. Migrate from SMMS database to an SQL server. An SQL (test) server has been
built and the SMMS 3.2 SQL version is being tested. NPE in progress. Currently being placed on the SQL Server
V7 (EXSQL7P2). Complete 6/12/01

Chuck met with DMV on July 18th to determine needs. Working on language breakdown. (I.e. Asian). System
delivered to DMV. In warranty mode. Complete 9/18/01 (80 hour project).
Resource materials have been acquired and sample sites chosen (The Dalles). Resources have been formatted into
standard/uniform projection. Project on hold, resources dedicated to GIS19. Project reactivated 11/10/02. Right-of-
Way images acquired. Adobe Photoshop software on order to complete processing. Pilot covered State Highways
in 1 city. Pilot demo Complete .



Extended close date 11/30/00. Data Model approved, test data base has been created. Transferring data to new
database. Creating Standard and user documentation. Transferring data to production database (State highways,
County Boundaries, City limits, ATR sites). Finishing User documentation.

(1) Most of the application functions are complete. Adding enhancements and fixes as identified by the GeoHydro
users. GeoHydro forecasts completion by January 2002. Hired temp for data entry. Complete 7/13/01.

2.) Coordinating integration of the GIS portion. Application complete and in testing phase. Maintenance of
aggregate source location data needs to be worked out between GeoHydro and the GIS Unit. Complete 7/13/01.




    Revised 10/12/00
                                                                         COMPLETED PROJECTS

3.) Script created to allow GeoHydro users to map data based on latitude and longitude values stored in the
database is waiting for review by Amy Landvoight and/or Mike Long. Scheduled review and acceptance June 7,
2001. Application is only for use by the GeoHydro personnel. Complete 7/13/01.
35,000 miles of road. 11/30/00 Attribution complete. Error checking in progress. Successfully developed and
tested the new MGE project and
access database. Complete 10/19/01.
Plus or Minus 40' of state highways. Complete August 2001.

(Dependant on the completion of GIS 17) Add new layers to GIS SQL database 6 at a time. Database modeling
and data acquisition is under way. Layers changed to meet the needs of the Conditions Report and TransGIS
version 2. Received 2001 Pavement Conditions data. Congestion data has been reviewed and released in
TransGIS 2.1. Congestion data is being viewed again. Re-visit corporate GIS base layers and bring back to Dec.
5th meeting. Project reassigned to GIS21. Descriptions and guidelines rewritten. Complete




Project Statement (002,026,028), Context of the System (140), Definition of the System/Subsystems (200/210), in
draft form awaiting approval. Began work on possible data model. Project Plan approved. Two prototype databases
created on SQL server 7.0 for evaluation purposes on 8/31/01. Testing prototype SQL server database (HGIS15a)
using COTS (commercial off the shelf) software. Querying, reporting and updating capabilities are being tested
using GeoMedia Pro, Access and SQL Server utilities. Database model has been updated, preparing documentation
(P Plus Deliverables 170, 180 and 190). Testing and migration complete. Complete


Partner with other authorities to build a GIS network of all Oregon roads. First project co-operative with University of
Oregon for completion of Wasco County. Contract review and data analysis took longer than anticipated, scope
was reduced. 6 target areas complete. Complete 6/26/01.

Phase 2 slightly delayed by other projects at the University; dedicated resources stretched thin resulting in attaching
attribution delays. Server crash caused some data loss. Other University obligations will end 10/5/01 at which time
work will resume. Met with the University on 9/24/01 to resolve delays in phase 2 and discuss a potential phase 3
(additional counties). Complete 12/28/01 data sent to GPL and T-FIT for review.

Test existing GIS software and databases. NPE and testing completed on all products. Complete

Implementation plans are being developed. Migrate software and databases to SQL V7.0 adding capabilities and
flexibility. Data structure modified and migrated to SQL 7. GeoMedia Pro is being used for production work.
Complete



    Revised 10/12/00
                                                                      COMPLETED PROJECTS

Database built and book published. Enhancements and updates are ongoing. Complete.
Met 9/24 to determine how to proceed with data compilation. Oregon Parks and Rec., ODOT Archeology and
Mortuary Board providing data. Fields confirmed at meeting. Verifying data entries. Completed GIS layer from
ODOT map base cemeteries.




Working with State Parks Div. who is adding Oregon Burial Guide cemeteries to our layer (additional 700 sites) and
BLM to build State Historical Preservation Office (SHPO). Complete




    Revised 10/12/00
                                                                COMPLETED PROJECTS

ATR 2002 locations (ATR's) (OEM) 10/02                                               Hillshade options (OEM) 10/04
ADT 2001 (Average Daily Traffic) (OEM) 10/02                                         Hwy Culverts less than 6 ft 10/04
ODOT Areas Boundaries (OEM) 11/02                                                    Hwy Culverts 6-20 ft 10/04
ASIS Aggregate Sites (OEM) 10/02                                                     Washington State Base Layers (OEM) 10/04
Hwy Milepost Locations (OEM) 10/02                                                   Environmental Justice 2K blkgrp 12/04
Schools Locations (All public schools) (OEM) 11/02                                   Bar Pts2 (Fish Passage Barriers) 12/04
Hwy Tenths for updated Hwy Network (OEM) 11/02                                       Zero Pop. Census Blocks 2000 12/04
US Corps of Engineers Navigable Waters (Complete 12/02) (OEM)                        Environmental Justice 2K trct 12/04
Crash Segs 2001 (SIP) (Complete 12/02) (OEM)                                         NGS monuments for 2003 (OEM) 1/05
Crashes 5-yr composite by region (Complete 11/02) (OEM)                              Pavement Conditions 2004 (OEM) 1/05
Highways-lane widths (Complete 11/02) (OEM)                                          Low Volume Pavement Conditions 2004 (OEM) 1/05
Highway-number of lanes (Complete 11/02) (OEM)                                       Annual Average Daily Traffic 2003 (OEM) 1/05
Culverts 2002 (Complete 11/02) (OEM)                                                 ATR 2003 (OEM) 1/05
Truck Safety Corridors 2003                                                          Flow Maps 2003 1/05
Truck A/M Corridors 2003                                                             Cemetery 2003 CAD extract 1/05
Culverts 6-20 ft (12/03)                                                             Hwy Posted Speed 2004 1/05
Culverts less than 6 ft (12/03)                                                      Railroads 2004 1/05
Highway Mileposts 2002 (Complete 10/02) (OEM)                                        NGS Monuments 2003 1/05
Unincorporated Urban Communities 2002 (Complete 11/02) (OEM)                         Low Volume Presrv Pave 2004 1/05
ODOT Regions Boundaries (Complete 1/03) (OEM)                                        Routes Cross-ref 2005 3/05
ODOT Districts Boundaries (Complete 1/03) (OEM)                                      Bridge Log 2004 3/05
Highway Friction Values 2002 (Complete 2/03) (OEM)                                   Tidegates 2003 2/05
Highway Skid Factors 2002 (Complete 2/03) (OEM)                                      Rest Areas 2005 2/05
Maintenance Crew Assignments (Complete 2/03) (OEM)                                   Waysides 2005 2/05
SPIS Sites (OEM) 4/03                                                                Hwy network Feb 4, 2005 2/05
Tsunami ODOT Inundation Line (GIS21-04) (sm) 3/03




   Revised 10/12/00
                                                                      COMPLETED PROJECTS

Complete:
 Access Mgmt ArcView (DGIS13-2) 11/01
 Or State Hwy No. conversion (DGIS 13-17) 8/02
 A* CARS ArcExplorer (and CD for home users) (DGIS14-2) 2/03
 A* Video Log-ArcExplorer Training (GIS23-05) 2/03
 D* Road Authority (GIS23-04)(Sm) 12/02
 D* City Annexation Data Modeling (GIS23-02)(Sm) (6/03)
 A* Software acquisition and distribution (Sm) (9/03)
 A* Standard Data Display and Formatting (Sm) (10/03)
 A* Upgrade Crash Coder Desktop GIS tool and User Guide (OEM) (10/03)
 D* Bridge Location Project (11/03)
 D* 650 Map Project (11/03)
 A* Bridge Location to Web (11/03)
 D* Mapping Speed-monitoring Loops in Metro area for Traffic Condition
Mapping project for statewide Tsunami exercise is complete. Maps show inundation line intersecting state highways,
and lifeline routes. Being tested in statewide earthquake drill April 2nd and 3rd. Complete


Project development nearly complete. Mixture of techniques used to accomplish project. Internet use not yet
approved. Draft model presented to ODOT end-users 3/20 by the IS team (Diane Powers). Waiting for XML
templates from IS Development Team. Network testing underway. Application and data complete and provided to
customer. P+ documentation in draft stage. Complete



Display Lat/Long coordinates and LRS in ArcView. The application is out for peer review. Ready to send through
product approval and Intranet roll-out. Going through NPE. (Complete)
Application complete. Ready to send through product approval and Intranet roll-out. (Complete)


Application complete. Ready to send through product approval and Intranet roll-out. Going through NPE.
(Complete)

Document approved on April 20, 2000. Distribution is being planned

Revisions made, forwarded to State Forestry for review. Complete and delivered to State Service Center and GIS
User Group.
User has accepted the ArcView Extension (application) software and installation instructions. Network testing of
extension is complete. Extension given to user.




    Revised 10/12/00
                                                                        COMPLETED PROJECTS

Create National Geodetic Survey benchmark layer for Geometronics in ArcView & MGE software. (Complete)


Software purchase complete, documentation under development. Roll-out scheduled to start the week of August
28th. Close after testing complete 10/10/00.
Quality check household activity locations from travel survey buffer points to create environmental design variables.


Building base layer of ODOT maintenance facilities (103) to satisfy Oregon's DEQ water permit requirements.
(Complete)
Produce presentation of output from first generation statewide model. Completed 11/1/00. Project Lead was Brian
Gregor.
Base year employment & housing distributions and network characteristics. Completed 6/1/00. Project Lead was
Sam Ayash.
Road layer comprised of State Highways and nonhighways Functional Class network, attributed with functional
class, number of lanes, posted speeds as available. Preliminary work should be completed by July 2001. Will be
migrated to statewide modeling software. Final review meeting scheduled in November 2001. GIS work for model is
complete.

Waiting for review from cities of the employment and household data. Recent vacancies in both City of Coos Bay
and ODOT Region 3 have slowed progress on this project. Employment and household data complete. Entering
traffic count data. Complete 12/31/01

Transportation Analysis Zones (TAZ) defined. Count locations submitted to Region 2. Employer and household
geocoding in progress. Region 2 will be hiring a consultant to perform field data collection. Employer and household
geocoding complete. Region 2 has contracted with consultant to perform field data collection. TAZ and Network
being finalized. Analyzing traffic counts to network links. Incorporated city's housing and employment revisions.
Complete
Scheduling with COG for update of existing model. Consultant compiling existing data. ODOT is collecting and
reviewing traffic count data. Updating population and housing data for consultant. Complete 11/02


Reviewing consultant data. Complete


Providing preliminary TAZ, model road network, employment and housing data to City for review. Incorporating city
housing and employment revisions and forecast data. Need City of Dundee to validate employment, household and
forecast data. Complete
Zone and network development in progress. Zones and network have been restructured. City has validated
employment and household data. Waiting for city to provide forecast data. Forecast data under development.
Complete



    Revised 10/12/00
                                                                       COMPLETED PROJECTS

Zone and network development in progress. Zones and network have been restructured. City has validated
employment and household data. Waiting for city to provide forecast data. Forecast data under development.
Complete
Complete


Zone and network structure under development. Base year data delivered to Region Planner to verify with local
jurisdictions. City and County are reviewing base year data. Traffic counts not yet complete. Counts complete and
forwarded to consultant. Complete
Developing base year GIS data. Complete


Working on schedule with COG to update existing model. TPAU compiling traffic count data. Region resources not
available, pending Roseburg completion. Delivered to the city for review. Study area has been significantly
expanded. On hold, waiting for forecast data. City has provided final base year revisions and are working on future
year. GIS work Complete

Phase 2 - Modifications to database will result from "lessons learned" in phase 1. Create & integrate data for 5
additional counties. Pilot to work out edge/overlap problems. Apply for pooled Fund SPR 4 OR-WA pilot and 03-05
OGIC grant. Database test results doc phase 1 and implementation plan for 03-05 biennium. Integrated data for
Wasco and Jefferson Counties 100%, Douglas 80% and Umatilla 100% complete. Data obtained from 16 to 18 local
road authorities. Data Dictionary 90%, Process Doc. 90%, Workplan (WBS) for 03-05 90%. All documents have
been sent to Implementation Sub-committee for review. DataModel v5.0 Schema released. Began Sherman and
Gilliam data creation. Working on piggybacking with BLM contractor. Load 5 data sets in the database and send
back to counties for review.


Phase 1 - Steering Committee approved project proposal on March 28, 2002. ArcIMS version 4 approved for use.
First phase will display mapping data like TransGIS. ArcIMS version 4 installed on sarscims server in October.
Templates have been created.
Complete
Phase 2 - Chuck will arrange for network test.
* Purchased production server
* Provide access for selected GIS Users (Susan will choose 20 test users, Chuck will provide the link for the non-
tabbed version to the test users)
* NPE testing in progress
* Sent to 33 test participants 4/30. Created invitation document, review template and how-to document.
* Additional software to be purchased
* New server up and running
Complete




    Revised 10/12/00
                                                                       COMPLETED PROJECTS

Phase 3 -
* Implement Reporting Functionality
* Software for production server ordered and delivered
* Production web server has been installed and configured with ArcIMS
* Rebuild development server
* Most display functions working
* Enhancements & revisions underway as a result of phase 2 testing
* Report generation in progress. Trying to find programmers with Web
  experience.
* Roll out to select group of users
Complete


Phase 4 - Developing strategy and schedule. Develop TransGIS to allow Project Delivery Company to access data.
Improved the User Guide and Help Functions. Released and on the Web. Training in progress. Complete

Kick-off meeting completed in April. Project delayed due to resources used for Microstation rollout. Project scope
has been limited to commercially available desktop applications. Stakeholders needs and Package Alternatives
documents are under development. Some of the evaluation software has been received. Stakeholder Needs
document complete. Collecting and formatting ODOT and commercial data for use in testing. Test plan and scoring
criteria are being developed. Complete

Phase 1A - Project request form revised and approved by Steering Committee. Straightline Chart User's Focus           Phil Smith
Group met 8/03. Project statement (002, 006, 026, 028) approved. Solution Assessment Survey draft complete.
Application developer selected, development phase in progress. Met with ESRI Corp. and Intergraph Corp. for
additional solutions and ideas for future phases. Visio and MicroStation file exchange test (P750S, P770S) draft
completed. Definition of system draft, subsystem, system functions complete and in progress. Automated
Straightline Application version 1.0.0 released on April 15. Have compiled and forwarded to developer for code
revision. Additional application enhancements are underway in three main areas: (1) meet straightline depiction
requirements (2) tighten product integration of version 1.0.0 output with existing SR-SAM RES and RAZ map
products for GIS Unit production environment. (Completed 12/4/04)


Phase 3 - Five product 'shapefiles' complete (traffic counts and locations) adding to Intranet TransGIS tool. Truck   Sue Mead
'Flow Map' and GeoMedia process instructions in progress. Shapefiles in revision to change format and
representation as well as naming conventions. Training in progress to perform GIS spatial data maintenance and
network completeness routines. Foxpro data moved to MS Access format. Equipment inventory is on hold until
annual reports and GIS map production is complete. Equipment inventory moved to related phase (5). The data is
available in TransGIS and the corporate data server. Complete




    Revised 10/12/00
                                                                        COMPLETED PROJECTS

Phase 4 - The data (TVTbl) has been reformated for standard spreadsheet use and no longer maintained in FoxPro.            Sue Mead
Additional data review complete (FC update). Data cleaning done. Data updates for 2003 will be input by the end of
May. Volume tables are being drafted. Resources are limited but efforts will resume in May. The GIS database has
been updated with 2003 figures and the TVT draft prints are in review. Data is processed through GIS mapping
software before Flow Map is created. TVT's in final review 6/15/04. Testing for overlaps and gaps. Constructed two
standard queries, TVT report and Flow Map Data for Dynamic Segmentation. Documented business processes.
Report for Traffic Volume Table publication is complete 9/10/04. Flow map complete. Standard queries to create
volume table and flow map publication complete, output was used to create this years publications. Complete


Phase 2 - Phase 1 of the Bridge project located approx. 9000 of the 10,000 bridges that are in the Bridge Mgmt. Sys.
database. The 917 or so remaining bridges were not part of of the original data set because they didn't have a
lat/long. Phase 2 of this project is focused on placing those 917 bridges using only desc. contained in the data.
Work is complete on 590 (64%) of the 917 bridge records as of 9/9/2004. The remaining bridges are primarily local
and culverts (over 6') that, based on the desc. and avail. info., are increasingly more difficult to assign definition
locations. These may be candidates to go to the counties for accurate location. The remaining 327 structures will be
researched by Bridge with field visits or by contacting the agencies with jurisdiction over the structure. Passed
database back to Bridge for incorp. into Bridge Databases. This project was successful in cleaning up coord. values
and other related data such as whether the structure is on the NB or SB side of the hwy. New coordinates were
incorporated into the Bridge Log Database. Complete 12/31/04.



Approximately 500 STIP projects need to be mapped with 900 different locations. Some STIP Projects have multiple
locations. Many of the projects are not on the state system. (Completed 12/30/04)




A meeting was held with Mike Sniezak and Marcia Malstrom to assess the needs of the project.                             Darlene Gowen
An initial scope of the project was outlined. Next meeting to be held January 21st, 2005 will
include individuals from IS, Incident Management, RICS and GIS. Project needs to be redefined
and brought back to the GIS Steering Comm. due to scope change. Revised project request will
be presented at May 12th meeting. 7/05: Complete




    Revised 10/12/00
                                                 COMPLETED PROJECTS

Hillshade options (OEM) 10/04
Hwy Culverts less than 6 ft 10/04
Hwy Culverts 6-20 ft 10/04
Washington State Base Layers (OEM) 10/04
Environmental Justice 2K blkgrp 12/04
Bar Pts2 (Fish Passage Barriers) 12/04
Zero Pop. Census Blocks 2000 12/04
Environmental Justice 2K trct 12/04
NGS monuments for 2003 (OEM) 1/05
Pavement Conditions 2004 (OEM) 1/05
Low Volume Pavement Conditions 2004 (OEM) 1/05
Annual Average Daily Traffic 2003 (OEM) 1/05
ATR 2003 (OEM) 1/05
Flow Maps 2003 1/05
Cemetery 2003 CAD extract 1/05
Hwy Posted Speed 2004 1/05
Railroads 2004 1/05
NGS Monuments 2003 1/05
Low Volume Presrv Pave 2004 1/05
Routes Cross-ref 2005 3/05
Bridge Log 2004 3/05
Tidegates 2003 2/05
Rest Areas 2005 2/05
Waysides 2005 2/05
Hwy network Feb 4, 2005 2/05
STIP 04-07




  Revised 10/12/00
                                       COMPLETED PROJECTS

Traffic Volume 20 yr projn 2022 2/05
Traffic Volume 20 yr projn 2023 2/05
Pavement Conditions 2004 2/05
Detour Rt. for Mt. St. Helens 2/05
Urban Growth Boundary 2004 2/05
Crashes 2003 2/05
DRAFT STIP 06-09 5/05
SIP Segs 01-03 05/05
City Points 05/05
Railroads 2004 1/05
ATR 2004 (OEM) 6/05
AADT 2004 (OEM) 6/05
Flow Map 2004 (OEM) 6/05
SPIS 01-03 (OEM) 6/05
Mileposts 2005 (OEM) 6/05
Hwy Ones 2005 (OEM) 6/05
Hwynet 2005 Annual (OEM) 6/05
Rest Areas 2005 (OEM) 6/05
Multnomah Imagery (small) 6/05
Clackamas Imagery (small) 6/05
Non Hwy Bridge Scour A, B, C, D 6/05




   Revised 10/12/00
                                                          COMPLETED PROJECTS

Phase 3 - ODOT has committed to develop 4 counties worth of road centerline data by June
30, 2005 under a grant from OGIC for $100,000. The work is divided between three
contractors: UofO, Central Oregon Community College and BLM. ODOT has received a grant
from the Traffic Safety Division for $80,000 to develop 5 additional counties of data (Morrow,
Malheur, Harney, Lake and Klamath). Under these two grants a total of 9 counties worth of
road centerline will be developed. BLM contract signed. Meeting with Central OR Comm.
College (COCC) to finalize details of the contract on 2/28. The All Roads db is rebuilt and
existing GIS data is being loading. We are also acquiring updated data from USFS, BLM and
counties. UofO is 80% done w/ Union Co. Loading of GIS data continues. IGA is being
developed with Curry county for road centerline development. COCC contract signed (See
status map).




Complete:

A*D* Traffic Mobility 'War Room' GIS capability and data development (6/05)




   Revised 10/12/00
                                                          COMPLETED PROJECTS

Phase 1 - The Open GeoSpatial Consortium has been contacted. Greh Beuhler forwarded
ODOT's request for a demo of the GeoSpatial One Stop (GOS) to Sam Bacharach. He stated
that OGIC is in negotiations with USDOT for outreach work and that a demonstration on the
West Coast might be a good addition to that. He asked if ODOT was interested in hosting such
a demonstration. We are interested. Attempting to contact project staff to determine status of
project. We have contacted Cy Smith to see if he can help obtain information about the project.
We have contacted Intergraph for assistance. I have sent multiple emails to David Kingsburry
about his contact with GOS and I have not had any response from him or Pamela Siminitz of
GOS. 7/05: Waiting for a response. Cy Smith is researching status of project. 9/08/05:
Waiting to hear back from Cy. 11/10: Received approval from Cy to redeploy server.


In Progress- Need some of Bridge staff time. They are working on other data needs at this
time. Bridge Section staff turnover has slowed project. Time has been scheduled for Bridge to
learn the software and work with GIS to complete the metadata. 7/05 : Bridge Section has
taken instruction and template for metadata completion. SQL database has been moved and
updated, licenses for new software received and software has been installed on staff
workstations. Metadata data entry can now begin. 9/08/05: Bridge staff has received training
to create Metadata. Metadata created and awaiting validation and publishing. This will
complete the project. 11/10: Metadata is in final correction phase.
7/05: Coordination underway - target dates will be identified.
GIS worked with Motor Carrier IS on query result transfer from web application. Results
passed via Python, opening ArcGIS software, sending data to GeoDatabase (MS Access),
dynamically segmented and zoom to query area. Waiting for refinement instructions and
working out security/permissions issues 9/08/05: Phase 1 nearing completion. GIS Unit has
conduct 6 training sessions for customer. Phase 2 project proposals under development.
11/10: Phase 1 complete.




   Revised 10/12/00
                                                             COMPLETED PROJECTS

7/05: Initial RES map production complete and PDF generation in progress, RAZ Workshop
scheduling to start soon. 9/08/05: Phil will be meeting with the District Staff in Pendleton, La
Grande, Ontario throughout the month of September. 11/10: RAZ workshops for Region 5 are
complete. RAZ data entry and map revisions have begun. 1/12: Final version map production
complete, distribution complete, Phase 4 complete.



In Progress- Need some of Bridge staff time. They are working on other data needs at this
time. Bridge Section staff turnover has slowed project. Time has been scheduled for Bridge to
learn the software and work with GIS to complete the metadata. 7/05 : Bridge Section has
taken instruction and template for metadata completion. SQL database has been moved and
updated, licenses for new software received and software has been installed on staff
workstations. Metadata data entry can now begin. 9/08/05: Bridge staff has received training
to create Metadata. Metadata created and awaiting validation and publishing. This will
complete the project. 11/10: Metadata is in final correction phase. 1/12: Project complete as of
11/15.

Phase 1B - Add features to depict interchange diagram and locator map images, calculate
summary tables, and improve scaling to allow Straight-line production for RICS Unit to remain
in Visio application environment from start to finish into version 1.3.0. 7/05: Project is now active
and being worked. 9/08/05: Working on the last set of deliverables. 1/12: Complete




   Revised 10/12/00
                                                          COMPLETED PROJECTS

Staff from GIS Unit, Contractor and Geo-Env met 1/5/05 for initial project kickoff and user
needs assessment (UNA). Contractor will continue dialog and development in coordination with
Geo-Env staff. Second UNA for Regional Environmental Coordinators (RECs) conducted
2/1/05. Contractor, GIS Unit staff and Geo-Env staff will continue coordination and
development. 7/05: Contractor's principal staff managing project have left project, new staff on
board. Despite the changes the project remains on schedule. 9/08/05: Initial field trials with
ODOT Geo-Env staff and consultants are scheduled for 9/9-9/22 time frame. Results will be
reported to Geo-Env GIS Committee via their Data Collection Process Review Template. 11/10:
Data Collection Process Review Template complete and submitted. Preparation for second set
of field trials underway. Final report and training sessions are under development. 1/12:
Deliverables received, project complete. Report will be distributed to GIS Steering Committee
prior to 3/9/06 meeting.
7/05: Enhancements underway, communication and training outline complete. Coordinating
with OBPD on transfer of parametrix TransGIS to ODOT. Purchased additional software to
support phase 2. 9/08/05: Due to competing priorities project is delayed. 11/10:
Enhancements are under way again. The new legend now has the ability to turn on labels from
the legend. Currently the only Generic page has the folder and labeling features at this point.
The other pages have been modified and are awaiting updates to the HELP feature and the
changes noted in "What's New". The hardware purchase to facilitate the transfer of Parametrix.
TransGIS to ODOT has been approved and is now awaiting DAS approval. A demonstration to
the Project Leader Quarterly Meeting is scheduled for 10/27 to determine what GIS data could
assist PL's on project scoping. 1/12: Phase 1 complete.

7/05: Coordination underway - target dates will be identified. 9/08/05: The TOC replacement
project is still in the planning and architecture scoping stage. GIS Unit staff have met with
project team and consultants to discuss options for GIS interface. A test application has been
successfully tested to determine if the GIS software can handle the anticipated load. No target
end date has been established. 11/10: Waiting for TAD to provide data for GIS display. 1/12:
Project will include proof of concept to determine interoperability of MapObjects (MO) and
SDE/SQL using GDT data. It's anticipated this activity will be complete 2/1/06. 3/9: Phase 1 -
Pilot proof of concept completed on schedule. Project now exploring software, data, and
interface options with TOC Project staff.




   Revised 10/12/00
                                                            COMPLETED PROJECTS

In June we assumed the task of developing three additional county datasets. Census was
scheduled to complete this work but was unable to meet tour timeline. We were unable to
complete the three, Tillamook, Coos and Grant counties by 12/31/05. The estimated time for
delivery of the data is the end of January 06. There will be a couple weeks of QA/QC and
question resolution and those datasets, along with Columbia county, which is being done by the
county should be loaded in the database by 3/31/06. 3/9: U of O - Tillamook completed by mid-
March. BLM - Coos completed by mid-March. GeoSolve - Grant and Columbia completed by
mid-March with Hood River delivered late March. *Note* GeoSolve contract under the authority
of OEM and GEO, completion times are estimates. 5/11/06: Phase 3 Complete.




11/10: Actively working on the project and is on schedule for completion date. 1/12: The
database structure for GIS36 is nearing completion. The process of populating the database
with emergency contact information will begin. 3/9: Phase 2 was intended to be focused at
Marion County as a pilot, As we received data from other regions it became apparent that we
could not build a database limited by the needs of the pilot. A prototype database is currently
being tested in Regions 2, 4 and 5. Region 3. ITS is managing the distribution of the database
application to the regions and the collection of feedback by March 3rd. 5/11/06: Prototype has
been revised and is being deployed and used for data collection. Data collection will occur until
Alternate Route Mapping Porject is rolled into the TMOC Project. ~ '07. Phase complete


7/13: GIS Unit processed GPS data from 'conditions report' data collection effort, identifying all
access points on selected highways. GPS mapping compared to Permit Specialist location data
(CHAMPS). Quality, validity, record matching needs under analysis. Region 1, Access
Management and GIS management planning additional meetings. Completed 09/01/06 .




   Revised 10/12/00
                                                          COMPLETED PROJECTS



Phase 1 - Delivered GIS produced resource maps to Dist. 3, 4 and 5 (Region 2) Received
partial data, anticipating full data next week. Copying in process, computer work complete.
Complete

Phase 2 - Delivered GIS produced resource maps to Dist. 2a, 2b and 2c. Region 2 imagery
delivered. Funding for Region 1 resource map restored. Restricted Activity Base Maps are
created and awaiting data. Budget meeting with funding source and Environmental held
11/21/01, results indicate an impact on phase 3 (Region 4&5). Requested Salmon data from
Brenda Z. Data plotted, delivered to Environmental. Sent to field for review. Final product
delayed until July due to late delivery of data. RAZ maps out to Region 1 for review. Complete

7/05: Initial RES map production complete and PDF generation in progress, RAZ Workshop
scheduling to start soon. 9/08/05: Phil will be meeting with the District Staff in Pendleton, La
Grande, Ontario throughout the month of September. 11/10: RAZ workshops for Region 5 are
complete. RAZ data entry and map revisions have begun. 1/12: Final version map production
complete, distribution complete, Phase 4 complete.




Phase 6 - Sid imagery for Regions 1,2,4 and 5 delivered and installed on Intranet. Tiff imagery
being loaded on network server. Complete

Phase 1 - Data model v4.5 is completed, approved by Internal Review Team. Data has been
loaded and tested. Evaluation of input and output underway. Completed pilot for Wasco
County. Addressing took a majority of the time in the Wasco County project. Addressing will
done later in future counties so a road network can be completed faster. Complete




   Revised 10/12/00
                                                           COMPLETED PROJECTS

Phase 2 - The All Roads database was changed as a result of issues while loading the 5
county/US 97 corridor data. The five counties that were loaded for this phase were Wasco,
Jefferson, Deschutes, Klamath and Lane counties along with the ODOT highway data. ODOT
has submitted a project proposal to OGIC for continuation of data development on other
counties. Work for 2004 complete. We have a signed project proposal to work on creating
data for 4 additional counties over the next year. The additional counties will be worked on by
U of O or BLM under contract with ODOT. Working to load data currently available from local
road authorities into All Roads database. These local authorities include up to 13 road
authorities that have GIS road data available in some form. Complete




03/06 Continue development of state-wide addressing for 911 center needs. Work will be
coordinated with OEM and its contractors. Additionally work will continue on assigning
and/or improving the county road numbering system for the county owned roads. This
work will include a pilot coordinated thought AOC and Wasco County Road master.

1/12: Work continues to be done on a software solution to allow road authorities the
ability to "check in" and "check out" data through a web interface for a pilot project with
King and Pierce County. The source code for this ability is being developed through an
existing contract between WashDOT and ESRI. The goal of this pilot project is to
develop code that uses data translation technology so that the source code can be
slightly modified to work with various GIS data and GIS database formats. 3/9: Will
provide update after the GIS-T meeting to be held later this month in Ohio.




   Revised 10/12/00
                                                          COMPLETED PROJECTS

Phase 1 - ArcView 3.3 upgrades or installs have occurred on most computers in Env.
Section. Workshops are being held. Some Env. Section staff are beginning to use
ArcView to produce reports. GIS Unit staff gathering necessary data and making it
available on the ODOT Intranet. More than a dozen brown bag workshops complete.
Future workshops on hold because of the SRSAM project. Work continues on
modifying ArcView to enable easy access to environmental data. Processes that can be
accomplished w/TransGIS will be identified, TransGIS development will be emphasized.
Testing in progress. Complete
1/3/07: Meeting in Wasco resulted in interest of crash coding program and developing
additional data needed for crash coding and sharing existing data. Meeting in Pendleton to
develop web site for data users and contributors resulted in designs that addressed needs of
participants. Code will be written to create what was designed and testing will be preformed on
resulting web page. Upon successful loading of OR-Trans staging database into production
working database QA/QC will begin. Looking to move production working database to newer
version of SQL to insure continued support. Checking on software compatibility w/ SQL 2005.
3/8/207: Some of the first QC work will begin on the state hwy system and where it intersects w/
local roads. This will include matching the hwy network to the Upper Functionally Classed
roads through Task Order. QC work will also begin to identify where jurisdiction cannot be
determined and data contributors will be asked to identify those roads that lack a jurisdiction
designation.




   Revised 10/12/00
                                                           COMPLETED PROJECTS

Phase 1 - The Bridge Section and GIS unit entered into an agreement whereby the GIS unit
would geolocate each of the approx 10,000 bridges (including sign bridges and large culverts)
throughout the state using USGS digital ortho photo quads, digital raster graphs and ODOT
salmon color infrared imagery as necessary to accurately locate these bridges. The latitude
and longitude would be calculated using GIS software and lat/long values would be returned to
the Bridge section for review. Locations for all bridges statewide has been completed and
delivered to ODOT. We have forwarded data to the Bridge group for review and comment,
when accepted we will use the GIS software to generate a new latitude and longitude and
deliver coordinates that they will use to update their current coordinates. The adjusted end date
was met for delivery for Phase 1 however, the work being done was well beyond the scope of
Phase 1 and is actually part of Phase 2.
Complete




Phase 1 - The Steering Committee suggested moving to SQL - the Project Team determined
to do this as part of the enterprise routing project. Data mapped and sent to data steward for
review. Complete


Phase 2 - Templates created while data is being edited and reviewed. Review depends on
customer availability. Complete

OTMS to build database. Possible future GIS interface. Geo-Env currently doing field
culvert surveying and entering data into a user-built Access database in the interim.




In Progress. The Bridge 2004 file and will include off and on Highway System bridges.




   Revised 10/12/00
                                                        COMPLETED PROJECTS

Phase 3 - On Hold - Motor Carrier is starting to maintain & update database. Route maps
ready for State Printer. Completed 4 separate MAP/GIS Layers, 1 in progress. Motor Carrier
resources have not been available. Dennis will meet with Mike Bollinger to determine
direction.

Completed about 650 of the 948 records. (Completed on 2/15/05)




Draft Complete, out for review. Strategy has been reviewed by GIS Leadership and GIS
Project Team. Implementation under way. Completed on 1/7/05. Reported to Steering
Committee on 3/4/05.

Phase 2 - Planned




Phase 3 - Planned




Phase 4 - Planned




   Revised 10/12/00
                                                           COMPLETED PROJECTS

Phase 1 - GIS Unit's function is instructional and advisory. ArcExplorer training
continues. Table/data consistency under review as part of TransGIS update. Basic
training complete. Advanced training necessary for database modeling and GIS
enhancement. Additional resources to be dedicated to database issues. FTE dedicated
to mapping Non-state Highway count sites. TVT counts added to TransGIS. Added
value to 568 vehicle class count locations and mapped them. Maps for Sequence 2 sites
are in progress for field tech validation. ADT/TVT/ATR data being processed. GIS Unit's
function increased from advisory to data model drafting, presentation research
(TransGIS display and field staff interface) and data maintenance instruction using GIS
tools. Complete


Phase 2 - Database integration and relationships under way. Forms and queries in
development. Data cleaning under way, element relationships being developed. Additional
relational tables are being created to allow for proper output of data vs. headings. Complete




Phase 3 - As of July 2002 post-field processing occurring for Region 4. The budget impact
noted in phase 2 significantly delayed post field processing and may affect ability to meet target
date. Cost savings were realized from contractor using ODOT Hwy network file. Resource
data received, map prep underway. Issues with resource time and availability. RES maps were
produced for the entire Region. RAZ workshops complete for The Dalles, Klamath Falls,
Lakeview and Moro maintenance areas, Prineville and LaPine scheduled for January and Bend
in May. RAZ map production wrapping up, out for review by 8/30. Database entry and QA
complete, RAZ maps complete and sent to Maintenance Managers for review. Maps returned.
Final maps under production. Complete and distribution underway.




   Revised 10/12/00
                                                                     COMPLETED PROJECTS


Exits and Interchanges 2006 (Sum)
Oregon Auto Dealers 2006 (Sm)
House and Senate Districts 2006 (add phone and names) (OEM)
Vehicle Class 2005 (OEM)
Flow Map 2005 (OEM)
Truck Flow Map 2005 (OEM)
Rail Crossings 2005 (OEM)
Non-hwy roads and road text from CAD 2006 (Sm)
Highway Tenths 2006 (Sm)
WIM count location 2005 (Sm)
Access Management Approach Permits Fall 2006 (Sm)
County Boundaries (OEM)
Half Meter NAIP Imagery 2005 (SID mosaics) (Sm)
Highway Ones 2006 (Sm)
Highway Fives 2006 (Sm)
Highway Tens 2006 (Sm)
Highway Tenths 2006 (Sm)
Freight System Highways 2006 (Sm)
Bridges 2006 (OEM)
Pavement Conditions 2006 (11/06) (OEM)
Right of Way Image Index
Reg2 Pilot (3/07) (Sm)
Flow Map 2006
Vehicle Class 2006
ATR 2006
  GIS techniques for Wetland Specialists (delivered by Casey Ragain) (8/24)
 Data Formatting techniques ('B' McConnell & Diana Mann) (08/06)
 ArcGIS Intro for Anne Batten, Wade Atkines (08/06)
 NW MapBook for C. Crockett, R. Johnson & D. Gowen (11/06)
 ORMAP Version for C. Crockett, R. Johnson & D. Gowen 11/06)
 ArcGIS Tools and Techniques (Mike. Chad C.)
 Map2PDF - various staff (10/06)
 National Hydro Dataset - various GIS staff (11/06)GIS techniques for Wetland Specialists (delivered by Casey
Ragain) (8/24)




    Revised 10/12/00
                                                          COMPLETED PROJECTS


129 (01/06)
 42 (04/06)
 25 (05/06)
 30 (06/06)
 70 (07/06)
 86 (08/06)
 76 (09/06)
 80 (10/06)
 52 (11/06)
 30 (12/06)
5/11/06: Additional projects have been added to database by customer. Database and mapping
work continues. 7/13/06: Database and ArcReader products complete. Customer now working
with TransGIS team to develop Web GIS tools. Phase 2 9/14/06: Working with customer to
update GIS file and related maps. Customer will work with TransGIS team to establish needs.
11/9/06: Further mapping pending receipt of data from OECDD. 1/03/07: No change and No
requests at this time 2/21/2007: TransGIS team is working with customer to determine if
updates to current layers are needed. 3/8/07: Final map to Legislature January 29, 2007.
(complete)
3/9/06: Met with ODOT Maintenance and Water Resource Department (WRD) to assess
requirements. WRD will accept GIS data as "map" for permit requirement. 5/11/06: GIS data for
permit request has been produced, reviewed by Maintenance and delivered to Maintenance.
Project will see no activity until WRD returns results of submission. 11/20/06: WRD has
responded to ODOT submission. Preliminary SOW submitted to several contractors for
estimate.11/20/06: WRD has responded to ODOT submission. Preliminary SOW submitted to
several contractors for estimate. 1/11/07: Contractor selected, statement of work and task order
is complete, Notice to Proceed anticipated soon. 3/8/07: Notice to Proceed issued, DRAFT
products received, reviewd and accepted. Contractor proceeding with production. 5/10/07:
Final maps received from contractor and delivered to customer. Customer has reviewed
and accepted. Project complete.




   Revised 10/12/00
                                                            COMPLETED PROJECTS

10/01/06: Data collection complete. Project team cleaning and standardizing data. 11/01/06:
Data being mapped. 12:01/06: Data analysis and GIS presentation being defined. 01/03/07:
Needs Assessment complete (data identified for uses by GIS community). Data will be
extracted according to various requirements, symbology will be established and data will be
passed to TransGIS programmer for implementation. 2/21/2007: Initial delivery complete - in
conversion of data layers to TransGIS some symbology changes are underway. 3/8/07: All data
processed. Map/symbology established and provided to ArcIMS programmer. Consultation
continues to be provided by GIS Unit. 5/10/07 Met with customer who had additional
requirements for the web version. This was primarily symbology and layer color
changes. TransGIS's Asset Management System will be updated and this will complete
the project.
5/11/06: Determination was made to use ITS Asset Inventory software. This software will also
be used to track signals. A future project will be to develop a GIS interface. This project will be
closed until that request is made. 7/13/06: Maintenance Work: Data Entry Interfaces have been
updated to connect to new database format. Traffic Volume Report is functional. Data entry in
progress. Resources intermittent due to TSM staff change and the number of projects in
process through the GIS Unit. 9/14/06: Looking at ITS Software for tracking Traffic Counting
Assets. May not need this project. 10/31/07: Remaining tasks were moved to GIS46 TO #10.




   Revised 10/12/00
                                                           COMPLETED PROJECTS

9/14/06: DMV utilized 'Code 1' address cleaning software to improve location information.
Duplicate data was discovered and removed. DMV is matching previously encoded
latitude/longitude derivation and adding it to their new 'location' table. DMV is defining new
queries for simple extracts which will be provided to the GIS Unit for geocoding. DMV is
delighted with the quality of the refined database and confident in the new process. 11/01/06:
Data provider is defining appropriate display fields. Data expected to be received by 11/15/06.
Geocoding will take approx 40 hours. Geocoding will take approx 40 hours. 01/03/07: Data
received. No resources available to Geocode. 3/8/07: Geocoding in process. Approx 50%
complete. 5/2/07: Geocoding complete. Data provided to customer in ArcExplorer project for
review. Customer resources not available at this time. 5/10/07: Met with customers and have
delivered a web-based prototype. Another meeting is scheduled to demonstrate the tool and
refine the requirements. 7/9/07: Data
decoding completed and provided to TransGIS. 9/13/07: New extract
delivered to GIS, formatted and provided toTransGIS. Project Complete.
11/8/07: Met with customer and received approval of "simple"
version. Small adjustments to site and this is complete.

This project will create a TransGIS tool which will locate crash sites and collect codes for 25
attributes from ODOT’s GIS system. 03/06/07: Project Kick-off meeting complete, necessary
data identified, TransGIS application under development. 5/10/07: Completed - A stand alone
application of the Crash Locator Tool is currently in the ICARE process. (Complete). A
secondary web version of the tool is in development and will be implemented this month.
11/8/07: Completed and in production - enhacements may follow.

11/28/06: Approved at GIS Steering Committee 1/5/07: Met with Alsea Geospatial who
demonstrated existing application called Incident View developed for local emergency
responders. By adapting this application our project cost will be reduce by 50% from initial
estimates. Rewriting Task Order to use Incident View program technology. 3/8/07: Data
provided to consultant. 5/3/07: Consultant delivered alpha version to TSM for review. 8/30:
Received final version of product, in testing phase. 10/29: Project Complete




   Revised 10/12/00
                                                           COMPLETED PROJECTS

3/20/08: Project underway. 4/4/08: ITIS updload and calculations must be completed by
customer before project continues. 04/15/08: Data load to I.T.I.S. in progress. 5/09/08: I.T.I.S.
load complete. Data import to Traffic Database in progress. 6/5/08: Data import complete.
Query updated for 2007 extracts and TVT report in review. 7/09/08: TVT still in review and
being edited by customer. Map processing cannot continue until data is finalized. -
Completed 7/1/08
3/11/08: Prototype developed. Business refining requirements.
- Complete 7/1/08




3/20/08: Waiting for allocation of resources. 4/4/08: Meeting scheduled with customer to
discuss goals. 4/15/08: Needs defined. COTS solution in review. 5/09/08: FME solution
developed and in review. 6/10/08: GIS unit developed application. Customer can decide
whether analysis should be for total volume or any subset (such as trucks). GIS
automating tools for customer.
- Complete 7/1/08
1/3/08: Tested revised tools and database management. Preparing web accessible instructional
resources. Base software installs are complete. Tools are being distributed to customers.
2/20/08: Distribution of tools continues. 3/20/08: Distribution of tools continues. Most delay due
to FSU resourcing for software installation. 4/4/08: Distribution continues. FSU Software installs
slow. 4/15/08: Distribution continues. Software installs nearly complete. 5/09/08: Completing
distribution and preparing survey for user feedback. 7/09/08: Distribution continues. 25
customer installs remain. 11/12/08: Distribution complete for pilot project customers.
Project complete.
3/20/08: Experiencing problems obtaining data from PGE (Portland General Electric). 4/4/08:
No data from PGE. 04/15/08: Data received. Site maps in progress. 5/09/08: Data analysis and
mapping in progress. 06/18/08: Data processing has increased due to data limitations.
Additional map production required from GIS staff to provide detail for analysis. 10/13/08: Final
maps in production. Analysis review scheduled. This will complete the project as described.
11/12/08: Complete. Maps produced and delivered to customer.




   Revised 10/12/00
                                                         COMPLETED PROJECTS

2/25/08: Project Complete. 4/15/08: Customer utilizing data and tools. Training set for map
production tool. 6/5/08: Project database and security developed for customer use during
research phase. Data use restrictions prompted this action. Customer continues
research and mapping. Field work and site decisions planned for completion by
customer, end of June 2008. 06/30/08: Maps completed (by customer) and database in
use for various tasks. Project Complete.
1/3/08 - Project approved. 2/25/08 - Data provided to consultant. 3/7/08 - Project due to be
delivered week of 3/10/08. Software delivered, working on software version issue. 4/18/08:
Software out of iCARE. Working with contractor to fine tune bugs with program. 6/25/08: Tech's
have program installed on their laptops and are testing program. 7/14/08: Sending issue log to
contractor on 7-14-08. 9/1/08: Waiting on contractor to complete changes. 11/14/08 -
Contractor is correcting bugs in programming and will be sending out package week of
11/17/08. 12/5/08: New version of software is in ICARe, scheduled for install next week.
12/29/08: Project complete.
Completed 2007




1/9/08: Image migration complete but have not been able to create pyramids; progress halted
since 8/2007; waiting on support. 4/2/08: It has been decided that since some imagery is the
same as that provided by the portal that there is no longer a need to host this imagery
ourselves. 6/18/08: GIS Unit has requested creation of two new databases through IS DBA
staff . 'ODOT' will host standard data tables, replacing shapefiles posted to 'NAS' server.
'PROJECTS' will contain project based file groupings. 9/2/08: The databases have been
created and are in use. 02/01/09: Complete. Now in maintenance mode.




   Revised 10/12/00
                                                          COMPLETED PROJECTS

3/13/06: Customers have received frequent training refresher courses. Data entry has been
validated. Insufficient resources to address 'instant-update' to main database. Other report
capability not distributed until resources available. 9/14/06: Continued GIS and data support
delivered by GIS Unit. Data is received by GIS Unit as needed.11/01/06: Counting season
complete. Data being received by GIS Unit as it becomes available. 01/03/07: Data received
and in review. 2007 Hose Counts Sheets being prepared. Work with consultants continues.
3/8/07: 2007 count year application and data provided to field staff. Refresher training
provided. TSM staff trained to support field staff. GIS will assist in copying datasets during
collection season. GIS unit will append data to main database once approved by TSM staff.




   Revised 10/12/00
                   COMPLETED PROJECTS




Revised 10/12/00
                   COMPLETED PROJECTS




Revised 10/12/00
                   COMPLETED PROJECTS




Revised 10/12/00
                   COMPLETED PROJECTS




Revised 10/12/00
                                                                      COMPLETED PROJECTS

Traffic Volume 20 yr projn 2022 2/05
Traffic Volume 20 yr projn 2023 2/05
Pavement Conditions 2004 2/05
                                              RLIS quarterly update (OEM) (3/07)
Detour Rt. for Mt. St. Helens 2/05
                                              Off Highway Local Roads 2007 (Small) (3/07)
Urban Growth Boundary 2004 2/05
                                              TOC Command Areas 2007 (Small) (04/07)
Crashes 2003 2/05
                                              Hazardous Waste Sites updated (OEM) (4/07)
DRAFT STIP 06-09 5/05
                                              National Freight Network nonstate 2007 (Small)
SIP Segs 01-03 05/05
                                              (4/07)
City Points 05/05
                                              National Freight Network state 2007 (Small) (4/07)
Railroads 2004 1/05
                                              Oregon Geologic Data Compilation update V3 (OEM)
Medians 2006 (OEM) (01/07)
                                              (4/07)
Number of Lanes 2006 (OEM) (01/07)
                                              Rest Area Exits 2007 (OEM) (4/07)
Shoulder Wdth/Typ 2006 (OEM) (01/07)
                                              USDA/NRCS Soil Survey update (OEM) (4/07)
Viewpoints 2006 (OEM) (01/07)
                                              Leaking Underground Storage Tanks update (OEM)
Waysides 2006 (OEM) (01/07)
                                              (4/07)
Expressways 2006 (OEM) (01/07)
                                              Flow Map 2005 (OEM) (4/07)
Left Turn Lane 2007 (OEM) (02/07)
                                              Truck Flow Map 2005 (OEM) (4/07)
Right Turn Lane 2007 (OEM) (02/07)
                                              Medians 2006 (OEM) (01/07)
City Limit 2007 (January) (OEM) (02/07)
                                              Number of Lanes 2006 (OEM) (01/07)
Routes cross ref 2007 (OEM) (02/07)
                                              Shoulder Wdth/Typ 2006 (OEM) (01/07)
Highway Traffic Signals 2006 (OEM) (2/07)
                                              Viewpoints 2006 (OEM) (01/07)
Unstable Slopes on State Highways 2007
                                              Waysides 2006 (OEM) (01/07)
(OEM) (3/07)
                                              Expressways 2006 (OEM) (01/07)
RLIS quarterly update (OEM) (3/07)
                                              Left Turn Lane 2007 (OEM) (02/07)
Off Highway Local Roads 2007 (Small)
                                              Right Turn Lane 2007 (OEM) (02/07)
(3/07)
                                              City Limit 2007 (January) (OEM) (02/07)
TOC Command Areas 2007 (Small) (04/07)
                                              Routes cross ref 2007 (OEM) (02/07)
Hazardous Waste Sites updated (OEM)
                                              Highway Traffic Signals 2006 (OEM) (2/07)
(4/07)
                                              Unstable Slopes on State Highways 2007 (OEM)
National Freight Network nonstate 2007
                                              (3/07)
(Small) (4/07)
                                              RLIS quarterly update (OEM) (3/07)
National Freight Network state 2007 (Small)
                                              Off Highway Local Roads 2007 (Small) (3/07)
(4/07)




    Revised 10/12/00
                   COMPLETED PROJECTS




Revised 10/12/00
                   COMPLETED PROJECTS




Revised 10/12/00
                   COMPLETED PROJECTS




Revised 10/12/00
                               COMPLETED PROJECTS




        Chuck Jenkins   Dennis Scofield       Milt Hill
        Dianna Mann




          Sue Mead      Don Crownover          Eric
                                             Anderson




Revised 10/12/00
                           COMPLETED PROJECTS

          Sue Mead   Don Crownover         Eric
                                         Anderson




Revised 10/12/00
ODOT Construction Plans and            GIS22                      On Hold - Intranet application to create a spacial index (map) of
Right-of-Way Map Index                                            ODOT Construction projects and Right-of-Way files data stored in
                                                                  ITIS. Resources need to be assigned. Data from ITIS for Map
                                                                  information has been obtained. Basic intranet application has been
                                                                  developed in ArcIMS but does not include the Construction Projects
                                                                  or Right-of-Way Maps, reports or additional queries. Project
                                                                  approved by Cathy Nelson. Project delayed due to other project
                                                                  priorities and lack of resources.
Drainage Facility Management           GIS29   11/1/03   3/4/04   Phase 3 - On Hold - Motor Carrier is starting to maintain & update
 - Develop system for inventorying,                               database. Route maps ready for State Printer. Completed 4
evaluating and tracking condition of                              separate MAP/GIS Layers, 1 in progress. Motor Carrier resources
pipes, culverts and storm water                                   have not been available. Dennis will meet with Mike Bollinger to
facilities                                                        determine direction.




Truck Route Permit Mapping and         GIS29   11/1/03   3/4/04   Phase 3 - On Hold - Motor Carrier is starting to maintain & update
Database                                                          database. Route maps ready for State Printer. Completed 4
Phase 3 - Outline processes for                                   separate MAP/GIS Layers, 1 in progress. Motor Carrier resources
maintenance by data steward (MC)                                  have not been available. Dennis will meet with Mike Bollinger to
                                                                  determine direction.
Region 1 Development Review
TRAINING RECEIVED: SQL training 3/8/01                    State Web dev Cert (HTML focus) fall/02
GeoMedia Intro Class 6/5/01                               Sequal Server 2000 fall/02
GIS in Action                                             ArcGIS 8 for Enviro Appl fall/02
GIS-T 2001                                                Map Objects Basics0online fall/02
GeoMedia Pro 7/12/01-7/13/01-10/16/01-10/17/01-10/18/01   MSTN V8 for Admin/User update 10/02
ArcIMS 6/28/01-6/29/01                                    Java Scripting 11/02
TransGIS version 2 training                               Visual Basic-(Phil & Chad N)GIS Unit 12/02
Advanced Access 10/23/01-10/24/01                         HTML basics-Sue/GIS Unit 1/03
SQL training 9/1/02                                       Excel XP - Sue/GIS Unit (1/03)
TransGIS version 2 training 1/02                          Cold Fusion - Lisa, Phil, Casey 4/03
GIS in Action, addressing conf. 08/02                     ArcGIS - Casey, Phil, Lisa 4/03
XML Fundamentals fall/02                                  Java Script - Lisa 4/03
MicroStation V8 - GIS Unit 1/04                           Remote Control/Field Tach GIS course (8 GIS members) 5/03
Java - Chad N, Phil S 1/04                                Requirements Mgmt - Sue 6/03
                                                          GIS in Action workshps and seminars-GIS Unit 5/04
                                                                     MS access, advanced & Excel, advanced- Lisa L. 4/04
                                                          ArcGIS 9.0, I and II, (GISU), Kim Taylor (GeoEnviro), Charlotte
                                                                        Gerkin (TSM), Chris Shearer and Diana Mann (RICS) 9/04
                                                                     Java 1 Chad Nielsen (GISU)10/04
                                                                     GPS Data Collection, Chad Nielsen, Casy Ragain (GISU),
                                                                           Marcia Malstrom (IS), Jim Gavin (RICS), 9/04
                                                                     GIS-T Lincoln Nebraska - Susan Mead (GIS), 04/05


TRAINING DELIVERED:                                       ArcView - Region 1 staff 10/03
ArcView and ArcExplorer - Bridge Mgmt                     Crash Coding - CAR staff 10/03
ArcView - Darla Stoneman / Acces Mgmt                     GIS Brownbags 11/03
ArcExplorer - TSM                                         ArcView-General Support to Region 1 (Lisa) 6/04
First Round - TransGIS users                                        15 users in queue
GIS Tools-R1 6/02
ArcView-Darla Stoneman/Access Mgmt 6/02
TransGIS-initial users/R5 5/02
ArcExplorer - CAR 11/02
ONHP/ArcExplorer-Env at CCC and R3 10/02
GIS Tools R3 11/02
ArcExplorer-Access Mgmt (CHAMPS) 12/02
ArcExplorer - Motor Carrier 4/03
Resource Map Template production - Env. 4/03
Crash Viewer - Region 1- 5/03
ArcExplorer - 10 Approach Perm Spec 7/03
ArcExplorer - TSM staff 8/03 - IS staff 8/03
DEMONSTRATIONS:                                           TransGIS demo for Traffic Recorder Techs 1/03
ArcExplorer to GIS Steering Committee 3/22/01             SR-SAM to GIS Steering Committee (1/03)
ArcExplorer to OTMS Steering Committee 6/28/01            Functional Classification - TDS expanded staff 4/03
Aggregate Demo                                            GeoConnent/MetaWeb - GIS Steering Comm. 5/03
ESRI demo                                                 ArcGIS template - GIS Steering Comm. 5/03
Collision Diagram demo to Region Traffic Managers 6/02    TransGIS Web dev - TDS staff 6/03
OTMS - TransGIS & DMV demo 9/25/01                        ArcGIS 8.x template - TDS staff 6/03
DMV demo to IS quarterly mgmt team 10/19/01               TransGIS Web PP - Region1 Planners 6/03
DMV & Trans GIS demo to GIS Steering Comm. 10/25/01       TransGIS Web - OTMS SC - OTMS Exec SC - Trans. COI 6/03
GIS Tools - ODOT Directors office 09-02                   TransGIS Web - GIS Steering Committee 7/03
Rural Lands database project to GeoHydro 10/02            TransGIS Web - TDS Expanded Staff 8/03
VBCrash to IT Exec Steering Comm and R2 10/02             TransGIS PP - PBLT 8/03
TransGIS demo for Eugene Public Worls 11/02               TransGIS PP - Highway Division staff 12/03
TransGIS demo for Eugene Public Worls 11/02               TransGIS - Chief of staff Lori Sundstrom 12/03
DMV App. & TransGIS - R2 Management 10/02                 TransGIS - TPAU 12/03
DMV App. & TransGIS - R2 Design Team 11/02                TransGIS - Traffic Count Field Techs 1/04
DMV App. & TransGIS - HR expanded staff 11/02             Traffic Count GIS and Metro relationship 2/04
FC database demo-GIS Steering Comm 12/02                  TransGIS - Planning Business Line Team 4/04
                                                          TransGIS - Parametrix 4/04
                                                          Network Software - GIS Steering Committee 5/04
                                                          GPS-ArcView Script for Data collect Team 7/04
                                                                    TransGIS - OBDT 6/04
                                                                    TransGIS - Region 1 Project Delivery 6/04
                                                                    Network Software - TPAU 6/04
                                                                    TransGIS - Region 1 Traffic Mgmt 8/04
                                                                    TransGIS - Region 1 Tech Center Managers 9/04
                                                                    TransGIS - Region 4 Traffic Managers 9/04
                                                                    TransGIS - DMV 10/04
                                                                    TransGIS & Env TransGIS - OTMS Steering Comm 12/04
                                                                    GIS File Storage System - GeoEnv Steering Comm 12/04




DMV App. & TransGIS - HR expanded staff 11/02
FC database demo-GIS Steering Comm 12/02
TransGIS demo for Traffic Recorder Techs 1/03
SR-SAM to GIS Steering Committee (1/03)
Functional Classification - TDS expanded staff 4/03
GeoConnent/MetaWeb - GIS Steering Comm. 5/03
ArcGIS template - GIS Steering Comm. 5/03
TransGIS Web dev - TDS staff 6/03
ArcGIS 8.x template - TDS staff 6/03
TransGIS Web PP - Region1 Planners 6/03
TransGIS Web - OTMS SC - OTMS Exec SC - Trans. COI 6/03

								
To top