Docstoc

Project Report on Sql Injection

Document Sample
Project Report on Sql Injection Powered By Docstoc
					                                                                                                         GIS Monthly Project Status Report
                                                                                                                        September 2006
                                                                       Project Status




                                                                                                                                                      Projected
Status***




                                                                                               August




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


A Phase 5 - Region 3                                                GIS04        G      G      G        05/01/03      06/30/04          6/30/2006       G         7/05: SQL db containing RES data being archived in preparation for loading new
   - Deliver final version RES & RAZ maps                                                                                                01/31/07                 data. 9/08/05: Meeting in Roseburg in the month of September. 11/10: Meeting
  to Maintenance and other staff                                                                                                                                  complete 1/12: Planning steps for phase 5 underway. 3/9: RES Map production in
                                                                                                                                                                  progress. 5/11: Price Agreement (PA) Contractor now assisting with production
                                                                                                                                                                  tasks. 7/13/06: RES Map production compete. Region requests postponing
                                                                                                                                                                  workshops until fall due to summer workload. 9/14/06: R3 Workshops scheduled
                                                                                                                                                                  for October & November.

A Phase 4 - OR-Trans                                                GIS19        Y      Y      Y        06/30/04      06/30/05         12/31/2008       Y         7/13: 34 of 36 county datasets for geometry of linework have been loaded, 26 of
   - Load data developed in Phase 3                                                                                                      3/31/06                  36 have data attributes loaded. Nine of those 10 datasets we we're waiting on
   - SQL database                                                                                                                       06/30/06                  from GeoSolve. GeoSolve had new direction from OEM and DAS and these
  - Complete coordination of "edge                                                                                                      12/31/06                  dataset will not be complete until starting late Summer 2006 through January
  matching" of road segments between road                                                                                                                         2007. We will go ahead and load the attribution that was developed through OR-
  authorities.                                                                                                                                                    Trans and OGIC and wait for the addressing from GeoSolve as we get those
                                                                                                                                                                  updates. 9/14/06: All 36 county datasets have been loaded. Forest Service,
                                                                                                                                                                  State and regional govt datasets have been loaded. Segment description
                                                                                                                                                                  loading is in progress and approximately half completed.


A            Phase 5 - OR-Trans                                     GIS19        G      G      G                      06/30/05          12/31/08        G         9/14/06: County updates are being incorporated as feasible into the
             - State wide addressing                                                                                                                              database. The 3rd Task Order is half complete for adding county road
             - Pilot project; county road numbering/mp                                                                                                            number and milepoints data to existing county linework where needed. OEM
            data                                                                                                                                                  is actively working on Klamath, Douglas and Morrow addressing and has 6
             - QA/QC of data and coordinate                                                                                                                       more on schedule to complete by mid 2007. The addressing from this effort
            correction w/ road authorities                                                                                                                        will be incorporated into OR-Trans.
             - Complete any Ph. 3 missing statewide

A Phase 6 - OR-Trans/Pooled Fund                                    GIS19        G      G      G                      06/30/05          12/31/08        G         7/13: Puget Sound Pilot is complete, implementation of FME software will occur in
  Project                                                                                                                                                         July 2006 and testing phase with county datasets from Oregon and Washington
   - Design and construct Web based check-                                                                                                                        that abut each other will occur during the remainder of 2006. 9/14/06:
  in and                                                                                                                                                          Organization is underway for the Bi-State pilot project for the Pooled Fund
   - check-out system                                                                                                                                             Project. Morrow and Umatilla County in Oregon and Benton, Franklin and
                                                                                                                                                                  Walla Walla Counties in Washington. This testing area will identify issues
                                                                                                                                                                  around integrating data across county and state boundaries into a central
                                                                                                                                                                  database. Methods from the Puget Sound Pilot will be used on this pilot as a
                                                                                                                                                                  means to improve ways to integrate data for the Pooled Fund Project.


