On Sun, Jun 20, 2010 at 6:54 PM, john whelan <jwhelan0...@gmail.com> wrote: > Basically restricted to Ottawa (how?) > > If highway and no tag name:fr exists and second word in name is street > > then add tag name:fr first value is "rue + first word from name" Note lower > case rue here. > > If that one works correctly then I'd like to repeat it for > > Avenue=avenue > Crescent=croissant > Road=chemin > Drive=promenade > Boulevard=boulevard > Lane=ruelle > > Suggestions please. Note the French has been verified as correct and this > will allow me to display French streets names in Ottawa. Politically that > would be very helpful as a lever in getting the City's data under ODbL > license. > > If some one else could run this for me I'd be grateful since I haven't done > something like this before.
I wonder if this is something that we could also do as a Postgres CREATE VIEW ? Certainly it could be done slowly with a script locally, but is there a clever select that could build this for us as well? _______________________________________________ Talk-ca mailing list Talk-ca@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-ca