A subset of the data stored in the Porowhitā Hauwha table called facilities_attributes.
The need for a separate table to store information (or attributes) about facilities is because assets, spaces, and entities have common fields; managing those fields here simplifies the process of managing the data.
This data has been made available for use in package documentation examples, and for the user to explore the kind of information stored in the live Porowhita Hauwhā database.
Format
'test_facilities_attributes'
A data frame with 5 rows and 9 columns:
- id
Unique identifier. This is the primary key for the table.
- property_code
- provider_legal_status_number
- entry_access_type
- facility_type
Describes whether this facility is an asset, a space, or an entity.
- facility_id
A foreign key for joining to the relevant facilities table, as defined by
facility_type.- designation
Describes the function of this facility, for example "Rural Hall", "Community Library", "Room" etc.
- delivery_model
Categorises the facility as either community-led or Council-led. A community-led facility is operated by community partners.
- facility_ownership
Describes whether the facility is owned by Council, by Kainga Ora, or is privately owned.
- staffed
Is the facility staffed during opening hours (
TRUE) or not (FALSE)?- closed
Is the facility currently closed to the public (
TRUE) or not (FALSE)?- leased
Is there a community lease agreement in place for this facility (
TRUE) or not (FALSE)?