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

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