Customer Inventory Agreement - Excel

Document Sample
Customer Inventory Agreement - Excel Powered By Docstoc
					                                                                                Roadside Features Inventory Systems Analysis

                                                                                                                                                                                                                                                                               Data Dictionary
                                                                                                                                                                                                                                                                               Data Model
                                                                  System ID

                                                                                                 Customer         Support
        Project Name             Business Name                                 Sponsor Org        Contact         Contact           Server          Database/Data Layer                                 Description
                                                                                                                                                                          The Washington State Bridge Inventory System (WSBIS) is an
                                                                                                                                                                          integrated, bridge inventory system designed to be used throughout
                                                                                                                                                                          WSDOT. The system is designed to be easy to use and has
                                                                                                                                                                          comprehensive help and prompt functions. The WSBIS system
                              Washington State Bridge                                                                                                                     allows the bridge inventory records for every structure in the state to
Bridge Preservation Office    Inventory System        WSBIS IB                Bridge Office   Steven Rochelle Dick Schmidt DOTDBOLYHQ01T BridgeInventory                  be stored in a single client/server database                              SQL                        X
                              Signals Inventory
Signals Inventory Maintenance Maintenance                                     Northwest       Pat Carboneau/                                                              used to track Signal Shop inventory and tracks work by done by shop
Management                    Management              SIMMS                   Region          Bryan Bailey   Ken Storkle       DOTDBOLYHQ02P NWD_SIMMS                    technicians, it is a statewide system                                   SQL                          X
                                                                                                                                                                          Traffic Signs Management System inventories all of the signs
                                                                                                                                                                          installed by the Department of Transportation, Traffic Office, on
                                                                                                                                                                          various state and inter state routes across the state. In addition, the
                                                                                                                                                                          system keeps track of all of the maintenance actions for each sign.
                                                                                                                                                                          Traffic Signs Management System has four basic functions. System
                                                                                              Rick Mowlds        Larry                                                    Administration, Sign Management Utilities, Reporting / Querying and
Statewide Signs              Traffic Sign Management TSM         FD           Signs           360-705-6891       Gruginski     DOTDBOLYHQ01P Ctrl_SMS                     State Route Information maintenance.                                    SQL           7/1/1999 X

                                                                                                                                                                          The business function of the StormWater inventory database, is to
                                                                                                                                                                          meet the federal, state, and local regulations relating to controlling
                                                                                                                                                                          contaminated stormwater runoff and reducing peak storm water
                                                                                                                                                                          flows for the WSDOT Environmental Affairs Office. The system is
                                                                                                                                                                          maintained through Shared Application Maintenance (SHAMU)
                                                                                                                                                                          team. The StormWater DB is a management decision making tool
                                                                                                                                                                          in support of transportation planning and program management
                                                                                                                                                                          activities for the Design Office and EAO services. The primary
                                                                                                                                                                          objectives of the database is the inventory and data collection of
                                                                                                                                                                          Storm Water Outfall to support outfall data for public roads
                                                                                                                                                                          maintained by WSDOT in its data collection, validation, and system
Stormwater Facilities and                                                                     Elizabeth Lanzer                                                            maintenance The state has 3,500 outfalls locations that have been
Outfalls                     Stormwater Database                 GS           Environmental   360-705-7476                     DOTDBOLYHQ02P StormWaterApp2_4             assigned a priority ranking for the implementation of inventory.          SQL         7/1/1999 X
                                                                                                                               DOTDBOLYHQ02P StormWaterD2_4                                                                                                              X
                                                                              Northwest       Dave
NWR- Roadside Inventory                                                       Region          McCormick                        DOTDBOLYHQ01T NWHighwayInventory                                                                                                                X

Pavement Management                                                                           , NADARA
System                                                                        Materials Lab   360-709-5475                                                                                                                                                                     X X
                                                                                                                                                                          The WSDOT Traffic and Weather project collects and disseminates
                                                                                                                                                                          real-time and predictive statewide road and weather information. The
                                                                                                                                                                          program gathers data from a variety of sources and provides
                                                                                                                                                                          statewide weather and road-condition reports and forecasts. This
                                                                                                                                                                          detailed information helps the state manage and maintain the
Road and Weather Information Road and Weather                                 Communication Laura Merrit,        Ryan Knopp                                               roadways as well as keep the traveling public informed of current and
System                       Information System           FO
                                                    RWeather                  s Office      360-705-7074         360-705-7660 DOTDBOLYHQ03P RoadWeatherInfo               future weather and driving conditions.                                SQL                   1999
