[Talk-GB] Importing UK LDP relations with osm2pgsql
Graham Jones
grahamjones139 at gmail.com
Sun Nov 14 11:49:06 GMT 2010
>
> Nick,
> I haven't got around to doing this myself yet, so I could be wrong, but I
> thought it was all about the planet_osm_rels table.
>
> If you do something like:
> select tags, members,parts from planet_osm_rels where tags @>
> '{Cleveland Way}';
> You get two arrays 'members' and 'parts', which I thought were the ID's of
> the members of the relation.
>
> It might be worth a look at http://osm.lonvia.de/world_hiking/about.html too
> - the author of that site is very helpful when I have asked her questions
> about it!
>
> Graham.
>
> On 14 November 2010 11:05, Nick Whitelegg <Nick.Whitelegg at solent.ac.uk>wrote:
>
>> Hi,
>>
>> I want to render UK Long Distance Paths on Freemap and am wondering how
>> the relations are imported into a PostGIS db with osm2pgsql.
>>
>> My guess is that they would be imported as a series of ways with the route
>> tag set appropriately, e.g route=foot, route=hiking; however this has not
>> occurred, e.g.
>>
>> select route from planet_osm_line where name='South Downs Way';
>>
>> gives a blank string for the 'route' tag even though the relation is
>> present, with a 'route=hiking' tag, in OSM (AFAIK it has been for at least a
>> year, it has a last-edited date of Oct 20, and the database is more recent
>> than Oct 20...)
>>
>> It seems one or two UK LDPs are there - the Maelor Way and the Calderdale
>> Way - but nothing else.
>>
>> Any ideas on this? Is it an import issue?
>>
>> Thanks,
>> Nick
>>
>>
>> _______________________________________________
>> 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/20101114/e2d5a6fc/attachment.html>
More information about the Talk-GB
mailing list