GIS Steering Committee Project Status report

Shared by: HC120830212437

Tags

Stats

views:: 3
posted:: 8/30/2012
language:: Unknown
pages:: 203

Public Domain

Document Sample

A= Active
C= Complete Red= project completion or resource slippage by 25% or more
H= On hold Yellow= project completion or resource slippage by 15% or more
Q= Queue (waiting for resource allocation) Green= on schedule

GIS Monthly Project Status Report
November 2009
Project Status

Importance

Projected
Status***

Status**
Project

June
April

July
May

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

C OR-Trans/Pooled Fund Project - GIS19 G G G G 6/30/04 6/30/05 12/31/2008 G 2/19/2009: ODOT has received the software requirements for replicating the Pooled Fund
Phase 6 3/31/09 portal at ODOT. The code behind the actual portal will be delivered towards the end of
- Design and construct Web based February after WSDOT has had a chance to clean and finalized the code from any issues

Tammi Griffin and Chad Brady
check in and out found during testing. 3/5/2009 Staff is on schedule to have the 33 updates to the OR-
Trans database by March 31. 5/5/2009 ODOT has revceived the code for the WA-Trans
data user portal for the Washington transportation framework data. ODOT is looking at
Medium

various approaches to implementing a similar portal utilizing the code, software and
architechture developed from the Pooled Fund Porject. Scoping will begin in May. 6/22/09
ODOT met with WSDOT on 6/17/09 to learn about the software requirements for the
portal that was developed through the Pooled Fund project. The meeting was to
determine if Geocortex Essetials was necessary for the development of the portal.
It was determined that the web programing could be done without this software.
Project complete.

C OR-Trans FY 2007 - Phase 7 GIS19 G G G G 5/1/07 6/30/08 7/15/09 G 2/19/2009: ODOT has received updates from GeoSolve again. They added a persistent
- Statewide data partnership unique id to each record in each dataset they maintain for 17 counties. This will aid in
- Wasco County Pilot project future change detection efforts during updating and loading of the database. Shawn

Chad Brady
- Develop/Coordinator QA/QC of data Snyder has begun loading
Medium

with Road Authorities all of the 33 dataset updates received since November of 2008. He is working on adding
- Develop Routing data on State error reporting features to the FME workbenches. 5/5/2009 The 34 updated datasets have
highways been loaded. A contractor is now working to integrate the geometry between the highway
network and the local road network and establish agreement points. This work will be
finished by July. 7/15/09 Project complete.

A OR-Trans/Pooled Fund Project - GIS19 G 7/1/09 06/310/10 G 9/15/09 The Poole Fund Annual meeting is going to be held in Olympia on 9/23 and 9/24.
Phase 8 Representatives from the participating states will be attending to review the project work
Continue Pooled fund participation for the last year and discuss next years objectives. 11/20/09: No Change.
- Develop a web portal to to facilitate
regular data maintenance
- Develop change detection tools

Chad Brady
Medium

- Integrate data from disparate sources,
QA/QC: quality, security, data entry
and data retrieval
- Develop a web portal to deliver multi-
jurisdictional, multi-modal statewide
transportation and location data
- Create documentation to support of all
technical aspects of the project

1
Importance

Projected
Status***

Status**
Project

June
April

July
May

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

A OR-Trans FY 2009 - Phase 9 GIS19 G G G G 6/1/09 06/310/10 G 6/22/09 There are now data sharing issues with the county datasets delivered from OEM.
- Statewide data partnership These datasets cannot be shared as part of OR-Trans to anyone at this point. ODOT and
- Develop/Coordinator QA/QC of data DAS are working on the issue to see if this can be resolved. 9/15/09 Data from all road
with Road Authorities authorities has been loaded. Staff is reviewing data for completeness. An FME
- Dataset updates workbench has been developed to transfer County road number information from previous

Chad Brady
Medium
datasets to the newest datasets if the newest dataset didn't contain that information. The
workbench looks like it has an 85% match success rate with the remaining 15% sent to a
"review" dataset where personnel will have to review and approve for updating the latest
data. 11/20/09: County Rd no. transfer was completed. QAQC and mop up on that
process will be competed in the following months. QAQC on data is being
performed to insure that all Functionally Classed above local road are represented
in OR-Trans.
C Environmental Data Management GIS31 G G G G Ongoing 6/30/09 7/31/2009 G 5/5/09: Region 2 RAZ meetings are in progress through May. Web application migration to

Phil Smith / Casey Ragain
System 11/20/09 ArcGIS server platform is underway at Alsea Geospatial (AGI) through June. Currently AGI
(formerly SR-SAM) is developing archaeological module for Gov to Gov use. Handheld applications for
Medium
09-11 Biennium mitigation monitoring and Special Management Areas are in revision at MB&G through the
end of May. 6/11/09: Region 2 RAZ now going to publication. 9/16/09: EDMS team work
assignments completed. Waiting on printer. 11/20/09: Final maps being distributed.
Project completed.

H Traffic Mobility Management System GIS39 Y Y Y Y 3/1/06 6/1/07 Y 09/14/06: Placed on Hold by Motor Carrier Staff. 10/31/06: Project completed. Motor
Phase 2 On-Hold Carrier does not need any additional work at this time.
• Develop data models and business 3/8/07: Dennis, Pete Randall, Erik Havig, OBDP Staff and Ron Winterrowd met to discuss
processes based on recommendations future developer needs. Additional discussions will occur over the next few months. Invited
and findings from Phase 1. Randall Thomas to May Steering Committee to discuss needs for project. 1/4/08: Randall
• Create/capture and catalogue data

Dennis Scofield
Thomas reports that final database testing is underway. GIS portion of this project
(or secure access to data) that will be remains on hold.
High

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

C TOC GIS Interface GIS42 Y Y Y G 5/1/06 5/1/07 6/15/09 G 3/8/07: Prototype delivered, waiting for final requirements. 3/17/09: ITS database created
Phase 2 on failover server in Bend (s-reg4toc-115). DBA's created account for read only access.
- Implementation of viewing tool Data loaded to ROC or RTP, depending on the application needs. TOC has been notified
- Provide GIS expertise to the project and have been asked to test the new server and data. 5/6/09: Going into production the
end of May. 07/07/09 Data delivered. Participated in meeting to address need for

Chuck Jenkins
notification of data updates to prevent application errors. Manual process to notify
High

automation team has been activated. Automated process addressing all GIS users will be
referred to as part of GIS 11-18, Data Management. 9/11/09: Much of the data
supporting application specific non-highway search and validation functions has
been developed and delivered. Some of the larger data requests (addressing, for
instance) are in progress. Data, it's use and expectations were not defined during
project development. Our current efforts are work-arounds to address the resultant
issues.

2
Importance

Projected
Status***

Status**
Project

June
April

July
May

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

C OEM & Small Projects (cont.) GIS23-27 G G G G 9/1/06 2/1/07 2/1/07 G 10/01/06: Data collection complete. Project team cleaning and standardizing data.
Asset Management Region 2 Pilot 6/1/07 11/01/06: Data being mapped. 12:01/06: Data analysis and GIS presentation being
defined. 01/03/07: Needs Assessment complete (data identified for uses by GIS
community). Data will be extracted according to various requirements, symbology will be
established and data will be passed to TransGIS programmer for implementation.

Robin Ness
2/21/2007: Initial delivery complete - in conversion of data layers to TransGIS some
symbology changes are underway. 3/8/07: All data processed. Map/symbology established
and provided to ArcIMS programmer. Consultation continues to be provided by GIS Unit.
5/10/07 Met with customer who had additional requirements for the web version.
This was primarily symbology and layer color changes. TransGIS's Asset
Management System will be updated and this will complete the project. Project
Complete.
A SPIS Pilot for OR-Trans - Proof of GIS44 Y Y Y G 7/13/06 12/31/06 3/31/10 G 1/7/2009: Requirements and High level design has started for the SPIS_PUB project. By
Concepts end of January or early February, this project will decide on its GIS solution. 07/07/09: GIS
developed SPIS segment generation routines using FME/Python. Volume data is

Benny Sexton
dependent on Upper Functionally Classed road conflation to OrTrans. Working on
process to create LRS for city streets in OrTrans - Baker County pilot. Using LRS and
High

measure applied to crashes, SPIS can then be calculated. 11/16/09: Waiting for testing
to be completed and SPIS business users to approve the proposed GIS solution as
a working source for statewide location and ADT data for the new SPIS process.
Hope to be to the design/construction phase by January 2010.

H Alternate Fuels Corridor - I5 GIS50-2 Y Y Y Y On-Hold Y 02/04/09: Tasking not required, yet - per customer.

Averbeck
Potential Sites Research- PHASE 2

Lynn
- Make database available to public.

C TPOD (Transportation Planning GIS52 Y Y Y G 5/1/08 6/1/2008 G 1/26/09: The application is functioning and minor enhancements progress with allotted
Online Database) Phase 1 07/15/08 time. Access database is complete, with regards to format and table relations. User
- Use GIS interface to view scanned 9/31/08 interface for editing is still under construction, however, this does not affect use of the GIS

Susan Mead / Robin Marshburn
planning studies using Intranet access 12/31/08 web tool. Data updates are in progress and necessary for proper linkages to documents in
2/1/09 the application. Data edits were on hold during holiday break, however, they have
04/15/09 resumed and should be completed soon. 03/13/09: Project distributed to users. Data in
06/30/09 update/maintenance mode. Application being moved from development to production
High

server. 05/18/09: Application updated, however, needs to be move to production server.
Susan needs to complete several data entry forms for database and update the document
on the server. Resources limited. 07/07/09: Database interfaces completed. Customer
trained to update database using new tools. Data inconsistencies reported to
customer. Reconcilliation in process, however, that is a continued maintenance
activity for customer. Application complete

C GIS Right-of-Way Parcel Access GIS53 G G G G 3/10/08 6/1/08 7/1/08 G 3/11/08: Prototype developed. Business refining requirements.

Jenkins
Chuck
High

- Provide public access to a subset of - Complete 7/1/08
R/W data using a GIS Web Interface

3
Importance

Projected
Status***

Status**
Project

June
April

July
May

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

C ODOT Solar Highway GIS54 Y Y Y Y 3/10/08 5/1/08 6/1/2008 Y 3/20/08: Experiencing problems obtaining data from PGE (Portland General Electric).

Mission Critical
- Identify ODOT R/W that Solar 7/31/08 4/4/08: No data from PGE. 04/15/08: Data received. Site maps in progress. 5/09/08: Data

Susan Mead
equipment can be tied into PGE 10/31/08 analysis and mapping in progress. 06/18/08: Data processing has increased due to data
transmission lines limitations. Additional map production required from GIS staff to provide detail for analysis.
10/13/08: Final maps in production. Analysis review scheduled. This will complete the
project as described. 11/12/08: Complete. Maps produced and delivered to customer.

C RWDMS II - GIS Component GIS55 G G G G 3/10/08 5/1/08 3/20/08 G 3/20/08: Feasibility testing complete. 11/16/09: Last week the RITS GIS application

