BC Indigenous Business Listings

1038 views (14 recent)

Published by the Ministry of Jobs, Trade and Technology - Economic Development Division
Licensed under Open Government Licence - British Columbia

The BC Indigenous Business Listings dataset offers a brief summary of Indigenous businesses operating in the province. For each business listed in the dataset, information including the Indigenous owner(s) of the company, location, links to websites as well as primary contact information including email addresses and phone numbers is provided where available. This information is intended to facilitate connections between business owners and consumers, investors, and industry. It is also meant to support an understanding of ownership trends among Indigenous businesses.

To add or update your Indigenous-owned business, please visit the BC Indigenous Business & Investment Council.

Data and Resources

Dataset Extent

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

Additional Information

Purpose

The primary use of this data is to provide information about Indigenous Owned Businesses identified at specific civic address locations in B.C.

Lineage Statement

This dataset was previously named WHSE_IMAGERY_AND_BASE_MAPS.GSR_ABORIGINAL_BUSINESSES_SVW

More Information

Contact Information

NameGreg Booth (custodian)
EmailGreg.Booth@gov.bc.ca
OrganizationMinistry of Jobs, Trade and Technology
Sub-OrganizationEconomic Development Division
NameMegan Whonnock (businessExpert)
EmailMegan.Whonnock@gov.bc.ca
OrganizationMinistry of Jobs, Trade and Technology
Sub-OrganizationEconomic Development Division
NameChris Bechard (businessExpert)
EmailChris.Bechard@gov.bc.ca
OrganizationMinistry of Jobs, Trade and Technology
Sub-OrganizationEconomic Development Division

Access & Security

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

Metadata Information

Record Published 2016-09-15
Record Last Modified 2019-03-18
Resource Status onGoing

Object Description

Object Name: WHSE_IMAGERY_AND_BASE_MAPS.GSR_INDIGENOUS_BUSINESSES_SV

Short Name: INDIG_BUSI
Comments: GSR_INDIGENOUS_BUSINESSES_SV is a spatially enabled layer comprising a brief summary of INDIGENOUS Businesses operating in the province. For each business listed in the dataset, information including the INDIGENOUS owner(s) of the company, location, links to websites as well as primary contact information including email addresses and phone numbers is provided where available. This information is intended to facilitate connections between business owners and consumers, investors, and industry. It is also meant to support an understanding of ownership trends among INDIGENOUS businesses.

Column Name Short Name Data Type Data Precision Comments
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., indigenousBusinessListings
BUSINESS_CATEGORY_DESCRIPTION BUS_CAT_DS VARCHAR2 1000 BUSINESS_CATEGORY_DESCRIPTION describes the category of business, i.e., Indigenous Business Listings
OCCUPANT_TYPE_DESCRIPTION OCCPNT_TYP VARCHAR2 500 OCCUPANT_TYPE_DESCRIPTION contains the description of the occupant type, e.g. Hospital
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
SUPPLIED_SOURCE_ID_IND SRC_ID_IND VARCHAR2 1 SUPPLIED_SOURCE_ID_IND is an indicator of whether the source data id was supplied by the supplier (Y) or DataBC (N)
BUSINESS_NAME BUS_NAME VARCHAR2 500 BUSINESS_NAME is a name of an indigenous business that can identify the company that is formed and organized to carry on a business. e.g., , Lakeshore Resort and Campground, K & L Contracting Ltd.
DESCRIPTION DESCRIPTN VARCHAR2 4000 DESCRIPTION describes the Occupant in more detail, e.g., logging, land clearing, road building
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.
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
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.
POSTAL_CODE POSTAL_CD VARCHAR2 10 POSTAL_CODE is the Canadian Postal code value associated with the physical address, e.g., V9Z 2K1
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.
CONTACT_PHONE CONT_PHONE VARCHAR2 50 CONTACT PHONE contains the general office phone number of the Occupant, e.g., (250) 555-1234 or 250-555-1234.
CONTACT_EMAIL CONT_EMAIL VARCHAR2 100 CONTACT_EMAIL contains the "general office" email address of the Occupant.
CONTACT_FAX CONT_FAX VARCHAR2 50 CONTACT FAX contains the general office fax number of the Occupant, e.g., (250) 555-1234 or 250-555-1234.
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.
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.
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
INDIGENOUS_OWNERSHIP_DESC INDIG_OWN VARCHAR2 50 INDIGENOUS_OWNERSHIP_DESC identifies if the company includes indigenous ownership, e.g., TRUE.
BUSINESS_REGION BUS_REGION VARCHAR2 100 BUSINESS_REGION is the region that the company is located in, e.g., Vancouver Island and Coast.
COMPANY_TYPE CMPNY_TYPE VARCHAR2 100 COMPANY_TYPE describes the type of company, e.g., Partnership.
CONTACT_TITLE CONT_TITLE VARCHAR2 500 CONTACT_TITLE is the title of the primary contact, e.g., Owner.
FACEBOOK FACEBOOK VARCHAR2 2083 FACEBOOK provides the Facebook link for the business.
INDUSTRY_SECTOR IND_SECTOR VARCHAR2 500 INDUSTRY_SECTOR is the Industry Sector from the North American Industry Classification System (NAICS), e.g., 23 - Construction.
NBR_OF_EMPLOYEES_RANGE NUM_EMPLYS VARCHAR2 50 NBR_OF_EMPLOYEES_RANGE is the number of employees in the company defined by a range, e.g., 1-5.
PRIMARY_CONTACT PRIM_CONTA VARCHAR2 500 PRIMARY_CONTACT identifies the primary contact for the company.
TWITTER TWITTER VARCHAR2 2083 TWITTER is the Twitter link for the business.
YEAR_FORMED YR_FORMED VARCHAR2 4 YEAR_FORMED is the year the company was formed. e.g., 2014
WHEN_UPDATED WHEN_UPDTD DATE 8 WHEN_UPDATED contains the date when the information in this record was last updated in the source system.
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. It is populated with unique values automatically by SDE.
SE_ANNO_CAD_DATA ANNO_CAD 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.