[OSM-dev] Automatic Spell check service

[Tom Hughes]

On 02/01/2008, Stefan de Konink <skinkie at xs4all.nl> wrote:

> Tom Hughes schreef:
> > On 02/01/2008, Stefan de Konink <skinkie at xs4all.nl> wrote:
> >
> >> Tom Hughes schreef:
> >>> On 02/01/2008, Stefan de Konink <skinkie at xs4all.nl> wrote:
> >>>
> >>>> I wonder if it could be accepted that every day an automatic spell check
> >>>> script would operate on the database and checks for less common 'name'
> >>>> tags for automatic spelling corrections.
> >>>>
> >>>> select name, count(name) AS count from way_tags group by name order by
> >>>> count, name;
> >>> That query should only lock the API for an hour or so at a guess.
> >> In my setup:
> >>
> >> 89696.395 msec resulting in 10434 rows
> >
> > ...this would be a setup that has a name field in way_tags? unlike the
> > actual live setup which doesn't?
>
> Yup. Does the live setup store it as 'bla=bla'?

No - it has columns called k (key) and v (value). That's for ways -
nodes store it all jumbled up in a single field.

Tom

-- 
Tom Hughes (tom at compton.nu)
http://www.compton.nu/