< USA | Great Lakes
(Initial page creation from preload) |
|||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 20: | Line 20: | ||
[https://docs.google.com/spreadsheets/u/0/d/1-f-JTWY5UnBx-rFTa4qhyGMYdHBZWNirUTOgn222zMY/pubhtml?gid=1292189415&single=true View this list full-screen in Google Sheets] | [https://docs.google.com/spreadsheets/u/0/d/1-f-JTWY5UnBx-rFTa4qhyGMYdHBZWNirUTOgn222zMY/pubhtml?gid=1292189415&single=true View this list full-screen in Google Sheets] | ||
<br /> | |||
<br /> | |||
*<b>Place Categories</b> | |||
:Some Places are not chains and therefore will not be harmonized but still need the correct category. The below sheet is a mapping for the business type to the correct category, for the Great Lakes Region. | |||
{{#widget:Iframe | |||
|url=https://docs.google.com/spreadsheets/d/e/2PACX-1vTf57YufmYRdvoa7gIapIk2GQNnAq_nsj4PNAY0GsQz2fVtvmkkEBeXnb_r_tWsv9hIAVmtgW_pWbsd/pubhtml?gid=0&single=true&widget=true&headers=false | |||
|width=100% | |||
|height=500 | |||
|border=0 | |||
}} | |||
[https://docs.google.com/spreadsheets/d/e/2PACX-1vTf57YufmYRdvoa7gIapIk2GQNnAq_nsj4PNAY0GsQz2fVtvmkkEBeXnb_r_tWsv9hIAVmtgW_pWbsd/pubhtml?gid=0&single=true View this list full-screen in Google Sheets] | |||
*<b>Place Lock Standard</b><br /> | *<b>Place Lock Standard</b><br /> | ||
Places should be locked to the below standards, only after all data fields have been filled. At a minimum ensure that Category, Name and Address (street and house number), and Brand (for gas stations) have information. Note for gas stations - DO NOT USE THE BRAND "UNBRANDED". If it is a no brand gas station, just leave the brand field blank.<br /> | Places should be locked to the below standards, only after all data fields have been filled. At a minimum ensure that Category, Name and Address (street and house number), and Brand (for gas stations) have information. Note for gas stations - DO NOT USE THE BRAND "UNBRANDED". If it is a no brand gas station, just leave the brand field blank.<br /> | ||
Latest revision as of 16:20, 28 December 2017
Places and Chain Harmonization Sheet
- The Place Harmonizer script found here should be used for all places.
- Phone Numbers
Places should use the following phone number format: xxx-xxx-xxxx
Note: Running the Place Harmonization script on a place will automatically correct the phone number to this format
- Chain Businesses and Missing Chains
- If you don't find the business you're looking on the sheet below, please use the built in functionality of the place harmonizer script to add it. There is a sheet maintained for each region.
View this list full-screen in Google Sheets
- Place Categories
- Some Places are not chains and therefore will not be harmonized but still need the correct category. The below sheet is a mapping for the business type to the correct category, for the Great Lakes Region.
View this list full-screen in Google Sheets
- Place Lock Standard
Places should be locked to the below standards, only after all data fields have been filled. At a minimum ensure that Category, Name and Address (street and house number), and Brand (for gas stations) have information. Note for gas stations - DO NOT USE THE BRAND "UNBRANDED". If it is a no brand gas station, just leave the brand field blank.
Any place that has at least a correct category, correct name, and correct address with house number should be locked to 3.