From my mail box I found some related messages in 'Spell check data to a file'.
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; ...or more advanced: select way, name from way_tags where name = ( select name from way_tags group by name having count(name) = 1); If anyone interested in some plane query results of different tags ordered by (non-)presence: http://www.mediafire.com/?6uwdsgnuc9z So basically: - skip stuff with the tiger namespace - check the untrimmed results: select way, name from way_tags where name <> TRIM(name); (around 107 results) - check the count(name) results less than 10, lowercase, trim them and apply something like Levenshtein distance to the results and the higher numbers. Comments? Stefan _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
