Revision 12186
Added by Aaron Marcuse-Kubitza almost 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 10 | 10 |
|
| 11 | 11 |
|
| 12 | 12 |
-- |
| 13 |
-- Name: public_validations_plots; Type: SCHEMA; Schema: -; Owner: -
|
|
| 13 |
-- Name: public_validations; Type: SCHEMA; Schema: -; Owner: - |
|
| 14 | 14 |
-- |
| 15 | 15 |
|
| 16 |
CREATE SCHEMA public_validations_plots;
|
|
| 16 |
CREATE SCHEMA public_validations; |
|
| 17 | 17 |
|
| 18 | 18 |
|
| 19 | 19 |
-- |
| 20 |
-- Name: SCHEMA public_validations_plots; Type: COMMENT; Schema: -; Owner: -
|
|
| 20 |
-- Name: SCHEMA public_validations; Type: COMMENT; Schema: -; Owner: - |
|
| 21 | 21 |
-- |
| 22 | 22 |
|
| 23 | 23 |
|
| 24 | 24 |
|
| 25 | 25 |
|
| 26 |
-- |
|
| 27 |
-- Name: public_validations_specimens; Type: SCHEMA; Schema: -; Owner: - |
|
| 28 |
-- |
|
| 29 | 26 |
|
| 30 |
CREATE SCHEMA public_validations_specimens; |
|
| 31 | 27 |
|
| 32 |
|
|
| 33 | 28 |
-- |
| 34 |
-- Name: SCHEMA public_validations_specimens; Type: COMMENT; Schema: -; Owner: - |
|
| 35 |
-- |
|
| 36 |
|
|
| 37 |
|
|
| 38 |
|
|
| 39 |
|
|
| 40 |
-- |
|
| 41 |
-- Name: public_validations_traits; Type: SCHEMA; Schema: -; Owner: - |
|
| 42 |
-- |
|
| 43 |
|
|
| 44 |
CREATE SCHEMA public_validations_traits; |
|
| 45 |
|
|
| 46 |
|
|
| 47 |
-- |
|
| 48 |
-- Name: SCHEMA public_validations_traits; Type: COMMENT; Schema: -; Owner: - |
|
| 49 |
-- |
|
| 50 |
|
|
| 51 |
|
|
| 52 |
|
|
| 53 |
|
|
| 54 |
|
|
| 55 |
|
|
| 56 |
-- |
|
| 57 | 29 |
-- Name: accesslevel; Type: TYPE; Schema: public; Owner: - |
| 58 | 30 |
-- |
| 59 | 31 |
|
| ... | ... | |
| 3456 | 3428 |
|
| 3457 | 3429 |
|
| 3458 | 3430 |
-- |
| 3459 |
-- Name: _01_count_of_projects; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 3431 |
-- Name: plots_01_count_of_projects; Type: VIEW; Schema: public_validations; Owner: -
|
|
| 3460 | 3432 |
-- |
| 3461 | 3433 |
|
| 3462 | 3434 |
|
| 3463 | 3435 |
|
| 3464 | 3436 |
|
| 3465 | 3437 |
-- |
| 3466 |
-- Name: _02_list_of_project_names; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 3438 |
-- Name: plots_02_list_of_project_names; Type: VIEW; Schema: public_validations; Owner: -
|
|
| 3467 | 3439 |
-- |
| 3468 | 3440 |
|
| 3469 | 3441 |
|
| 3470 | 3442 |
|
| 3471 | 3443 |
|
| 3472 | 3444 |
-- |
| 3473 |
-- Name: _03_count_of_all_plots_in_this_source; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 3445 |
-- Name: plots_03_count_of_all_plots_in_this_source; Type: VIEW; Schema: public_validations; Owner: -
|
|
| 3474 | 3446 |
-- |
| 3475 | 3447 |
|
| 3476 | 3448 |
|
| 3477 | 3449 |
|
| 3478 | 3450 |
|
| 3479 | 3451 |
-- |
| 3480 |
-- Name: _04_count_of_plots_in_each_project_in_this_source; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 3452 |
-- Name: plots_04_count_of_plots_in_each_project_in_this_source; Type: VIEW; Schema: public_validations; Owner: -
|
|
| 3481 | 3453 |
-- |
| 3482 | 3454 |
|
| 3483 | 3455 |
|
| 3484 | 3456 |
|
| 3485 | 3457 |
|
| 3486 | 3458 |
-- |
| 3487 |
-- Name: _05_list_of_plot_codes_by_project; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 3459 |
-- Name: plots_05_list_of_plot_codes_by_project; Type: VIEW; Schema: public_validations; Owner: -
|
|
| 3488 | 3460 |
-- |
| 3489 | 3461 |
|
| 3490 | 3462 |
|
| 3491 | 3463 |
|
| 3492 | 3464 |
|
| 3493 | 3465 |
-- |
| 3494 |
-- Name: _06_list_of_plots_with_stem_measurements; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 3466 |
-- Name: plots_06_list_of_plots_with_stem_measurements; Type: VIEW; Schema: public_validations; Owner: -
|
|
| 3495 | 3467 |
-- |
| 3496 | 3468 |
|
| 3497 | 3469 |
|
| 3498 | 3470 |
|
| 3499 | 3471 |
|
| 3500 | 3472 |
-- |
| 3501 |
-- Name: _10_count_of_individuals_per_plot_in_each_project; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 3473 |
-- Name: plots_10_count_of_individuals_per_plot_in_each_project; Type: VIEW; Schema: public_validations; Owner: -
|
|
| 3502 | 3474 |
-- |
| 3503 | 3475 |
|
| 3504 | 3476 |
|
| 3505 | 3477 |
|
| 3506 | 3478 |
|
| 3507 | 3479 |
-- |
| 3508 |
-- Name: VIEW _10_count_of_individuals_per_plot_in_each_project; Type: COMMENT; Schema: public_validations_plots; Owner: -
|
|
| 3480 |
-- Name: VIEW plots_10_count_of_individuals_per_plot_in_each_project; Type: COMMENT; Schema: public_validations; Owner: -
|
|
| 3509 | 3481 |
-- |
| 3510 | 3482 |
|
| 3511 | 3483 |
|
| 3512 | 3484 |
|
| 3513 | 3485 |
|
| 3514 | 3486 |
-- |
| 3515 |
-- Name: _11_count_of_stems_per_plot_in_each_project; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 3487 |
-- Name: plots_11_count_of_stems_per_plot_in_each_project; Type: VIEW; Schema: public_validations; Owner: -
|
|
| 3516 | 3488 |
-- |
| 3517 | 3489 |
|
| 3518 | 3490 |
|
| 3519 | 3491 |
|
| 3520 | 3492 |
|
| 3521 | 3493 |
-- |
| 3522 |
-- Name: VIEW _11_count_of_stems_per_plot_in_each_project; Type: COMMENT; Schema: public_validations_plots; Owner: -
|
|
| 3494 |
-- Name: VIEW plots_11_count_of_stems_per_plot_in_each_project; Type: COMMENT; Schema: public_validations; Owner: -
|
|
| 3523 | 3495 |
-- |
| 3524 | 3496 |
|
| 3525 | 3497 |
|
| 3526 | 3498 |
|
| 3527 | 3499 |
|
| 3528 | 3500 |
-- |
| 3529 |
-- Name: _12_count_of_verbatim_taxa_per_plot_in_each_project; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 3501 |
-- Name: plots_12_count_of_verbatim_taxa_per_plot_in_each_project; Type: VIEW; Schema: public_validations; Owner: -
|
|
| 3530 | 3502 |
-- |
| 3531 | 3503 |
|
| 3532 | 3504 |
|
| 3533 | 3505 |
|
| 3534 | 3506 |
|
| 3535 | 3507 |
-- |
| 3536 |
-- Name: VIEW _12_count_of_verbatim_taxa_per_plot_in_each_project; Type: COMMENT; Schema: public_validations_plots; Owner: -
|
|
| 3508 |
-- Name: VIEW plots_12_count_of_verbatim_taxa_per_plot_in_each_project; Type: COMMENT; Schema: public_validations; Owner: -
|
|
| 3537 | 3509 |
-- |
| 3538 | 3510 |
|
| 3539 | 3511 |
|
| 3540 | 3512 |
|
| 3541 | 3513 |
|
| 3542 | 3514 |
-- |
| 3543 |
-- Name: _13_list_of_distinct_verbatim_taxa_in_each_plot_in_each_project; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 3515 |
-- Name: plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_each_pr; Type: VIEW; Schema: public_validations; Owner: -
|
|
| 3544 | 3516 |
-- |
| 3545 | 3517 |
|
| 3546 | 3518 |
|
| 3547 | 3519 |
|
| 3548 | 3520 |
|
| 3549 | 3521 |
-- |
| 3550 |
-- Name: VIEW _13_list_of_distinct_verbatim_taxa_in_each_plot_in_each_project; Type: COMMENT; Schema: public_validations_plots; Owner: -
|
|
| 3522 |
-- Name: VIEW plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_each_pr; Type: COMMENT; Schema: public_validations; Owner: -
|
|
| 3551 | 3523 |
-- |
| 3552 | 3524 |
|
| 3553 | 3525 |
|
| 3554 | 3526 |
|
| 3555 | 3527 |
|
| 3556 | 3528 |
-- |
| 3557 |
-- Name: _14_count_of_indiv_per_verbatim_taxon_per_plot_in_each_project; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 3529 |
-- Name: plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_each_pro; Type: VIEW; Schema: public_validations; Owner: -
|
|
| 3558 | 3530 |
-- |
| 3559 | 3531 |
|
| 3560 | 3532 |
|
| 3561 | 3533 |
|
| 3562 | 3534 |
|
| 3563 | 3535 |
-- |
| 3564 |
-- Name: VIEW _14_count_of_indiv_per_verbatim_taxon_per_plot_in_each_project; Type: COMMENT; Schema: public_validations_plots; Owner: -
|
|
| 3536 |
-- Name: VIEW plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_each_pro; Type: COMMENT; Schema: public_validations; Owner: -
|
|
| 3565 | 3537 |
-- |
| 3566 | 3538 |
|
| 3567 | 3539 |
|
| 3568 | 3540 |
|
| 3569 | 3541 |
|
| 3570 | 3542 |
-- |
| 3571 |
-- Name: _15_pct_cover_of_each_verb_taxon_in_each_plot_in_each_project; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 3543 |
-- Name: plots_15_pct_cover_of_each_verb_taxon_in_each_plot_in_each_proj; Type: VIEW; Schema: public_validations; Owner: -
|
|
| 3572 | 3544 |
-- |
| 3573 | 3545 |
|
| 3574 | 3546 |
|
| 3575 | 3547 |
|
| 3576 | 3548 |
|
| 3577 | 3549 |
-- |
| 3578 |
-- Name: VIEW _15_pct_cover_of_each_verb_taxon_in_each_plot_in_each_project; Type: COMMENT; Schema: public_validations_plots; Owner: -
|
|
| 3550 |
-- Name: VIEW plots_15_pct_cover_of_each_verb_taxon_in_each_plot_in_each_proj; Type: COMMENT; Schema: public_validations; Owner: -
|
|
| 3579 | 3551 |
-- |
| 3580 | 3552 |
|
| 3581 | 3553 |
|
| 3582 | 3554 |
|
| 3583 | 3555 |
|
| 3584 | 3556 |
-- |
| 3585 |
-- Name: _17_count_of_subplots_per_plot_for_each_project; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 3557 |
-- Name: plots_17_count_of_subplots_per_plot_for_each_project; Type: VIEW; Schema: public_validations; Owner: -
|
|
| 3586 | 3558 |
-- |
| 3587 | 3559 |
|
| 3588 | 3560 |
|
| 3589 | 3561 |
|
| 3590 | 3562 |
|
| 3591 | 3563 |
-- |
| 3592 |
-- Name: _18_list_of_subplots_codes_for_each_plot_for_each_project; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 3564 |
-- Name: plots_18_list_of_subplots_codes_for_each_plot_for_each_project; Type: VIEW; Schema: public_validations; Owner: -
|
|
| 3593 | 3565 |
-- |
| 3594 | 3566 |
|
| 3595 | 3567 |
|
| 3596 | 3568 |
|
| 3597 | 3569 |
|
| 3598 | 3570 |
-- |
| 3599 |
-- Name: VIEW _18_list_of_subplots_codes_for_each_plot_for_each_project; Type: COMMENT; Schema: public_validations_plots; Owner: -
|
|
| 3571 |
-- Name: VIEW plots_18_list_of_subplots_codes_for_each_plot_for_each_project; Type: COMMENT; Schema: public_validations; Owner: -
|
|
| 3600 | 3572 |
-- |
| 3601 | 3573 |
|
| 3602 | 3574 |
|
| 3603 | 3575 |
|
| 3604 | 3576 |
|
| 3605 |
|
|
| 3606 |
|
|
| 3607 | 3577 |
-- |
| 3608 |
-- Name: _01_count_records; Type: VIEW; Schema: public_validations_traits; Owner: -
|
|
| 3578 |
-- Name: traits_01_count_records; Type: VIEW; Schema: public_validations; Owner: -
|
|
| 3609 | 3579 |
-- |
| 3610 | 3580 |
|
| 3611 | 3581 |
|
| 3612 | 3582 |
|
| 3613 | 3583 |
|
| 3614 | 3584 |
-- |
| 3615 |
-- Name: _02_count_trait_names; Type: VIEW; Schema: public_validations_traits; Owner: -
|
|
| 3585 |
-- Name: traits_02_count_trait_names; Type: VIEW; Schema: public_validations; Owner: -
|
|
| 3616 | 3586 |
-- |
| 3617 | 3587 |
|
| 3618 | 3588 |
|
| 3619 | 3589 |
|
| 3620 | 3590 |
|
| 3621 | 3591 |
-- |
| 3622 |
-- Name: _03_list_trait_names; Type: VIEW; Schema: public_validations_traits; Owner: -
|
|
| 3592 |
-- Name: traits_03_list_trait_names; Type: VIEW; Schema: public_validations; Owner: -
|
|
| 3623 | 3593 |
-- |
| 3624 | 3594 |
|
| 3625 | 3595 |
|
| 3626 | 3596 |
|
| 3627 | 3597 |
|
| 3628 | 3598 |
-- |
| 3629 |
-- Name: _04_count_records_per_trait; Type: VIEW; Schema: public_validations_traits; Owner: -
|
|
| 3599 |
-- Name: traits_04_count_records_per_trait; Type: VIEW; Schema: public_validations; Owner: -
|
|
| 3630 | 3600 |
-- |
| 3631 | 3601 |
|
| 3632 | 3602 |
|
| 3633 | 3603 |
|
| 3634 | 3604 |
|
| 3635 | 3605 |
-- |
| 3636 |
-- Name: _05_count_taxa; Type: VIEW; Schema: public_validations_traits; Owner: -
|
|
| 3606 |
-- Name: traits_05_count_taxa; Type: VIEW; Schema: public_validations; Owner: -
|
|
| 3637 | 3607 |
-- |
| 3638 | 3608 |
|
| 3639 | 3609 |
|
| 3640 | 3610 |
|
| 3641 | 3611 |
|
| 3642 | 3612 |
-- |
| 3643 |
-- Name: VIEW _05_count_taxa; Type: COMMENT; Schema: public_validations_traits; Owner: -
|
|
| 3613 |
-- Name: VIEW traits_05_count_taxa; Type: COMMENT; Schema: public_validations; Owner: -
|
|
| 3644 | 3614 |
-- |
| 3645 | 3615 |
|
| 3646 | 3616 |
|
| 3647 | 3617 |
|
| 3648 | 3618 |
|
| 3649 | 3619 |
-- |
| 3650 |
-- Name: _06_list_taxa; Type: VIEW; Schema: public_validations_traits; Owner: -
|
|
| 3620 |
-- Name: traits_06_list_taxa; Type: VIEW; Schema: public_validations; Owner: -
|
|
| 3651 | 3621 |
-- |
| 3652 | 3622 |
|
| 3653 | 3623 |
|
| 3654 | 3624 |
|
| 3655 | 3625 |
|
| 3656 | 3626 |
-- |
| 3657 |
-- Name: VIEW _06_list_taxa; Type: COMMENT; Schema: public_validations_traits; Owner: -
|
|
| 3627 |
-- Name: VIEW traits_06_list_taxa; Type: COMMENT; Schema: public_validations; Owner: -
|
|
| 3658 | 3628 |
-- |
| 3659 | 3629 |
|
| 3660 | 3630 |
|
| 3661 | 3631 |
|
| 3662 | 3632 |
|
| 3663 | 3633 |
-- |
| 3664 |
-- Name: _07_trait_value_and_units_for_first_5000_records; Type: VIEW; Schema: public_validations_traits; Owner: -
|
|
| 3634 |
-- Name: traits_07_trait_value_and_units_for_first_5000_records; Type: VIEW; Schema: public_validations; Owner: -
|
|
| 3665 | 3635 |
-- |
| 3666 | 3636 |
|
| 3667 | 3637 |
|
| 3668 | 3638 |
|
| 3669 | 3639 |
|
| 3670 | 3640 |
-- |
| 3671 |
-- Name: _08_taxon_trait_and_value_for_first_5000_records; Type: VIEW; Schema: public_validations_traits; Owner: -
|
|
| 3641 |
-- Name: traits_08_taxon_trait_and_value_for_first_5000_records; Type: VIEW; Schema: public_validations; Owner: -
|
|
| 3672 | 3642 |
-- |
| 3673 | 3643 |
|
| 3674 | 3644 |
|
| ... | ... | |
| 9374 | 9344 |
|
| 9375 | 9345 |
|
| 9376 | 9346 |
-- |
| 9377 |
-- Name: public_validations_plots; Type: ACL; Schema: -; Owner: -
|
|
| 9347 |
-- Name: public_validations; Type: ACL; Schema: -; Owner: - |
|
| 9378 | 9348 |
-- |
| 9379 | 9349 |
|
| 9380 | 9350 |
|
| ... | ... | |
| 9385 | 9355 |
|
| 9386 | 9356 |
|
| 9387 | 9357 |
-- |
| 9388 |
-- Name: public_validations_specimens; Type: ACL; Schema: -; Owner: - |
|
| 9389 |
-- |
|
| 9390 |
|
|
| 9391 |
|
|
| 9392 |
|
|
| 9393 |
|
|
| 9394 |
|
|
| 9395 |
|
|
| 9396 |
|
|
| 9397 |
|
|
| 9398 |
-- |
|
| 9399 |
-- Name: public_validations_traits; Type: ACL; Schema: -; Owner: - |
|
| 9400 |
-- |
|
| 9401 |
|
|
| 9402 |
|
|
| 9403 |
|
|
| 9404 |
|
|
| 9405 |
|
|
| 9406 |
|
|
| 9407 |
|
|
| 9408 |
|
|
| 9409 |
-- |
|
| 9410 | 9358 |
-- Name: source; Type: ACL; Schema: public; Owner: - |
| 9411 | 9359 |
-- |
| 9412 | 9360 |
|
Also available in: Unified diff
schemas/vegbien.sql: public_validations_*: merged into single public_validations schema, with type-specific prefixes for each query, so that datasources can use validations queries from multiple type categories, and so that each datasource doesn't have to indicate which validations output schema it's using