FAQs - SDM

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

What are the facility Access Type definitions?

Access Types are defined as:

AccessibilityID 1 - Free Public Access - There is no charge to use the facility

AccessibilityID 2 - Pay and Play - The main means of public access to the facility is on payment of a charge.  The facility may also have a membership scheme, and it may be possible to block book the facility for a specific activity or for lessons, but during the public opening hours anyone can just turn up, pay and play. 

For example: Local authority swimming pool or health and fitness facility, where the casual user pays per session, although there is also a membership scheme.

AccessibilityID 3 - Sports Club/Community Association use - The main means of public access to the facility is via sports clubs or community associations, which book it for use by their members.  Membership of the club or association is based on a particular sport or community group, and is not based on performance criteria or on a particular facility.  The club or association may use several different facilities.

For example: Access to indoor bowls greens is through a bowls club, or to athletics tracks through an athletics club.  School swimming pool that can be used by a swimming or sub-aqua club, but cannot be used by the general public.

AccessibilityID 4 - Registered Membership use - The main public access to the facility is by membership.  Members usually pay a joining fee as well as a monthly or annual subscription.  Membership is controlled by the owner or manager of the facility.

For example: Fitness First health and fitness facility can only be used by registered members

AccessibilityID 5 - Private use - The facility cannot be used by the public, either on a pay and play basis or through a recreational club, except when playing against the owner of the site.  It may be available for use by elite clubs or development squads.   

For example: School grass pitches that are only available for the school teams and the teams they are playing against.  University, prison, MOD etc facilities that are not available for public use.

AccessibilityID 6 - Not Known

Access Types are grouped into the following categories:

  • Public Access (AccessibilityID 1 to 4)
  • Private (AccessibilityID 5 only)
  • Not Known (AccessibilityID 6 and NULL)

What are the facility Management Type definitions?

