Resume Format Guide Template by bho25192


More Info
									                                                                                                               GIS Monthly Project Status Report
                                                                                                                                  July 2006
                                                                        Project Status



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

A Phase 5 - Region 3                                                 GIS04       G         G          G       05/01/03      06/30/04          6/30/2006       G         7/05: SQL db containing RES data being archived in preparation for loading new
   - Deliver final version RES & RAZ maps                                                                                                      01/31/07                 data. 9/08/05: Meeting in Roseburg in the month of September. 11/10: Meeting
  to Maintenance and other staff                                                                                                                                        complete 1/12: Planning steps for phase 5 underway. 3/9: RES Map production in
                                                                                                                                                                        progress. 5/11: Price Agreement (PA) Contractor now assisting with production
                                                                                                                                                                        tasks. 7/13/06: RAS Map production compete. Region requests postponing
                                                                                                                                                                        workshops until fall due to summer workload.
A Phase 4 - OR-Trans                                                 GIS19       Y          Y         Y       06/30/04      06/30/05          12/31/2008      Y         3/9: Data delivered to ODOT requires "processing" in preparation to loading into
   - Load data developed in Phase 3                                                                                                             3/31/06                 SQL database. Delays in loading the database is a result of prioritizing critical
   - SQL database                                                                                                                              06/30/06                 resources to other projects.
  - Complete coordination of "edge                                                                                                             12/31/06                 05/11/06: GIS Unit will explore the purchase of FME software and consultant
  matching" of road segments between                                                                                                                                    services to automate this process. GIS Unit hired a contractor to complete
  road authorities.                                                                                                                                                     attribution of county road numbers and MPs. Contract in review to document data
                                                                                                                                                                        processing and loading into OR-Trans database. 7/13: 34 of 36 county datasets
                                                                                                                                                                        for geometry of linework have been loaded, 26 of 36 have data attributes
                                                                                                                                                                        loaded. Nine of those 10 datasets we we're waiting on from GeoSolve.
                                                                                                                                                                        GeoSolve had new direction from OEM and DAS and these dataset will not be
                                                                                                                                                                        complete until starting late Summer 2006 through January 2007. We will go
                                                                                                                                                                        ahead and load the attribution that was developed through OR-Trans and
                                                                                                                                                                        OGIC and wait for the addressing from GeoSolve as we get those updates.

A            Phase 5 - OR-Trans                                      GIS19       G         G          G                     06/30/05           12/31/08       G         03/06 Continue development of state-wide addressing for 911 center needs. Work
             - State wide addressing                                                                                                                                    will be coordinated with OEM and its contractors. Additionally work will continue on
             - Pilot project; county road                                                                                                                               assigning and/or improving the county road numbering system for the county
            numbering/mp data                                                                                                                                           owned roads. This work will include a pilot coordinated thought AOC and Wasco
             - QA/QC of data and coordinate                                                                                                                             County Road master.
            correction w/ road authorities                                                                                                                              05/01/06: GeoSolve working with to update ODOT data for 911 data requirement in
             - Complete any Ph. 3 missing statewide                                                                                                                     Coos and Klamath Counties. 7/13: GeoSolve addressing: Union - done,
                                                                                                                                                                        Douglas 50%, Umatilla 50%, Coos, Douglas, Morrow not started, Harney,
                                                                                                                                                                        Tillamook, Klamath waiting for contract, Wallowa not tasked out yet. ODOT
                                                                                                                                                                        county rd #/ MP: Lake, Wallowa, Union, Umatilla, Morrow done and need to
                                                                                                                                                                        be reviewed by counties. Gilliam, Sherman and Wheeler done and on internal
                                                                                                                                                                        QA/QC before they need to be reviewed by the county. GeoSolve has Wasco,
                                                                                                                                                                        Sherman, Gilliam, Wheeler, Grant, Union, Lake, Columbia and Lincoln on
                                                                                                                                                                        contract for maintenance of GIS data (includes addressing).

               D:\Docstoc\Working\pdf\83815aa7-9d6c-4956-8c73-21f529fb87c8.xls                                                           1                                                                                         10:39 PM   7/17/2010
                                                                                                            GIS Monthly Project Status Report
                                                                                                                               July 2006
                                                                     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                     06/30/05           12/31/08       G         1/12: Work continues to be done on a software solution to allow road authorities
  Project                                                                                                                                                            the ability to "check in" and "check out" data through a web interface for a pilot
   - Design and construct Web based                                                                                                                                  project with King and Pierce County. The source code for this ability is being
  check-in and                                                                                                                                                       developed through an existing contract between WashDOT and ESRI. The goal of
   - check-out system                                                                                                                                                this pilot project is to develop code that uses data translation technology so that the
                                                                                                                                                                     source code can be slightly modified to work with various GIS data and GIS
                                                                                                                                                                     database formats. 3/9: Will provide update after the GIS-T meeting to be held later
                                                                                                                                                                     this month in Ohio.
                                                                                                                                                                     05/11/06: Met with Pooled-Fund states at GIS-T 2006
                                                                                                                                                                     7/13: Puget Sound Pilot is complete, implementation of FME software will
                                                                                                                                                                     occur in July 2006 and testing phase with county datasets from Oregon and
                                                                                                                                                                     Washington that abut each other will occur during the remainder of 2006.

