BC Public Libraries Systems - Branches and Locations

1104 views (3 recent)

Published by the Ministry of Education - Libraries
Licensed under Open Government Licence - British Columbia

This dataset includes contact and location data for all library service points in BC. It also includes some primary data on library use and services from the most current year that data is available.

The dataset is geolocational, and is available in XLSX, CSV, and KML formats.

Data and Resources

Dataset Extent

Latitude: 48.0° to 60.0°
Longitude: -139.5° to -113.5°

Additional Information

More Information

Contact Information

Access & Security

Who can view this dataset? Public
Who can download this dataset?Public

Metadata Information

Record Published 2012-02-06
Record Last Modified 2020-11-03
Resource Status completed

Object Description

Object Name: WHSE_IMAGERY_AND_BASE_MAPS.GSR_PUBLIC_LIBRARY_LOCS_SV

Short Name: GSRPUBLICL
Comments: GSR_PUBLIC_LIBRARY_LOCS_SV is a spatially enabled point dataset identifying public library service point locations (public library branch or material drop-off location) in British Columbia

Column Name Short Name Data Type Data Precision Comments
SERVICE_POINT_ID SP_ID VARCHAR2 20 A unique occupant ID for the library, supplied by the source data system, e.g., BABM001.
SERVICE_POINT_NAME SP_NAME VARCHAR2 500 The name of the public library service point, which could be a public library branch or material drop-off location, e.g., George Mackie Library.
LIBRARY_SYSTEM_NAME LIB_SYSTEM VARCHAR2 100 The name of the public library system, e.g., Fraser Valley Regional Library.
STREET_ADDRESS ADDRESS VARCHAR2 200 The address of where the library is located, consisting of the site descriptor (e.g. unit), and the civic building number / street / street indicator portion of an address, e.g., Unit 1, 123 Main Street East.
LOCALITY LOCALITY VARCHAR2 100 The name of the municipality, community, Indian reservation, subdivision, regional district, aboriginal lands, or natural feature the occupant site is located in, e.g., Victoria, Saanich IR 1, Capital Regional District.]
POSTAL_CODE POSTAL_CD VARCHAR2 10 The Canadian Postal code value associated with the physical address, e.g., V9Z 2K1
WEBSITE_URL WEBSITE VARCHAR2 500 The full URL link to the home page of the library.
LATITUDE LATITUDE NUMBER 9 The geographic coordinate, in decimal degrees (dd.dddddd), of the location of the feature as measured from the equator, e.g., 55.323653
LONGITUDE LONGITUDE NUMBER 10 The geographic coordinate, in decimal degrees (-ddd.dddddd), of the location of the feature as measured from the prime meridian, e.g., -123.093544
COMPUTERS COMPUTERS NUMBER 9 The number of public computers available at a library service point.
PRINTERS_COPIERS PRINT_COPY NUMBER 9 The number of public printers and photocopiers available at a library service point.
CARD_SERVICES_IND CARD_SERVC VARCHAR2 5 Indicates whether the library service point offers card services, i.e., Y (true), N (false).
CHECKOUT_IND CHECKOUT VARCHAR2 5 Indicates whether the library service point offers check out services, as opposed to deposit-only locations, i.e., Y (true), N (false).
WIFI_IND WIFI VARCHAR2 5 Indicates whether the library service point offers free public wifi, i.e., Y (true), N (false).
OUTREACH_IND OUTREACH VARCHAR2 5 Indicates whether the library service point offers outreach services (such as a mobile library or book delivery service), i.e., Y (true), N (false).
ACCESSIBILITY_IND ACCESSBLTY VARCHAR2 5 Indicates whether the library service point is wheelchair accessible, i.e., Y (true), N (false).
THINGS_IND THINGS VARCHAR2 5 Indicates whether the library service point has a Library of Things, i.e., Y (true), N (false).
MAKERSPACE_IND MKRSPACE VARCHAR2 5 Indicates whether the library service point offers a public Maker Space, i.e., Y (true), N (false).
CUSTODIAN_ORG_DESCRIPTION CUST_ORG VARCHAR2 200 CUSTODIAN_ORG_DESCRIPTION contains the name or description of the custodial organization e.g. Ministry of Agriculture.
BUSINESS_CATEGORY_CLASS BUS_CAT_CL VARCHAR2 1000 BUSINESS_CATEGORY_CLASS is the designation that the business belongs to. E.g. accommodationFoodServices.accommodations or educationalServices.multiLevelSchool
BUSINESS_CATEGORY_DESCRIPTION BUS_CAT_DS VARCHAR2 1000 BUSINESS_CATEGORY_DESCRIPTION is the description that applies to its corresponding BUSINESS_CATEGORY_CLASS. E.g. Tourist accommodations for class accommodationFoodServices.accommodations.
OCCUPANT_TYPE_DESCRIPTION OCCPNT_TYP VARCHAR2 500 OCCUPANT_TYPE_DESCRIPTION contains the description of the occupant type e.g. Hospital
DATE_UPDATED DATE_UPDT DATE 7 DATE_UPDATED contains the date that the Occupant data was updated in the Occupant structure (system-generated)
SHAPE SHAPE SDO_GEOMETRY 64 SHAPE is the column used to reference the spatial coordinates defining the feature.
OBJECTID OBJECTID NUMBER 10 OBJECTID is a column required by spatial layers that interact with ESRI ArcSDE.
SE_ANNO_CAD_DATA BLOB 4000 SE ANNO CAD DATA is a binary column used by spatial tools to store annotation, curve features and CAD data when using the SDO GEOMETRY storage data type.