Generally there is one management type for each site.  Sometimes there may be more than one (e.g. outdoor facilities are managed by the LEA but indoor facilities are handled by a private contractor).  

    Management Types are defined as:  

    MgmtTypeID 1 - School/College/University (in house) - Managed by the school/college themselves.  Community access to these facilities are often limited to fit around curriculum/University use

    MgmtTypeID 2 - Local Authority (in house) - Managed by Local Authority using their own staff. 

    MgmtTypeID 3 - Private Contractor (PPP/PFI) - Facility managed by a private contractor as part of the Public Private Partnership / Private Finance Initiative. PPP/PFI  is a partnership between the public and private sector for the purpose of delivering a project or service traditionally provided by the public sector.  This is an arrangement whereby the public sector pays the contractor to build and run a facility for a set period (25 years), after which the facility is handed back to the public sector.  This arrangement is increasingly common with the development of new schools and some Local Authority Leisure Provision.

    MgmtTypeID 4 – Trust - Charitable Trust set up to run sports facilities.  A number of Local Authorities have set up Leisure Trusts to run their leisure centres.  These Trusts benefit from charitable status and work outside the Local Authority structure.  The Local Authority remains the owner of the facility.

    MgmtTypeID 5 - Sport Club - Where the facility is managed by a sports club.

    MgmtTypeID 6 - Commercial Management - Where the facility is managed by a commercial company, such as commercial health clubs.  There are also Local Authority Facilities which have been contracted in to manage Local Authority Leisure Centres. 

    MgmtTypeID 7 - CSSC - Civil Service Sports Council provides sports facilities for employees in Government departments and agencies, the Post Office, BT and many other public bodies and in many companies carrying out ex-civil service work. The CSSC is the largest corporate provider of sport and leisure in the UK and have a network of sports facilities across the country.

    MgmtTypeID 8 - Community Organisation - Facilities that are managed and run by Community Organisations, such as community associations and user groups. 

    MgmtTypeID 9 - Industry Sports Club - Facilities which are managed by an Industrial/Commercial Company for the benefit and use by its staff.  Use of these facilities are often limited to family members of employees.

    MgmtTypeID 10 - Health Authority - Facilities which are managed by the Health Authority.

    MgmtTypeID 11 – MOD - Facilities on MOD sites managed by Armed Forces.  Limited community availability.

    MgmtTypeID 12 - Other - Other types of management

    MgmtTypeID 13 - Not Known - Facilities where the management type is not known.


    Management types are grouped into the following categories:

    • Education – (MgmtTypeID 1)
    • Local Authority– (MgmtTypeID 2)
    • Trust – (MgmtTypeID 4)
    • Commercial – (MgmtTypeID 6)
    • Others – (MgmtTypeID 3, 5, 7 to 12)
    • Not Known – (MgmtTypeID13 and Null)




    What are the facility Operational Status definitions?

    Operational Status means the functional status of a facility.  The Operational Status of a facility is defined as:

    FacStatusID 1 - Planned

    FacStatusID 2 - Under Construction

    FacStatusID 3 - Operational

    FacStatusID 4 - Temporarily Closed

    FacStatusID 5 - Closed

    FacStatusID 6 - Does not appear to meet Active Places criteria*

    FacStatusID 7 - No Grass Pitches Currently Marked Out

    FacStatusID 8 - Not Known

    * The “Does not appear to meet Active Places criteria” means that the data collected under further inspection has been found to not meet the definitions of the facility type/sub type as defined in the Sports Data Model e.g. it is an AGP where the length is too small etc. It is not a reflection of the quality or it failing to meet a certain design standard. The definitions of the facility types can be found under Help > Sports Data Model (SDM).


    What are the facility Ownership Type definitions?

    Ownership Types are defined as:  

    (Note, for educational establishments the education type is taken from the Type of Establishment code in Edubase).  

    OwnerTypeID 1 - Local Authority - Facilities owned by the Local Authority, to include District, Borough, County and Unitary Councils

    OwnerTypeID 2 - Community school - Similar to former County schools. LEA employs the school’s staff, owns the school’s land and buildings and is the admissions authority (it has primary responsibility for deciding the arrangements for admitting pupils.

    OwnerTypeID 3 - Voluntary Aided School - Similar to former aided schools. The governing body is the employer and the admissions authority. The school’s land and buildings (apart from playing fields which are normally vested in the LEA) will normally be owned by a charitable foundation.

    OwnerTypeID 4 - Voluntary Controlled School - Very similar to former controlled schools. The LEA is the employer and the admissions authority. The school’s land and buildings (apart from the playing fields which are normally vested in the LEA) will normally be owned by a charitable foundation.

    OwnerTypeID 5 - Foundation School - At foundation schools the governing body is the employer and the admissions authority. The school’s land and buildings are either owned by the governing body or by a charitable foundation.

    OwnerTypeID 6 - City Technology College - Independent all- ability, non fee-paying schools for pupils aged 11-18. Their purpose is to offer pupils of all abilities in urban areas across England the opportunity to study successfully a curriculum geared, with the help of private sector sponsors, towards the world of work. Also encouraged to innovate in the development, management and delivery of the curriculum.

    OwnerTypeID 7 - Community Special School - Is the special school equivalent of mainstream Community schools yet are catered wholly or mainly for children with statutory statements of special educational needs.

    OwnerTypeID 8 - Non-Maintained Special School - Independent special schools approved by the Secretary of State for Education and Skills. They are run on a not-for-profit basis by charitable trusts and normally cater for children with severe and/or low incidence special educational needs.

    OwnerTypeID 9 - Independent School approved for SEN Pupils - A special school equivalent of Other Independent catering wholly or mainly for children with statutory statements of special educational needs. Has been approved by the DfES for SEN provision.

    OwnerTypeID 10 - Other Independent Special School - A special school equivalent of Other Independent catering wholly or mainly for children with statutory statements of special educational needs.

    OwnerTypeID 11 - Other Independent School - Any school which provides full time education for 5 or more pupils of compulsory school age, which is not maintained by a local education authority or a non-maintained special school.

    OwnerTypeID 12 - Foundation Special School - A special school equivalent of the mainstream Foundation school catering wholly or mainly for children with statutory statements of special educational needs.

    OwnerTypeID 13 - Pupil Referral Unit - Any school established and maintained by a local authority which Is specially organised to provide education for children who are excluded, sick or otherwise unable to attend mainstream school and Is not a county or special school.

    OwnerTypeID 14 - LEA Nursery School - Is maintained by a local education authority and is not a special school, providing education for children who have attained the age of 2 but are under compulsory school age.

    OwnerTypeID 15 - Playing for Success - Through Playing for Success, the DfES is establishing out of school hours study support centres within top football clubs and at other sports’ clubs grounds and venues. The centres use the environment and medium of football to help motivate pupils identified by their schools, as being in need of a boost to help them get back up to speed in literacy and ICT.

    OwnerTypeID 16 - Academy Sponsor Led - Academies are all-ability, state-funded schools established and managed by sponsors from a wide range of backgrounds, including high performing schools and colleges, universities, individual philanthropists, businesses, the voluntary sector, and the faith communities

    OwnerTypeID 17 - EY Setting - Early Years settings include private and voluntary day nurseries, pre-schools, playgroups, childminding networks, portage services and Local Authority day nurseries. The database only lists EY Settings that are registered with the Early Years Development Plan and Childcare Partnerships.

    OwnerTypeID 18 - Further Education

    OwnerTypeID 19 - Higher Education Institutions

    OwnerTypeID 21 - Miscellaneous Education

    OwnerTypeID 22 - Secure Units

    OwnerTypeID 23 - Sixth Form Centres

    OwnerTypeID 24 - Commercial - Site owned by a commercial company .

    OwnerTypeID 25 - Sports Club - Site owned by a sports club.

    OwnerTypeID 26 - Community Organisation - Facilities that are owned and run by Community Organisations, such as community associations and user groups. 

    OwnerTypeID 27 - Government - Sites which are owned by Government Departments, excluding Local Authority site & MOD sites.

    OwnerTypeID 28 - Industry (for employees) - Facilities which are owned by an Industrial/Commercial Company for the benefit and use by its staff.  Use of these facilities are often limited to family members of employees.

    OwnerTypeID 29 - Health Authority - Facilities which are owned by the Health Authority.

    OwnerTypeID 30 - MOD - Facilities owned by the MOD. 

    OwnerTypeID 31 - Other - Other types of ownership

    OwnerTypeID 32 - Not known - Sites where the ownership is not known

    OwnerTypeID 33 - Academy Convertors - All schools that have chosen through Governing Body Resolution and application to the Secretary of State to become an Academy under the Academies Act 2010.

    OwnerTypeID 34 - Academy Free Schools - Free Schools are all-ability state-funded schools set up in response to parental demand. The most important element of a great education is the quality of teaching and Free Schools will enable excellent teachers to create schools and improve standards for all children, regardless

    OwnerTypeID 35 - Academy Specials - Special Schools that have chosen through Governing Body Resolution and application to the Secretary of State to become an Academy under the Academies Act 2010. These will be handled differently to Academy convertors and will follow a different process which is currently being developed

    OwnerTypeID 36 - Special College


    Ownership types are grouped into the following categories:

    • Local Authority – (OwnerTypeID 1)
    • Education – (OwnerTypeID 2 to 23 and 33 to 36)
    • Commercial – (OwnerTypeID 24)
    • Sports Club – (OwnerTypeID 25)
    • Community Organisation – (OwnerTypeID 26)
    • Others – (OwnerTypeID 27 to 31)
    • Not Known – (OwnerTypeID 32 and Null)

     


    What is the relationship between a site and a facility?

    The Active Places database base in structured so that a single site may have one or more facilities associated with it (a one to many relationship).  Each site and each individual facility sub type will have a unique ID.  As the below example shows these numbers may be very similar but never the same.

    The below example for Aireville School in North Yorkshire CSP shows a single site (i.e. Aireville School - unique id of 1010263), which has three sports hall facilities - one main hall (2008384) and two activity halls (2026284 and 2026285).

    Site Name

    Site Id

    Facility Type

    Facility Sub Type

    Facility Id

    Unit

    Number

    Facility Status

    AIREVILLE SCHOOL

    1010263

    Sports Hall

    Main

    2008384

    Badminton courts

    3

    Operational

    AIREVILLE SCHOOL

    1010263

    Sports Hall

    Activity Hall

    2026284

    Badminton courts

    1

    Operational

    AIREVILLE SCHOOL

    1010263

    Sports Hall

    Activity Hall

    2026285

    Badminton courts

    1

    Operational


    What is the Sport Data Model (SDM)?

    The Active Places sport facility database is a complex relational database.  The individual database tables, their contents and relationships are defined within the Sport Data Model (SDM).   

    The SDM is available for download as an Excel spread sheet (see Help menu > SDM) and should be referenced by users of the data in particular those who download and use the data for local analysis or integration with other applications.  


    What type of sport facilities does Active Places hold information on?

    The Active Places Database currently holds information on 14 facility types, each of which has one or more sub types.  They are listed below.  The Active Places Sport Data Model defines additional facility types and Sport England is actively working to introduce data for these facility types.

    Id

    Facility Type

    Description

    Id

    Facility Sub-Type

    Description

    1

    Athletics Tracks

    Permanently constructed all weather 400m outdoor running track with a minimum number of 4 lanes. Does not include tracks that are seasonally marked out on grass or short (200m) training tracks that are marked out on Synthetic Turf pitches.

    1001

    Synthetic

    Tracks made from acrylic man made material. Surfaces give greater cushioning for runner and are the most modern form of track.   Synthetic tracks are gradually replacing cinder and grass tracks.  This surface is also called 'Tartan'.

     

    1002

    Cinder

    Tracks made from unbound material, such as cinder.  This category includes Redgra (natural aggregate dressing), shale and 'real cinder' tracks. 

     

     

     

    1003

    Permanent Grass

    Tracks that are permanently marked out on grass.   Does not include running tracks which are seasonally marked out during the summer; this tends to be the case which many school tracks.

    2

    Health and Fitness Suite

    Normally a minimum of 20 stations, although some small health & fitness suites may be included.

    2001

    Health and Fitness Suite

    A room or rooms with cardiovascular and/or resistance stations, and possibly also free weights and stretching areas.

    3

    Indoor Bowls

    Permanent indoor facility which contains a carpeted bowls green area.  Can be a purpose built bowls centre or dedicated bowls area within a sports facility.   The bowls green area must be specifically constructed for bowls use.  Does not include short matt bowls areas, which are temporarily laid out in multipurpose halls. 

    3002

    Indoor Bowls

     

    4

    Indoor Tennis Centre

    Covered or indoor tennis courts, includes standalone indoor tennis structures, purpose built tennis centres and indoor courts connected to other sports facilities, such as sports clubs.  To only include dedicated indoor tennis courts, and not multi use halls or outdoor MUGA's which are marked out as tennis courts. 

    4001

    Airhall

    Unframed fabric structure which requires inflating to form its shape.  Commonly referred to as 'Bubbles'. Can be over existing outdoor courts. Most cost effective way to provide indoor court. Most common type of non-traditional indoor court.

     

    4002

    Airhall (seasonal)

    As above, but only inflated part of the year.

     

    4003

    Framed Fabric

    Steel frame covered with fabric. Permanent structure which does not require 'inflating'.

     

     

     

    4004

    Traditional

    Permanent structure which is not fabric. Traditional steel/timber framed and block structure.

    5

    Grass Pitches

    A grass that is marked out for at least part of the year as a pitch for a particular sport, upon which a match could be played.  Does not include Artificial Grass Pitches (these should be included in AGPs).  Does not include grass pitches of less than 0.4 hectares.

    5001

    Full sized Football

    Minimum size 90m x 46m, max 120m x 90m

     

    5002

    Junior Football

    Minimum size 70 x 42, max 82 x 56

     

    5003

    Cricket

    A grass area that is has a marked out cricket square for at least part of the year and upon which a cricket match can be played.  Minimum size 46 x 46

     

    5004

    Senior Rugby League

    Minimum size 88m x 55m (recreational) max 122m x 68m (inc goal area)

     

    5005

    Junior Rugby League

     

    5006

    Senior Rugby Union

    71m x 44m min to 144m x 70m max (inc in goal area) (exc run offs)

     

    5007

    Junior Rugby Union

    60m x 30m min to 70m x 43m max  (inc in goal area) (exc run offs)

     

    5008

    Australian Rules Football

    135m x 110m min to 185m x 155m max (exc run offs)

     

    5009

    American Football

    109.73 x 48.77m min (exc run off)

     

    5010

    Hockey

    91.4m x 55m (exc run off)

     

    5011

    Lacrosse

    100m x 55m (men), 100m x 50m min to 122 x 60m max (women) (exc run offs)

     

    5012

    Rounders

    40m x 60m min (min 30m boundary) to 60m x 100m senior max (min 50m boundary),

     

    5013

    Baseball

    21.34m x 21.34m to 27.43m x 27.43m max (diamond) (exc run off & outfield)

     

    5014

    Softball

    16.76m x16.76m to 19.81m x 19.81m max (diamond) (exc run off & outfield)

     

    5015

    Gaelic Football

    130m x 80m min to 145m x 90m max (exc run offs)

     

    5016

    Shinty

    128m x 64m min to 155m x 73 max 9 (exc run offs)

     

    5017

    Hurling

    130m x 80m min to 145m x 90m max (exc run offs)

     

    5018

    Polo

    230m x 146m min to 275m x 183m max (exc run offs)

     

    5019

    Cycling Polo

    120m x 80m min to 150m x 100m max (exc run offs)

     

    5020

    Mini Soccer

    Minimum 27.45m x 18.3m , max 54.9m x 36.6m

     

    5021

    Mini Rugby

    70m x 30m min to 70m x 35m max (inc in goal area) (exc run offs)

     

     

     

    5022

    Nine v Nine

    64m x 46m min, 82m x 46m max (exc run offs)

    6

    Sports Hall

    Indoor multi-sports hall where a range of sport and recreational activities are carried out. 2 or more of the sport and recreational activities must be from the list of Activities, one or more of which must be on at least a weekly basis. One hall per site must be at least 18x10m, the size of one badminton court including surrounding safety area. Includes specifically designed sports halls, such as leisure centres and school sports halls, and also additional halls where activities can take place, such as school assembly halls, community buildings and village halls.  Specialist centres, e.g. dance centres, are not included. Includes other structures which may have been developed for other purposes but are now being used as a permanent sports hall (Barn).

    6001

    Main

    Main multi-sports hall(s) within site.  Minimum size is marked out as 3 Badminton courts and above. Dimensions Min width 18m, max width 70m, Min Length 27m Max length 90m

    6002

    Activity Hall

    This is a multi-sports hall (below 3 badminton courts) where activities take place that does not qualify as a main hall and is not a purpose built studio.  It can include Community/Village halls. It should be between the following dimensions: min width 9m, max width 18m, min length 17m, max length 26m. It may or may not be marked out.

     

     

     

     

    Barn

    Marked out with Minimum size of 4 badminton courts or 1 basketball court, or 1 netball court or 1 volleyball court. These are buildings which did not start out life as a dedicated sports hall but are now used for that purpose. Typically the dimensions of the building are much greater than the courts they contain. May include courts marked out in the middle of a indoor velodrome or indoor running track.

    7

    Swimming Pool

    Enclosed area of water, specifically maintained for all forms of water based sport & recreation.  Includes general swimming, teaching, training, diving, club use and school use.  Includes indoor and outdoor pools, freeform leisure pools, and specific diving tanks. Where an area of a pool is normally cordoned off as a purpose-built off-shoot of the main rectangular tank, e.g. diving section off a main pool, it is treated as a separate pool.

    7001

    Main/General

    Indoor only.  Principle pool(s) within site.  Minimum length is 15m.  Pool must be traditional rectangular tank.  Where a main pool has had flumes/slides fitted, provided the pool is rectangular in shape, it should be classified as a 'Main/General' pool.

    7002

    Leisure Pool

    Indoor only.  A pool which has a freeform, curved shape on the majority of its sides.  These pools are primarily designed for informal recreational swimming and may include flumes, slides, beach areas, water jets, wave machines.   Some leisure pools may have been designed to allow lane swimming within a specific area of the pool. These pools should be classified as 'leisure' where the majority of its sides are freeform.  If lanes are present, these should be counted, and the length recorded.

    7003

    Learner/Teaching/Training 

    Indoor only.  Either less than 15m in length, or a secondary pool within site. Smaller and generally shallower than Main pool, and traditionally rectangular in shape.  May have stepped/shallow area for infant use.  Record number of lanes if present.

    7004

    Diving

    Indoor only.  Pool specifically designed for diving.  Pools are usually square and deeper than main pools.

    7005

    Lido

    Public open-air pool. Includes ponds which have roped off section e.g. Hampstead. May be seasonal and only opened for six months of year. When shut status should be marked as Temporarily closed.

    8

    Artificial Grass Pitch

    Synthetic alternative to grass, providing an all-weather surface for pitch sports, in particular, hockey and football. Pitches must be a minimum of 75m x 45m and be floodlit.  Does not include other non-turf surfaces, such as tarmac, concrete, Redgra (natural aggregate dressing).  Where there are two pitches within one site, of the same sub type but different measurements, these should be entered as separate facilities.

    8001

    Sand Filled

    20-25mm tufted carpet covered filled with graded sand laid over a rubber shock pad and engineering base. Most common surface for STP's, used in particular for hockey & football, but can be used by other activities, such as American Football, Lacrosse, and training for Rugby and Athletics.

    8002

    Water Based

    Similar pile to sand based, very dense synthetic sports surfaces that are irrigated with water. Combined with some form of underlay/shock-pad, sometimes integral. The carpets or the pad are typically designed to hold up the water flow at a specific rate.  This is the preferred surface for Hockey and is used for first class games.

    8003

    Rubber crumb pile (3G)

    50mm - 65mm long pile carpet filled with rubber crumb/sand. Generically named 'Third Generation' pitches. Used predominantly for football, but can be used for other sports such as rugby.     

     

     

     

    8004

    Sand Dressed

    This has sand base rather than sand infilling. A sand dressed pitch has a heavier amount of fibres which are more exposed, giving it a greener appearance. This is the preferred surface for club hockey

    9

    Golf

    All golf courses with a minimum number of 9 holes, and driving ranges

    9001

    Standard

    A standard par course, with a minimum of 9 holes.

    9002

    Par 3

    Shorter length of holes than the standard course, where no hole is over Par 3.

     

     

     

    9003

    Driving Range

    Includes covered and uncovered driving bays. Range must have a minimum of 10 driving bays. Ranges based on hire of balls by the bucket, and user does not retrieve balls.  Does not include practise areas within golf courses.

    10

    Ice Rinks

    All permanent ice rinks.  Does not include temporary ice rinks such as the one at Somerset House.

    10001

    Ice Rinks

     

    11

    Ski Slopes

    A slope for skiing; natural slopes may be seasonal.  Does not include cross-country skiing tracks.

    11001

    Outdoor Artificial

    Permanent outdoor artificial slope

    11002

    Outdoor Natural

    Seasonal outdoor ski slope; must be equipped with a tow.

     

     

     

    11003

    Indoor

    Indoor ski slope;  snowdome

    12

    Studio

    A purpose built studio where classes are held for a range of activities such as yoga, aerobics, spinning, martial arts etc.  Normally it has a sprung floor and/or mirrors. It must be at a site that also has another Active Places facility. 

    12001

    Studio

     

    13

    Squash Courts

    Purpose build court(s) designed for playing squash.  A Squash court is a rectangular box with four vertical walls of varying height, being the Front Wall, Side Walls and Back Wall.  It has a level floor and a clear height above the court area.  Minimum dimensions are 9.74m x 6.39m.  The clear height above finished floor level (i.e. the height to the underside of the lowest obstruction) over the whole of the court must be not less than 5.64m.

    13001

    Glass-backed

    The court has a glass or transparent back wall

     

     

     

    13002

    Normal

    Definition to follow

    17

    Tennis Courts

    Marked out for tennis only, these should be one full size court with safety margins and be fenced. May be floodlit.

    17001

    Tennis Courts

    Marked out surface with minimum of 34.75m x 16.75m