Chuck Jenkins
- Enhance GIS connection to R/W project completed the User Acceptance Testing. Issues have been categorized and

Mission
Critical
FileNet System. are being address by HDR project staff. An application code review was performed
on November 13th, and a User Guide is in development. The project is still on track
to be complete by November 30th.

H ArcGIS ODOT GUI Update GIS56 Y Y Y Y 6/1/08 8/1/2009 Y 1/26/09: Some tools under revision, in response to the distribution of data through
- Update existing template to improve 09/15/09 SQL/SDE. 03/16/09: First draft in review and revision. 05/18/09: Resources limited. Also,

Susan Mead
efficiency and standardization. Medium On-Hold with workstation software update soon, consider holding final review and release until
agency update plan in place. 07/07/09: Data enhancements complete. Data re-pathing
complete (SDE, portal, etc). In need of programming resources to develop or incorporate
new tools and complete this version as an 'extension'. 9/11/09: No resources at this
time.
H Interchange Diagramming in GIS GIS58 Y Y Y Y 8/1/08 9/1/08 2/1/2010 Y 6/25/08: Waiting for resources.
Medium

Tanner
Tricia
On-Hold Resource will be available 8/1. 7/10/09: Due to technical issues regarding the new
database (TCM), this project is on hold Until approx 01/01/2010.

C Electric Vehicle Charging Stations GIS59 G G G G 8/1/08 G 9/4/08: Lynn Averbeck has received ArcGIS 2 training and with the assistance of Sarah

Lynn Averbeck
Site Data Collection Assistance Abbott, Region 1 GIS support technician are doing the project themselves with a minor
amount (four hours) of support from Ryan Johnson. 7/13/09: Customer reports that the
High

project is no longer GIS enabled. Somebody else has taken over and they will not
be using GIS to implement the EV Charging Station Installations. Project Complete.

A Freight Bottleneck Identification GIS60 Y G G G 6/1/09 12/31/09 G 5/6/09: Data delivery to HDR complete. 7/11/09: Continue to provide data standards and
- Provide to consultant, existing data data structure support to consultant. 9/16/09: Preliminary map review complete.

Phil Smith
Medium

for various infrastructure elements Interactive Visualization tool in development, Standard mapping, workflows, and
- Assist consultant with data structure data use limitations in technical consultation with Freight and GIS Unit.
support
-standardize, map and publish final
data products
A FACS-STIP Tool - Phase 3 GIS61 Y R G G 7/1/09 varies per WOC 6: G 5/18/09: Project scoping complete, contractor under consideration, supplemental data in
- GIS Utilities / Intranet Service WOC 04/01/10 review. Waiting on contract process. 07/13/09: WOC 1 - Master Plan completed by
- Data enhancements (new data and contractor. WOC 2 - Redevelop original desktop STIP Scoping application for Intranet
additional fields in existing data) deployment, completed by contractor. WOC 3 - Develop mobile GIS plan, completed by
- Reporting mechanisms contractor. WOC 4 - Develop first phase of mobile GIS (data extract to spreadsheet) and

Laura Wipper
- Data Collection options
Medium

include additional priority data as identified by customers, in process. Updated and
- Communication Tools additional data to be delivered to consultant 7/17/09 (GIS resources). Application to be
- Mobile GIS completed by 7/31/09 (consultant). User testing, fixes and installation/acceptance by
9/18/09. 9/11/09: user initiation complete. Follow-up survey complete and compiled.
WOC-5 priorities being established to address enhancements as well as existing bugs.
11/20/09: User and support staff training in progress using 'Alpha' version of WOC-
5. WOC-6 contract signed and data updates in progress.

4
Importance

Projected
Status***

Status**
Project

June
April

July
May

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

Susan Mead /
A TPOD (Transportation Planning GIS62 Y Y Y Y 7/1/09 9/1/09 1/31/10 Y 5/18/09: Waiting on completion of phase 1. 07/07/09: VPN testing in progress in

Medium
Online Database) - Phase 2 development server. 9/15/09: TAD is installing JavaScript API on server. Testing will

Robin
- Internet access continue, once install is complete. 11/20/09: Waiting for completion of new Web
BaseMap before promoting to production server. Development version in use by
customers.
Q Integration of OTIA III GIS data and GIS63 Y Y Y Y 6/20/10 Y 9/15/09 Funding has been identified and project plans will be developed. Current

Dennis Scofield
Benny Sexton /
systems to ODOT GIS System - plans call for a mini-solicitation process of available GIS contractors.

High
Phase 1

Q Statewide Traffic Mobility GIS GIS64 Y Y Y Y Y

Chad Nielsen
Interface - Phase 2
Redevelops the 'war room'
application as an Intranet utility for High
use as a freight / mobility
insurance/planning tool.
A EDMS: Enhance Environmental Data GIS65 G 7/1/09 6/30/11 G 03/03/09: Begin Work 07/01/09. 9/16/09: GPS field support and data collection in progress
Management System 09-11 for field season 2009. Region 1 RAZ workshops scheduled for October and November.
Biennium GEAR application project plan in draft. Achaeological web application in development.
11/16/09: The EDMS program is currently in its final week of hosting Region 1 RAZ
meetings. The meetings are on schedule to publish and distribute Region 1 maps in
early Spring 2010. The Region 1 Tech Center Environmental Unit withdrew from
workshop participation due to workloads and immediate demands within project
delivery. The Geo-environmental section’s natural resource unit staff participated in

Phil smith
Medium

place of the Region Environmental Coordinators. ODF&W participated in the
meetings and expressed concerns regarding this substitution. Following a joint
project debrief with ODOT GIS later this year any ongoing issues in this matter will
be addressed to Office of Maintenance by ODF&W. Field data collection support
slowing as winter approaches. The first module for archaeology support is
currently in review with ODOT archaeology staff. Resource map production is
currently underway for Region 4.

A GIS Data In Progress GIS21 G G G G Ongoing Ongoing Ongoing G Traffic Barriers update
Projects categorized as: ITS update
OEM or Small Bridge Needs List (STIP Scoping)

Susan A. Mead
Pavement Needs List (STIP Scoping)
High

Weigh-in-motion Sites (2009)
Traffic Signal Warrants (2009)
Fire Stations
Extremely Hazardous Sites (partial state)
Highway Network, 3rd quarter version

5
Importance

Projected
Status***

Status**
Project

June
April

July
May

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

A GIS Data Completed GIS21 G G G G Completed Completed Completed G ODOT Aggregate sites October 2009 (10/09)
ATRs on State System (07/09)
Cattle Guards and Passes (10/09)
City Limits Annual (10/09)
Congestion (10/09)
Contract Plan Segments (10/09)
Crashes 2008 Annual (09/09)
ODOT Districts (09/09)
Engineering Stations (10/09)
Highway Names Lookup (10/09)
Right of Way Map Index (10/09)

Susan A. Mead
Lane Widths (09/09)

High
LiDAR Index (10/09)
Left turn Lanes (09/09)
Medians (09/09)
National Network - nonstate roads (10/09)
National Network - state highways (10/09)
Rest Areas on State Highways (10/09)
RLIS (Metro data) (09/09)
Right of Way Parcel Centroids (10/09)
Right Turn Lanes (09/09)
Safety Investment Program Segments (SIP) (09/09)
Command Areas (TOC) (09/09)
Viewpoints (10/09)
Weigh Stations (10/09)

Susan A. Mead
A GIS Infrastructure Support (cont.) GIS11-01 G G G G Ongoing Ongoing Ongoing G TRAINING RECEIVED: no activity at this time
Training
High

TRAINING DELIVERED:
Access Management Road Approach Tool: 10 students (10/09)

6
Importance

Projected
Status***

Status**
Project

June
April

July
May

Lead
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 Ongoing G DEMONSTRATIONS DELIVERED:
Demonstrations

Susan A. Mead
Crash Locator Tool: Metro and WashDOT (10/09)
(6 month drop-off cycle)

High
Target:
OTC, Area Managers, Project
Managers, Additional PBLT groups,
Doug Tindall, Hwy Div Manager
A GIS Infrastructure Support (cont.) GIS11-03 G G G G Ongoing Ongoing Ongoing G CUSTOMER SUPPORT HOURS:
Customer Support 41.25 (5/09)

Susan A. Mead
-Help Desk functions including GPS 89.5 (6/09)

High
support 17.0 (07/09)
24.0 (08/09)
28.0 (09/09)
31.0 (10/09)
A GIS Infrastructure Support (cont.) GIS11-04 Y Y Y G Ongoing Ongoing Ongoing G METADATA Completed:
Metadata 10/09 - all datasets listed below
ODOT Aggregate sites October 2009 (10/09)
ATRs on State System (07/09)
Cattle Guards and Passes (10/09)
City Limits Annual (10/09)
Congestion (10/09)
Contract Plan Segments (10/09)
Crashes 2008 Annual (09/09)
ODOT Districts (09/09)
Engineering Stations (10/09)
Highway Names Lookup (10/09)

Susan A. Mead
Right of Way Map Index (10/09)
High

Lane Widths (09/09)
LiDAR Index (10/09)
Left turn Lanes (09/09)
Medians (09/09)
National Network - nonstate roads (10/09)
National Network - state highways (10/09)
Rest Areas on State Highways (10/09)
RLIS (Metro data) (09/09)
Right of Way Parcel Centroids (10/09)
Right Turn Lanes (09/09)
Safety Investment Program Segments (SIP) (09/09)
Command Areas (TOC) (09/09)
Viewpoints (10/09)
Weigh Stations (10/09)

7
Importance

Projected
Status***

Status**
Project

June
April

July
May

Lead
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 Ongoing G In Progress:
Software ArcGIS Desktop 9.3.1 (I)
Evaluation/Purchase/Implementation Job Tracking for ArcGIS (GIS Unit testing)
PLTS for ArcGIS (GIS Unit testing)
(E) - Evaluation Google Sketchup 7 (E)

Chad Nielsen
(P) - Purchase FME Desktop 2010 - Beta (E)
(I) - Implementation

High
On Hold:
Intergraph GeoMedia Professional 6.01 (E; GIS unit testing)
Intergraph GeoMedia Transportation Manager 6.01 (E; GIS unit testing)
Intergraph GeoMedia Fusion 6.01 (E; GIS unit testing)

Complete: No Activity

A GIS Infrastructure Support (cont.) GIS11-08 Y Y Y Y 9/4/09 G 7/9/09: GIS Project Delivery Concept of Operations in draft. Consultation with project

Phil Smith
Process Guidelines delivery completed. Project Tracker in review and Project Scheduler in draft. GIS project
High

delivery functional flow chart in draft. 11/16/09: Draft GIS Project Delivery Concept of
Operations submitted for GIS steering review.

A GIS Infrastructure (cont.) GIS11-14 G G G G Ongoing Ongoing Ongoing G 7/8/09: Coordinating with software vendor to discuss best architecture for implementation
Hardware of planned and existing services and to address performance issues. 11/20/09: Removing