H EnviroView - Environmental Data                                   GIS31        Y      Y      Y        Ongoing       Ongoing                           Y         Phase 2 - 7/13: Input gathered from EDMS review at CETAS, NEPA and Planning
  Management System                                                                                                                                               Workshop, FHWA coordination and TRB Environmental Analysis Committee.7/13:
  (formerly SR-SAM)                                                                                                                                               Input gathered from EDMS review at CETAS, NEPA and Planning Workshop,
  Phase 2 - Field data collection and                                                                                                                             FHWA coordination and TRB Environmental Analysis Committee. 9/14/06: Project
  management                                                                                                                                                      plan development and budget work in progress.




               D:\Docstoc\Working\pdf\fa17b890-72e6-4de8-b575-a72d788ada1a.xls                                                     1                                                                                        7:15 PM   7/15/2011
                                                                                                      GIS Monthly Project Status Report
                                                                                                                     September 2006
                                                                    Project Status




                                                                                                                                                   Projected
Status***




                                                                                            August




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


H Traffic Counting GIS Implementation                                         Y      Y      Y        12/01/04      02/28/05          6/1/20/05       Y         5/11: Determination was made to use ITS Asset Inventory software. This software
  Phase 5                                                                                                                             8/15/05                  will also be used to track signals. A future project will be to develop a GIS
   - Create data entry system for traffic data                                                                                                                 interface. This project will be closed until that request is made. 7/13: Maintenance
   - Create database tables, site inspection,                                                                                                                  Work: Data Entry Interfaces have been updated to connect to new database
  vendor info.                                                                                                                                                 format. Traffic Volume Report is functional. Data entry in progress. Resources
   - Equipment Inventory Detail                                                                                                                                intermittent due to TSM staff change and the number of projects in process
   - Create data entry interface(s) for equip                                                                                                                  through the GIS Unit. 9/14/06: Looking at ITS Software for tracking Traffic
  inventory                                                                                                                                                    Counting Assets. May not need this project.
   - Provide imagery linking & view options



A DMV Oregon Automobile Dealers                                  GIS41        Y      Y      Y        07/11/05      08/01/05          9/30/2005       Y         7/13: GIS Unit provided additional fields to be included in the DMV database to
                                                                                                                                      12/31/05                 allow for site location accuracy improvements and location tracking.
                                                                                                                                      2/01/06                  Recommendation will be based on GIS/ODOT 'spatial location' data standards.
                                                                                                                                      04/01/06                 DMV database architect has identified time to process the request. Once added,
                                                                                                                                      06/30/06                 GIS Unit will re-geocode every location. The review process will then
                                                                                                                                      08/01/06                 proceed.9/14/06: DMV utilized 'Code 1' address cleaning software to improve
                                                                                                                                      10/15/06                 location information. Duplicate data was discovered and removed. DMV is
                                                                                                                                                               matching previously geocoded 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.


P TOC GIS Interface                                              GIS42        Y      Y      Y        05/01/06      05/01/07                          Y
  Phase 2
   - Implementation of viewing tool
  - Provide GIS expertise to the project
H Traffic Mobility Management System                             GIS39        G      G      G        03/01/06                                        G         09/14/06   Placed on Hold by Motor Carrier Staff
  Phase 2
    • Develop data models and business
  processes based on recommendations
  and findings from Phase 1.
    • Create/capture and catalogue data (or
  secure access to data) that will be used
  and maintained for managing traffic
  mobility.
    • Develop applications that assist in
  managing traffic and freight mobility.
    • Prototype applications, data and
  business processes.




            D:\Docstoc\Working\pdf\fa17b890-72e6-4de8-b575-a72d788ada1a.xls                                                     2                                                                                          7:15 PM   7/15/2011
                                                                                                      GIS Monthly Project Status Report
                                                                                                                     September 2006
                                                                    Project Status




                                                                                                                                                   Projected
Status***




                                                                                            August




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


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

