Platform Migration Project Schedule Template by kck16802

VIEWS: 216 PAGES: 29

More Info
									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
                                                                                                                                March 2009
                                                       Project Status




                                                                                November
                                                                                           December
                                                         Importance




                                                                                                      January
                                                                      October




                                                                                                                                                          Projected
Status***




                                                                                                                                                           Status**
                                                           Project
                                             Project                                                             Project     Preliminary   Adjusted End
             Project Name/Description                                                                                                                                                                      Comments
                                             Number                                                             Start Date    End Date         Date


 A Phase 6 -OR-Trans/Pooled Fund             GIS19                    G         G          G           G         6/30/04      6/30/05       12/31/08        G         8/25/08: WA_Trans Policy Advisory Commitee mtg on 9/4. This will address
   Project                                                                                                                                                            technical issues that will guide the tools and design for the load/extract/change
   - Design and construct Web based check                                                                                                                             detection software. 11/12/08: On 10/14 the Pooled Fund Quarterly meeting
   in and out                                                                                                                                                         addressed funding from participating states. The portal was going to be online in
   - Check out system                                                                                                                                                 beta form by the end of October. FME will be used for change detection on linework
                                                                                                                                                                      and SQL will be used for change detection on attributes. 1/13/09: WSDOT has
                                                                                                                                                                      emailed the test documents for participants to test the Portal. Testing will be done
                                                                                                                                                                      by ODOT the week of 1/12/09. ODOT has made their final payment obligation of
                                                                                                                                                                      $35k. ODOT will begin receiving the custom code and all software requirements
                                                                                                                                                                      for the portal over January and February of 2009. 2/19/2009: ODOT has received
                                                           Medium




                                                                                                                                                                      the software requirements for replicating the Pooled Fund portal at ODOT. The
                                                                                                                                                                      code behind the actual portal will be delivered towards the end of February after
                                                                                                                                                                      WSDOT has had a chance to clean and finalized the code from any issues found
                                                                                                                                                                      during testing. 3/5/2009 Staff is on schedule to have the 33 updates to the OR-
                                                                                                                                                                      Trans
                                                                                                                                                                      database by March 31.
A Phase 7 - OR-Trans FY 2007             GIS19            G   G   G   G   5/1/07    6/30/08             G   8/25/08 OEM contract w/ counties at DOJ for review. OEM placed a hold on data
  - Statewide data partnership                                                                              distribution to OR-Trans until new contract is signed. Crash data for Wasco Pilot
  - Wasco County Pilot project                                                                              has been extracted and geocoded to OR-Trans data. Mid Sept. mtg is planned to
  - Develop/Coordinator QA/QC of data                                                                       demonstrate data to Wasco Co. Marion/Linn Co. pilot to resolve agreement points
    with Road Authorities                                                                                   was scheduled for August but has been pushed back because of loss of resources
  - Continue Pooled Fund participation                                                                      (Loren Mueller). Chad N has taken over some tasks that Loren had but he also has
  - Develop Routing data on State                                                                           GIS technical support functions for ODOT that take his time. 11/12/08: We are
  highways                                                                                                  waiting on the delivery of 18 county data sets from OEM/GeoSolve through
                                                                                                            agreement not to distribute the data until they have finalized their contracts with
                                                                                                            each county. We can use the data for purposes to develop QAQC process and for
                                                                                                            internal purposes. We have lost both of our internal resources that were working on
                                                                                                            the OR-Trans project and hope to have new resources in place soon. 1/13/09:
                                                                                                            ODOT has received 29 county updates for the OR-Trans data. A decision will be




                                                 Medium
                                                                                                            made to do the data updates to the database either through in-house
                                                                                                            resources or via contractor services. Loading will occur between now and
                                                                                                            June of 2009. Functionality will be added to the FME workbenches for
                                                                                                            loading the data to include error reporting of standard data issues like
                                                                                                            missing road names, an end address smaller than the begin address or very
                                                                                                            short segments of roads. 2/19/2009: ODOT has received updates
                                                                                                            from GeoSolve again. They added a persistant unique id to
                                                                                                            each record in each dataset they maintain for 17 counties.
                                                                                                            This will aid in future change detection efforts during updating
                                                                                                            and loading of the database. Shawn Snyder has begun loading
                                                                                                            all of the 33 dataset updates recieved since November of
                                                                                                            2008. He is working on adding error reporting features to the
                                                                                                            FME workbenches.



