[Talk-GB] OS Locator / OSM correspondence list generation

[Jerry Clough - OSM]

Further playing around with the first set of data (PostGIS learning improving):

http://wiki.openstreetmap.org/wiki/User:SK53/Missing_Names_by_District
http://wiki.openstreetmap.org/wiki/User:SK53/Missing_Nottingham_Names (big, but using PostGIS allocated to cake slices)

Jerry




________________________________
From: Robert Scott <lists at humanleg.org.uk>
To: talk-gb at openstreetmap.org
Sent: Thu, 13 May, 2010 21:53:40
Subject: Re: [Talk-GB] OS Locator / OSM correspondence list generation

On Thursday 13 May 2010, Jerry Clough - OSM wrote:
> Thanks very much for this Robert. 
> 
> I'd made a start trying to do this myself, but had a steep learning curve with PostGIS. My main suggestions (which will make the file bigger) are: a) retain the original centroid values (these are near as dammit a primary key);

Mmm - I think line numbers are fine for now - the issue comes when (if) OS release the next OS Locator and we need to track differences. In this situation, tiny changes in the centroid would change the primary key anyway.

> and b) keep one or more of the district authority columns. In particular the latter will make it very much easier to filter for people interested in a particular district, rather than having to fiddle with bounding boxes. 

I was intending this to be used alongside the original OS Locator file - in fact I was going to just put the two id columns and an ldist column and let people do the join themselves.

I've got another file baking at the moment with a newer planet and slightly stricter normalization.


robert.

_______________________________________________
Talk-GB mailing list
Talk-GB at openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk-gb



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk-gb/attachments/20100514/2659d4bd/attachment-0001.html>