Entreprendre Sherbrooke

From OpenStreetMap Wiki
Jump to navigation Jump to search

Entreprendre Sherbrooke is a para-municipal economic development organization. They make available a dataset with about 4900 businesses and organizations present in the Sherbrooke area. This page describes the data and the different steps needed to import them according to the Import guidelines.

Directory of businesses in the Sherbrooke area

The data is available here under a CC0 license. In order to show how it can be processed/edited and to facilitate discussion on the import process, an record example is described below. The file format is .csv. File content is in French but definitions are provided here in English.

Description of available attributes
Attribute Definition Example Import tag
entreprise Company name. ÉRABLIÈRE BEAU SITE name=*
no_civique Civic number of the company. 3499 addr:housenumber=*
rue_local Company street. Chemin Hatley North addr:street=*
code_postal Postal code of the company. A0B 1C2 addr:postcode=*
entreprise_tel Phone number 123 456-7890 phone=*
mix_id NAICS code 111994 conversion [1]
scian_categorie NAICS category Agriculture, foresterie, pêche et chasse conversion [1]
scian_principal name of the NAICS assigned to the company. Production de sirop et autres produits de l'érable conversion [1]
neq Registration number from the Quebec Enterprise Register. 00000001 not imported
secteur_commercial Geographic limits determined by Entreprendre Sherbrooke. Université not imported
lng Longitude (building centroid) -71.0123456789 lon
lat Latitude (building centroid) 45.987654321 lat

[1] The North American Industry Classification System defines the mix_id, scian_categorie and scian_principal attributes. These attributes are used to help finding adequate tags for each record.

License Compatibility

Entreprendre Sherbrooke has made its dataset available with a CC0 license. They own all of its contents except for coordinates. These coordinates are derived from data belonging to the Ville de Sherbrooke (the City) which distributes its data with a CC-BY 4.0 license. Entreprendre Sherbrooke is currently seeking an agreement with the City to share these coordinates with OpenStreetMap. Until then, the import cannot be done.

Data Analysis

Nodes location

According to Entreprendre Sherbrooke, the coordinates correspond to the center of the buildings in which these businesses are located. In cases where several businesses are located in the same building, their geometries overlap. All geometries need to be place at their actual location using the Simple POI Mapping Schema.

Attribute to Tag Conversion

  • building=yes is added to each record since the feature is located at the center of a building. However, if the building exists in OSM database, the tag will be removed (see Import Process section).
  • addr:city=Sherbrooke is added to each record.
  • addr:* tags can be imported as is.
  • name=*: should be converted in proper case (i.e., Érablière Beau Site).
  • phone=*: numbers should be converted to international format (i.e., +1-123-456-7890).

NAICS code to OSM tag Conversion

The current dataset includes 522 different business types (scian_principal), divided into 20 business categories (scian_categorie). An analysis suggests that all business categories refer to one of Key:shop, Key:craft, Key:office, Key:leisure, Key:amenity or Key:healthcare values. However, due to business types (scian_principal), a large number of records cannot be translated directly into OSM tags. Therefore a review of each record, based on local knowledge/web search validation, should be performed before converting a NAICS code to OSM tags. In addition, a NAICS code can often be translated into several tags. For example, in the current dataset, the code 713940 “Fitness and Recreational Sports Centers” translates to recreation=fitness_centre for some records and recreation=sports_hall, sport=hockey for the remaining records. The search for appropriate tags is performed using above keys and the TagFinder. The NAICS conversion results (OSM tags) are kept for each record (business) in an Excel file.


