Revision 12168
Added by Aaron Marcuse-Kubitza almost 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 3456 | 3456 |
|
| 3457 | 3457 |
|
| 3458 | 3458 |
-- |
| 3459 |
-- Name: _01_count_of_projects; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 3460 |
-- |
|
| 3461 |
|
|
| 3462 |
|
|
| 3463 |
|
|
| 3464 |
|
|
| 3465 |
-- |
|
| 3466 |
-- Name: _02_list_of_project_names; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 3467 |
-- |
|
| 3468 |
|
|
| 3469 |
|
|
| 3470 |
|
|
| 3471 |
|
|
| 3472 |
-- |
|
| 3473 |
-- Name: _03_count_of_all_plots_in_this_source; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 3474 |
-- |
|
| 3475 |
|
|
| 3476 |
|
|
| 3477 |
|
|
| 3478 |
|
|
| 3479 |
-- |
|
| 3480 |
-- Name: _04_count_of_plots_in_each_project_in_this_source; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 3481 |
-- |
|
| 3482 |
|
|
| 3483 |
|
|
| 3484 |
|
|
| 3485 |
|
|
| 3486 |
-- |
|
| 3487 |
-- Name: _05_list_of_plot_codes_by_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 3488 |
-- |
|
| 3489 |
|
|
| 3490 |
|
|
| 3491 |
|
|
| 3492 |
|
|
| 3493 |
-- |
|
| 3494 |
-- Name: _06_list_of_plots_with_stem_measurements; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 3495 |
-- |
|
| 3496 |
|
|
| 3497 |
|
|
| 3498 |
|
|
| 3499 |
|
|
| 3500 |
-- |
|
| 3501 |
-- Name: _10_count_of_individuals_per_plot_in_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 3502 |
-- |
|
| 3503 |
|
|
| 3504 |
|
|
| 3505 |
|
|
| 3506 |
|
|
| 3507 |
-- |
|
| 3508 |
-- Name: _11_count_of_stems_per_plot_in_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 3509 |
-- |
|
| 3510 |
|
|
| 3511 |
|
|
| 3512 |
|
|
| 3513 |
|
|
| 3514 |
-- |
|
| 3515 |
-- Name: _12_count_of_verbatim_taxa_per_plot_in_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 3516 |
-- |
|
| 3517 |
|
|
| 3518 |
|
|
| 3519 |
|
|
| 3520 |
|
|
| 3521 |
-- |
|
| 3522 |
-- Name: _13_list_of_distinct_verbatim_taxa_in_each_plot_in_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 3523 |
-- |
|
| 3524 |
|
|
| 3525 |
|
|
| 3526 |
|
|
| 3527 |
|
|
| 3528 |
-- |
|
| 3529 |
-- Name: _14_count_of_indiv_per_verbatim_taxon_per_plot_in_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 3530 |
-- |
|
| 3531 |
|
|
| 3532 |
|
|
| 3533 |
|
|
| 3534 |
|
|
| 3535 |
-- |
|
| 3536 |
-- Name: _15_pct_cover_of_each_verb_taxon_in_each_plot_in_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 3537 |
-- |
|
| 3538 |
|
|
| 3539 |
|
|
| 3540 |
|
|
| 3541 |
|
|
| 3542 |
-- |
|
| 3543 |
-- Name: _17_count_of_subplots_per_plot_for_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 3544 |
-- |
|
| 3545 |
|
|
| 3546 |
|
|
| 3547 |
|
|
| 3548 |
|
|
| 3549 |
-- |
|
| 3550 |
-- Name: _18_list_of_subplots_codes_for_each_plot_for_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 3551 |
-- |
|
| 3552 |
|
|
| 3553 |
|
|
| 3554 |
|
|
| 3555 |
|
|
| 3556 |
|
|
| 3557 |
|
|
| 3558 |
-- |
|
| 3459 | 3559 |
-- Name: _01_count_records; Type: VIEW; Schema: public_validation_traits; Owner: - |
| 3460 | 3560 |
-- |
| 3461 | 3561 |
|
Also available in: Unified diff
schemas/vegbien.sql: public_validation_plots: populated queries from validation/aggregating/plots/bien3_validations_salvias_vegbien.sql