Skip to content U.S. Department of Transportation/Federal Highway AdministrationU.S. Department of Transportation/Federal Highway Administration

Office of Planning, Environment, & Realty (HEP)
PlanningEnvironmentReal Estate

HEP Events Guidance Publications Awards Contacts

Outdoor Advertising - State Study

State of Montana

Automated Data Gathering System

A Case Study

Brief Overview of State's Outdoor Advertising Program

Montana's Outdoor Advertising (OA) program is administered by the Bureau of Right-of-Way (ROW), Montana Department of Transportation (MDT) located in Helena. Montana's OA program is decentralized, except for accounting practices, with five districts. Each District has a separate physical office location. There are a total of 17 staff people among the five districts. District offices do their own permitting and site inspections, although all permits receive final approval from the Central office in Helena. Site inspections occur primarily only when a new permit application is received or a violation is discovered or brought to their attention randomly. Program procedures dictate that all permitted signs are to be inspected annually by each District, but District personnel have many ROW duties beyond Outdoor Advertising and annual inspections are not always completed. The prospect of additional outdoor advertising program staffing make annual inventories more likely in the foreseeable future. Sign permits are renewed every three years. Signs are permitted by location, so one permit number can cover several sign faces. Fees are based the total square footage of all sign faces under the permit. Montana has approximately 3,100 signs in its system. The program is only partially funded by permit fees. The data base system that is the subject of this case study is called Outdoor Advertising Control (OAC).

Motivation Behind Selection of System (Technical and Administrative Drivers)

What prompted need for system?

Several things prompted the need for a new system of OA program data collection and maintenance in Montana. In 1995, the state enacted new legislation that made the state's sign permitting regulations more strict in several ways. The state's existing mainframe database system did not house all of the data that would have to be monitored under the new legislation. For example, it was the 1995 legislation that dictated that permit fees be based on the size of the sign. The mainframe system did not allow for easy correlation between sign size and permit renewal invoicing. In addition, they did not believe the mainframe system was Y2K compliant. The Central OA office also recognized a general need for better and more standardized information from the field.

What were your system requirements?

The Central OA office wanted digital imaging and better, cleaner, more accurate field reporting. They knew that any field system that was put into place needed to be kept simple or it would be difficult to get buy-in from the District office field agents. The decentralized nature of the program meant that District offices and field agents were accustomed to working relatively independently using what ever system of data collection worked best for them.

Process of system selection

The Central OA office decided to go through a competitive bidding process to select a contractor to design a data collection system. Many of the technical parameters were predetermined based on the types of systems the Right-of-Way office was already using for accounting and other purposes.

System Design and Development Process

Contractor versus in-house development?

A local firm, Wesco Inc., was contracted for system development, implementation and training.

Who and what process was involved in technical planning and system design?

The Coordinator of the Outdoor Advertising program, one staff member from each District office, and staff from the Information Services Bureau were involved in working with the contractor to develop the system. The planning process was not terribly extensive because the planning team had a good idea of the type of system they wanted, and knew that they wanted to use an Oracle database. These decisions were based on their familiarity with existing ROW Oracle data bases. A few iterations of the system layout were discussed by the planning team and the consultant over a period of two or three months.

How long to develop system?

It took between six and nine months to design and implement the system, and to provide training to Central and District office staff. Districts were brought on-line one by one so full and complete implementation of the system took an additional month or two.

Was the system designed to integrate with other systems?

The system was not specifically designed to integrate with other systems because it was unnecessary to do so. ROW's accounting system is also an Oracle data base so the two systems could easily be linked if there is ever reason to do so in the future. ROW also uses another Oracle data base that was not originally designed for the OA program. This database provides a traveling digital image along every roadway in the state and indicates both milepost references and GPS coordinates. As with the accounting system, there are currently no common fields linking this database to the OAC system, but a user can view a sign in the ROW image system and then find details on it by searching the OAC database by route and milepost number.

System Description

Hardware, including data collection tools

The system's hardware components include a Digital Alpha server that is located at the Headquarters office, and desktop PCs in the Central and District offices. Field personnel use Kodak digital cameras.

Software

The system uses Oracle version 7.0 database software running on a Digital Alpha server at Headquarters, and Oracle for NT database software at the District offices. Laptop computers equipt with Kodak software are available in the District Offices for additional storage of digital images.

System type

