Project Outline Sample - Excel by thr18122

VIEWS: 137 PAGES: 16

More Info
									                                                                                                            GIS Monthly Project Status Report
                                                                                                                                      June 2007
                                                                               Project Status




                                                                     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       06/30/04      06/30/05      12/31/08        G         7/13/06: Puget Sound Pilot is complete, implementation of FME software will
            Project                                                                                                                                                      occur in 7/06 and testing phase w/ county datasets from OR and WA will
            - Design and construct Web based check                                                                                                                       occur during the remainder of 2006. 9/14/06: Organization is underway for the
            in and out                                                                                                                                                   Bi-State pilot project for the Pooled Fund Project. Morrow and Umatilla in OR

                                                                                                                                                                                                                                                           Tammi Griffin and Chad Brady
            - Check out system                                                                                                                                           and Benton, Franklin and Walla Walla counties in WA. This testing area will
                                                                                                                                                                         identify issues around integrating data across county and state boundaries into
                                                                                                                                                                         central database. Methods from Puget Sound Pilot will be used as a means to
                                                                                                                                                                         improve ways to integrate data for the Pooled Fund Project. 3/8/07: The first
                                                                                                                                                                         web page for the check in/out site has been created. Info gathered from JAD
                                                                                                                                                                         session was used to design interface and some of the functionality. At this
                                                                                                                                                                         point the web page is a mark up of information and the function of loading the
                                                                                                                                                                         data will be worked out after the overall design has been finished.

                                                                                                                                                                         4/3/07: Pooled fund project meeting on 3/24/07 in Nashville TN. NE, TN,
                                                                                                                                                                         IO, WA and OR were all in attendance. California has joined the pooled
                                                                                                                                                                         fund. 7/9 ODOT has secured $30K per year for the next two years for the
                                                                                                                                                                         pooled fund.

