USA/Great Lakes/Places/Main: Difference between revisions View history

(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&amp;widget=true&amp;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.