The OAC is a client-server application using an Oracle version 7.0 relational database. (See Appendix A.) OAC is housed on the Central office server and District offices are networked to HQ for use of the database. All data is stored in the database sitting on the server located at Headquarters. Forms or entry screens are each separate files within the data base. These files are stored locally on the District office computers to facilitate faster display of screens. Digital cameras can be connected directly to laptops available in the District Offices and images are stored in selected different formats (i.e. JPEG, TIF) at one location in the file system. That location is maintained within the database and can be changed at any point of time without disturbing the software.

The system locates signs by route number and milepost, but was designed with fields to accommodate GPS coordinates. Screens are object-oriented, Windows-type screens with radio buttons or pull-down menus associated with as many fields as possible. This limits the possible entries for those fields, thereby reducing data entry errors. (See Appendix B.)

Users must log on using a user-ID. All users have access to all data in the data base, e.g. each district has access to, and can make changes to, information on sign permits in all other Districts. An entry log is maintained that records the date, time and user-ID for the last change made to any data element in the database. Field inspectors have direct access to the data in the OAC system from their PCs in the District Offices. Data inspected and manually changed in the field is entered into the system in the District offices.

Several frequently used queries and resulting reports are embedded in the system. Customized queries and reports can also be generated easily by the system. The standard reports generated by the system include: permitted signs; permitted signs by district; permitted signs by district and county; permitted sign selected by district by owner; permitted signs by district, county route number and milepost; withdrawn & purchased signs by permit number; withdrawn & purchased signs by district and permit number; inspection comments; exception report.

Data Collection/Data Input - Procedure and Mechanics

OA program procedures and practices

Permit applications are review and processed by each District with final approval of all sign permits coming from the Headquarters office. Permits are renewed every three years and invoicing is done by Headquarters. Field inspectors investigate potential sign locations when an application is received and again after the sign is placed. A picture is taken at that time. All permitted signs are also supposed to be inventoried annually by each District, although this practice has not been strictly adhered to in the past. In addition to the 17 field employees, the OA program recently hired a Compliance Technician who covers all Districts, assisting with inventorying and pursuing violations.

Inspectors have access to the OAC system sign data from their District Office PCs. They investigate and gather data manually in the field and then input the changes/new data at the District offices. Data updates, changes, additions or deletions are not reviewed by any other staff when input by field inspectors at the District Offices. The entry log is available, however, that records the user-ID of the last user to change a particular data element.

How was existing data transferred to the new system?

Montana had an existing mainframe system. Data was transferred from the mainframe system to the replacement system with only minor "data cleansing" necessary. The OAC system includes data fields that were not a part of the old mainframe system. Montana opted to implement the new system despite these missing data elements. "Data holes" are being filled gradually on a case by case basis through day-to-day use of the system for permit renewals, site inspections and annual inventories. The Compliance Technician hired to oversee all Districts is gradually updating all information in the system. Including the likely addition of two Headquarters staff dedicated to outdoor advertising, Montana estimates that it will take two years before all data is complete on all signs in the system. That includes photographs and GPS coordinates for all signs assuming money is available within that time period for the GPS equipment. Since sign fees are determined by the square footage of the sign faces(s), that information has been the top priority for updating the system.

Hardware/software data collection tools used?

The only data gathering equipment used is a digital camera. Although the field agents do not use laptops to run the OAC system, there are laptops available in the District offices that are equipt with Kodak software. The digital cameras can be plugged directly into the laptops. If agents can not fit all of the images they need on the digital cameras while they are out in the field, they can use the laptops to store images.

System Strengths and Weaknesses

Strengths

The system's simplicity is its primary strength as evidenced by the fact that implementation proceeded very smoothly. There was very little opposition from District staff to the use of the system which was something HQ would have anticipated if the system were too complicated, cumbersome or inflexible. Depending on individual personalities, many of the District field staff were really enjoying using the new system and experimenting with its capabilities.

The system has allowed inquiries generated from the field to be handled directly by each District office. This is much more efficient than having to contact HQ for answers. The Districts have very quick access to data.

Weaknesses

The time required to download digital images is much too long. The process in general of getting the photos from the digital camera into the system is cumbersome.

What would you do differently/advice?

Montana is quite happy with their system development process and the resulting database. They feel the appropriate amount of planning went into the design of the system and that the right people were involved. They believe the level of complexity and sophistication of their system is in line with their OA program requirements. Their system has the ability to expand to include the use of GPS, and they do not feel that the lack of GPS capability at the moment is debilitating to managing their program. Headquarters staff are satisfied with the level of buy-in that they have received from District staff. This is a significant point, because District acceptance of a new system had been an issue of concern for them.

