[Tagging] Fast Food Restaurants
Tac Tacelosky
tacman at gmail.com
Thu May 30 09:22:27 UTC 2013
postgres also has ILIKE, which does case-insensitive searches, so
that's working for the moment.
The biggest challenge I'm having with the current editors is the
learning curve for the tags, specifically which keys to use. But yes,
I've spent some time in there, and am trying to adopt their approach.
Ideally, I'd find a JSON or CSV file with the common tags structured
in a way that maps into more of a category system than a multi-tag
system.
Tac
On Wed, May 29, 2013 at 9:38 PM, Richard Welty <rwelty at averillpark.net> wrote:
> On 5/29/13 6:42 PM, Richard Welty wrote:
>>
>> On 5/29/13 6:01 PM, Tac Tacelosky wrote:
>>>
>>> I see "amenity:Restaurant" and "amenity:restaurant" are both returned
>>> from the api. And I just discovered that postgres does case-sensitive
>>> LIKE's. Sigh.
>>
>> now fixing this is actually a reasonable thing to do in a bulk edit,
>> because many data consumers likely don't do case flattening and
>> will miss Restaurant
>
> and i'll also point out that postgresql has useful string functions like
> LOWER that can be applied to arguments before using LIKE if you really
> feel the need to bandaid around case errors in tag values
>
>
> richard
>
>
>
>
> _______________________________________________
> Tagging mailing list
> Tagging at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/tagging
More information about the Tagging
mailing list