Finding out common names' numbers per language

General
12

@twiane
Is it possible to query ‘‘how many common names are added under each lexicon’’ for @fffffffff ?
I think the smallest lexicon can be discarded cause no one will use them…

SELECT lexicon, COUNT() count
FROM taxon_names
GROUP BY lexicon
HAVING COUNT() > 10
ORDER BY count DESC;

lexicon                      |  count  

---------------------------------------------------+---------

 Chinese (Traditional)                             |   23853

 Chinese Traditional                               |     414
1 Like
13

are you running sql against your own copy of this table, or are you querying the actual database? if the latter, how are you querying against the database?

14

I wish it was option 2 but it is option three 3, I got the data and some kind of query from github forum and added some magic.

Melodi: you have to do some arithmetic as you can see at this moment Chinese has two lexicons in iNaturalist…

15

oh okay… this: https://github.com/inaturalist/inaturalist/issues/2675

16

yes, but it was also in my mailbox and that is where I found it.

17

Here’s a list of name counts for reptiles, mammals, amphibians and birds in all the site translated languages and a few others (there are over 400 lexicons). The data is a few months old, was not collected all at the same time and has changed since. It was originally gathered to find names with missing lexicons.

Lexicon Reptiles Mammals Amphibians Birds Total
Scientific Names 16022 11047 9013 34250 70332
Afrikaans 125 481 14 513 1133
Albanian 0 23 1 3 27
Arabic 179 634 21 1751 2585
Basque 2 53 1 61 117
Breton 2 26 0 4 32
Bulgarian 27 105 22 134 288
Catalan 49 155 28 391 623
Chinese (Simplified) 1159 1061 355 2731 5306
Chinese (Traditional) 354 649 114 926 2043
Czech 1571 4432 3933 11305 21241
Danish 135 224 20 832 1211
Dutch 416 3171 163 27277 31027
English 10354 8289 4749 17010 40402
Esperanto 8 35 1 34 78
Estonian 24 319 18 1355 1716
Finnish 78 5563 60 10550 16251
French 497 2512 232 6963 10204
Galician 16 40 12 121 189
German 1731 2830 205 9171 13937
Greek 79 132 33 540 784
Hebrew 208 454 36 576 1274
Indonesian 85 147 44 964 1240
Italian 354 766 101 1079 2300
Japanese 420 492 144 2289 3345
Korean 132 250 65 627 1074
Latvian 1 9 0 16 26
Lithuanian 11 116 22 449 598
Luxembourgish 5 51 5 322 383
Maori 22 54 6 240 322
Macedonian 1 24 0 2 27
Norwegian 5 79 6 518 608
Occitan 2 23 0 2 27
Ojibwe 34 77 23 151 285
Polish 56 374 33 498 961
Portuguese 862 1453 235 3501 6051
Russian 2098 1874 887 3425 8284
Slovak 11 35 8 233 287
Spanish 1981 2803 1557 5402 11743
Swedish 37 161 32 731 961
Turkish 4 13 0 62 79
3 Likes
18

So conlangs do count. Or at least Esperanto does.

19

Anyone can add a name to a taxon, in any lexicon. Some lexicons aren’t languages, like the AOU 4-Letter and herbarium codes.

20

If a lexicon has not yet been added, is there a way to create it?

1 Like
21

Yes anyone can create a lexicon, which has lead to duplicates like Norwegian Bokmål and Norwegian Bokmal; and Nonbre Comun, Nombres Científicos, Nomes Científicos, Nomi Scientifici, Noms Scientifiques, Научные названия and 學名. There are about 670 lexicons at this moment!

2 Likes
22

Thank you a lot!

1 Like
23

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.

24
25

Does anybody know if it’s possible to do a some kind of search of names’ statistics with the UI or other way?

26

If you can read between the lines you find an answer in the Tutorial section or even in this thread…
inaturalist-taxonomy.dwca\VernacularNames_Languages_count

