The dataset is a collection of business information, including business names, geographical locations, and the specific sectors and industries they belong to. The dataset is a valuable resource for anyone interested in exploring, analyzing, or understanding the diverse landscape of businesses in Edmonton. Some of the information include the North American Industry Classification (NAICS) code - a standardized system used to classify businesses and industries in North America. These codes, ranging from two to six digits, provide a comprehensive framework for classifying establishments based on their primary economic activities.
This dataset has the following 29 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| objectid | objectid | number | primary key that uniquely identifies each record | 4773 10051 6910 5325 2747 view top 100 |
| Last Edited Date | last_edited_date | calendar_date | The data was downloaded from arcGIS map | 2023-11-02T17:10:00.000 2023-11-02T17:09:00.000 view top 100 |
| Business Name | business_name | text | Name of Business establishment. In some cases, this may be different from legal names. | AVENUE LIVING Government of Alberta STARBUCKS U-HAUL NEIGHBORHOOD DEALER TIM HORTONS view top 100 |
| Business Description | business_description | text | Business description. | Rental Accommodation Restaurant Or Food Service Attorneys Offices Of Lawyers Lessors Of Residential Buildings And Dwellings (Except Social Housing Projects) Dentists Offices Of Dentists view top 100 |
| Export | export | text | Yes - businesses that export goods and services outside Canada; and NO - for business that do not | No Yes view top 100 |
| Hybrid Work | hybrid_work | text | Yes - for business that allow hybrid work | No Yes view top 100 |
| Business Address | business_address | text | Street address | 1 KINGSWAY GARDEN MALL NW 10665 JASPER AVENUE NW 10060 JASPER AVENUE NW 10180 101 STREET NW 10123 99 STREET NW view top 100 |
| Unit Number | unit_number | text | Unit number | 201 101 100 200 102 view top 100 |
| Postal Code | postal_code | text | Postal code | T5G3A6 T5J3R8 T5J3S9 T5J3S4 T5J0H8 view top 100 |
| Business Website | business_website | text | Business website | NA https://www.alberta.ca/ https://www.edmonton.ca/ bwalk.com https://www.covenanthealth.ca/ view top 100 |
| Year Of Establishment | year_of_establishment | text | The year the business was established in Edmonton, based on survey response and online search | 2019 2021 2018 2020 2023 view top 100 |
| Sectors | sectors | text | level 1: sectors (two-digit NAICS codes) label | Real estate and rental and leasing Retail trade Accommodation and food services Professional, scientific and technical services Other services (except public administration) view top 100 |
| Sectors Code | sectors_code | text | level 1: sectors (two-digit NAICS codes) | 53 72 54 81 62 view top 100 |
| Subsectors | subsectors | text | level 2: subsectors (three-digit NAICS codes) label | Real estate Professional, scientific and technical services Food services and drinking places Ambulatory health care services Personal and laundry services view top 100 |
| Subsectors Code | subsectors_code | text | level 2: subsectors (three-digit NAICS codes) | 531 541 722 621 812 view top 100 |
| Industry Group | industry_group | text | level 3: industry groups (four-digit NAICS codes) label | Lessors of real estate Full-service restaurants and limited-service eating places Personal care services Legal services Other provincial and territorial public administration view top 100 |
| Industry Group Code | industry_group_code | text | level 3: industry groups (four-digit NAICS codes) | 5311 7225 8121 5411 9129 view top 100 |
| Industries | industries | text | level 4: industries (five-digit NAICS codes) label | Lessors of residential buildings and dwellings Full-service restaurants and limited-service eating places Offices of lawyers Hair care and esthetic services Other provincial and territorial public administration view top 100 |
| Industries Code | industries_code | text | level 4: industries (five-digit NAICS codes) | 53111 72251 54111 81211 91291 view top 100 |
| NAICS Code | naics_code | text | level 5: Canadian industries (six-digit NAICS codes) label | 531111 722512 722511 541110 912910 view top 100 |
| NAICS Description | naics_description | text | level 5: Canadian industries (six-digit NAICS codes) | Lessors of residential buildings and dwellings (except social housing projects) Limited-Service Eating Places Full-service restaurants Offices of Lawyers Other provincial and territorial public administration view top 100 |
| Service Or Goods | service_or_goods | text | Variant of North American Industry Classification System (NAICS) 2022 Version 1.0 for Goods and services producing industries | Services-producing industries Goods-producing industries Other view top 100 |
| Ward Name | ward_name | text | Civic ward name where the business is located | O-day'min view top 100 |
| BIA | bia | text | Business improvement area where the business is located | Downtown Kingsway 124 Street and Area North Edge Chinatown and Area view top 100 |
| Neighbourhood Name | neighbourhood_name | text | Name of the neighbourhood where the business is located | DOWNTOWN OLIVER WESTMOUNT QUEEN MARY PARK CENTRAL MCDOUGALL view top 100 |
| Neighbourhood Number | neighbourhood_number | number | Numeric unique identifier of the neighbourhood where the business is located | 1090 1150 3440 1180 1030 view top 100 |
| Longitude | longitude | number | Longitude in decimal degrees of the business's location | -113.5043981 -113.4929271 -113.5040909 -113.4946432 -113.4865463 view top 100 |
| Latitude | latitude | number | Latitude in decimal degrees of the business's location | 53.56165604 53.54152481 53.54047568 53.54266781 53.5425041 view top 100 |
| Geometry | geom | point | Point location of the business in WKT (Well-Known Text) format, for mapping and geospatial analysis | {"coordinates":[-113.5043981,53.56165604],"type":"Point"} {"coordinates":[-113.4929271,53.54152481],"type":"Point"} {"coordinates":[-113.5040909,53.54047568],"type":"Point"} {"coordinates":[-113.4946432,53.54266781],"type":"Point"} {"coordinates":[-113.4865463,53.5425041],"type":"Point"} view top 100 |