Find businesses and services using DMTI Enhanced Points of Interest

1. Open Scholars GeoPortal
   • If you are off-campus you should see a banner along the top to login. Select Carleton University and login with your MyCarletonOne username and password.
2. In the search box, search for enhanced points.
3. In the Sort By drop-down list, select Publish date: newest.
4. The fourth item on the list should be Enhanced Points of Interest (EPOI) with dates from 2015 to 2020. Click the Details button to view documentation and information about the dataset.
   Image:

   
5. Click the Add 0/6 button then Add the newest dataset.
6. Once the dataset is loaded, it is possible to click on any point and obtain more details.

   

1. Click on the Download tab in the top left area of the Scholars GeoPortal window.
2. Select the radio button for Download by area of interest.
3. Scholars GeoPortal can clip to census geographies (e.g.: province, census metropolitan areas (cities), etc.) - you can find out more about census geographies here. Once you know which census geography you would like, click the radio button for Select a pre-defined area.
4. In the Select an area type and click the map drop-down, make a selection (in this example Census Metropolitan Areas is selected to download data for Ottawa-Gatineau).
5. Zoom into your area(s) of interest and click on the map. In this example, both Ottawa and Gatineau were clicked. Yellow polygons should appear to show which areas were selected.
6. In Choose output options, select as appropriate.
7. Click the Download button. One file will be created for each geography selected.
8. We recommend clicking the individual .zip folders created to download - the Download All button includes a lot of subfolders and requires an extra file extraction (unzipping).

   

1. Click on the Download tab in the top left area of the Scholars GeoPortal window.
2. Select the radio button for Download by area of interest.
3. Select the radio button for Draw an area.
4. Use the tools available to draw a region on your map. In this case, a section of the Gaspé Peninsula was selected.
5. In Choose output options, select output file format and coordinate system as appropriate.
6. Click the Download button.
7. We recommend clicking the individual .zip folders created to download - the Download All button includes a lot of subfolders and requires an extra file extraction (unzipping).

   

Recent years of EPOI consistently include either North American Industry Classification System (NAICS) or Standard Industrial Classification (SIC) codes for locations, or sometimes both. This is helpful as it provides a method to filter for businesses such as grocery stores (NAICS code 445110; SIC code 5411) or automotive repair shops (NAICS code 811111; SIC code 7500).

**This is not a perfect method as there will likely be errors and omissions, but it is a quick way to filter.

1. Once you've loaded EPOI in Scholars GeoPortal, zoom to your area of interest. For this example, we've zoomed to Prince Edward Island.
2. Click the Data Table link in the menu bar in the top right side of the GeoPortal window. Wait a moment while the table loads.
3. Once the table has loaded, click the Limit to current extent checkbox. This will speed up analysis as it will save searching the entire table of over 1.7 million features (2017).

   

4. Have a look at the data table. Scroll right to view the attributes for SIC and NAICS codes. Note that some of the points have both SIC and NAICS codes, some have only one or the other, and that some have multiple codes in both categories.
5. Search NAICS (alternate NAICS option that links to SIC) and SIC to find the code(s) you require. The categories may be broader than you'd like. Note the code(s) you'd like to find. In this example, we will be searching for grocery stores (NAICS code 445110; SIC code 5411).
6. Click the Query button on the data table toolbar.
7. In the query window, there is a list of attributes (including NAICS and SIC codes) as well as a query box. Scholars GeoPortal has some details about searching using queries. All the SIC and NAICS fields are Strings, which means they are text fields and not numeric.
   • Take a close look at the NAICS and SIC code values. EPOI occasionally drops zeroes from the end of NAICS codes (e.g.: 44511) and always adds zeroes to the SIC codes (e.g.: 54110000).
8. To search for NAICS code 445110:
   • Double-click on NAICS_1: String to populate the query text box
   • Click the = sign
   • Type '445110' after the = sign
   • Click Execute

     