A           Phase 7 - OR-Trans FY 2007                               GIS19            G        G   G       G       05/01/07      06/30/08                      G         5/1/07 Drafted "Data sharing" document for sharing of road data between Road
            - Statewide data partnership                            (TO #15)                                                                                             Authorities and OR-Trans effort. Received IRIS data extracts for Wasco
            - Wasco County Pilot project                                                                                                                                 County and reviewing data for use in pilot project. Crash coder application in
            - Develop/Coordinator QA/QC of data                                                                                                                          "beta" test and review. This app will be used to generate some crash location
            w/Road Authorities                                                                                                                                           data for use in Wasco pilot. OR-Trans data loading completed and updates to
            - Continue Pooled Fund participation                                                                                                                         data are being applied. QC issues are being documented and a QC document

                                                                                                                                                                                                                                                           Chad Brady
            - Develop Routing data on State                                                                                                                              is in draft form. Pooled Fund project has a "mock" website based on JAD
            highways                                                                                                                                                     session in Nov 06. Web site is in review w/ contributors for refinement.
                                                                                                                                                                         Routing data being developed for state highway network and includes one-way,
                                                                                                                                                                         turn restriction and over dimensional restrictions for use in oversized routing
                                                                                                                                                                         needs. 7/9 Routing data for the state highway system has been
                                                                                                                                                                         completed. A "pipeline" connection to the Motor Carrier data is being
                                                                                                                                                                         developed in SQL to allow live access to restriction information for
                                                                                                                                                                         routing. Routing application will be deployed through the web using

             C:\Docstoc\Working\pdf\4cc51067-0bdf-41fb-baf3-245ed9505c27.xls                                                                                                                                                                          1
                                                                               Project Status




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

A           Phase 6 -OR-Trans/Pooled Fund
            Environmental Data Management                            GIS19
                                                                     GIS31            G        G   G       G       06/30/04
                                                                                                                   Ongoing       06/30/05
                                                                                                                                 Ongoing       12/31/08
                                                                                                                                               Ongoing         G         9/14/06: Project plan development and budget work in progress.11/20/06: Met
            System                                                  (TO #4,                                                                                              with "Linking Planning and Enviromental Process" (LPEP) Committee
            - Design and construct Web based check
            (formerly SR-SAM)                                       TO #12)                                                                                              members representing Planning and Geo-Environmental to discuss progress
            in and out                                                                                                                                                   to date and opportunities for collaboration, may get assistance with plan

                                                                                                                                                                                                                                                              Tammi Griffin and Chad Brady
            - Check out system                                                                                                                                           revisions. EDMS Steering Committee Charter drafted and reviewed by LPEP,
                                                                                                                                                                         Geo-Environmental.1/11/07: EDMS Steering Committee initial meeting held
                                                                                                                                                                         12/15/06. Committee is reviewing EDMS Strategic Plan and has authorized two
                                                                                                                                                                         sub-committees: one for continuation of SR-SAM related activities (The RES-
                                                                                                                                                                         RAZ Sub-Committee) and the other to focus on data and tools. 3/8/07: TDD
                                                                                                                                                                         and Maintenance Management met to review Program direction. Direction

                                                                                                                                                                                                                                                                  Milt Hill
                                                                                                                                                                         affirmed. RES-RAZ Sub-Committee formed with representation including
                                                                                                                                                                         Maintenance, Geo-Env, TDD and the ODOT-ODFW Liasion. Sub-Committee
                                                                                                                                                                         wiil meet 3/13/07. 5/10/07: Sub-committee rescheduled for 5/9/07. 7/12/07:
                                                                                                                                                                         RES/RAZ sub-committee met 5/9/07 in interactive workshop setting to
                                                                                                                                                                         discuss existing process and products and look at future direction. A
                                                                                                                                                                         revised Project Proposal for EDMS is being
                                                                                                                                                                         presented to the GIS Steering Committee. The preliminary
                                                                                                                                                                         wetlands mapping tool is geing rolled out to Regional staff this
                                                                                                                                                                         week. OSMA, SHPO and ODOT staff are meeting to discuss
                                                                                                                                                                         future development of the SHPO Archaeological database.

H           Traffic Counting GIS Implementation                      GIS16            Y        Y                   12/01/04      02/28/05      6/1/20/05                 5/11/06: Determination was made to use ITS Asset Inventory software. This
            Phase 5                                                                                                                             8/15/05                  software will also be used to track signals. A future project will be to develop a
             - Create data entry system for traffic                                                                                            On Hold                   GIS interface. This project will be closed until that request is made. 7/13/06:
            data                                                                                                                                                         Maintenance Work: Data Entry Interfaces have been updated to connect to

                                                                                                                                                                                                                                                              Susan Mead
             - Create database tables, site                                                                                                                              new database format. Traffic Volume Report is functional. Data entry in
            inspection, vendor info.                                                                                                                                     progress. Resources intermittent due to TSM staff change and the number of
             - Equipment Inventory Detail                                                                                                                                projects in process through the GIS Unit. 9/14/06: Looking at ITS Software for
             - Create data entry interface(s)) for equip                                                                                                                 tracking Traffic Counting Assets. May not need this project.
             - Provide imagery linking & view options

A           DMV Oregon Automobile Dealers                             GIS41           Y        Y   Y       Y       07/11/05      08/01/05      9/30/2005       R         9/14/06: DMV utilized 'Code 1' address cleaning software to improve location
                                                                                                                                                12/31/05                 information. Duplicate data was discovered and removed. DMV is matching
                                                                                                                                                2/01/06                  previously encoded latitude/longitude derivation and adding it to their new
                                                                                                                                                04/01/06                 'location' table. DMV is defining new queries for simple extracts which will be

                                                                                                                                                                                                                                                              Susan Mead and Robin Ness
                                                                                                                                                06/30/06                 provided to the GIS Unit for geocoding. DMV is delighted with the quality of
                                                                                                                                                08/01/06                 the refined database and confident in the new process. 11/01/06: Data
                                                                                                                                                10/15/06                 provider is defining appropriate display fields. Data expected to be received by
                                                                                                                                                12/01/06                 11/15/06. Geocoding will take approx 40 hours. Geocoding will take approx 40
                                                                                                                                                2/14/07                  hours. 01/03/07: Data received. No resources available to Geocode. 3/8/07:
                                                                                                                                                3/15/07                  Geocoding in process. Approx 50% complete. 5/2/07: Geocoding complete.
                                                                                                                                                6/11/07                  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

             C:\Docstoc\Working\pdf\4cc51067-0bdf-41fb-baf3-245ed9505c27.xls                                                                                                                                                                              2
                                                                               Project Status




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

A           Phase 6 -OR-Trans/Pooled Fund
            TOC GIS Interface                                        GIS19
                                                                     GIS42            G        G   G       G       06/30/04
                                                                                                                   05/01/06      06/30/05
                                                                                                                                 05/01/07      12/31/08
                                                                                                                                               06/01/07        G         3/8/07: Prototype delivered, waiting for final requirements.

              Implementation of viewing based check
            - Design and construct Web tool
            inProvide GIS expertise to the project
            - and out

                                                                                                                                                                                                                                                                Dennis Scofield and Chad Brady
            - Check out system
A           Traffic Mobility Management System                        GIS39           G        G   G       G       03/01/06                                    G         09/14/06: Placed on Hold by Motor Carrier Staff 10/31/06: Project completed.
            Phase 2                                                                                                                                                      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
            processes based on recommendations                                                                                                                           to discuss future developer needs. Additional discussions will occur over the
            and findings from Phase 1.                                                                                                                                   next few months. Invited Randall Thomas to May Steering Committee to

                                                                                                                                                                                                                                                                  Tammi Griffin
               • Create/capture and catalogue data (or                                                                                                                   discuss needs for project.
            secure access to data) that will be used
            and maintained for managing traffic
               • Develop applications that assist in
            managing traffic and freight mobility.
               • Prototype applications, data and
            business processes.

C           Crash Coding Tool                                        GIS43            G        G   G       G                                                   G         This project will create a TransGIS tool which will locate crash sites and collect
            - Create GIS application to assist in                                                                                                                        codes for 25 attributes from ODOT’s GIS system. 03/06/07: Project Kick-off

                                                                                                                                                                                                                                                                Robin Ness
            coding crashes                                                                                                                                               meeting complete, necessary data identified, TransGIS application under
                                                                                                                                                                         development. 5/10/07 Completed - A standalone application of the Crash
            - Workstation Based                                                                                    2/1/2007      4/1/2007                                Locator Tool is currently in the ICARE process. (Complete). A secondary
                                                                                                                                                                         web version of the tool is in development and will be implemented this
            - Web Based                                                                                             4/1/07       6/17/07                                 month.
A           Traffic Counting Field Data Collection                   GIS46            G        G   G       G       1/7/2007                    08/01/07        G         11/28/06: Approved at GIS Steering Committee 1/5/07: Met with Alsea
            Conversion                                              (TO#10)                                                                                              Geospatial who demonstrated existing application called Incident View

                                                                                                                                                                                                                                                                Tricia Tanner
                                                                                                                                                                         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.

A           STIP TransGIS Scoping Tool                               GIS47            G        G   G       G       5/10/2007    5/10/2007      2/1/2007        G         11/28/06: Approved at GIS Steering Committee 2/21/2007: First requirements

                                                                                                                                                                                                                                                                Susan Mead
            Phase 1 & 2                                                                                                                                                  meeting scheduled for March. 5/10/07: Met with customers, and received more
                                                                                                                                                                         direction from Cathy Nelson. 7/9/07: Project outline developed. Sample
                                                                                                                                                                         'mxd' created. Waiting for customer team to be identified.

             C:\Docstoc\Working\pdf\4cc51067-0bdf-41fb-baf3-245ed9505c27.xls                                                                                                                                                                             3
                                                                               Project Status




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

H           Phase 6 -OR-Trans/Pooled Fund
            OEM & Small Projects (cont.)                            GIS19
                                                                   GIS23-02           G        G   G
                                                                                                   Y       G
                                                                                                           Y       06/30/04
                                                                                                                   Ongoing       06/30/05
                                                                                                                                 Ongoing       12/31/08
                                                                                                                                              07/31/2006       G
                                                                                                                                                               Y         Phase 1 - 3/9/06: Existing CAD files and current brochure descriptions were
            ProjectByways GIS Implementation
            Scenic                                                                                                                            11/15/2006                 used to create a GIS layer/theme. Customer reviewed the theme. Additional

                                                                                                                                                                                                                                                                  Susan Mead and Robin Ness
            - Design and construct Web based check                                                                                              5/15/07                  text is being created by customer team. 5/11/06: GIS Unit has produced routes
            in and out                                                                                                                         On Hold                   from "Detailed Driving Directions" document. 7/13/06: GIS Unit working w/

                                                                                                                                                                                                                                                            Tammi Griffin and Chad Brady
            - Check out system                                                                                                                                           RICS Unit to review milepoints and details of 'drive-path' .9/14/06: Detailed
                                                                                                                                                                         spatial data refined. GIS file complete and posted to server. Phase 2 -
                                                                                                                                                                         Sponsor will work with TransGIS coordinator to establish display and use
                                                                                                                                                                         requirements. 11/01/06: No resources at this time. 01/03/07: No resources at
                                                                                                                                                                         this time. 3/8/07: Sponsor ready to initialize TransGIS implementation. All data
                                                                                                                                                                         work is complete with a March meeting planned. 5/10/07 Met with customers
                                                                                                                                                                         for initial requirements. On hold for GIS - resources. Another meeting
                                                                                                                                                                         with the customers will be scheduled to refine the requirements and
                                                                                                                                                                         schedule the work.
A           OEM & Small Projects (cont.)                           GIS23-03           G        G   G       G       Ongoing       Ongoing       Ongoing         G         3/9/06: Data provided by customer had to be re-extracted several times.
            Access Management GIS                                                                                                                                        Questions remain about certain records. 5/11/06: Training provided to
            Implementation                                                                                                                                               customer. GIS Unit has produced DRAFT dataset. 7/13/06: Coordinate fields

                                                                                                                                                                                                                                                                         Susan Mead and Robin Ness
                                                                                                                                                                         added to CHAMPS database to allow for more accurate locational methods.
                                                                                                                                                                         No resources available at this time. 9/14/06: No resources available at this
                                                                                                                                                                         time. 11/01/06: Status remains the same. 01/03/07: No change in status.
                                                                                                                                                                         3/8/07: New extract provided to GIS Unit. 'Mapping' of this data very difficult
                                                                                                                                                                         due to missing data. Resources need to be found to provide consultation to
                                                                                                                                                                         Access Management for data cleaning. Also, extracts need to be reconsidered.
                                                                                                                                                                         5/10/2007 - Met with customers in April and they have requested a
                                                                                                                                                                         demonstration of TransGIS (remotely) for the District Access
                                                                                                                                                                         Coordinators to assist in determining additional project requirements. A
                                                                                                                                                                         schedule will be set and a GIS/IS resource will be providing that
H           OEM & Small Projects (cont.)                           GIS23-09           G        G   G       G       6/9/2006     10/1/2006      5/1/2007        G         7/13/06: GIS Team is awaiting data and value or rating system. 9/14/06: GIS

                                                                                                                                                                                                                                                            Susan Mead
            Asset Management Safety Rating Pilot                                                                                               On Hold                   Unit working with sponsor to convey data and GIS standards, identify various
                                                                                                                                                                         resources, review ongoing tests and define data responsibility. 2/21/07: This
                                                                                                                                                                         project on-hold awaiting direction from business sponsor. 3/8/07: No business
                                                                                                                                                                         resources at this time. 5/2/07: No business resources at this time.

C           OEM & Small Projects (cont.)                           GIS23-27           G        G   G       G       09/01/06      02/01/07        2/1/07        G         10/01/06: Data collection complete. Project team cleaning and standardizing
            Asset Management Region 2 Pilot                                                                                                      6/1/07                  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

                                                                                                                                                                                                                                                            Robin Ness
                                                                                                                                                                         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.

             C:\Docstoc\Working\pdf\4cc51067-0bdf-41fb-baf3-245ed9505c27.xls                                                                                                                                                                           4
                                                                               Project Status




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

A           Phase 6 -OR-Trans/Pooled Fund
            GIS Layers In Progress                                   GIS19
                                                                     GIS21            G        G   G       G       06/30/04
                                                                                                                   Ongoing       06/30/05
                                                                                                                                 Ongoing       12/31/08
                                                                                                                                               Ongoing         G         Highway Hundredths 2006 (SM)
            Project categorized as:
              Projects                                                                                                                                                   Highway Ones 2006 (SM)

                                                                                                                                                                                                                                                             Tammi Griffin and Chad Brady Mead
              Design Sum
            - OEM orand construct Web based check                                                                                                                        Highway Fives (SM)
            in and out sub-numbers (Sum)
                Assign                                                                                                                                                   Highway Tens (SM)

            - Check out system                                                                                                                                           Crashes 2006
                                                                                                                                                                         STIP 08-11

A           GIS Layers Completed                                      GIS21           C        C   C       C       Completed    Completed     Completed        C         TOC Command Areas 2007 (Small) (04/07)
                                                                                                                                                                         Hazardous Waste Sites updated (OEM) (4/07)
                                                                                                                                                                         National Freight Network nonstate 2007 (Small) (4/07)
                                                                                                                                                                         National Freight Network state 2007 (Small) (4/07)
                                                                                                                                                                         Oregon Geologic Data Compilation update V3 (OEM) (4/07)
                                                                                                                                                                         Rest Area Exits 2007 (OEM) (4/07)

                                                                                                                                                                                                                                                     Susann Mead
                                                                                                                                                                         USDA/NRCS Soil Survey update (OEM) (4/07)
                                                                                                                                                                         Leaking Underground Storage Tanks update (OEM) (4/07)
                                                                                                                                                                         Flow Map 2005 (OEM) (4/07)
                                                                                                                                                                         Truck Flow Map 2005 (OEM) (4/07)
                                                                                                                                                                         Contracts (I.T.I.S. 2007 extract) (OEM) (5/07)
                                                                                                                                                                         Traffic Volume Projection 2025 - 20yr (OEM) (5/07)
                                                                                                                                                                         Bridges 2007 (OEM) (6/07)
                                                                                                                                                                         SPIS 04-06 (OEM) (6/07)
                                                                                                                                                                         RLIS (Metro database) update (OEM) (6/07)
A           GIS Infrastructure Support (cont.)                     GIS11-01           G        G   G       G        Ongoing      Ongoing       Ongoing         G         TRAINING RECEIVED:
            Training                                                                                                                                                      Building GeoDatabases I - GIS Staff (02/07)
                                                                                                                                                                          Building GeoDatabases II - GIS Staff (03/07)
                                                                                                                                                                          GPS and Field Data Collection (C. Ragain & R. Johnson) (4/07)
                                                                                                                                                                         TRAINING DELIVERED:

                                                                                                                                                                                                                                                     Susan Mead
                                                                                                                                                                          R. Johnson gave Mapbook demos to UoO and TDD (11/06)
                                                                                                                                                                          C. Ragain gave Hydro-NHD layer demo to GIS Unit (11/06)
                                                                                                                                                                          ArcView Traffic Counting App to Alsea Geospatial (12/06)
                                                                                                                                                                          S. Mead/R. Johnson Traffic Counting Refresher & TSM Unit Coaching (2/07)
                                                                                                                                                                          R. Johnson gave Mapbook training to Region 1 RTP staff (6/07)
                                                                                                                                                                          R. Johnson gave GPS centroid training to Bridge staff (6/07)
                                                                                                                                                                          R. Johnson gave metadata training to new GIS staff (6/07)

A           GIS Infrastructure Support (cont.)                     GIS11-02           G        G   G       G        Ongoing      Ongoing       Ongoing         G         DEMONSTRATIONS:
            Demonstrations                                                                                                                                                Feature Manipulation Engine (FME) (10/06)
            (6 month drop-off cycle)                                                                                                                                      Routing software demo to MC

                                                                                                                                                                                                                                                     Susan Mead
            Target:                                                                                                                                                       Project Manager TransGIS demonstration
              OTC                                                                                                                                                         Highway Finance Office TransGIS demo
              Doug Tindall, Hwy Div Manager                                                                                                                               OGIC OR-Trans demonstration
              Additional PBLT groups
              Area Managers
              Project Manager

             C:\Docstoc\Working\pdf\4cc51067-0bdf-41fb-baf3-245ed9505c27.xls                                                                                                                                                                     5
                                                                               Project Status




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

A           Phase 6 -OR-Trans/Pooled Fund
            GIS Infrastructure Support (cont.)                      GIS19
                                                                   GIS11-03           G        G   G       G       06/30/04
                                                                                                                   Ongoing       06/30/05
                                                                                                                                 Ongoing       12/31/08
                                                                                                                                               Ongoing         G         CUSTOMER SUPPORT HOURS:
            Project Support
            Customer                                                                                                                                                      46 (01/07)

                                                                                                                                                                                                                                                                 Tammi Griffin and Chad Brady Mead
            - Design and construct Web based check                                                                                                                        43 (02/07)
            in and out                                                                                                                                                    28 (03/07)

            - Check out system                                                                                                                                            24 (04/07)
                                                                                                                                                                          61 (05/07)
                                                                                                                                                                          45 (06/07)
A           GIS Infrastructure Support (cont.)                     GIS11-04           G        G   G       G       Ongoing       Ongoing       Ongoing         G         METADATA:
            Metadata                                                                                                                                                      Hwynet Annual May 2006 (09/06) (provided to Clearinghouse)
                                                                                                                                                                          City limit Annual Aug 2006 (09/06) (provided to Clearinghouse)

                                                                                                                                                                                                                                                               Susan Mead
                                                                                                                                                                          Oregon Geologic Data Compilation V2 (OGDC) (09/06 - format/import)
                                                                                                                                                                          Unstable Slopes (11/06)
                                                                                                                                                                          Temporary Employee trained and working approx. 50 docs (12/06)
                                                                                                                                                                          Metadata for 128 data layers completed and published (01/07)
                                                                                                                                                                          Metadata for 51 data layers completed and published (04/07)
                                                                                                                                                                          7/7/07: No resources

A           GIS Infrastructure Support (cont.)                     GIS11-05           G        G   G       G       Ongoing       Ongoing       Ongoing         G


A           GIS Infrastructure Support (cont.)                     GIS11-06           G        G   G       G       Ongoing       Ongoing       Ongoing         G         In Progress:
            Software                                                                                                                                                        GDT Dynamap Transportation with ACG Guide (E)
            Evaluation/Purchase/Implementation                                                                                                                              ArcPad (E)
                                                                                                                                                                            GPScorrect (E)
                                                                                                                                                                            GPS Analyst (E)
                                                                                                                                                                            GeoMedia Fusion (E)
                                                                                                                                                                            GeoMedia Transportation Manager (E)
                                                                                                                                                                            GeoMedia Transportation Analyst (E)

                                                                                                                                                                                                                                                               Chad Nielsen
                                                                                                                                                                            GeoMedia Fusion (E)
                                                                                                                                                                            Mapbook (E)
                                                                                                                                                                            Maplogic Layout Manager (E)
                                                                                                                                                                            Terrain Navigator ArcGIS Extension (E)
                                                                                                                                                                            Map2PDF (E)
                                                                                                                                                                            ArcGIS 9.2 (E) (Pending Leadership Approval)
                                                                                                                                                                            ArcGIS 9.1
                                                                                                                                                                            Descartes 8.05
                                                                                                                                                                            FME Suite 2006 GB (P)
                                                                                                                                                                            GeoMedia 6.0 (I)
H           GIS Infrastructure Support (cont.)                     GIS11-07           G        G   G       G       Ongoing       Ongoing        On Hold        G         7/13/06: Researching needs with regards to new SDE/SQL environment.
            GIS File Structure                                                                                                                                           Attending GeoHydro meetings to work through file organizational structure to

                                                                                                                                                                                                                                                               Susan Mead
                                                                                                                                                                         build their conceptual data structure. Responding to storage issues with regard
                                                                                                                                                                         to imagery by placing tiffs on alternate partition. 9/14/06: Data structure being
                                                                                                                                                                         addressed using 'layer' files. The optimal implementation of the layer files will
                                                                                                                                                                         be coordinated with Geo/Hydro/Enviro Section. 5/2/07: On hold until
                                                                                                                                                                         customer resources are available.

             C:\Docstoc\Working\pdf\4cc51067-0bdf-41fb-baf3-245ed9505c27.xls                                                                                                                                                                            6
                                                                               Project Status




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

A           Phase 6 -OR-Trans/Pooled Fund
            GIS Infrastructure Support                              GIS19
                                                                   GIS11-08           G
                                                                                      Y        G
                                                                                               Y   G
                                                                                                   Y       G
                                                                                                           Y       06/30/04
                                                                                                                   Ongoing       06/30/05
                                                                                                                                 Ongoing       12/31/08
                                                                                                                                               Ongoing         G
                                                                                                                                                               Y         3/9/06: CAD and GIS - Exploring a variety of solutions to transfer raster and

                                                                                                                                                                                                                                                                                    Ryan Johnson and Darlene
            Guidelines                                                                                                                                                   vector data between GIS and CAD software with the goal of establishing a
            - Design and construct Web based check
            GIS11-08-05 CAD and GIS                                                                                                                                      standardized solution that offers consistent results. 3/9/06: Developing
            in and out
            GIS11-08-03 Map Layouts                                                                                                                                      cartographic templates to ensure that ODOT map products have a

                                                                                                                                                                                                                                                               Chad Nielsen Griffin and Chad Brady
            - Check out system                                                                                                                                           standardized appearance and consistently contain the appropriate layout
                                                                                                                                                                         elements. 5/11/06: No current activity pending available resources. 9/14/06:
                                                                                                                                                                         No resources available. 11/01/06: New 'Mapbook' type format and output
                                                                                                                                                                         being researched and formatted for change to GIS City/County map

A           GIS Infrastructure Support                             GIS11-09           G        G   G       G       6/1/2006     8/15/2006                      G         7/13/06: Spatial Reference: Review Spatial Reference set-ups and decisions
            SDE Implementation                                                                                                                                           with Business Partners and other agencies. Review extents vs. precision to

            Spatial Reference                                                                                                                                            determine with regards to ODOT needs / GIS Unit needs / Engineering needs.
            Populate Database                                                                                                                                            Recommendation forthcoming. Populate Database: Test files have been
                                                                                                                                                                         loaded and various interactions. 9/14/06: Spatial Reference settings in place.
                                                                                                                                                                         Image loading techniques in review and being documented.11/01/06: Data
                                                                                                                                                                         identified and copied to SQL/SDE environment. 01/03/07:Additional server
                                                                                                                                                                         storage acquired. 3/8/07: Image migration in process.

                                                                                                                                                                                                                                                             Brian Dunn a
A           Phase 6 -
            Transportation Model Development                                          Y
                                                                                      G        Y
                                                                                               G   Y
                                                                                                   G       Y
                                                                                                           G       On Hold
                                                                                                                   Ongoing       On Hold
                                                                                                                                 Ongoing       On Hold
                                                                                                                                               Ongoing         Y
                                                                                                                                                               G         Phase 6 - On Hold -Data (TVTbl) has been reformatted for standard Rogue
                                                                                                                                                                         3/9/06: Marion County - 90% - On hold pending RPS work. 5/06/06:
                                                                                                                                                                         Valley MPO - complete. 7/13/06: Marion County GIS work complete

                                                                         *                     On Schedule                                                               TO = Task Order
            A=Active                                                     *                     Requires Corrective Action
            C=Complete                                                   *                     Project complete or not started                                           *Small Projects
            H=On Hold                                                                                                                                                    A*=Application
            P=Planned                                            ** Forecast of project status for next month                                                            D*=Data Development

             C:\Docstoc\Working\pdf\4cc51067-0bdf-41fb-baf3-245ed9505c27.xls                                                                                                                                                                             7
                                                                            COMPLETED PROJECTS

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

DGIS04      ITS Traffic Counting Equipment                        10/1/00    3/1/01    TDD and ITS Unit developing project plan. Gave demo to ITS Unit and field
            (Closed on 3/01/01)                                                        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.

DGIS05      TransGIS (Version 2.0)                                9/1/01               Met with Pavement, STIP coordinators, Intermodal (Freight), Congestion, Traffic Safety, Bridge and Transportation
            - Develop plan for next phase                                              Systems Monitoring. Re-scheduling to meet with Motor Carrier. Developing decision list to prioritize actions.
              - Intermodal (Freight)                                                   Integrating data collection and storage for this and Region 2 Corridor Planning. Demo to Steering Committee 3/22/01.
              - Pavement                                                               Met with Mgmt. System Managers to review data requests and formats. Continue to enhance and add features to the
              - Congestion                                                             application (Shaded Relief, Print Functions, Save Settings, etc.). Work continues to enhance performance and
              - Bridge                                                                 implement changes. Receiving data for all Hwy's: 2000 Pavement Friction, ITS Devices, partial Bridge data for Hwy
              - Traffic Counting                                                       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.

DGIS06      Highway Layer for ArcView                             9/1/00     2/28/02   Conversion program from MGE to ArcInfo. Created Measured Shapefile that can be used in ArcView 3.1. Common
             - Conversion program from MGE to ArcInfo.                                 alignments, equations and z mileages all displayed correctly. Minor problems uncovered, approx. 150 points did not
            Allows users to dynamically segment, review                                plot. Documenting process, resolving problem areas. Testing by GISU is needed to determine if the file should be
            and display their own highway data.                                        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

DGIS07      SMMS Web Based Access                                 2/15/01    5/15/02   Loaded on test machine. Resources are needed. Software ready for testing, loading 10/2/01. Software DLL conflicts
            - (DGIS 10 is complete)                                                    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

DGIS09      Automated Collision Diagram                           6/30/01              Software reviews complete, demo for Chuck complete, considering re-make of the Maryland model. City of Portland's
            - Phase 1                                                                  negative experience with the newest version of Intersection Magic and our crash data has discouraged its use. Traffic
              - Study options                                                          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

  Revised 10/12/00
                                                               COMPLETED PROJECTS

DGIS09   Automated Collision Diagram                5/30/02      9/01/02   Prototype in place and will make it similar to the in-house application (Visual Basic). Possible software to use for the
         - Phase 2                                              01/01/03   actual drawing (Visio, MapObjects, MS Paint, etc.). 10/23/01 resources identified. Re-writing software. Working on
           - Development/Testing                                           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

DGIS09   Automated Collision Diagram                 3/1/03     4/01/03    Documentation nearly complete. Purchasing visio software. NPE review underway. Deploy 2 copies to each region
         - Phase 3                                              5/22/03    HQ traffic management staff. Visio software delivered, Documentation complete, demo to OTMS Steering Committee
           - Implementation                                                3/27/03. Distribution in process. Complete

DGIS10   SMMS Metadata migration to SQL Server      2/15/01      6/1/01    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

DGIS11   DMV Project                                 8/1/01     10/1/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).
DGIS15   Access Control Demonstration               10/31/02    2/28/03    Resource materials have been acquired and sample sites chosen (The Dalles). Resources have been formatted into
          - Incorporate resources                                          standard/uniform projection. Project on hold, resources dedicated to GIS19. Project reactivated 11/10/02. Right-of-
          - Changes to CHAMPS database and                                 Way images acquired. Adobe Photoshop software on order to complete processing. Pilot covered State Highways in
         hyperlink to GIS tools                                            1 city. Pilot demo Complete .
          - Database development for ROW research

GIS01    Base Layer Development                     3/24/98     9/22/98    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.

GIS05    Aggregate Sites                            5/29/00     5/30/01    (1) Most of the application functions are complete. Adding enhancements and fixes as identified by the GeoHydro
          Phase 1                                                          users. GeoHydro forecasts completion by January 2002. Hired temp for data entry. Complete 7/13/01.
           Intranet database application
GIS05    Aggregate Sites                            1/31/01     5/30/01    2.) Coordinating integration of the GIS portion. Application complete and in testing phase. Maintenance of aggregate
          Phase 2                                                          source location data needs to be worked out between GeoHydro and the GIS Unit. Complete 7/13/01.
           Intranet GIS application
