Access & Security

Metadata Information

Record Published

2016-12-01

Record Last Modified

2019-12-17

Resource Status

completed

Object Description

Object Name: WHSE_ADMIN_BOUNDARIES.EBC_VOTING_AREAS_BS10_POLY_SVW

Short Name: VOT_AREAComments: EBC_VOTING_AREAS_BS10_POLY_SVW contains information about provincial areal (polygonal) voting areas in British Columbia, including non-spatial information and spatial information (boundary linework). Data is restricted to a single boundary set (10).

Column Name

Short Name

Data Type

Data Precision

Comments

VOTING_AREA_POLY_ID

VTNG_R_ID

NUMBER

10

VOTING_AREA_POLY_ID is a system generated unique identification number.

BOUNDARY_SET_ID

BNDRY_S_ID

NUMBER

10

BOUNDARY_SET_ID Identifies the boundary set to which this voting area definition applies, e.g., 8. It is a foreign key to EBC_BOUNDARY_SETS

ED_ABBREVIATION

ED_BBRVTN

VARCHAR2

3

ED ABBREVIATION is the electoral district name abbreviation, e.g., 'VTS'

VA_CODE

VA_CODE

VARCHAR2

4

VA_CODE is the voting area code; uniquely identifies a voting area within a boundary set and electoral district. The value is 3-digit leading zero numeric with an optional single character suffix. E.g., '020', '020S'

EDVA_CODE

EDVA_CODE

VARCHAR2

7

EDVA_CODE Is a string concatenation of the ED ABBREVIATION and VA CODE, e.g., 'VTS020S'

VA_TYPE

VA_TYPE

VARCHAR2

20

VA TYPE Is the type of voting area: 'Areal' for features in this table

DATA_ACCESS_LEVEL

DT_CCSS_LL

VARCHAR2

10

DATA_ACCESS_LEVEL defines the level of system access: Public (may be displayed through the BCEDE service), or Restricted (may not be displayed through the BCEDE service). The Point VAs may be displayed through BCEDE; the SVAs may not.

GAZETTE_DATE

GZTT_DTE

DATE

7

GAZETTE_DATE is the date the associated active voting area boundary was gazetted

FEATURE_AREA_SQM

AREA_SQM

NUMBER

19

FEATURE_AREA_SQM is the system calculated area of a two-dimensional polygon in square meters.

FEATURE_LENGTH_M

FEAT_LNGTH

NUMBER

19

FEATURE_LENGTH_M is the system calculated length or perimeter of a geometry in meters.

SHAPE

SHAPE

SDO_GEOMETRY

64

SHAPE is the column used to reference the spatial coordinates defining the feature.

OBJECTID

OBJECTID

NUMBER

38

OBJECTID is a column required by spatial layers that interact with ESRI ArcSDE. It is populated with unique values automatically by SDE.

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.

About Tracking

Google Analytics uses "cookies," which are text files stored on your computer that enable an analysis of your use of the website. Some of the information generated by the cookie about your use of this website may be transmitted to and stored on Google servers outside of Canada. You may refuse the use of cookies by selecting the appropriate settings in your browser; however, please note that if you do so, you may not be able to use the full functionality of this website. Furthermore, you can prevent Google’s collection and use of data generated by the cookie and related to your use of the website by downloading and installing the browser plug-in available at (http://tools.google.com/dlpage/gaoptout?hl=en).