<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Are you sure it's upto date?:<br>
<br>
<div class="nhsuk-review-date">
<p class="nhsuk-body-s"> Page last reviewed: 15 December 2016<br>
Next review due: 15 December 2019 </p>
</div>
<aside class="nhsuk-grid-column-one-third">
<div class="nhsuk-related-nav">
<nav class="nhsuk-related-nav__nav-section"><br>
The 'GPs' is corrupted with Chines symbols.<br>
</nav>
</div>
</aside>
<br>
<br>
<div class="moz-cite-prefix">On 16/04/2020 17:18, Mike Baggaley
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:001f01d6140a$b6b10010$24130030$@tvage.co.uk">
<pre class="moz-quote-pre" wrap="">The data at <a class="moz-txt-link-freetext" href="https://data.gov.uk/dataset/e373eb6a-fffd-48e5-b306-71eb17f97af2/pharmacies">https://data.gov.uk/dataset/e373eb6a-fffd-48e5-b306-71eb17f97af2/pharmacies</a> looks like an out of date copy of the NHS data to me. You can use the data at <a class="moz-txt-link-freetext" href="https://www.nhs.uk/about-us/nhs-website-datasets/">https://www.nhs.uk/about-us/nhs-website-datasets/</a> which is regularly updated. It even includes an opening hours file which can be linked to the pharmacies. You will need to use "¬" as the column separator. Instead of double clicking on the csv file, open Excel with an empty spreadsheet and use import file. You can then choose the column separator. If you follow the "About our data downloads" link it tells you how to import the data. I assume the data is combined from various regions which use their own systems, hence the variety of ways of holding the address data.
Regards,
Mike
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">Yes, the first two links at
<a class="moz-txt-link-freetext" href="https://data.gov.uk/dataset/e373eb6a-fffd-48e5-b306-71eb17f97af2/pharmacies">https://data.gov.uk/dataset/e373eb6a-fffd-48e5-b306-71eb17f97af2/pharmacies</a>
are broken for me as well. For the third link, it looks like they
tried to do CSV, but didn't understand how to escape commas within the
fields, and so opted to use a different character "¬" instead. If you
import this into a spreadsheet, and tell it to use just "¬" as the
column separator, I think it works out fine, with all the entries in
the right place. (You can certainly do this with LibreOffice; I'm not
sure about Excel.) The address lines seem to be used inconsistently,
but everything is back aligned when you get to the postcode field.
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
_______________________________________________
Talk-GB mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Talk-GB@openstreetmap.org">Talk-GB@openstreetmap.org</a>
<a class="moz-txt-link-freetext" href="https://lists.openstreetmap.org/listinfo/talk-gb">https://lists.openstreetmap.org/listinfo/talk-gb</a>
</pre>
</blockquote>
<br>
</body>
</html>