[Talk-ca] I'd like to run something to add a French street name tag in Ottawa

[john whelan]

Could you add in
Way=voie as well please, I missed it off the first time.

My thoughts on using a view is you would still need to get the data in a
field in the first place.  This way allows manually editing afterwards for
those names that have been entered in a different format but I'm using the
word view here in a database way where we would replace the contents of name
with name:fr in the data presented to the render.  In the past I've found
once you have one way then other ways follow.

Cheerio John



On 22 June 2010 11:55, Richard Weait <richard at weait.com> wrote:

> On Sun, Jun 20, 2010 at 6:54 PM, john whelan <jwhelan0112 at 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?
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk-ca/attachments/20100622/6747a06d/attachment.html>