Chad Nielsen
ArcIMS from one server - moving from 3 to 2-tier environment. VPN will move from
s-salemrev-110 to s-salemrev-112. Data server s-salemrev-114 will be updated to
E.S.R.I. 9.3.1 version once TOCS data is copied to it's own, dedicated server and the
predominance of ODOT staff workstations are updated to ArcGIS 9.3.1.

8
Importance

Projected
Status***

Status**
Project

June
April

July
May

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

A GIS Infrastructure (cont.) GIS11-15 G G G G Ongoing Ongoing Ongoing G 8/31/08: Regions 3 and 5 NAS servers are full. The Salem server has more storage space
Planning and is reaching capacity. Region 5 now has a fiber connection so data access should be
much faster. We are investigating if perhaps the new connection is fast enough in
combination with SDE to scale down the Region 5 NAS. Options for Region 3 are still
being explored. 1/26/09: No resources. 7/8/09: A team has been assembled which
includes Information Security (IS) and Business to assess ODOT’s computer network
infrastructure. This team is using network tools to analyze and diagnose congestion and
utilization. This includes looking at PC switching incompatibilities, insufficient bandwidth,
topology (how the network is configured), the mapping to non-local servers, business
processes, back-ups and applications that may not be using the network efficiently. A
survey in under development right now for release on July 13 to gain more insight into local
experience with ODOT networks. The project team is working in collaboration with State
Data Center (SDC) on potential improvements and options for higher network speeds.
9/15/09 Dennis is working with Dan Handy to
develop options including State Data Center tape back-up for non-essencial
GIS data. Interum solution is to purchase additional external drives for LiDAR
data. Laura Wipper reports that the team evaluating network speeds and
optimization continues to meet. At last report, some improvements to
network topology are being undertaken by the State Data Center; an
automated option was being evaluated for efficient corrections to PC switch
incompatibilities; and a survey to the regions was delayed until this fall.
A GIS Infrastructure (cont.) GIS11-18 G G G G Ongoing Ongoing Ongoing G 1/26/09: No resources. 5/18/09: two new 'working' databases have been created on the
Data Management production server. Application pointers to a single image file need redirection. The image
has been copied to a dedicated server. This will free-up space for several new 'working'

Susan Mead
databases. 7/8/09: Working with I.S. to develop a customer notification process to address
the implications that data changes/updates may have on applications, projects, map
services, etc. May utilize change detection to provide change details, simplifying the task
of investigating possible impacts to existing systems. 09/11/09: Data cleaning in process to
free S6000E Business Server. 11/20/09: LiDAR data being stored on additional
external drives.
A GIS Infrastructure (cont.) GIS 11-22 G G G G Ongoing Ongoing Ongoing G 03/16/09: Revisions, updates and enhancements in progress. 05/18/09: Server/data

Phil Smith / Shawn
GIS Unit Website Maintenance location tools in production. 7/11/09: Updates to ArcPad data folders, added water
authorization maps and links and began build of framework for the new GIS webpage.

Snyder
9/16/09: Web site in maintenance while new Intranet site standards are in development.
11/18/09: Maps page: Added section for the ORS 366.215-State Highways Subject to
Reduction of Capacity Review Maps; GPS page: Added the ArcPad quick reference
documents; and general site maintenance.

A GIS Infrastructure (cont.) GIS 11-24 G 7/1/09 G 09/11/09: DRAFT Standard established. Using contractor code from FACS-STIP

Scofield
Dennis
Develop Standard Map Interface Tool as base. Code passed to HDR for use in Right-of-way application design.
Design for ODOT

C OEM & Small Projects (cont.) GIS23-02 Y R R G 5/1/06 7/31/06 11/15/06 G 1/26/09: No resources available. 05/18/09: Application moved to ArcGIS Server platform

Susan Mead and Robin
Scenic Byways GIS Implementation 5/15/07 on development server. Graphics in revision. Due to server versioning issues, application
5/1/08 will be moved to production server. 7/13/09: Generated raster image for OpenLayers
6/15/08 version of application. Submitted to customer for review and approval. GIS correcting one
High

Ness
ACTIVE 9/01/08 spelling error, then, it's considered approved by customer and complete!
12/1/07 10/1/08
11/30/08
03/01/09
07/01/09

9
Importance

Projected
Status***

Status**
Project

June
April

July
May

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

C OEM & Small Projects (cont.) GIS23-03 Y G G G 1/29/07 6/30/07 6/30/07 G 1/26/09: Final approval of application received from PM and training plan and scheduling

Susan Mead and Robin Ness
Access Management GIS 6/30/08 are in progress. 3/19/09: Real-life/user scenarios in development w/ field staff input.

Mission Critical
Implementation 9/01/08 5/18/09: Training resources redefined and classes should begin before mid-June. 7/10/09:
3/1/08 03/01/09 Updated CHAMPS and Upermit layers. Prepared and presented AMPT Training Session.
07/15/09 Customer has requested a second session to train additional staff. 09/11/09: No classes
11/19/09 scheduled by customer as of this report. 11/20/09: Class held November 2009. Support
for training development complete. Data update will be received 12/01/09 and
update cycle will be determined as users provide feedback to customer. Project
complete 11/19/09.

OEM & Small Projects G Ongoing Ongoing Ongoing G 09/14/09:
(Active Projects Listed) 23-43 City/County Base Maps and bi-products
Completed changes submitted by RICS Unit. Edited and final review of city and county
atlas series. Analyzed and submitted differences between functionally classified roads in
city/county base layers vs OrTrans. Updates to Salem and Chiloquin.
23-48 Director's Office Support: Economic Stimulus Maps
Updated JTA Region 5 and statewide map.
23-51 Safety Section Support
Began crash map product for motor carrier.
23-52 Oregon Transportation Commission Maps, Graphics and Analysis
Created maps for meetings and striping crew. Review and confirm locations with
customer.
23-56 Safety Section Support
Reviewed and edited data for 2010 construction map and provided input requirements to
customer for support of future data exchanges.
23-57 SIP-SPIS Maps
Reviewed data runs for errors, submitted to data steward.
23-58 STIP mapping Support:
Received list of key numbers, used to extract and map projects. Created Region 5 map
for public meeting. Created Region 2 maps for draft stip.
23-59 Official State Map / Tourist Map:
Coordination with UofO to complete edits. Printing stopped due to errors.
23-62 Miscellaneous small mapping projects
Develop additional maps for ODOT construction project outreach. Develop exhibit
map for ODOT/Tillamook county road agreement.
23-64 Maintenance Maps - Annual product
Completed district and region maps. Developed custom maps for Don Jordan.

10
Importance

Projected
Status***

Status**
Project

June
April

July
May

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

