[postgis-users] Need some advice in my Postgis table design

[Ehud Shabtai]

Hi,

I'm trying to write an application which will allow creating digital
maps. I'm using postgis as my DB and I'm using GPS traces to create my
map.
I'd like everything in the DB to be as simple as possible so it could
be easily viewed by external software connected to postgis (mapserver)
and edited (qgis, uDig, etc').
My main problem is with roads. I'm using two tables: one to keep nodes
and another to keep road segments. The problem is that a single street
is typically built from several segments, and so I'm not sure how to
handle street names. I'd like to have another street table with all
the information about a street and link each segment to a street using
its ID. But if I choose this solution, external software will not
handle the indirection and won't show the street names. Putting the
name for each segment seems as a waste.

Is there any other option?

Thanks,

Ehud.