<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:"Yu Gothic";
panose-1:2 11 4 0 0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"\@Yu Gothic";
panose-1:2 11 4 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style></head><body lang=EN-CA link=blue vlink="#954F72"><div class=WordSection1><p class=MsoNormal>You can also use a simple overpass query to find out which post offices are tagged with the name “Canada Post”. Here’s what such a query looks like in QL:</p><p class=MsoNormal>----</p><p class=MsoNormal>[out:json][timeout:45];</p><p class=MsoNormal>// gather results</p><p class=MsoNormal>(</p><p class=MsoNormal> // query part for: “amenity=post_office”</p><p class=MsoNormal> way["amenity"="post_office"]</p><p class=MsoNormal> ["name"="Canada Post"]</p><p class=MsoNormal> (area:3600068841); // Ontario</p><p class=MsoNormal>);</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>// print results</p><p class=MsoNormal>out body;</p><p class=MsoNormal>>;</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>out skel qt;</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>node</p><p class=MsoNormal> [amenity=post_office]</p><p class=MsoNormal> [name="Canada Post"]</p><p class=MsoNormal> (area:3600068841); // Ontario</p><p class=MsoNormal>out;</p><p class=MsoNormal>----</p><p class=MsoNormal>- David E. Nelson</p><p class=MsoNormal><a href="https://www.openstreetmap.org/user/DENelson83">https://www.openstreetmap.org/user/DENelson83</a></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Sent from <a href="https://go.microsoft.com/fwlink/?LinkId=550986">Mail</a> for Windows 10</p><p class=MsoNormal><o:p> </o:p></p><div style='mso-element:para-border-div;border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal style='border:none;padding:0cm'><b>From: </b><a href="mailto:talk-ca@openstreetmap.org">David E. Nelson via Talk-ca</a><br><b>Sent: </b>March 28, 2020 17:36<br><b>To: </b><a href="mailto:talk-ca@openstreetmap.org">talk-ca@openstreetmap.org</a><br><b>Subject: </b>Re: [Talk-ca] Canada Post offices</p></div><p class=MsoNormal><o:p> </o:p></p><div><p>I have highlighted in the spreadsheets which post offices are tagged with their correct postal codes. Those postal codes are now in bold type.</p><p>- David E. Nelson</p><p>https://www.openstreetmap.org/user/DENelson83</p></div><div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>On Mar. 28, 2020 15:39, john whelan <jwhelan0112@gmail.com> wrote:</p><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm'><div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Verdana",sans-serif'>It might be worthwhile highlighting those that do not have a postcode or are tagged name=Canada Post.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Verdana",sans-serif'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Verdana",sans-serif'>Useful locally as I hadn't checked the ones I know of had been mapped nor that their details were correct. I did note one address was wrong, the post office had moved from one side of the street to the other a year or so ago.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Verdana",sans-serif'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Verdana",sans-serif'>Thanks John<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>On Sat, 28 Mar 2020 at 16:04, David E. Nelson via Talk-ca <<a href="mailto:talk-ca@openstreetmap.org">talk-ca@openstreetmap.org</a>> wrote:</p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm'><div><div><p class=MsoNormal>I have started a project with the objective of adding as many post offices as can be found in Canada to OpenStreetMap.</p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Canada Post's own database yields just over 6000 post offices within the country, and I have used the Overpass API to determine that just over 2000 of those, or only about one in every three such outlets, have already been added to OSM's database.</p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>I would like to enlist the help of mappers across Canada to add as many more of the missing post offices as they can find. To that end, I have produced these spreadsheets detailing which post offices have already been added to OSM and which have not.</p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Atlantic (A, B, C, E): <<a href="https://docs.google.com/spreadsheets/d/13O2oY4te6EvOPSqpaCOtWbUZ2UkO-ahq9CeODruvcDA/">https://docs.google.com/spreadsheets/d/13O2oY4te6EvOPSqpaCOtWbUZ2UkO-ahq9CeODruvcDA/</a>></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Quebec (G, H, J):</p></div><div><p class=MsoNormal><<a href="https://docs.google.com/spreadsheets/d/1IOrbwQsEgSM8PvzWzBDHNPvM0d3HsiW_XLXYnK7utm8/">https://docs.google.com/spreadsheets/d/1IOrbwQsEgSM8PvzWzBDHNPvM0d3HsiW_XLXYnK7utm8/</a>></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Ontario (K, L, M, N, P):</p></div><div><p class=MsoNormal><<a href="https://docs.google.com/spreadsheets/d/1k_mOmiL15L6ObCeJJ8DntVBXb21JSZwOsJTbfb1FOI0/">https://docs.google.com/spreadsheets/d/1k_mOmiL15L6ObCeJJ8DntVBXb21JSZwOsJTbfb1FOI0/</a>></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Western and Northern (R, S, T, V, X, Y):</p></div><div><p class=MsoNormal><<a href="https://docs.google.com/spreadsheets/d/1lcOL5ISS9aML6oaUOcgyngw4bio_gRmbxzLn-4GCjXQ/">https://docs.google.com/spreadsheets/d/1lcOL5ISS9aML6oaUOcgyngw4bio_gRmbxzLn-4GCjXQ/</a>></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Each spreadsheet has a "master list" of post offices, and each of those entries has been colour-coded according to their disposition:</p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Green = Already added to OSM; node/way ID given, with dash before ID indicating a way, no dash indicating a node</p></div><div><p class=MsoNormal>Red = Not yet added to OSM</p></div><div><p class=MsoNormal>Yellow = Location listed on <a href="http://waymarking.com">waymarking.com</a> (although I am not sure <a href="http://waymarking.com">waymarking.com</a> data is licence-compatible with OSM) <<a href="https://www.waymarking.com/cat/details.aspx?f=1&guid=610386da-84d0-4983-bdf1-7eb34a03e64b">https://www.waymarking.com/cat/details.aspx?f=1&guid=610386da-84d0-4983-bdf1-7eb34a03e64b</a>></p></div><div><p class=MsoNormal>Blue = Added to OSM, but since moved to a new location or simply needs to have its address re-verified</p></div><div><p class=MsoNormal>Lilac = Postal code needs to be corrected—the correct postal code is in the spreadsheet; postal codes for Canada Post facilities *always* end with a zero</p></div><div><p class=MsoNormal>Violet = A letter has been sent to that post office asking for its precise geographical location</p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Each spreadsheet also has a second sheet titled "extraneous data", detailing which post offices found in the OSM data have been determined to have closed; which OSM post office data is redundant and needs to be merged, i.e., if a single post office location has both a way and a disconnected node describing it, in which case the tags from the node should be moved to the way; and which locations have been erroneously tagged as post offices. Only locations branded as Canada Post where postage stamps can be purchased should have the "amenity=post_office" tag, while outlets branded as "FedEx", "UPS", or any other private courier should instead be tagged as "office=logistics".</p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>I would also like to see a harmonized tagging schema for Canada Post outlets, consisting as follows:</p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>addr:housenumber (Use ground survey or local knowledge wherever and whenever possible)</p></div><div><p class=MsoNormal>addr:postcode (Use from spreadsheets)</p></div><div><p class=MsoNormal>addr:street (Use ground survey or local knowledge wherever and whenever possible)</p></div><div><p class=MsoNormal>amenity=post_office</p></div><div><p class=MsoNormal>brand=Canada Post</p></div><div><p class=MsoNormal>brand:wikipedia=en:Canada Post</p></div><div><p class=MsoNormal>brand:wikidata=Q1032001</p></div><div><p class=MsoNormal>name (Use from spreadsheets)</p></div><div><p class=MsoNormal>operator (Either "Canada Post", for an outlet run directly by Canada Post, or for an independently-run franchise, the name of the business that the postal outlet can be found in)</p></div><div><p class=MsoNormal>phone (Optional)</p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>I would prefer that no two or more post office locations share a postal code. If this is not the case, only the outlet listed in the above spreadsheets should get tagged with "addr:postcode", while the others not use the "addr:postcode" tag at all. As well, no two post office locations within the same province or territory should be permitted to have identical name values, and I have made sure of that in the spreadsheets.</p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>- David E. Nelson</p></div><div><p class=MsoNormal><a href="https://www.openstreetmap.org/user/DENelson83">https://www.openstreetmap.org/user/DENelson83</a></p></div></div><p class=MsoNormal>_______________________________________________<br>Talk-ca mailing list<br><a href="mailto:Talk-ca@openstreetmap.org">Talk-ca@openstreetmap.org</a><br><a href="https://lists.openstreetmap.org/listinfo/talk-ca">https://lists.openstreetmap.org/listinfo/talk-ca</a></p></blockquote></div></blockquote></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>