Revision 11865
Added by Aaron Marcuse-Kubitza about 11 years ago
create.sql | ||
---|---|---|
1 | 1 |
SELECT * |
2 | 2 |
FROM "TaxonOccurrence.src" |
3 |
LEFT JOIN "InfraspecificEpithet.src" USING ("SpeciesID", "SubSpeciesID") |
|
4 |
LEFT JOIN "SpecificEpithet.src" USING ("SpeciesID") |
|
5 |
LEFT JOIN "Genus.src" USING ("GenusID") |
|
6 |
LEFT JOIN "Family.src" USING ("FamilyID") |
|
3 |
LEFT JOIN "InfraspecificEpithet.src" USING ("*SpeciesID", "*SubSpeciesID") |
|
4 |
LEFT JOIN "SpecificEpithet.src" USING ("*SpeciesID") |
|
5 |
LEFT JOIN "Genus.src" USING ("*GenusID") |
|
6 |
LEFT JOIN "Family.src" USING ("*FamilyID") |
Also available in: Unified diff
bugfix: inputs/CTFS/import_order.txt: added *.src so that these would be installed under new-style import as well. this means that their columns will now be automapped, requiring the names to be renamed to VegCore names in */create.sql. note that VegCore taxonOccurrenceID has been renamed to taxonObservationID since this was last run.