GIS05    Aggregate Sites                            12/31/00    5/30/01    3.) Script created to allow GeoHydro users to map data based on latitude and longitude values stored in the database
          Phase 3                                                          is waiting for review by Amy Landvoight and/or Mike Long. Scheduled review and acceptance June 7, 2001.
           Desktop GIS application                                         Application is only for use by the GeoHydro personnel. Complete 7/13/01.
GIS07    Non-State Hwy Functional Classification     6/1/00     12/1/01    35,000 miles of road. 11/30/00 Attribution complete. Error checking in progress. Successfully developed and tested
         System Attribution                                                the new MGE project and
                                                                           access database. Complete 10/19/01.
GIS13    State Highway 1:24,000 road alignments     6/30/01     7/31/01    Plus or Minus 40' of state highways. Complete August 2001.

 Revised 10/12/00
                                                                  COMPLETED PROJECTS

GIS14   GIS Base Layers Phase 2                        1/24/01     3/1/3102   (Dependant on the completion of GIS 17) Add new layers to GIS SQL database 6 at a time. Database modeling and
        - Select 6 new base layers                                            data acquisition is under way. Layers changed to meet the needs of the Conditions Report and TransGIS version 2.
          1-Pavement Conditions 1999                                          Received 2001 Pavement Conditions data. Congestion data has been reviewed and released in TransGIS 2.1.
          2-ITS                                                               Congestion data is being viewed again. Re-visit corporate GIS base layers and bring back to Dec. 5th meeting.
          3-Bridge                                                            Project reassigned to GIS21. Descriptions and guidelines rewritten. Complete
          4-Intermodal (FIMS)
          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    Project Statement (002,026,028), Context of the System (140), Definition of the System/Subsystems (200/210), in draft
        National Highway System to SQL                                        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

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

