Monthly Status Report Template for Team Leader - Excel

Document Sample
Monthly Status Report Template for Team Leader - Excel Powered By Docstoc
					                                                                                                               GIS Monthly Project Status Report
                                                                                                                                 March 2006
                                                                       Project Status




                                                                                           February
                                                                                 January




                                                                                                                                                            Projected
Status***




                                                                                                                                                             Status**
                                                                                                      March
                                                                   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          06/30/06        G         7/05: SQL db containing RES data being archived in preparation for loading new
   - Deliver final version RES & RAZ maps                                                                                                                               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.

C OR Trans (formerly All Roads, formerly                            GIS19        C          C         C                     06/30/05          12/30/05        C         In June we assumed the task of developing three additional county datasets.
  OTN)                                                                                                                                         3/31/06                  Census was scheduled to complete this work but was unable to meet tour timeline.
  Phase 3 -                                                                                                                                                             We were unable to complete the three, Tillamook, Coos and Grant counties by
  - Develop county-wide GIS data for Baker,                                                                                                                             12/31/05. The estimated time for delivery of the data is the end of January 06.
  Malheur, Harney, Lake and Klamath                                                                                                                                     There will be a couple weeks of QA/QC and question resolution and those datasets,
  under TSD Safety Grant.                                                                                                                                               along with Columbia county, which is being done by the county should be loaded in
  - Load developed data that is available                                                                                                                               the database by 3/31/06. 3/9: U of O - Tillamook completed by mid-March. BLM -
  from other agencies (fed, state, and local).                                                                                                                          Coos completed by mid-March. GeoSolve - Grant and Columbia completed by mid-
   - Develop county wide GIS data for                                                                                                                                   March with Hood River delivered late March. *Note* GeoSolve contract under the
  Grant, Hood River and Coos as part of                                                                                                                                 authority of OEM and GEO, completion times are estimates. 5/11/06: Phase 3
  additional OGIC funding.                                                                                                                                              Complete.




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                                                                                                                                      05/11/06: GIS Unit will explore the purchase of FME software and consultant
  matching" of road segments between road                                                                                                                               services to automate this process. GIS unit hired a contractor to complete
  authorities.                                                                                                                                                          attribution of county road numbers and MPs. Contract in review to document
                                                                                                                                                                        data processing and loading into OR-Trans database.


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 numbering/mp                                                                                                                  assigning and/or improving the county road numbering system for the county owned
            data                                                                                                                                                        roads. This work will include a pilot coordinated thought AOC and Wasco County
             - QA/QC of data and coordinate                                                                                                                             Road master.
            correction w/ road authorities                                                                                                                              05/01/06: GeoSolve working with to update ODOT data for 911 data
             - Complete any Ph. 3 missing statewide                                                                                                                     requirement in Coos and Klamath Counties




               C:\Docstoc\Working\pdf\17120804-3780-4d8e-a040-8e7680b3fe8e.xls                                                           1                                                                                        11:17 AM   4/13/2011
                                                                                                            GIS Monthly Project Status Report
                                                                                                                              March 2006
                                                                    Project Status




                                                                                        February
                                                                              January




                                                                                                                                                         Projected
Status***




                                                                                                                                                          Status**
                                                                                                   March
                                                                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 the
  Project                                                                                                                                                            ability to "check in" and "check out" data through a web interface for a pilot project
   - Design and construct Web based check-                                                                                                                           with King and Pierce County. The source code for this ability is being developed
  in and                                                                                                                                                             through an existing contract between WashDOT and ESRI. The goal of this pilot
   - check-out system                                                                                                                                                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
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.

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 instead
   - Equipment Inventory Detail                                                                                                                                      of creating in-house software. Software currently used by ITS. 3/9: Evaluations
   - Create data entry interface(s) for equip                                                                                                                        continuing. 5/11: Determination was made to use ITS Asset Inventory software.
  inventory                                                                                                                                                          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.