H EnviroView - Environmental Data                                 GIS31       Y          Y         Y                                                       Y         Phase 2 - Presented Project Statement for phases 2, 3 and 4 to Steering
  Management System                                                                                                                                                  Committee 5/26/04, approved pending modifications. On hold until strategic plan is
  (formerly SR-SAM)                                                                                                                                                  developed and approved. GIS 37 will complete a pilot for field data collection of
  Phase 2 - Field data collection and                                                                                                                                biological data. 11/10: Will discuss direction of project with Hal Gard. 1/12: GIS37
  management                                                                                                                                                         pilot now complete. 3/9: Project being reactivated and revised project request to
                                                                                                                                                                     be presented at 5/11 GIS Steering Committee Meeting. 5/11: EDMS Plan review
                                                                                                                                                                     and revision continues. 7/13: Input gathered from EDMS review at CETAS,
                                                                                                                                                                     NEPA and Planning Workshop, FHWA coordination and TRB Environmental
                                                                                                                                                                     Analysis Committee.
H Traffic Counting GIS Implementation                                         Y          Y         Y       12/01/04      02/28/05          6/1/20/05       Y         7/05: Traffic Volume Flow Map and Enlargements have been constructed in an
  Phase 5                                                                                                                                    8/15/05                 automated ArcGIS environment. Drafts available July 6th. GIS shapefiles
   - Create data entry system for traffic data                                                                                                                       complete for ATR, Flow Map and AADT 2004. Equipment Inventory was turned
   - Create database tables, site inspection,                                                                                                                        over to temporary staff who has taken permanent employment elsewhere. 9/08/05:
  vendor info.                                                                                                                                                        On hold until resources become available. 1/12: Evaluating vendor software
   - Equipment Inventory Detail                                                                                                                                      instead of creating in-house software. Software currently used by ITS. 3/9:
   - Create data entry interface(s) for equip                                                                                                                        Evaluations continuing. 5/11: Determination was made to use ITS Asset Inventory
  inventory                                                                                                                                                          software. This software will also be used to track signals. A future project will be to
   - Provide imagery linking & view options                                                                                                                          develop a GIS interface. This project will be closed until that request is made.
                                                                                                                                                                     7/13: Maintenance Work: Data Entry Interfaces have been updated to connect
                                                                                                                                                                     to new database format. Traffic Volume Report is functional. Data entry in
                                                                                                                                                                     progress. Resources intermittent due to TSM staff change and the number of
                                                                                                                                                                     projects in process through the GIS Unit.

            D:\Docstoc\Working\pdf\83815aa7-9d6c-4956-8c73-21f529fb87c8.xls                                                           2                                                                                           10:39 PM   7/17/2010
                                                                                                            GIS Monthly Project Status Report
                                                                                                                               July 2006
                                                                     Project Status



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

A DMV Oregon Automobile Dealers                                   GIS41       Y          Y         Y       07/11/05      08/01/05          9/30/2005       Y         1/12: Waiting for DMV to complete review data. 3/9: Data posted on the GIS
                                                                                                                                            12/31/05                 server. Waiting for DMV to complete review of data. 5/11/06: Working closely with
                                                                                                                                            2/01/06                  the DMV customer attempting to identify the remaining 130 sites an
                                                                                                                                            04/01/06                 inconsistencies in the database was identified causing difficulties updating the
                                                                                                                                            06/30/06                 data. A "Site-ID" will be implemented allowing updates without re-geocoding the
                                                                                                                                            08/01/06                 data every time. 7/13: GIS Unit provided additional fields to be included in the
                                                                                                                                                                     DMV database to allow for site location accuracy improvements and location
                                                                                                                                                                     tracking. Recommendation will be based on GIS/ODOT 'spatial location' data
                                                                                                                                                                     standards. DMV database architect has identified time to process the
                                                                                                                                                                     request. Once added, GIS Unit will re-geocode every location. The review
                                                                                                                                                                     process will then proceed.

P TOC GIS Interface                                               GIS42       Y          Y         Y       05/01/06      05/01/07                          Y         05/11/06 Chuck Larsen has prepared a phase 2 project proposal.
  Phase 2
   - Implementation of viewing tool
  - Provide GIS expertise to the project