A Environmental Data Management          GIS31            G   G   G   G   Ongoing   Ongoing   Ongoing   G   1/9/08: Completed 2007 customer outreach and scheduled Steering Committee for
  System                                                                                                    February 2008. RES/RAZ revised prototypes currently in development.
  (formerly SR-SAM)                                                                                         Archaeological field application recently completed. Biology and Mitigation field
                                                                                                            applications in revision at Mason Bruce & Girard through Spring 2008. EDMS web
                                                                                                            application development resumes at Alsea Geospatial Spring-Summer 2008.
                                                                                                            4/17/08: EDMS Steering Committee met February 20. Archaeological GPS
                                                                                                            application development was completed in March. SRSAM mapping committee met
                                                                                                            April 14. RES/RAZ map rewrite in process through June 2008. 7/14/08: RES/RAZ
                                                                                                            map rewrite process through July 2008. Resource grade GPS training underway in
                                                                                                            Regions through mid-August. 9/8/08: GPS trainings completed. RES/RAZ map
                                                                                                            rewrite in progress, currently converting thematic Line Charts previously displayed
                                                 Medium




                                                                                                            in MicroStation to ArcMap for final draft review. 11/12/08: EDMS schedule revised
                                                                                                            for comprehensive committee review of RES/RAZ mapping prototypes. RES/RAZ
                                                                                                            revisions in committee review thru January 2009. EDMS web platform migration
                                                                                                            kick-off completed Nov 5, 2008. EDMS
                                                                                                            web platform migration focus groups to be held thru late Fall 2008. EDMS
                                                                                                            field and desktop tools for supporting archaeology currently in development.
                                                                                                            12/16/08: EDMS steering committee met Dec. 11 and reviewed
                                                                                                            current program status and recommended submitting FY09-11
                                                                                                            workplan proposal to GIS steering committee for approval.
                                                                                                            1/16/09: Chris Wright joins the ODOT GIS Unit returning the
                                                                                                            EDMS team to full staff level.
H Traffic Mobility Management System          GIS39              Y   Y   Y   Y   3/1/06               On Hold-    Y   09/14/06: Placed on Hold by Motor Carrier Staff. 10/31/06: Project completed.
  Phase 2                                                                                              6/1/07         Motor 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
  processes based on recommendations                                                                                  discuss future developer needs. Additional discussions will occur over the next few
  and findings from Phase 1.                                                                                          months. Invited Randall Thomas to May Steering Committee to discuss needs for
    • Create/capture and catalogue data (or                                                                           project. 1/4/08: Randall Thomas reports that final database testing is
  secure access to data) that will be used                                                                            underway. GIS portion of this project remains on hold.




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


A TOC GIS Interface                           GIS42              Y   Y   Y   Y   5/1/06     5/1/07    On Hold-    Y   3/8/07: Prototype delivered, waiting for final requirements. 3/17/09: ITS database
  Phase 2                                                                                              6/1/07         created on failover server in Bend (s-reg4toc-115). DBA's created account for




                                                        High
  - Implementation of viewing tool                                                                                    read only access. Data loaded to ROC or RTP, depending on the application
  - Provide GIS expertise to the project                                                                              needs. TOC has been notified and have been asked to test the new server
                                                                                                                      and data.
H SPIS Pilot for OR-Trans - Proof of          GIS44              Y   Y   Y   Y   7/13/06   12/31/06   On-Hold     Y   6/17/08: Contact business (Safety Management System staff) for future direction of
  Concepts                                                                                                            this project. 7/16/2008 This project is linked to TAD db project RFW # 16117 that
                                                                                                                      has not started as if this date. 1/7/2009: Requirements and High level design
                                                        High


                                                                                                                      has started for the SPIS_PUB project. By end of January or early February,
                                                                                                                      this project will decide on its GIS solution.