GIS16   Wasco County Pilot Project                     7/23/01     9/30/01    Phase 2 slightly delayed by other projects at the University; dedicated resources stretched thin resulting in attaching
         Phase 2                                                              attribution delays. Server crash caused some data loss. Other University obligations will end 10/5/01 at which time
          All roads GIS coverage                                              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.

GIS17   Upgrade of GIS related software               10/25/01     3/31/02    Test existing GIS software and databases. NPE and testing completed on all products. Complete
         Phase 1 - testing
GIS17   Upgrade of GIS related software                1/1/02      3/31/02    Implementation plans are being developed. Migrate software and databases to SQL V7.0 adding capabilities and
         Phase 2 - implementation                                             flexibility. Data structure modified and migrated to SQL 7. GeoMedia Pro is being used for production work.
GIS18   Road Authority Database                         7/1/01      10/1/01   Database built and book published. Enhancements and updates are ongoing. Complete.
GIS20   Oregon Statewide Burial Site & Cemetery        4/30/02     12/30/02   Met 9/24 to determine how to proceed with data compilation. Oregon Parks and Rec., ODOT Archeology and Mortuary
        Base Layer                                                            Board providing data. Fields confirmed at meeting. Verifying data entries. Completed GIS layer from ODOT map
        (Phase 1) (Cultural framework)                                        base cemeteries.
        - Develop GIS layer for cemeteries from
        ODOT map bases.
          (Approx. 500)

