Revision 12182
Added by Aaron Marcuse-Kubitza almost 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 10 | 10 |
|
| 11 | 11 |
|
| 12 | 12 |
-- |
| 13 |
-- Name: public_validation_plots; Type: SCHEMA; Schema: -; Owner: - |
|
| 13 |
-- Name: public_validations_plots; Type: SCHEMA; Schema: -; Owner: -
|
|
| 14 | 14 |
-- |
| 15 | 15 |
|
| 16 |
CREATE SCHEMA public_validation_plots; |
|
| 16 |
CREATE SCHEMA public_validations_plots;
|
|
| 17 | 17 |
|
| 18 | 18 |
|
| 19 | 19 |
-- |
| 20 |
-- Name: SCHEMA public_validation_plots; Type: COMMENT; Schema: -; Owner: - |
|
| 20 |
-- Name: SCHEMA public_validations_plots; Type: COMMENT; Schema: -; Owner: -
|
|
| 21 | 21 |
-- |
| 22 | 22 |
|
| 23 | 23 |
|
| 24 | 24 |
|
| 25 | 25 |
|
| 26 | 26 |
-- |
| 27 |
-- Name: public_validation_specimens; Type: SCHEMA; Schema: -; Owner: - |
|
| 27 |
-- Name: public_validations_specimens; Type: SCHEMA; Schema: -; Owner: -
|
|
| 28 | 28 |
-- |
| 29 | 29 |
|
| 30 |
CREATE SCHEMA public_validation_specimens; |
|
| 30 |
CREATE SCHEMA public_validations_specimens;
|
|
| 31 | 31 |
|
| 32 | 32 |
|
| 33 | 33 |
-- |
| 34 |
-- Name: SCHEMA public_validation_specimens; Type: COMMENT; Schema: -; Owner: - |
|
| 34 |
-- Name: SCHEMA public_validations_specimens; Type: COMMENT; Schema: -; Owner: -
|
|
| 35 | 35 |
-- |
| 36 | 36 |
|
| 37 | 37 |
|
| 38 | 38 |
|
| 39 | 39 |
|
| 40 | 40 |
-- |
| 41 |
-- Name: public_validation_traits; Type: SCHEMA; Schema: -; Owner: - |
|
| 41 |
-- Name: public_validations_traits; Type: SCHEMA; Schema: -; Owner: -
|
|
| 42 | 42 |
-- |
| 43 | 43 |
|
| 44 |
CREATE SCHEMA public_validation_traits; |
|
| 44 |
CREATE SCHEMA public_validations_traits;
|
|
| 45 | 45 |
|
| 46 | 46 |
|
| 47 | 47 |
-- |
| 48 |
-- Name: SCHEMA public_validation_traits; Type: COMMENT; Schema: -; Owner: - |
|
| 48 |
-- Name: SCHEMA public_validations_traits; Type: COMMENT; Schema: -; Owner: -
|
|
| 49 | 49 |
-- |
| 50 | 50 |
|
| 51 | 51 |
|
| ... | ... | |
| 3456 | 3456 |
|
| 3457 | 3457 |
|
| 3458 | 3458 |
-- |
| 3459 |
-- Name: _01_count_of_projects; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 3459 |
-- Name: _01_count_of_projects; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 3460 | 3460 |
-- |
| 3461 | 3461 |
|
| 3462 | 3462 |
|
| 3463 | 3463 |
|
| 3464 | 3464 |
|
| 3465 | 3465 |
-- |
| 3466 |
-- Name: _02_list_of_project_names; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 3466 |
-- Name: _02_list_of_project_names; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 3467 | 3467 |
-- |
| 3468 | 3468 |
|
| 3469 | 3469 |
|
| 3470 | 3470 |
|
| 3471 | 3471 |
|
| 3472 | 3472 |
-- |
| 3473 |
-- Name: _03_count_of_all_plots_in_this_source; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 3473 |
-- Name: _03_count_of_all_plots_in_this_source; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 3474 | 3474 |
-- |
| 3475 | 3475 |
|
| 3476 | 3476 |
|
| 3477 | 3477 |
|
| 3478 | 3478 |
|
| 3479 | 3479 |
-- |
| 3480 |
-- Name: _04_count_of_plots_in_each_project_in_this_source; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 3480 |
-- Name: _04_count_of_plots_in_each_project_in_this_source; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 3481 | 3481 |
-- |
| 3482 | 3482 |
|
| 3483 | 3483 |
|
| 3484 | 3484 |
|
| 3485 | 3485 |
|
| 3486 | 3486 |
-- |
| 3487 |
-- Name: _05_list_of_plot_codes_by_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 3487 |
-- Name: _05_list_of_plot_codes_by_project; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 3488 | 3488 |
-- |
| 3489 | 3489 |
|
| 3490 | 3490 |
|
| 3491 | 3491 |
|
| 3492 | 3492 |
|
| 3493 | 3493 |
-- |
| 3494 |
-- Name: _06_list_of_plots_with_stem_measurements; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 3494 |
-- Name: _06_list_of_plots_with_stem_measurements; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 3495 | 3495 |
-- |
| 3496 | 3496 |
|
| 3497 | 3497 |
|
| 3498 | 3498 |
|
| 3499 | 3499 |
|
| 3500 | 3500 |
-- |
| 3501 |
-- Name: _10_count_of_individuals_per_plot_in_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 3501 |
-- Name: _10_count_of_individuals_per_plot_in_each_project; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 3502 | 3502 |
-- |
| 3503 | 3503 |
|
| 3504 | 3504 |
|
| 3505 | 3505 |
|
| 3506 | 3506 |
|
| 3507 | 3507 |
-- |
| 3508 |
-- Name: VIEW _10_count_of_individuals_per_plot_in_each_project; Type: COMMENT; Schema: public_validation_plots; Owner: - |
|
| 3508 |
-- Name: VIEW _10_count_of_individuals_per_plot_in_each_project; Type: COMMENT; Schema: public_validations_plots; Owner: -
|
|
| 3509 | 3509 |
-- |
| 3510 | 3510 |
|
| 3511 | 3511 |
|
| 3512 | 3512 |
|
| 3513 | 3513 |
|
| 3514 | 3514 |
-- |
| 3515 |
-- Name: _11_count_of_stems_per_plot_in_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 3515 |
-- Name: _11_count_of_stems_per_plot_in_each_project; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 3516 | 3516 |
-- |
| 3517 | 3517 |
|
| 3518 | 3518 |
|
| 3519 | 3519 |
|
| 3520 | 3520 |
|
| 3521 | 3521 |
-- |
| 3522 |
-- Name: VIEW _11_count_of_stems_per_plot_in_each_project; Type: COMMENT; Schema: public_validation_plots; Owner: - |
|
| 3522 |
-- Name: VIEW _11_count_of_stems_per_plot_in_each_project; Type: COMMENT; Schema: public_validations_plots; Owner: -
|
|
| 3523 | 3523 |
-- |
| 3524 | 3524 |
|
| 3525 | 3525 |
|
| 3526 | 3526 |
|
| 3527 | 3527 |
|
| 3528 | 3528 |
-- |
| 3529 |
-- Name: _12_count_of_verbatim_taxa_per_plot_in_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 3529 |
-- Name: _12_count_of_verbatim_taxa_per_plot_in_each_project; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 3530 | 3530 |
-- |
| 3531 | 3531 |
|
| 3532 | 3532 |
|
| 3533 | 3533 |
|
| 3534 | 3534 |
|
| 3535 | 3535 |
-- |
| 3536 |
-- Name: VIEW _12_count_of_verbatim_taxa_per_plot_in_each_project; Type: COMMENT; Schema: public_validation_plots; Owner: - |
|
| 3536 |
-- Name: VIEW _12_count_of_verbatim_taxa_per_plot_in_each_project; Type: COMMENT; Schema: public_validations_plots; Owner: -
|
|
| 3537 | 3537 |
-- |
| 3538 | 3538 |
|
| 3539 | 3539 |
|
| 3540 | 3540 |
|
| 3541 | 3541 |
|
| 3542 | 3542 |
-- |
| 3543 |
-- Name: _13_list_of_distinct_verbatim_taxa_in_each_plot_in_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 3543 |
-- Name: _13_list_of_distinct_verbatim_taxa_in_each_plot_in_each_project; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 3544 | 3544 |
-- |
| 3545 | 3545 |
|
| 3546 | 3546 |
|
| 3547 | 3547 |
|
| 3548 | 3548 |
|
| 3549 | 3549 |
-- |
| 3550 |
-- Name: VIEW _13_list_of_distinct_verbatim_taxa_in_each_plot_in_each_project; Type: COMMENT; Schema: public_validation_plots; Owner: - |
|
| 3550 |
-- Name: VIEW _13_list_of_distinct_verbatim_taxa_in_each_plot_in_each_project; Type: COMMENT; Schema: public_validations_plots; Owner: -
|
|
| 3551 | 3551 |
-- |
| 3552 | 3552 |
|
| 3553 | 3553 |
|
| 3554 | 3554 |
|
| 3555 | 3555 |
|
| 3556 | 3556 |
-- |
| 3557 |
-- Name: _14_count_of_indiv_per_verbatim_taxon_per_plot_in_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 3557 |
-- Name: _14_count_of_indiv_per_verbatim_taxon_per_plot_in_each_project; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 3558 | 3558 |
-- |
| 3559 | 3559 |
|
| 3560 | 3560 |
|
| 3561 | 3561 |
|
| 3562 | 3562 |
|
| 3563 | 3563 |
-- |
| 3564 |
-- Name: VIEW _14_count_of_indiv_per_verbatim_taxon_per_plot_in_each_project; Type: COMMENT; Schema: public_validation_plots; Owner: - |
|
| 3564 |
-- Name: VIEW _14_count_of_indiv_per_verbatim_taxon_per_plot_in_each_project; Type: COMMENT; Schema: public_validations_plots; Owner: -
|
|
| 3565 | 3565 |
-- |
| 3566 | 3566 |
|
| 3567 | 3567 |
|
| 3568 | 3568 |
|
| 3569 | 3569 |
|
| 3570 | 3570 |
-- |
| 3571 |
-- Name: _15_pct_cover_of_each_verb_taxon_in_each_plot_in_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 3571 |
-- Name: _15_pct_cover_of_each_verb_taxon_in_each_plot_in_each_project; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 3572 | 3572 |
-- |
| 3573 | 3573 |
|
| 3574 | 3574 |
|
| 3575 | 3575 |
|
| 3576 | 3576 |
|
| 3577 | 3577 |
-- |
| 3578 |
-- Name: VIEW _15_pct_cover_of_each_verb_taxon_in_each_plot_in_each_project; Type: COMMENT; Schema: public_validation_plots; Owner: - |
|
| 3578 |
-- Name: VIEW _15_pct_cover_of_each_verb_taxon_in_each_plot_in_each_project; Type: COMMENT; Schema: public_validations_plots; Owner: -
|
|
| 3579 | 3579 |
-- |
| 3580 | 3580 |
|
| 3581 | 3581 |
|
| 3582 | 3582 |
|
| 3583 | 3583 |
|
| 3584 | 3584 |
-- |
| 3585 |
-- Name: _17_count_of_subplots_per_plot_for_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 3585 |
-- Name: _17_count_of_subplots_per_plot_for_each_project; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 3586 | 3586 |
-- |
| 3587 | 3587 |
|
| 3588 | 3588 |
|
| 3589 | 3589 |
|
| 3590 | 3590 |
|
| 3591 | 3591 |
-- |
| 3592 |
-- Name: _18_list_of_subplots_codes_for_each_plot_for_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 3592 |
-- Name: _18_list_of_subplots_codes_for_each_plot_for_each_project; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 3593 | 3593 |
-- |
| 3594 | 3594 |
|
| 3595 | 3595 |
|
| 3596 | 3596 |
|
| 3597 | 3597 |
|
| 3598 | 3598 |
-- |
| 3599 |
-- Name: VIEW _18_list_of_subplots_codes_for_each_plot_for_each_project; Type: COMMENT; Schema: public_validation_plots; Owner: - |
|
| 3599 |
-- Name: VIEW _18_list_of_subplots_codes_for_each_plot_for_each_project; Type: COMMENT; Schema: public_validations_plots; Owner: -
|
|
| 3600 | 3600 |
-- |
| 3601 | 3601 |
|
| 3602 | 3602 |
|
| ... | ... | |
| 3605 | 3605 |
|
| 3606 | 3606 |
|
| 3607 | 3607 |
-- |
| 3608 |
-- Name: _01_count_records; Type: VIEW; Schema: public_validation_traits; Owner: - |
|
| 3608 |
-- Name: _01_count_records; Type: VIEW; Schema: public_validations_traits; Owner: -
|
|
| 3609 | 3609 |
-- |
| 3610 | 3610 |
|
| 3611 | 3611 |
|
| 3612 | 3612 |
|
| 3613 | 3613 |
|
| 3614 | 3614 |
-- |
| 3615 |
-- Name: _02_count_trait_names; Type: VIEW; Schema: public_validation_traits; Owner: - |
|
| 3615 |
-- Name: _02_count_trait_names; Type: VIEW; Schema: public_validations_traits; Owner: -
|
|
| 3616 | 3616 |
-- |
| 3617 | 3617 |
|
| 3618 | 3618 |
|
| 3619 | 3619 |
|
| 3620 | 3620 |
|
| 3621 | 3621 |
-- |
| 3622 |
-- Name: _03_list_trait_names; Type: VIEW; Schema: public_validation_traits; Owner: - |
|
| 3622 |
-- Name: _03_list_trait_names; Type: VIEW; Schema: public_validations_traits; Owner: -
|
|
| 3623 | 3623 |
-- |
| 3624 | 3624 |
|
| 3625 | 3625 |
|
| 3626 | 3626 |
|
| 3627 | 3627 |
|
| 3628 | 3628 |
-- |
| 3629 |
-- Name: _04_count_records_per_trait; Type: VIEW; Schema: public_validation_traits; Owner: - |
|
| 3629 |
-- Name: _04_count_records_per_trait; Type: VIEW; Schema: public_validations_traits; Owner: -
|
|
| 3630 | 3630 |
-- |
| 3631 | 3631 |
|
| 3632 | 3632 |
|
| 3633 | 3633 |
|
| 3634 | 3634 |
|
| 3635 | 3635 |
-- |
| 3636 |
-- Name: _05_count_taxa; Type: VIEW; Schema: public_validation_traits; Owner: - |
|
| 3636 |
-- Name: _05_count_taxa; Type: VIEW; Schema: public_validations_traits; Owner: -
|
|
| 3637 | 3637 |
-- |
| 3638 | 3638 |
|
| 3639 | 3639 |
|
| 3640 | 3640 |
|
| 3641 | 3641 |
|
| 3642 | 3642 |
-- |
| 3643 |
-- Name: VIEW _05_count_taxa; Type: COMMENT; Schema: public_validation_traits; Owner: - |
|
| 3643 |
-- Name: VIEW _05_count_taxa; Type: COMMENT; Schema: public_validations_traits; Owner: -
|
|
| 3644 | 3644 |
-- |
| 3645 | 3645 |
|
| 3646 | 3646 |
|
| 3647 | 3647 |
|
| 3648 | 3648 |
|
| 3649 | 3649 |
-- |
| 3650 |
-- Name: _06_list_taxa; Type: VIEW; Schema: public_validation_traits; Owner: - |
|
| 3650 |
-- Name: _06_list_taxa; Type: VIEW; Schema: public_validations_traits; Owner: -
|
|
| 3651 | 3651 |
-- |
| 3652 | 3652 |
|
| 3653 | 3653 |
|
| 3654 | 3654 |
|
| 3655 | 3655 |
|
| 3656 | 3656 |
-- |
| 3657 |
-- Name: VIEW _06_list_taxa; Type: COMMENT; Schema: public_validation_traits; Owner: - |
|
| 3657 |
-- Name: VIEW _06_list_taxa; Type: COMMENT; Schema: public_validations_traits; Owner: -
|
|
| 3658 | 3658 |
-- |
| 3659 | 3659 |
|
| 3660 | 3660 |
|
| 3661 | 3661 |
|
| 3662 | 3662 |
|
| 3663 | 3663 |
-- |
| 3664 |
-- Name: _07_trait_value_and_units_for_first_5000_records; Type: VIEW; Schema: public_validation_traits; Owner: - |
|
| 3664 |
-- Name: _07_trait_value_and_units_for_first_5000_records; Type: VIEW; Schema: public_validations_traits; Owner: -
|
|
| 3665 | 3665 |
-- |
| 3666 | 3666 |
|
| 3667 | 3667 |
|
| 3668 | 3668 |
|
| 3669 | 3669 |
|
| 3670 | 3670 |
-- |
| 3671 |
-- Name: _08_taxon_trait_and_value_for_first_5000_records; Type: VIEW; Schema: public_validation_traits; Owner: - |
|
| 3671 |
-- Name: _08_taxon_trait_and_value_for_first_5000_records; Type: VIEW; Schema: public_validations_traits; Owner: -
|
|
| 3672 | 3672 |
-- |
| 3673 | 3673 |
|
| 3674 | 3674 |
|
| ... | ... | |
| 9374 | 9374 |
|
| 9375 | 9375 |
|
| 9376 | 9376 |
-- |
| 9377 |
-- Name: public_validation_plots; Type: ACL; Schema: -; Owner: - |
|
| 9377 |
-- Name: public_validations_plots; Type: ACL; Schema: -; Owner: -
|
|
| 9378 | 9378 |
-- |
| 9379 | 9379 |
|
| 9380 | 9380 |
|
| ... | ... | |
| 9385 | 9385 |
|
| 9386 | 9386 |
|
| 9387 | 9387 |
-- |
| 9388 |
-- Name: public_validation_specimens; Type: ACL; Schema: -; Owner: - |
|
| 9388 |
-- Name: public_validations_specimens; Type: ACL; Schema: -; Owner: -
|
|
| 9389 | 9389 |
-- |
| 9390 | 9390 |
|
| 9391 | 9391 |
|
| ... | ... | |
| 9396 | 9396 |
|
| 9397 | 9397 |
|
| 9398 | 9398 |
-- |
| 9399 |
-- Name: public_validation_traits; Type: ACL; Schema: -; Owner: - |
|
| 9399 |
-- Name: public_validations_traits; Type: ACL; Schema: -; Owner: -
|
|
| 9400 | 9400 |
-- |
| 9401 | 9401 |
|
| 9402 | 9402 |
|
Also available in: Unified diff
schemas/vegbien.sql, validation/aggregating/*/*.sql: renamed public_validation_* to plural public_validations_* since we refer to them as aggregating validation*s*