Public Buildings

359 views (2 recent)

Published by the Non-government - GIS Innovations
Licensed under Access Only

Point layer of Public Buildings within BC

Data and Resources

Dataset Extent

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

Additional Information

Purpose

To determine the location of public buildings in BC

Contact Information

NameAaronMcMillan (pointOfContact)
EmailAaron.McMillan@gov.bc.ca
OrganizationNon-government
Sub-OrganizationGIS Innovations

Access & Security

Who can view this dataset? Government
Who can download this dataset?Government

Metadata Information

Record Published 2014-12-15
Record Last Modified 2017-04-12
Resource Status onGoing

Object Description

Object Name: WHSE_IMAGERY_AND_BASE_MAPS.DRP_PUBLIC_BUILDINGS_SP

Short Name: DRPPBLCBLD

Column Name Short Name Data Type Data Precision Comments
PUBLIC_BUILDING_ID PBLCBLDNGD NUMBER 38 PUBLIC BUILDING ID contains a unique value populated from a sequence by a trigger
BUILDING_NAME BLDNGNM VARCHAR2 80 BUILDING NAME contains the name of the building or centre e.g. Beaver Valley Community Policing Station
BUILDING_GROUP BLDNGGRP VARCHAR2 12 BUILDING GROUP contains a general description of the group using the building e.g. ambulance
BUILDING_TYPE BLDNGTP VARCHAR2 20 BUILDING TYPE contains a description of the specific use of the building e.g. prison
ADDRESS_NUMBER DDRSSNMBR VARCHAR2 10 ADDRESS NUMBER contains the address number of the building e.g. 80
ADDRESS_ROAD DDRSSRD VARCHAR2 50 ADDRESS ROAD contains the name of the road on which the building is located .
CITY CITY VARCHAR2 30 CITY contains the name of the city in which the building is located.
GEOMETRY GEOMETRY SDO_GEOMETRY 1 GEOMETRY is the column used to reference the spatial coordinates defining the feature.
OBJECTID OBJECTID NUMBER 38 OBJECTID is a required attribute of feature classes and object classes in a geodatabase.
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.