System Costs

Design, implementation and training

The cost for system design, implementation, and training was $32,000.

Hardware and equipment

Twenty (20) digital cameras were purchased at $950 each for a total hardware cost of $19,000.

Maintenance

There are no maintenance costs associated directly with the system. The system does not currently use a GPS locationing system, so there are no GPS fees. HQ and District offices already had Oracle licenses so there are no additional software license fees associated strictly with use of the system. No maintenance contract was solicited from the contractor, and any fine-tuning to the system is being done by in-house staff who are familiar with Oracle.

For More Information

Contact Gordon Koterba at gkoterba@state.mt.us or 406-444-7293.


APPENDIX A: Outdoor Advertising Control (OAC) System Manual [not included here - contains proprietary information]

APPENDIX B: Outdoor Advertising Control (OAC) User Manual


* Case study based on site visit conducted on February 1, 2000 and telephone update conducted in October, 2000. Those present at the site visit included:

Richard Munger, Coordinator, Outdoor Advertising, Montana Department of Transportation (MDT)

Gordon Koterba, Programmer Analyst, Information Services Bureau, MDT

Patrick Hurley, Compliance Technician, Outdoor Advertising, MDT

Merlin Voegele, Right of Way/Civil Rights Officer, FHWA


APENDIX B

Outdoor Advertising Control (OAC) User Manual

Textual descriptions of database screen images in this appendix are provided immediately following each image. These descriptions are enclosed in brackets. Within each image description, any fields and buttons in the screen are identified in bold, italicized text. Other words appearing in the screen images are in quotation marks. Text outside of the brackets in this Appendix is as it appears in the document provided by the state.


OUTDOOR ADVERTISING CONTROL (OAC)

DEPARTMENT OF TRANSPORTATION MONTANA USER MANUAL VERSION 1.0 JULY 1999


CONTENTS

INTRODUCTION *

1. RW001FT (Application Form Maintenance) *

2. RW002FT (Field Inspection) *

3. RW004FM (Sign Owner Maintenance) *

4. RW009FC (Reports) *


INTRODUCTION

Outdoor Advertising Control is an application system to catalog Billboard permits and Images. When the OAC agents travel the roads of Montana, they shall be equipped with Laptop computers and Digital cameras to capture information and images regarding the billboards along the roadways. The information regarding images, their location, size, owner details etc shall be stored in the database and images captured shall be stored in the file system at specified location. The State headquarters and the Districts will be connected through high speed links for the storing and retrieval of the information. This information shall be used for future inspections of the billboards and shall be used at the District and State headquarters for a variety of purposes.

  1. RW001FT (Application Form Maintenance)

This program will be used for maintenance of the Application Form details. One can Add/ Modify/View the details of the Application Form using this program. The Application form details have been divided into various screens. Each of them can be activated by either clicking or pressing enter on the corresponding header.

One can enter the various details after entering the Permit Number.

The user can perform various operations by clicking the buttons on the Toolbar.

Sign and Land Owner Details Screen

screen shot of the Montana Department of Transportation Application Form Maintenance, Sign Owner and Land Owner Details window

[This page shows the "Application Form Maintenance" screen. "Montana Department of Transportation", the date, the screen reference number ("RW001FT"), are displayed across the top of the screen. There is a field for Permit No. and below that are five tabs that can be selected. The tabs include: Sign and Land Owner, Sign Location, Sign Desc./Location, Image Info, and Other Info. The Sign and Land Owner tab is currently selected. The tab is split in half with "Sign Owner Details" on the top and "Land Owner Details" below that. Both sections contain the same fields - Last Name, First Name, Street, City, State, Zip Code, Telephone. The "Sign Owner Details" section also includes an Owner Code field. At the bottom of the screen, instructions are provided on how to enter, execute and cancel queries using tab keys - "Enter a query, press F8 to execute, Ctrl q to cancel".

Above "Montana Department of Transportation" at the top of the screen are the eighteen buttons that make up the toolbar for the "Application Form Maintenance" screen. The toolbar buttons include: Previous Block, Next Block, Previous Record Set, Next Record Set, Previous Record, Next Record, Query, Exec, County, Prev, Print, Save Exit, List, Keys, Error, Tool Bar, and Help. These buttons are listed and described in the last sub-section of this Chapter. The menu options for the entire "Outdoor Advertisement Control" system that appear at the very top of each screen in the system include: Action, Edit, Block, Field, Record, Query, Window and Help.]

