Revision 10950
Added by Aaron Marcuse-Kubitza over 11 years ago
- added
- modified
- copied
- renamed
- deleted
- inputs
- FIA
- import_order.txt (diff)
- taxon_observation.**
- header.csv /inputs/FIA/occurrence_all/header.csv
- map.csv /inputs/FIA/occurrence_all/map.csv
- postprocess.sql /inputs/FIA/occurrence_all/postprocess.sql
- unmapped_terms.csv /inputs/FIA/occurrence_all/unmapped_terms.csv
- FIA
inputs/FIA/occurrence_all/: renamed to taxon_observation.** to clarify what an occurrence is. taxon_observation has the same meaning as in VegCore, where each taxon_determination is considered a separate taxon_observation of the associated specimen or vouchered plant (vegpath.org/VegCore/ERD/). (note that having multiple taxon_determinations only makes sense when there is something to reobserve.) the .** is SQL dotpath syntax (wiki.vegpath.org/SQL_dotpaths) for the recursive expansion of all tables to which taxon_observation has forward fkeys (i.e. "the left-join").