NAICS code to OSM tags Translation Status
NAICS (mix_id) Main Category (scian_categorie) Business Type (scian_principal) Records Primary OSM tag Other OSM tags Status
445110 Retail trade Supermarkets and other grocery (except convenience) stores 35 shop=supermarket
446110 Retail trade Pharmacies and drug stores 28 amenity=pharmacy; healthcare=pharmacy
453910 Retail trade Pet and pet supplies stores 18 shop=pet
713940 Arts, entertainment and recreation Fitness and recreational sports centres 27 leisure=fitness_centre leisure=sports_hall;sport=hockey
722310 Services d'hébergement et de restauration Services de restauration contractuels 3 Finished reviewing
722320 Services d'hébergement et de restauration Traiteurs 19 craft=caterer Finished reviewing
722410 Services d'hébergement et de restauration Débits de boissons alcoolisées 36 amenity=bar amenity=pub, amenity=nightclub, amenity=restaurant Currently reviewing
722511 Services d'hébergement et de restauration Restaurants à service complet 119 amenity=restaurant ... To do
722512 Services d'hébergement et de restauration Établissements de restauration à service restreint 184 amenity=fast_food amenity=restaurant, amenity=cafe, ... To do
812114 Other services (except public administration) Barber shops 30 shop=hairdresser
812116 Other services (except public administration) Unisex hair salons 154 shop=hairdresser

Records whose NAICS code does not appear in the table above should not be imported.

(Work in progress)...

Import process

When records of a given NAICS code are ready to be imported, they are converted to an .osm file using FME, and opened in JOSM as an import separate layer.


For each object of the import layer:

  • upload the surrounding content from OSM in an osm layer
  • if the object exists in the osm layer then update the existing osm feature:
    • if the osm feature is a node then:
      • update the node with object tags.
      • adjust the node location if required.
    • else if the osm feature has a building=* tag then:
      • remove the building=yes tag from the object.
      • copy the object to the osm layer on its actual location.
      • remove osm feature tags that are duplicated in object.
    • else the osm feature is not a building, so:
      • copy the object to the osm layer on its actual location.
      • remove osm feature tags that are duplicated in object.
  • else copy the object to the osm layer on its actual location.

Once each object is transferred to the osm layer:

  • check the osm layer for errors with JOSM validator and correct them.
  • upload the osm layer to OSM database.


The process aims to create nodes with imported businesses. These businesses start, stop or move but the buildings in which they are located do not change much. Keeping businesses up to date should be easier with nodes than with anything else. Once imported, the identifiers of the nodes will be kept in order to link them to the records of the Entreprendre Sherbrooke dataset. Since this organization updates its dataset on a quarterly basis, this could potentially help keeping OSM updated at the same frequency.

(Work in progress)...

Current Records Tagging

This section aims to provide and discuss tags for each business associated with a given NAICS code. A review of each record, based on local knowledge/web search validation, must be performed to properly tag each business.
Current osm_tags is the result of a first attempt. You are welcome to add or modify any of these tags.