This screen will be used to enter the details of the Sign and Land Owner. On pressing tab key at the Land Owner Telephone field, the control automatically goes to the Sign Location Info details screen.


Sign Location Screen

screen shot of the Montana Department of Transportation Application Form Maintenance, Location Information window

[This page shows the "Application Form Maintenance" screen with the Sign Location tab selected (the other tabs include Sign and Land owner, Sign Desc/Structure, Image Info and Other Info). The date is displayed in the upper, left corner, "Montana Department of Transportation" is centered at the top of the screen, and the screen reference number ("RW001FT") is in the upper, right corner. The Permit No. field is located just above where the tabs can be selected. The fields that make up the Sign Location tab can be separated into in three columns. The following fields are listed down the left side: District, County, Nearest Sign, RoadBed Information, Kilometers Offset, Coordinates [X] and Latitude. The RoadBed Information field has four radio buttons associated with in including: North, South, East and West, respectively. The fields in the middle column include Route, Sign Located, Roadway Id, Mile Offset, [Y] and Longitude. The field Sign Located has six radio buttons associated with it including: Left, Right, North, South, East and West. RoadWay Id also has four radio buttons, these include: P, S, I and U. The right column includes the following fields: Nearest Milestone, Highway No. and [Z]. At the bottom of the screen, instructions are provided on how to enter, execute and cancel queries using tab keys. "Enter a query, press F8 to execute, Ctrl q to cancel".

The toolbar options provided at the top of the screen include: Previous Block, Next Block, Previous Record Set, Next Record Set, Previous Record, Next Record, Query, Exec, County, Prev, Print, Save Exit, List, Keys, Error, Tool Bar, and Help. These buttons are listed and described in the last sub-section of this Chapter. The menu options for the entire "Outdoor Advertisement Control" system that appear, of course, at the very top of each screen, include: Action, Edit, Block, Field, Record, Query, Window and Help.]

This screen will be used to maintain the information about the location of the sign/billboard. The user can enter details about the situation of the Sign like the Highway on which the Sign is located, the District, the County, the Nearest Milepost to the Sign, the State Plane Co-ordinates, GPS readings etc.

On pressing tab key at the Longitude field, the control automatically goes to the Sign Desc/Structure Details Screen.


Sign Description and Structure Details Screen

screen shot of the Montana Department of Transportation Application Form Maintenance, Structure Information window

[This page shows the "Application Form Maintenance" screen with the Sign Desc/Structure tab selected (the other tabs include Sign and Land owner, Sign Desc/Structure, Image Info and Other Info). The date is displayed in the upper left corner, "Montana Department of Transportation" in center, and the screen reference number ("RW001FT") is in the right corner. The Permit No. field is located just above where the tabs can be selected. The Sign Desc/Structure tab is divided into two sections - the "STRUCTURE INFORMATION" section and the "ZONE INFORMATION" section. The upper section ("structure information") contains the following fields: Sign Width, Sign Height, Structure Height, Square Footage, Labor Cost, Material Cost, Sign Type, Sign Lighted and Sign Comments. The Sign Type field has four radio buttons associated with it including: Single, Double, V Type and Multi Faced. The Sign Lighted field has two radio buttons including Yes and No. The "zone information" section contains just two fields, each with associated radio buttons. The first field is C/I Zoned with the radio button options being: Commercial, Industrial and Unzoned. The other field, Sign Conforming, has the following radio button options: Yes, No, P-72, P-95 and Others.

The toolbar options provided at the top of the screen include: Previous Block, Next Block, Previous Record Set, Next Record Set, Previous Record, Next Record, Query, Exec, County, Prev, Print, Save Exit, List, Keys, Error, Tool Bar, and Help. These buttons are listed and described in the last sub-section of this Chapter. The menu options for the entire "Outdoor Advertisement Control" system that appear, of course, at the very top of each screen, include: Action, Edit, Block, Field, Record, Query, Window and Help.]

This screen will be used to maintain the details regarding physical description of the sign and structure, information regarding the cost of the sign and the zone details. The details that can be maintained are Sign Width, Sign Height, Structure Height, Sq. footage of the Sign, Labor Cost, Material Cost, Zone Information etc