A GIS Layers In Progress                                         GIS21        G      G      G        Ongoing       Ongoing                           G         Exits and Interchanges 2006 (Sm)
   Projects categorized as:                                                                                                                                    Oregon Auto Dealers 2006 (Sm)
   OEM or Sm                                                                                                                                                   NHS 2006 (OEM)
    Assign sub-numbers (Sm)                                                                                                                                    Routes Cross Ref 2006 (OEM)
                                                                                                                                                               Medians 2006 (OEM)
                                                                                                                                                               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)




            D:\Docstoc\Working\pdf\fa17b890-72e6-4de8-b575-a72d788ada1a.xls                                                     3                                                                                       7:15 PM   7/15/2011
                                                                                                      GIS Monthly Project Status Report
                                                                                                                     September 2006
                                                                    Project Status




                                                                                                                                                   Projected
Status***




                                                                                            August




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


C GIS Layers Completed                                           GIS21        C      C      C                                                        C         Interchange Aerials (historic) (OEM) (02/06)
                                                                                                                                                               NAIP_CCM_05 (Natl Agric Imgry Prog) (OEM) (02/06)
                                                                                                                                                               STIP 06-09 All segs development (Sm) (02/06)
                                                                                                                                                               Hwy Tenths (OEM) (04/06)
                                                                                                                                                               Highway Network - 2006 Annual (OEM) (05/06)
                                                                                                                                                               Maintenance Units 2005 (OEM) (06/06)
                                                                                                                                                               ODOT Aggregate Summer 2006 (OEM) (06/06)
                                                                                                                                                               Conservation Opportunity Areas - 2005 (OEM) (07/06)
                                                                                                                                                               FIPS / GNIS Code Lookup (OEM) (07/06)
                                                                                                                                                               Hydrography sub-basin lookup (OEM) (07/06)
                                                                                                                                                               NHD (National Hydro Dataset) (OEM) (07/06)
                                                                                                                                                               NHD Areas (OEM) (07/06)
                                                                                                                                                               NHD Waterbodies (OEM) (07/06)
                                                                                                                                                               Functional Classification for non-state roads (OEM) (07/06)
                                                                                                                                                               SPIS 2002-04 (OEM) (07/06)
                                                                                                                                                               SPIS 2003-05 (OEM) (07/06)
                                                                                                                                                               MPO 2003 draft (OEM) (07/06)
                                                                                                                                                               City CAD files - V8 (OEM) (08/06)
                                                                                                                                                               County CAD files - V8 (OEM) (08/06)
                                                                                                                                                               Citylimit 2006 Annual (OEM) (08/06)
                                                                                                                                                               Crashes 2005 (OEM) (08/06)
                                                                                                                                                               Soil Survey Index for GIS application (OEM) (08/06)
                                                                                                                                                               SIP segs (crash segs)2003-05 (OEM) (09/06)
                                                                                                                                                               Scenic Byways (Sm) (09/06)
                                                                                                                                                               OR Geologic Data Compilation V2 (OGDC) (OEM) (09/06)

A GIS Infrastructure Support (cont.)                           GIS11-01       G      G      G        Ongoing       Ongoing                           G         TRAINING RECEIVED:
  Training                                                                                                                                                             Arc GIS Tools and Techniques (Mike. Chad C.)
                                                                                                                                                                       Spatial analysis of Geohazards using ArcGIS 9 (Philip Smith) (7/3)
                                                                                                                                                                       NIMS (Smith, Gowen, Mead, Ringeisen, Brady, Scofield, Hill,
                                                                                                                                                                       Johnson, Crockett)
                                                                                                                                                                       Building Geo-databases 1 and 3 (Jenkins and Malstrom) (7/06)
                                                                                                                                                               TRAINING DELIVERED:

                                                                                                                                                               TRAINING RECEIVED:
                                                                                                                                                                       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)




            D:\Docstoc\Working\pdf\fa17b890-72e6-4de8-b575-a72d788ada1a.xls                                                     4                                                                                       7:15 PM   7/15/2011
                                                                                                      GIS Monthly Project Status Report
                                                                                                                     September 2006
                                                                    Project Status




                                                                                                                                                   Projected
Status***




                                                                                            August




                                                                                                                                                    Status**
                                                                              June
                                                                                     July
                                                                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        Ongoing       Ongoing                           G         DEMONSTRATIONS:
  Demonstrations
  (6 month drop-off cycle)
  Target:
    OTC
    Doug Tindall, Hwy Div Manager
    Additional PBLT groups
    Area Managers
    Project Manager