C Alternate Fuels Corridor - I5 Potential     GIS50              Y   Y   Y   Y   1/10/08   2/29/08    2/25/2008   Y   2/25/08: Project Complete. 4/15/08: Customer utilizing data and tools. Training set
  Sites Research                                                                                       06/30/08       for map production tool. 6/5/08: Project database and security developed for
  - GIS map and database of all available                                                                             customer use during research phase. Data use restrictions prompted this
                                                        Medium




  sites associated with the I-5 corridor.                                                                             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.


H Alternate Fuels Corridor - I5 Potential     GIS50-2            Y   Y   Y   Y                                    Y   02/04/09: Tasking not required, yet - per customer.
  Sites Research- PHASE 2
  - Make database available to public.
A TPOD (Transportation Planning Online      GIS52               Y   Y   R   Y             5/1/08   6/1/2008    Y   3/20/08: Waiting for allocation of resources. 4/4/08: First meeting scheduled to gain
  Database)                                                                                        07/15/08        access to database and determine location of scanned documents. 4/15/08: Data
  - Use GIS interface to view scanned                                                               9/31/08        and scanned documents located. Database schema in review as is document
  planning studies                                                                                 12/31/08        storage/access location. 5/09/08: No Change. Resources are scarce. 06/19/08:
                                                                                                    2/1/09         Database in revision to achieve functionality and meet GIS standards.
                                                                                                   04/15/09        Redundancy and organization of documents in review to prepare for action by
                                                                                                                   temporary staff and to insure proper posting and updates. Temp staff begins work
                                                                                                                   to add and update documents, update database, revise organization and document
                                                                                                                   naming. GIS staff designs interface for database entries and link management.
                                                                                                                   11/12/08: GIS PM developing database interfaces for maintenance and providing
                                                                                                                   direction to Intern. Document files moved to GIS server. Application development
                                                                                                                   coordinated by customer. Changes being implemented by programmer. Intern




                                                       High
                                                                                                                   updating data, validating documents, and developing metadata. Project status
                                                                                                                   review scheduled for 11/20/08.
                                                                                                                   1/26/09: The application is functioning and minor
                                                                                                                   enhancements progress with allotted time. Access database
                                                                                                                   is complete, with regards to format and table relations. User
                                                                                                                   interface for editing is still under construction, however, this
                                                                                                                   does not affect use of the GIS web tool. Data updates are in
                                                                                                                   progress and necessary for proper linkages to documents in
                                                                                                                   the application. Data edits were on hold during holiday break,
                                                                                                                   however, they have resumed and should be completed soon. 03/13/09: Project
                                                                                                                   distributed to users. Data in update/maintenance mode. Application being
                                                                                                                   moved from development to production server.
H RWDMS II - GIS Component                  GIS55               G   G   G   G   3/10/08   5/1/08               G   3/20/08: Feasibility testing complete.
                                                     Mission
                                                     Critical




  - Enhance GIS connection to R/W
  FileNet System.

Q ArcGIS ODOT GUI Update                    GIS56               Y   Y   Y   Y             6/1/08               Y   3/20/08: Waiting for allocation of resources. 4/4/08: Short discussions have begun.
  - Update existing template to improve                                                                            4/15/08: Project scope and purpose to be reviewed. Possible split as two projects.
  efficiency and standardization.                                                                                  5/09/08: Project split confirmed. This project addresses desktop toolset.
                                                       Medium




                                                                                                                   Navigation and data access toolbars in development. Data migration to SDE/SQL
                                                                                                                   in process. Team reviewing modules developed by business partners and other
                                                                                                                   agencies. 7/09/08: Resources unavailable. 1/26/09: Some tools under revision, in
                                                                                                                   response to the distribution of data through SQL/SDE. 03/16/09: First draft in
                                                                                                                   review and revision.
C Traffic Counting Application Features     TO #23              C   C   C   C   1/3/07             3/10/2008   C   1/3/08 - Project approved. 2/25/08 - Data provided to consultant. 3/7/08 - Project
  Enhancement                                                                                       06/01/08       due to be delivered week of 3/10/08. Software delivered, working on software
  - Contractor will enhance application                                                              9/1/08        version issue. 4/18/08: Software out of iCARE. Working with contractor to fine tune
  used by field traffic counting staff                                                              12/29/08       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.


