BC Assessment - Commercial Inventory

0 views (0 recent)

Published by the Crown Corporations and Agencies - BC Assessment Authority
Licensed under Access Only

The BCA Commercial Inventory Extract contains a record or row for every building or part of a building in a jurisdictional or area, unless it has been omitted for privacy reasons.

Non-residential properties are assessed using different approaches, dependent on multiple factors including, for example, income generation and highest and best use. Building breakdown of floor area by use is not always collected, depending on the assessment approach. Therefore, users of this data will find some properties carry a more detailed breakdown of floor area by use than others.

Total areas of buildings are not collected for major industrial properties and any other properties valued using the ad valorem approach and therefore will not be available in this report. This may include properties like sawmills, airports, schools and utilities.

Use of this data is restricted to internal government named users. All users of this data are required to enter into an End User License Agreement (EULA) under the authority of their Ministry.

At this time, the EULA can be signed and access requested by the Expense Authority for your Branch/Division (e.g., Director or Executive Director) using the Data Request Form. The following information is to be included in the request:

Ministry
Division
Branch
List of names and IDIR's for each person that will be accessing and/or using the data
Short description of intended data use

Data and Resources

Dataset Extent

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

Additional Information

Data Quality	The Commercial Inventory Extract data is in .txt format with comma separated data and is updated quarterly on January 1, April 1, July 1 and October 1 (or the first business day following these dates).

Data Quality

The Commercial Inventory Extract data is in .txt format with comma separated data and is updated quarterly on January 1, April 1, July 1 and October 1 (or the first business day following these dates).

More Information

Contact Information

Name	Property Information, Customer Division (businessExpert)
Email	bcacustomer.services@bcassessment.ca
Organization	Crown Corporations and Agencies
Sub-Organization	BC Assessment Authority

Name	DataBC (distributor)
Email	data@gov.bc.ca
Organization	Ministry of Citizens Services
Sub-Organization	DataBC Program

Access & Security

Who can view this dataset?	Named users
Who can download this dataset?	Named users

Metadata Information

Record Published	2021-01-01
Record Last Modified	2021-02-18
Resource Status	onGoing
Spatial Data	SDO_GEOMETRY

Object Description

Object Name: WHSE_HUMAN_CULTURAL_ECONOMIC.BCA_COMMERCIAL_INVENTORY_VW

Short Name: BCACOMMERC
Comments: Commercial Inventory is the non-residential properties are assessed using different approaches, dependant on multiple factors including, for example, income generation and highest and best use. Building breakdown of floor area by use is not always collected, depending on the assessment approach. Therefore, users of this data will find some properties carry a more detailed breakdown of floor area by use than others. Total areas of buildings are not collected for major industrial properties and any other properties valued using the ad valorem approach and therefore will not be available in this report. This may include properties like sawmills, airports, schools and utilities. The data is updated quarterly.