Image Information Screen

screen shot of the Montana Department of Transportation Application Form Maintenance, Image Information window

[This page shows the "Application Form Maintenance" screen with the Image Info tab selected (the other tabs include Sign and Land owner, Sign Desc/Structure, Image Info and Other Info). The date is displayed in the upper left corner, "Montana Department of Transportation" is written across the center, and the screen reference number ("RW001FT") is in the upper, right corner. The Permit No field is located just above where the tabs can be selected. The Image Info tab includes a box with side and bottom scroll bars that is currently blank, but could contain a photograph. Buttons saying Prev Image and Next Image are below the box. The area next to the box contains a series of fields with associated radio buttons and comment fields. The entire area is labeled "IMAGE INFORMATION". The fields include: Location Conforming with Yes and No radio buttons and a Comments field, Sign Illuminated with Yes and No radio buttons and a Comments field, Sign Occupied with Yes and No radio buttons and a Comments field, Sign in Disrepair with Yes and No radio buttons and a Comments field, and Sign Upgraded with Yes and No radio buttons and a Comments field.]

The toolbar options provided at the top of the screen include: Previous Block, Next Block, Previous Record Set, Next Record Set, Previous Record, Next Record, Query, Exec, County, Prev, Print, Save Exit, List, Keys, Error, Tool Bar, and Help. These buttons are listed and described in the last sub-section of this Chapter. The menu options for the entire "Outdoor Advertisement Control" system that appear, of course, at the very top of each screen, include: Action, Edit, Block, Field, Record, Query, Window and Help.]

This screen tab will be used to get the information regarding the images and inspection details of the Sign.

One can view the multiple images associated with the last inspection by using the Next Image and Previous Image buttons. To view the previous image taken during the inspection, click on Previous Image button. To view the next image taken during the inspection, click on Next Image button.

To increment the zoom factor of the image, the user can enter the desired values in the field located below the image. This will enlarge the portion of the image located at the center of the image box.

One can also click on the image to get an enlarged view of the image.


Other Information Screen

screen shot of the Montana Department of Transportation Application Form Maintenance, Other Information window

