Revision 13105
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 8781 | 8781 |
-- |
| 8782 | 8782 |
|
| 8783 | 8783 |
CREATE VIEW _plots_06_list_of_plots_with_stem_measurements AS |
| 8784 |
SELECT project.projectname AS project_name, |
|
| 8784 |
SELECT DISTINCT project.projectname AS project_name,
|
|
| 8785 | 8785 |
plot.authorlocationcode AS plot_code |
| 8786 | 8786 |
FROM ((public.plot |
| 8787 | 8787 |
JOIN public.locationevent USING (plot_id)) |
| ... | ... | |
| 8821 | 8821 |
-- |
| 8822 | 8822 |
|
| 8823 | 8823 |
CREATE VIEW _plots_07_list_of_plots_which_use_counts_of_indiv_per_species AS |
| 8824 |
SELECT project.projectname AS project_name, |
|
| 8824 |
SELECT DISTINCT project.projectname AS project_name,
|
|
| 8825 | 8825 |
plot.authorlocationcode AS plot_code |
| 8826 | 8826 |
FROM ((public.plot |
| 8827 | 8827 |
JOIN public.locationevent USING (plot_id)) |
| ... | ... | |
| 8859 | 8859 |
-- |
| 8860 | 8860 |
|
| 8861 | 8861 |
CREATE VIEW _plots_09_list_of_plots_which_use_line_intercept AS |
| 8862 |
SELECT project.projectname AS project_name, |
|
| 8862 |
SELECT DISTINCT project.projectname AS project_name,
|
|
| 8863 | 8863 |
plot.authorlocationcode AS plot_code |
| 8864 | 8864 |
FROM ((public.plot |
| 8865 | 8865 |
JOIN public.locationevent USING (plot_id)) |
Also available in: Unified diff
fix: schemas/vegbien.sql: plots* with duplicated rows: removed duplicated rows