mutolisp
commented
6 years ago Update postgresql database
BEGIN;
UPDATE namelist SET fullname='Bonnaya antipoda (L.) Druce',
name='Bonnaya antipoda' WHERE name='Lindernia antipoda';
UPDATE namelist SET fullname='Bonnaya ciliata (Colsm.) Spreng.',
name='Bonnaya ciliata' WHERE name='Lindernia ciliata';
UPDATE namelist SET fullname='Bonnaya ruellioides (Colsm.) Spreng.',
name='Bonnaya ruellioides' WHERE name='Lindernia ruellioides';
UPDATE namelist SET fullname='Bonnaya tenuifolia (Colsm.) Spreng.',
name='Bonnaya tenuifolia' WHERE name='Lindernia tenuifolia';
UPDATE namelist SET fullname='Lindernia dubia (L.) Pennell var. dubia',
name='Lindernia dubia var. dubia',
subordinate='true',sub_name='var.'
WHERE name='Lindernia dubia';
UPDATE namelist SET fullname='Lindernia dubia var. anagallidea (Michx.) Cooperr.',
name='Lindernia dubia var. anagallidea',
subordinate='true',sub_name='var.'
WHERE name='Lindernia anagallidea';
UPDATE namelist SET fullname='Micranthemum callitrichoides (Griseb.) C. Wright',
name='Micranthemum callitrichoides' WHERE name='Hemianthus callitrichoides';
UPDATE namelist SET fullname='Torenia crustacea (L.) Cham. & Schltdl.',
name='Torenia crustacea' WHERE name='Lindernia crustacea';
UPDATE namelist SET fullname='Vandellia anagallis (Burm. f.) T. Yamaz.',
name='Vandellia anagallis' WHERE name='Lindernia anagallis';
UPDATE namelist SET fullname='Vandellia scutellariiformis (T. Yamaz.) T. Yamaz.',
name='Vandellia scutellariiformis' WHERE name='Lindernia scutellariiformis';
UPDATE namelist SET fullname='Vandellia viscosa (Hornem.) Merr.',
name='Vandellia viscosa' WHERE name='Lindernia viscosa';
-- update genus
UPDATE namelist SET genus = split_part(name, ' ', 1) WHERE family='Linderniaceae';
UPDATE namelist SET genus_zh = '泥花草屬' WHERE genus = 'Bonnaya';
UPDATE namelist SET genus_zh = '母草屬' WHERE genus = 'Lindernia';
UPDATE namelist SET genus_zh = '珍珠草屬' WHERE genus = 'Micranthemum';
UPDATE namelist SET genus_zh = '倒地蜈蚣屬' WHERE genus = 'Torenia';
UPDATE namelist SET genus_zh = '見風紅屬' WHERE genus = 'Vandellia';
-- update literature
UPDATE namelist SET literature='Willdenowia, 43(2), 209–238.',literature_yr='2013' WHERE zh_name[1]='泥花草';
UPDATE namelist SET literature='Willdenowia, 43(2), 209–238.',literature_yr='2013' WHERE zh_name[1]='水丁黃';
UPDATE namelist SET literature='Willdenowia, 43(2), 209–238.',literature_yr='2013' WHERE zh_name[1]='旱田草';
UPDATE namelist SET literature='Willdenowia, 43(2), 209–238.',literature_yr='2013' WHERE zh_name[1]='薄葉見風紅';
UPDATE namelist SET literature='Willdenowia, 43(2), 209–238.',literature_yr='2013' WHERE zh_name[1]='擬櫻草';
UPDATE namelist SET literature='Willdenowia, 43(2), 209–238.',literature_yr='2013' WHERE zh_name[1]='美洲母草';
UPDATE namelist SET literature='Willdenowia, 43(2), 209–238.',literature_yr='2013' WHERE zh_name[1]='迷你矮珍珠';
UPDATE namelist SET literature='Willdenowia, 43(2), 209–238.',literature_yr='2013' WHERE zh_name[1]='藍豬耳';
UPDATE namelist SET literature='Willdenowia, 43(2), 209–238.',literature_yr='2013' WHERE zh_name[1]='定經草';
UPDATE namelist SET literature='Willdenowia, 43(2), 209–238.',literature_yr='2013' WHERE zh_name[1]='臺南見風紅';
UPDATE namelist SET literature='Willdenowia, 43(2), 209–238.',literature_yr='2013' WHERE zh_name[1]='臺南見風紅';
-- delete exclude species
DELETE FROM namelist WHERE name='Lindernia viatica' and id = 3280;
DELETE FROM namelist WHERE name='Lindernia hyssopoides' and id = 3272;
DELETE FROM namelist WHERE name='Lindernia mollis' and id = 3273;
COMMIT;
根據 Fischer et al. (2013) 母草科的親緣關係研究論文，新增 Linderniella 屬1，也針對 Bonnaya, Lindernia, Vandellia 等屬中的種類進行修訂。預計將把臺灣母草科的處理為下方列表（粗體字為變動的分類群）。過去在臺灣植物誌中母草科有三個屬(放在玄參科中)，目前則有六個屬，其中 Bonnaya (泥花草屬) 和 Vandellia (見風紅屬) 兩屬為新增的屬(珍珠草屬全為歸化/栽培種)。此外根據 Liang (2012) 的母草屬訂正文章中，排除三個物種(擬泥花草、尖果母草以及見風紅)3：
Bonnaya 泥花草屬 (4 species)
Bonnaya multiflora Bonati (≡ Lindernia viatica (Kerr ex Barnett) Philcox) 擬泥花草(排除種3)Legazpia 三翅萼屬 (1 species)
Lindernia 母草屬 (3 species, 2 varieties)
Lindernia hyssopoides (L.) Haines 尖果母草(hyssopioides? 需確認文獻，不過它是排除種3就不理它了，哈哈)Micranthemum 珍珠草屬 (2 species)
Torenia 倒地蜈蚣屬 (6 species)
Vandellia 見風紅屬 (3 species)
Vandellia 擬新譯屬名為「見風紅屬」，因為 Vandellia 的模式種為 V. viscosa (屏東見風紅)
Vandellia montana (Blume) Benth. (≡ Lindernia mollis (Benth.) Wettst.) 見風紅(排除種3)References