Entries
SQL: select relname,reltuples from pg_class where relname like 'wp_coords_%' or relname like 'pub_C_geo_id%' order by reltuples DESC;

relnamereltuples
wp_coords_red04.1544e+06
wp_coords_red2589230
wp_coords_red335942
wp_coords_red4410

Input from Languages
SQL: SELECT lang,' ',Count(*) as count FROM wp_coords_red0 GROUP BY lang ORDER BY count DESC;

lang?column?count
en 1145421
de 772004
sv 372494
fr 293196
nl 232555
ru 226063
pl 149819
ja 106954
ca 94353
es 91030
it 86936
sr 65041
cs 53493
zh 52971
uk 50251
da 48126
no 40229
fa 39004
eu 25054
lt 24879
vi 24674
pt 21167
ro 19083
hu 14138
nn 11460
fi 10285
hi 10205
ms 9887
ko 8172
sk 7985
el 7853
tr 6201
et 6016
te 5362
gl 4690
eo 4147
he 3669
hr 3643
ceb 3405
simple 1982
vo 277

Types
SQL: SELECT Count(*) as count,types FROM wp_coords_red0 GROUP BY types HAVING Count(*)>10 ORDER BY count DESC ;

counttypes
1539414landmark
1008749
918499city
278617waterbody
67425mountain
61329river
49153railwaystation
42057adm3rd
38214edu
36130airport
29039isle
27531adm2nd
22898country
8615event
7224adm1st
5142forest
3479
2433pass
1843church
1362glacier
1030building
1007forrest
613island
391region
136dam
115castle
111park
105town
97lvemark
92railway
87state
84stazioneferroviaria
67havaliman
65lago
64village
60commune
54landscape
51road
42repuloter
41cave
39tomb
28waterfall
28satellite
27location
26panchayat
26lighthouse
25sport
23port
21airportdisplay=inline.ti
19song
18province
17rural
14street
14fortress
14railwaypark
13other
13headland
12golfcourse
12county
12muncipality
11cidade
11bridge

Attributes
SQL: select (SELECT Count(*) FROM wp_coords_red0 where pop<>'' ) AS pop, (SELECT Count(*) FROM wp_coords_red0 where "Height"<>'' ) AS height, (SELECT Count(*) FROM wp_coords_red0 where "Height"<>'' ) AS height, (SELECT Count(*) FROM wp_coords_red0 where "Country"<>'' ) AS country, (SELECT Count(*) FROM wp_coords_red0 where "Subregion"<>'' ) AS subregion, (SELECT Count(*) FROM wp_coords_red0 where "Scale"<>'' ) AS scale, (SELECT Count(*) FROM wp_coords_red0 where "dim"<>'' ) AS dim, (SELECT Count(*) FROM wp_coords_red0 where "style"<>'' ) AS style, (SELECT Count(*) FROM wp_coords_red0 where "image"<>'' ) AS image, (SELECT Count(*) FROM wp_coords_red0 where "imagejpg"<>'' ) AS imagejpg, (SELECT Count(*) FROM wp_coords_red0 where "name"<>'' ) AS name ;

popheightcountrysubregionscaledimstyleimageimagejpgname
2808089572640707115243101877883141946392336625081961836777