9. This particular search will result in no results. It turns out that sometimes the EPOI dataset drops zeroes from the NAICS codes. In this case, let's try searching for NAICS_1 = '44511'.
10. The search without the zero is successful and produces results. However, since we know that some of the features are missing either a NAICS or SIC code, let's also search for the SIC code (5411). Remember that EPOI adds zeroes to the SIC codes (e.g.: 54110000) to make them 8 digits long. We'll add this using OR, which means that if a feature has either NAICS code 44511 OR it has SIC code 54110000, the search will return those results.

    

11. Once that search is executed, it is possible to export only the results as a shapefile. Click the Export Result button on the data table toolbar and select ...As Shapefile (.shp).
12. It doesn't seem like anything is happening, but a link called Your file is available here will appear in the top right corner of the data table.

    

13. Click the link to view the download list and download the file.

Recent years of EPOI consistently include either North American Industry Classification System (NAICS) or Standard Industrial Classification (SIC) codes for locations, or sometimes both. This is helpful as it provides a method to filter for businesses such as grocery stores (NAICS code 445110; SIC code 5411) or automotive repair shops (NAICS code 811111; SIC code 7500).

**This is not a perfect method as there will likely be errors and omissions, but it is a quick way to filter.

1. Access EPOI in Scholars GeoPortal and download the data by your area of interest (either census geography or area you draw).
2. Unzip the compressed file (if the file is still zipped, you cannot add it to ArcGIS Pro or ArcMap)
3. Add the shapefile to ArcGIS Pro.
4. Right-click on the shapefile in the Drawing Order pane and open the attribute table.
5. Have a look at the data table. Scroll right to view the attributes for SIC and NAICS codes. Note that some of the points have both SIC and NAICS codes, some have only one or the other, and that some have multiple codes in both categories.
6. Search NAICS (alternate NAICS option that links to SIC) and SIC to find the code(s) you require. The categories may be broader than you'd like. Note the code(s) you'd like to find. In this example, we will be searching for grocery stores (NAICS code 445110; SIC code 5411) in Prince Edward Island.
7. In the ArcGIS Pro Map tab, click the Select By Attributes button.

   

8. In the Geoprocessing pane, a Select Layer By Attribute window will be visible. Ensure the EPOI dataset is selected in the Layer Name drop-down list.
9. We'll search for the NAICS code. Click the Add Clause button to add a query:
   • Field: NAICS_1
   • is Equal to
   • Start typing 445110. Note that the drop-down list becomes populated with available values in the field. This is very helpful as it demonstrates that EPOI occasionally drops the final 0 on the end of the NAICS codes. Type in 44511.
   • Click Add

     

10. Click the green checkmark to verify that the SQL expression is valid (this one should be). If not, go back and check it.
11. Click the Run button at the bottom of the Geoprocessing pane.
12. At the bottom of the attribute table it will show how many features are selected. In this case, 53 of 8516 locations are selected.

    

13. However, since we know that some of the features are missing either a NAICS or SIC code, let's also search for the SIC code (5411). We'll add this using OR, which means that if a feature has either NAICS code 44511 OR it has SIC code 5411, the search will return those results.
    • Click Add Clause
    • Instead of And, select Or in the drop-down
    • Field: SIC_1
    • Is Equal To
    • Start typing 5411. Note that the drop-down list becomes populated with available values in the field. This is very helpful as it demonstrates that, opposite to the NAICS codes, EPOI may have extra zeroes in the SIC codes. Type in or select 54110000.
    • Click Add
14. Verify that the expression is valid by clicking the green checkmark. (It should be.)
15. Run the expression. There should be more features selected - in the example, there are now 144 features.
16. To save the selected features, click the Data tab > Layer From Selection.
17. Copy Features will appear in the Geoprocessing tab. Click the folder in Output Feature Class to browse to where you want to save the new file.
18. Click Run.