Column Name	Short Name	Data Type	Data Precision	Comments
BCA_CI_SYSID	BCA_CI_SID	NUMBER	10	A system generated unique identification number.
ASSESSMENT_AREA_CODE	AA_CD	NUMBER	2	The code for an Assessment Area, it is a a two-digit value, e.g., 01, 09, 27.
ASSESSMENT_AREA_NAME	ASSSSMNT_M	VARCHAR2	254	The corresponding descriptive name associated with the Assessment Area Code, e.g., Capital, Vancouver, Peace River.
JURISDICTION_CODE	JUR_CD	NUMBER	3	The code for a municipal or rural Taxing Jurisdiction that falls within a BCA Assessment Area. A 3-digit code from 200 to 799.
JURISDICTION_NAME	JRSDCTN_NM	VARCHAR2	254	The corresponding descriptive name associated with the Jurisdiction Code, e.g., City of Vancouver, Terrace Rural
ROLL_NUMBER	ROLL_NUM	VARCHAR2	15	A number assigned by a local government (Municipal or Rural) to identify a specific property. May not be unique across the province.
YEAR_BUILT	YEAR_BUILT	NUMBER	4	Year that construction began on the property.
YEAR_EFFECTIVE	YEAR_EFF	NUMBER	4	Effective year of an improvement is the effective age as defined in Section 1 of the Depreciation of Industrial Improvements Regulation (BC Reg 379/88).
STOREYS	STOREYS	NUMBER	3	Number of distinct levels of living space above the basement, crawl space or slab foundation.
GROSS_LEASABLE_AREA	GR_LEASE	NUMBER	10	The Gross Leasable Area (GLA) is equivalent to Floor Rentable Area as defined by the Building Owners and Managers Assn (BOMA). Floor Rentable Area is the gross measured area of a floor less the area of major vertical penetrations, e.g., ventilation shaft, elevator shafts and stairs. Total Building GLA is equivalent to Building Rentable Area or sum of all Floor Rentable Areas. In x units.
NET_LEASABLE_AREA	NET_LEASE	NUMBER	10	Total floor area designed for the occupancy and exclusive use of tenants in square feet. Is also referred to as the store area.
PARKING_UNDERGROUND_STALLS	PRK_UG_S	NUMBER	4	Number of underground parking stalls on the property.
PARKING_SURFACE_STALLS	PRK_SRF_S	NUMBER	4	Number of parking stalls on the property.
PARKING_STRUCTURE_STALLS	PRK_STR_S	NUMBER	4	Number of parking stalls in a parking structure on the property.
COOP_UNITS	COOP_UNITS	NUMBER	10	Number of units in a cooperative apartment building.
COOP_BACH_UNITS	COOP_BACH	NUMBER	10	Number of bachelor units in a cooperative apartment building.
COOP_1BR_UNITS	COOP_1BR	NUMBER	10	Number of 1 bedroom units in a cooperative apartment building.
COOP_2BR_UNITS	COOP_2BR	NUMBER	10	Number of 2 bedroom units in a cooperative apartment building.
COOP_3BR_UNITS	COOP_3BR	NUMBER	10	Number of 3 bedroom units in a cooperative apartment building.
COOP_4BR_UNITS	COOP_4BR	NUMBER	10	Number of 4 bedroom units in a cooperative apartment building.
PREDOMINANT_MANUAL_CLASS_CODE	PR_MAN_CL	VARCHAR2	50	The state and condition of the improvement (building) and the structural components and condition of the improvement, e.g., Apartment - Frame, Carwash, Office.
GROSS_BUILDING_AREA	GRS_BLD_AR	NUMBER	10	Total constructed area of a building in square feet. This area is computed by measuring to the outside finished surface of permanent outer building walls. It includes all enclosed floor areas of the building including basements, mechanical rooms etc.
BASEMENT_AREA	BSMNT_AREA	NUMBER	10	Area of the basement in square feet.
STRATA_INDUST_COMM_LOT_AREA	STRATA_IND	NUMBER	10	Area defined in square feet for multiple strata types. Strata Office and Retail is the sum of the areas of all strata units and common areas as registered on the strata plan. Strata Industrial is the sum of the areas of all strata units as registered on the strata plan in the development.
APT_UNITS	APT_UNITS	NUMBER	10	Number of units in a rental apartment building.
APT_BACH_UNITS	APT_BACH	NUMBER	10	Number of bachelor units in a rental apartment building.
APT_1BR_UNITS	APT_1BR	NUMBER	10	Number of 1 bedroom units in a rental apartment building.
APT_2BR_UNITS	APT_2BR	NUMBER	10	Number of 2 bedroom units in a rental apartment building.
APT_3BR_UNITS	APT_3BR	NUMBER	10	Number of 3 bedroom units in a rental apartment building.
APT_4BR_UNITS	APT_4BR	NUMBER	10	Number of 4 bedroom units in a rental apartment building.
APT_HOUSE_KEEPING_ROOMS	APT_HKR	NUMBER	10	Number of housekeeping units in a rental apartment building. Typically these units have their own private bedroom or living quarters but share other facilities, such as bathrooms.
HOTEL_UNITS	HTL_UNITS	NUMBER	10	Number of units in a hotel properties (Use Code 230 � Hotel).
MOTEL_UNITS	MTL_UNITS	NUMBER	10	Number of units in a motel properties (Use Code 232 � Motel and Auto Court).
SENIOR_UNITS	SNR_NTS	NUMBER	10	Number of units in a seniors housing building.
SENIOR_BACH_UNITS	SNR_BACH	NUMBER	10	Number of bachelor units in a seniors housing building.
SENIOR_1BR_UNITS	SNR_1BR	NUMBER	10	Number of 1 bedroom units in a seniors housing building.
SENIOR_2BR_UNITS	SNR_2BR	NUMBER	10	Number of 2 bedroom units in a seniors housing building.
SENIOR_3BR_UNITS	SNR_3BR	NUMBER	10	Number of 3 bedroom units in a seniors housing building.
SENIOR_BED_SITTING_ROOM	SNR_BSR	NUMBER	10	Number of bed sitting rooms (BSR) in a seniors housing building. A BSR is a resident unit that does not contain a kitchenette; it may or may not contain an ensuite bathroom.
SENIOR_LIC_CARE_PRIV_BED	SNR_LC_PB	NUMBER	10	Number of private single bed bedrooms, funded from Health Authority for licensed care.
SENIOR_LIC_CARE_SEMI_PRIV_BED	SNR_LC_SPB	NUMBER	10	Number of semi-private rooms of two to four beds and a two-piece ensuite or shared washroom, funded from Health Authority for licensed care.
TOTAL_BALCONY_AREA	TTL_BLCNY	NUMBER	10	Total balcony area for a commercial property in square feet.
MEZZANINE_AREA	MEZZANINE	NUMBER	10	Total of all mezzanine area in a commercial property in square feet. A mezzanine is a low storey between two other storeys in a building, typically between the ground and first floors.
HEATING_TYPE	HTNG_TYPE	VARCHAR2	50	The predominant heating source for the home. In the case of homes with more than one heating type, e.g., gas on main and electric on the upper floor(s), the predominant heating type is shown. If the structure has no heat, the No Heat option is selected, Electric, Hot Water, Space Heater, Package Unit.
ELEVATOR_FLAG	ELVTR_FLG	VARCHAR2	5	Indicates if any commercial buildings have one or more elevator(s), i.e., T (True), blank (False).
CONSTRUCTION_TYPE_CODE	CNST_CD	VARCHAR2	5	The type of construction for a commercial property, derived from the predominant manual class for that property, e.g., A (s Fireproof structural steel frame), B (Reinforced concrete frame), C (Masonry bearing walls), D (Wood or steel frame exterior walls), H (Hoop arch), P (Pole frame), S (Metal Frame), W (Metal fram and walls).
OTHER_BUILDINGS	OTHR_BLDNS	VARCHAR2	5	Identifies whether one or more outbuildings exist on the property, i.e, X (Yes), blank/null (No). Detached garages larger than 950 square feet are considered outbuildings.
SCHOOL_DISTRICT	SCHL_DIST	NUMBER	3	The School District code identified for the property.
ZONING	ZONING	VARCHAR2	15	A code that identifies permitted use based on a local government bylaw that describes the permitted, i.e., uses for land, building and other structures; siting, size and dimensions of buildings and other structures; and shape, dimensions and area of lots that may be created by subdivision.