OSM SQLite Experiment: Frequency of key values

These queries show the top frequencies of keys for nodes, ways and relations.

Nodes

1addr:housenumber75,929,845
2addr:street67,686,667
3addr:city52,809,993
4source52,058,928
5addr:postcode47,789,854
6power32,112,838
7name27,127,165
8natural26,942,470
9highway24,680,012
10addr:country21,807,167
11amenity14,292,568
12source:date11,427,423
13addr:district9,936,148
14addr:state8,597,831
15barrier8,317,597
16place6,875,832
17crossing6,839,810
18operator6,534,122
19addr:hamlet6,421,059
20addr:place6,334,016

Ways

1building607,578,215
2highway232,602,962
3source221,258,840
4addr:housenumber75,940,489
5addr:street74,606,437
6name70,951,446
7surface61,097,077
8addr:city57,525,716
9addr:postcode50,359,212
10landuse41,284,810
11natural39,766,110
12building:levels31,833,800
13waterway29,974,079
14service25,113,350
15oneway22,396,958
16addr:country21,859,524
17height18,642,447
18access18,365,904
19maxspeed18,125,919
20source:date17,199,048

Relations

1type12,215,702
2name3,546,403
3natural3,005,853
4landuse2,105,995
5restriction1,924,881
6source1,349,302
7ref1,193,448
8network1,186,315
9route1,053,320
10building1,041,482
11boundary849,896
12operator741,319
13admin_level714,136
14wikidata670,105
15wetland521,339
16public_transport456,180
17wikipedia422,160
18from353,767
19to351,966
20public_transport:version292,441

:-)