Oregon in House Auto Finance Form by dji10449

VIEWS: 9 PAGES: 29

Oregon in House Auto Finance Form document sample

More Info
									                                                                                                                            GIS Monthly Project Status Report
                                                                                                                                               Feb-07
                                                                         Project Status




                                                                                 November
                                                                                            December


                                                                                                                 February
                                                                                                       January




                                                                                                                                                                       Projected
Status***




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


A Phase 5 - Region 3                                               GIS04         G          G          G         G           05/01/03      06/30/04      6/30/2006       G         11/13/06: Prospect, Grants Pass, Ashland, Central Point, Shady, Drain, Hunter
   - Deliver final version RES & RAZ maps                         (TO #1)                                                                                03/30/07                  Creek workshops completed. Steamboat Workshop scheduled for November
  to Maintenance and other staff                                                                                                                                                   30. Davis Slough postponed due to inclement weather - to be rescheduled
                                                                                                                                                                                   ASAP. Temporary services currently providing data entry and building binders.
                                                                                                                                                                                   RES map draft revisions & RAZ map production in progress.1/11: RAZ
                                                                                                                                                                                   Workshops, including Davis Slough, are complete. Production temporarily
                                                                                                                                                                                   delayed for Archeology staff review of data, resumption anticipated mid-month.
                                                                                                                                                                                   Data entry from RAS workshops is underway. 3/8/07: Archaeology review
                                                                                                                                                                                   recently complete. R3 RES maps printed and bound. RAZ map production
                                                                                                                                                                                   resumed with data migration to SQL in progress. RAZ templates ready for
                                                                                                                                                                                   data placement routines and map printing through February and into
                                                                                                                                                                                   March.

C Phase 4 - OR-Trans                                              GIS19-4         Y          Y          Y         Y          06/30/04      06/30/05     12/31/2008       C         11/17/06 QA/QC document has been drafted and is under review.
  - Load data developed in Phase 3                                                                                                                       3/31/06                   Trans.Standard has been updated to reflect new needs in road centerline data
  - SQL database                                                                                                                                         06/30/06                  needs. OR-Trans data loading is proceeding and is expected to be complete by
                                                                                                                                                         12/31/06                  the end of 2006 1/3/07 Recieved comments on QA/QC documents from DAS
                                                                                                                                                         01/31/07                  and incorporating recommendations. Trans Standard has been addopted and is
                                                                                                                                                                                   posted on T-FIT and FIT website. All acquired OR-Trans data was loaded into
                                                                                                                                                                                   the stagging database. Production SQL db has been updated to incorporate all
                                                                                                                                                                                   necessary changes required to keep data integrity. Proceeding w/ loading the
                                                                                                                                                                                   production working database and applying the QA/QC proccesses. 3/8/07: The
                                                                                                                                                                                   first complete loading of the OR-Trans database was completed by Feb 1.
                                                                                                                                                                                   This dataset included the linework and attribution for the lines. The data is
                                                                                                                                                                                   now being cleaned to improve identification of the jurisdiction or "owners"
                                                                                                                                                                                   of the road segments. Updates are being applied to database.. (complete)




A            Phase 5 - OR-Trans                                   GIS19-5        G          G          G         G                         06/30/05         12/31/08     G         1/3/07 Meeting in Wasco resulted in interest of crash coding program and
             - State wide addressing                              (TO #2,                                                                                                          cooperation in developing some additional data necessary for crash coding and
             - Pilot project; county road numbering/mp            TO #6,                                                                                                           in sharing exisiting data. Meeting in Pendleton to develop a web site for data
            data                                                  TO #7,                                                                                                           users and data contributors resulted in designs that addressed needs of
             - QA/QC of data and coordinate                       TO #8)                                                                                                           participants. Code will be written to create what was designed and testing will
            correction w/ road authorities                                                                                                                                         be preformed on resulting web page. Upon successfull loading of OR-Trans
             - Complete any Ph. 3 missing statewide                                                                                                                                staging database into production working database QA/QC will begin. Looking
                                                                                                                                                                                   to move production working database to newer version of SQL to insure
                                                                                                                                                                                   continued support. Checking on software compatibility w/ SQL 2005. 3/8/207:
                                                                                                                                                                                   Some of the first QC work will begin on the state highway system and
                                                                                                                                                                                   where it intersects w/ local roads. This work will include matching the hwy
                                                                                                                                                                                   network to the Upper Functionally Classed roads through Task Order. QC
                                                                                                                                                                                   work will also begin to identify where jurisdiction cannot be determined
                                                                                                                                                                                   and data contributors will be asked to identify those roads that lack a
                                                                                                                                                                                   jurisdiciton designation.




               C:\Docstoc\Working\pdf\d9155937-e12d-41e6-b174-dd171d3738c6.xls                                                                          1                                                                                                3:49 PM    3/7/2011
                                                                                                                         GIS Monthly Project Status Report
                                                                                                                                            Feb-07
                                                                      Project Status




                                                                              November
                                                                                         December


                                                                                                              February
                                                                                                    January




                                                                                                                                                                    Projected
Status***




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


A Phase 6 - OR-Trans/Pooled Fund                                GIS19         G          G          G         G                         06/30/05         12/31/08     G         7/13: Puget Sound Pilot is complete, implementation of FME software will occur
  Project                                                                                                                                                                       in July 2006 and testing phase with county datasets from Oregon and
   - Design and construct Web based check-                                                                                                                                      Washington that abut each other will occur during the remainder of 2006.
  in and                                                                                                                                                                        9/14/06: Organization is underway for the Bi-State pilot project for the Pooled
   - check-out system                                                                                                                                                           Fund Project. Morrow and Umatilla County in Oregon and Benton, Franklin and
                                                                                                                                                                                Walla Walla Counties in Washington. This testing area will identify issues
                                                                                                                                                                                around integrating data across county and state boundaries into a central
                                                                                                                                                                                database. Methods from the Puget Sound Pilot will be used on this pilot as a
                                                                                                                                                                                means to improve ways to integrate data for the Pooled Fund Project. 3/8/07:
                                                                                                                                                                                The first iteration of the web page for the check in/out site has been
                                                                                                                                                                                created. Information gathered from the JAD session in Pendleton in
                                                                                                                                                                                November 2006 was used to design the interface and some of the
                                                                                                                                                                                functionality. At this point the web page is a mark up of that information
                                                                                                                                                                                and the function of loading the data will be worked out after the overall
                                                                                                                                                                                design has been finished.
A Environmental Data Management                                 GIS31          Y          Y                   G           Ongoing       Ongoing                       G         9/14/06: Project plan development and budget work in progress.11/20/06: Met
  System                                                       (TO #4,                                                                                                          with "Linking Planning and Enviromental Process" (LPEP) Committee members
  (formerly SR-SAM)                                            TO #12)                                                                                                          representing Planning and Geo-Environmental to discuss progress to date and
                                                                                                                                                                                opportunities for collaboration, may get assistance with plan revisions. EDMS
                                                                                                                                                                                Steering Committee Charter drafted and reviewed by LPEP, Geo-
                                                                                                                                                                                Environmental.1/11: EDMS Steering Committee initial meeting held 12/15/06.
                                                                                                                                                                                Committee is reviewing EDMS Strategic Plan and has authorized two sub-
                                                                                                                                                                                committees: one for continuation of SR-SAM related activities (The RES-RAZ
                                                                                                                                                                                Sub-Committee) and the other to focus on data and tools. 3/8/07: TDD and
                                                                                                                                                                                Maintenance Management met to review Program direction. Direction
                                                                                                                                                                                affirmed. RES-RAZ Sub-Committee formed with representation including
                                                                                                                                                                                Maintenance, Geo-Env, TDD and the ODOT-ODFW Liasion. Sub-Committee
                                                                                                                                                                                wiil meet 3/13/07.
H Traffic Counting GIS Implementation                          GIS_16          Y          Y          Y         Y          12/01/04      02/28/05      6/1/20/05                 5/11: Determination was made to use ITS Asset Inventory software. This
  Phase 5                                                                                                                                              8/15/05                  software will also be used to track signals. A future project will be to develop a
   - Create data entry system for traffic data                                                                                                                                  GIS interface. This project will be closed until that request is made. 7/13:
   - Create database tables, site inspection,                                                                                                                                   Maintenance Work: Data Entry Interfaces have been updated to connect to new
  vendor info.                                                                                                                                                                  database format. Traffic Volume Report is functional. Data entry in progress.
   - Equipment Inventory Detail                                                                                                                                                 Resources intermittent due to TSM staff change and the number of projects in
   - Create data entry interface(s) for equip                                                                                                                                   process through the GIS Unit. 9/14/06: Looking at ITS Software for tracking
  inventory                                                                                                                                                                     Traffic Counting Assets. May not need this project.
   - Provide imagery linking & view options




            C:\Docstoc\Working\pdf\d9155937-e12d-41e6-b174-dd171d3738c6.xls                                                                          2                                                                                                   3:49 PM   3/7/2011
                                                                                                                         GIS Monthly Project Status Report
                                                                                                                                            Feb-07
                                                                      Project Status




                                                                              November
                                                                                         December


                                                                                                              February
                                                                                                    January




                                                                                                                                                                    Projected
Status***




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


A DMV Oregon Automobile Dealers                                 GIS41          Y          Y          Y         Y          07/11/05      08/01/05      9/30/2005       R 9/14/06: DMV utilized 'Code 1' address cleaning software to improve location
                                                                                                                                                      12/31/05          information. Duplicate data was discovered and removed. DMV is matching
                                                                                                                                                       2/01/06          previously geocoded latitude/longitude derivation and adding it to their new
                                                                                                                                                      04/01/06          'location' table. DMV is defining new queries for simple extracts which will be
                                                                                                                                                      06/30/06          provided to the GIS Unit for geocoding. DMV is delighted with the quality of the
                                                                                                                                                      08/01/06          refined database and confident in the new process. 11/01/06 Data provider is
                                                                                                                                                      10/15/06          defining appropriate display fields. Data expected to be received by 11/15/06.
                                                                                                                                                      12/01/06          Geocoding will take approx 40 hours. Geocoding will take approx 40 hours.
                                                                                                                                                       2/14/07          01/03/07 Data received. No resources available to Geocode. 3/8/07:
                                                                                                                                                       3/15/07          Geocoding in process. Approx 50% complete.
A TOC GIS Interface                                             GIS42         G          G          G         G           05/01/06      05/01/07      06/01/07        G 3/8/07: Prototype delivered, waiting for final requirements.
  Phase 2
   - Implementation of viewing tool
  - Provide GIS expertise to the project
A Traffic Mobility Management System                            GIS39         G          G                                03/01/06                                              09/14/06 Placed on Hold by Motor Carrier Staff
  Phase 2                                                                                                                                                                       10/31/06 Project completed. Motor Carrier does not need any additional work
    • Develop data models and business                                                                                                                                          at this time.
  processes based on recommendations                                                                                                                                            3/8/07: Dennis, Pete Randall, Erik Havig, OBDP Staff and Ron Winterrowd
  and findings from Phase 1.                                                                                                                                                    met to discuss future develope needs. Additional discussions will occur
    • Create/capture and catalogue data (or                                                                                                                                     over the next few months.
  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.




            C:\Docstoc\Working\pdf\d9155937-e12d-41e6-b174-dd171d3738c6.xls                                                                          3                                                                                             3:49 PM    3/7/2011
                                                                                                                         GIS Monthly Project Status Report
                                                                                                                                            Feb-07
                                                                      Project Status




                                                                              November
                                                                                         December


                                                                                                              February
                                                                                                    January




                                                                                                                                                                    Projected
Status***




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


A GIS Layers In Progress                                        GIS21         G          G          G         G           Ongoing       Ongoing                       G         Exits and Interchanges 2006 (Sm)
   Projects categorized as:                                                                                                                                                     Oregon Auto Dealers 2006 (Sm)
   OEM or Sm                                                                                                                                                                    House and Senate Districts 2006 (add phone and names) (OEM)
     Assign sub-numbers (Sm)                                                                                                                                                    Vehicle Class 2005 (OEM)
                                                                                                                                                                                Flow Map 2005 (OEM)
                                                                                                                                                                                Truck Flow Map 2005 (OEM)
                                                                                                                                                                                Rail Crossings 2005 (OEM)
                                                                                                                                                                                Non-hwy roads and road text from CAD 2006 (Sm)
                                                                                                                                                                                Highway Tenths 2006 (Sm)
                                                                                                                                                                                WIM count location 2005 (Sm)
                                                                                                                                                                                Access Management Approach Permits Fall 2006 (Sm)
                                                                                                                                                                                County Boundaries (OEM)
                                                                                                                                                                                Half Meter NAIP Imagery 2005 (SID mosaics) (Sm)
                                                                                                                                                                                Highway Ones 2006 (Sm)
                                                                                                                                                                                Highway Fives 2006 (Sm)
                                                                                                                                                                                Highway Tens 2006 (Sm)
                                                                                                                                                                                Highway Tenths 2006 (Sm)
                                                                                                                                                                                Freight System Highways 2006 (Sm)
                                                                                                                                                                                Bridges 2006 (OEM)
                                                                                                                                                                                Pavement Conditions 2006 (11/06) (OEM)
                                                                                                                                                                                Right of Way Image Index
                                                                                                                                                                                Reg2 Pilot (3/07) (Sm)
                                                                                                                                                                                Flow Map 2006
                                                                                                                                                                                Vehicle Class 2006
                                                                                                                                                                                ATR 2006




            C:\Docstoc\Working\pdf\d9155937-e12d-41e6-b174-dd171d3738c6.xls                                                                          4                                                                                        3:49 PM   3/7/2011
                                                                                                                         GIS Monthly Project Status Report
                                                                                                                                            Feb-07
                                                                      Project Status




                                                                              November
                                                                                         December


                                                                                                              February
                                                                                                    January




                                                                                                                                                                    Projected
Status***




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


A GIS Layers Completed                                          GIS21          C          C         C          C                                                      C         OR Geologic Data Compilation V2 (OGDC) (OEM) (09/06)
                                                                                                                                                                                ODOT Aggregate Sites - Fall 2006 (OEM) (10/06)
                                                                                                                                                                                Functional Class 2006 (Highway) (OEM) (09/06)
                                                                                                                                                                                Highway Class 2006 (OEM) (09/06)
                                                                                                                                                                                Lane Width 2006 (OEM) (09/06)
                                                                                                                                                                                Mileposts 2006 (OEM) (09/06)
                                                                                                                                                                                NHS 2006 (OEM) (09/06)
                                                                                                                                                                                NHS nonstate 2006 (OEM) (09/06)
                                                                                                                                                                                Posted Speeds 2006 (OEM)(09/06)
                                                                                                                                                                                Rest Area Exits 2006 (OEM) (09/06)
                                                                                                                                                                                Culverts (OEM) (10/06)
                                                                                                                                                                                Freight System Hwys 2006 (OEM) (10/06)
                                                                                                                                                                                Lat / Long Quarters Image Index (OEM) (11/06)
                                                                                                                                                                                Pavement Conditions 2006 (OEM) (11/06)
                                                                                                                                                                                Oregon Natural Heritage update (OEM) (12/06)
                                                                                                                                                                                Reg2 Pilot (Sm) (Asset Management Data) (01/07)
                                                                                                                                                                                Cattleguard/Pass 2007 (OEM) (01/07)
                                                                                                                                                                                Medians 2006 (OEM) (01/07)
                                                                                                                                                                                Number of Lanes 2006 (OEM) (01/07)
                                                                                                                                                                                Shoulder Wdth/Typ 2006 (OEM) (01/07)
                                                                                                                                                                                Viewpoints 2006 (OEM) (01/07)
                                                                                                                                                                                Waysides 2006 (OEM) (01/07)
                                                                                                                                                                                Expressways 2006 (OEM) (01/07)
                                                                                                                                                                                Left Turn Lane 2007 (OEM) (02/07)
                                                                                                                                                                                Right Turn Lane 2007 (OEM) (02/07)
                                                                                                                                                                                City Limit 2007 (January) (OEM) (02/07)
                                                                                                                                                                                Routes cross ref 2007 (OEM) (02/07)

A GIS Infrastructure Support (cont.)                          GIS11-01        G          G          G         G           Ongoing       Ongoing                       G         TRAINING RECEIVED:
  Training                                                                                                                                                                               GIS techniques for Wetland Specialists (delivered by
                                                                                                                                                                                         Casey Ragain) (8/24)
                                                                                                                                                                                         Data Formatting techniques ('B' McConnell & Diana Mann)
                                                                                                                                                                                         (08/06)
                                                                                                                                                                                         ArcGIS Intro for Anne Batten, Wade Atkines (08/06)
                                                                                                                                                                                         NW MapBook for C. Crockett, R. Johnson & D. Gowen (11/06)
                                                                                                                                                                                         ORMAP Version for C. Crockett, R. Johnson & D. Gowen
                                                                                                                                                                                          (11/06)
                                                                                                                                                                                         ArcGIS Tools and Techniques (Mike. Chad C.)
                                                                                                                                                                                         Map2PDF - various staff (10/06)
                                                                                                                                                                                         National Hydro Dataset - various GIS staff (11/06)
                                                                                                                                                                                         Building GeoDatabases I - GIS Staff (02/07)
                                                                                                                                                                                         Building GeoDatabases II - GIS Staff (03/07)
                                                                                                                                                                                TRAINING DELIVERED:
                                                                                                                                                                                         R. Johnson gave Mapbook demos to UoO and TDD (11/06)
                                                                                                                                                                                         C. Ragain gave Hydro-NHD layer demo to GIS Unit (11/06)
                                                                                                                                                                                         ArcView Traffic Counting App to Alsea Geospatial (12/06)
                                                                                                                                                                                         SA Mead / R. Johnson Traffic Counting Refresher and
                                                                                                                                                                                         TSM Unit Coaching (02/07)


            C:\Docstoc\Working\pdf\d9155937-e12d-41e6-b174-dd171d3738c6.xls                                                                          5                                                                                         3:49 PM   3/7/2011
                                                                                                                         GIS Monthly Project Status Report
                                                                                                                                            Feb-07
                                                                      Project Status




                                                                              November
                                                                                         December


                                                                                                              February
                                                                                                    January




                                                                                                                                                                    Projected
Status***




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


A GIS Infrastructure Support (cont.)                          GIS11-02        G          G          G         G           Ongoing       Ongoing                       G         DEMONSTRATIONS:
  Demonstrations                                                                                                                                                                      Feature Manipulation Engine (FME) (10/06)
  (6 month drop-off cycle)                                                                                                                                                            Routing software demo to MC
  Target:                                                                                                                                                                             Project Manager TransGIS demonstration
    OTC                                                                                                                                                                               Highway Finance Office TransGIS demo
    Doug Tindall, Hwy Div Manager
    Additional PBLT groups
    Area Managers
    Project Manager

A GIS Infrastructure Support (Cont)                           GIS11-03        G          G          G         G           Ongoing       Ongoing                       G         CUSTOMER SUPPORT HOURS:
  Customer Support                                                                                                                                                                    129 (01/06)
                                                                                                                                                                                      142 (04/06)
                                                                                                                                                                                      25 (05/06)
                                                                                                                                                                                      30 (06/06)
                                                                                                                                                                                      70 (07/06)
                                                                                                                                                                                      86 (08/06)
                                                                                                                                                                                      76 (09/06)
                                                                                                                                                                                      80 (10/06)
                                                                                                                                                                                      52 (11/06)
                                                                                                                                                                                      30 (12/06)
                                                                                                                                                                                      46 (01/07)
                                                                                                                                                                                      43 (02/07)
A GIS Infrastructure Support (cont.)                          GIS11-04        G          G          G         G           Ongoing       Ongoing                       G         METADATA:
  Metadata                                                                                                                                                                      Hwynet Annual May 2006 (09/06) (provided to Clearinghouse)
                                                                                                                                                                                City limit Annual Aug 2006 (09/06) (provided to Clearinghouse)
                                                                                                                                                                                Oregon Geologic Data Compilation V2 (OGDC) (09/06 - format/import)
                                                                                                                                                                                Unstable Slopes (11/06)
                                                                                                                                                                                Temporary Employee trained and working approx. 50 docs (12/06)
                                                                                                                                                                                Metadata for 128 data layers completed and published (01/07)
A GIS Infrastructure Support (Cont)                           GIS11-05        G          G          G         G           Ongoing       Ongoing                       G
  Standards




            C:\Docstoc\Working\pdf\d9155937-e12d-41e6-b174-dd171d3738c6.xls                                                                          6                                                                                               3:49 PM   3/7/2011
                                                                                                                         GIS Monthly Project Status Report
                                                                                                                                            Feb-07
                                                                      Project Status




                                                                              November
                                                                                         December


                                                                                                              February
                                                                                                    January




                                                                                                                                                                    Projected
Status***




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


A GIS Infrastructure Support (cont.)                          GIS11-06        G          G          G         G           Ongoing       Ongoing                       G                In Progress:
  Software                                                                                                                                                                                 GDT Dynamap Transportation with ACG Guide (E)
  Evaluation/Purchase/Implementation                                                                                                                                                       ArcPad (E)
                                                                                                                                                                                           GPScorrect (E)
                                                                                                                                                                                           GPS Analyst (E)
                                                                                                                                                                                           GeoMedia Fusion (E)
                                                                                                                                                                                           Mapbook (E)
                                                                                                                                                                                           Maplogic Layout Manager (E)
                                                                                                                                                                                           Terrain Navigator ArcGIS Extension (E)
                                                                                                                                                                                           Map2PDF (E)
                                                                                                                                                                                           ArcGIS 9.2 (E)
                                                                                                                                                                                     Complete:
                                                                                                                                                                                           ArcGIS 9.1
                                                                                                                                                                                           Descartes 8.05
                                                                                                                                                                                           FME Suite 2006 GB (P)
                                                                                                                                                                                           GeoMedia 6.0 (I)



A GIS Infrastructure Support                                  GIS11-07        G          G          G         G           Ongoing       Ongoing                       G         7/13: Researching needs with regards to new SDE/SQL environment. Attending
  (Cont)                                                                                                                                                                        GeoHydro meetings to work through file organizational structure to build their
  GIS File Structure                                                                                                                                                            conceptual data structure. Responding to storage issues with regard to imagery
                                                                                                                                                                                by placing tifs on alternate partition. 9/14/06: Data structure being addressed
                                                                                                                                                                                using 'layer' files. The optimal implementation of the layer files will be
                                                                                                                                                                                coordinated with GeoHydroEnviro Section. 11/01/06: No action from
                                                                                                                                                                                Geo/Hydro/Enviro. 01/03/07 No action from Geo/Hydro/Enviro. 3/8/07: No
                                                                                                                                                                                action from Geo/Hydro/Enviro.

A GIS Infrastructure Support                                  GIS11-08         Y          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
  GIS11-08-05 CAD and GIS                                                                                                                                                       standardized 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. 9/14/06: No resources available. 11/01/06: New 'Mapbook' type
                                                                                                                                                                                format and output being researched and formatted for change to GIS
                                                                                                                                                                                City/County map production.

A GIS Infrastructure Support                                  GIS11-09        G          G          G         G           6/1/2006     8/15/2006                       g        7/13: Spatial Reference: Review Spatial Reference set-ups and decisions with
  SDE Implementation                                                                                                                                                            Business Partners and other agencies. Review extents vs. precision to
  Spatial Reference                                                                                                                                                             determine with regards to ODOT needs/GIS Unit needs/Engineering needs.
  Populate Database                                                                                                                                                             Recommendation forthcoming.
                                                                                                                                                                                Populate Database: Test files have been loaded and various interactions.
                                                                                                                                                                                9/14/06: Spatial Reference settings in place. Image loading techniques in review
                                                                                                                                                                                and being documented.11/01/06: Data identified and copied to SQL/SDE
                                                                                                                                                                                environment. 01/03/07:Additional server storage acquired. 3/8/07: Image
                                                                                                                                                                                migration in process.




            C:\Docstoc\Working\pdf\d9155937-e12d-41e6-b174-dd171d3738c6.xls                                                                          7                                                                                                  3:49 PM     3/7/2011
                                                                                                                         GIS Monthly Project Status Report
                                                                                                                                            Feb-07
                                                                      Project Status




                                                                              November
                                                                                         December


                                                                                                              February
                                                                                                    January




                                                                                                                                                                    Projected
Status***




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


H OEM & Small Projects (Cont)                                 GIS23-02        G          G           Y         Y          Ongoing       Ongoing      07/31/2006       Y         Phase 1 - 3/9: Existing CAD files and current brochure descriptions were used
  Scenic Byways GIS Implementation                                                                                                                   11/15/2006                 to create a GIS layer/theme. Customer reviewed the theme. Additional text is
                                                                                                                                                      5/15/07                   being created by customer team. 5/11: GIS Unit has produced routes from
                                                                                                                                                                                "Detailed Driving Directions" document. 7/13: GIS Unit working w/ RICS Unit to
                                                                                                                                                                                review milepoints and details of 'drive-path'.9/14/06: Detailed spatial data
                                                                                                                                                                                refined. GIS file complete and posted to server. Phase 2 - Sponsor will work
                                                                                                                                                                                with TransGIS coordinator to establish display and use requirements. 11/01/06:
                                                                                                                                                                                No resources at this time. 01/03/07: No resources at this time. 3/8/07: Sponsor
                                                                                                                                                                                ready to initialize TransGIS implementation. All data work is complete with
                                                                                                                                                                                a March meeting planned.
A OEM & Small Projects (Cont)                                 GIS23-03        G          G          G         G           Ongoing       Ongoing          9/1/2006     G         3/9: Data provided by customer had to be re-extracted several times. Questions
  Access Management GIS Implementation                                                                                                                   11/15/06               remain about certain records. 5/11: Training provided to customer. GIS Unit has
                                                                                                                                                         5/15/07                produced DRAFT dataset. 7/13: Coordinate fields added to CHAMPS database
                                                                                                                                                                                to allow for more accurate locational methods. No resources available at this
                                                                                                                                                                                time. 9/14/06: No resources available at this time. 11/01/06: Status remains the
                                                                                                                                                                                same.01/03/07: No change in status. 3/8/07: New extract provided to GIS
                                                                                                                                                                                Unit. 'Mapping' of this data very difficult due to missing data. Resources
                                                                                                                                                                                need to be found to provide consultation to Access Management for data
                                                                                                                                                                                cleaning. Also, extracts need to be reconsidered.


A OEM & Small Projects (Cont)                                 GIS23-04        G          G          G         G           1/11/2006    3/15/2006     12/31/2006       G         3/13: Customers have received frequent training refresher courses. Data entry
  Traffic Counting Field Data Collection                      (TO#10)                                                                                06/1/2006                  has been validated. Insufficient resources to address 'instant-update' to main
                                                                                                                                                      07/15/06                  database. Other report capability not distributed until resources available.
                                                                                                                                                      08/01/07                  9/14/06: Continued GIS and data support delivered by GIS Unit. Data is
                                                                                                                                                                                received by GIS Unit as needed.11/01/06: Counting season complete. Data
                                                                                                                                                                                being received by GIS Unit as it becomes available. 01/03/07: Data received
                                                                                                                                                                                and in review. 2007 Hose Counts Sheets being prepared. Work with
                                                                                                                                                                                consultants continues. 3/8/07: 2007 count year application and data
                                                                                                                                                                                provided to field staff. Refresher training provided. TSM staff trained to
                                                                                                                                                                                support field staff. GIS will assist in copying datasets during collection
                                                                                                                                                                                season. GIS unit will append data to main database once approved by TSM
                                                                                                                                                                                staff.

C OEM & Small Projects (Cont)                                 GIS23-05        G          G          G         G           2/6/2006      03/05/06     12/31/2006       C         5/11: Additional projects have been added to database by customer. Database
  Connect Oregon                                                                                                                        Phase 1       07/1/06                   and mapping work continues. 7/13: Database and ArcReader products
                                                                                                                                                      11/01/06                  complete. Customer now working with TransGIS team to develop Web GIS
                                                                                                                                                                                tools. Phase 2 9/14/06: Working with customer to update GIS file and related
                                                                                                                                                                                maps. Customer will work with TransGIS team to establish needs. 11/9/06
                                                                                                                                                                                Further mapping pending receipt of data from OECDD. 01/03/07 No change and
                                                                                                                                                                                No requests at this time 2/21/2007: TransGIS team is working with customer
                                                                                                                                                                                to determine if updates to current layers are needed. 3/8/07: Final map to
                                                                                                                                                                                Legislature January 29, 2007. (complete)

H OEM & Small Projects (Cont)                                 GIS23-09        G          G          G         G           6/9/2006     10/1/2006         05/01/07     G         7/13: GIS Team is awaiting data and value or rating system. 9/14/06: GIS Unit
  Asset Management Safety Rating Pilot                                                                                                                                          working with sponsor to convey data and GIS standards, identify various
                                                                                                                                                                                resources, review ongoing tests and define data responsibility. 2/21/07: This
                                                                                                                                                                                project on-hold awaiting direction from business sponsor. 3/8/07: No
                                                                                                                                                                                business resources at this time.


            C:\Docstoc\Working\pdf\d9155937-e12d-41e6-b174-dd171d3738c6.xls                                                                          8                                                                                                3:49 PM   3/7/2011
                                                                                                                            GIS Monthly Project Status Report
                                                                                                                                               Feb-07
                                                                          Project Status




                                                                                 November
                                                                                            December


                                                                                                                 February
                                                                                                       January




                                                                                                                                                                       Projected
Status***




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


A OEM & Small Projects (Cont)                                    GIS23-07         Y          Y          Y         Y          Ongoing       Ongoing                       Y         3/9: Met with ODOT Maintenance and Water Resource Department (WRD) to
  Water Withdrawal Permitting                                    (TO #11)                                                                                                          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. 11/20/06: WRD has responded to ODOT
                                                                                                                                                                                   submission. Preliminary SOW submitted to several contractors for
                                                                                                                                                                                   estimate.11/20: WRD has responded to ODOT submission. Preliminary SOW
                                                                                                                                                                                   submitted to several contractors for estimate. 1/11: Contractor selected,
                                                                                                                                                                                   statement of work and task order is complete, Notice to Proceed anticipated
                                                                                                                                                                                   soon. 3/8/07: Notice to Proceed issued, DRAFT products received, reviewd
                                                                                                                                                                                   and accepted. Contractor proceeding with production.
A OEM & Small Projects (Cont)                                    GIS23-27        G          G          G         G           09/01/06      02/01/07          2/1/07      G         10/01/06: Data collection complete. Project team cleaning and standardizing
  Asset Management Pilot (Monmouth to                                                                                                                        4/1/07                data. 11/01/06: Data being mapped. 12:01/06: Data analysis and GIS
  McMinnville)                                                                                                                                                                     presentation being defined. 01/03/07: Needs Assessment complete (data
                                                                                                                                                                                   identified for uses by GIS community). Data will be extracted according to
                                                                                                                                                                                   various requirements, symbology will be established and data will be passed to
                                                                                                                                                                                   TransGIS programmer for implementation. 2/21/2007: Inital delivery complete -
                                                                                                                                                                                   in conversion of data layers to TransGIS some symbology changes are
                                                                                                                                                                                   underway. 3/8/07: All data processed. Map/symbology established and
                                                                                                                                                                                   provided to ArcIMS programmer. Consultation continues to be provided by
                                                                                                                                                                                   GIS Unit.
A Transportation Model Development                                               G          G          G         G           Ongoing       Ongoing                       G         3/9: Marion County - 90% - On hold pending RPS work.
                                                                                                                                                                                   5/06 Rogue Valley MPO - complete
                                                                                                                                                                                   7/13: Marion County GIS work complete
A Traffic Counting Field Data Collection                           GIS46         G          G          G         G           1/7/2007                       08/01/07     G         11/28: Approved at GIS Steering Committee 1/5/07: Met with Alsea Geospatial
  Conversion                                                                                                                                                                       who demonstrated existing application called Incident View developed for local
  Task Order 10                                                                                                                                                                    emergency responders. By adapting this application our project cost will be
                                                                                                                                                                                   reduce by 50% from initial estimates. Rewriting Task Order to use Incident View
                                                                                                                                                                                   program technology. 3/8/07: Data provided to consultant.


A STIP TransGIS Scoping Tool                                       GIS47         G          G          G         G             New                          02/01/07     G         11/28 - Approved at GIS Steering Committee 2/21/2007: First requirements
  Phase 1 & 2                                                                                                                                                                      meeting scheduled for March.

A Crash Coding Tool                                                GIS43         G          G          G         G           2/1/2007                       04/01/07     G         This project will create a TransGIS tool which will locate crash sites and collect
                                                                                                                                                                                   codes for 25 attributes from ODOT’s GIS system. 03/06/07: Project Kick-off
                                                                                                                                                                                   meeting complete, necessary data identified, TransGIS application under
                                                                                                                                                                                   development.



                                                                                                                                                                                   E=Evaluate
                                                                                                                                                                                   P=Purchase
                                                                                                                                                                                   I=Implement

                                                                      *                       On Schedule                                                                          TO = Task Order
            *** Status                                                *                       Requires Attention                                                                   OEM = Operations & Essential Maint.
            A=Active                                                  *                       Requires Corrective Action


               C:\Docstoc\Working\pdf\d9155937-e12d-41e6-b174-dd171d3738c6.xls                                                                          9                                                                                                    3:49 PM    3/7/2011
                                                                                                                            GIS Monthly Project Status Report
                                                                                                                                               Feb-07
                                                                          Project Status




                                                                                 November
                                                                                            December


                                                                                                                 February
                                                                                                       January




                                                                                                                                                                       Projected
Status***




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


            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\d9155937-e12d-41e6-b174-dd171d3738c6.xls                                                                          10                                                          3:49 PM   3/7/2011
                                                          COMPLETED PROJECTS

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

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




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




 Revised 10/12/00
                                                           COMPLETED PROJECTS

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




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




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




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




 Revised 10/12/00
                                                         COMPLETED PROJECTS

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


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




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


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



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




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

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

GIS05    Aggregate Sites                                      12/31/00   5/30/01
          Phase 3
           Desktop GIS application




 Revised 10/12/00
                                                         COMPLETED PROJECTS

GIS07   Non-State Hwy Functional Classification System         6/1/00     12/1/01
        Attribution


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




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




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




Revised 10/12/00
                                                       COMPLETED PROJECTS

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


GIS18   Road Authority Database                              7/1/01    10/1/01

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




Revised 10/12/00
                                                        COMPLETED PROJECTS

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

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




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

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




Revised 10/12/00
                                                          COMPLETED PROJECTS

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




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




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


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


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

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

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

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


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


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


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




Revised 10/12/00
                                                 COMPLETED PROJECTS

        Generation 2 Statewide Model                   7/1/99    12/31/01




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




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




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


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


        Urban Transportation Model Development        12/31/02
        - Redmond


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


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




Revised 10/12/00
                                                                        COMPLETED PROJECTS


                               Comments
Outside contracts reviewed. Software evaluated. Project Plan created.
ARC IMS Web software received 9/25/00. Installed and sent through
NPE. Approval received to purchase software. Placed on hold for lack of
resources. Returned to active status 1/22/02. Draft of GIS Software
Evaluation Guidelines presented to Steering Committee 3/28/02. Dennis
will make revisions and bring to 1/23/03 committee meeting. Using
purchase of SDE (spatial data engine) GIS server software to develop and
test process. (Will not work with OTS software). Used proposed ArcSDE
TDD and ITS Unit developing project plan. Gave demo to ITS Unit and
field
technicians. Waiting for data needs assessment from ITS Unit. Roll-out
database using Internet GIS viewing tool as pilot. Updating and cleaning
data
for pilot. Delivered prototype to customer for testing. Java script
rewritten. Roll-out to additional users, distribute to ITS. The application
has been delivered.



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




    Revised 10/12/00
                                                                     COMPLETED PROJECTS

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



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


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

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




    Revised 10/12/00
                                                                      COMPLETED PROJECTS

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

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

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

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

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

3.) Script created to allow GeoHydro users to map data based on latitude
and longitude values stored in the database is waiting for review by Amy
Landvoight and/or Mike Long. Scheduled review and acceptance June 7,
2001. Application is only for use by the GeoHydro personnel. Complete
7/13/01.




    Revised 10/12/00
                                                                         COMPLETED PROJECTS

35,000 miles of road. 11/30/00 Attribution complete. Error checking in
progress. Successfully developed and tested the new MGE project and
access database. Complete 10/19/01.

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



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


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

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




    Revised 10/12/00
                                                                        COMPLETED PROJECTS

Test existing GIS software and databases. NPE and testing completed on
all products. Complete
Implementation plans are being developed. Migrate software and
databases to SQL V7.0 adding capabilities and flexibility. Data structure
modified and migrated to SQL 7. GeoMedia Pro is being used for
production work. Complete
Database built and book published. Enhancements and updates are
ongoing. Complete.
Met 9/24 to determine how to proceed with data compilation. Oregon
Parks and Rec., ODOT Archeology and Mortuary Board providing data.
Fields confirmed at meeting. Verifying data entries. Completed GIS layer
from ODOT map base cemeteries.



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




    Revised 10/12/00
                                                                COMPLETED PROJECTS

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

Complete:
 Access Mgmt ArcView (DGIS13-2) 11/01
 Or State Hwy No. conversion (DGIS 13-17) 8/02
 A* CARS ArcExplorer (and CD for home users) (DGIS14-2) 2/03
 A* Video Log-ArcExplorer Training (GIS23-05) 2/03
 D* Road Authority (GIS23-04)(Sm) 12/02
 D* City Annexation Data Modeling (GIS23-02)(Sm) (6/03)
 A* Software acquisition and distribution (Sm) (9/03)
 A* Standard Data Display and Formatting (Sm) (10/03)
 A* Upgrade Crash Coder Desktop GIS tool and User Guide (OEM)
(10/03)
 D* Bridge Location Project (11/03)
 D* 650 Map Project (11/03)
 A* Bridge Location to Web (11/03)




   Revised 10/12/00
                                                                        COMPLETED PROJECTS

Mapping project for statewide Tsunami exercise is complete. Maps show
inundation line intersecting state highways, and lifeline routes. Being
tested in statewide earthquake drill April 2nd and 3rd. Complete

Project development nearly complete. Mixture of techniques used to
accomplish project. Internet use not yet approved. Draft model presented
to ODOT end-users 3/20 by the IS team (Diane Powers). Waiting for XML
templates from IS Development Team. Network testing underway.
Application and data complete and provided to customer. P+
documentation in draft stage. Complete
Display Lat/Long coordinates and LRS in ArcView. The application is out
for peer review. Ready to send through product approval and Intranet roll-
out. Going through NPE. (Complete)
Application complete. Ready to send through product approval and
Intranet roll-out. (Complete)

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

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

Revisions made, forwarded to State Forestry for review. Complete and
delivered to State Service Center and GIS User Group.
User has accepted the ArcView Extension (application) software and
installation instructions. Network testing of extension is complete.
Extension given to user.
Create National Geodetic Survey benchmark layer for Geometronics in
ArcView & MGE software. (Complete)
Software purchase complete, documentation under development. Roll-
out scheduled to start the week of August 28th. Close after testing
complete 10/10/00.
Quality check household activity locations from travel survey buffer points
to create environmental design variables.
Building base layer of ODOT maintenance facilities (103) to satisfy
Oregon's DEQ water permit requirements. (Complete)
Produce presentation of output from first generation statewide model.
Completed 11/1/00. Project Lead was Brian Gregor.
Base year employment & housing distributions and network
characteristics. Completed 6/1/00. Project Lead was Sam Ayash.




    Revised 10/12/00
                                                                        COMPLETED PROJECTS

Road layer comprised of State Highways and nonhighways Functional
Class network, attributed with functional class, number of lanes, posted
speeds as available. Preliminary work should be completed by July 2001.
Will be migrated to statewide modeling software. Final review meeting
scheduled in November 2001. GIS work for model is complete.

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

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

Scheduling with COG for update of existing model. Consultant compiling
existing data. ODOT is collecting and reviewing traffic count data.
Updating population and housing data for consultant. Complete 11/02

Reviewing consultant data. Complete

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




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




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


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




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

								
To top