A Traffic Mobility Management System                              GIS39       G         G          G       03/01/06                                        G         3/9: Phase 2 Project plan under review, work to commence immediately by MC in
  Phase 2                                                                                                                                                            March 06.
    • Develop data models and business                                                                                                                               05/11/06: Internal MC discussions underway to determine project requirements,
  processes based on recommendations                                                                                                                                 GIS Project team waiting results.
  and findings from Phase 1.
    • Create/capture and catalogue data (or
  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.

H Region 1 Development Review                                                 Y          Y         Y       08/29/05                                        Y         9/08/05: Will start project when price agreement contracts are executed.
                                                                                                                                                                     11/10: On hold while Region 1 reviews project goals. 1/12: Region 1 moving
                                                                                                                                                                     forward with reviews. 5/11: A development review database is being translated
                                                                                                                                                                     from MS Access to SQL and will be distributed statewide. 7/13: Connection to GIS
                                                                                                                                                                     is unclear at this time.

            D:\Docstoc\Working\pdf\83815aa7-9d6c-4956-8c73-21f529fb87c8.xls                                                           3                                                                                       10:39 PM   7/17/2010
                                                                                                            GIS Monthly Project Status Report
                                                                                                                               July 2006
                                                                     Project Status



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

A GIS Layers In Progress                                          GIS21       G         G          G       Ongoing       Ongoing                           G         Exits and Interchanges 2005 (Sm)
   Projects categorized as:                                                                                                                                          MPOs 2005 (Sm)
   OEM or Sm                                                                                                                                                         Oregon Auto Dealers 2005 (Sm)
    Assign sub-numbers (Sm)                                                                                                                                          NHS 2005 (OEM)
                                                                                                                                                                     Routes 2005 (OEM)
                                                                                                                                                                     Medians 2005 (OEM)
                                                                                                                                                                     House and Senate Districts 2005 (add phone and names) (OEM)
                                                                                                                                                                     Vehicle Class 2004 (OEM)
                                                                                                                                                                     Truck Flow Map 2004 (OEM)
                                                                                                                                                                     Rail Crossings 2005 (OEM)
                                                                                                                                                                     Crashes 2004 (OEM)
                                                                                                                                                                     SIP segs (crash segs) 2004 (OEM)
                                                                                                                                                                     Metro Leaf Off 2005 Imagery (Sm)
                                                                                                                                                                     STIP 04-06 ALL 3rd qrtr update (Sm)
                                                                                                                                                                     Non-hwy roads and road text from CAD 2005 (Sm)
                                                                                                                                                                     STIP 06-09 All segs development (Sm)
                                                                                                                                                                     Scenic Byways 2005 (Sm) (In review)
                                                                                                                                                                     Highway Tenths 2005 (Sm)
                                                                                                                                                                     Springfield 2004 Imagery OGIC (Sm)
                                                                                                                                                                     WIM count location 2005 (Sm)
                                                                                                                                                                     Access Management Approach Permits Fall 2005 (Sm)
                                                                                                                                                                     County Boundaries (OEM)

            D:\Docstoc\Working\pdf\83815aa7-9d6c-4956-8c73-21f529fb87c8.xls                                                           4                                                                                  10:39 PM   7/17/2010
                                                                                                            GIS Monthly Project Status Report
                                                                                                                               July 2006
                                                                     Project Status



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

C GIS Layers Completed                                            GIS21       C          C         C                                                       C         SIP segs (crash segs) 02-04 (OEM) (12.05)
                                                                                                                                                                     Metro Leaf Off 2005 Imagery SPN (Sm) (12/05)
                                                                                                                                                                     Metro Leaf Off 2005 Imagery OGIC (Sm) (12/05)
                                                                                                                                                                     Metro Leaf On 2004 Imagery SPN (Sm) (12/05)
                                                                                                                                                                     Springield 2004 Imagery SPN (Sm) (12/05)
                                                                                                                                                                     ODOT Aggregate Fall 2005 (OEM) (11/05)
                                                                                                                                                                     Freight System Highways 2005 (Sm) (12/05)
                                                                                                                                                                     Federal Urban Transp Bndry 2005 (OEM) (12/05)
                                                                                                                                                                     Highway Ones 2005 (OEM) (12/05)
                                                                                                                                                                     Highway Fives 2005 (OEM) (12/05)
                                                                                                                                                                     Highway Tens 2005 (OEM) (12/05)
                                                                                                                                                                     RIAS Contract Plan Index 2005 (OEM) (12/05)
                                                                                                                                                                     RIAS Right-of-Way Map Index 2005 (OEM) (12/05)
                                                                                                                                                                     STA, UBA, CC 2005 (OEM) (12/05)
                                                                                                                                                                     Statewide SRA (Salmon Resource Areas) (OEM) (12/05)
                                                                                                                                                                     Struct Def Bridges 2006 (OEM) (01/06)
                                                                                                                                                                     Wt Rstrctd Bridges 2006 (OEM) (01/06)
                                                                                                                                                                     BLMOR (BLM Jurisdictions) (OEM) (01/06)
                                                                                                                                                                     Green Light Sites 2006 (OEM) (01/06)
                                                                                                                                                                     Highway Network Jan 2006 (OEM) (01/06)
                                                                                                                                                                     Crashes2004 (OEM) (02/06)
                                                                                                                                                                     STIP 06-09 All segs development DRAFT (Sm) (02/06)
                                                                                                                                                                     Lifeline2006 (OEM) (02/06)
                                                                                                                                                                     Connect Oregon Boundaries 2006 (OEM) (02/06)
                                                                                                                                                                     STIP 2006 Construction Projects (OEM) (02/06)
                                                                                                                                                                     Interchange Aerials (historic) (OEM) (02/06)
                                                                                                                                                                     NAIP_CCM_05 (Natl Agric Imgry Prog) (OEM) (02/06)
                                                                                                                                                                     Oregon Auto Dealers 2005 (Sm) (03/06)
                                                                                                                                                                     Hwy Tenths (OEM) (04/06)

            D:\Docstoc\Working\pdf\83815aa7-9d6c-4956-8c73-21f529fb87c8.xls                                                           5                                                                                    10:39 PM   7/17/2010
                                                                                                            GIS Monthly Project Status Report
                                                                                                                               July 2006
                                                                     Project Status



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

A GIS Infrastructure Support (cont.)                            GIS11-01      G         G          G       Ongoing       Ongoing                           G         TRAINING RECEIVED:
  Training                                                                                                                                                                   GIS-T Conference (Milt) (04/06)
                                                                                                                                                                             Remedy Tracking (GIS Customer Support Team) (06/06)
                                                                                                                                                                             Advanced Analysis with ArcGIS (Ryan, Darlene, Casey, Phil)
                                                                                                                                                                             Arc GIS Tools and Techniques (Mike. Chad C.)

                                                                                                                                                                     TRAINING DELIVERED:
                                                                                                                                                                             "Using Spatial Analysis Tools to Correct Tabular Data"
                                                                                                                                                                              (delivered by Marcia Malstrom) (Bruce, Dee, Jennifer) (04/06)
                                                                                                                                                                              ArcReader Application for Connect Oregon
                                                                                                                                                                              Project (delivered by Ryan Johnson) (04/06)
                                                                                                                                                                              SMMS Metadata Tool Use (delivered by Ryan Johnson)
                                                                                                                                                                              (Dennis Stephens) (04/06)
                                                                                                                                                                              ArcView 3.x Application for Traffic Counting (delivered by
                                                                                                                                                                              Ryan Johnson) (04/06)
                                                                                                                                                                              GIS Overview for Access Management (delivered by
                                                                                                                                                                              Ryan Johnson) (04/06)
                                                                                                                                                                              SMMS Metadata (Robin Ness, Kelly Zobrist) (06/06)
                                                                                                                                                                              Traffic Counting Field App. (Kevin, Ray) (06/06)

A GIS Infrastructure Support (cont.)                            GIS11-02      G         G          G       Ongoing       Ongoing                           G         DEMONSTRATIONS:
  (6 month drop-off cycle)
    Doug Tindall, Hwy Div Manager
    Additional PBLT groups
    Area Managers
    Project Manager

A GIS Infrastructure Support (Cont)                             GIS11-03      G         G          G       Ongoing       Ongoing                           G         DAILY CUSTOMER SUPPORT:
  Customer Support                                                                                                                                                          80 hours (10/05)
                                                                                                                                                                            60 hours (9/05)
                                                                                                                                                                            46 hours (12/05)
                                                                                                                                                                            129 hours (01/06)
                                                                                                                                                                            142 hours (04/06)
                                                                                                                                                                            25 (05/06)
                                                                                                                                                                            30 (06/06)
A GIS Infrastructure Support (cont.)                            GIS11-04      G         G          G       Ongoing       Ongoing                           G         METADATA:
  Metadata                                                                                                                                                                 Hwynet Jan 2006 (01/06) (also provided to Clearinghouse)
                                                                                                                                                                           Citylimit 2005 (01/06) (also provided to Clearinghouse)

            D:\Docstoc\Working\pdf\83815aa7-9d6c-4956-8c73-21f529fb87c8.xls                                                           6                                                                                   10:39 PM   7/17/2010
                                                                                                            GIS Monthly Project Status Report
                                                                                                                               July 2006
                                                                     Project Status



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

A GIS Infrastructure Support (Cont)                             GIS11-05      G         G          G       Ongoing       Ongoing                           G         3/9: Oversight Committee is developing list of tasks, assigning and identifying
  Standards                                                                                                                                                          resources and estimating project timelines. 5/11: Tasks assigned. Geometronics
  GIS11-05-01 Resource Grade GPS                                                                                                                                     will house standards, guidelines, processes, procedures and other information.
  Standards                                                                                                                                                          Estimated completion date is 7/15/06.

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

                                                                                                                                                                             ArcGIS 9.1
                                                                                                                                                                             Descartes 8.05

A GIS Infrastructure Support                                    GIS11-07      G         G          G       Ongoing       Ongoing                           G         3/9: Addressing data storage needs, customer recommendations and new data
  (Cont)                                                                                                                                                             formats. 7/13: Researching needs with regards to new SDE/SQL environment.
  GIS File Structure                                                                                                                                                 Attending GeoHydro meetings to work through file organizational structure to
                                                                                                                                                                     build their conceptual data structure. Responding to storage issues with
                                                                                                                                                                     regard to imagery by placing tifs on alternate partition.

A GIS Infrastructure Support                                    GIS11-08      Y          Y         Y       Ongoing       Ongoing                           Y         3/9: CAD and GIS - Exploring a variety of solutions to transfer raster and vector
  Guidelines                                                                                                                                                         data between GIS and CAD software with the goal of establishing a standardized
  GIS11-08-05 CAD and GIS                                                                                                                                            solution that offers consistent results.
  GIS11-08-03 Map Layouts                                                                                                                                            3/9: Map Layouts - Developing cartographic templates to ensure that ODOT map
                                                                                                                                                                     products have a standardized appearance and consistently contain the appropriate
                                                                                                                                                                     layout elements. 5/11: No current activity pending available resources.

A GIS Infrastructure Support                                    GIS11-09      G         G          G       6/1/2006     8/15/2006                           g        7/13: Spatial Reference: Review Spatial Reference set-ups and decisions with
  SDE Implementation                                                                                                                                                 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.

A OEM & Small Projects (Cont)                                   GIS23-02      G         G          G       Ongoing       Ongoing            07/31/06       G         3/9: Existing CAD files and current brochure descriptions were used to create a
  Scenic Byways GIS Implementation                                                                                                                                   GIS layer/theme. Customer reviewed the theme. Additional text is being created by
                                                                                                                                                                     customer team. 5/11: GIS Unit has produced routes from "Detailed Driving
                                                                                                                                                                     Directions" document. 7/13: GIS Unit working w/ RICS Unit to review milepoints
                                                                                                                                                                     and details of 'drive-path'.

            D:\Docstoc\Working\pdf\83815aa7-9d6c-4956-8c73-21f529fb87c8.xls                                                           7                                                                                       10:39 PM   7/17/2010
                                                                                                            GIS Monthly Project Status Report
                                                                                                                               July 2006
                                                                     Project Status



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

A OEM & Small Projects (Cont)                                   GIS23-03      G         G          G       Ongoing       Ongoing            09/01/06       G         3/9: Data provided by customer had to be re-extracted several times. Questions
  Access Management GIS Implementation                                                                                                                               remain about certain records. 5/11: Training provided to customer. GIS Unit has
                                                                                                                                                                     produced DRAFT dataset. 7/13: Coordinate fields added to CHAMPS database
                                                                                                                                                                     to allow for more accurate locational methods. No resources available at this
A OEM & Small Projects (Cont)                                   GIS23-04      G         G          G       1/11/2006    3/15/2006          12/31/2006      G         3/9: Existing highway system count database rewritten to accommodate multiple
  Traffic Counting Field Data Collection                                                                                                    6/1/2006                 counts/history and incorporation of non-system data. Non-highway count system
                                                                                                                                            07/15/06                 was reformatted and incorporated into the existing highway system database.
                                                                                                                                                                     Software application rewritten based on Fall 2005 review by customer. First dry-
                                                                                                                                                                     run of system revealed that to use the new features - additional scripting and
                                                                                                                                                                     'Routing' scheme must be added to the application. Training proposed for
                                                                                                                                                                     03/14/06. 5/11: Terry Trussel has received training. 7/13: Customers have
                                                                                                                                                                     received frequent training refresher courses. Data entry has been validated.
                                                                                                                                                                     Insufficient resources to address 'instant-update' to main database. Other
                                                                                                                                                                     report capability not distributed until resources available.

A OEM & Small Projects (Cont)                                   GIS23-05      G         G          G       2/6/2006      03/05/06          12/31/2006      G         3/9: Phase 1 - Database constructed to meet Connect Oregon Submittal needs
  Connect Oregon                                                                                                         Phase 1             7/1/06                  and provide spatial or locational data elements (lat/lon). Data entry screens
                                                                                                                                                                     created to allow customer to enter information from submittal documents. Map
                                                                                                                                                                     requirements received and additional GIS themes created to address customer
                                                                                                                                                                     needs. Customers now entering data while consultant reviews submittals. 5/11:
                                                                                                                                                                     Additional projects have been added to database by customer. Database and
                                                                                                                                                                     mapping work continues. 7/13: Database and ArcReader products complete.
                                                                                                                                                                     Customer now working with TransGIS team to develop Web GIS tools.

H OEM & Small Projects (Cont)                                   GIS23-09      G         G          G       6/9/2006     10/1/2006                          G         7/13: GIS Team is awaiting data and value or rating system.
  Asset Management Safety Rating Pilot

C OEM & Small Projects (Cont)                                   GIS23-12      C          C         C       5/18/2006    6/26/2006                          C         7/13: GIS Team gathered requested data layers, mapped features, performed
  Steep Slope Congestion analysis                                                                                                                                    overlay analysis and created maps. Completed 06/15/06.

C OEM & Small Projects (Cont)                                   GIS23-16      C          C         C       4/12/2006    6/15/2006                          C         7/13: GIS Unit worked with ODOT Customer Support to develop
  REMEDY customer support development                                                                                                                                Category/Item/Type tracking scheme, initiate software installation and
  and implementation                                                                                                                                                 subsequent training. GIS Customer Support Team has received training and
                                                                                                                                                                     tracking support tasks in Help Desk standard software/database. Standard
                                                                                                                                                                     reports will be developed as needed. Completed 06/26/06.

C OEM & Small Projects (Cont)                                   GIS23-18      C          C         C       5/15/2006     6/1/2006                          C         7/13: GIS Unit worked with ODOT Bridge Unit to identify analysis
  Bridge data enhancement for                                                                                                                                        requirements. GIS Unit utilized GIS tools to provide an enhanced dataset
  boundary/permitting review efficiency                                                                                                                              containing approximately 10 boundary layers worth of data. Completed

            D:\Docstoc\Working\pdf\83815aa7-9d6c-4956-8c73-21f529fb87c8.xls                                                           8                                                                                       10:39 PM   7/17/2010
                                                                                                              GIS Monthly Project Status Report
                                                                                                                                 July 2006
                                                                       Project Status



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

A OEM & Small Projects (Cont)                                     GIS23-19      G         G          G       5/18/2006    unknown                            G         7/13: GIS Unit processed GPS data from 'conditions report' data collection
  GPS Access Management Demonstration                                                                                                                                  effort, identifying all access points on selected highways. GPS mapping
  Project                                                                                                                                                              compared to Permit Specialist location data (CHAMPS). Quality, validity,
                                                                                                                                                                       record matching needs under analysis. Region 1, Access Management and
                                                                                                                                                                       GIS management planning additional meetings.

C OEM & Small Projects (Cont)                                     GIS23-20      C          C         C       6/7/2006     6/20/2006                          C         7/13: GIS Unit worked with Russ Frost to identify analysis and map
  Federal Material Sources and Land Use                                                                                                                                requirements. Requirements changed once during the project. Completed
  Zoning                                                                                                                                                               06/26/06.
H OEM & Small Projects (Cont)                                     GIS23-07      Y          Y         Y       Ongoing       Ongoing                           Y         3/9: Met with ODOT Maintenance and Water Resource Department (WRD) to
  Water Withdrawal Permitting                                                                                                                                          assess requirements. WRD will accept GIS data as "map" for permit requirement.
                                                                                                                                                                       5/11: GIS data for permit request has been produced, reviewed by Maintenance
                                                                                                                                                                       and delivered to Maintenance. Project will see no activity until WRD returns results
                                                                                                                                                                       of submission.

A Transportation Model Development                                              G         G          G       Ongoing       Ongoing                           G         3/9: Marion County - 90% - On hold pending RPS work.
                                                                                                                                                                       5/06 Rogue Valley MPO - complete
                                                                                                                                                                       7/13: Marion County GIS work complete


                                                                       *                    On Schedule
            *** Status                                                 *                    Requires Attention                                                         OEM = Operations & Essential Maint.
            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

              D:\Docstoc\Working\pdf\83815aa7-9d6c-4956-8c73-21f529fb87c8.xls                                                           9                                                                                         10:39 PM   7/17/2010
                                                                COMPLETED PROJECTS

                                                        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.
         - Develop GIS software evaluation guidelines               3/1/02    1/23/03   ARC IMS Web software received 9/25/00. Installed and sent through
        (complete)                                                            5/22/03   NPE. Approval received to purchase software. Placed on hold for lack of
         - Develop test plan template                                         7/24/03   resources. Returned to active status 1/22/02. Draft of GIS Software
        (complete)                                                                      Evaluation Guidelines presented to Steering Committee 3/28/02. Dennis
         - Develop template for cost analysis                                           will make revisions and bring to 1/23/03 committee meeting. Using
        (Life cycle costs)                                                              purchase of SDE (spatial data engine) GIS server software to develop
                                                                                        and test process. (Will not work with OTS software). Used proposed
DGIS04 ITS Traffic Counting Equipment                              10/1/00    3/1/01    TDD and ITS Unit developing project plan. Gave demo to ITS Unit and
       (Closed on 3/01/01)                                                              field
                                                                                        technicians. Waiting for data needs assessment from ITS Unit. Roll-out
                                                                                        database using Internet GIS viewing tool as pilot. Updating and cleaning
                                                                                        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,
       - Develop plan for next phase                                                    Traffic Safety, Bridge and Transportation Systems Monitoring. Re-
         - Intermodal (Freight)                                                         scheduling to meet with Motor Carrier. Developing decision list to
         - Pavement                                                                     prioritize actions. Integrating data collection and storage for this and
         - Congestion                                                                   Region 2 Corridor Planning. Demo to Steering Committee 3/22/01. Met
         - Bridge                                                                       with Mgmt. System Managers to review data requests and formats.
         - Traffic Counting                                                             Continue to enhance and add features to the application (Shaded Relief,
                                                                                        Print Functions, Save Settings, etc.). Work continues to enhance
                                                                                        performance and implement changes. Receiving data for all Hwy's: 2000
                                                                                        Pavement Friction, ITS Devices, partial Bridge data for Hwy 162, ADT's
                                                                                        and Speed data. Training complete, roll out from Mark Robinson on
                                                                                        9/28/01. Complete 10/22/01 will be distributed to 60-70 additional users.
                                                                                        In maintenance - to develop project plan for next phase.

   Revised 10/12/00
                                                         COMPLETED PROJECTS

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

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

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

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

   Revised 10/12/00
                                                     COMPLETED PROJECTS

DGIS09 Automated Collision Diagram                       3/1/03    4/01/03   Documentation nearly complete. Purchasing visio software. NPE review
       - Phase 3                                                   5/22/03   underway. Deploy 2 copies to each region HQ traffic management staff.
         - Implementation                                                    Visio software delivered, Documentation complete, demo to OTMS
                                                                             Steering Committee 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
        - Incorporate resources                                              Dalles). Resources have been formatted into standard/uniform
        - Changes to CHAMPS database and hyperlink                           projection. Project on hold, resources dedicated to GIS19. Project
       to GIS tools                                                          reactivated 11/10/02. Right-of-Way images acquired. Adobe Photoshop
        - Database development for ROW research                              software on order to complete processing. Pilot covered State Highways
                                                                             in 1 city. Pilot demo Complete .

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

