FAQs - Tools

Other FAQ categories: All FAQs | Access | Background | Data | Mapping | SDM | Technical | Tools |

How are AND OR operators used in reports?

When building a report there are a number of parameters that can be set.  The report queries are constructed using a combination of operator functions:

The AND operator displays a record if both the first condition AND the second condition are true.  The AND operator is used when values are set between different options.  For example:

 I want a list of:

 - Area of Interest = National (AND)

 - Facility Type = AGP (AND)

 - Facility Sub Type = 3G Rubber Crumb (AND)

 - Pitch Count => 2 (AND)

 - Small AGP Flag ticked

 This would generate a report output of only small sided 3G APGs facilities with more than 2 pitches located in England.


The OR operator displays a record if either the first condition OR the second condition is true.  The OR operator is used when multiple values within a single option.  For example:

 I want a list of:

 - Area of Interest = Kent (AND)

 - Facility Type = Grass Pitches (AND)

 - Ownership = Local Authority (OR) Education (OR) Sports Club

 This would generate a report output of Grass Pitches in Kent that are either owned by the Local Authority sector or the Education sector or Sports Clubs.


It should be noted that no results may be generated if certain options are used e.g. for GOLF.  Unlike most facility types Golf has sub types that do not share the same attributes (i.e. Driving ranges do not have the same attributes as par 3 or standard courses).  For example:

 I want a list of:

 - Area of Interest = National (AND)

 - Golf (AND)

 - Bays = >4 (AND)

 - Holes = >4

 This would generate a report output of no results as no single facility has both Bay and Hole attributes. 

How are counts of different facility types calculated?

In broad terms calculations are based upon the smallest unit definable for a facility type.  For example the total number of Grass Pitches at a site will be based upon the number of individual pitches for all Grass Pitch sub types (of which 20 sub types currently exist ranging from Full Size Football to Rounders).  Should a site have four Full Size Football pitches, two Junior Football pitches and three Rounder pitches a total count of nine pitches would be calculated. 

The method for calculating counts by the number of units applies to Artificial Grass Pitches (AGPs), Grass Pitches, Squash Courts and Tennis Courts.

All other facility counts are based upon the number of facility sub types rather than unit value.   For example the total count of Swimming Pools at a site will be based upon the number of individual facility sub types only (of which there are five).  Should a site have one Main/General Pool, one Diving Pit and one Learner pool a total of three facilities would be calculated. 

 *Please note that between the re-launch of Active Places Power in November 2012 and a fix release in June 2013 Artificial Grass Pitches (AGPs), Grass Pitches, Squash Courts and Tennis Courts were incorrectly calculated as a count of facility type rather than a count of units.  The result being that counts for these facilities types were significantly less than normally reported by Sport England.*

How are the catchment areas (drive and walking) generated and which datasets are used?

Active Places Power uses ESRI's ArcGIS Server Network Analyst 10 software to provide dynamic catchment area analysis.

For more information on ESRI's Network Analyst see:

The two separate network datasets are used to compute the catchment areas within the Catchment Profile Report.  For the driving option Ordnance Survey's Integrated Transport Network (ITN) Layer is used whereas for the for the walking option,  ITN is combined with and Ordnance Survey's Urban Path data. In the walking option motorways are avoided and all traversable roads are assigned a speed of 3 MPH. 

It should be noted that Ordnance Survey ITN road speed limits have not been used. Instead the entire ITN dataset has been assigned articulated speed limits determined through Sport England's Facility Planning Model (FPM). This includes for example junction delay factor of 15% (of the total Drive Time) and an additional 160 Secs (2.667 Mins) to factor in parking delays at start and end of each journey. This ensures a consistent calculation of drive times used within both Active Places Power and the Facility Planning Model.

The ArcGIS Server Network Analyst extension computes catchment areas (isochrones) around any location on the network whether this be an existing facility or a new user defined location.  The service area will encompass all accessible streets that are within a specified impedance. For example, the 5-minute catchment area for a point on a network includes all the streets that can be reached within five minutes from that point.  A service are for a given point is simply the polygon areas defined by specific time limit breaks (i.e. 5, 10, 15, 20 , 25, 30, and 35 minutes).