A GIS Infrastructure Support (Cont)                            GIS11-03       G      G      G        Ongoing       Ongoing                           G         DAILY CUSTOMER SUPPORT:
  Customer Support                                                                                                                                                    129 hours (01/06)
                                                                                                                                                                      142 hours (04/06)
                                                                                                                                                                      25 (05/06)
                                                                                                                                                                      30 (06/06)
                                                                                                                                                                      70 (07/06)
                                                                                                                                                                      86 (08/06)

A GIS Infrastructure Support (cont.)                           GIS11-04       G      G      G        Ongoing       Ongoing                           G         METADATA:
  Metadata                                                                                                                                                     Hwynet Annual May 2006 (09/06) (provided to Clearinghouse)
                                                                                                                                                               City limit Annual Aug 2006 (09/06) (provided to Clearinghouse)
                                                                                                                                                               Oregon Geologic Data Compilation V2 (OGDC) (09/06 - format/import)

A GIS Infrastructure Support (Cont)                            GIS11-05       G      G      G        Ongoing       Ongoing                           G
  Standards
  GIS11-05-01 Resource Grade GPS
  Standards


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




            D:\Docstoc\Working\pdf\fa17b890-72e6-4de8-b575-a72d788ada1a.xls                                                     5                                                                                  7:15 PM   7/15/2011
                                                                                                      GIS Monthly Project Status Report
                                                                                                                     September 2006
                                                                    Project Status




                                                                                                                                                   Projected
Status***




                                                                                            August




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


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

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

A GIS Infrastructure Support                                   GIS11-09       G      G      G        6/1/2006     8/15/2006                           g        7/13: Spatial Reference: Review Spatial Reference set-ups and decisions with
  SDE Implementation                                                                                                                                           Business Partners and other agencies. Review extents vs. precision to determine
  Spatial Reference                                                                                                                                            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.

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


A OEM & Small Projects (Cont)                                  GIS23-03       G      G      G        Ongoing       Ongoing           9/1/2006        G         3/9: Data provided by customer had to be re-extracted several times. Questions
  Access Management GIS Implementation                                                                                               11/15/06                  remain about certain records. 5/11: Training provided to customer. GIS Unit has
                                                                                                                                                               produced DRAFT dataset. 7/13: Coordinate fields added to CHAMPS database to
                                                                                                                                                               allow for more accurate locational methods. No resources available at this time.
                                                                                                                                                               9/14/06: No resources available at this time.




            D:\Docstoc\Working\pdf\fa17b890-72e6-4de8-b575-a72d788ada1a.xls                                                     6                                                                                         7:15 PM   7/15/2011
                                                                                                      GIS Monthly Project Status Report
                                                                                                                     September 2006
                                                                    Project Status




                                                                                                                                                   Projected
Status***




                                                                                            August




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


A OEM & Small Projects (Cont)                                  GIS23-04       G      G      G        1/11/2006    3/15/2006         12/31/2006       G         3/9: Existing highway system count database rewritten to accommodate multiple
  Traffic Counting Field Data Collection                                                                                             06/1/2006                 counts/history and incorporation of non-system data. Non-highway count system
                                                                                                                                     07/15/06                  was reformatted and incorporated into the existing highway system database.
                                                                                                                                     Pending                   Software application rewritten based on Fall 2005 review by customer. First dry-
                                                                                                                                    Application                run of system revealed that to use the new features - additional scripting and
                                                                                                                                    Migration to               'Routing' scheme must be added to the application. Training proposed for
                                                                                                                                      another                  03/14/06. 5/11: Terry Trussel has received training. 7/13: Customers have
                                                                                                                                     platform.                 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.


A OEM & Small Projects (Cont)                                  GIS23-05       G      G      G        2/6/2006      03/05/06         12/31/2006       G         5/11: Additional projects have been added to database by customer. Database
  Connect Oregon                                                                                                   Phase 1            07/1/06                  and mapping work continues. 7/13: Database and ArcReader products complete.
                                                                                                                                     11/01/06                  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.


