bugzilla.wikimedia.org's show_bug.cgi?id=7495 - eventually get resolved thanks to hasharZzz's email to foundation-l (see archives?) --Georgeryp 22:02, 23 May 2007 (UTC)

STARTING SEARCH ON "*"... Remaining list:

Todo

  1. Hippeastrum
  2. VN template overlap: Plantae
  3. Callipogon - use new templates, rm "TOC", etc

Wiktionary multi-language?:

wikt:fr:Canis

wikt:Canis

PLANTS Families edit

  Warning - The PLANTS Database website states it uses the Cronquist(sp?) classification system for vascular plants (I think APG II is preferred here on Wikispecies instead??)

To create this list I:

  1. Downloaded the complete PLANTS checklist[1] (as of 2008-03-23).
  2. Imported it into an Oracle database (90,610 records total).
  3. Ran this SQL:
select '#[['||fam||']]', count(*)
from p_orig
group by '#[['||fam||']]'
order by 1

<SQL> describe p_orig
 Name     Type
 -------- ---------------
 S        VARCHAR2(7)
 SYN      VARCHAR2(7)
 SCI      VARCHAR2(155)
 COMMON   VARCHAR2(45)
 FAM      VARCHAR2(30)
# - Family - Count of records under Family (could be species, subspecies, maybe even synonyms?)
  1. Acanthaceae 383
  2. Acarosporaceae 181
  3. Aceraceae 123
  4. Achatocarpaceae 2
  5. Acoraceae 6
  6. Acrobolbaceae 2
  7. Actinidiaceae 4
  8. Adelococcaceae 4
  9. Adoxaceae 2
  10. Agavaceae 253
  11. Agyriaceae 18
  12. Aizoaceae 64
  13. Alectoriaceae 18
  14. Alismataceae 125
  15. Allisoniaceae 3
  16. Aloaceae 12
  17. Amaranthaceae 340
  18. Amblystegiaceae 317
  19. Anacardiaceae 195
  20. Andreaeaceae 39
  21. Andreaeobryaceae 2
  22. Anemiaceae 10 [2]
  23. Aneuraceae 19
  24. Annonaceae 63
  25. Anomodontaceae 14
  26. Antheliaceae 3
  27. Anthocerotaceae 107
  28. Apiaceae 966
  29. Apocynaceae 266
  30. Aponogetonaceae 2
  31. Aquifoliaceae 81
  32. Araceae 167
  33. Araliaceae 221
  34. Araucariaceae 14
  35. Archidiaceae 11
  36. Arctomiaceae 3
  37. Arecaceae 275
  38. Aristolochiaceae 89
  39. Arnelliaceae 2
  40. Arthoniaceae 135
  41. Arthopyreniaceae 50
  42. Arthrorhaphidaceae 11
  43. Asclepiadaceae 377
  44. Aspleniaceae 177
  45. Asteraceae 10610
  46. Asterothyriaceae 2
  47. Atheliaceae 3
  48. Aulacomniaceae 10
  49. Aytoniaceae 31
  50. Azollaceae 5
  51. Bacidiaceae 230
  52. Baeomycetaceae 13
  53. Balanophoraceae 5
  54. Balsaminaceae 21
  55. Bartramiaceae 78
  56. Basellaceae 16
  57. Bataceae 2
  58. Begoniaceae 15
  59. Berberidaceae 104
  60. Betulaceae 205
  61. Biatorellaceae 10
  62. Bignoniaceae 127
  63. Bixaceae 10
  64. Blasiaceae 2
  65. Blechnaceae 49
  66. Bombacaceae 31
  67. Boraginaceae 974
  68. Brachytheciaceae 313
  69. Brassicaceae 2427
  70. Brigantiaceae 6
  71. Bromeliaceae 91
  72. Bruchiaceae 20
  73. Brunelliaceae 3
  74. Bryaceae 247
  75. Bryoxiphiaceae 2
  76. Buddlejaceae 23 - obsolete? see en:w:Buddleja
  77. Burmanniaceae 18
  78. Burseraceae 33
  79. Butomaceae 2
  80. Buxaceae 14
  81. Buxbaumiaceae 11
  82. Cabombaceae 12
  83. Cactaceae 1135
  84. Caliciaceae 61
  85. Callicostaceae 12
  86. Callitrichaceae 32
  87. Calycanthaceae 12
  88. Calyceraceae 4
  89. Calymperaceae 20
  90. Calypogeiaceae 15
  91. Campanulaceae 667
  92. Candelariaceae 39
  93. Canellaceae 6
  94. Cannabaceae 17
  95. Cannaceae 14
  96. Capnodiaceae 2
  97. Capparaceae 140
  98. Caprifoliaceae 358
  99. Caricaceae 11
  100. Caryocaraceae 4
  101. Caryophyllaceae 1386
  102. Casuarinaceae 35
  103. Catillariaceae 81
  104. Catoscopiaceae 2
  105. Caulerpaceae 2
  106. Cecropiaceae 5
  107. Celastraceae 124
  108. Cephalotaxaceae 2
  109. Cephaloziaceae 45
  110. Cephaloziellaceae 47
  111. Ceratophyllaceae 17
  112. Cercidiphyllaceae 2
  113. Chenopodiaceae 708
  114. Chionosphaeraceae 2
  115. Chloranthaceae 4
  116. Chonecoleaceae 2
  117. Chrysobalanaceae 27
  118. Chrysotrichaceae 7
  119. Cistaceae 114
  120. Cladoniaceae 247
  121. Clavariaceae 6
  122. Clethraceae 5
  123. Cleveaceae 7
  124. Climaciaceae 5
  125. Clusiaceae 196
  126. Coccocarpiaceae 14
  127. Coccotremataceae 5
  128. Collemataceae 157
  129. Combretaceae 40
  130. Commelinaceae 187
  131. Coniocybaceae 39
  132. Connaraceae 5
  133. Conocephalaceae 2
  134. Convolvulaceae 489
  135. Cornaceae 102
  136. Corsiniaceae 2
  137. Corticiaceae 7
  138. Corynocarpaceae 2
  139. Costaceae 10
  140. Crassulaceae 434
  141. Crocyniaceae 3
  142. Crossosomataceae 34
  143. Cryphaeaceae 7
  144. Cucurbitaceae 227
  145. Cunoniaceae 5
  146. Cupressaceae 218
  147. Cuscutaceae 114
  148. Cyatheaceae 44
  149. Cycadaceae 3
  150. Cyclanthaceae 2
  151. Cymodoceaceae 16
  152. Cyperaceae 2664
  153. Cyrillaceae 9
  154. Dacampiaceae 16
  155. Dactylosporaceae 26
  156. Daltoniaceae 2
  157. Datiscaceae 3
  158. Davalliaceae 2
  159. Dendrocerotaceae 2
  160. Dennstaedtiaceae 75
  161. Diapensiaceae 20
  162. Dicksoniaceae 13
  163. Dicranaceae 212
  164. Dilleniaceae 12
  165. Dioscoreaceae 42
  166. Dipsacaceae 29
  167. Dipterocarpaceae 8
  168. Disceliaceae 2
  169. Ditrichaceae 60
  170. Droseraceae 26
  171. Dryopteridaceae 489
  172. Ebenaceae 51
  173. Ectolechiaceae 18
  174. Eigleraceae 4
  175. Elaeagnaceae 21
  176. Elaeocarpaceae 11
  177. Elatinaceae 21
  178. Empetraceae 18
  179. Encalyptaceae 35
  180. Entodontaceae 20
  181. Epacridaceae 8
  182. Ephedraceae 32
  183. Ephemeraceae 28
  184. Equisetaceae 59
  185. Eremolepidaceae 7
  186. Ericaceae 748
  187. Eriocaulaceae 38
  188. Erpodiaceae 9
  189. Erythroxylaceae 12
  190. Euphorbiaceae 1226
  191. Fabaceae 6877
  192. Fabroniaceae 22
  193. Fagaceae 417
  194. Fissidentaceae 75
  195. Flacourtiaceae 68
  196. Flagellariaceae 2
  197. Fontinalaceae 55
  198. Fossombroniaceae 14
  199. Fouquieriaceae 5
  200. Frankeniaceae 9
  201. Fumariaceae 104
  202. Funariaceae 77
  203. Fuscideaceae 48
  204. Garryaceae 18
  205. Gentianaceae 468
  206. Geocalycaceae 26
  207. Geraniaceae 154
  208. Gesneriaceae 260
  209. Gigaspermaceae 4
  210. Ginkgoaceae 2
  211. Gleicheniaceae 29
  212. Gnetaceae 4
  213. Gomphillaceae 27
  214. Goodeniaceae 32
  215. Grammitidaceae 89
  216. Graphidaceae 119
  217. Greyiaceae 2
  218. Grimmiaceae 206
  219. Grossulariaceae 257
  220. Gunneraceae 12
  221. Gyalectaceae 46
  222. Gymnomitriaceae 34
  223. Gypsoplaceae 2
  224. Gyrothyraceae 2
  225. Haematommataceae 21
  226. Haemodoraceae 10
  227. Haloragaceae 51
  228. Hamamelidaceae 19
  229. Hanguanaceae 2
  230. Haplomitriaceae 3
  231. Hedwigiaceae 9
  232. Heliconiaceae 18
  233. Helodiaceae 8
  234. Heppiaceae 8
  235. Herbertaceae 11
  236. Hernandiaceae 3
  237. Hippocastanaceae 42
  238. Hippocrateaceae 2
  239. Hippuridaceae 4
  240. Hookeriaceae 3
  241. Hydrangeaceae 142
  242. Hydrocharitaceae 82
  243. Hydrophyllaceae 506
  244. Hylocomiaceae 39
  245. Hymeneliaceae 180
  246. Hymenophyllaceae 79
  247. Hypnaceae 243
  248. Hypocreaceae 10
  249. Hypopterygiaceae 3
  250. Icacinaceae 10
  251. Illiciaceae 4
  252. Iridaceae 452
  253. Isoetaceae 100
  254. Joinvilleaceae 2
  255. Jubulaceae 37
  256. Juglandaceae 110
  257. Juncaceae 404
  258. Juncaginaceae 23
  259. Jungermanniaceae 186
  260. Krameriaceae 13
  261. Lamiaceae 1438
  262. Lardizabalaceae 3
  263. Lauraceae 120
  264. Lecanoraceae 494
  265. Lecideaceae 186
  266. Lecythidaceae 13
  267. Leitneriaceae 2
  268. Lejeuneaceae 106
  269. Lemnaceae 57
  270. Lennoaceae 6
  271. Lentibulariaceae 70
  272. Leotiaceae 2
  273. Lepidoziaceae 22
  274. Leptodontaceae 12
  275. Leskeaceae 130
  276. Letrouitiaceae 8
  277. Leucobryaceae 6
  278. Leucodontaceae 21
  279. Lichenotheliaceae 15
  280. Lichinaceae 122
  281. Liliaceae 1648
  282. Limnanthaceae 40
  283. Limnocharitaceae 4
  284. Linaceae 167
  285. Loasaceae 165
  286. Lobariaceae 47
  287. Loganiaceae 127
  288. Lophosoriaceae 3
  289. Loranthaceae 14
  290. Lunulariaceae 2
  291. Lycopodiaceae 264
  292. Lygodiaceae 6
  293. Lythraceae 89
  294. Magnoliaceae 38
  295. Malpighiaceae 96
  296. Malvaceae 754
  297. Marantaceae 23
  298. Marattiaceae 13
  299. Marcgraviaceae 5
  300. Marchantiaceae 18
  301. Marsileaceae 27
  302. Mastigophoraceae 2
  303. Mastodiaceae 4
  304. Mayacaceae 3
  305. Meesiaceae 17
  306. Megalosporaceae 7
  307. Melanommataceae 3
  308. Melaspileaceae 16
  309. Melastomataceae 178
  310. Meliaceae 53
  311. Melianthaceae 2
  312. Menispermaceae 29
  313. Menyanthaceae 19
  314. Mesoptychiaceae 2
  315. Meteoriaceae 11
  316. Metzgeriaceae 15
  317. Micareaceae 64
  318. Microcaliciaceae 8
  319. Mniaceae 101
  320. Molluginaceae 12
  321. Monimiaceae 2
  322. Monoblastiaceae 72
  323. Monosoleniaceae 3
  324. Monotropaceae 35
  325. Moraceae 126
  326. Moringaceae 4
  327. Musaceae 17
  328. Mycoblastaceae 8
  329. Mycocaliciaceae 61
  330. Mycoporaceae 24
  331. Mycosphaerellaceae 19
  332. Myoporaceae 14
  333. Myricaceae 43
  334. Myriniaceae 5
  335. Myristicaceae 12
  336. Myrsinaceae 75
  337. Myrtaceae 742
  338. Myxotrichaceae 2
  339. Najadaceae 35
  340. Neckeraceae 32
  341. Nelumbonaceae 8
  342. Nepenthaceae 2
  343. Nephromataceae 17
  344. Notothyladaceae 22
  345. Nyctaginaceae 340
  346. Nymphaeaceae 104
  347. Ochnaceae 15
  348. Odontotremataceae 5
  349. Oedipodiaceae 2
  350. Olacaceae 13
  351. Oleaceae 225
  352. Onagraceae 1157
  353. Opegraphaceae 113
  354. Ophioglossaceae 123
  355. Ophioparmaceae 10
  356. Orchidaceae 1083
  357. Orobanchaceae 110
  358. Orthotrichaceae 158
  359. Osmundaceae 10
  360. Oxalidaceae 174
  361. Oxymitraceae 2
  362. Paeoniaceae 11
  363. Pallaviciniaceae 5
  364. Pandanaceae 34
  365. Pannariaceae 74
  366. Papaveraceae 217
  367. Parkeriaceae 7
  368. Parmeliaceae 994
  369. Passifloraceae 64
  370. Pedaliaceae 43
  371. Pelliaceae 10
  372. Peltigeraceae 56
  373. Peltulaceae 32
  374. Pertusariaceae 162
  375. Philydraceae 2
  376. Phlyctidaceae 9
  377. Phyllachoraceae 6
  378. Physciaceae 513
  379. Phytolaccaceae 30
  380. Pilocarpaceae 18
  381. Pinaceae 259
  382. Piperaceae 174
  383. Pittosporaceae 77
  384. Placynthiaceae 27
  385. Plagiochilaceae 49
  386. Plagiotheciaceae 31
  387. Plantaginaceae 133
  388. Platanaceae 9
  389. Platygloeaceae 3
  390. Pleomassariaceae 6
  391. Pleosporaceae 8
  392. Pleuroziaceae 2
  393. Pleuroziopsidaceae 3
  394. Plumbaginaceae 95
  395. Poaceae 6422
  396. Podocarpaceae 20
  397. Podostemaceae 3
  398. Polemoniaceae 1067
  399. Polygalaceae 158
  400. Polygonaceae 1591
  401. Polypodiaceae 134
  402. Polytrichaceae 141
  403. Pontederiaceae 38
  404. Porellaceae 17
  405. Porpidiaceae 147
  406. Portulacaceae 355
  407. Posidoniaceae 3
  408. Potamogetonaceae 169
  409. Pottiaceae 455
  410. Primulaceae 379
  411. Proteaceae 35
  412. Protothelenellaceae 8
  413. Pseudoditrichaceae 2
  414. Pseudolepicoleaceae 7
  415. Psilotaceae 4
  416. Psoraceae 44
  417. Pteridaceae 332
  418. Pterigynandraceae 27
  419. Pterobryaceae 11
  420. Ptilidiaceae 4
  421. Ptychomitriaceae 9
  422. Punicaceae 2
  423. Pyrenotrichaceae 3
  424. Pyrenulaceae 144
  425. Pyrolaceae 88
  426. Racopilaceae 2
  427. Radulaceae 18
  428. Rafflesiaceae 2
  429. Ramalinaceae 126
  430. Ranunculaceae 1238
  431. Resedaceae 10
  432. Rhachitheciaceae 3
  433. Rhamnaceae 372
  434. Rhizocarpaceae 94
  435. Rhizogoniaceae 3
  436. Rhizophoraceae 17
  437. Rhytidiaceae 2
  438. Ricciaceae 45
  439. Riellaceae 3
  440. Rimulariaceae 22
  441. Roccellaceae 47
  442. Rosaceae 3224
  443. Rubiaceae 1132
  444. Ruppiaceae 18
  445. Rutaceae 424
  446. Sabiaceae 3
  447. Salicaceae 978
  448. Salviniaceae 11
  449. Santalaceae 52
  450. Sapindaceae 156
  451. Sapotaceae 174
  452. Sarraceniaceae 54
  453. Saururaceae 7
  454. Saxifragaceae 633
  455. Scapaniaceae 91
  456. Schaereriaceae 13
  457. Scheuchzeriaceae 5
  458. Schisandraceae 3
  459. Schistostegaceae 2
  460. Schizaeaceae 15
  461. Scouleriaceae 3
  462. Scrophulariaceae 2574
  463. Selaginellaceae 86
  464. Seligeriaceae 23
  465. Sematophyllaceae 37
  466. Simaroubaceae 35
  467. Simmondsiaceae 4
  468. Smilacaceae 60
  469. Solanaceae 638
  470. Solorinellaceae 10
  471. Sonneratiaceae 2
  472. Sparganiaceae 30
  473. Sphaerocarpaceae 9
  474. Sphaerophoraceae 8
  475. Sphagnaceae 154
  476. Sphenocleaceae 2
  477. Sphinctrinaceae 9
  478. Splachnaceae 43
  479. Splachnobryaceae 3
  480. Stackhousiaceae 2
  481. Staphyleaceae 6
  482. Stemonaceae 2
  483. Sterculiaceae 114
  484. Stereocaulaceae 53
  485. Stereophyllaceae 7
  486. Stictidaceae 19
  487. Strelitziaceae 5
  488. Strigulaceae 27
  489. Styracaceae 42
  490. Surianaceae 2
  491. Symplocaceae 10
  492. Syzygosporaceae 3
  493. Taccaceae 4
  494. Tamaricaceae 16
  495. Targioniaceae 2
  496. Taxaceae 16
  497. Teloschistaceae 222
  498. Tetraphidaceae 10
  499. Thamnobryaceae 17
  500. Theaceae 49
  501. Thelenellaceae 49
  502. Theliaceae 4
  503. Thelotremataceae 110
  504. Thelypteridaceae 219
  505. Theophrastaceae 10
  506. Thrombiaceae 4
  507. Thuidiaceae 30
  508. Thymelaeaceae 63
  509. Tiliaceae 101
  510. Timmiaceae 16
  511. Trapaceae 6
  512. Trapeliaceae 52
  513. Tremellaceae 13
  514. Treubiaceae 2
  515. Trichocoleaceae 2
  516. Trichocomaceae 2
  517. Tricholomataceae 20
  518. Trichotheliaceae 50
  519. Triuridaceae 2
  520. Tropaeolaceae 5
  521. Trypetheliaceae 53
  522. Turneraceae 29
  523. Typhaceae 8
  524. Ulmaceae 92
  525. Umbilicariaceae 66
  526. Uncertain Lichen Family 208
  527. Urticaceae 199
  528. Valerianaceae 101
  529. Verbenaceae 442
  530. Verrucariaceae 276
  531. Vezdaeaceae 2
  532. Violaceae 380
  533. Viscaceae 107
  534. Vitaceae 143
  535. Vittariaceae 26
  536. Winteraceae 2
  537. Xyridaceae 51
  538. Zamiaceae 19
  539. Zannichelliaceae 5
  540. Zingiberaceae 73
  541. Zosteraceae 15
  542. Zygophyllaceae 52

542 rows selected.