<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi all<div>there is another approach, which is to download the data for all companies in the UK from Companies House. This became available as free public data in July.</div><div>The full address and postcode is there along with a URI (not the same as the company number).</div><div>I prefer this approach to private house sales because</div><div>- companies want to be found</div><div>- there isn't a privacy issue from address being matched to other data to identify individuals (although that will happen)</div><div>- OSM has less complete business listings than Google maps. For SMEs the company address and business premises will often be the same.</div><div>- connecting OSM location data with Open Corporates <a href="http://opencorporates.com/">http://opencorporates.com/</a> would enhance both services.</div><div><br></div><div>The data is listed alphabetically. Would be useful to group them geographically and extract the West Midlands addresses. It's not difficult to extract the column for URIs, which gives the link to the Companies House web page for the company.</div><div>Download the data from <a href="http://download.companieshouse.gov.uk/en_output.html">http://download.companieshouse.gov.uk/en_output.html</a></div><div><br></div><div>Andrew</div><div><br></div><div><div><div>On 31 Aug 2012, at 10:48, Andy Robinson wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div><a href="http://www.landregistry.gov.uk/public/information/public-data/price-paid-dat">http://www.landregistry.gov.uk/public/information/public-data/price-paid-dat</a><br>a<br><br><br><blockquote type="cite">-----Original Message-----<br></blockquote><blockquote type="cite">From: Big Fat Frog [mailto:bigfatfrog67@gmail.com]<br></blockquote><blockquote type="cite">Sent: 31 August 2012 10:11<br></blockquote><blockquote type="cite">To: talk-gb-westmidlands@openstreetmap.org<br></blockquote><blockquote type="cite">Subject: Re: [Talk-gb-westmidlands] [Talk-GB] UK Postcodes - Potential<br></blockquote>data<br><blockquote type="cite">source<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Have I missed something? What datasource are you referring to here?<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Jonathan<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">On 31/08/2012 09:44, Andy Robinson wrote:<br></blockquote><blockquote type="cite"><blockquote type="cite">In the meantime I'm just downloading the files and filtering in<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">spreadsheet for my patch (Sutton Coldfield) and then checking/adding<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">postcode data for the handful of addresses it contains for each month.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Though this only really works if you have the majority of your<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">building addressing done for an area.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">As I'm now adding some postcode data from this source I've added the<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">required attribution to<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">http://wiki.openstreetmap.org/wiki/Contributors#United_Kingdom<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Incidentally, what do folks feel about adding any of the other data<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">from the dataset?:<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">.the full address of the property (Primary addressable object name<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">(PAON), Secondary addressable object name (SAON), street, postcode,<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">locality (if available), town, district, county)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">.the price paid for the property<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">.the date of transfer<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">.the property type (Detached, Semi, Terraced, Flat/Maisonette)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">.whether the property is new build or not<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">.whether the property is freehold or leasehold.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Cheers<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Andy<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">*From:*Brian Prangle [mailto:bprangle@gmail.com]<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">*Sent:* 31 August 2012 08:27<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">*To:* Rob Nickerson; talk-gb-westmidlands<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">*Subject:* Re: [Talk-gb-westmidlands] [Talk-GB] UK Postcodes -<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Potential data source<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">I'd agree with Rob's logic and extend it to show one of three results:<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">postcode missing or postcode incomplete or postcode incorrect. We have<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">loads of addresses with only the first group in place e.g B27 and I'm<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">sure when we were using codepoint( before we knew it was dodgy in<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">licensing terms) we chose the wrong break point in address runs. We<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">currently have 61272 addresses in the W Mids and 44164 have postcodes.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">regards<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Brian<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">On 30 August 2012 18:35, Rob Nickerson <rob.j.nickerson@gmail.com<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><mailto:rob.j.nickerson@gmail.com>> wrote:<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">== Matt wrote ==<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">This does indeed seem like a very useful data source. Great find!<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">However, I'm struggling to think of a nice way of visualising it to<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">make it useful. What I've got so far in my mind is:<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> - Take an entry from the list<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> - Take its postcode<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> - Search for the postcode (I've got a curated list of postcodes as<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">part of my PostCodeFinder [1])<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> - Get the location of the nearest match (hopefully, we'll find at<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">least a CV4-type segment match)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> - Search for roads within an x mile radius with a matching name<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"> - Associate that entry with that road<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">== End Message ==<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Hi Matt,<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">I was actually thinking the other way round. That is:<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Pull in a list of building with addresses but no postcode in OSM (with<br></blockquote></blockquote>their<br><blockquote type="cite">way IDs) and see if any match up with the Land Registry addresses. This<br></blockquote>way<br><blockquote type="cite">we can add postcode to buildings rather than just to the roads.<br></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Not sure if this is any easier/harder to do.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Regards,<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Rob<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">_______________________________________________<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Talk-GB mailing list<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Talk-GB@openstreetmap.org <mailto:Talk-GB@openstreetmap.org><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">http://lists.openstreetmap.org/listinfo/talk-gb<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">_______________________________________________<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Talk-gb-westmidlands mailing list<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Talk-gb-westmidlands@openstreetmap.org<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">http://lists.openstreetmap.org/listinfo/talk-gb-westmidlands<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">_______________________________________________<br></blockquote><blockquote type="cite">Talk-gb-westmidlands mailing list<br></blockquote><blockquote type="cite">Talk-gb-westmidlands@openstreetmap.org<br></blockquote><blockquote type="cite">http://lists.openstreetmap.org/listinfo/talk-gb-westmidlands<br></blockquote><br><br>_______________________________________________<br>Talk-gb-westmidlands mailing list<br>Talk-gb-westmidlands@openstreetmap.org<br>http://lists.openstreetmap.org/listinfo/talk-gb-westmidlands<br></div></blockquote></div><br></div></body></html>