Revision 12629
Added by Aaron Marcuse-Kubitza almost 11 years ago
| vegbien.sql | ||
|---|---|---|
| 7316 | 7316 |
JOIN public.aggregateoccurrence USING (taxonoccurrence_id)) |
| 7317 | 7317 |
JOIN public.plantobservation USING (aggregateoccurrence_id)) |
| 7318 | 7318 |
JOIN public.stemobservation USING (plantobservation_id)) |
| 7319 |
WHERE (location.plot_location_id = plot.location_id)
|
|
| 7319 |
WHERE ((location.plot_location_id = plot.location_id) AND ((stemobservation.sourceaccessioncode IS NOT NULL) OR (stemobservation.authorstemcode IS NOT NULL)))
|
|
| 7320 | 7320 |
LIMIT 1))) |
| 7321 | 7321 |
ORDER BY plot.authorlocationcode; |
| 7322 | 7322 |
|
Also available in: Unified diff
bugfix: schemas/vegbien.sql: _plots_06_list_of_plots_with_stem_measurements: only include stemobservation records which have actual stem IDs, not merely stem-related measurements (DBH, etc.)