Revision 6750
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/VegBank/stemlocation_/create.sql | ||
|---|---|---|
| 1 |
SELECT * |
|
| 2 |
FROM stemcount |
|
| 3 |
LEFT JOIN stemlocation USING (stemcount_id) |
|
| 4 |
; |
|
Also available in: Unified diff
| inputs/VegBank/stemlocation_/create.sql | ||
|---|---|---|
| 1 |
SELECT * |
|
| 2 |
FROM stemcount |
|
| 3 |
LEFT JOIN stemlocation USING (stemcount_id) |
|
| 4 |
; |
|
Also available in: Unified diff
inputs/VegBank/: Joined together stemcount and stemlocation tables to create stemlocation_, in order to include the stem size class's measurements in each tagged stem's stemobservation (in addition to in the stemobservation for the aggregateoccurrence as a whole)