H OEM & Small Projects (Cont)                                  GIS23-09       G      G      G        6/9/2006     10/1/2006          01/01/07        G         7/13: GIS Team is awaiting data and value or rating system. 9/14/06: GIS Unit
  Asset Management Safety Rating Pilot                                                                                                                         working with sponsor to convey data and GIS standards, identify various
                                                                                                                                                               resources, review ongoing tests and define data responsibility.


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

C OEM & Small Projects (Cont)                                  GIS23-16       C      C      C        4/12/2006    6/15/2006                          C         7/13: GIS Unit worked with ODOT Customer Support to develop
  REMEDY customer support development                                                                                                                          Category/Item/Type tracking scheme, initiate software installation and subsequent
  and implementation                                                                                                                                           training. GIS Customer Support Team has received training and tracking support
                                                                                                                                                               tasks in Help Desk standard software/database. Standard reports will be
                                                                                                                                                               developed as needed. Completed 06/26/06.
C OEM & Small Projects (Cont)                                  GIS23-18       C      C      C        5/15/2006     6/1/2006                          C         7/13: GIS Unit worked with ODOT Bridge Unit to identify analysis requirements.
  Bridge data enhancement for                                                                                                                                  GIS Unit utilized GIS tools to provide an enhanced dataset containing
  boundary/permitting review efficiency                                                                                                                        approximately 10 boundary layers worth of data. Completed 06/01/2006.
C OEM & Small Projects (Cont)                                  GIS23-19       C      C      C        5/18/2006    unknown            08/15/06        C         7/13: GIS Unit processed GPS data from 'conditions report' data collection effort,
  GPS Access Management Demonstration                                                                                                                          identifying all access points on selected highways. GPS mapping compared to
  Project                                                                                                                                                      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 .
C OEM & Small Projects (Cont)                                  GIS23-20       C      C      C        6/7/2006     6/20/2006                          C         7/13: GIS Unit worked with Russ Frost to identify analysis and map requirements.
  Federal Material Sources and Land Use                                                                                                                        Requirements changed once during the project. Completed 06/26/06.
  Zoning



            D:\Docstoc\Working\pdf\fa17b890-72e6-4de8-b575-a72d788ada1a.xls                                                     7                                                                                         7:15 PM   7/15/2011
                                                                                                        GIS Monthly Project Status Report
                                                                                                                       September 2006
                                                                      Project Status




                                                                                                                                                     Projected
Status***




                                                                                              August




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


H OEM & Small Projects (Cont)                                    GIS23-07       Y      Y      Y        Ongoing       Ongoing                           Y         3/9: Met with ODOT Maintenance and Water Resource Department (WRD) to
  Water Withdrawal Permitting                                                                                                                                    assess requirements. WRD will accept GIS data as "map" for permit requirement.
                                                                                                                                                                 5/11: GIS data for permit request has been produced, reviewed by Maintenance
                                                                                                                                                                 and delivered to Maintenance. Project will see no activity until WRD returns results
                                                                                                                                                                 of submission.

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



                                                                                                                                                                 E=Evaluate
                                                                                                                                                                 P=Purchase
                                                                                                                                                                 I=Implement

                                                                      *                 On Schedule
            *** Status                                                *                 Requires Attention                                                       OEM = Operations & Essential Maint.
            A=Active                                                  *                 Requires Corrective Action
            C=Complete                                                *                 Project complete or not started                                          *Small Projects
            H=On Hold                                                                                                                                            A*=Application
            P=Planned                                          ** Forecast of project status for next month                                                      D*=Data Development




              D:\Docstoc\Working\pdf\fa17b890-72e6-4de8-b575-a72d788ada1a.xls                                                     8                                                                                          7:15 PM   7/15/2011
                                                                COMPLETED PROJECTS

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



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




   Revised 10/12/00
                                                         COMPLETED PROJECTS

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



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


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

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




   Revised 10/12/00
                                                       COMPLETED PROJECTS

DGIS09 Automated Collision Diagram                         3/1/03    4/01/03   Documentation nearly complete. Purchasing visio software. NPE review
       - Phase 3                                                     5/22/03   underway. Deploy 2 copies to each region HQ traffic management staff.
         - Implementation                                                      Visio software delivered, Documentation complete, demo to OTMS
                                                                               Steering Committee 3/27/03. Distribution in process. Complete

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