https://drive.google.com/file/d/1Nbqi-qRmJQijoXTL_gsQBUATdHg3y8WE/view?usp=sharing (per year)

Data 1-1-2023, threshold 10.000. there are over 1015 lexicons.

language lexicon COUNT
en English 262888
zh-CN Chinese (Simplified) 100218
cs Czech 79038
ja Japanese 67281
es Spanish 60175
ru Russian 58002
zh Chinese (Traditional) 55315
fr French 45777
de German 43379
nl Dutch 36845
fi Finnish 36241
pt Portuguese 29258
sv Swedish 28531
nb Norwegian 26996
da Danish 20267
af Afrikaans 19030
ko Korean 18465
ar Arabic 14960
th Thai 13253
it Italian 12938
pl Polish 12876
lt Lithuanian 12350
et Estonian 12132

Interesting idea and maybe also valid for ‘common names’. But it has the same issue as a taxon name: if the correct name is not available the observation will get an incorrect name or a taxon at a higher value.

27

More than 12,000 names in Estonian. Estonian is rather a niche language, with a bit over 1 million speakers according to Omniglot. This is similar to Fang and only half as many as Fante. Then there is Yoruba, with 42 miliion speakers.

I note that of the top 23 in your embedded image, the majority are European languages, and the one that could be thought of as African is of European origin (Afrikaans, genetically related to Dutch). Ethnologue estimates that there are 448 Indo-European languages as compared with 1,553 Niger-Congo languages. Niger-Congo is the largest language family, followed by Austronesian with 1,257 languages and Trans-New Guinea with 481. Indo-European is fourth.

What if the three largest language families had proportionately as many common names in iNat’s database as the fourth-place family?

2 Likes
28

You need to find people to add those, I’m saddened to know how few names have many languages, of them top is Kazakh with 230, that’s unacceptable, no wonder there’re so few observers.

2 Likes
29

I agree that there is a relation between the number of common names in iNaturalist and the use of the platform. But most people are too busy to add them… But does my reaction answer your question? What statistics you mean?

names=common names?
names=contributor? I do not get it.

https://forum.inaturalist.org/t/run-job-to-associate-translated-common-names-to-places/3964
About common names for lexicions without a languague and without a place.

30

Names meaning common names, I wouldn’t refer to people as names.)
Your doc gives a current statistics, I don’t know what is needed to find it a year later or any random day, by statistics Iean just that, number of names in each language (added on iNat).

32

If Kazakh is you favorite language, I will add and extra table with Kazakh in it:

language lexicon COUNT
und Zulu 3440
und Mandarin Chinese 3119
und Setswana 2698
und Vermont Flora Codes 2273
und Nahuatl 1509
und Armenian 1428
und Xhosa 1400
und Tagalog 1353
und Malay (Individual Language) 1307
und Slovene 1257
und Malayalam 1253
und Aou 4 Letter Codes 1226
und AOU 4-Letter Codes 1150
und Hodges Number 1012
und Visayan 1006
und Venda 993
und Faroese 846
und Tsonga 809
und Icelandic 792
und Shona 732
und Sotho (Southern) 712
und Irish 697
und Swati 657
und Palauan 648
und Mongolian 612
und Español (Argentina) 566
und Western Mari 532
und U.S.D.A. Symbol 523
und Kwéyòl 481
und Bikol 476
und Other 462
und Ndebele 445
und Cebuano 429
und Si Lozi 421
und Sotho 410
und Sotho (Northern) 362
und Fijian 341
und Ilokano 339
und Navajo 317
und Chuvash 313
und Herero 310
und Waray (Philippines) 307
und Sesotho 300
und Modern Greek (1453 ) 275
und Alabama 270
und Totonaco 270
und Carolinian 264
und Zapoteco 259
und Asturian 255
und Bunun (Taiwan) 252
und Malagasy 248
und Tamil 245
und Oshiwambo 241
und Kazakh 230
und Hindi 218
und Romaji 213
und West Flemish 212
1 Like