The resulting isochrones are then intersected with profile data (point in polygon) to create the required report information. For example, population centroids within each catchment area are selected and aggregated to provide a total population count.

For more information on the Ordnance Survey data products see:
ITN - http://www.ordnancesurvey.co.uk/oswebsite/products/os-mastermap/itn-layer/index.html
Urban Path - http://www.ordnancesurvey.co.uk/oswebsite/products/os-mastermap/itn-layer/urban-paths.html

For more information on ESRI's Network Analyst see:

How can I compare outputs for a selected area of interest (AOI) against other AOIs?

The “Compare Area of Interest” is an optional parameter that can be defined for the following reports:

- Detailed Report – Facilities

- Summary Report – Facilities

The “Compare Area of Interest” enables up to 15 comparator AOIs to be selected.  To facilitate the selection of AOIs they have been grouped according to the following relationships:

 Hierarchical Relationship (The hierarchical neighbour AOIs available for selection will be those administrative authorities in ascending hierarchy from the initial AOI selected. For example: CSP(s), County, Region and National for a selected Local Authority.

-  Geographical Relationship (The AOIs whose geographic boundaries adjoin that of the selected AOI). 

-  CIPFA Relationship (The four AOIs whose CIPFA Nearest Neighbours Model score is closest to the selected AOI.  For more details on the Chartered Institute of Public Finance and Accountancy Nearest Neighbour Model see - http://www.cipfastats.net/resources/nearestneighbours/

-  Core Cities (England’s eight largest city economies outside London)

-  Full listing (All AOIs as listed within the default AOI list enabling the user to choose their own unique combination of comparison AOIs; Region, County, CSP and Local Authority AOIs.

What do the report calculation symbols mean (i.e. <=)?

The below table defines the “operators” used to create basic calculations within the Active Places Power reports.




Less than.


Less than or equal to.


Not equal to.


Greater than.


Greater than or equal to.

For example to create a detailed report of Sports Halls of the equivalent size to 5 or more badminton courts set Badminton Courts >= 5.

What information will the Map Identify tool return?

The Active Places Power interactive map includes a "Map Identify" tool (blue circle with "i") that returns information for a given location on the map.  To use the tool click on the Map Identify icon, which will change the mouse marker to include a question mark and display a tool tip.

Click anyway on the map to return inforamtion.  A default set of location information will be returned by default (see below table).  Other map layer must be set to display (within the left side Map Layers section) in order for the tool to return information on them.  The tool will automatically drill down through all map layers set displaying on the map in addition to the default information. 

If multiple results are returned for a given data layer (i.e. Census Output Areas) zoom in to a larger scale and repeat the Map Identify action.  This will return a more specific results set.

Location Details



Parliamentary Constituency Name

Cities of London and Westminster

Parliamentary Constituency Code


Ward Name


Ward Code


Local Authority Name

City of London

Local Authority Code


County Name

Greater London Authority

County Code


Region Name


Region Code




Sport England


CSP Name

London Sport

CSP Code






Output Area Code


Lower Super Output Area Code


Middle Super Output Area Code




Geographic Reference








Why is Facilities per 1000 no longer available as a Strategic Planning Tool?

It was found that this tool was used as a simplistic way of developing a local standard which often masked the need to carry out more detailed local assessment work to develop a robust standard.  An over emphasis was therefore given to the use of this tool in isolation in creating local standards.  

A reliance on this tool focusses too much on the supply side which often did not reflect the different types of facilities and their accessibility.  The National Planning Policy Framework has moved away from generic local standards for sport and recreation.  The NPPF requires a robust and up to date assessment of need for sport and recretional provision setting out actual infrastructure requirements.  

Why is Supply and Demand Balance no longer available as a Strategic Planning Tool?

The use of this tool only provided a ‘global’ view of provision within a local authority area for three facility types, which often masked other important elements such as the location, nature and quality of facilities in relation to demand.  

The need to carry out more detailed local assessment work to develop a robust standard would also need to determine how accessible facilities are to the resident population (by car and on foot) and take into account facilities in adjoining boroughs.   

The information provided by the tool is useful as a high level view when building a picture of the level of provision within the context of the Facility Planning Model National and Local Run Reports (accessible through Sport England Planning Officers) rather than in isolation.