GIS20   Oregon Statewide Burial Site & Cemetery        4/30/02                Working with State Parks Div. who is adding Oregon Burial Guide cemeteries to our layer (additional 700 sites) and
        Base Layer                                                            BLM to build State Historical Preservation Office (SHPO). Complete
        (Phase 2) (Cultural framework)

 Revised 10/12/00
                                                COMPLETED PROJECTS

GIS21   GIS Layers Complete                            ATR 2002 locations (ATR's) (OEM) 10/02
         Projects categorized as:                      ADT 2001 (Average Daily Traffic) (OEM) 10/02
         OEM or Sm                                     ODOT Areas Boundaries (OEM) 11/02
          Assign sub-numbers                           ASIS Aggregate Sites (OEM) 10/02
                                                       Hwy Milepost Locations (OEM) 10/02
        (Quarterly drop-off cycle)                     Schools Locations (All public schools) (OEM) 11/02
        (Mar-Jun-Sept-Dec)                             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

GIS23   OEM & Small Projects(OEM)                      Complete:
        - Other projects completed by the GIS           Access Mgmt ArcView (DGIS13-2) 11/01
        Project Team                                    Or State Hwy No. conversion (DGIS 13-17) 8/02
                                                        A* CARS ArcExplorer (and CD for home users) (DGIS14-2) 2/03
        (Quarterly drop-off cycle)                      A* Video Log-ArcExplorer Training (GIS23-05) 2/03
        (Mar-Jun-Sept-Dec)                              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

 Revised 10/12/00
                                                                COMPLETED PROJECTS

GIS24   Tsunami Inundation Mapping Analysis          3/5/2003     4/4/03    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

GIS26   On-Line Contractor Emergency Registry        12/15/02    4/01/03    Project development nearly complete. Mixture of techniques used to accomplish project. Internet use not yet
        System                                                    5/1/03    approved. Draft model presented to ODOT end-users 3/20 by the IS team (Diane Powers). Waiting for XML templates
         - Build GIS interface to IS Web developed                          from IS Development Team. Network testing underway. Application and data complete and provided to customer. P+
        site                                                                documentation in draft stage. Complete

        ArcView Lat/Long coordinates                 08/01/00    9/15/00    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)

        Arc View Display of DGN Files                09/01/00    09/15/00   Application complete. Ready to send through product approval and Intranet roll-out. (Complete)

        ArcView Location Reference System (LRS)      08/01/00    09/15/00   Application complete. Ready to send through product approval and Intranet roll-out. Going through NPE. (Complete)
        Highway Milepoint Readout

        GPS Standards                                05/01/00    05/01/00   Document approved on April 20, 2000. Distribution is being planned

        Rail Network                                 08/01/00    03/15/00   Revisions made, forwarded to State Forestry for review. Complete and delivered to State Service Center and GIS User
        Rail Crossing                                03/15/00    05/31/00   User has accepted the ArcView Extension (application) software and installation instructions. Network testing of
                                                                            extension is complete. Extension given to user.

        Federal benchmark layer (NGS) (Complete)     07/15/00               Create National Geodetic Survey benchmark layer for Geometronics in ArcView & MGE software. (Complete)

        Desktop GIS - STIP/SIP (DGIS03a)             06/16/00    10/15/00   Software purchase complete, documentation under development. Roll-out scheduled to start the week of August 28th.
                                                                            Close after testing complete 10/10/00.
        Joint Estimation Model Data Development      05/15/00    09/30/00   Quality check household activity locations from travel survey buffer points to create environmental design variables.
        ODOT Injection Wells Inventory (Phase 1)     6/22/00     09/01/00   Building base layer of ODOT maintenance facilities (103) to satisfy Oregon's DEQ water permit requirements.
        (Complete)                                                          (Complete)
        Statewide Model Application Project           6/1/00     12/1/00    Produce presentation of output from first generation statewide model. Completed 11/1/00. Project Lead was Brian
        (Willamette Valley)                                                 Gregor.
        Non-MPO Travel Model Data Support             3/1/00     11/30/00   Base year employment & housing distributions and network characteristics. Completed 6/1/00. Project Lead was Sam
        (Lebanon)                                                           Ayash.
        Generation 2 Statewide Model                  7/1/99     12/31/01   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.

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

 Revised 10/12/00
                                                           COMPLETED PROJECTS

       Urban Transportation Model Development    9/1/01      6/1/02    Transportation Analysis Zones (TAZ) defined. Count locations submitted to Region 2. Employer and household
       - Woodburn                                                      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

       Urban Transportation Model Development   3/13/02     5/30/02    Scheduling with COG for update of existing model. Consultant compiling existing data. ODOT is collecting and
       - Roseburg                                                      reviewing traffic count data. Updating population and housing data for consultant. Complete 11/02

       Urban Transportation Model Development    5/1/02                Reviewing consultant data. Complete
       - Wilsonville

       Urban Transportation Model Development    6/1/02     12/31/02   Providing preliminary TAZ, model road network, employment and housing data to City for review. Incorporating city
       - Newberg                                                       housing and employment revisions and forecast data. Need City of Dundee to validate employment, household and
                                                                       forecast data. Complete
       Urban Transportation Model Development   12/31/02               Zone and network development in progress. Zones and network have been restructured. City has validated
       - Redmond                                                       employment and household data. Waiting for city to provide forecast data. Forecast data under development.
       Urban Transportation Model Development    7/1/02      7/1/03    Zone and network development in progress. Zones and network have been restructured. City has validated
       - Brookings                                                     employment and household data. Waiting for city to provide forecast data. Forecast data under development.
       Urban Transportation Model Development    5/1/03      7/1/03    Complete
       - Central Oregon

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