Re: [Talk-ca] I'd like to run something to add a French street name tag in Ottawa
On 21 June 2010 00:32, Richard Weait rich...@weait.com wrote: I won't run it against the live data and change the data on the server unless the community thinks this is a good idea. You and I think it is; let's see if some others support the idea. Don't call it a bot. Bots are bad.* My questions are why have these names been given Street not rue. I don't think name:xx is supposed to be a literal translation but what people of that language would call it. Sometimes there are road signs with both languages on. Some of these might (for whatever, possibly wrong, reason) have Street after the French name. Some might just be the user not thinking, or having missing data. Knowing a reason for a lot of the Street names would give support to your changes. E.g. a user explaining their lazy entry or seeing a selection are from imports. How will we know the changes were made by your script? Maybe tagging every element isn't necessary and just explain in the changeset description. *You can call it a bot if it is restricted to an area. Like you are doing, and so you count me as supporting this. If you have at least 1-2 people who have an eye over the place then, in my view, you should be allowed to do it. This means you must have support at the very least for each provenance you do it for. For example I only knew the Western half of Vancouver, you would have to also get the support of someone who lives/maps in the East to support you for a city-wide change. With getting boundaries, can you just run it on a bounding box that seems to encompass the whole city? What will happen outside: no name:fr will be found, or they will be changed with just the same accuracy/affect as the ones in the city? Also the value of my support got a half-life since I left Canada at the start of May, and I don't know about the french side. Hopefully you're happy for me to add these thinking points even if you decide to not care about them. -- Gregory o...@livingwithdragons.com http://www.livingwithdragons.com ___ Talk-ca mailing list Talk-ca@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-ca
Re: [Talk-ca] I'd like to run something to add a French street name tag in Ottawa
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
Re: [Talk-ca] I'd like to run something to add a French street name tag in Ottawa
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 rich...@weait.com wrote: 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
Re: [Talk-ca] I'd like to run something to add a French street name tag in Ottawa
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=crossiant 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. Dear John, Sure. I'm still under some deadline pressure but I should be able to get something like this done this week. We can at a minimum, test it and run it on some sample data, and then I can render it on my test server so you can show it to folks. I won't run it against the live data and change the data on the server unless the community thinks this is a good idea. You and I think it is; let's see if some others support the idea. You want this to be restricted to Ottawa. Do we have a municipal boundary relation for Ottawa? It looks like the Ottawa relations are for Kansas, Illinois and Ohio. It would be super to have a boundary relation for Ottawa Canada, but an approximate bounding box for the test area you would like would be fine as well. Please note that the Project of the Week this week relates to translations. http://wiki.openstreetmap.org/wiki/Project_of_the_week/2010/Jun_20 Best regards, Richard ___ Talk-ca mailing list Talk-ca@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-ca
Re: [Talk-ca] I'd like to run something to add a French street name tag in Ottawa
Available on or before July 10th would be very nice but it can be later if need be. I'll try to get some boundaries for Ottawa, the problem is probably going to be the river, but if we can add in within Ontario that should be fine. Thanks John On 20 June 2010 19:32, Richard Weait rich...@weait.com wrote: 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=crossiant 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. Dear John, Sure. I'm still under some deadline pressure but I should be able to get something like this done this week. We can at a minimum, test it and run it on some sample data, and then I can render it on my test server so you can show it to folks. I won't run it against the live data and change the data on the server unless the community thinks this is a good idea. You and I think it is; let's see if some others support the idea. You want this to be restricted to Ottawa. Do we have a municipal boundary relation for Ottawa? It looks like the Ottawa relations are for Kansas, Illinois and Ohio. It would be super to have a boundary relation for Ottawa Canada, but an approximate bounding box for the test area you would like would be fine as well. Please note that the Project of the Week this week relates to translations. http://wiki.openstreetmap.org/wiki/Project_of_the_week/2010/Jun_20 Best regards, Richard ___ Talk-ca mailing list Talk-ca@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-ca ___ Talk-ca mailing list Talk-ca@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-ca