DGIS11 DMV Project                                         8/1/01    10/1/01   Chuck met with DMV on July 18th to determine needs. Working on
                                                                               language breakdown. (I.e. Asian). System delivered to DMV. In warranty
                                                                               mode. Complete 9/18/01 (80 hour project).
DGIS15 Access Control Demonstration                       10/31/02   2/28/03   Resource materials have been acquired and sample sites chosen (The
       - Incorporate resources                                                 Dalles). Resources have been formatted into standard/uniform projection.
       - Changes to CHAMPS database and hyperlink to                           Project on hold, resources dedicated to GIS19. Project reactivated
       GIS tools                                                               11/10/02. Right-of-Way images acquired. Adobe Photoshop software on
       - Database development for ROW research                                 order to complete processing. Pilot covered State Highways in 1 city.
                                                                               Pilot demo Complete .

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

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

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




  Revised 10/12/00
                                                         COMPLETED PROJECTS

GIS07   Non-State Hwy Functional Classification System       6/1/00     12/1/01    35,000 miles of road. 11/30/00 Attribution complete. Error checking in
        Attribution                                                                progress. Successfully developed and tested the new MGE project and
                                                                                   access database. Complete 10/19/01.

GIS13   State Highway 1:24,000 road alignments               6/30/01    7/31/01    Plus or Minus 40' of state highways. Complete August 2001.
GIS14   GIS Base Layers Phase 2                              1/24/01    3/1/3102   (Dependant on the completion of GIS 17) Add new layers to GIS SQL
        - Select 6 new base layers                                                 database 6 at a time. Database modeling and data acquisition is under
          1-Pavement Conditions 1999                                               way. Layers changed to meet the needs of the Conditions Report and
          2-ITS                                                                    TransGIS version 2. Received 2001 Pavement Conditions data.
          3-Bridge                                                                 Congestion data has been reviewed and released in TransGIS 2.1.
          4-Intermodal (FIMS)                                                      Congestion data is being viewed again. Re-visit corporate GIS base
          5-Crash                                                                  layers and bring back to Dec. 5th meeting. Project reassigned to GIS21.
          6-Non State Highway Functional Class                                     Descriptions and guidelines rewritten. Complete
          7-Federal Urban Trans Boundary
        Cust.: All GIS users
GIS15   Non-State Hwy Functional Classification and          1/9/01     5/31/02    Project Statement (002,026,028), Context of the System (140), Definition
        National Highway System to SQL                                             of the System/Subsystems (200/210), in draft form awaiting approval.
                                                                                   Began work on possible data model. Project Plan approved. Two
                                                                                   prototype databases created on SQL server 7.0 for evaluation purposes
                                                                                   on 8/31/01. Testing prototype SQL server database (HGIS15a) using
                                                                                   COTS (commercial off the shelf) software. Querying, reporting and
                                                                                   updating capabilities are being tested using GeoMedia Pro, Access and
                                                                                   SQL Server utilities. Database model has been updated, preparing
                                                                                   documentation (P Plus Deliverables 170, 180 and 190). Testing and
                                                                                   migration complete. Complete


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

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




  Revised 10/12/00
                                                       COMPLETED PROJECTS

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




  Revised 10/12/00
                                                        COMPLETED PROJECTS

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

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




  Revised 10/12/00
                                                          COMPLETED PROJECTS

GIS24   Tsunami Inundation Mapping Analysis                  3/5/2003    4/4/03    Mapping project for statewide Tsunami exercise is complete. Maps show
                                                                                   inundation line intersecting state highways, and lifeline routes. Being
                                                                                   tested in statewide earthquake drill April 2nd and 3rd. Complete