GIS05   Aggregate Sites                                 5/29/00    5/30/01   (1) Most of the application functions are complete. Adding
         Phase 1                                                             enhancements and fixes as identified by the GeoHydro users. GeoHydro
          Intranet database application                                      forecasts completion by January 2002. Hired temp for data entry.
                                                                             Complete 7/13/01.
GIS05   Aggregate Sites                                 1/31/01    5/30/01   2.) Coordinating integration of the GIS portion. Application complete and
         Phase 2                                                             in testing phase. Maintenance of aggregate source location data needs
          Intranet GIS application                                           to be worked out between GeoHydro and the GIS Unit. Complete 7/13/01.

GIS05   Aggregate Sites                                 12/31/00   5/30/01   3.) Script created to allow GeoHydro users to map data based on latitude
         Phase 3                                                             and longitude values stored in the database is waiting for review by Amy
          Desktop GIS application                                            Landvoight and/or Mike Long. Scheduled review and acceptance June 7,
                                                                             2001. Application is only for use by the GeoHydro personnel. Complete

  Revised 10/12/00
                                                         COMPLETED PROJECTS

GIS07   Non-State Hwy Functional Classification System       6/1/00     12/1/01    35,000 miles of road. 11/30/00 Attribution complete. Error checking in
        Attribution                                                                progress. Successfully developed and tested 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.
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
        - Select 6 new base layers                                                 database 6 at a time. Database modeling and data acquisition is under
          1-Pavement Conditions 1999                                               way. Layers changed to meet the needs of the Conditions Report and
          2-ITS                                                                    TransGIS version 2. Received 2001 Pavement Conditions data.
          3-Bridge                                                                 Congestion data has been reviewed and released in TransGIS 2.1.
          4-Intermodal (FIMS)                                                      Congestion data is being viewed again. Re-visit corporate GIS base
          5-Crash                                                                  layers and bring back to Dec. 5th meeting. Project reassigned to GIS21.
          6-Non State Highway Functional Class                                     Descriptions and guidelines rewritten. Complete
          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
        National Highway System to SQL                                             of the System/Subsystems (200/210), in draft form awaiting approval.
                                                                                   Began work on possible data model. Project Plan approved. Two
                                                                                   prototype databases created on SQL server 7.0 for evaluation purposes
                                                                                   on 8/31/01. Testing prototype SQL server database (HGIS15a) using
                                                                                   COTS (commercial off the shelf) software. Querying, reporting and
                                                                                   updating capabilities are being tested using GeoMedia Pro, Access and
                                                                                   SQL Server utilities. Database model has been updated, preparing
                                                                                   documentation (P Plus Deliverables 170, 180 and 190). Testing and
                                                                                   migration complete. Complete

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

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

  Revised 10/12/00
                                                       COMPLETED PROJECTS

