FAQ

FAQ categories: Access | Background | Data | Mapping | Redevelopment | SDM | Technical | Tools |

What is the relationship between a site and a facility?

The Active Places database is structured so that a single site may have one or more facilities associated with it (a one to many relationship). 

A site is a location (normally addressable) at which one or more sport facilities are located.  Typically, a site will be located at a unique addressable location and both the site and all facilities associated with it have the same owner organisation.  Occasionally more than one site may exist at a location/address if two or more facilities at the location have different owner organisations.

A sport facility is either a wholly or partially built place such as a grass pitch, swimming pool, ice rink or similar where physical activity, exercise or competition takes place.

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 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

Where a facility sub-type has a unit of pitches or courts and all attributes of each facility sub-type are the same, then a single FacilityID will exist with a Number count of 2 or more.

Where more than one of the same facility sub-type exists but attributes are different then the facility sub-types will be recorded with individual FacilityIDs. 

The attributes will vary depending on facility sub-type but can include one or more of the following:  operating status, management or access type, opening hours, floodlighting, year built or refurbished date. 

The below example for Woodbridge Town FC shows a single site (i.e. Woodbridge Town FC - unique id of 6015401), which has two grass pitches each recorded as a separate facility record due to different facility attributes (3012446 being floodlit where as 20000813 is not).

Site Name

Site Id

Facility Type

Facility Sub Type

Facility Id

Unit

Number

Flootlit

WOODBRIDGE TOWN FC

6015401

Grass Pitches

Adult Football

3012446

Pitches

1

Yes

WOODBRIDGE TOWN FC

6015401

Grass Pitches

Adult Football

20000813

Pitches

1

No


Note, where pitch markings are reconfigured for the same facility sub-type resulting in the count of pitches increasing or decreasing but with no other attribute changes then the pitch count would simply be adjusted to reflect the change.  Should the pitch marking reconfiguration result in different facility sub-types being marked out then then new records with new FacilityIDs will be created.