H Interchange Diagramming in GIS            GIS58               Y   Y   Y   Y   8/1/08    9/1/08               Y   6/25/08: Waiting for resources.
                                                       Medium




                                                                                                                   Resource will be available 8/1


H Electric Vehicle Charging Stations Site   GIS59               Y   Y   Y   Y                                  Y   9/4/08: Lynn Bailey has received ArcGIS 2 training and with the assistance of
  Data Collection Assistance                                                                                       Sarah Abbott, Region 1 GIS support technician is doing the project
                                                       High




                                                                                                                   themselves with a minor amount (four hours) of support from Ryan Johnson.
Q Freight Bottleneck Identification      GIS60            Y   Y   Y   Y                                      Y




                                                 Low
A STIP Scoping and Project Delievery     GIS61            Y   Y   Y   Y                                      Y




                                                 Medium
  GIS Utilities (Phase 3)
  AKA: FACS GIS Utilities


Q TPOD (Transportation Planning Online   GIS62            Y   Y   Y   Y                                      Y
  Database) Phase 2




                                                 Medium
Q Integration of OTIA III GIS data and   GIS63            Y   Y   Y   Y                                      Y
  systems to ODOT GIS System (Phase

                                                 High
  1)



Q Statewide Traffic Mobility GIS         GIS64            Y   Y   Y   Y                                      Y
  Interface (Phase 2)
                                                 High




Q EDMS: Enhance Environmental Data       GIS65                             7/1/09     6/30/11                    03/03/09: Begin Work 07/01/09
                                                 Medium




  Management System



A GIS Data In Progress                   GIS21            G   G   G   G   Ongoing    Ongoing     Ongoing     G   City Limits (2009)
   Projects categorized as:                                                                                      Highway Network (first qrtr 2009 update)
                                                 High




   OEM or Small                                                                                                  nonstate functional class 2009 (OEM)



A GIS Data Completed                     GIS21            C   C   C   C   Complete   Completed   Completed   C   ODOT Aggregate Sites Jan 2009 (3/09)
                                                                             d                                   ODOT Areas Jan 2009 (1/09)
                                                                                                                 Bull Trout Observation (2/09)
                                                                                                                 Bull Trout fish Habitat dist. (2/09)
                                                                                                                 Fall Chinook Observation (2/09)
                                                                                                                 Salmon, Steelhead and Resident Trout Observ (2/09)
                                                                                                                 Fall Chinook Habitat dist. (2/09)
                                                                                                                 Spring Chinook Habitat dist. (2/09)
                                                                                                                 Chum Habitat dist. (2/09)
                                                 High




                                                                                                                 Coho Habitat dist. (2/09)
                                                                                                                 Summer Steelhead Habitat dist. (2/09)
                                                                                                                 Winter Steelhead Habitat dist. (2/09)
                                                                                                                 Summer Steelhead Observation (2/09)
                                                                                                                 Winter Steelhead Observation (2/09)
                                                                                                                 Fish Passage Barrier (2/09)
                                                                                                                 Oregon Geographic Names Info Sys (GNIS) (2/09)
                                                                                                                 Portland Metro Regional Land Info Sys (RLIS) (3/09)
                                                                                                                 LiDAR - DOGAMI 3 ft res. Elevation Data update (3/09)
A GIS Infrastructure Support (cont.)   GIS11-01          G   G   G   G   Ongoing   Ongoing   Ongoing   G   TRAINING RECEIVED:
  Training                                                                                                  Oregon Real Time GPS network: Ryan J, Chad C, Shawn S, Casey R (02/09)




                                                  High
                                                                                                           TRAINING DELIVERED: no activity at this time