GIS17   Upgrade of GIS related software                   10/25/01   3/31/02    Test existing GIS software and databases. NPE and testing completed
         Phase 1 - testing                                                      on all products. Complete
GIS17   Upgrade of GIS related software                    1/1/02    3/31/02    Implementation plans are being developed. Migrate software and
         Phase 2 - implementation                                               databases to SQL V7.0 adding capabilities and flexibility. Data structure
                                                                                modified and migrated to SQL 7. GeoMedia Pro is being used for
                                                                                production work. Complete
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 Base      4/30/02    12/30/02   Met 9/24 to determine how to proceed with data compilation. Oregon
        Layer                                                                   Parks and Rec., ODOT Archeology and Mortuary Board providing data.
        (Phase 1) (Cultural framework)                                          Fields confirmed at meeting. Verifying data entries. Completed GIS layer
        - Develop GIS layer for cemeteries from ODOT                            from ODOT map base cemeteries.
        map bases.
          (Approx. 500)
GIS20   Oregon Statewide Burial Site & Cemetery Base      4/30/02               Working with State Parks Div. who is adding Oregon Burial Guide
        Layer                                                                   cemeteries to our layer (additional 700 sites) and BLM to build State
        (Phase 2) (Cultural framework)                                          Historical Preservation Office (SHPO). Complete

  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 Project                    Access Mgmt ArcView (DGIS13-2) 11/01
        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)
                                                                         D* Bridge Location Project (11/03)
                                                                         D* 650 Map Project (11/03)
                                                                         A* Bridge Location to Web (11/03)

  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 System         12/15/02   4/01/03    Project development nearly complete. Mixture of techniques used to
        - Build GIS interface to IS Web developed site                   5/1/03    accomplish project. Internet use not yet approved. Draft model
                                                                                   presented to ODOT end-users 3/20 by the IS team (Diane Powers).
                                                                                   Waiting for XML templates from IS Development Team. Network testing
                                                                                   underway. Application and data complete and provided to customer. P+
                                                                                   documentation in draft stage. Complete
        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
        Highway Milepoint Readout                                                  Intranet roll-out. Going through NPE. (Complete)

        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 Group.
        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
        (Medford)                                                                  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
        (Complete)                                                                 Oregon's DEQ water permit requirements. (Complete)
        Statewide Model Application Project (Willamette       6/1/00    12/1/00    Produce presentation of output from first generation statewide model.
        Valley)                                                                    Completed 11/1/00. Project Lead was Brian Gregor.
        Non-MPO Travel Model Data Support (Lebanon)           3/1/00    11/30/00   Base year employment & housing distributions and network
                                                                                   characteristics. Completed 6/1/00. Project Lead was Sam Ayash.

  Revised 10/12/00
                                              COMPLETED PROJECTS

     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.
     - Coos Bay/North Bend                                             Recent vacancies in both City of Coos Bay and ODOT Region 3 have
                                                                       slowed progress on this project. Employment and household data
                                                                       complete. Entering traffic count data. Complete 12/31/01

     Urban Transportation Model Development       9/1/01     6/1/02    Transportation Analysis Zones (TAZ) defined. Count locations submitted
     - Woodburn                                                        to Region 2. Employer and household geocoding in progress. Region 2
                                                                       will be hiring a consultant to perform field data collection. Employer and
                                                                       household geocoding complete. Region 2 has contracted with consultant
                                                                       to perform field data collection. TAZ and Network being finalized.
                                                                       Analyzing traffic counts to network links. Incorporated city's housing and
                                                                       employment revisions. Complete

     Urban Transportation Model Development      3/13/02    5/30/02    Scheduling with COG for update of existing model. Consultant compiling
     - Roseburg                                                        existing data. ODOT is collecting and 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
     - Newberg                                                         data to City for review. Incorporating city housing and employment
                                                                       revisions and forecast data. Need City of Dundee to validate
                                                                       employment, household and forecast data. Complete
     Urban Transportation Model Development      12/31/02              Zone and network development in progress. Zones and network have
     - Redmond                                                         been restructured. City has validated employment and household data.
                                                                       Waiting for city to provide forecast data. Forecast data under
                                                                       development. Complete
     Urban Transportation Model Development       7/1/02     7/1/03    Zone and network development in progress. Zones and network have
     - Brookings                                                       been restructured. City has validated employment and household data.
                                                                       Waiting for city to provide forecast data. Forecast data under
                                                                       development. Complete
     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