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

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

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

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 ;