178 views (3 recent)Published by the Ministry of Forests, Lands, Natural Resource Operations and Rural Development - GeoBC
Licensed under Open Government Licence - British Columbia
Data and Resources
BC Geographic Warehouse Custom Downloadother
WMS getCapabilities requestwms
For use in viewers such as ESRI tools Click here for information on how to...
KML Network Linkkml
For use in viewers such as Google Earth Click here for information on how...
This dataset provides location data for prisons, pretrial custody and youth custody facilities in British Columbia.
The location of correctional facilities is tracked in the sites database at GeoBC. This database identifies the physical location of the building or the access point to the property (for emergency response). This dataset is updated at the beginning of each month.
|Name||Joy Sinnett (pointOfContact)|
|Organization||Ministry of Forests, Lands, Natural Resource Operations and Rural Development|
Access & Security
|Who can view this dataset?||Public|
|Who can download this dataset?||Public|
|Record Last Modified||2019-09-05|
Object Name: WHSE_IMAGERY_AND_BASE_MAPS.GSR_CORRECTNL_FACILITIES_SV
Short Name: CRRCTNL_FA
Comments: GSR_CORRECTNL_FACILITIES_SV is a spatially enabled layer comprising Correctional Facilities. Correctional Facilities is a point dataset identifying prisons, pretrial custody and youth custody facilities in British Columbia.
|Column Name||Short Name||Data Type||Data Precision||Comments|
|FACILITY_NAME||FCLTY_NM||VARCHAR2||500||FACILITY_NAME is the name of the correctional facility.|
|KEYWORDS||KEYWORDS||VARCHAR2||1000||KEYWORDS contains text strings supplied by the Custodian, to be used for search/query purposes. Keywords are separated by the ; delimiter.|
|STREET_ADDRESS||ST_ADDRESS||VARCHAR2||200||STREET_ADDRESS is a free form expression 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||LOCALITY is the name of the municipality, community, Federal Indian Reserve (IR), subdivision, regional district, indigenous land or natural feature the occupant site is located in, e.g., Victoria, Saanich IR 1, Capital Regional District.|
|MAILING_ADDRESS||MAIL_ADD||VARCHAR2||1000||MAILING_ADDRESS contains an address string, not a parsed address. It is the address that will be displayed for presentation purposes, e.g., 32900 Marshall Road, Abbotsford, BC|
|WEBSITE_URL||WEBSITE||VARCHAR2||500||WEBSITE_URL contains the link to the Home page of the Occupant's Website|
|IMAGE_URL||IMAGE_URL||VARCHAR2||500||IMAGE_URL contains a full URL link to a picture of the Occupant's Location.|
|LATITUDE||LATITUDE||NUMBER||9||LATITUDE is 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||LONGITUDE is the geographic coordinate, in decimal degrees (-ddd.dddddd), of the location of the feature as measured from the prime meridian, e.g., -123.093544|
|CORRECTIONAL_FACILITY_TYPE||COR_FAC_TY||VARCHAR2||50||CORRECTIONAL_FACILITY_TYPE is the type of facility, e.g., Pretrial, Youth Custody|
|PHYSICAL_ADDRESS||ADDRESS||VARCHAR2||1000||PHYSICAL_ADDRESS contains the civic or non-civic address as a single string, structured according to the specification of the Physical Address and Geocoding Standard, e.g., 420 GORGE RD E, VICTORIA, BC.|
|DATE_UPDATED||DT_UPDATE||DATE||7||DATE_UPDATED contains the date that the Occupant data was updated in the Occupant structure (system-generated)|
|SITE_GEOCODED_IND||GEOCD_IND||VARCHAR2||1||SITE_GEOCODED_IND contains a Flag/indicator (Y/N) that the Occupant Physical Address has been geo-coded by the DataBC Address Geocoder and the results provide a valid site address, e.g., Y, N|
|SOURCE_DATA_ID||SRCDATA_ID||VARCHAR2||20||SOURCE_DATA_ID is a unique occupant id either supplied by the source data system or produced by GSR, depending on the value of SUPPLIED_SOURCE_ID_IND|
|CUSTODIAN_ORG_DESCRIPTION||CUST_ORG||VARCHAR2||200||CUSTODIAN_ORG_DESCRIPTION contains the name or description of the custodial organization (usually Ministry and Branch)|
|BUSINESS_CATEGORY_CLASS||BUS_CAT_CL||VARCHAR2||1000||BUSINESS_CATEGORY_CLASS designates the category of business, i.e., CorrectionalFacilities|
|BUSINESS_CATEGORY_DESCRIPTION||BUS_CAT_DS||VARCHAR2||1000||BUSINESS_CATEGORY_DESCRIPTION describes the category of business, i.e., Correctional Facilities|
|OCCUPANT_TYPE_DESCRIPTION||OCCPNT_TYP||VARCHAR2||500||OCCUPANT_TYPE_DESCRIPTION contains the description of the occupant type, e.g. Hospital|
|SHAPE||SHAPE||SDO_GEOMETRY||64||SHAPE is the column used to reference the spatial coordinates defining the feature.|
|SEQUENCE_ID||SEQ_ID||NUMBER||10||SEQUENCE_ID contains a value to distinguish occupant instances. Where a single occupant can have multiple instances (representing different services, for example), this field distinguishes this occupant instance from other instances of the same or different occupants.|
|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.|