<html xmlns:v="urn:schemas-microsoft-com:vml" 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>
<!-- Template generated by Exclaimer Mail Disclaimers on 11:41:28 Thursday, 18 April 2013 -->
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css">P.d149c9fa-9537-41ff-8a80-fcc79aff3db2 {
        MARGIN: 0cm 0cm 0pt
}
LI.d149c9fa-9537-41ff-8a80-fcc79aff3db2 {
        MARGIN: 0cm 0cm 0pt
}
DIV.d149c9fa-9537-41ff-8a80-fcc79aff3db2 {
        MARGIN: 0cm 0cm 0pt
}
TABLE.d149c9fa-9537-41ff-8a80-fcc79aff3db2Table {
        MARGIN: 0cm 0cm 0pt
}
DIV.Section1 {
        page: Section1
}
</style>
<meta name="Generator" content="Microsoft Word 12 (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:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
p
        {mso-style-priority:99;
        mso-margin-top-alt:auto;
        margin-right:0cm;
        mso-margin-bottom-alt:auto;
        margin-left:0cm;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
span.EmailStyle18
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
.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;}
/* List Definitions */
@list l0
        {mso-list-id:417604484;
        mso-list-template-ids:-1962405024;}
@list l1
        {mso-list-id:1572539518;
        mso-list-template-ids:78036588;}
ol
        {margin-bottom:0cm;}
