Skip to content

Species with missing scientificname, genus, species, and commonname #8

Open
@dlebauer

Description

@dlebauer

@dlebauer commented on Tue Mar 17 2015

There are 19 species records that have no scientificname, genus, species, or commonname. All are associated with citation_id 199 (Xiaohui Feng, field data).

Some are apparently plant communities. A few appear to be specific species, and four have no information.

For communities please give a descriiption that we can put in the commonname field (similar to how the USDA plants database has entries for plant types ("Tree", "Subshrub") or at least the name of a specific community.

Notably, all of these records are for c2n_[root, leaf, stem] or seedling_mortality; none are associated with a particular site, and although they were collected pre 2000, all have checked = -1 are not associated with their original citation. One option would be to delete these.

These were discussed three years ago in Redmine 737.

Presumably "PFTs" would be a better place for such community level definitions, but is beyond the scope of what we can do presently with the database.

select id, AcceptedSymbol from traits join species on traits.specie_id = species.id 
        where scientificname = '' and commonname = '' ;
id AcceptedSymbol
2925 prairiemix4woody
2932 SORI2
2922 prairiemix4forb
2888 POBA
2892 POMATRI
2895 POEU
2899 prairiemix6
2902 HEGR4*HEMA2
2904 ASLA5
2905 ASOO4
2910 DESM
2911 ECHI
51169
2921 Prairemix2-11
51106
51107
51111
2923 prairiemix4grass
2924 prairiemix4legu

(19 rows)


@mdietze commented on Wed Mar 18 2015

This should be assigned to Sunny since it's her data


@dlebauer commented on Wed Mar 18 2015

Does she have a github account?
On Wed, Mar 18, 2015 at 7:42 AM Michael Dietze notifications@github.com
wrote:

This should be assigned to Sunny since it's her data


Reply to this email directly or view it on GitHub
PecanProject/bety#269 (comment).


@mdietze commented on Wed Mar 18 2015

@lovelilyinfall


@lovelilyinfall commented on Tue Mar 24 2015

These data are not my field data collected from EBI farm. EBI farm did not have these species planted. In addition, all my data from EBI farm are on species level. I have looked but not found the literature for these data. I think you can delete them.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions