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