NCR- Guardrails and Culverts                                                                Debbi Achord
Database                                                                                    509-633-0629                                                                                                                                            Excel

       1                                                                                                                       11:43 AM 2/14/2011                                                                  edb7287f-737a-4126-a10e-23e8ea60c8c7.xls
                                                                                     Roadside Features Inventory Systems Analysis

                                                                                                                                                                                                                                                                                                    Data Dictionary
                                                                                                                                                                                                                                                                                                    Data Model
                                                                       System ID

                                                                                                       Customer          Support
        Project Name                Business Name                                   Sponsor Org         Contact          Contact           Server             Database/Data Layer                                     Description

                                                                                                    Jody Brown                                                                           UFP is a client/server application written in PowerBuilder with a SQL
                                                                                                    360-705-7318                                                                         Server database. The Utility/Franchise Permits System (UFP) lets
                                                                                                    (retiring May 30)                                                                    you enter, edit and view utilities, franchise, and permit information in
                                                                                                                                                                                         a variety of formats. Anyone authorized to log in to the system can
                                                                                                    Lee Hughes (as                                                                       view and print any information in the database. Some people are
                                                                                                    of 6/1/2005 360- Greg Guinotte                                                       allowed to add and edit data for documents and details only within
UFP Utilities Franchise/Permit Utility Franchise Permits   UFP        HB           Real Estate      705-7318)        360-705-7640 DOTDBOLYHQ02P UtilityPermits                           their own region.                                                        SQL                7/1/2000 X

                                                                                                                                                                                         WSDOT is required to manage all access to state highway system
                                                                                                                                                                                         that are not in a centrally incorporated area. This application will
                               Road Access                                         Maintenance    Darlene Sharar        Greg Guinotte                                                    track and manage permits for road approaches (i.e., access roads,
Road Access Management         Management                             GR           and Operations 360.705.7251          360-705-7640 DOTDBOLYHQ02P RoadAccessManagement                  driveways) that intersect with the state highway system.                 SQL                7/1/2000 X

                                                                                                    Steve Lowell ext
                               Unstable Slopes                                                      5460 Lynn                                                                            USMS allows the entry and storage of slope information, ratings and
Unstable Slopes                Management System           USMS FL                 Materials Lab    Moses ext 5462 Dick Schmidt DOTDBOLYHQ03P UnstableSlopes                             cost estimates. Unstable Slope management strategies                     SQL                7/1/2000 X
                                                                                                                                                                                         Should be posted in May 2005 to the GIS ArcSDE server. We are
                                                                                                                                                                                         working on the metadata now and it will be posted to the GIS
                                                                                                                                                                                         metadata database. This database was developed in the past 6
                                                                                                                                                                                         months by using plan sheets and other records of where noise walls
                                                                                                                                                                                         have been built, locating those walls on the 24kLRS in our GIS
                                                                                                                                                                                         system using air photos and SRView. The purpose of the database
                                                                                                                                                                                         is to have an inventory of constructed walls. The fields contain

                                                                                                                                                                                         information about the nature of the wall (proposed or actually built,
                                                                                                    Elizabeth Lanzer Michelle                                                            materials used, height, length, etc), the highway project that built it,
