Re: [OSM-dev] re-creating turn restriction geometry from osmosis based postgis

2019-11-21 Thread Gerd Petermann
Keep in mind that there are a few restrictions with one or more via ways.

Gerd


Von: maning sambale 
Gesendet: Donnerstag, 21. November 2019 15:57
An: Martin Koppenhoefer
Cc: dev@openstreetmap.org
Betreff: Re: [OSM-dev] re-creating turn restriction geometry from osmosis based 
postgis

Thanks Martin.

I'll give this a try.

On Wed, Nov 20, 2019 at 1:30 AM Martin Koppenhoefer
 wrote:
>
>
>
> sent from a phone
>
> > On 19. Nov 2019, at 17:03, maning sambale  
> > wrote:
> >
> > My db has the ways, nodes table with geometry and relations and
> > relation_members referencing the members.
>
>
> you could count all relations with type=restriction where the via member is 
> in your polygon.
>
> Cheers Martin



--
cheers,
maning
--
"Freedom is still the most radical idea of all" -N.Branden
https://github.com/maning
http://twitter.com/maningsambale
--

___
dev mailing list
dev@openstreetmap.org
https://lists.openstreetmap.org/listinfo/dev

___
dev mailing list
dev@openstreetmap.org
https://lists.openstreetmap.org/listinfo/dev


Re: [OSM-dev] re-creating turn restriction geometry from osmosis based postgis

2019-11-21 Thread maning sambale
Thanks Martin.

I'll give this a try.

On Wed, Nov 20, 2019 at 1:30 AM Martin Koppenhoefer
 wrote:
>
>
>
> sent from a phone
>
> > On 19. Nov 2019, at 17:03, maning sambale  
> > wrote:
> >
> > My db has the ways, nodes table with geometry and relations and
> > relation_members referencing the members.
>
>
> you could count all relations with type=restriction where the via member is 
> in your polygon.
>
> Cheers Martin



-- 
cheers,
maning
--
"Freedom is still the most radical idea of all" -N.Branden
https://github.com/maning
http://twitter.com/maningsambale
--

___
dev mailing list
dev@openstreetmap.org
https://lists.openstreetmap.org/listinfo/dev


Re: [OSM-dev] re-creating turn restriction geometry from osmosis based postgis

2019-11-19 Thread Martin Koppenhoefer


sent from a phone

> On 19. Nov 2019, at 17:03, maning sambale  wrote:
> 
> My db has the ways, nodes table with geometry and relations and
> relation_members referencing the members.


you could count all relations with type=restriction where the via member is in 
your polygon.

Cheers Martin 
___
dev mailing list
dev@openstreetmap.org
https://lists.openstreetmap.org/listinfo/dev