GIS26   On-Line Contractor Emergency Registry System         12/15/02   4/01/03    Project development nearly complete. Mixture of techniques used to
        - Build GIS interface to IS Web developed site                   5/1/03    accomplish project. Internet use not yet approved. Draft model presented
                                                                                   to ODOT end-users 3/20 by the IS team (Diane Powers). Waiting for XML
                                                                                   templates from IS Development Team. Network testing underway.
                                                                                   Application and data complete and provided to customer. P+
                                                                                   documentation in draft stage. Complete
        ArcView Lat/Long coordinates                         08/01/00   9/15/00    Display Lat/Long coordinates and LRS in ArcView. The application is out
                                                                                   for peer review. Ready to send through product approval and Intranet roll-
                                                                                   out. Going through NPE. (Complete)
        Arc View Display of DGN Files                        09/01/00   09/15/00   Application complete. Ready to send through product approval and
                                                                                   Intranet roll-out. (Complete)

        ArcView Location Reference System (LRS)              08/01/00   09/15/00   Application complete. Ready to send through product approval and
        Highway Milepoint Readout                                                  Intranet roll-out. Going through NPE. (Complete)

        GPS Standards                                        05/01/00   05/01/00   Document approved on April 20, 2000. Distribution is being planned

        Rail Network                                         08/01/00   03/15/00   Revisions made, forwarded to State Forestry for review. Complete and
                                                                                   delivered to State Service Center and GIS User Group.
        Rail Crossing                                        03/15/00   05/31/00   User has accepted the ArcView Extension (application) software and
                                                                                   installation instructions. Network testing of extension is complete.
                                                                                   Extension given to user.
        Federal benchmark layer (NGS) (Complete)             07/15/00              Create National Geodetic Survey benchmark layer for Geometronics in
                                                                                   ArcView & MGE software. (Complete)
        Desktop GIS - STIP/SIP (DGIS03a)                     06/16/00   10/15/00   Software purchase complete, documentation under development. Roll-
                                                                                   out scheduled to start the week of August 28th. Close after testing
                                                                                   complete 10/10/00.
        Joint Estimation Model Data Development              05/15/00   09/30/00   Quality check household activity locations from travel survey buffer points
        (Medford)                                                                  to create environmental design variables.
        ODOT Injection Wells Inventory (Phase 1)             6/22/00    09/01/00   Building base layer of ODOT maintenance facilities (103) to satisfy
        (Complete)                                                                 Oregon's DEQ water permit requirements. (Complete)
        Statewide Model Application Project (Willamette       6/1/00    12/1/00    Produce presentation of output from first generation statewide model.
        Valley)                                                                    Completed 11/1/00. Project Lead was Brian Gregor.
        Non-MPO Travel Model Data Support (Lebanon)           3/1/00    11/30/00   Base year employment & housing distributions and network
                                                                                   characteristics. Completed 6/1/00. Project Lead was Sam Ayash.




  Revised 10/12/00
                                              COMPLETED PROJECTS

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

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

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

     Urban Transportation Model Development      3/13/02    5/30/02    Scheduling with COG for update of existing model. Consultant compiling
     - Roseburg                                                        existing data. ODOT is collecting and reviewing traffic count data.
                                                                       Updating population and housing data for consultant. Complete 11/02

     Urban Transportation Model Development       5/1/02               Reviewing consultant data. Complete
     - Wilsonville
     Urban Transportation Model Development       6/1/02    12/31/02   Providing preliminary TAZ, model road network, employment and housing
     - Newberg                                                         data to City for review. Incorporating city housing and employment
                                                                       revisions and forecast data. Need City of Dundee to validate
                                                                       employment, household and forecast data. Complete
     Urban Transportation Model Development      12/31/02              Zone and network development in progress. Zones and network have
     - Redmond                                                         been restructured. City has validated employment and household data.
                                                                       Waiting for city to provide forecast data. Forecast data under
                                                                       development. Complete
     Urban Transportation Model Development       7/1/02     7/1/03    Zone and network development in progress. Zones and network have
     - Brookings                                                       been restructured. City has validated employment and household data.
                                                                       Waiting for city to provide forecast data. Forecast data under
                                                                       development. Complete
     Urban Transportation Model Development       5/1/03     7/1/03    Complete
     - Central Oregon




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




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


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




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

				
DOCUMENT INFO
Description: Project Report on Sql Injection document sample