ul
        {margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="blue" vlink="purple">    
    
<p class="d149c9fa-9537-41ff-8a80-fcc79aff3db2"></p>
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">I thought that we’d imported the NAPTAN dataset, which should mean we have ALL the bus stops in the UK? So why do OSGB have more?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<div style="border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt">
<div></div>
</div>
</div>
<p></p>
<p class="d149c9fa-9537-41ff-8a80-fcc79aff3db2"> </p>
<p class="d149c9fa-9537-41ff-8a80-fcc79aff3db2"><img id="IMG1" border="0" src="http://images.itn.co.uk/images/ITN_Master_blue.gif" width="80" height="56"></p>
<font face="Arial">
<p class="d149c9fa-9537-41ff-8a80-fcc79aff3db2"><span style="font-family:Arial; font-size:xx-small; color: #006699; font-weight: bold; ">PHILLIP</span><font color="#006699" size="1"><strong> </strong></font><span style="font-family:Arial; font-size:xx-small; color: #006699; font-weight: bold; ">BARNETT</span><br>
<span style="font-family:Arial; font-size:xx-small; color: #006699; font-weight: bold; ">SERVER MANAGER</span><br>
<br>
<span style="font-family:Arial; font-size:xx-small; ">200 GRAY'S INN ROAD</span><br>
<span style="font-family:Arial; font-size:xx-small; ">LONDON</span><br>
<span style="font-family:Arial; font-size:xx-small; ">WC1X 8XZ</span><font size="1"><br>
UNITED KINGDOM<br>
</font><font size="1">T </font><span style="font-family:Arial; font-size:xx-small; ">+44 207 430 4474</span><font size="1"><br>
E </font><span style="font-family:Arial; font-size:xx-small; ">PHILLIP.BARNETT@ITN.CO.UK</span><br>
<font size="1"><span style="font-family:Arial; font-size:xx-small; ">WWW.ITN.CO.UK</span></font><span style="FONT-FAMILY: Webdings; COLOR: #007d00; FONT-SIZE: 18pt; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: Arial; mso-ansi-language: EN-GB; mso-fareast-language: EN-GB; mso-bidi-language: AR-SA"><br>
P</span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #007d00; FONT-SIZE: 8pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-GB; mso-fareast-language: EN-GB; mso-bidi-language: AR-SA">
</span><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #007d00; FONT-SIZE: 7.5pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-GB; mso-fareast-language: EN-GB; mso-bidi-language: AR-SA"> Please consider the environment. Do you really
 need to print this email?</span></p>
</font>
<p class="d149c9fa-9537-41ff-8a80-fcc79aff3db2"> </p>
<p class="d149c9fa-9537-41ff-8a80-fcc79aff3db2"></p>
<div class="WordSection1">
<div style="border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt">
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> sk53.osm [mailto:sk53.osm@gmail.com]
<br>
<b>Sent:</b> 18 April 2013 10:28<br>
<b>To:</b> talk-gb@openstreetmap.org<br>
<b>Subject:</b> [Talk-GB] 10 fascinating facts about OSM & OSGB<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal">OSGB has just tweeted it's 10 fascinating facts. I thought it would be fun to compare with OSM<o:p></o:p></p>
</div>
<ol start="1" type="1">
<li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1">
Pylons: 80,517 ; 58,487 (<a href="http://taginfo.openstreetmap.org.uk/search?q=tower#values">OSM</a>)<o:p></o:p></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1">
Post Boxes: 93.728 (OSGB); 42,742 (<a href="http://taginfo.openstreetmap.org.uk/search?q=post_box#values">OSM</a>)<o:p></o:p></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1">
Camp sites: 8,908 (OSGB); 1 274 (<a href="http://taginfo.openstreetmap.org.uk/search?q=camp_site#values">camp_site</a>) + 1 918 (<a href="http://taginfo.openstreetmap.org.uk/search?q=caravan#values">caravan_site</a>) = 3,192 (OSM)<o:p></o:p></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1">
Buildings: 35,397,754 (OSGB); 1,890,835 (<a href="http://taginfo.openstreetmap.org.uk/search?q=building">OSM</a>)<o:p></o:p></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1">
Bus Stops: 354,099 (OSGB); 215,720 (<a href="http://taginfo.openstreetmap.org.uk/search?q=fuel#values">OSM</a>)<o:p></o:p></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1">
2,115,006 (OSGB);<o:p></o:p></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1">
Petrol Stations: 7,702 (OSGB); 5,197 (<a href="http://taginfo.openstreetmap.org.uk/search?q=fuel#values">OSM</a>)<o:p></o:p></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1">
Addresses: 27,341,262 (OSGB); 532,886 (<a href="http://taginfo.openstreetmap.org.uk/keys/addr:housenumber">OSM</a>)<o:p></o:p></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1">
Electricity Poles: 183, 987 (OSGB); 94,199 (<a href="http://taginfo.openstreetmap.org.uk/search?q=pole#values">OSM</a>)<o:p></o:p></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1">
Road length: 407,532 km (OSGB); 522,627 (OSM)<o:p></o:p></li></ol>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="116" style="width:87.0pt;margin-left:36.0pt">
<tbody>
<tr style="height:12.75pt">
<td width="116" style="width:87.0pt;padding:0cm 0cm 0cm 0cm;height:12.75pt"></td>
</tr>
</tbody>
</table>
<p>Of course there is no guarantee we are comparing like for like (although its only power=pole which looks suspiciously high, I suspect we map low power lines not included by OSGB).<o:p></o:p></p>
<p>All values from UK taginfo (except for road length, which I queried from a snapshot schema), no data merging or need to query multiple sources, and certainly no need for an IBM Netezza appliance.<o:p></o:p></p>
<p>I thought I'd add a few more quirky OSM values:<o:p></o:p></p>
<ol start="1" type="1">
<li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l1 level1 lfo2">
<a href="http://taginfo.openstreetmap.org.uk/tags/royal_cypher=EVIIIR">5</a> post boxes with Edward VIII's royal cypher<o:p></o:p></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l1 level1 lfo2">
only <a href="http://taginfo.openstreetmap.org.uk/tags/memorial=war_memorial">110</a> War Memorials <o:p></o:p></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l1 level1 lfo2">
<a href="http://taginfo.openstreetmap.org.uk/search?q=police#values">1830</a> Police and
<a href="http://taginfo.openstreetmap.org.uk/search?q=fire#values">1518</a> Fire Stations<o:p></o:p></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l1 level1 lfo2">
847 Fire Hydrants (see above)<o:p></o:p></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l1 level1 lfo2">
<a href="http://taginfo.openstreetmap.org.uk/search?q=real_ale">1378</a> establishments purveying Real Ale, and
<a href="http://taginfo.openstreetmap.org.uk/search?q=cider">156</a> Real Cider out of
<a href="http://taginfo.openstreetmap.org.uk/search?q=pub#values">32,624 Pubs </a>
and 1717 <a href="http://taginfo.openstreetmap.org.uk/search?q=bar#values">Bars</a> (including 1 with ale_supply_limited, and ONLY 1 with
<a href="http://taginfo.openstreetmap.org.uk/keys/osm%3Alondon#overview">osm:london=approval</a>)<o:p></o:p></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l1 level1 lfo2">
<a href="http://taginfo.openstreetmap.org.uk/keys/bicycle_parking">4771</a> Bicycle Parking locations<o:p></o:p></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l1 level1 lfo2">
around 300<a href="http://taginfo.openstreetmap.org.uk/search?q=hide#values">http://taginfo.openstreetmap.org.uk/search?q=hide#values</a> bird/wildlife hides<o:p></o:p></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l1 level1 lfo2">
<a href="http://taginfo.openstreetmap.org.uk/search?q=knitting#values">2</a> knitting shops (shows gender of mappers I suspect)<o:p></o:p></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l1 level1 lfo2">
<a href="http://taginfo.openstreetmap.org.uk/keys/stile#values">5552</a> stiles<o:p></o:p></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l1 level1 lfo2">
<a href="http://taginfo.openstreetmap.org.uk/search?q=lock">1774</a> canal locks<o:p></o:p></li></ol>
<p>Jerry<o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>
<p></p>

    <BR>
    <BR>
   <span style="font-family:Arial; Font-size:7.0pt">
Please Note:<br><br>

Any views or opinions are solely those of the author and do not necessarily represent those of Independent Television News Limited unless specifically stated. This email and any files attached are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error, please notify postmaster@itn.co.uk<br><br> 

Please note that to ensure regulatory compliance and for the protection of our clients and business, we may monitor and read messages sent to and from our systems.

  </span>
 </body>
</html>