[Openstreetmap] Re: Naming segments using applet

Immanuel Scholz immanuel.scholz at gmx.de
Thu Dec 8 07:00:25 GMT 2005


> some times ago i proposed a different but similar approach
> Streets is a new table that holds informations like name,
> importance (overland/local/city),
> which city, region or country it belongs to (might be empty)
> street and track segment are connected by a n:n relation
> so a street can have [1,n] tracks,
> while a track segment can belong to [0,n] streets

The suggestion you made for the relationship between segments and
streets are the very same with the one that will be implemented

The differences to your original idea are that now nodes can be part of
more than one segment and that a segment consist of only two nodes, not
a list of nodes.

> there must be a ERD for this on the wiki


(The ip is, but beware: the site uses virtual hosts)

Ciao, Imi.

More information about the talk mailing list