OEM & Small Projects (cont'd) G G 23-78 TransInfo / I.T.I.S. Rewrite
(Active projects cont'd) Review analysis by RICS Unit and make recommendations regarding OrTrans and Web
Apps with regards to TransInfo.
23-79 House Bill 2001
Georeference scanned maps. Create historical AADT maps.
23-80 Fire Marshal - Extremely Hazardous Site response planning
Worked on inset maps, edited point layers and posted data and maps for review by
customer. Developing an atlas for series.
23-81 Trip Check GIS Prototype
Continue work on prototype of basemap and application.
23-84 RWDMS Phase 3 support HDR Application Development of GIS tools to
define and access Filenet documents.
Provide support by updating and posting data for contractor.
A Transportation Model Development G G G G Ongoing Ongoing Ongoing G 9/17/09: Deschutes County Model: Base year completed. Future year in progress.
Brookings and Woodburn Model: Base / Future year complete and awaiting
applications. OHAS: Fall Survey (Region 2 and LCOG) has begun. GreenStep: large
majority of input data received, currently developing scenarios to model. Marion
High

County Model: Network complete, currently integrating demand from SWIM into the
structure. Corvallis/Albany/Lebanon (CALM) Model: Model will incorporate
Jefferson, Lebanon, Albany, Corvallis, Tangent and selected Marion County areas,
build in progress.

11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
COMPLETED PROJECTS

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

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

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

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

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

Revised 10/12/00
COMPLETED PROJECTS

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

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

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

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

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

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

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

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

Revised 10/12/00
COMPLETED PROJECTS

GIS05 Aggregate Sites 12/31/00 5/30/01
Phase 3
Desktop GIS application
GIS07 Non-State Hwy Functional Classification 6/1/00 12/1/01
System Attribution

GIS13 State Highway 1:24,000 road alignments 6/30/01 7/31/01

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

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

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

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

Revised 10/12/00
COMPLETED PROJECTS

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

GIS20 Oregon Statewide Burial Site & Cemetery 4/30/02
Base Layer
(Phase 2) (Cultural framework)

Revised 10/12/00
COMPLETED PROJECTS

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

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

Revised 10/12/00
COMPLETED PROJECTS

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

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

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

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

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

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

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

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

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

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

Revised 10/12/00
COMPLETED PROJECTS

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

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

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

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

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

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

Urban Transportation Model Development 5/1/02
- Wilsonville

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

Urban Transportation Model Development 12/31/02
- Redmond

Revised 10/12/00
COMPLETED PROJECTS

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

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

Urban Transportation Model Development 6/1/03 3/31/04
- Klamath Falls

Urban Transportation Model Development 5/1/04 6/30/04
- Lakeview

Urban Transportation Model Development 12/31/02 7/01/03
- Grants Pass 8/1/03
2/29/04

GIS19 Phase 2 -
- Refine Database/Procedures
- Final changes to database model
- Deploy Road Authority Database to
internet
- Impliement Database
- Obtain Data
Wasco, Jefferson, Douglas, Umatilla,
and 5 additional counties

DGIS12 TransGIS 2.1 to Web 6/1/02 2/28/03
Phase 1 - Develop test system
-Provide TransGIS functionality in a web-
based application utilizing ArcIMS.
Phase 2 - Testing 9/1/02 6/01/03
6/30/03

Revised 10/12/00
COMPLETED PROJECTS

Phase 3 - Implementation 6/15/03 10/1/03
Reporting Functionality

Phase 4 - Deployment and Training 10/1/03 6/30/04
Develop Data Maintenance Agreement

GIS25 Desktop GIS Routing Software 1/23/03 12/31/03
4/1/04
5/1/04
7/1/04

GIS30 Dynamic Data Display 12/1/03 3/01/04
Phase 1A - SRSAM 6/18/03 4/15/04
8/31/04
9/30/04

DGIS16 Traffic Counting GIS Implementation 7/22/03 12/31/03 2/28/04
Phase 3 - 4/31/04
- Create Internet viewing tool: 6/30/04
- Traffic Counts 9/1/04
- Training & maintenance

Revised 10/12/00
COMPLETED PROJECTS

DGIS16 Traffic Counting GIS Implementation 2/1/04 4/15/04 6/30/04
Phase 4 - 7/30/04
- Create Annual Volume Table 9/15/04
- Create Annual Traffic Volume Flow Map 10/15/04
- Create standard queries

GIS28 Bridge Location Accuracy Enhancement 9/30/04 12/21/04
Phase 2 - Improve location accuracy for
remaining bridges & merge into 1 dataset

GIS34 STIP Mapping of Projects Identified by Area 12/1/04 12/31/04 2/15/05
and unidentified project locations-Draft STIP
06-09
Phase 1 - Determine required fields
necessary for new data and data sources.
Setup database
GIS36 Alternate Route Mapping 01/04/05 06/30/05
Phase 1
Research and consolidate data to
map all existing detour routes.
Create a GIS layer to support Traffic
Management activities for ITS

Revised 10/12/00
COMPLETED PROJECTS

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

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

Revised 10/12/00
COMPLETED PROJECTS

GIS21 GIS Layers Complete
Continued

Revised 10/12/00
COMPLETED PROJECTS

GIS19 All Roads 07/01/04 06/30/05 09/30/05
Phase 3 -
- Develop county-wide GIS data for
Baker, Malheur, Harney, Lake and
Klamath under TSD Safety Grant.
- Load developed data that is
available from other agencies (fed,
state, and local).
- Develop county wide GIS data for
Grant, Hood River and Coos as part
of additional OGIC funding.
- Begin coordination of "edge
matching" of road segments
between road authorities.

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

GIS27 GeoSpatial Onestop 01/23/03 04/30/03 5/30/03
- Central storage & Web retrieval 7/30/03
system for transportation framework 9/30/03
layers 7/1/04
Phase 1 - Evaluation 10/31/05

GIS28 Bridge Location Accuracy 01/10/05 2/15/2005 6/30/05
Enhancement 3/15/2005 7/31/05
Phase 4 - Create metadata 9/15/05
11/15/05

GIS39 Traffic Mobility Mgmt System 07/11/05 10/03/05 08/15/05
Pilot
Phase 1

Revised 10/12/00
COMPLETED PROJECTS

GIS04 Salmon Resource and Sensitive 04/01/02 01/30/04 12/31/05
Area Mapping Project (SR-SAM)
Phase 4 - Region 5
- Deliver final version RES & RAZ
maps to Maintenance and other
staff

GIS28 Bridge Location Accuracy 01/10/05 2/15/2005 6/30/05
Enhancement 3/15/2005 7/31/05
Phase 4 - Create metadata 9/15/05
11/15/05

GIS30 Dynamic Data Display 07/01/04 10/31/04 3/31/05
Phase 1B - Automated Straight-line 12/31/05
Charts (RICS Unit Production Line
Enhancements)

Revised 10/12/00
COMPLETED PROJECTS

GIS37 Biological Field Data Collection 01/05/05 10/14/05 12/31/05
Pilot
Develop two proof of concept pilot
projects using data, procedures and
experience developed in SR-SAM
Project. Pilots are wetland mitigation
site monitoring and environmental
scoping.

GIS40 TransGIS Development ver 2.2 07/11/05 08/30/05 11/01/05
Phase 1

GIS42 TOC GIS Interface
Phase 1
- Complete

Revised 10/12/00
COMPLETED PROJECTS

GIS 19 OR Trans (formerly All Roads, 06/30/05 12/30/05
formerly OTN) 3/31/06
Phase 3 -
- Develop county-wide GIS data for
Baker, Malheur, Harney, Lake and
Klamath under TSD Safety Grant.
- Load developed data that is
available from other agencies (fed,
state, and local).
- Develop county wide GIS data for
Grant, Hood River and Coos as part
of additional OGIC funding.

GIS36 Alternate Route Mapping 9/12/2005 3/1/2006 3/31/2006
Phase 2
- Create and populate a spatially
enabled database with Marion
County data to be available to
ODOT TOC's as well as local
authorities for even scheduling and
routing.

GIS23-19 OEM & Small Projects (Cont) 5/18/2006 unknown 08/15/06
GPS Access Management
Demonstration Project

Revised 10/12/00
COMPLETED PROJECTS

GIS04 (EDMS) Salmon Project
Phase 1 - Region 2 8/01/99 9/01/00 10/15/00
- Development of base GIS/CAD
data for Salmon Recovery Project
for R2
GIS04 (EDMS) Salmon Project 7/1/01 6/30/02 7/31/02
Phase 2 - Region 1
- Development of base GIS/CAD
data for Salmon Recovery Project
for R1

GIS04 (EDMS) Salmon Project
Salmon Resource and Sensitive
Area Mapping Project (SR-SAM)
Phase 4 - Region 5
- Deliver final version RES & RAZ
maps to Maintenance and other
staff

GIS04 Phase 6 - Region 2 04/01/03 06/30/03 08/15/03
- Delivery of Imagery
GIS19 All Roads
Phase 1 - 6/30/02 6/30/03
- Develop data model, database,
data collection procedures, and
documentation
- Obtain data
Complete pilot for Wasco County
Complete State Hwy's
Complete Upper FC roads

Revised 10/12/00
COMPLETED PROJECTS

GIS19 Phase 2 - 06/30/03 06/30/04
- Refine Database/Procedures
- Final changes to database model
- Deploy Road Authority Database
to
internet
- Implement Database
- Obtain Data
- Load 5 county/US97 corridor data
- Develop county-wide GIS data
(Wasco,
Jefferson, Douglas, Umatilla,
Sherman,
Gilliam and 3 additional counties)

GIS22 ODOT Construction Plans and
Right-of-Way Map Index

Phase 2 -
-To be determined

Revised 10/12/00
COMPLETED PROJECTS

GIS31 EnviroView - Environmental Data 09/25/03 01/23/04 3/31/04
Management System 5/31/04
Phase 1
A- Access to existing software and
readily available spatial data
B-Web

06/30/05 12/31/08

Revised 10/12/00
COMPLETED PROJECTS

GIS28 Non State Hwy Bridge Location 07/02/03 03/01/04 4/1/04
Accuracy Enhancement 7/1/04
Phase 1 - Improving location
accuracy for weight restricted
bridges

GIS29 Truck Route Permit Mapping and
Database
Phase 1 - Map existing database 4/01/03 4/30/03 5/15/03
Return mapped data to MC for
review
Edit using ArcExplorer and Access

GIS29 Phase 2 - Make correction after 05/01/03 06/30/03 8/15/03
review 10/15/03
Create PDF files for publication
GIS32 Drainage Facility Management
- Develop system for inventorying,
evaluating and tracking condition of
pipes, culverts and storm water
facilities
Bridge Location Accuracy 01/04/05 1/31/05
Enhancement 2/15/05
Phase 3 - Create 2004 GIS bridge
file

Revised 10/12/00
COMPLETED PROJECTS

GIS29 Truck Route Permit Mapping and 11/01/03 03/04/04
Database
Phase 3 - Outline processes for
maintenance by data steward (MC)

GIS34 STIP Mapping of Projects 12/15/04 02/15/04 02/15/05
Identified by Area and
unidentified project locations-
Draft STIP 06-09
Phase 2 - Populate New Fields
GIS33 Two Year Implementation 12/01/04 01/07/05 01/07/05
Strategy for ESRI Software

Phase 2 - Thematic Line Charts
- Utility to add data themes as a line
chart along the bottom of the SL
sheet.
Phase 3 - Corresponding Map
- SL chart drawn with corresponding
portion of county map along the top.
Ability to export drawings to
additional formats as determined by
the project team.

Phase 4 - 3D Enhancements
- Online creation and viewing, with
selectable data and map scale
through the use of check boxes.
Ability to redline/add user notes.

Revised 10/12/00
COMPLETED PROJECTS

Traffic Counting GIS
Implementation
Phase 1 -
- Create GIS layers (complete)
- Review and Implement Data
Distribution Model (complete)
- Create metadata
- Train TSM staff (complete)

Phase 2 - 07/22/03 10/31/03
- Create GIS database of Counting 12/31/03
Equipment Inventory (ATR's) 2/28/04
- Training & maintenance 4/31/04

GIS42 TOC GIS Interface
Phase 1
- Complete
Imagery Delivery System
GIS04 (EDMS) Salmon Project 6/30/04 6/30/03 9/30/03
Phase 3 - Region 4 3/30/04
- Development of base GIS/CAD 4/30/04
data for Salmon Recovery Project 6/30/04
for R4 9/30/04
12/7/04
2/15/05

Revised 10/12/00
COMPLETED PROJECTS

GIS21 GIS Layers In Progress Ongoing Ongoing Ongoing
Projects categorized as:
OEM or Sum
Assign sub-numbers (Sum)

GIS11-01 GIS Infrastructure Support (cont.) Ongoing Ongoing Ongoing
Training

Revised 10/12/00
COMPLETED PROJECTS

GIS11-03 GIS Infrastructure Support (Cont) Ongoing Ongoing Ongoing
Customer Support

GIS23-05 OEM & Small Projects (cont.) 2/6/2006 03/05/06 12/31/2006
Connect Oregon Phase 1 07/1/06
11/01/06

GIS23-07 OEM & Small Projects (cont.) 3/9/2006 6/1/2007 05/08/07
(TO #11) Water Withdrawal Permitting

Revised 10/12/00
COMPLETED PROJECTS

GIS23-27 OEM & Small Projects (cont.) 09/01/06 02/01/07 2/1/07
Asset Management Region 2 Pilot 6/1/07

GIS16 Traffic Counting GIS 12/01/04 02/28/05 6/1/20/05
Implementation 8/15/05
Phase 5 On Hold
- Create data entry system for 11/01/07
traffic data
- Create database tables, site
inspection, vendor info.
- Equipment Inventory Detail
- Create data entry interface(s)) for
equip inventory
- Provide imagery linking & view
options

Revised 10/12/00
COMPLETED PROJECTS

GIS41 DMV Oregon Automobile Dealers 07/11/05 08/01/05 9/30/2005
12/31/05
2/01/06
04/01/06
06/30/06
08/01/06
10/15/06
12/01/06
2/14/07
3/15/07
6/11/07
9/13/07
10/30/07

GIS43 Crash Coding Tool
- Create GIS application to assist in
coding crashes

- Workstation Based 2/1/2007 4/1/2007

- Web Based 4/1/07 6/17/07
GIS46 Traffic Counting Field Data 1/7/2007 08/01/07
(TO#10) Collection Conversion

Revised 10/12/00
COMPLETED PROJECTS

GIS57 Import 2007 Traffic Count Data 3/10/08 4/15/08 6/1/2008
- Import traffic volume data to 07/01/08
support 2007 production of data and
publications

GIS53 GIS Right-of-Way Parcel Access 03/10/08 06/01/08 07/01/08
- Provide public access to a subset
of R/W data using a GIS Web
Interface

GIS51 Traffic Volume Junction Analysis 06/01/08 07/01/08
- Analyze junctions of Hwys using
GIS to check traffic volumes

GIS47 STIP TransGIS Scoping Tool 5/10/07 11/15/07 11/30/07
Phase 1 & 2 12/31/07
03/15/08
4/1/08
6/15/08
9/01/08
9/30/08

GIS54 ODOT Solar Highway 3/10/08 5/1/08 6/1/2008
- Identify ODOT R/W that Solar 7/31/08
equipment can be tied into PGE 10/31/08
transmission lines

Revised 10/12/00
COMPLETED PROJECTS

GIS50 Alternate Fuels Corridor - I5 1/10/08 2/29/08 2/25/2008
Potential Sites Research 06/30/08
- GIS map and database of all
available sites associated with the I-
5 corridor.

TO #23 Traffic Counting Application 1/3/07 3/10/2008
Features Enhancement 06/01/08
- Contractor will enhance application 9/1/08
used by field traffic counting staff 12/29/08

GIS11-05 GIS Infrastructure Support (cont.) Ongoing Ongoing Completed
GPS Standards

GIS11-09 GIS Infrastructure Support 6/1/06 8/15/06 2/1/09
SDE Implementation
Spatial Reference
Populate Database

Revised 10/12/00
COMPLETED PROJECTS

GIS23-04 OEM & Small Projects (Cont) 1/11/06 3/15/06 12/31/06
Traffic Counting Field Data 06/1/06
Collection 07/15/06
08/01/07

Revised 10/12/00
COMPLETED PROJECTS

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

TDD and ITS Unit developing project plan. Gave demo to ITS Unit and field
technicians. Waiting for data needs assessment from ITS Unit. Roll-out
database using Internet GIS viewing tool as pilot. Updating and cleaning data
for pilot. Delivered prototype to customer for testing. Java script rewritten. Roll-out to additional users, distribute to
ITS. The application has been delivered.

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

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

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

Revised 10/12/00
COMPLETED PROJECTS

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

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

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

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

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

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

(1) Most of the application functions are complete. Adding enhancements and fixes as identified by the GeoHydro
users. GeoHydro forecasts completion by January 2002. Hired temp for data entry. Complete 7/13/01.

2.) Coordinating integration of the GIS portion. Application complete and in testing phase. Maintenance of
aggregate source location data needs to be worked out between GeoHydro and the GIS Unit. Complete 7/13/01.

Revised 10/12/00
COMPLETED PROJECTS

3.) Script created to allow GeoHydro users to map data based on latitude and longitude values stored in the
database is waiting for review by Amy Landvoight and/or Mike Long. Scheduled review and acceptance June 7,
2001. Application is only for use by the GeoHydro personnel. Complete 7/13/01.
35,000 miles of road. 11/30/00 Attribution complete. Error checking in progress. Successfully developed and
tested the new MGE project and
access database. Complete 10/19/01.
Plus or Minus 40' of state highways. Complete August 2001.

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

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

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

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

Test existing GIS software and databases. NPE and testing completed on all products. Complete

Implementation plans are being developed. Migrate software and databases to SQL V7.0 adding capabilities and
flexibility. Data structure modified and migrated to SQL 7. GeoMedia Pro is being used for production work.
Complete

Revised 10/12/00
COMPLETED PROJECTS

Database built and book published. Enhancements and updates are ongoing. Complete.
Met 9/24 to determine how to proceed with data compilation. Oregon Parks and Rec., ODOT Archeology and
Mortuary Board providing data. Fields confirmed at meeting. Verifying data entries. Completed GIS layer from
ODOT map base cemeteries.

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

Revised 10/12/00
COMPLETED PROJECTS

ATR 2002 locations (ATR's) (OEM) 10/02 Hillshade options (OEM) 10/04
ADT 2001 (Average Daily Traffic) (OEM) 10/02 Hwy Culverts less than 6 ft 10/04
ODOT Areas Boundaries (OEM) 11/02 Hwy Culverts 6-20 ft 10/04
ASIS Aggregate Sites (OEM) 10/02 Washington State Base Layers (OEM) 10/04
Hwy Milepost Locations (OEM) 10/02 Environmental Justice 2K blkgrp 12/04
Schools Locations (All public schools) (OEM) 11/02 Bar Pts2 (Fish Passage Barriers) 12/04
Hwy Tenths for updated Hwy Network (OEM) 11/02 Zero Pop. Census Blocks 2000 12/04
US Corps of Engineers Navigable Waters (Complete 12/02) (OEM) Environmental Justice 2K trct 12/04
Crash Segs 2001 (SIP) (Complete 12/02) (OEM) NGS monuments for 2003 (OEM) 1/05
Crashes 5-yr composite by region (Complete 11/02) (OEM) Pavement Conditions 2004 (OEM) 1/05
Highways-lane widths (Complete 11/02) (OEM) Low Volume Pavement Conditions 2004 (OEM) 1/05
Highway-number of lanes (Complete 11/02) (OEM) Annual Average Daily Traffic 2003 (OEM) 1/05
Culverts 2002 (Complete 11/02) (OEM) ATR 2003 (OEM) 1/05
Truck Safety Corridors 2003 Flow Maps 2003 1/05
Truck A/M Corridors 2003 Cemetery 2003 CAD extract 1/05
Culverts 6-20 ft (12/03) Hwy Posted Speed 2004 1/05
Culverts less than 6 ft (12/03) Railroads 2004 1/05
Highway Mileposts 2002 (Complete 10/02) (OEM) NGS Monuments 2003 1/05
Unincorporated Urban Communities 2002 (Complete 11/02) (OEM) Low Volume Presrv Pave 2004 1/05
ODOT Regions Boundaries (Complete 1/03) (OEM) Routes Cross-ref 2005 3/05
ODOT Districts Boundaries (Complete 1/03) (OEM) Bridge Log 2004 3/05
Highway Friction Values 2002 (Complete 2/03) (OEM) Tidegates 2003 2/05
Highway Skid Factors 2002 (Complete 2/03) (OEM) Rest Areas 2005 2/05
Maintenance Crew Assignments (Complete 2/03) (OEM) Waysides 2005 2/05
SPIS Sites (OEM) 4/03 Hwy network Feb 4, 2005 2/05
Tsunami ODOT Inundation Line (GIS21-04) (sm) 3/03

Revised 10/12/00
COMPLETED PROJECTS

Complete:
Access Mgmt ArcView (DGIS13-2) 11/01
Or State Hwy No. conversion (DGIS 13-17) 8/02
A* CARS ArcExplorer (and CD for home users) (DGIS14-2) 2/03
A* Video Log-ArcExplorer Training (GIS23-05) 2/03
D* Road Authority (GIS23-04)(Sm) 12/02
D* City Annexation Data Modeling (GIS23-02)(Sm) (6/03)
A* Software acquisition and distribution (Sm) (9/03)
A* Standard Data Display and Formatting (Sm) (10/03)
A* Upgrade Crash Coder Desktop GIS tool and User Guide (OEM) (10/03)
D* Bridge Location Project (11/03)
D* 650 Map Project (11/03)
A* Bridge Location to Web (11/03)
D* Mapping Speed-monitoring Loops in Metro area for Traffic Condition
Mapping project for statewide Tsunami exercise is complete. Maps show inundation line intersecting state highways,
and lifeline routes. Being tested in statewide earthquake drill April 2nd and 3rd. Complete

Project development nearly complete. Mixture of techniques used to accomplish project. Internet use not yet
approved. Draft model presented to ODOT end-users 3/20 by the IS team (Diane Powers). Waiting for XML
templates from IS Development Team. Network testing underway. Application and data complete and provided to
customer. P+ documentation in draft stage. Complete

Display Lat/Long coordinates and LRS in ArcView. The application is out for peer review. Ready to send through
product approval and Intranet roll-out. Going through NPE. (Complete)
Application complete. Ready to send through product approval and Intranet roll-out. (Complete)

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

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

Revisions made, forwarded to State Forestry for review. Complete and delivered to State Service Center and GIS
User Group.
User has accepted the ArcView Extension (application) software and installation instructions. Network testing of
extension is complete. Extension given to user.

Revised 10/12/00
COMPLETED PROJECTS

Create National Geodetic Survey benchmark layer for Geometronics in ArcView & MGE software. (Complete)

Software purchase complete, documentation under development. Roll-out scheduled to start the week of August
28th. Close after testing complete 10/10/00.
Quality check household activity locations from travel survey buffer points to create environmental design variables.

Building base layer of ODOT maintenance facilities (103) to satisfy Oregon's DEQ water permit requirements.
(Complete)
Produce presentation of output from first generation statewide model. Completed 11/1/00. Project Lead was Brian
Gregor.
Base year employment & housing distributions and network characteristics. Completed 6/1/00. Project Lead was
Sam Ayash.
Road layer comprised of State Highways and nonhighways Functional Class network, attributed with functional
class, number of lanes, posted speeds as available. Preliminary work should be completed by July 2001. Will be
migrated to statewide modeling software. Final review meeting scheduled in November 2001. GIS work for model is
complete.

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

Transportation Analysis Zones (TAZ) defined. Count locations submitted to Region 2. Employer and household
geocoding in progress. Region 2 will be hiring a consultant to perform field data collection. Employer and household
geocoding complete. Region 2 has contracted with consultant to perform field data collection. TAZ and Network
being finalized. Analyzing traffic counts to network links. Incorporated city's housing and employment revisions.
Complete
Scheduling with COG for update of existing model. Consultant compiling existing data. ODOT is collecting and
reviewing traffic count data. Updating population and housing data for consultant. Complete 11/02

Reviewing consultant data. Complete

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

Revised 10/12/00
COMPLETED PROJECTS

Zone and network development in progress. Zones and network have been restructured. City has validated
employment and household data. Waiting for city to provide forecast data. Forecast data under development.
Complete
Complete

Zone and network structure under development. Base year data delivered to Region Planner to verify with local
jurisdictions. City and County are reviewing base year data. Traffic counts not yet complete. Counts complete and
forwarded to consultant. Complete
Developing base year GIS data. Complete

Working on schedule with COG to update existing model. TPAU compiling traffic count data. Region resources not
available, pending Roseburg completion. Delivered to the city for review. Study area has been significantly
expanded. On hold, waiting for forecast data. City has provided final base year revisions and are working on future
year. GIS work Complete

Phase 2 - Modifications to database will result from "lessons learned" in phase 1. Create & integrate data for 5
additional counties. Pilot to work out edge/overlap problems. Apply for pooled Fund SPR 4 OR-WA pilot and 03-05
OGIC grant. Database test results doc phase 1 and implementation plan for 03-05 biennium. Integrated data for
Wasco and Jefferson Counties 100%, Douglas 80% and Umatilla 100% complete. Data obtained from 16 to 18 local
road authorities. Data Dictionary 90%, Process Doc. 90%, Workplan (WBS) for 03-05 90%. All documents have
been sent to Implementation Sub-committee for review. DataModel v5.0 Schema released. Began Sherman and
Gilliam data creation. Working on piggybacking with BLM contractor. Load 5 data sets in the database and send
back to counties for review.

Phase 1 - Steering Committee approved project proposal on March 28, 2002. ArcIMS version 4 approved for use.
First phase will display mapping data like TransGIS. ArcIMS version 4 installed on sarscims server in October.
Templates have been created.
Complete
Phase 2 - Chuck will arrange for network test.
* Purchased production server
* Provide access for selected GIS Users (Susan will choose 20 test users, Chuck will provide the link for the non-
tabbed version to the test users)
* NPE testing in progress
* Sent to 33 test participants 4/30. Created invitation document, review template and how-to document.
* Additional software to be purchased
* New server up and running
Complete

Revised 10/12/00
COMPLETED PROJECTS

Phase 3 -
* Implement Reporting Functionality
* Software for production server ordered and delivered
* Production web server has been installed and configured with ArcIMS
* Rebuild development server
* Most display functions working
* Enhancements & revisions underway as a result of phase 2 testing
* Report generation in progress. Trying to find programmers with Web
experience.
* Roll out to select group of users
Complete

Phase 4 - Developing strategy and schedule. Develop TransGIS to allow Project Delivery Company to access data.
Improved the User Guide and Help Functions. Released and on the Web. Training in progress. Complete

Kick-off meeting completed in April. Project delayed due to resources used for Microstation rollout. Project scope
has been limited to commercially available desktop applications. Stakeholders needs and Package Alternatives
documents are under development. Some of the evaluation software has been received. Stakeholder Needs
document complete. Collecting and formatting ODOT and commercial data for use in testing. Test plan and scoring
criteria are being developed. Complete

Phase 1A - Project request form revised and approved by Steering Committee. Straightline Chart User's Focus Phil Smith
Group met 8/03. Project statement (002, 006, 026, 028) approved. Solution Assessment Survey draft complete.
Application developer selected, development phase in progress. Met with ESRI Corp. and Intergraph Corp. for
additional solutions and ideas for future phases. Visio and MicroStation file exchange test (P750S, P770S) draft
completed. Definition of system draft, subsystem, system functions complete and in progress. Automated
Straightline Application version 1.0.0 released on April 15. Have compiled and forwarded to developer for code
revision. Additional application enhancements are underway in three main areas: (1) meet straightline depiction
requirements (2) tighten product integration of version 1.0.0 output with existing SR-SAM RES and RAZ map
products for GIS Unit production environment. (Completed 12/4/04)

Phase 3 - Five product 'shapefiles' complete (traffic counts and locations) adding to Intranet TransGIS tool. Truck Sue Mead
'Flow Map' and GeoMedia process instructions in progress. Shapefiles in revision to change format and
representation as well as naming conventions. Training in progress to perform GIS spatial data maintenance and
network completeness routines. Foxpro data moved to MS Access format. Equipment inventory is on hold until
annual reports and GIS map production is complete. Equipment inventory moved to related phase (5). The data is
available in TransGIS and the corporate data server. Complete

Revised 10/12/00
COMPLETED PROJECTS

Phase 4 - The data (TVTbl) has been reformated for standard spreadsheet use and no longer maintained in FoxPro. Sue Mead
Additional data review complete (FC update). Data cleaning done. Data updates for 2003 will be input by the end of
May. Volume tables are being drafted. Resources are limited but efforts will resume in May. The GIS database has
been updated with 2003 figures and the TVT draft prints are in review. Data is processed through GIS mapping
software before Flow Map is created. TVT's in final review 6/15/04. Testing for overlaps and gaps. Constructed two
standard queries, TVT report and Flow Map Data for Dynamic Segmentation. Documented business processes.
Report for Traffic Volume Table publication is complete 9/10/04. Flow map complete. Standard queries to create
volume table and flow map publication complete, output was used to create this years publications. Complete

Phase 2 - Phase 1 of the Bridge project located approx. 9000 of the 10,000 bridges that are in the Bridge Mgmt. Sys.
database. The 917 or so remaining bridges were not part of of the original data set because they didn't have a
lat/long. Phase 2 of this project is focused on placing those 917 bridges using only desc. contained in the data.
Work is complete on 590 (64%) of the 917 bridge records as of 9/9/2004. The remaining bridges are primarily local
and culverts (over 6') that, based on the desc. and avail. info., are increasingly more difficult to assign definition
locations. These may be candidates to go to the counties for accurate location. The remaining 327 structures will be
researched by Bridge with field visits or by contacting the agencies with jurisdiction over the structure. Passed
database back to Bridge for incorp. into Bridge Databases. This project was successful in cleaning up coord. values
and other related data such as whether the structure is on the NB or SB side of the hwy. New coordinates were
incorporated into the Bridge Log Database. Complete 12/31/04.

Approximately 500 STIP projects need to be mapped with 900 different locations. Some STIP Projects have multiple
locations. Many of the projects are not on the state system. (Completed 12/30/04)

A meeting was held with Mike Sniezak and Marcia Malstrom to assess the needs of the project. Darlene Gowen
An initial scope of the project was outlined. Next meeting to be held January 21st, 2005 will
include individuals from IS, Incident Management, RICS and GIS. Project needs to be redefined
and brought back to the GIS Steering Comm. due to scope change. Revised project request will
be presented at May 12th meeting. 7/05: Complete

Revised 10/12/00
COMPLETED PROJECTS

Hillshade options (OEM) 10/04
Hwy Culverts less than 6 ft 10/04
Hwy Culverts 6-20 ft 10/04
Washington State Base Layers (OEM) 10/04
Environmental Justice 2K blkgrp 12/04
Bar Pts2 (Fish Passage Barriers) 12/04
Zero Pop. Census Blocks 2000 12/04
Environmental Justice 2K trct 12/04
NGS monuments for 2003 (OEM) 1/05
Pavement Conditions 2004 (OEM) 1/05
Low Volume Pavement Conditions 2004 (OEM) 1/05
Annual Average Daily Traffic 2003 (OEM) 1/05
ATR 2003 (OEM) 1/05
Flow Maps 2003 1/05
Cemetery 2003 CAD extract 1/05
Hwy Posted Speed 2004 1/05
Railroads 2004 1/05
NGS Monuments 2003 1/05
Low Volume Presrv Pave 2004 1/05
Routes Cross-ref 2005 3/05
Bridge Log 2004 3/05
Tidegates 2003 2/05
Rest Areas 2005 2/05
Waysides 2005 2/05
Hwy network Feb 4, 2005 2/05
STIP 04-07

Revised 10/12/00
COMPLETED PROJECTS

Traffic Volume 20 yr projn 2022 2/05
Traffic Volume 20 yr projn 2023 2/05
Pavement Conditions 2004 2/05
Detour Rt. for Mt. St. Helens 2/05
Urban Growth Boundary 2004 2/05
Crashes 2003 2/05
DRAFT STIP 06-09 5/05
SIP Segs 01-03 05/05
City Points 05/05
Railroads 2004 1/05
ATR 2004 (OEM) 6/05
AADT 2004 (OEM) 6/05
Flow Map 2004 (OEM) 6/05
SPIS 01-03 (OEM) 6/05
Mileposts 2005 (OEM) 6/05
Hwy Ones 2005 (OEM) 6/05
Hwynet 2005 Annual (OEM) 6/05
Rest Areas 2005 (OEM) 6/05
Multnomah Imagery (small) 6/05
Clackamas Imagery (small) 6/05
Non Hwy Bridge Scour A, B, C, D 6/05

Revised 10/12/00
COMPLETED PROJECTS

Phase 3 - ODOT has committed to develop 4 counties worth of road centerline data by June
30, 2005 under a grant from OGIC for $100,000. The work is divided between three
contractors: UofO, Central Oregon Community College and BLM. ODOT has received a grant
from the Traffic Safety Division for $80,000 to develop 5 additional counties of data (Morrow,
Malheur, Harney, Lake and Klamath). Under these two grants a total of 9 counties worth of
road centerline will be developed. BLM contract signed. Meeting with Central OR Comm.
College (COCC) to finalize details of the contract on 2/28. The All Roads db is rebuilt and
existing GIS data is being loading. We are also acquiring updated data from USFS, BLM and
counties. UofO is 80% done w/ Union Co. Loading of GIS data continues. IGA is being
developed with Curry county for road centerline development. COCC contract signed (See
status map).

Complete:

A*D* Traffic Mobility 'War Room' GIS capability and data development (6/05)

Revised 10/12/00
COMPLETED PROJECTS

Phase 1 - The Open GeoSpatial Consortium has been contacted. Greh Beuhler forwarded
ODOT's request for a demo of the GeoSpatial One Stop (GOS) to Sam Bacharach. He stated
that OGIC is in negotiations with USDOT for outreach work and that a demonstration on the
West Coast might be a good addition to that. He asked if ODOT was interested in hosting such
a demonstration. We are interested. Attempting to contact project staff to determine status of
project. We have contacted Cy Smith to see if he can help obtain information about the project.
We have contacted Intergraph for assistance. I have sent multiple emails to David Kingsburry
about his contact with GOS and I have not had any response from him or Pamela Siminitz of
GOS. 7/05: Waiting for a response. Cy Smith is researching status of project. 9/08/05:
Waiting to hear back from Cy. 11/10: Received approval from Cy to redeploy server.

In Progress- Need some of Bridge staff time. They are working on other data needs at this
time. Bridge Section staff turnover has slowed project. Time has been scheduled for Bridge to
learn the software and work with GIS to complete the metadata. 7/05 : Bridge Section has
taken instruction and template for metadata completion. SQL database has been moved and
updated, licenses for new software received and software has been installed on staff
workstations. Metadata data entry can now begin. 9/08/05: Bridge staff has received training
to create Metadata. Metadata created and awaiting validation and publishing. This will
complete the project. 11/10: Metadata is in final correction phase.
7/05: Coordination underway - target dates will be identified.
GIS worked with Motor Carrier IS on query result transfer from web application. Results
passed via Python, opening ArcGIS software, sending data to GeoDatabase (MS Access),
dynamically segmented and zoom to query area. Waiting for refinement instructions and
working out security/permissions issues 9/08/05: Phase 1 nearing completion. GIS Unit has
conduct 6 training sessions for customer. Phase 2 project proposals under development.
11/10: Phase 1 complete.

Revised 10/12/00
COMPLETED PROJECTS

7/05: Initial RES map production complete and PDF generation in progress, RAZ Workshop
scheduling to start soon. 9/08/05: Phil will be meeting with the District Staff in Pendleton, La
Grande, Ontario throughout the month of September. 11/10: RAZ workshops for Region 5 are
complete. RAZ data entry and map revisions have begun. 1/12: Final version map production
complete, distribution complete, Phase 4 complete.

Phase 1B - Add features to depict interchange diagram and locator map images, calculate
summary tables, and improve scaling to allow Straight-line production for RICS Unit to remain
in Visio application environment from start to finish into version 1.3.0. 7/05: Project is now active
and being worked. 9/08/05: Working on the last set of deliverables. 1/12: Complete

Revised 10/12/00
COMPLETED PROJECTS

Staff from GIS Unit, Contractor and Geo-Env met 1/5/05 for initial project kickoff and user
needs assessment (UNA). Contractor will continue dialog and development in coordination with
Geo-Env staff. Second UNA for Regional Environmental Coordinators (RECs) conducted
2/1/05. Contractor, GIS Unit staff and Geo-Env staff will continue coordination and
development. 7/05: Contractor's principal staff managing project have left project, new staff on
board. Despite the changes the project remains on schedule. 9/08/05: Initial field trials with
ODOT Geo-Env staff and consultants are scheduled for 9/9-9/22 time frame. Results will be
reported to Geo-Env GIS Committee via their Data Collection Process Review Template. 11/10:
Data Collection Process Review Template complete and submitted. Preparation for second set
of field trials underway. Final report and training sessions are under development. 1/12:
Deliverables received, project complete. Report will be distributed to GIS Steering Committee
prior to 3/9/06 meeting.
7/05: Enhancements underway, communication and training outline complete. Coordinating
with OBPD on transfer of parametrix TransGIS to ODOT. Purchased additional software to
support phase 2. 9/08/05: Due to competing priorities project is delayed. 11/10:
Enhancements are under way again. The new legend now has the ability to turn on labels from
the legend. Currently the only Generic page has the folder and labeling features at this point.
The other pages have been modified and are awaiting updates to the HELP feature and the
changes noted in "What's New". The hardware purchase to facilitate the transfer of Parametrix.
TransGIS to ODOT has been approved and is now awaiting DAS approval. A demonstration to
the Project Leader Quarterly Meeting is scheduled for 10/27 to determine what GIS data could
assist PL's on project scoping. 1/12: Phase 1 complete.

7/05: Coordination underway - target dates will be identified. 9/08/05: The TOC replacement
project is still in the planning and architecture scoping stage. GIS Unit staff have met with
project team and consultants to discuss options for GIS interface. A test application has been
successfully tested to determine if the GIS software can handle the anticipated load. No target
end date has been established. 11/10: Waiting for TAD to provide data for GIS display. 1/12:
Project will include proof of concept to determine interoperability of MapObjects (MO) and
SDE/SQL using GDT data. It's anticipated this activity will be complete 2/1/06. 3/9: Phase 1 -
Pilot proof of concept completed on schedule. Project now exploring software, data, and
interface options with TOC Project staff.

Revised 10/12/00
COMPLETED PROJECTS

In June we assumed the task of developing three additional county datasets. Census was
scheduled to complete this work but was unable to meet tour timeline. We were unable to
complete the three, Tillamook, Coos and Grant counties by 12/31/05. The estimated time for
delivery of the data is the end of January 06. There will be a couple weeks of QA/QC and
question resolution and those datasets, along with Columbia county, which is being done by the
county should be loaded in the database by 3/31/06. 3/9: U of O - Tillamook completed by mid-
March. BLM - Coos completed by mid-March. GeoSolve - Grant and Columbia completed by
mid-March with Hood River delivered late March. *Note* GeoSolve contract under the authority
of OEM and GEO, completion times are estimates. 5/11/06: Phase 3 Complete.

11/10: Actively working on the project and is on schedule for completion date. 1/12: The
database structure for GIS36 is nearing completion. The process of populating the database
with emergency contact information will begin. 3/9: Phase 2 was intended to be focused at
Marion County as a pilot, As we received data from other regions it became apparent that we
could not build a database limited by the needs of the pilot. A prototype database is currently
being tested in Regions 2, 4 and 5. Region 3. ITS is managing the distribution of the database
application to the regions and the collection of feedback by March 3rd. 5/11/06: Prototype has
been revised and is being deployed and used for data collection. Data collection will occur until
Alternate Route Mapping Porject is rolled into the TMOC Project. ~ '07. Phase complete

7/13: GIS Unit processed GPS data from 'conditions report' data collection effort, identifying all
access points on selected highways. GPS mapping compared to Permit Specialist location data
(CHAMPS). Quality, validity, record matching needs under analysis. Region 1, Access
Management and GIS management planning additional meetings. Completed 09/01/06 .

Revised 10/12/00
COMPLETED PROJECTS

Phase 1 - Delivered GIS produced resource maps to Dist. 3, 4 and 5 (Region 2) Received
partial data, anticipating full data next week. Copying in process, computer work complete.
Complete

Phase 2 - Delivered GIS produced resource maps to Dist. 2a, 2b and 2c. Region 2 imagery
delivered. Funding for Region 1 resource map restored. Restricted Activity Base Maps are
created and awaiting data. Budget meeting with funding source and Environmental held
11/21/01, results indicate an impact on phase 3 (Region 4&5). Requested Salmon data from
Brenda Z. Data plotted, delivered to Environmental. Sent to field for review. Final product
delayed until July due to late delivery of data. RAZ maps out to Region 1 for review. Complete

Phase 6 - Sid imagery for Regions 1,2,4 and 5 delivered and installed on Intranet. Tiff imagery
being loaded on network server. Complete

Phase 1 - Data model v4.5 is completed, approved by Internal Review Team. Data has been
loaded and tested. Evaluation of input and output underway. Completed pilot for Wasco
County. Addressing took a majority of the time in the Wasco County project. Addressing will
done later in future counties so a road network can be completed faster. Complete

Revised 10/12/00
COMPLETED PROJECTS

Phase 2 - The All Roads database was changed as a result of issues while loading the 5
county/US 97 corridor data. The five counties that were loaded for this phase were Wasco,
Jefferson, Deschutes, Klamath and Lane counties along with the ODOT highway data. ODOT
has submitted a project proposal to OGIC for continuation of data development on other
counties. Work for 2004 complete. We have a signed project proposal to work on creating
data for 4 additional counties over the next year. The additional counties will be worked on by
U of O or BLM under contract with ODOT. Working to load data currently available from local
road authorities into All Roads database. These local authorities include up to 13 road
authorities that have GIS road data available in some form. Complete

03/06 Continue development of state-wide addressing for 911 center needs. Work will be
coordinated with OEM and its contractors. Additionally work will continue on assigning
and/or improving the county road numbering system for the county owned roads. This
work will include a pilot coordinated thought AOC and Wasco County Road master.

1/12: Work continues to be done on a software solution to allow road authorities the
ability to "check in" and "check out" data through a web interface for a pilot project with
King and Pierce County. The source code for this ability is being developed through an
existing contract between WashDOT and ESRI. The goal of this pilot project is to
develop code that uses data translation technology so that the source code can be
slightly modified to work with various GIS data and GIS database formats. 3/9: Will
provide update after the GIS-T meeting to be held later this month in Ohio.

Revised 10/12/00
COMPLETED PROJECTS

Phase 1 - ArcView 3.3 upgrades or installs have occurred on most computers in Env.
Section. Workshops are being held. Some Env. Section staff are beginning to use
ArcView to produce reports. GIS Unit staff gathering necessary data and making it
available on the ODOT Intranet. More than a dozen brown bag workshops complete.
Future workshops on hold because of the SRSAM project. Work continues on
modifying ArcView to enable easy access to environmental data. Processes that can be
accomplished w/TransGIS will be identified, TransGIS development will be emphasized.
Testing in progress. Complete
1/3/07: Meeting in Wasco resulted in interest of crash coding program and developing
additional data needed for crash coding and sharing existing data. Meeting in Pendleton to
develop web site for data users and contributors resulted in designs that addressed needs of
participants. Code will be written to create what was designed and testing will be preformed on
resulting web page. Upon successful loading of OR-Trans 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 hwy system and where it intersects w/
local roads. This 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 jurisdiction
designation.

Revised 10/12/00
COMPLETED PROJECTS

Phase 1 - The Bridge Section and GIS unit entered into an agreement whereby the GIS unit
would geolocate each of the approx 10,000 bridges (including sign bridges and large culverts)
throughout the state using USGS digital ortho photo quads, digital raster graphs and ODOT
salmon color infrared imagery as necessary to accurately locate these bridges. The latitude
and longitude would be calculated using GIS software and lat/long values would be returned to
the Bridge section for review. Locations for all bridges statewide has been completed and
delivered to ODOT. We have forwarded data to the Bridge group for review and comment,
when accepted we will use the GIS software to generate a new latitude and longitude and
deliver coordinates that they will use to update their current coordinates. The adjusted end date
was met for delivery for Phase 1 however, the work being done was well beyond the scope of
Phase 1 and is actually part of Phase 2.
Complete

Phase 1 - The Steering Committee suggested moving to SQL - the Project Team determined
to do this as part of the enterprise routing project. Data mapped and sent to data steward for
review. Complete

Phase 2 - Templates created while data is being edited and reviewed. Review depends on
customer availability. Complete

OTMS to build database. Possible future GIS interface. Geo-Env currently doing field
culvert surveying and entering data into a user-built Access database in the interim.

In Progress. The Bridge 2004 file and will include off and on Highway System bridges.

Revised 10/12/00
COMPLETED PROJECTS

Phase 3 - On Hold - Motor Carrier is starting to maintain & update database. Route maps
ready for State Printer. Completed 4 separate MAP/GIS Layers, 1 in progress. Motor Carrier
resources have not been available. Dennis will meet with Mike Bollinger to determine
direction.

Completed about 650 of the 948 records. (Completed on 2/15/05)

Draft Complete, out for review. Strategy has been reviewed by GIS Leadership and GIS
Project Team. Implementation under way. Completed on 1/7/05. Reported to Steering
Committee on 3/4/05.

Phase 2 - Planned

Phase 3 - Planned

Phase 4 - Planned

Revised 10/12/00
COMPLETED PROJECTS

Phase 1 - GIS Unit's function is instructional and advisory. ArcExplorer training
continues. Table/data consistency under review as part of TransGIS update. Basic
training complete. Advanced training necessary for database modeling and GIS
enhancement. Additional resources to be dedicated to database issues. FTE dedicated
to mapping Non-state Highway count sites. TVT counts added to TransGIS. Added
value to 568 vehicle class count locations and mapped them. Maps for Sequence 2 sites
are in progress for field tech validation. ADT/TVT/ATR data being processed. GIS Unit's
function increased from advisory to data model drafting, presentation research
(TransGIS display and field staff interface) and data maintenance instruction using GIS
tools. Complete

Phase 2 - Database integration and relationships under way. Forms and queries in
development. Data cleaning under way, element relationships being developed. Additional
relational tables are being created to allow for proper output of data vs. headings. Complete

Phase 3 - As of July 2002 post-field processing occurring for Region 4. The budget impact
noted in phase 2 significantly delayed post field processing and may affect ability to meet target
date. Cost savings were realized from contractor using ODOT Hwy network file. Resource
data received, map prep underway. Issues with resource time and availability. RES maps were
produced for the entire Region. RAZ workshops complete for The Dalles, Klamath Falls,
Lakeview and Moro maintenance areas, Prineville and LaPine scheduled for January and Bend
in May. RAZ map production wrapping up, out for review by 8/30. Database entry and QA
complete, RAZ maps complete and sent to Maintenance Managers for review. Maps returned.
Final maps under production. Complete and distribution underway.

Revised 10/12/00
COMPLETED PROJECTS

Exits and Interchanges 2006 (Sum)
Oregon Auto Dealers 2006 (Sm)
House and Senate Districts 2006 (add phone and names) (OEM)
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
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)GIS techniques for Wetland Specialists (delivered by Casey
Ragain) (8/24)

Revised 10/12/00
COMPLETED PROJECTS

129 (01/06)
42 (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)
5/11/06: Additional projects have been added to database by customer. Database and mapping
work continues. 7/13/06: Database and ArcReader products 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. 1/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)
3/9/06: Met with ODOT Maintenance and Water Resource Department (WRD) to assess
requirements. WRD will accept GIS data as "map" for permit requirement. 5/11/06: 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/06: WRD has responded to ODOT submission. Preliminary SOW submitted to
several contractors for estimate. 1/11/07: 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. 5/10/07:
Final maps received from contractor and delivered to customer. Customer has reviewed
and accepted. Project complete.

Revised 10/12/00
COMPLETED PROJECTS

10/01/06: Data collection complete. Project team cleaning and standardizing data. 11/01/06:
Data being mapped. 12:01/06: Data analysis and GIS presentation being defined. 01/03/07:
Needs Assessment complete (data identified for uses by GIS community). Data will be
extracted according to various requirements, symbology will be established and data will be
passed to TransGIS programmer for implementation. 2/21/2007: Initial delivery complete - in
conversion of data layers to TransGIS some symbology changes are underway. 3/8/07: All data
processed. Map/symbology established and provided to ArcIMS programmer. Consultation
continues to be provided by GIS Unit. 5/10/07 Met with customer who had additional
requirements for the web version. This was primarily symbology and layer color
changes. TransGIS's Asset Management System will be updated and this will complete
the project.
5/11/06: Determination was made to use ITS Asset Inventory software. This software will also
be used to track signals. A future project will be to develop a GIS interface. This project will be
closed until that request is made. 7/13/06: Maintenance Work: Data Entry Interfaces have been
updated to connect to new database format. Traffic Volume Report is functional. Data entry in
progress. Resources intermittent due to TSM staff change and the number of projects in
process through the GIS Unit. 9/14/06: Looking at ITS Software for tracking Traffic Counting
Assets. May not need this project. 10/31/07: Remaining tasks were moved to GIS46 TO #10.

Revised 10/12/00
COMPLETED PROJECTS

9/14/06: DMV utilized 'Code 1' address cleaning software to improve location information.
Duplicate data was discovered and removed. DMV is matching previously encoded
latitude/longitude derivation and adding it to their new 'location' table. DMV is defining new
queries for simple extracts which will be provided to the GIS Unit for geocoding. DMV is
delighted with the quality of the refined database and confident in the new process. 11/01/06:
Data provider is defining appropriate display fields. Data expected to be received by 11/15/06.
Geocoding will take approx 40 hours. Geocoding will take approx 40 hours. 01/03/07: Data
received. No resources available to Geocode. 3/8/07: Geocoding in process. Approx 50%
complete. 5/2/07: Geocoding complete. Data provided to customer in ArcExplorer project for
review. Customer resources not available at this time. 5/10/07: Met with customers and have
delivered a web-based prototype. Another meeting is scheduled to demonstrate the tool and
refine the requirements. 7/9/07: Data
decoding completed and provided to TransGIS. 9/13/07: New extract
delivered to GIS, formatted and provided toTransGIS. Project Complete.
11/8/07: Met with customer and received approval of "simple"
version. Small adjustments to site and this is complete.

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. 5/10/07: Completed - A stand alone
application of the Crash Locator Tool is currently in the ICARE process. (Complete). A
secondary web version of the tool is in development and will be implemented this month.
11/8/07: Completed and in production - enhacements may follow.

11/28/06: Approved at GIS Steering Committee 1/5/07: Met with Alsea Geospatial who
demonstrated existing application called Incident View developed for local emergency
responders. By adapting this application our project cost will be reduce by 50% from initial
estimates. Rewriting Task Order to use Incident View program technology. 3/8/07: Data
provided to consultant. 5/3/07: Consultant delivered alpha version to TSM for review. 8/30:
Received final version of product, in testing phase. 10/29: Project Complete

Revised 10/12/00
COMPLETED PROJECTS

3/20/08: Project underway. 4/4/08: ITIS updload and calculations must be completed by
customer before project continues. 04/15/08: Data load to I.T.I.S. in progress. 5/09/08: I.T.I.S.
load complete. Data import to Traffic Database in progress. 6/5/08: Data import complete.
Query updated for 2007 extracts and TVT report in review. 7/09/08: TVT still in review and
being edited by customer. Map processing cannot continue until data is finalized. -
Completed 7/1/08
3/11/08: Prototype developed. Business refining requirements.
- Complete 7/1/08

3/20/08: Waiting for allocation of resources. 4/4/08: Meeting scheduled with customer to
discuss goals. 4/15/08: Needs defined. COTS solution in review. 5/09/08: FME solution
developed and in review. 6/10/08: GIS unit developed application. Customer can decide
whether analysis should be for total volume or any subset (such as trucks). GIS
automating tools for customer.
- Complete 7/1/08
1/3/08: Tested revised tools and database management. Preparing web accessible instructional
resources. Base software installs are complete. Tools are being distributed to customers.
2/20/08: Distribution of tools continues. 3/20/08: Distribution of tools continues. Most delay due
to FSU resourcing for software installation. 4/4/08: Distribution continues. FSU Software installs
slow. 4/15/08: Distribution continues. Software installs nearly complete. 5/09/08: Completing
distribution and preparing survey for user feedback. 7/09/08: Distribution continues. 25
customer installs remain. 11/12/08: Distribution complete for pilot project customers.
Project complete.
3/20/08: Experiencing problems obtaining data from PGE (Portland General Electric). 4/4/08:
No data from PGE. 04/15/08: Data received. Site maps in progress. 5/09/08: Data analysis and
mapping in progress. 06/18/08: Data processing has increased due to data limitations.
Additional map production required from GIS staff to provide detail for analysis. 10/13/08: Final
maps in production. Analysis review scheduled. This will complete the project as described.
11/12/08: Complete. Maps produced and delivered to customer.

Revised 10/12/00
COMPLETED PROJECTS

2/25/08: Project Complete. 4/15/08: Customer utilizing data and tools. Training set for map
production tool. 6/5/08: Project database and security developed for customer use during
research phase. Data use restrictions prompted this action. Customer continues
research and mapping. Field work and site decisions planned for completion by
customer, end of June 2008. 06/30/08: Maps completed (by customer) and database in
use for various tasks. Project Complete.
1/3/08 - Project approved. 2/25/08 - Data provided to consultant. 3/7/08 - Project due to be
delivered week of 3/10/08. Software delivered, working on software version issue. 4/18/08:
Software out of iCARE. Working with contractor to fine tune bugs with program. 6/25/08: Tech's
have program installed on their laptops and are testing program. 7/14/08: Sending issue log to
contractor on 7-14-08. 9/1/08: Waiting on contractor to complete changes. 11/14/08 -
Contractor is correcting bugs in programming and will be sending out package week of
11/17/08. 12/5/08: New version of software is in ICARe, scheduled for install next week.
12/29/08: Project complete.
Completed 2007

1/9/08: Image migration complete but have not been able to create pyramids; progress halted
since 8/2007; waiting on support. 4/2/08: It has been decided that since some imagery is the
same as that provided by the portal that there is no longer a need to host this imagery
ourselves. 6/18/08: GIS Unit has requested creation of two new databases through IS DBA
staff . 'ODOT' will host standard data tables, replacing shapefiles posted to 'NAS' server.
'PROJECTS' will contain project based file groupings. 9/2/08: The databases have been
created and are in use. 02/01/09: Complete. Now in maintenance mode.

Revised 10/12/00
COMPLETED PROJECTS

3/13/06: Customers have received frequent training refresher courses. Data entry has been
validated. Insufficient resources to address 'instant-update' to main database. Other report
capability not distributed until resources available. 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.

Revised 10/12/00
COMPLETED PROJECTS

Traffic Volume 20 yr projn 2022 2/05
Traffic Volume 20 yr projn 2023 2/05
Pavement Conditions 2004 2/05
RLIS quarterly update (OEM) (3/07)
Detour Rt. for Mt. St. Helens 2/05
Off Highway Local Roads 2007 (Small) (3/07)
Urban Growth Boundary 2004 2/05
TOC Command Areas 2007 (Small) (04/07)
Crashes 2003 2/05
Hazardous Waste Sites updated (OEM) (4/07)
DRAFT STIP 06-09 5/05
National Freight Network nonstate 2007 (Small)
SIP Segs 01-03 05/05
(4/07)
City Points 05/05
National Freight Network state 2007 (Small) (4/07)
Railroads 2004 1/05
Oregon Geologic Data Compilation update V3 (OEM)
Medians 2006 (OEM) (01/07)
(4/07)
Number of Lanes 2006 (OEM) (01/07)
Rest Area Exits 2007 (OEM) (4/07)
Shoulder Wdth/Typ 2006 (OEM) (01/07)
USDA/NRCS Soil Survey update (OEM) (4/07)
Viewpoints 2006 (OEM) (01/07)
Leaking Underground Storage Tanks update (OEM)
Waysides 2006 (OEM) (01/07)
(4/07)
Expressways 2006 (OEM) (01/07)
Flow Map 2005 (OEM) (4/07)
Left Turn Lane 2007 (OEM) (02/07)
Truck Flow Map 2005 (OEM) (4/07)
Right Turn Lane 2007 (OEM) (02/07)
Medians 2006 (OEM) (01/07)
City Limit 2007 (January) (OEM) (02/07)
Number of Lanes 2006 (OEM) (01/07)
Routes cross ref 2007 (OEM) (02/07)
Shoulder Wdth/Typ 2006 (OEM) (01/07)
Highway Traffic Signals 2006 (OEM) (2/07)
Viewpoints 2006 (OEM) (01/07)
Unstable Slopes on State Highways 2007
Waysides 2006 (OEM) (01/07)
(OEM) (3/07)
Expressways 2006 (OEM) (01/07)
RLIS quarterly update (OEM) (3/07)
Left Turn Lane 2007 (OEM) (02/07)
Off Highway Local Roads 2007 (Small)
Right Turn Lane 2007 (OEM) (02/07)
(3/07)
City Limit 2007 (January) (OEM) (02/07)
TOC Command Areas 2007 (Small) (04/07)
Routes cross ref 2007 (OEM) (02/07)
Hazardous Waste Sites updated (OEM)
Highway Traffic Signals 2006 (OEM) (2/07)
(4/07)
Unstable Slopes on State Highways 2007 (OEM)
National Freight Network nonstate 2007
(3/07)
(Small) (4/07)
RLIS quarterly update (OEM) (3/07)
National Freight Network state 2007 (Small)
Off Highway Local Roads 2007 (Small) (3/07)
(4/07)

Revised 10/12/00
COMPLETED PROJECTS

Chuck Jenkins Dennis Scofield Milt Hill
Dianna Mann

Sue Mead Don Crownover Eric
Anderson

Revised 10/12/00
COMPLETED PROJECTS

Sue Mead Don Crownover Eric
Anderson

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