GIS Monthly Project Status Report
June 2007
Project Status
January
Projected
Status***
Status**
March
April
Lead
Project Project Preliminary Adjusted End
Project Name/Description Comments
Number Start Date End Date Date
A Phase 6 -OR-Trans/Pooled Fund GIS19 G G G G 06/30/04 06/30/05 12/31/08 G 7/13/06: Puget Sound Pilot is complete, implementation of FME software will
Project occur in 7/06 and testing phase w/ county datasets from OR and WA will
- Design and construct Web based check occur during the remainder of 2006. 9/14/06: Organization is underway for the
in and out Bi-State pilot project for the Pooled Fund Project. Morrow and Umatilla in OR
Tammi Griffin and Chad Brady
- Check out system and Benton, Franklin and Walla Walla counties in WA. This testing area will
identify issues around integrating data across county and state boundaries into
central database. Methods from Puget Sound Pilot will be used as a means to
improve ways to integrate data for the Pooled Fund Project. 3/8/07: The first
web page for the check in/out site has been created. Info gathered from JAD
session was used to design interface and some of the functionality. At this
point the web page is a mark up of information and the function of loading the
data will be worked out after the overall design has been finished.
4/3/07: Pooled fund project meeting on 3/24/07 in Nashville TN. NE, TN,
IO, WA and OR were all in attendance. California has joined the pooled
fund. 7/9 ODOT has secured $30K per year for the next two years for the
pooled fund.
A Phase 7 - OR-Trans FY 2007 GIS19 G G G G 05/01/07 06/30/08 G 5/1/07 Drafted "Data sharing" document for sharing of road data between Road
- Statewide data partnership (TO #15) Authorities and OR-Trans effort. Received IRIS data extracts for Wasco
- Wasco County Pilot project County and reviewing data for use in pilot project. Crash coder application in
- Develop/Coordinator QA/QC of data "beta" test and review. This app will be used to generate some crash location
w/Road Authorities data for use in Wasco pilot. OR-Trans data loading completed and updates to
- Continue Pooled Fund participation data are being applied. QC issues are being documented and a QC document
Chad Brady
- Develop Routing data on State is in draft form. Pooled Fund project has a "mock" website based on JAD
highways session in Nov 06. Web site is in review w/ contributors for refinement.
Routing data being developed for state highway network and includes one-way,
turn restriction and over dimensional restrictions for use in oversized routing
needs. 7/9 Routing data for the state highway system has been
completed. A "pipeline" connection to the Motor Carrier data is being
developed in SQL to allow live access to restriction information for
routing. Routing application will be deployed through the web using
WMS.
D:\Docstoc\Working\pdf\fddbecd0-d21b-43bf-95b3-5e900336b66c.xls 1
Project Status
January
Projected
Status***
Status**
March
April
Lead
Project Project Preliminary Adjusted End
Project Name/Description Comments
Number Start Date End Date Date
A Phase 6 -OR-Trans/Pooled Fund
Environmental Data Management GIS19
GIS31 G G G G 06/30/04
Ongoing 06/30/05
Ongoing 12/31/08
Ongoing G 9/14/06: Project plan development and budget work in progress.11/20/06: Met
Project
System (TO #4, with "Linking Planning and Enviromental Process" (LPEP) Committee
- Design and construct Web based check
(formerly SR-SAM) TO #12) members representing Planning and Geo-Environmental to discuss progress
in and out to date and opportunities for collaboration, may get assistance with plan
Tammi Griffin and Chad Brady
- Check out system revisions. EDMS Steering Committee Charter drafted and reviewed by LPEP,
Geo-Environmental.1/11/07: EDMS Steering Committee initial meeting held
12/15/06. Committee is reviewing EDMS Strategic Plan and has authorized two
sub-committees: one for continuation of SR-SAM related activities (The RES-
RAZ Sub-Committee) and the other to focus on data and tools. 3/8/07: TDD
and Maintenance Management met to review Program direction. Direction
Milt Hill
affirmed. RES-RAZ Sub-Committee formed with representation including
Maintenance, Geo-Env, TDD and the ODOT-ODFW Liasion. Sub-Committee
wiil meet 3/13/07. 5/10/07: Sub-committee rescheduled for 5/9/07. 7/12/07:
RES/RAZ sub-committee met 5/9/07 in interactive workshop setting to
discuss existing process and products and look at future direction. A
revised Project Proposal for EDMS is being
presented to the GIS Steering Committee. The preliminary
wetlands mapping tool is geing rolled out to Regional staff this
week. OSMA, SHPO and ODOT staff are meeting to discuss
future development of the SHPO Archaeological database.
H Traffic Counting GIS Implementation GIS16 Y Y 12/01/04 02/28/05 6/1/20/05 5/11/06: Determination was made to use ITS Asset Inventory software. This
Phase 5 8/15/05 software will also be used to track signals. A future project will be to develop a
- Create data entry system for traffic On Hold GIS interface. This project will be closed until that request is made. 7/13/06:
data Maintenance Work: Data Entry Interfaces have been updated to connect to
Susan Mead
- Create database tables, site new database format. Traffic Volume Report is functional. Data entry in
inspection, vendor info. progress. Resources intermittent due to TSM staff change and the number of
- Equipment Inventory Detail projects in process through the GIS Unit. 9/14/06: Looking at ITS Software for
- Create data entry interface(s)) for equip tracking Traffic Counting Assets. May not need this project.
inventory
- Provide imagery linking & view options
A DMV Oregon Automobile Dealers GIS41 Y Y Y Y 07/11/05 08/01/05 9/30/2005 R 9/14/06: DMV utilized 'Code 1' address cleaning software to improve location
12/31/05 information. Duplicate data was discovered and removed. DMV is matching
2/01/06 previously encoded latitude/longitude derivation and adding it to their new
04/01/06 'location' table. DMV is defining new queries for simple extracts which will be
Susan Mead and Robin Ness
06/30/06 provided to the GIS Unit for geocoding. DMV is delighted with the quality of
08/01/06 the refined database and confident in the new process. 11/01/06: Data
10/15/06 provider is defining appropriate display fields. Data expected to be received by
12/01/06 11/15/06. Geocoding will take approx 40 hours. Geocoding will take approx 40
2/14/07 hours. 01/03/07: Data received. No resources available to Geocode. 3/8/07:
3/15/07 Geocoding in process. Approx 50% complete. 5/2/07: Geocoding complete.
6/11/07 Data provided to customer in ArcExplorer project for review. Customer
resources not available at this time. 5/10/07: Met with customers and have
delivered a web-based prototype. Another meeting is scheduled to
demonstrate the tool and refine the requirements. 7/9/07: Data
decoding completed and provided to TransGIS
D:\Docstoc\Working\pdf\fddbecd0-d21b-43bf-95b3-5e900336b66c.xls 2
Project Status
January
Projected
Status***
Status**
March
April
Lead
Project Project Preliminary Adjusted End
Project Name/Description Comments
Number Start Date End Date Date
A Phase 6 -OR-Trans/Pooled Fund
TOC GIS Interface GIS19
GIS42 G G G G 06/30/04
05/01/06 06/30/05
05/01/07 12/31/08
06/01/07 G 3/8/07: Prototype delivered, waiting for final requirements.
Project2
Phase
Jenkins
Chuck
Implementation of viewing based check
- Design and construct Web tool
inProvide GIS expertise to the project
- and out
Dennis Scofield and Chad Brady
- Check out system
A Traffic Mobility Management System GIS39 G G G G 03/01/06 G 09/14/06: Placed on Hold by Motor Carrier Staff 10/31/06: Project completed.
Phase 2 Motor Carrier does not need any additional work at this time.
• Develop data models and business 3/8/07: Dennis, Pete Randall, Erik Havig, OBDP Staff and Ron Winterrowd met
processes based on recommendations to discuss future developer needs. Additional discussions will occur over the
and findings from Phase 1. next few months. Invited Randall Thomas to May Steering Committee to
Tammi Griffin
• Create/capture and catalogue data (or discuss needs for project.
secure access to data) that will be used
and maintained for managing traffic
mobility.
• Develop applications that assist in
managing traffic and freight mobility.
• Prototype applications, data and
business processes.
C Crash Coding Tool GIS43 G G G G G This project will create a TransGIS tool which will locate crash sites and collect
- Create GIS application to assist in codes for 25 attributes from ODOT’s GIS system. 03/06/07: Project Kick-off
Robin Ness
coding crashes meeting complete, necessary data identified, TransGIS application under
development. 5/10/07 Completed - A standalone application of the Crash
- Workstation Based 2/1/2007 4/1/2007 Locator Tool is currently in the ICARE process. (Complete). A secondary
web version of the tool is in development and will be implemented this
- Web Based 4/1/07 6/17/07 month.
A Traffic Counting Field Data Collection GIS46 G G G G 1/7/2007 08/01/07 G 11/28/06: Approved at GIS Steering Committee 1/5/07: Met with Alsea
Conversion (TO#10) Geospatial who demonstrated existing application called Incident View
Tricia Tanner
developed for local emergency responders. By adapting this application our
project cost will be reduce by 50% from initial estimates. Rewriting Task Order
to use Incident View program technology. 3/8/07: Data provided to consultant.
5/3/07: Consultant delivered alpha version to TSM for review.
A STIP TransGIS Scoping Tool GIS47 G G G G 5/10/2007 5/10/2007 2/1/2007 G 11/28/06: Approved at GIS Steering Committee 2/21/2007: First requirements
Susan Mead
Phase 1 & 2 meeting scheduled for March. 5/10/07: Met with customers, and received more
direction from Cathy Nelson. 7/9/07: Project outline developed. Sample
'mxd' created. Waiting for customer team to be identified.
D:\Docstoc\Working\pdf\fddbecd0-d21b-43bf-95b3-5e900336b66c.xls 3
Project Status
January
Projected
Status***
Status**
March
April
Lead
Project Project Preliminary Adjusted End
Project Name/Description Comments
Number Start Date End Date Date
A
H Phase 6 -OR-Trans/Pooled Fund
OEM & Small Projects (cont.) GIS19
GIS23-02 G G G
Y G
Y 06/30/04
Ongoing 06/30/05
Ongoing 12/31/08
07/31/2006 G
Y Phase 1 - 3/9/06: Existing CAD files and current brochure descriptions were
ProjectByways GIS Implementation
Scenic 11/15/2006 used to create a GIS layer/theme. Customer reviewed the theme. Additional
Susan Mead and Robin Ness
- Design and construct Web based check 5/15/07 text is being created by customer team. 5/11/06: GIS Unit has produced routes
in and out On Hold from "Detailed Driving Directions" document. 7/13/06: GIS Unit working w/
Tammi Griffin and Chad Brady
- Check out system RICS Unit to review milepoints and details of 'drive-path' .9/14/06: Detailed
spatial data refined. GIS file complete and posted to server. Phase 2 -
Sponsor will work with TransGIS coordinator to establish display and use
requirements. 11/01/06: No resources at this time. 01/03/07: No resources at
this time. 3/8/07: Sponsor ready to initialize TransGIS implementation. All data
work is complete with a March meeting planned. 5/10/07 Met with customers
for initial requirements. On hold for GIS - resources. Another meeting
with the customers will be scheduled to refine the requirements and
schedule the work.
A OEM & Small Projects (cont.) GIS23-03 G G G G Ongoing Ongoing Ongoing G 3/9/06: Data provided by customer had to be re-extracted several times.
Access Management GIS Questions remain about certain records. 5/11/06: Training provided to
Implementation customer. GIS Unit has produced DRAFT dataset. 7/13/06: Coordinate fields
Susan Mead and Robin Ness
added to CHAMPS database to allow for more accurate locational methods.
No resources available at this time. 9/14/06: No resources available at this
time. 11/01/06: Status remains the same. 01/03/07: No change in status.
3/8/07: New extract provided to GIS Unit. 'Mapping' of this data very difficult
due to missing data. Resources need to be found to provide consultation to
Access Management for data cleaning. Also, extracts need to be reconsidered.
5/10/2007 - Met with customers in April and they have requested a
demonstration of TransGIS (remotely) for the District Access
Coordinators to assist in determining additional project requirements. A
schedule will be set and a GIS/IS resource will be providing that
demonstration.
H OEM & Small Projects (cont.) GIS23-09 G G G G 6/9/2006 10/1/2006 5/1/2007 G 7/13/06: GIS Team is awaiting data and value or rating system. 9/14/06: GIS
Susan Mead
Asset Management Safety Rating Pilot On Hold Unit working with sponsor to convey data and GIS standards, identify various
resources, review ongoing tests and define data responsibility. 2/21/07: This
project on-hold awaiting direction from business sponsor. 3/8/07: No business
resources at this time. 5/2/07: No business resources at this time.
C OEM & Small Projects (cont.) GIS23-27 G G G G 09/01/06 02/01/07 2/1/07 G 10/01/06: Data collection complete. Project team cleaning and standardizing
Asset Management Region 2 Pilot 6/1/07 data. 11/01/06: Data being mapped. 12:01/06: Data analysis and GIS
presentation being defined. 01/03/07: Needs Assessment complete (data
identified for uses by GIS community). Data will be extracted according to
various requirements, symbology will be established and data will be passed to
Robin Ness
TransGIS programmer for implementation. 2/21/2007: Initial delivery complete -
in conversion of data layers to TransGIS some symbology changes are
underway. 3/8/07: All data processed. Map/symbology established and
provided to ArcIMS programmer. Consultation continues to be provided by GIS
Unit. 5/10/07 Met with customer who had additional requirements for the
web version. This was primarily symbology and layer color changes.
TransGIS's Asset Management System will be updated and this will
complete the project.
D:\Docstoc\Working\pdf\fddbecd0-d21b-43bf-95b3-5e900336b66c.xls 4
Project Status
January
Projected
Status***
Status**
March
April
Lead
Project Project Preliminary Adjusted End
Project Name/Description Comments
Number Start Date End Date Date
A Phase 6 -OR-Trans/Pooled Fund
GIS Layers In Progress GIS19
GIS21 G G G G 06/30/04
Ongoing 06/30/05
Ongoing 12/31/08
Ongoing G Highway Hundredths 2006 (SM)
Project categorized as:
Projects Highway Ones 2006 (SM)
Tammi Griffin and Chad Brady Mead
Design Sum
- OEM orand construct Web based check Highway Fives (SM)
in and out sub-numbers (Sum)
Assign Highway Tens (SM)
Susan
- Check out system Crashes 2006
STIP 08-11
A GIS Layers Completed GIS21 C C C C Completed Completed Completed C TOC Command Areas 2007 (Small) (04/07)
Hazardous Waste Sites updated (OEM) (4/07)
National Freight Network nonstate 2007 (Small) (4/07)
National Freight Network state 2007 (Small) (4/07)
Oregon Geologic Data Compilation update V3 (OEM) (4/07)
Rest Area Exits 2007 (OEM) (4/07)
Susann Mead
USDA/NRCS Soil Survey update (OEM) (4/07)
Leaking Underground Storage Tanks update (OEM) (4/07)
Flow Map 2005 (OEM) (4/07)
Truck Flow Map 2005 (OEM) (4/07)
Contracts (I.T.I.S. 2007 extract) (OEM) (5/07)
Traffic Volume Projection 2025 - 20yr (OEM) (5/07)
Bridges 2007 (OEM) (6/07)
SPIS 04-06 (OEM) (6/07)
RLIS (Metro database) update (OEM) (6/07)
A GIS Infrastructure Support (cont.) GIS11-01 G G G G Ongoing Ongoing Ongoing G TRAINING RECEIVED:
Training Building GeoDatabases I - GIS Staff (02/07)
Building GeoDatabases II - GIS Staff (03/07)
GPS and Field Data Collection (C. Ragain & R. Johnson) (4/07)
TRAINING DELIVERED:
Susan Mead
R. Johnson gave Mapbook demos to UoO and TDD (11/06)
C. Ragain gave Hydro-NHD layer demo to GIS Unit (11/06)
ArcView Traffic Counting App to Alsea Geospatial (12/06)
S. Mead/R. Johnson Traffic Counting Refresher & TSM Unit Coaching (2/07)
R. Johnson gave Mapbook training to Region 1 RTP staff (6/07)
R. Johnson gave GPS centroid training to Bridge staff (6/07)
R. Johnson gave metadata training to new GIS staff (6/07)
A GIS Infrastructure Support (cont.) GIS11-02 G G G G Ongoing Ongoing Ongoing G DEMONSTRATIONS:
Demonstrations Feature Manipulation Engine (FME) (10/06)
(6 month drop-off cycle) Routing software demo to MC
Susan Mead
Target: Project Manager TransGIS demonstration
OTC Highway Finance Office TransGIS demo
Doug Tindall, Hwy Div Manager OGIC OR-Trans demonstration
Additional PBLT groups
Area Managers
Project Manager
D:\Docstoc\Working\pdf\fddbecd0-d21b-43bf-95b3-5e900336b66c.xls 5
Project Status
January
Projected
Status***
Status**
March
April
Lead
Project Project Preliminary Adjusted End
Project Name/Description Comments
Number Start Date End Date Date
A Phase 6 -OR-Trans/Pooled Fund
GIS Infrastructure Support (cont.) GIS19
GIS11-03 G G G G 06/30/04
Ongoing 06/30/05
Ongoing 12/31/08
Ongoing G CUSTOMER SUPPORT HOURS:
Project Support
Customer 46 (01/07)
Tammi Griffin and Chad Brady Mead
- Design and construct Web based check 43 (02/07)
in and out 28 (03/07)
Susan
- Check out system 24 (04/07)
61 (05/07)
45 (06/07)
A GIS Infrastructure Support (cont.) GIS11-04 G G G G Ongoing Ongoing Ongoing G METADATA:
Metadata Hwynet Annual May 2006 (09/06) (provided to Clearinghouse)
City limit Annual Aug 2006 (09/06) (provided to Clearinghouse)
Susan Mead
Oregon Geologic Data Compilation V2 (OGDC) (09/06 - format/import)
Unstable Slopes (11/06)
Temporary Employee trained and working approx. 50 docs (12/06)
Metadata for 128 data layers completed and published (01/07)
Metadata for 51 data layers completed and published (04/07)
7/7/07: No resources
A GIS Infrastructure Support (cont.) GIS11-05 G G G G Ongoing Ongoing Ongoing G
Nielsen
Standards
Chad
A GIS Infrastructure Support (cont.) GIS11-06 G G G G Ongoing Ongoing Ongoing G In Progress:
Software GDT Dynamap Transportation with ACG Guide (E)
Evaluation/Purchase/Implementation ArcPad (E)
GPScorrect (E)
GPS Analyst (E)
GeoMedia Fusion (E)
GeoMedia Transportation Manager (E)
GeoMedia Transportation Analyst (E)
Chad Nielsen
GeoMedia Fusion (E)
Mapbook (E)
Maplogic Layout Manager (E)
Terrain Navigator ArcGIS Extension (E)
Map2PDF (E)
ArcGIS 9.2 (E) (Pending Leadership Approval)
Complete:
ArcGIS 9.1
Descartes 8.05
FME Suite 2006 GB (P)
GeoMedia 6.0 (I)
H GIS Infrastructure Support (cont.) GIS11-07 G G G G Ongoing Ongoing On Hold G 7/13/06: Researching needs with regards to new SDE/SQL environment.
GIS File Structure Attending GeoHydro meetings to work through file organizational structure to
Susan Mead
build their conceptual data structure. Responding to storage issues with regard
to imagery by placing tiffs on alternate partition. 9/14/06: Data structure being
addressed using 'layer' files. The optimal implementation of the layer files will
be coordinated with Geo/Hydro/Enviro Section. 5/2/07: On hold until
customer resources are available.
D:\Docstoc\Working\pdf\fddbecd0-d21b-43bf-95b3-5e900336b66c.xls 6
Project Status
January
Projected
Status***
Status**
March
April
Lead
Project Project Preliminary Adjusted End
Project Name/Description Comments
Number Start Date End Date Date
A Phase 6 -OR-Trans/Pooled Fund
GIS Infrastructure Support GIS19
GIS11-08 G
Y G
Y G
Y G
Y 06/30/04
Ongoing 06/30/05
Ongoing 12/31/08
Ongoing G
Y 3/9/06: CAD and GIS - Exploring a variety of solutions to transfer raster and
Ryan Johnson and Darlene
Project
Guidelines vector data between GIS and CAD software with the goal of establishing a
- Design and construct Web based check
GIS11-08-05 CAD and GIS standardized solution that offers consistent results. 3/9/06: Developing
in and out
GIS11-08-03 Map Layouts cartographic templates to ensure that ODOT map products have a
Gowen
Chad Nielsen Griffin and Chad Brady
- Check out system standardized appearance and consistently contain the appropriate layout
elements. 5/11/06: No current activity pending available resources. 9/14/06:
No resources available. 11/01/06: New 'Mapbook' type format and output
being researched and formatted for change to GIS City/County map
production.
A GIS Infrastructure Support GIS11-09 G G G G 6/1/2006 8/15/2006 G 7/13/06: Spatial Reference: Review Spatial Reference set-ups and decisions
SDE Implementation with Business Partners and other agencies. Review extents vs. precision to
Tammi
Spatial Reference determine with regards to ODOT needs / GIS Unit needs / Engineering needs.
Populate Database Recommendation forthcoming. Populate Database: Test files have been
loaded and various interactions. 9/14/06: Spatial Reference settings in place.
Image loading techniques in review and being documented.11/01/06: Data
identified and copied to SQL/SDE environment. 01/03/07:Additional server
storage acquired. 3/8/07: Image migration in process.
L
Brian Dunn a
u
H
A Phase 6 -
Transportation Model Development Y
G Y
G Y
G Y
G On Hold
Ongoing On Hold
Ongoing On Hold
Ongoing Y
G Phase 6 - On Hold -Data (TVTbl) has been reformatted for standard Rogue
3/9/06: Marion County - 90% - On hold pending RPS work. 5/06/06:
Valley MPO - complete. 7/13/06: Marion County GIS work complete
* On Schedule TO = Task Order
A=Active * Requires Corrective Action
C=Complete * Project complete or not started *Small Projects
H=On Hold A*=Application
P=Planned ** Forecast of project status for next month D*=Data Development
D:\Docstoc\Working\pdf\fddbecd0-d21b-43bf-95b3-5e900336b66c.xls 7
COMPLETED PROJECTS
Project # Start End Adjusted
Project Comments
Date Date End Date
GIS09 GIS Software Evaluation Process 3/01/01 9/30/02 Outside contracts reviewed. Software evaluated. Project Plan created. ARC IMS Web software received 9/25/00.
- Develop GIS software evaluation 3/1/02 1/23/03 Installed and sent through NPE. Approval received to purchase software. Placed on hold for lack of resources.
guidelines (complete) 5/22/03 Returned to active status 1/22/02. Draft of GIS Software Evaluation Guidelines presented to Steering Committee
- Develop test plan template 7/24/03 3/28/02. Dennis will make revisions and bring to 1/23/03 committee meeting. Using purchase of SDE (spatial data
(complete) engine) GIS server software to develop and test process. (Will not work with OTS software). Used proposed ArcSDE
- Develop template for cost analysis acquisition to demonstrate revised Life Cycle template which is currently being revised based on Steering Committee
(Life cycle costs) feedback. Complete
DGIS04 ITS Traffic Counting Equipment 10/1/00 3/1/01 TDD and ITS Unit developing project plan. Gave demo to ITS Unit and field
(Closed on 3/01/01) technicians. Waiting for data needs assessment from ITS Unit. Roll-out
database using Internet GIS viewing tool as pilot. Updating and cleaning data
for pilot. Delivered prototype to customer for testing. Java script rewritten. Roll-out to additional users, distribute to
ITS. The application has been delivered.
DGIS05 TransGIS (Version 2.0) 9/1/01 Met with Pavement, STIP coordinators, Intermodal (Freight), Congestion, Traffic Safety, Bridge and Transportation
- Develop plan for next phase Systems Monitoring. Re-scheduling to meet with Motor Carrier. Developing decision list to prioritize actions.
- Intermodal (Freight) Integrating data collection and storage for this and Region 2 Corridor Planning. Demo to Steering Committee 3/22/01.
- Pavement Met with Mgmt. System Managers to review data requests and formats. Continue to enhance and add features to the
- Congestion application (Shaded Relief, Print Functions, Save Settings, etc.). Work continues to enhance performance and
- Bridge implement changes. Receiving data for all Hwy's: 2000 Pavement Friction, ITS Devices, partial Bridge data for Hwy
- Traffic Counting 162, ADT's and Speed data. Training complete, roll out from Mark Robinson on 9/28/01. Complete 10/22/01 will be
distributed to 60-70 additional users. In maintenance - to develop project plan for next phase.
DGIS06 Highway Layer for ArcView 9/1/00 2/28/02 Conversion program from MGE to ArcInfo. Created Measured Shapefile that can be used in ArcView 3.1. Common
- Conversion program from MGE to ArcInfo. alignments, equations and z mileages all displayed correctly. Minor problems uncovered, approx. 150 points did not
Allows users to dynamically segment, review plot. Documenting process, resolving problem areas. Testing by GISU is needed to determine if the file should be
and display their own highway data. made available to others throughout ODOT. Two measured shapefiles of the highway network were created in
January 2002 (1:24,000 network, production road network) with modified processes to improve accuracy. Testing by
GISU continues. Complete 2/28/02
DGIS07 SMMS Web Based Access 2/15/01 5/15/02 Loaded on test machine. Resources are needed. Software ready for testing, loading 10/2/01. Software DLL conflicts
- (DGIS 10 is complete) halted implementation. No conflicts in new version of software. NPE submitted and software testing is underway.
Metaweb and GeoConnect Admin Tools to be loaded when serial number is received from Intergraph. NPE for new
version complete. Loaded on test web. Bruce Westcott from Intergraph is working on problems with
software/hardware connections. Met with DBA and security on 5/3/02, web problem resolved. Testing under way with
Regions 1, 4 and 5. Change Mgmt. scheduled for May 28th, will then implement on production server. Complete
DGIS09 Automated Collision Diagram 6/30/01 Software reviews complete, demo for Chuck complete, considering re-make of the Maryland model. City of Portland's
- Phase 1 negative experience with the newest version of Intersection Magic and our crash data has discouraged its use. Traffic
- Study options Engineers requested that we create our own package. The decision was made to design a new package using the
Maryland system as a model. Complete
Revised 10/12/00
COMPLETED PROJECTS
DGIS09 Automated Collision Diagram 5/30/02 9/01/02 Prototype in place and will make it similar to the in-house application (Visual Basic). Possible software to use for the
- Phase 2 01/01/03 actual drawing (Visio, MapObjects, MS Paint, etc.). 10/23/01 resources identified. Re-writing software. Working on
- Development/Testing symbols to depict data. Should have prototype in May, first release in June and final release in September. Demo for
Traffic Managers meeting scheduled for June. Setting up two employees in Region 2 to test the application. Delivered
Beta version to R2 November 2nd. Testing and software revisions complete
DGIS09 Automated Collision Diagram 3/1/03 4/01/03 Documentation nearly complete. Purchasing visio software. NPE review underway. Deploy 2 copies to each region
- Phase 3 5/22/03 HQ traffic management staff. Visio software delivered, Documentation complete, demo to OTMS Steering Committee
- Implementation 3/27/03. Distribution in process. Complete
DGIS10 SMMS Metadata migration to SQL Server 2/15/01 6/1/01 Replace SMMS 3.1 with SMMS 3.2. Migrate from SMMS database to an SQL server. An SQL (test) server has been
built and the SMMS 3.2 SQL version is being tested. NPE in progress. Currently being placed on the SQL Server V7
(EXSQL7P2). Complete 6/12/01
DGIS11 DMV Project 8/1/01 10/1/01 Chuck met with DMV on July 18th to determine needs. Working on language breakdown. (I.e. Asian). System
delivered to DMV. In warranty mode. Complete 9/18/01 (80 hour project).
DGIS15 Access Control Demonstration 10/31/02 2/28/03 Resource materials have been acquired and sample sites chosen (The Dalles). Resources have been formatted into
- Incorporate resources standard/uniform projection. Project on hold, resources dedicated to GIS19. Project reactivated 11/10/02. Right-of-
- Changes to CHAMPS database and Way images acquired. Adobe Photoshop software on order to complete processing. Pilot covered State Highways in
hyperlink to GIS tools 1 city. Pilot demo Complete .
- Database development for ROW research
GIS01 Base Layer Development 3/24/98 9/22/98 Extended close date 11/30/00. Data Model approved, test data base has been created. Transferring data to new
database. Creating Standard and user documentation. Transferring data to production database (State highways,
County Boundaries, City limits, ATR sites). Finishing User documentation.
GIS05 Aggregate Sites 5/29/00 5/30/01 (1) Most of the application functions are complete. Adding enhancements and fixes as identified by the GeoHydro
Phase 1 users. GeoHydro forecasts completion by January 2002. Hired temp for data entry. Complete 7/13/01.
Intranet database application
GIS05 Aggregate Sites 1/31/01 5/30/01 2.) Coordinating integration of the GIS portion. Application complete and in testing phase. Maintenance of aggregate
Phase 2 source location data needs to be worked out between GeoHydro and the GIS Unit. Complete 7/13/01.
Intranet GIS application
GIS05 Aggregate Sites 12/31/00 5/30/01 3.) Script created to allow GeoHydro users to map data based on latitude and longitude values stored in the database
Phase 3 is waiting for review by Amy Landvoight and/or Mike Long. Scheduled review and acceptance June 7, 2001.
Desktop GIS application Application is only for use by the GeoHydro personnel. Complete 7/13/01.
GIS07 Non-State Hwy Functional Classification 6/1/00 12/1/01 35,000 miles of road. 11/30/00 Attribution complete. Error checking in progress. Successfully developed and tested
System Attribution the new MGE project and
access database. Complete 10/19/01.
GIS13 State Highway 1:24,000 road alignments 6/30/01 7/31/01 Plus or Minus 40' of state highways. Complete August 2001.
Revised 10/12/00
COMPLETED PROJECTS
GIS14 GIS Base Layers Phase 2 1/24/01 3/1/3102 (Dependant on the completion of GIS 17) Add new layers to GIS SQL database 6 at a time. Database modeling and
- Select 6 new base layers data acquisition is under way. Layers changed to meet the needs of the Conditions Report and TransGIS version 2.
1-Pavement Conditions 1999 Received 2001 Pavement Conditions data. Congestion data has been reviewed and released in TransGIS 2.1.
2-ITS Congestion data is being viewed again. Re-visit corporate GIS base layers and bring back to Dec. 5th meeting.
3-Bridge Project reassigned to GIS21. Descriptions and guidelines rewritten. Complete
4-Intermodal (FIMS)
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 Project Statement (002,026,028), Context of the System (140), Definition of the System/Subsystems (200/210), in draft
National Highway System to SQL form awaiting approval. Began work on possible data model. Project Plan approved. Two prototype databases
created on SQL server 7.0 for evaluation purposes on 8/31/01. Testing prototype SQL server database (HGIS15a)
using COTS (commercial off the shelf) software. Querying, reporting and updating capabilities are being tested using
GeoMedia Pro, Access and SQL Server utilities. Database model has been updated, preparing documentation (P Plus
Deliverables 170, 180 and 190). Testing and migration complete. Complete
GIS16 Wasco County Pilot Project 5/01/2001 6/30/01 Partner with other authorities to build a GIS network of all Oregon roads. First project co-operative with University of
Phase 1 Oregon for completion of Wasco County. Contract review and data analysis took longer than anticipated, scope was
6 target areas reduced. 6 target areas complete. Complete 6/26/01.
GIS16 Wasco County Pilot Project 7/23/01 9/30/01 Phase 2 slightly delayed by other projects at the University; dedicated resources stretched thin resulting in attaching
Phase 2 attribution delays. Server crash caused some data loss. Other University obligations will end 10/5/01 at which time
All roads GIS coverage work will resume. Met with the University on 9/24/01 to resolve delays in phase 2 and discuss a potential phase 3
(additional counties). Complete 12/28/01 data sent to GPL and T-FIT for review.
GIS17 Upgrade of GIS related software 10/25/01 3/31/02 Test existing GIS software and databases. NPE and testing completed on all products. Complete
Phase 1 - testing
GIS17 Upgrade of GIS related software 1/1/02 3/31/02 Implementation plans are being developed. Migrate software and databases to SQL V7.0 adding capabilities and
Phase 2 - implementation flexibility. Data structure modified and migrated to SQL 7. GeoMedia Pro is being used for production work.
Complete
GIS18 Road Authority Database 7/1/01 10/1/01 Database built and book published. Enhancements and updates are ongoing. Complete.
GIS20 Oregon Statewide Burial Site & Cemetery 4/30/02 12/30/02 Met 9/24 to determine how to proceed with data compilation. Oregon Parks and Rec., ODOT Archeology and Mortuary
Base Layer Board providing data. Fields confirmed at meeting. Verifying data entries. Completed GIS layer from ODOT map
(Phase 1) (Cultural framework) base cemeteries.
- Develop GIS layer for cemeteries from
ODOT map bases.
(Approx. 500)
GIS20 Oregon Statewide Burial Site & Cemetery 4/30/02 Working with State Parks Div. who is adding Oregon Burial Guide cemeteries to our layer (additional 700 sites) and
Base Layer BLM to build State Historical Preservation Office (SHPO). Complete
(Phase 2) (Cultural framework)
Revised 10/12/00
COMPLETED PROJECTS
GIS21 GIS Layers Complete ATR 2002 locations (ATR's) (OEM) 10/02
Projects categorized as: ADT 2001 (Average Daily Traffic) (OEM) 10/02
OEM or Sm ODOT Areas Boundaries (OEM) 11/02
Assign sub-numbers ASIS Aggregate Sites (OEM) 10/02
Hwy Milepost Locations (OEM) 10/02
(Quarterly drop-off cycle) Schools Locations (All public schools) (OEM) 11/02
(Mar-Jun-Sept-Dec) Hwy Tenths for updated Hwy Network (OEM) 11/02
US Corps of Engineers Navigable Waters (Complete 12/02) (OEM)
Crash Segs 2001 (SIP) (Complete 12/02) (OEM)
Crashes 5-yr composite by region (Complete 11/02) (OEM)
Highways-lane widths (Complete 11/02) (OEM)
Highway-number of lanes (Complete 11/02) (OEM)
Culverts 2002 (Complete 11/02) (OEM)
Truck Safety Corridors 2003
Truck A/M Corridors 2003
Culverts 6-20 ft (12/03)
Culverts less than 6 ft (12/03)
Highway Mileposts 2002 (Complete 10/02) (OEM)
Unincorporated Urban Communities 2002 (Complete 11/02) (OEM)
ODOT Regions Boundaries (Complete 1/03) (OEM)
ODOT Districts Boundaries (Complete 1/03) (OEM)
Highway Friction Values 2002 (Complete 2/03) (OEM)
Highway Skid Factors 2002 (Complete 2/03) (OEM)
Maintenance Crew Assignments (Complete 2/03) (OEM)
SPIS Sites (OEM) 4/03
Tsunami ODOT Inundation Line (GIS21-04) (sm) 3/03
GIS23 OEM & Small Projects(OEM) Complete:
- Other projects completed by the GIS Access Mgmt ArcView (DGIS13-2) 11/01
Project Team Or State Hwy No. conversion (DGIS 13-17) 8/02
A* CARS ArcExplorer (and CD for home users) (DGIS14-2) 2/03
(Quarterly drop-off cycle) A* Video Log-ArcExplorer Training (GIS23-05) 2/03
(Mar-Jun-Sept-Dec) D* Road Authority (GIS23-04)(Sm) 12/02
D* City Annexation Data Modeling (GIS23-02)(Sm) (6/03)
A* Software acquisition and distribution (Sm) (9/03)
A* Standard Data Display and Formatting (Sm) (10/03)
A* Upgrade Crash Coder Desktop GIS tool and User Guide (OEM) (10/03)
D* Bridge Location Project (11/03)
D* 650 Map Project (11/03)
A* Bridge Location to Web (11/03)
D* Mapping Speed-monitoring Loops in Metro area for Traffic Condition
Revised 10/12/00
COMPLETED PROJECTS
GIS24 Tsunami Inundation Mapping Analysis 3/5/2003 4/4/03 Mapping project for statewide Tsunami exercise is complete. Maps show inundation line intersecting state highways,
and lifeline routes. Being tested in statewide earthquake drill April 2nd and 3rd. Complete
GIS26 On-Line Contractor Emergency Registry 12/15/02 4/01/03 Project development nearly complete. Mixture of techniques used to accomplish project. Internet use not yet
System 5/1/03 approved. Draft model presented to ODOT end-users 3/20 by the IS team (Diane Powers). Waiting for XML templates
- Build GIS interface to IS Web developed from IS Development Team. Network testing underway. Application and data complete and provided to customer. P+
site documentation in draft stage. Complete
ArcView Lat/Long coordinates 08/01/00 9/15/00 Display Lat/Long coordinates and LRS in ArcView. The application is out for peer review. Ready to send through
product approval and Intranet roll-out. Going through NPE. (Complete)
Arc View Display of DGN Files 09/01/00 09/15/00 Application complete. Ready to send through product approval and Intranet roll-out. (Complete)
ArcView Location Reference System (LRS) 08/01/00 09/15/00 Application complete. Ready to send through product approval and Intranet roll-out. Going through NPE. (Complete)
Highway Milepoint Readout
GPS Standards 05/01/00 05/01/00 Document approved on April 20, 2000. Distribution is being planned
Rail Network 08/01/00 03/15/00 Revisions made, forwarded to State Forestry for review. Complete and delivered to State Service Center and GIS User
Group.
Rail Crossing 03/15/00 05/31/00 User has accepted the ArcView Extension (application) software and installation instructions. Network testing of
extension is complete. Extension given to user.
Federal benchmark layer (NGS) (Complete) 07/15/00 Create National Geodetic Survey benchmark layer for Geometronics in ArcView & MGE software. (Complete)
Desktop GIS - STIP/SIP (DGIS03a) 06/16/00 10/15/00 Software purchase complete, documentation under development. Roll-out scheduled to start the week of August 28th.
Close after testing complete 10/10/00.
Joint Estimation Model Data Development 05/15/00 09/30/00 Quality check household activity locations from travel survey buffer points to create environmental design variables.
(Medford)
ODOT Injection Wells Inventory (Phase 1) 6/22/00 09/01/00 Building base layer of ODOT maintenance facilities (103) to satisfy Oregon's DEQ water permit requirements.
(Complete) (Complete)
Statewide Model Application Project 6/1/00 12/1/00 Produce presentation of output from first generation statewide model. Completed 11/1/00. Project Lead was Brian
(Willamette Valley) Gregor.
Non-MPO Travel Model Data Support 3/1/00 11/30/00 Base year employment & housing distributions and network characteristics. Completed 6/1/00. Project Lead was Sam
(Lebanon) Ayash.
Generation 2 Statewide Model 7/1/99 12/31/01 Road layer comprised of State Highways and nonhighways Functional Class network, attributed with functional class,
number of lanes, posted speeds as available. Preliminary work should be completed by July 2001. Will be migrated to
statewide modeling software. Final review meeting scheduled in November 2001. GIS work for model is complete.
Urban Transportation Model Development 6/1/01 12/1/01 Waiting for review from cities of the employment and household data. Recent vacancies in both City of Coos Bay and
- Coos Bay/North Bend ODOT Region 3 have slowed progress on this project. Employment and household data complete. Entering traffic
count data. Complete 12/31/01
Revised 10/12/00
COMPLETED PROJECTS
Urban Transportation Model Development 9/1/01 6/1/02 Transportation Analysis Zones (TAZ) defined. Count locations submitted to Region 2. Employer and household
- Woodburn geocoding in progress. Region 2 will be hiring a consultant to perform field data collection. Employer and household
geocoding complete. Region 2 has contracted with consultant to perform field data collection. TAZ and Network being
finalized. Analyzing traffic counts to network links. Incorporated city's housing and employment revisions. Complete
Urban Transportation Model Development 3/13/02 5/30/02 Scheduling with COG for update of existing model. Consultant compiling existing data. ODOT is collecting and
- Roseburg reviewing traffic count data. Updating population and housing data for consultant. Complete 11/02
Urban Transportation Model Development 5/1/02 Reviewing consultant data. Complete
- Wilsonville
Urban Transportation Model Development 6/1/02 12/31/02 Providing preliminary TAZ, model road network, employment and housing data to City for review. Incorporating city
- Newberg housing and employment revisions and forecast data. Need City of Dundee to validate employment, household and
forecast data. Complete
Urban Transportation Model Development 12/31/02 Zone and network development in progress. Zones and network have been restructured. City has validated
- Redmond employment and household data. Waiting for city to provide forecast data. Forecast data under development.
Complete
Urban Transportation Model Development 7/1/02 7/1/03 Zone and network development in progress. Zones and network have been restructured. City has validated
- Brookings employment and household data. Waiting for city to provide forecast data. Forecast data under development.
Complete
Urban Transportation Model Development 5/1/03 7/1/03 Complete
- Central Oregon
Revised 10/12/00
ODOT Construction Plans and GIS22 On Hold - Intranet application to create a spacial index (map) of
Right-of-Way Map Index ODOT Construction projects and Right-of-Way files data stored in
ITIS. Resources need to be assigned. Data from ITIS for Map
information has been obtained. Basic intranet application has been
developed in ArcIMS but does not include the Construction Projects
or Right-of-Way Maps, reports or additional queries. Project
approved by Cathy Nelson. Project delayed due to other project
priorities and lack of resources.
Drainage Facility Management GIS29 11/1/03 3/4/04 Phase 3 - On Hold - Motor Carrier is starting to maintain & update
- Develop system for inventorying, database. Route maps ready for State Printer. Completed 4
evaluating and tracking condition of separate MAP/GIS Layers, 1 in progress. Motor Carrier resources
pipes, culverts and storm water have not been available. Dennis will meet with Mike Bollinger to
facilities determine direction.
Truck Route Permit Mapping and GIS29 11/1/03 3/4/04 Phase 3 - On Hold - Motor Carrier is starting to maintain & update
Database database. Route maps ready for State Printer. Completed 4
Phase 3 - Outline processes for separate MAP/GIS Layers, 1 in progress. Motor Carrier resources
maintenance by data steward (MC) have not been available. Dennis will meet with Mike Bollinger to
determine direction.
Region 1 Development Review
TRAINING RECEIVED: SQL training 3/8/01 State Web dev Cert (HTML focus) fall/02
GeoMedia Intro Class 6/5/01 Sequal Server 2000 fall/02
GIS in Action ArcGIS 8 for Enviro Appl fall/02
GIS-T 2001 Map Objects Basics0online fall/02
GeoMedia Pro 7/12/01-7/13/01-10/16/01-10/17/01-10/18/01 MSTN V8 for Admin/User update 10/02
ArcIMS 6/28/01-6/29/01 Java Scripting 11/02
TransGIS version 2 training Visual Basic-(Phil & Chad N)GIS Unit 12/02
Advanced Access 10/23/01-10/24/01 HTML basics-Sue/GIS Unit 1/03
SQL training 9/1/02 Excel XP - Sue/GIS Unit (1/03)
TransGIS version 2 training 1/02 Cold Fusion - Lisa, Phil, Casey 4/03
GIS in Action, addressing conf. 08/02 ArcGIS - Casey, Phil, Lisa 4/03
XML Fundamentals fall/02 Java Script - Lisa 4/03
MicroStation V8 - GIS Unit 1/04 Remote Control/Field Tach GIS course (8 GIS members) 5/03
Java - Chad N, Phil S 1/04 Requirements Mgmt - Sue 6/03
GIS in Action workshps and seminars-GIS Unit 5/04
MS access, advanced & Excel, advanced- Lisa L. 4/04
ArcGIS 9.0, I and II, (GISU), Kim Taylor (GeoEnviro), Charlotte
Gerkin (TSM), Chris Shearer and Diana Mann (RICS) 9/04
Java 1 Chad Nielsen (GISU)10/04
GPS Data Collection, Chad Nielsen, Casy Ragain (GISU),
Marcia Malstrom (IS), Jim Gavin (RICS), 9/04
GIS-T Lincoln Nebraska - Susan Mead (GIS), 04/05
TRAINING DELIVERED: ArcView - Region 1 staff 10/03
ArcView and ArcExplorer - Bridge Mgmt Crash Coding - CAR staff 10/03
ArcView - Darla Stoneman / Acces Mgmt GIS Brownbags 11/03
ArcExplorer - TSM ArcView-General Support to Region 1 (Lisa) 6/04
First Round - TransGIS users 15 users in queue
GIS Tools-R1 6/02
ArcView-Darla Stoneman/Access Mgmt 6/02
TransGIS-initial users/R5 5/02
ArcExplorer - CAR 11/02
ONHP/ArcExplorer-Env at CCC and R3 10/02
GIS Tools R3 11/02
ArcExplorer-Access Mgmt (CHAMPS) 12/02
ArcExplorer - Motor Carrier 4/03
Resource Map Template production - Env. 4/03
Crash Viewer - Region 1- 5/03
ArcExplorer - 10 Approach Perm Spec 7/03
ArcExplorer - TSM staff 8/03 - IS staff 8/03
DEMONSTRATIONS: TransGIS demo for Traffic Recorder Techs 1/03
ArcExplorer to GIS Steering Committee 3/22/01 SR-SAM to GIS Steering Committee (1/03)
ArcExplorer to OTMS Steering Committee 6/28/01 Functional Classification - TDS expanded staff 4/03
Aggregate Demo GeoConnent/MetaWeb - GIS Steering Comm. 5/03
ESRI demo ArcGIS template - GIS Steering Comm. 5/03
Collision Diagram demo to Region Traffic Managers 6/02 TransGIS Web dev - TDS staff 6/03
OTMS - TransGIS & DMV demo 9/25/01 ArcGIS 8.x template - TDS staff 6/03
DMV demo to IS quarterly mgmt team 10/19/01 TransGIS Web PP - Region1 Planners 6/03
DMV & Trans GIS demo to GIS Steering Comm. 10/25/01 TransGIS Web - OTMS SC - OTMS Exec SC - Trans. COI 6/03
GIS Tools - ODOT Directors office 09-02 TransGIS Web - GIS Steering Committee 7/03
Rural Lands database project to GeoHydro 10/02 TransGIS Web - TDS Expanded Staff 8/03
VBCrash to IT Exec Steering Comm and R2 10/02 TransGIS PP - PBLT 8/03
TransGIS demo for Eugene Public Worls 11/02 TransGIS PP - Highway Division staff 12/03
TransGIS demo for Eugene Public Worls 11/02 TransGIS - Chief of staff Lori Sundstrom 12/03
DMV App. & TransGIS - R2 Management 10/02 TransGIS - TPAU 12/03
DMV App. & TransGIS - R2 Design Team 11/02 TransGIS - Traffic Count Field Techs 1/04
DMV App. & TransGIS - HR expanded staff 11/02 Traffic Count GIS and Metro relationship 2/04
FC database demo-GIS Steering Comm 12/02 TransGIS - Planning Business Line Team 4/04
TransGIS - Parametrix 4/04
Network Software - GIS Steering Committee 5/04
GPS-ArcView Script for Data collect Team 7/04
TransGIS - OBDT 6/04
TransGIS - Region 1 Project Delivery 6/04
Network Software - TPAU 6/04
TransGIS - Region 1 Traffic Mgmt 8/04
TransGIS - Region 1 Tech Center Managers 9/04
TransGIS - Region 4 Traffic Managers 9/04
TransGIS - DMV 10/04
TransGIS & Env TransGIS - OTMS Steering Comm 12/04
GIS File Storage System - GeoEnv Steering Comm 12/04
DMV App. & TransGIS - HR expanded staff 11/02
FC database demo-GIS Steering Comm 12/02
TransGIS demo for Traffic Recorder Techs 1/03
SR-SAM to GIS Steering Committee (1/03)
Functional Classification - TDS expanded staff 4/03
GeoConnent/MetaWeb - GIS Steering Comm. 5/03
ArcGIS template - GIS Steering Comm. 5/03
TransGIS Web dev - TDS staff 6/03
ArcGIS 8.x template - TDS staff 6/03
TransGIS Web PP - Region1 Planners 6/03
TransGIS Web - OTMS SC - OTMS Exec SC - Trans. COI 6/03