Noise Walls Inventory          Noise Walls Inventory                               Environmental    360-705-7476     Blake            URSA MAJOR (probably)                              when and for how much $$.                                                                    May-05

                                                                                                                                                                                        FileMaker - 3 related DBs on StarBright called Noise_Priority List ( is
                                                                                                                                                                                       the "master" application,s o I guess that's the system name),
                                                                                                                                                                                       Noise_PriorityList_Data and Noise_Priority_Lookup, "supported" by
                                                                                                                                                                                       George Saunders but I think the last time they worked on them it was
                                                                                                                                                                                       a consultant. Best guess at production date was probably around
                                                                                                                                                                                       1995. This data base is used to estimate costs and benefits for noise

                                                                                                                                                                                                                                                                     Filemaker Pro
                                                                                                                                                                                       mitigation and rank noise wall projects for funding under I-4 -
                                                                                                                                                                                       Environmental Retrofits. Any Data Dictionary would probably be
                                                                                                                     George                                                            wrapped in the Application and be minimal, but I will/have asked the
                                                                                                    Elizabeth Lanzer Saunders 360-                         Noise_PriorityList_Data and users about any other documentation. I am also asking them if this
Noise Walls Inventory          Noise Walls Inventory                               Environmental    360-705-7476     705-7110                              Noise_Priority_Lookup       is still the way they do ranking, or if it is obsolete.
                                                                                                                                                                                       These databases have inventory of roadside areas with potential
                                                                                                                                                                                       biological resources protected under the Endangered Species Act.
                                                                                                                                                                                       Our operating agreement ("permit") with the Federal agencies
                                                                                                                                                                                       enforcing Endangered Species Act (ESA) compliance says that we'll
                                                                                                                                                                                       map roadsides areas that could potentially effect ESA species or
                                                                                                                                                                                       habitats, then our roadside pesticide spraying and other maintenance
                                                                                                                                                                                       activities are modified within those areas to avoid effecting ESA
                               Roadside Special                                    Maintenance                                                                                         resources. In some regions these areas have been marked with
Sensitive Areas                Maintenance Areas                                   and Operations                                                                                      "Fish Sticks".

       2                                                                                                                              11:43 AM 2/14/2011                                                                         edb7287f-737a-4126-a10e-23e8ea60c8c7.xls
                                                                               Roadside Features Inventory Systems Analysis

                                                                                                                                                                                                                                                                                          Data Dictionary
                                                                                                                                                                                                                                                                                          Data Model
                                                                 System ID

                                                                                                Customer         Support
        Project Name          Business Name                                   Sponsor Org        Contact         Contact            Server            Database/Data Layer                                    Description
                                                                                                                                                                                NW Region had these features inventoried using GPS about 4 years
                                                                                                                                                                                ago. The data is in SQL Server with the other features they mapped.
                                                                                                                                                                                In this database the features called "wetlands" are really a pretty
                                                                                            Data Steward :                                                                      good match to what was done in the other regions (next item) and
                          Roadside Special                                   NWR            Art Schaeffer                                                                       called Roadside Special Management Areas. These features are
                          Maintenance Areas                                  Maintenance    and Heather                                                                         also in a GIS dataset (with metatdata) on ArcSDE
Sensitive Areas           (NWR)                                              and Operations Rein                                                                                (roadsidefeatures.DBO.Wetland).
                          Roadside Special
                          Maintenance Areas (All                             HQ                                                                    TransFeatures.BASE.Sensiti
Sensitive Areas           others)                                            Maintenance     Sandy Stephens Tom Clay                               veRoadsideAreas                                                                                       Access /ArcSDE
                                                                                                                                                                                 Survey Monuments tracks the location, status and history of survey
                                                                                                                                                                                monuments for Washington State Highways. The Survey
                                                                                                                                                                                Information System database maintains a set of entities and
                                                                                                                                                                                attributes that refer to individual geographic locations. The relative
                                                                                                                                                                                location of the points as represented in this database correspond to
                                                                                                                                                                                the physical or determined location of Survey Control
Monuments                 Survey Monuments          Survey MM                                                                 DOTDBOLYHQ01P SurveyMonuments                     Monumentation.                                                           SQL               7/1/1999 X

                                                                                                                                                                                The Computer Aided Facility Management system provides data and
                                                                                                                                                                                functionality in support of all facility management functions. The
                                                                                                                                                                                database is divided into modules on Real Property and Lease
                                                                                                                                                                                (inventory), Building Opeations (a.k.a. CMMS - Computerized
                                                                                                                                                                                Maintenance Management System), Space Management, and
                                                                                                                                                                                Strategic Planning. The system provides information on facility
                          Computer Aided Facility                                              Tom Kuchman                                                                      depreciatino, current inventory status, imrpvoements, equipment
                          Management                CAFM                     Facilities Office 360-705-7437     Dick Schmidt DOTDBOLYHQ01P CAFM                                 inventory, maintenance details, and space inventory.               SQL                     2/5/2002 X X

                                                                                                                                                                               My group has been working toward a database but the data are
                                                                                                                                                    \\GINGKO\MISGroup\DMS\I    currently still in a spreadsheet (or more). Albert Perez did some

                                                                                                                                                    RM\Public\Info & Data      process flow and table design work about a year ago, but there was a
                                                                                                                              dotflolyhq07\gis\gise Models\RoadsideFeatures\R  change in leadership, and we, the data people, are somewhat out of
                                                                                                                              ao\projects\Chronic equirements Gathering\Data   the loop. I think the process flow was changed and we haven't been
Chronic Environmental     Chronic Environmental                                              Elizabeth Lanzer                 Defs as a GIS         Analysis\Chronic           asked for any further database work. For now, I am the technical
Deficiencies              Deficiencies                                       Environmental   360-705-7476                     Shapefile             Environmental Defiencies   support/ contact. The Spreadsheet was started around 2002.
                                                                                                                                                                               The metadata should give you the rest of what you need, but the
                                                                                                                                                                               history here is that this is a subset download from a more
                                                                                                                                                                               comprehensive database operated by Wa Dept Fish & Wildlife.
                                                                                                                                                                               WSDOT pays them to inventory our highways for fish barriers.
                                                                                                                                                                               Assessing a road/river crossing for fish barrier issues is doen using a
                                                                                                                                                   Data Layer:                 defined protocol that starts with the question "does/could this river
                                                                                                                                                   Animals.ENVIRO.FishPassB support fish here?" The database also applies a set of criteria that
                                                                                                                                                   arriers           FGDC:     prioritizes or ranks the barriers to identify those which most need to

                                                                                                              George                      be funded under the I-4 Environmental Retrofit Program. We get an
                          Fish Barriers Tracking                                             Elizabeth Lanzer Saunders 360-                        S/supportteam/data/Maps/24 annual update from WDFW in the spring to use in our project
Fish Barriers database    System                                             Environmental   360-705-7476     705-7110                             K/dfw/fishbarriers.htm      scoping.
Real Estate Information   Real Estate Information                            Property                          Ramanjit
System database           System                    REIS        KE           Management      Cindy Trembley Singh           DOTDBOLYHQ01P RealEstate                            Property Acquisition, Inventory, Rental and Disposal                     SQL               7/1/2000 X

       3                                                                                                                      11:43 AM 2/14/2011                                                                        edb7287f-737a-4126-a10e-23e8ea60c8c7.xls
                                                                              Roadside Features Inventory Systems Analysis

                                                                                                                                                                                                                                                                                                 Data Dictionary
                                                                                                                                                                                                                                                                                                 Data Model
                                                                System ID

                                                                                              Customer        Support
        Project Name            Business Name                                Sponsor Org       Contact        Contact            Server            Database/Data Layer                                   Description
                                                                                                                                                                          TRIPS maintains and processes current and historical data about the
                                                                                                                                                                          WSDOT roadway network, traffic volumes and classifications,
                                                                                                                                                                          collisions, and collision severity. System functions include: - Track
                                                                                                                                                                          highway geometrics, structures, classifications, geographic

                                                                                                                                                Roadway Accident History, jurisdictions, etc. - Maintain ARM - accrual of mileage from beginning
                            Transportation                                                                                                      Roadway Current, Roadway to end of route - Track collisions and the severity of the collision -
                            Information Planning and                        Transportation                                                      Suspense File, Roadway    Track vehicle usage of the highway system (volumes and
TRIPS                       Support System           TRIPS NB               Data Office    Mark Finch       Pat Weldon     BIG Blue DB01        Realignment File          classifications)                                                                                        7/1/1986               X

                           Commitment Tracking                                              Elizabeth Lanzer In
Commitment Tracking system Sytem                    CTS                     Environmental   360-705-7476     Development                                                                                                                                                         Planning X
                           Traffic, Accident,
                           Roadway Information                 Transportation                                                                                                Roadway, Traffic and Accident Data - TRIPS data in SQL Server
TARIS                      System                   TARIS None Data Office    Mark Finch,                   Pat Weldon     DOTDBOLYDS01         TARIS                        format                                                                SQL                                           X X
                           Road Object and                     Transportation
ROAD                       Attribulte Database      ROAD       Data Office    Mark Finch,
                                                                                                                                                                             The Design Variance Inventory System (DVIS) database is used to
                                                                                                                                                                             document design variances made during the project development
                                                                                                                                                                             phase.Design variances are: Design Exceptions (DE), Evaluate

                                                                                                                                                                                                                                                      GIS Layers Filemaker Pro
                                                                                                                                                                             Upgrades (EU) not upgraded, and deviations. A project or corridor
                                                                                                                                                                             analysis may also result in a variance. Purpose of the Design
                                                                                                                                                                             Variance Inventory System:Documentation of variances on a project
                            Design Variance                                                 Dave Olson                                 Federal requirement based on Stewardship Agreement Resource for
Design Variance Inventory   Inventory                                       Design Office   360-705-7952                                        dvis/                        future reference                                                                                                            X

                                                                                                                         http://oscims01.wsd http://oscims01.wsdot.wa.go
                            Integrated Vegetation                           HQ              Ray Willard 360- KENSTOWICZ, v/website/ivmclallam/viewer.
                            Management                                      Maintenance     360-705-7865     CAROL E     mi5/viewer.htm       htm

        4                                                                                                                  11:43 AM 2/14/2011                                                                      edb7287f-737a-4126-a10e-23e8ea60c8c7.xls

Shared By:
Description: Customer Inventory Agreement document sample