A GIS Infrastructure Support (cont.)   GIS11-02          G   G   G   G   Ongoing   Ongoing   Ongoing   G   LiDAR demo to Planning Section (1/09)
  Demonstrations
  (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                                                                                          27 (11/08)




                                                  High
                                                                                                            21 (12/08)
                                                                                                            16 (1/09)
                                                                                                            35 (2/09)

A GIS Infrastructure Support (cont.)   GIS11-04          Y   Y   Y   Y   Ongoing   Ongoing   Ongoing   Y   METADATA:
  Metadata                                                                                                  (1/09) ODOT Areas Jan 2009 (1/09)
                                                                                                            (2/09) Bull Trout Observation, Bull Trout fish Habitat dist., Fall Chinook
                                                                                                           Observation, Salmon, Steelhead and Resident Trout Observ, Fall Chinook
                                                                                                           Habitat dist., Spring Chinook Habitat dist., Chum Habitat dist., Coho Habitat
                                                  High



                                                                                                           dist., Summer Steelhead Habitat dist., Winter Steelhead Habitat dist., Summer
                                                                                                           Steelhead Observation, Winter Steelhead Observation,
                                                                                                           Fish Passage Barrier, Oregon Geographic Names Info Sys (GNIS).
                                                                                                            (3/09) Portland Metro Regional Land Info Sys (RLIS), LiDAR - DOGAMI 3 ft
                                                                                                           res. Elevation Data update


C GIS Infrastructure Support (cont.)   GIS11-05          G   G   G   G   Ongoing   Ongoing   Ongoing   G   Completed 2007
                                                  High




  GPS Standards

A GIS Infrastructure Support (cont.)   GIS11-06          G   G   G   G   Ongoing   Ongoing   Ongoing   G   In Progress:
  Software                                                                                                    ArcGIS Server 9.3 (Kick off meeting)
  Evaluation/Purchase/Implementation                                                                          ArcGIS Desktop 9.3 (E; GIS Unit Testing)
                                                                                                              Intergraph GeoMedia Professional 6.01 (E; GIS unit testing)
  (E) - Evaluation                                                                                            Intergraph GeoMedia Transportatoin Manager 6.01 (E; GIS unit testing)
  (P) - Purchase                                                                                              Intergraph GeoMedia Fusion 6.01 (E; GIS unit testing)
  (I) - Implementation
                                                                                                           Complete:
                                                  High




                                                                                                           Cancelled:
                                                                                                                "Where have all the license gone" (utility for checking current license use)
                                                                                                           (cancelled because we now have web application that tells us what is checked out;
                                                                                                           this software also had ability to boot others from server which limits its
                                                                                                           distributability)


  GIS Infrastructure Support (cont.)   GIS11-08          Y   Y   Y   Y                                 Y
  Process Guidelines
                                                  High
C GIS Infrastructure Support      GIS11-09           G   G   G   G   6/1/06    8/15/06             G   1/9/08: Image migration complete but have not been able to create pyramids;
  SDE Implementation                                                                                   progress halted since 8/2007; waiting on support. 4/2/08: It has been decided that
  Spatial Reference                                                                                    since some imagery is the same as that provided by the portal that there is no
  Populate Database                                                                                    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




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




   GIS Infrastructure (cont.)     GIS 11-13          G   G   G   G             4/30/09             G   03/16/09: Base files being loaded to Maintenance Server (//s-salemrev-
   Emergency Preparedness / GIS                                                                        52/sites/Emergency/default.aspx). Portable hard drive loaded with GIS shapefiles.
   Functions                                                                                           Various maps output to pdf format (coastal emphasis). Video Van reserved for GIS
                                                                                                       use in the event of emergency. Unit maps developed for TOC in Reg 2, 4 and 5.
                                                                                                       Training for 'routing' to be scheduled soon. Additional requests ongoing.




A GIS Infrastructure (cont.)      GIS11-14           G   G   G   G   Ongoing   Ongoing   Ongoing   G
  Hardware


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
  Planning                                                                                             space 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.


A GIS Infrastructure (cont.)      GIS11-18           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
  Data Management                                                                                      space 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.




A GIS Infrastructure (cont.)      GIS 11-22          G   G   G   G   Ongoing   Ongoing   Ongoing   G   03/16/09: Revisions, updates and enhancements in progress.
  GIS Unit Website Maintenance
A OEM & Small Projects (cont.)             GIS23-02                      Y   Y   Y   R   5/1/06    7/31/06   11/15/06   R   03/20/08: Needs to be published on TransGIS and customer has not completed
  Scenic Byways GIS Implementation                                                                            5/15/07       metadata. 4/4/08: Meeting scheduled to discuss TransGIS display requirements.
                                                                                                              5/1/08        4/15/08: Project review team meeting scheduled. Data update in progress. 5/09/08:
                                                                                                              6/15/08       Web Page display requirements determined and in development. 7/09/08: ArcGIS
                                                                                         ACTIVE               9/01/08       mxd Draft prepared and implemented through TransGIS. Waiting for customer
                                                                                         12/1/07              10/1/08       review. 11/17/08: Web map in revision (ArcGIS server). Customer review will be




                                                      High
                                                                                                             11/30/08       scheduled, shortly. Metadata complete. 1/26/09: No resources available.
                                                                                                             03/01/09




A OEM & Small Projects (cont.)             GIS23-03                      Y   Y   Y   Y   1/29/07   6/30/07    6/30/07   Y   1/03/2008 - PM is meeting to get an update on required data availability status with
  Access Management GIS                                                                                       6/30/08       GIS data administrator and is scheduling a final requirements meeting in January
  Implementation                                                                                              9/01/08       with the Project team. 03/20/08: PM has scheduled April meeting to determine if
                                                                                         3/1/08              03/01/09       customer will accept current data availability to meet project requirements. Need to
                                                                                                                            set new end date. 04/15/08: Update meeting occurred. Scope reviewed; data




                                                      Mission Critical
                                                                                                                            layers in review and application needs solidified. New end date set. 05/09/08: No
                                                                                                                            Change. 6/17/08: Surveyed field permit specialist for top 10 data layers most useful
                                                                                                                            in their work. 7/16/2008 received 10 top layers, proto type is developed and will be
                                                                                                                            sent to business for approval. 9/3/08: Application was reviewed dring an iLinc
                                                                                                                            meeting and approved by business ownder. Business ownder has requested
                                                                                                                            training for his staff. The PM will speak with GIS staff on scheduling some in-house
                                                                                                                            training with some pre-designated scenarios created. 1/26/09: Final approval of
                                                                                                                            application received from PM and training plan and scheduling are in progress.
                                                                                                                            3/19/09: Real-life/user scenarios
                                                                                                                            in development w/ field staff input.
C OEM & Small Projects (Cont)              GIS23-04                      C   C   C   C   1/11/06   3/15/06   12/31/06   C   3/13/06: Customers have received frequent training refresher courses. Data entry
  Traffic Counting Field Data Collection                                                                      06/1/06       has been validated. Insufficient resources to address 'instant-update' to main
                                                                                                             07/15/06       database. Other report capability not distributed until resources available. 9/14/06:
                                                                                                             08/01/07       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.


H OEM & Small Projects (cont.)             GIS23-09                      Y   Y   Y   Y   6/9/06    10/1/06    5/1/07    Y   2/21/07: This project on-hold awaiting direction from business sponsor. 3/8/07: No
  Asset Management Safety Rating Pilot                                                                                      business resources at this time. 5/2/07: No business resources at this time.
                                                                                                                            Contacted business (Safety Management System staff) for future direction on this
                                                                                                                            project. 7/16/2008 This project has been on hold - Requested response from
                                                      High




                                                                                                                            business to find out if they still had interest in moving forward with this
                                                                                                                            project. They have several other related initatives in the queue at this time.
OEM & Small Projects                  3/16/09:
(initial listing - shows ACTIVE and   23-10 (inactive) Lifeline Development and Maintenance
inACTIVE for Committee Perspective)   23-16 (hold) Modification to HGIS - City Limit and Highway Network db revisions
                                      23-38 (inactive) Multiple LRS discussion/demos
                                      23-42 (inactive) State Highway Seasonal Closures
                                      23-43 (active) Base Maps/data in support of City/County and other standard maps
                                      23-44 (active) ODOT Polictical Boundary Maps
                                      23-45 (active) Aeronautics Support
                                      23-46 (inactive) Bridge Section Support
                                      23-47 (inactive) Freight Section Support
                                      23-48 (active) Director's Office Support: Economic Stimulus Maps
                                      23-49 (inactive) DMV Support
                                      23-50 (inactive) Legislative Boundaries
                                      23-51 (active) Motor Carrier Support
                                      23-52 (active) Oregon Transportation Commission Maps, Graphics and Analysis
                                      23-53 (inactive) Pavement Section Support (incl. Pavement Condition Maps)
                                      23-54 (inactive) Wireless and Radio Communications Support
                                      23-55 (inactive) Rail Section Support
                                      23-56 (active) Safety Section Support
                                      23-57 (inactive) SIP/SPIS Mapping
                                      23-58 (active) STIP Mapping
                                      23-59 (active) Official State Map / Tourist Map: In review
                                      23-60 (inactive) Transit Section Support
                                      23-61 (inactive) Transportation Plan: Maps and Graphics Support
                                      23-62 (active) Misc. small and unrelated map requests
                                      23-63 (active) State Motorcycle Map
                                      23-64 (active) Maintenance Map and related products


OEM & Small Projects (cont'd)         23-65 (inactive) ODOT Facilities Support (sandsheds, fuel locations, etc)
(initial listing - shows ACTIVE and   23-66 (active) City Limits: Update/maintain GIS layer
inACTIVE for Committee Perspective)   23-67 (active) Highway Network: Update/maintain GIS layer
                                      23-68 (active) Scenic Byways Mapping and Data Support
                                      23-69 (inactive) Connect Oregon Mapping and Data Support
                                      23-70 (active) ITS Mapping and Data Support
                                      23-71 (inactive) Governor's Initiatives, Mapping Support
A Transportation Model Development          G   G   G   G   Ongoing   Ongoing   Ongoing   G   3/11/09: Deschutes County Model base year completed, Future year in
                                                                                              progress. Brookings Model: complete and awaiting applications. Woodburn
                                                                                              Model: awaiting confirmation of land use and network from city. SWIM2:
                                                                                              presented at TRB in January, New scenarios using alt. economic forecast
                                                                                              being run. GreenStep: There is still a significant amount of work needed on
                                                                                              the input side, but the bulk of the model is complete. Potential to be expanded
                                                                                              and connected across agencies to include work related to green house gas




                                     High
                                                                                              analysis. Currently existing model components are still being reviewed and re-
                                                                                              estimated. Marion County Model: Network complete,currently integrating
                                                                                              demand from SWIM into the structure.
                                                                  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




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
ADT 2001 (Average Daily Traffic) (OEM) 10/02
ODOT Areas Boundaries (OEM) 11/02
ASIS Aggregate Sites (OEM) 10/02
Hwy Milepost Locations (OEM) 10/02
Schools Locations (All public schools) (OEM) 11/02
Hwy Tenths for updated Hwy Network (OEM) 11/02
US Corps of Engineers Navigable Waters (Complete 12/02) (OEM)
Crash Segs 2001 (SIP) (Complete 12/02) (OEM)
Crashes 5-yr composite by region (Complete 11/02) (OEM)
Highways-lane widths (Complete 11/02) (OEM)
Highway-number of lanes (Complete 11/02) (OEM)
Culverts 2002 (Complete 11/02) (OEM)
Truck Safety Corridors 2003
Truck A/M Corridors 2003
Culverts 6-20 ft (12/03)
Culverts less than 6 ft (12/03)
Highway Mileposts 2002 (Complete 10/02) (OEM)
Unincorporated Urban Communities 2002 (Complete 11/02) (OEM)
ODOT Regions Boundaries (Complete 1/03) (OEM)
ODOT Districts Boundaries (Complete 1/03) (OEM)
Highway Friction Values 2002 (Complete 2/03) (OEM)
Highway Skid Factors 2002 (Complete 2/03) (OEM)
Maintenance Crew Assignments (Complete 2/03) (OEM)
SPIS Sites (OEM) 4/03
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




    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