A DMV Oregon Automobile Dealers                                  GIS41        Y          Y         Y       07/11/05      08/01/05          9/30/2005       Y         7/05: Employment and TPAU lacks resources to Geo-code addresses. GIS Unit will
                                                                                                                                            12/31/05                 complete this project when resources are available. 9/08/05: GIS Unit working with
                                                                                                                                            2/01/06                  project, scrubbing data and exploring geo-coding options. Project on schedule for
                                                                                                                                            04/01/06                 9/30 completion. 11/10: Geo-coding complete. Data is under review by customer
                                                                                                                                            06/30/06                 and will be formatted and made available on the NAS/TransGIS once the metadata
                                                                                                                                                                     is complete. After posting TransGIS 'system' development will be conducted
                                                                                                                                                                     through Robin Ness. 1/12: Waiting for DMV to complete review data. 3/9: Data
                                                                                                                                                                     posted on the GIS server. Waiting for DMV to complete review of data. 5/11/06:
                                                                                                                                                                     Working closely with the DMV customer attempting to identify the remaining
                                                                                                                                                                     130 sites an inconsistencies in the database was identified causing
                                                                                                                                                                     difficulties updating the data. A "Site-ID" will be implimented allowing updates
                                                                                                                                                                     without re-geocoding the data every time.




            C:\Docstoc\Working\pdf\17120804-3780-4d8e-a040-8e7680b3fe8e.xls                                                           2                                                                                          11:17 AM   4/13/2011
                                                                                                            GIS Monthly Project Status Report
                                                                                                                              March 2006
                                                                    Project Status




                                                                                        February
                                                                              January




                                                                                                                                                         Projected
Status***




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


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 requirments,
  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
  mobility.
    • 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. Connection to GIS
                                                                                                                                                                     is unclear at this time.

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 Boudaries (OEM)

            C:\Docstoc\Working\pdf\17120804-3780-4d8e-a040-8e7680b3fe8e.xls                                                           3                                                                                    11:17 AM   4/13/2011
                                                                                                            GIS Monthly Project Status Report
                                                                                                                              March 2006
                                                                    Project Status




                                                                                        February
                                                                              January




                                                                                                                                                         Projected
Status***




                                                                                                                                                          Status**
                                                                                                   March
                                                                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)
C Alternate Route Mapping                                        GIS36        C          C         C       9/12/2005     3/1/2006          3/31/2006       C 11/10: Actively working on the project and is on schedule for completion date. 1/12:
  Phase 2                                                                                                                                                    The database structure for GIS36 is nearing completion. The process of populating
   - Create and populate a spatially enabled                                                                                                                 the database with emergency contact information will begin. 3/9: Phase 2 was
  database with Marion County data to be                                                                                                                     intended to be focused at Marion County as a pilot, As we received data from other
  available to ODOT TOC's as well as local                                                                                                                   regions it became apparent that we could not build a database limited by the needs
  authorities for even scheduling and                                                                                                                        of the pilot. A prototype database is currently being tested in Regions 2, 4 and 5.
  routing.                                                                                                                                                   Region 3. ITS is managing the distribution of the database application to the
                                                                                                                                                             regions and the collection of feedback by March 3rd. 5/11/06: Prototype has been
                                                                                                                                                             revised and is being deployed and used for data collection. Data collection
                                                                                                                                                             will occur until Alternate Route Mapping Porject is rolled into Trip Check ~ '07.
                                                                                                                                                             Phase complete




            C:\Docstoc\Working\pdf\17120804-3780-4d8e-a040-8e7680b3fe8e.xls                                                           4                                                                                 11:17 AM   4/13/2011
                                                                                                            GIS Monthly Project Status Report
                                                                                                                              March 2006
                                                                    Project Status




                                                                                        February
                                                                              January




                                                                                                                                                         Projected
Status***




                                                                                                                                                          Status**
                                                                                                   March
                                                                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                                                                                                                                                                   Visual Basic (Ryan, Casey) 10/05
                                                                                                                                                                             Conceptual Data Modeling (Ryan, Casey, Marcia, Darlene)
                                                                                                                                                                             10/05
                                                                                                                                                                             Descartes (Darlene) 10/05
                                                                                                                                                                             C# (Sharp) (Marcia, Chuck) (12/05)
                                                                                                                                                                             Functional Process Modeling (Robin and Susan) (12/05)
                                                                                                                                                                             GIS-T Conference (Milt) (04/06)


                                                                                                                                                                     TRAINING DELIVERED:
                                                                                                                                                                             SMMS Metadata (Rich, John, Kim, Katie, Heidi, Diana, Heather,
                                                                                                                                                                             Randall, Bruce, B, Jennifer) 10/05
                                                                                                                                                                             Geo-Environmental Aggregate Subcommittee (Darlene) 10/05
                                                                                                                                                                             Contracted "Intro to ArcGIS 9"
                                                                                                                                                                                  10/18-19 & 10/20-21 (Salem Area)
                                                                                                                                                                                  11/9-10 (Region 1)
                                                                                                                                                                            "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)

