Create UKPMS Indicator Report

Description ahead provides information on the steps required and links to other relevant sections of the Confirm Help.

The steps to produce most of the UKPMS Indicators are as follows:
  • Import the Rules and Parameters 
  • Import the Survey Data 
  • Set up a Data Analysis record 
  • Specify the Features to be included 
  • Specify the Condition Data to be included 
  • Run the Analysis 
  • Generate the report 
The importing steps are usually performed just once at the beginning of the process and the analysis and running of the report done for each report required.

Note: The Footway Network Survey Headline Indicator is produced directly from Condition Data without the need to perform a Data Analysis. See the Footway Network Survey for more details.

Import the Rules and Parameters
Before performing any UKPMS analysis the Rules and Parameters for the current year must be imported into the database. The Rules and Parameters are provided in Microsoft Access database format and the File is named to reflect the year the rules are designed for (e.g. RP10.01 for use in 2010 and onwards).

See Data Analyser Imports for more information.

Import the Survey Data
Survey data should be supplied in HMDIF format and the Importing is explained in the Import Survey Data section.

Set up a Data Analysis record
All analysis is done using the Data Analysis screen. Set a Name for the new analysis (Batch No. is generated automatically).

Two types of analysis are performed in order to produce the UKPMS reports; Automatic Pass and SCANNER Road condition Indicator analysis. The report being run will determine which type of analysis data is used, but the analysis must be run in advance of the reports being run as the reports simply display the results of the different analysis.

When performing an analysis you must specify how the data will be analysed by setting the ‘Process Type’. The analysis for UKPMS requires that the Rules and Parameters for the current year be imported before performing the analysis. There are two types of Automatic Pass analysis in common use by UKPMS; fixed length and variable length. The other process type used by UKPMS is ‘SCANNER Road condition’. These types are created automatically by the Rules and Parameters Import and the type required will depend on the report being run.

Specify the Features to be included
A significant amount of processing effort is required to perform the analysis, especially the Automatic Pass analysis, so the processing time can reduced considerably by only running the analysis for the Features that are to be reported on (rather than analyse lots of Features and filter them at the reporting stage). The Features to be analysed are set by the “Action” button “Batch Add Feature” option. This option will display a filter used to restrict the Features that will be included.

Named Selections are the easiest way of adding Features based on a multiple criteria (and the only way when certain Features must be removed from the selection i.e. roundabouts), but where the Feature selection is straightforward they can be filtered here.

The Feature data required by the UKPMS reports is often more varied than can be retrieved in a single filter operation. To overcome this, Named Selections are used to build up a list of the relevant Features by performing multiple filter operations. Further details on creating Named Selections can be found in the Named Selection Tool section of the help.

Most Named Selections created for the UKPMS reports will be a collection of one of more DfT classifications (in some databases this is named DOT Classification) , although some also require that roundabouts be removed and some are based on inventory. The particular report section will provide exact details of creating the Named selection for the report.

Note: It is important to remember that a Named Selection is a list of Features retrieved at the time it was created and the filter criteria used to create it is not remembered. This means any Features that are added or removed after creation will not be reflected in the Named Selection.

Specify the Condition Data to be included
Selecting the condition data to be included in the analysis is done using the “Action” button “Refresh Data” option. This will then display the ‘Refresh Data’ screen where the types of observation data and the date range required can be selected. Each UKPMS report will require specific observation types and ranges. An additional setting on this screen that is sometimes required by the UKPMS reports is the “Ignore Inventory” tick box. Again, whether or not it needs setting will be dependent on the report being run.

For SCANNER analysis, ‘Refresh Data’ can be also performed from ‘Process Run Filter’ before specifying SCANNER Index. This will require parameters like survey type and dates to be specified similar to that on ‘Refresh Data’ screen’.

Run the Analysis
The Analysis is started by first selecting the ‘Initial Data’ on the ‘Data Sets’ tab and then clicking the detail button. This will display the ‘Analysis Data Set’ screen showing all of the Features with condition data that will be included in the analysis. From here select the ‘Action’ buttons ‘Run Processes’ option to open the ‘Process Run Filter’ the Analysis is actually started and different options can be set that determine how the analysis will be performed in more detail.

If the report requires that Inventory be ignored then the ‘Ignore Inventory’ option should be ticked, just as it was in the ‘Refresh Data’ screen.

If a SCANNER type analysis is being performed then the Weighting Set to be used must be specified by clicking the ‘Parms’ button and locating the relevant Access database file.

For the UKPMS reports the Sub-Process setting should not be changed from the default.

When the OK button is clicked the Analysis will begin. This can take a considerable amount of time, depending on how many Features and observations there are.

Generate the Reports
Details on producing the individual Indicators can be found in the appropriate report section.

UPDATED:  March 23, 2017