722511 - Accommodation and food services - Full-service restaurants
business civic_number street osm_tags
ADAM'S DINING ROOM 2600 Rue College fast_food=cafeteria;
ALLÔ! MON COCO 3050 Boulevard de Portland amenity=restaurant;cuisine=breakfast
ANTIDOTE FOODLAB 35 Rue Belvédère Nord amenity=restaurant;cuisine=fine_dining
AU COIN DU VIETNAM 1530 Rue Galt Ouest amenity=restaurant;cuisine=vietnamese
AU SANGLIER DORÉ 1410 Rue King Ouest amenity=restaurant;cuisine=medieval
AU VIEUX DULUTH 3155 Boulevard de Portland amenity=restaurant;cuisine=greek
AUGUSTE RESTAURANT 82 Rue Wellington Nord amenity=restaurant;cuisine=fine_dining
BAOBAB CAFÉ DE QUARTIER 1551 Rue Dunant amenity=restaurant;cuisine=café
BÂTON ROUGE STEAKHOUSE & BAR 2844 Rue King Ouest amenity=restaurant;cuisine=steak_house
BEN & FLORENTINE (12E AVENUE NORD) 2015 12e Avenue Nord amenity=restaurant;cuisine=brunch
BEN & FLORENTINE (RUE GALT OUEST) 3550 Rue Galt Ouest amenity=restaurant;cuisine=brunch
BENNY & CO (12E AVENUE NORD) 2015 12e Avenue Nord amenity=restaurant;cuisine=rotisserie
BENNY & CO (BOULEVARD DE PORTLAND) 4700 Boulevard de Portland amenity=restaurant;cuisine=rotisserie
BISTRO DE LA CITÉ (COMPLEXE DE LA CITÉ DES RIVIÈRES) 950 Rue King Ouest amenity=restaurant;cuisine=panini
BISTRO KÀAPEH ESPRESSO 137 Rue Frontenac amenity=restaurant;cuisine=mexican
BISTRO TAPAGEUR 83 Rue King Ouest amenity=restaurant;cuisine=tapas
BOEFISH RESTAURANT 3131 Rue King Ouest amenity=restaurant;cuisine=beef;fish
BOSTON PIZZA 550 Rue Jean-Paul-Perrault amenity=restaurant;cuisine=pizza
BRASSERIE DANIEL LAPOINTE ( KING OUEST) 2660 Rue King Ouest amenity=restaurant;cuisine=brasserie
BRASSERIE FLEURIMONT 1325 12e Avenue Nord amenity=restaurant;cuisine=brasserie
BRASSERIE LA SEIGNEURIE 14 Rue Léger amenity=restaurant;cuisine=brasserie
BRASSERIE LE DAUPHIN 1269 Rue King Est amenity=restaurant;cuisine=brasserie
BROCHETTERIE LA MAISON GRECQUE 514 Rue Galt Ouest amenity=restaurant;cuisine=greek
CAFÉ ARAGON INC 1497 Rue Galt Ouest amenity=restaurant;cuisine=regional
CAFÉ BEN LEE 7157 Boulevard Bourque amenity=restaurant;cuisine=chinese
CAFÉ BLA-BLA 2 Rue Wellington Sud amenity=restaurant;cuisine=bar&grill
CAFÉ DELUXE VIETNAMIEN 2227 Rue King Ouest amenity=restaurant;cuisine=vietnamese
CAFÉ PIERRE JEAN JASE 550 Rue de Montréal amenity=restaurant;cuisine=regional
CAFÉ RESTAURANT L 196 Rue Wellington Nord amenity=restaurant;cuisine=persian
CAFFUCCINO (BOUL. BOURQUE) 4257 Boulevard Bourque amenity=restaurant;cuisine=bar&grill
CAFFUCCINO (RUE KING OUEST) 1700 Rue King Ouest amenity=restaurant;cuisine=bar&grill
CAMÉLÉON SNACK & BAR 2150 Rue Galt Ouest amenity=restaurant;cuisine=bar&grill
COCO FRUTTI 3005 Rue King Ouest amenity=restaurant;cuisine=breakfast
COCO FRUTTI (BOUL. BOURQUE) 4857 Boulevard Bourque amenity=restaurant;cuisine=breakfast
COCO FRUTTI (RUE KING EST) 1235 Rue King Est amenity=restaurant;cuisine=breakfast
COCO LOCO 2680 Rue King Ouest amenity=restaurant;cuisine=breakfast
COCOFRUTTI (RUE BELVÉDÈRE SUD) 416 Rue Belvédère Sud amenity=restaurant;cuisine=breakfast
CRÊPERIE CK 961 Rue Galt Ouest amenity=restaurant;cuisine=mediterranean
CUISINE DU CHEF SAM 767 Rue King Est amenity=restaurant;
DÉGUSTATEUR CANTINE MODERNE 2222 Rue King Est amenity=restaurant;cuisine=fast_food
DÉLIA EGGXTRA INC. 661 Rue King Est amenity=restaurant;cuisine=breakfast
DI ME TUTTO PIZZERIA 182 Rue Wellington Nord amenity=restaurant;cuisine=pizza
EL TABERNACO 243 Rue Alexandre amenity=restaurant;cuisine=mexican
FREDDY PIZZERIA (RUE DU CONSEIL) 835 Rue du Conseil amenity=restaurant;cuisine=pizza
FROMAGERIE VICTORIA 4590 Boulevard Bourque amenity=restaurant;cuisine=pizza
GUACAMOLE Y TÉQUILA 2340 Rue King Ouest amenity=restaurant;cuisine=mexican
J'AIME TA FRAISE 2154 Rue King Ouest amenity=restaurant;cuisine=breakfast
JERRY PIZZERIA 106 Rue Queen amenity=restaurant;cuisine=pizza
JOHNNY RESTO ( RUE BELVÉDÈRE SUD) 419 Rue Belvédère Sud amenity=restaurant;cuisine=fast_food
KOBO RAMEN 1 Rue Wellington Nord amenity=restaurant;cuisine=noodle
KUTO COMPTOIR À TARTARES 4364 Boulevard Bourque amenity=restaurant;cuisine=tartare
KUTO COMPTOIR À TARTARES (12E AVENUE NORD) 2015 12e Avenue Nord amenity=restaurant;cuisine=tartare
KUTO COMPTOIR À TARTARES (RUE KING OUEST) 1705 Rue King Ouest amenity=restaurant;cuisine=tartare
LA BUVETTE DU CENTRO 117 Rue Wellington Nord amenity=restaurant;cuisine=bar&grill
LA CAGE BRASSERIE SPORTIVE 2655 Rue King Ouest amenity=restaurant;cuisine=brasserie
LA ROSE DES SABLES 270 Rue Dufferin amenity=restaurant;cuisine=moroccan
LE BALADI 123 Rue Wellington Nord amenity=restaurant;cuisine=moroccan
LE RANCH DU SPAGHETTI 4210 Boulevard Bourque amenity=restaurant;cuisine=pasta
LE VINTAGE 50 80 1112 Rue King Ouest amenity=restaurant;cuisine=fast_food
L'EMPREINTE 292 Rue King Ouest amenity=restaurant;cuisine=fine_dining
LES RÔTISSERIES ST-HUBERT (RUE KING OUEST) 3070 Rue King Ouest amenity=restaurant;cuisine=rotisserie
L'OMNIBOUFFE 660 Rue Bowen Sud amenity=restaurant;cuisine=diner
LOTUS BLANC VIETNAMIEN INC. 1564 Rue Denault amenity=restaurant;cuisine=vietnamese
MADAME PICKWICK 98 Rue Wellington Nord amenity=restaurant;cuisine=café
MASALA CAFÉ 61 Rue Wellington Nord amenity=restaurant;cuisine=indian
MAZAGAN 340 Rue Belvédère Sud amenity=restaurant;cuisine=mediterranean
MÉCHANT STEAK 111 Rue Wellington Nord amenity=restaurant;cuisine=steak_house
O CHEVREUIL 62 Rue Wellington Nord amenity=pub;cuisine=fine_dining
OMG RESTO 1175 Rue King Ouest amenity=pub;cuisine=fine_dining
PIZZA SALVATORE 901 Rue King Est amenity=restaurant;cuisine=pizza
PIZZÉRIA NO.900 3200 Rue King Ouest amenity=restaurant;cuisine=pizza
PIZZICATO 47 Rue King Ouest amenity=restaurant;cuisine=pizza;fine_dining
PURA VIDA BISTRO 3000 12e Avenue Nord amenity=restaurant;cuisine=diner
RESTAURANT AN PHU 1105 Rue King Est amenity=restaurant;cuisine=vietnamese
RESTAURANT BAUMANN 141 Rue Wellington Sud amenity=restaurant;cuisine=fine_dining
RESTAURANT BEYROUTH 966 Rue Galt Ouest amenity=restaurant;cuisine=lebanese
RESTAURANT BROCHETTERIE LE GREC 4385 Chemin Saint-Roch Nord amenity=restaurant;cuisine=greek
RESTAURANT CHANCHAI (RUE WELLINGTON N) 11 Rue Wellington Nord amenity=restaurant;cuisine=thai
RESTAURANT CHEZ LINH 900 Rue King Ouest amenity=restaurant;cuisine=vietnamese
RESTAURANT COMME CHEZ SOI 875 Rue Belvédère Sud amenity=restaurant;cuisine=diner
RESTAURANT DA LÉONARDO 4664 Boulevard Bourque amenity=restaurant;cuisine=italian
RESTAURANT EGGSFRUITS (RUE KING EST) 790 Rue King Est amenity=restaurant;cuisine=brunch
RESTAURANT EGGSFRUITS (RUE KING OUEST) 4200 Rue King Ouest amenity=restaurant;cuisine=brunch
RESTAURANT EGGSQUIS 3143 Boulevard de Portland amenity=restaurant;cuisine=brunch
RESTAURANT EGGSQUIS (BOUL. BOURQUE) 4795 Boulevard Bourque amenity=restaurant;cuisine=brunch
RESTAURANT EGGSQUIS (RUE KING EST) 565 Rue King Est amenity=restaurant;cuisine=brunch
RESTAURANT JACK'O (BOULEVARD BOURQUE) 5156 Boulevard Bourque amenity=restaurant;cuisine=pizza
RESTAURANT JACK'O (CHEMIN DE SAINT-ÉLIE) 6031 Chemin de Saint-Élie amenity=restaurant;cuisine=pizza
RESTAURANT KALYPSO 133 Rue Frontenac amenity=restaurant;cuisine=diner
RESTAURANT KING ALEXANDRE 276 Rue King Ouest amenity=pub;
RESTAURANT LA BOLDUC 5060 Boulevard Industriel amenity=restaurant;cuisine=canadian
RESTAURANT LA SUITE 100 Rue Webster amenity=restaurant;cuisine=fine_dining
RESTAURANT LE CHOUX DE BRUXELLES 1461 Rue Galt Ouest amenity=restaurant;cuisine=belgian
RESTAURANT LE PRINCIPAL 36 Rue Saint-Lambert amenity=restaurant;cuisine=pizza
RESTAURANT LE SULTAN 205 Rue Dufferin amenity=restaurant;cuisine=lebanese
RESTAURANT L'ENTR'AMIS 734 13e Avenue Nord amenity=pub;cuisine=fine_dining
RESTAURANT MIKES (RUE KING E) 735 Rue King Est amenity=restaurant;cuisine=sandwich
RESTAURANT NORMANDIN (RUE KING OUEST) 2707 Rue King Ouest amenity=restaurant;cuisine=diner
RESTAURANT OVERFLOW 1576 Rue King Ouest amenity=pub;
RESTAURANT PACINI 2960 Rue King Ouest amenity=restaurant;cuisine=italian
RESTAURANT PERSÉPOLIS 305 Rue King Ouest amenity=restaurant;cuisine=persian
RESTAURANT PHO LOC 1425 Rue King Ouest amenity=restaurant;cuisine=vietnamese
RESTAURANT RIMA (RUE GALT OUEST) 2128 Rue Galt Ouest amenity=restaurant;cuisine=lebanese
RESTAURANT RIMA (RUE QUEEN) 160 Rue Queen amenity=restaurant;cuisine=lebanese
RESTAURANT SHALIMAR 263 Rue Queen amenity=restaurant;cuisine=indian
RESTAURANT TRADITION SAIGON 820 Rue Belvédère Sud amenity=restaurant;cuisine=vietnamese
RESTAURANT WAKAI CUISINE ASIATIQUE 5178 Rue du Président-Kennedy amenity=restaurant;cuisine=asian
RESTO BAR CHEZ STANLEY 1180 Rue King Est amenity=pub;
ROTISSERIE CHANTECLERC 185 Rue Laval amenity=restaurant;cuisine=rotisserie
SAUG.E 17 Rue Peel amenity=restaurant;cuisine=brunch
SBALLO IL RISTORANTE 34 Rue Wellington Nord amenity=restaurant;cuisine=italian
SHAKER CUISINE & MIXOLOGIE 3050 Boulevard de Portland amenity=restaurant;cuisine=bar&grill
SHISH TAOUK SHERBROOKE 613 Rue King Est amenity=restaurant;cuisine=morrocan
STRATOS PIZZERIA (12E AVENUE NORD) 260 12e Avenue Nord amenity=restaurant;cuisine=pizza
THE GAITER GRILL 2600 Rue College amenity=restaurant;
VILLAGE DE CHINE 1748 Rue King Ouest amenity=restaurant;cuisine=chinese
VILLAGE GREC 1320 Rue Denault amenity=restaurant;cuisine=greek
VIN POLISSON 197 Rue King Ouest amenity=restaurant;cuisine=regional
VIRGULE CAFÉ 5400 Rue du Président-Kennedy amenity=restaurant;cuisine=diner
WESTLEY - ARTISANS RESTAURATEURS 3200 Rue King Ouest amenity=restaurant;cuisine=diner
DEWHURST DINNING HALL 2600 Rue College fast_food=cafeteria;

(Work in progress)...