A GIS Infrastructure Support (cont.)                           GIS11-02       G         G          G       Ongoing       Ongoing                           G         DEMONSTRATIONS:
  Demonstrations                                                                                                                                                           ESRI Spatial Analyst - CAD / GIS Cooperative Management
  (6 month drop-off cycle)                                                                                                                                                 Team (10/05)
  Target:                                                                                                                                                                  InRoads - CAD / GIS Cooperative Management Team (CoManT)
    OTC                                                                                                                                                                    (10/05)
    Doug Tindall, Hwy Div Manager                                                                                                                                          TransGIS Project Leaders (10/05)
    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)



            C:\Docstoc\Working\pdf\17120804-3780-4d8e-a040-8e7680b3fe8e.xls                                                           5                                                                                    11:17 AM   4/13/2011
                                                                                                            GIS Monthly Project Status Report
                                                                                                                              March 2006
                                                                    Project Status




                                                                                        February
                                                                              January




                                                                                                                                                         Projected
Status***




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


A GIS Infrastructure Support (cont.)                           GIS11-04       G         G          G       Ongoing       Ongoing                           G         METADATA:
  Metadata                                                                                                                                                                 Bridges 2004 (11/05)
                                                                                                                                                                           Hwynet Jan 2006 (01/06) (also provided to Clearinghouse)
                                                                                                                                                                           Citylimit 2005 (01/06) (also provided to Clearinghouse)

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
  Standards                                                                                                                                                          information. 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 2004 (P)
                                                                                                                                                                               GeoMedia 6.0 (I)
                                                                                                                                                                               ArcPad (E)
                                                                                                                                                                               GPScorrect (E)
                                                                                                                                                                               GPS Analyst (E)
                                                                                                                                                                               GeoMedia Fusion (E)

                                                                                                                                                                         Complete:
                                                                                                                                                                             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.
  GIS File Structure

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 OEM & Small Projects (Cont)                                  GIS23-02       G         G          G       Ongoing       Ongoing                           G         3/9: Existing CAD files and current brochure descriptions were used to create a GIS
  Scenic Byways GIS Implementation                                                                                                                                   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.

A OEM & Small Projects (Cont)                                  GIS23-03       G         G          G       Ongoing       Ongoing                           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.




            C:\Docstoc\Working\pdf\17120804-3780-4d8e-a040-8e7680b3fe8e.xls                                                           6                                                                                        11:17 AM   4/13/2011
                                                                                                              GIS Monthly Project Status Report
                                                                                                                                March 2006
                                                                      Project Status




                                                                                          February
                                                                                January




                                                                                                                                                           Projected
Status***




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


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/06                   counts/history and incorporation of non-system data. Non-highway count system
                                                                                                                                                                       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.

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 and
  Connect Oregon                                                                                                           Phase 1            7/1/06                   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.

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




                                                                      *                     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




              C:\Docstoc\Working\pdf\17120804-3780-4d8e-a040-8e7680b3fe8e.xls                                                           7                                                                                        11:17 AM   4/13/2011
                                                                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 ArcSDE
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
                                                                                       data
                                                                                       for pilot. Delivered prototype to customer for testing. Java script
                                                                                       rewritten. Roll-out to additional users, distribute to ITS. The application
                                                                                       has been delivered.



DGIS05 TransGIS (Version 2.0)                                      9/1/01              Met with Pavement, STIP coordinators, Intermodal (Freight), Congestion,
       - 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 projection.
       - Changes to CHAMPS database and hyperlink to                          Project on hold, resources dedicated to GIS19. Project reactivated
       GIS tools                                                              11/10/02. Right-of-Way images acquired. Adobe Photoshop software on
       - Database development for ROW research                                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
                                                                              documentation.

GIS05   Aggregate Sites                                  5/29/00    5/30/01   (1) Most of the application functions are complete. Adding enhancements
         Phase 1                                                              and fixes as identified by the GeoHydro users. GeoHydro forecasts
          Intranet database application                                       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 to
          Intranet GIS application                                            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
                                                                              7/13/01.




  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
                                                                                  6/26/01.

GIS16   Wasco County Pilot Project                          7/23/01    9/30/01    Phase 2 slightly delayed by other projects at the University; dedicated
         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
                                                                                  review.




  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 on
         Phase 1 - testing                                                     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)
                                                                       (10/03)
                                                                        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

				
DOCUMENT INFO
Description: Monthly Status Report Template for Team Leader document sample