Revision 13913
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.sql | ||
|---|---|---|
| 6123 | 6123 |
analytical_stem."decimalLatitude__@DwC__@vegpath.org" AS "decimalLatitude", |
| 6124 | 6124 |
analytical_stem."decimalLongitude__@DwC__@vegpath.org" AS "decimalLongitude", |
| 6125 | 6125 |
analytical_stem."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org" AS "dateCollected", |
| 6126 |
source__observation_type(analytical_stem."datasource__@Brad__.identifier_examples@vegpath.org") AS collection_type, |
|
| 6126 | 6127 |
COALESCE(analytical_stem."[custodial_]institutionCode[s]__@DwC__@vegpath.org", analytical_stem."datasource__@Brad__.identifier_examples@vegpath.org") AS orig_datasource, |
| 6127 | 6128 |
analytical_stem.scrubbed_family AS accepted_family, |
| 6128 | 6129 |
analytical_stem.scrubbed_genus AS accepted_genus, |
Also available in: Unified diff
schemas/public_.sql: 2014-6-4.Iara_Lacher.reserve_prioritization: added collection_type (using source__observation_type())