[This page shows the "Application Form Maintenance" screen with the Other Info tab selected (the other tab options include Sign and Land owner, Sign Location, sign Desc/Structure, and Image Info.) The date is displayed in the upper left corner, "Montana Department of Transportation" is written across the center, and the screen reference number ("RW001FT) is in the right corner. The Permit No. field is located just above where the tabs can be selected. The Other Info tab is labeled "OTHER INFORMATION" and contains the following fields organized basically in two columns: Date Permit Issued, Renewal Date, Last Inspection Date, sign Status, Sign Disrepair, Sign Support, Creation Date, Date Sign Built, Renewal Fee, Surface Height, Sign Lighted (with Yes and No radio buttons), Number Exist (with Yes and No radio buttons), Creation Id and Comments.

The toolbar options provided at the top of the screen include: Previous Block, Next Block, Previous Record Set, Next Record Set, Previous Record, Next Record, Query, Exec, County, Prev, Print, Save Exit, List, Keys, Error, Tool Bar, and Help. These buttons are listed and described in the last sub-section of this Chapter. The menu options for the entire "Outdoor Advertisement Control" system that appear, of course, at the very top of each screen, include: Action, Edit, Block, Field, Record, Query, Window and Help.]

This screen will be used to enter all other details related to the Sign/Permit like the date on which the Permit was issued, the date on which the Sign was built, Sign Renewal Date, Renewal Fee, Last Inspection Date, General Comments and the Status of the Sign.

Toolbar

The toolbar consists of the following buttons

Previous

Block This button is not applicable on this screen

Next

Block This button is not applicable on this screen

Previous Record

Set Gets the previous record matching the query criteria

Next Record

Set Gets the next record matching the query criteria

Previous Record

Gets the previous record matching the query criteria

Next Record

Gets the next record matching the query criteria

Query

Enter the query conditions for records retrieval

Exec

Executes the query based on the query conditions entered

Count

Displays the number of records matching the query criteria

Prev

Executes the last query

Print

Prints the details of Current permit number displayed on the form

Save

Saves and Commits the changes into the database.

Exit

Closes the application

List

Displays the list of values for the current field if applicable

Keys

Displays the function keys available on the screen

Error

Displays errors, if encountered

Tool Bar

Hides the Toolbar

Help

Displays Help on this program


One can get a List of Values for existing Permit Numbers by placing the cursor on the Permit Number field and clicking on the List button.


RW002FT (Field Inspection)

This program will be used by the Field persons for conducting inspection of the Sign/Permit. To select the required permit records, press the Query button and enter the desired criteria in any of the fields. After entering the criteria, press the Exec button to get the permits matching the query criteria. You can now view images and add inspection comments for the Sign. Images and details of previous inspection are also available for reference purposes.

The information in this program is arranged on three screen tabs. The first screen tab is Sign/ Permit Info Tab.

screen shot of the Montana Department of Transportation Field Inspection, Permit Details window

[This page shows the "Field Inspection" screen with the Sign/Permit Info tab selected. The other tabs that can be selected include Current Inspection Comments and Last Inspection Comments. The date is displayed in the upper left corner, "Montana Department of Transportation" is written across the center, and the screen reference number ("RW002FT) is in the right corner. Above where the tabs can be selected are the Permit No and Last Inspection Date fields. The Permit No and Last Inspection Date fields are located just above where the different screen tabs can be selected. The Sign/Permit Info tab is split into two sections. The upper section is labeled "PERMIT DETAILS" and below that is "STRUCTURE AND ZONE INFO" section. The "Permit Details" section of the tab includes the following fields: District, County, Nearest Sign, RoadBed Information (with radio buttons for North, South, East and West), Km Offset, Coordinate [X], Latitude, Route, Sign Located (with Yes and No radio buttons), RoadWay ID (with P, S, I and U radio buttons), Mile Offset, [Y], Longitude, Milepost, Highway No. and [Z]. The "Structure and Zone Info" section of the tab contains the following fields: Sign Width, Sign Height, Structure Height, Type of Sign (with radio buttons for Single, Double, V Type and Multi Faced), Sq Ftg, C/I Zoned (with D, I and U radio buttons), Sign Conforming (with Yes and No radio buttons) and Non Conf

The toolbar options provided at the top of the screen include: Previous Block, Next Block, Previous Record Set, Next Record Set, Previous Record, Next Record, Query, Exec, County, Prev, Print, Save Exit, List, Keys, Error, Tool Bar, and Help. These buttons are listed and described in the last sub-section of this Chapter. The menu options for the entire "Outdoor Advertisement Control" system that appear, of course, at the very top of each screen, include: Action, Edit, Block, Field, Record, Query, Window and Help.]


The second screen tab is Last Inspection Comments Tab.

screen shot of the Montana Department of Transportation Field Inspection, Last Image and Inspection window

[This page shows the "Field Inspection" screen with the Last Inspection Comments tab selected. The other tabs that can be selected include Sign/Permit Info and Current Inspection Comments. The date is displayed in the upper left corner, "Montana Department of Transportation" is written across the center, and the screen reference number ("RW002FT) is in the right corner. Above where the tabs can be selected are the Permit No and Last Inspection Date fields. The Last Inspection Comments tab is labeled "LAST IMAGE AND INSPECTION". It contains an image box with an image currently displayed and scroll bars to the side and bottom of the box. Above the image box are the Prev Image and Next Image buttons. There is also a % field with a drop-down menu allowing the user to change the size of the image. Next to the image box are five fields, each with associated Yes or No radio buttons and a Comments field. The fields include: Location Conforming, Sign Illuminated, Sign Occupied (with 100% copy), Sign in Disrepair, Sign being Upgraded. Below those fields is a separate Comments field.

The toolbar options provided at the top of the screen include: Previous Block, Next Block, Previous Record Set, Next Record Set, Previous Record, Next Record, Query, Exec, County, Prev, Print, Save Exit, List, Keys, Error, Tool Bar, and Help. These buttons are listed and described in the last sub-section of this Chapter. The menu options for the entire "Outdoor Advertisement Control" system that appear, of course, at the very top of each screen, include: Action, Edit, Block, Field, Record, Query, Window and Help.]


The third screen tab is Current Inspection Comments Tab.

screen shot of the Montana Department of Transportation Field Inspection, Current Image and Inspection window

[This page shows the "Field Inspection" screen with the Current Inspection Comments tab selected. The other tabs that can be selected include: Sign/Permit Info, and Last Inspection Comments. The date is displayed in the upper left corner, "Montana Department of Transportation" is written across the center, and the screen reference number ("RW002FT) is in the right corner. Above where the tabs can be selected are the Permit No and Last Inspection Date fields. The Current Inspection Comments tab is labeled "CURRENT IMAGE AND INSPECTION" across the top and contains a box with an image in it. There are scroll bars on the side and bottom of the image box. Above the image box are buttons for Prev Image and Next Image and a % field with a drop-down menu allowing the user to change the size of the image. Next to the image box are five fields, each with associated Yes or No radio buttons and a Comments field. The fields include: Location Conforming, Sign Illuminated, Sign Occupied (with 100% copy), Sign in Disrepair, Sign being Upgraded. Below those fields is a separate Comments field.

The toolbar options provided at the top of the screen include: Previous Block, Next Block, Previous Record Set, Next Record Set, Previous Record, Next Record, Query, Exec, County, Prev, Print, Save Exit, List, Keys, Error, Tool Bar, and Help. These buttons are listed and described in the last sub-section of this Chapter. The menu options for the entire "Outdoor Advertisement Control" system that appear, of course, at the very top of each screen, include: Action, Edit, Block, Field, Record, Query, Window and Help.]

To View the details of the image, increment the zoom factor of the image by entering the zoom factor in the field located above the image. This will enlarge the portion of the image located at the center of the image box.

To Enlarge the Image, click on the image.

To Return back to the original state, click on the Image.

To Enter the comments for each of the checklist items on the Current Inspection comments tab, click on the respective Comments button. This will invoke an editor in which comments related to the checklist items can be added.

To Enter General Comments, click on the General Comments button. This will invoke an editor in which general comments can be added.

screen shot of the Montana Department of Transportation comments Editor window

[Above is the image of the "Editor" box. It says "Editor" in the upper left corner and consists of the comment box and the buttons Search, OK and Cancel below the comment box.]

To View Multiple Images associated with this and previous inspection, use the Next Image and Previous Image buttons. To view the previous image taken during the inspection, click on Previous Image button. To view the next image taken during the inspection, click on Next Image button.

Clicking on the Save button of the Toolbar will Save the inspection comments into the database.

One can get a List of Values of existing Permit Numbers by placing the cursor on the Permit Number field and clicking on the List button.

Toolbar

The toolbar consists of the following buttons

Previous

Block This button is not applicable on this screen

Next

Block This button is not applicable on this screen

Previous Record

Set Gets the previous record matching the query criteria

Next Record

Set Gets the next record matching the query criteria

Previous Record

Gets the previous record matching the query criteria

Next Record

Gets the next record matching the query criteria

Query

Enter the query conditions for records retrieval

Exec

Executes the query based on the query conditions entered

Count

Displays the number of records matching the query criteria

Prev

Executes the last query

Print

Prints the details of Current permit number displayed on the form

Save

Saves and Commits the changes into the database.

Exit

Closes the application

List

Displays the list of values for the current field if applicable

Keys

Displays the function keys available on the screen

Error

Displays errors, if encountered

Tool Bar

Hides the Toolbar

Help

Displays Help on this program

RW004FM (Sign Owner Maintenance)

This program will be used to maintain the details of the Sign Owners. The user can Add, Modify, Delete or View information of the Sign Owners maintained in the database.

screen shot of the Montana Department of Transportation Sign Owner Maintenance window

[This page shows the "Sign Owner Maintenance" screen. The date is displayed in the upper left corner, "Montana Department of Transportation" is written across the center, and the screen reference number ("RW004FT) is in the right corner. Fields on the screen include: Owner Code, Owner Name - Last and First, Street, City, State Zip and Phone No. Below these fields are the Created/Modified By field and the Creation/Modification Date field.

The toolbar options provided at the top of the screen include: Previous Block, Next Block, Previous Record Set, Next Record Set, Previous Record, Next Record, Query, Exec, County, Prev, Print, Save Exit, List, Keys, Error, Tool Bar, and Help. These buttons are listed and described in the last sub-section of this Chapter. The menu options for the entire "Outdoor Advertisement Control" system that appear, of course, at the very top of each screen, include: Action, Edit, Block, Field, Record, Query, Window and Help.]

The user can perform various operations by clicking on the toolbar.

To Add a Sign Owner, enter the details in all the fields and click on the Save button. This will add the Sign Owner record in the database.

To Modify an existing Sign Owners details, enter the query criteria after clicking on the Query button. On pressing the Exec button, records matching the query criteria are retrieved and displayed on the screen. If more than one record matches the query criteria, click on the Next and Prev buttons on the toolbar to locate the desired record. After locating the desired record, which is to be modified, change the required values and press the Save button to record the changes in the database.

To Delete an existing Sign Owners details, enter the query criteria after clicking on the Query button. On pressing the Exec button, records matching the query criteria are retrieved and displayed on the screen. If more than one record matches the query criteria, click on the Next and Prev buttons on the toolbar to locate the desired record. After locating the desired record, which is to be deleted, click on the Delete button and press the Save button to commit the delete to the database.

To View an existing Sign Owner details, enter the query criteria after clicking on the Query button. On pressing the Exec button, records matching the query criteria are retrieved and displayed on the screen. If more than one record matches the query criteria, click on the Next and Prev buttons on the toolbar to view the desired record.

Toolbar

The Toolbar consists of the following buttons that can be used for various purposes :

Previous

Block This button is not applicable on this screen

Next

Block This button is not applicable on this screen

Previous Record

Set Gets the previous record matching the query criteria

Next Record

Set Gets the next record matching the query criteria

Previous Record

Gets the previous record matching the query criteria

Next Record

Gets the next record matching the query criteria

Query

Enter the query conditions for records retrieval

Exec

Executes the query based on the query conditions entered

Count

Displays the number of records matching the query criteria

Prev

Executes the last query

Print

Prints the details of Current permit number displayed on the form

Save

Saves and Commits the changes into the database.

Exit

Closes the application

List

Displays the list of values for the current field if applicable

Keys

Displays the function keys available on the screen

Error

Displays errors, if encountered

Tool Bar

Hides the Toolbar

Help

Displays Help on this program

RW009FC (Reports)

The program will be used to initiate the printing of various reports. The user can select any combination of reports to be printed.

To print report for a specific district, check the box next to the District name on the screen using the mouse button. You have an option to select any number of districts. To print report of all districts, check the box next to All.

To print a specific report, check the box next to the Report name on the screen using the mouse button. You have an option to select any number of reports to be printed.

If you have selected report Signs Selected by District-Owner Code, then you would be prompted to enter an Owner Code for which the report will be printed. This should be a valid Owner Code existing in the system. You can also press the list button on the toolbar to select an Owner Code from the list of values.

If you have selected report Inspection Comments, then you would be prompted to enter an Inspection Date for which the report will be printed.

If you have selected an exception report, then you would be prompted to four check box i.e. Sign width (Sign Width > 48), Sq. Footage (Sq. Footage > 672), Surface Height (Height Surface > 30) and Sign comments(Sign Comments is Not Null).

You can check either one of them or all, the report will be printed accordingly.

screen shot of the Montana Department of Transportation District Report window

[This page shows the system's reports options screen. The date is displayed in the upper left corner, "Montana Department of Transportation" is written across the center, and the screen reference number ("RW009FT) is in the right corner. The screen is split into two sections the "DISTRICT" section and the "REPORT" section. Under "DISTRICT" are radio buttons for the five districts in Montana (Missoula, Bulle, Great Falls, Glendive and Billings) and an All radio button. Under the "Report" section are check boxes for the various reports that can be selected. The check boxes include: Permitted Signs - Permit, Permitted Signs - District, Permitted Signs -District - County - Permit, Signs selected by District - Owner Code (with a field to enter the Owner Code), Permitted signs - District - County - Route - Milepost, Withdrawn and Purchased Signs - Permit, Withdrawn and Purchased Signs - District - Permit, Inspection Commnets (with Inspection Date field), Exception Report, Sign Width > 48, Sq footage > 672, Surface Height >30, and Sign Comments is Not Null.

The toolbar options provided at the top of the screen include: Previous Block, Next Block, Previous Record Set, Next Record Set, Previous Record, Next Record, Query, Exec, County, Prev, Print, Save Exit, List, Keys, Error, Tool Bar, and Help. These buttons are listed and described in the last sub-section of this Chapter. The menu options for the entire "Outdoor Advertisement Control" system that appear, of course, at the very top of each screen, include: Action, Edit, Block, Field, Record, Query, Window and Help.]

Updated: 09/05/2014
HEP Home Planning Environment Real Estate
Federal Highway Administration | 1200 New Jersey Avenue, SE | Washington, DC 20590 | 202-366-4000