--- Auto fix error-- trim tags keys--update current_way_tags set k=trim(k) where k regexp "^ " or k regexp " $";--update current_relation_tags set k=trim(k) where k regexp "^ " or k regexp " $";select * from current_way_tags where k regexp "^ " or k regexp " $";select * from current_relation_tags where k regexp "^ " or k regexp " $";-- trim tags values--update current_way_tags set v=trim(v) where v regexp "^ " or v regexp " $";--update current_relation_tags set v=trim(v) where v regexp "^ " or v regexp " $";select * from current_way_tags where v regexp "^ " or v regexp " $";select * from current_relation_tags where v regexp "^ " or v regexp " $";-- remove final ";"--update current_way_tags set v=substring(v,1,char_length(v)-1) where v regexp ";$";--update current_relation_tags set v=substring(v,1,char_length(v)-1) where v regexp ";$";select * from current_way_tags where v regexp ";$";select * from current_relation_tags where v regexp ";$";-- remove empty keys or tags--delete from current_way_tags where v="" and k="";select * from current_way_tags where v="" and k="";--delete from current_way_tags where v="";select * from current_way_tags where v="";--delete from current_relation_tags where v="" and k="";select * from current_relation_tags where v="" and k="";--delete from current_relation_tags where v="";select * from current_relation_tags where v="";--- Warning-- key not in map feature-- create table mapfeature ( k varchar(255) );select count(k), k from current_way_tags where k not in (select k from mapfeature) group by k order by count(k);select count(k), k from current_relation_tags where k not in (select k from mapfeature) group by k order by count(k);-- highway tag seem not contain good thingselect * from current_way_tags where k="highway" and v regexp " " and not v regexp ";" and not v like "FIXME%";select * from current_relation_tags where k="highway" and v regexp " " and not v regexp ";" and not v like "FIXME%";-- highway tag collapsed by poltachselect * from current_way_tags where k="highway" and v regexp " " and v regexp ";";select * from current_relation_tags where k="highway" and v regexp " " and v regexp ";";-- may encoding errorselect * from current_way_tags where v regexp "Ã";select * from current_relation_tags where v regexp "Ã";-- what is the question ?select * from current_way_tags where v like "%?%" or k like "%?%";select * from current_relation_tags where v like "%?%" or k like "%?%";-- full uppercaseselect * from current_way_tags where k="name" and not v like "RER _" and not v regexp "[A-Z][- ]?[0-9]+" and v like "% %" and v=binary upper(v);select * from current_relation_tags where k="name" and not v like "RER _" and not v regexp "[A-Z][- ]?[0-9]+" and v like "% %" and v=binary upper(v);capitalis tout sauf les articles