roger-mahler
commented
4 months ago There are in total 125 records having null value in `definition":
select s.name, d.abbreviation, d.definition, d.name, d.notes from tbl_ecocode_definitions d join tbl_ecocode_groups using (ecocode_group_id) join tbl_ecocode_systems s using (ecocode_system_id) where d.definition is null;
All of them belongs to Koch exocode system:
| name | abbreviation | definition | name |
|---|---|---|---|
| Koch Ecology Codes | HTyhl | xylophilous | |
| Koch Ecology Codes | HTyht | halotolerant | |
| Koch Ecology Codes | HTyrh | rheophilous | |
| Koch Ecology Codes | HTyro | rodentophilous | |
| Koch Ecology Codes | Ecoab | arboricolous | |
| Koch Ecology Codes | Ecoag | agaricolous | |
| Koch Ecology Codes | Ecoak | akrodendric | |
| Koch Ecology Codes | Ecoap | arundicolous | |
| Koch Ecology Codes | Ecoaq | aquatic | |
| Koch Ecology Codes | Ecoar | arenicolous | |
| Koch Ecology Codes | Ecoav | arvicolous | |
| Koch Ecology Codes | Ecobo | boleticolous | |
| Koch Ecology Codes | Ecoca | cadavericolous | |
| Koch Ecology Codes | Ecoco | corticolous | |
| Koch Ecology Codes | Ecocp | campicolous | |
| Koch Ecology Codes | Ecocv | cavernicolous | |
| Koch Ecology Codes | Ecode | deserticolous | |
| Koch Ecology Codes | Ecodt | detriticolous | |
| Koch Ecology Codes | Ecofl | floricolous | |
| Koch Ecology Codes | Ecofu | fungicolous | |
| Koch Ecology Codes | Ecogr | graminicolous | |
| Koch Ecology Codes | Ecohe | herbicolous | |
| Koch Ecology Codes | Ecohu | humicolous | |
| Koch Ecology Codes | Ecolc | linicolous | |
| Koch Ecology Codes | Ecoli | lignicolous | |
| Koch Ecology Codes | Ecolm | limnicolous | |
| Koch Ecology Codes | Ecomi | microcavernicolous | |
| Koch Ecology Codes | Ecomu | muscicolous | |
| Koch Ecology Codes | Econi | nidicolous | |
| Koch Ecology Codes | Econv | nivicolous | |
| Koch Ecology Codes | Ecopa | paludicolous | |
| Koch Ecology Codes | Ecope | petricolous | |
| Koch Ecology Codes | Ecoph | phyllicolous | |
| Koch Ecology Codes | Ecopl | planticolous | |
| Koch Ecology Codes | Ecopo | polyporicolous | |
| Koch Ecology Codes | Ecopr | praticolous | |
| Koch Ecology Codes | Ecops | parasitic | |
| Koch Ecology Codes | Ecopt | phytodetriticolous | |
| Koch Ecology Codes | Ecopy | phyllodetriticolous | |
| Koch Ecology Codes | Ecori | ripicolous | |
| Koch Ecology Codes | Ecosi | silvicolous | |
| Koch Ecology Codes | Ecosk | stercoricolous | |
| Koch Ecology Codes | Ecosp | sphagnicolous | |
| Koch Ecology Codes | Ecost | steppicolous | |
| Koch Ecology Codes | Ecosu | succicolous | |
| Koch Ecology Codes | Ecote | terricolous or subterranean | |
| Koch Ecology Codes | Ecoto | torrenticolous | |
| Koch Ecology Codes | Ecoxy | xylodetriticolous | |
| Koch Ecology Codes | Ecozo | zoodetriticolous | |
| Koch Ecology Codes | FCoHo | holoprobic | |
| Koch Ecology Codes | FCoMe | mesoprobic | |
| Koch Ecology Codes | FCoOl | oligoprobic | |
| Koch Ecology Codes | FDeEk | ectophagous | |
| Koch Ecology Codes | FDeEn | endophagous | |
| Koch Ecology Codes | FDeMe | merotopic | |
| Koch Ecology Codes | FDeMo | monophagous | |
| Koch Ecology Codes | FDeOl | oligophagous | |
| Koch Ecology Codes | FDeOm | omnivorous | |
| Koch Ecology Codes | FDePo | polyphagous | |
| Koch Ecology Codes | FDeXe | xenophagous | |
| Koch Ecology Codes | FDeXn | xenophilous | |
| Koch Ecology Codes | FNoAl | algophagous | |
| Koch Ecology Codes | FNoAp | aphidophagous | |
| Koch Ecology Codes | FNoBl | blastophagous | |
| Koch Ecology Codes | FNoCa | carpophagous | |
| Koch Ecology Codes | FNoCe | cecidophagous | |
| Koch Ecology Codes | FNoCo | cortivorous | |
| Koch Ecology Codes | FNoCp | coprophilous | |
| Koch Ecology Codes | FNoCu | caulophagous | |
| Koch Ecology Codes | FNoEn | entomophagous | |
| Koch Ecology Codes | FNoFr | fructivorous | |
| Koch Ecology Codes | FNoHe | helminthophagous | |
| Koch Ecology Codes | FNoKr | kreophilous | |
| Koch Ecology Codes | FNoLi | lichenophagous | |
| Koch Ecology Codes | FNoMm | myrmecophagous | |
| Koch Ecology Codes | FNoMs | muscophagous | |
| Koch Ecology Codes | FNoMu | molluscophagous | |
| Koch Ecology Codes | FNoMy | mycetophagous | |
| Koch Ecology Codes | FNoNe | necrophagous | |
| Koch Ecology Codes | FNoOo | oophagous | |
| Koch Ecology Codes | FNoPh | phytophagous | |
| Koch Ecology Codes | FNoPl | phloeophagous | |
| Koch Ecology Codes | FNoPn | pollenophagous | |
| Koch Ecology Codes | FNoPy | phyllophagous | |
| Koch Ecology Codes | FNoRh | rhizophagous | |
| Koch Ecology Codes | FNoSa | saprophagous | |
| Koch Ecology Codes | FNoSp | sporophagous | |
| Koch Ecology Codes | FNoXy | xylophagous | |
| Koch Ecology Codes | FNoZo | zoophagous | |
| Koch Ecology Codes | HRaEh | eurythermal | |
| Koch Ecology Codes | HRaEm | euryhygric | |
| Koch Ecology Codes | HRaEu | eurytopic | |
| Koch Ecology Codes | HRaSf | Facultative Sy | |
| Koch Ecology Codes | HRaSh | stenothermic | |
| Koch Ecology Codes | HRaSm | stenohygric | |
| Koch Ecology Codes | HRaSn | Typically Sy | |
| Koch Ecology Codes | HRaSs | Strong Sy | |
| Koch Ecology Codes | HRaSt | stenotopic | |
| Koch Ecology Codes | HRaSy | synanthropic | |
| Koch Ecology Codes | HRaUb | ubiquitous | |
| Koch Ecology Codes | HTyac | acidophilous | |
| Koch Ecology Codes | HTyam | amylophilous | |
| Koch Ecology Codes | HTyap | apoidephilous | |
| Koch Ecology Codes | HTych | chromophilous | |
| Koch Ecology Codes | HTyco | coprophilous | |
| Koch Ecology Codes | HTyha | halophilous | |
| Koch Ecology Codes | HTyhe | heliophilous | |
| Koch Ecology Codes | HTyhy | hygrophilous | |
| Koch Ecology Codes | HTykr | krenophilous | |
| Koch Ecology Codes | HTymm | myrmecophilous | |
| Koch Ecology Codes | HTymy | mycetophilous | |
| Koch Ecology Codes | HTyne | necrophilous | |
| Koch Ecology Codes | HTyos | osmophilous | |
| Koch Ecology Codes | HType | petrophilous | |
| Koch Ecology Codes | HTyph | pholeophilous | |
| Koch Ecology Codes | HTyps | psammophilous | |
| Koch Ecology Codes | HTysa | saprophilous | |
| Koch Ecology Codes | HTysi | silicophilous | |
| Koch Ecology Codes | HTyth | thermophilous | |
| Koch Ecology Codes | HTyti | tixophilous | |
| Koch Ecology Codes | HTytr | trogophilous | |
| Koch Ecology Codes | HTyty | tyrphophilous | |
| Koch Ecology Codes | HTyxe | xerophilous | |
| Koch Ecology Codes | FNoMi | Acarophagous | |
| Koch Ecology Codes | FNoDi | larval dipterophagous |
Both the Bugs and Koch ecocode systems lack definitions (descriptive texts) in the database (tbl_ecocode_systems).