Revision 12169
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 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: - |
|
| 3509 |
-- |
|
| 3510 |
|
|
| 3511 |
|
|
| 3512 |
|
|
| 3513 |
|
|
| 3514 |
-- |
|
| 3508 | 3515 |
-- Name: _11_count_of_stems_per_plot_in_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
| 3509 | 3516 |
-- |
| 3510 | 3517 |
|
| ... | ... | |
| 3512 | 3519 |
|
| 3513 | 3520 |
|
| 3514 | 3521 |
-- |
| 3522 |
-- Name: VIEW _11_count_of_stems_per_plot_in_each_project; Type: COMMENT; Schema: public_validation_plots; Owner: - |
|
| 3523 |
-- |
|
| 3524 |
|
|
| 3525 |
|
|
| 3526 |
|
|
| 3527 |
|
|
| 3528 |
-- |
|
| 3515 | 3529 |
-- Name: _12_count_of_verbatim_taxa_per_plot_in_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
| 3516 | 3530 |
-- |
| 3517 | 3531 |
|
| ... | ... | |
| 3519 | 3533 |
|
| 3520 | 3534 |
|
| 3521 | 3535 |
-- |
| 3536 |
-- Name: VIEW _12_count_of_verbatim_taxa_per_plot_in_each_project; Type: COMMENT; Schema: public_validation_plots; Owner: - |
|
| 3537 |
-- |
|
| 3538 |
|
|
| 3539 |
|
|
| 3540 |
|
|
| 3541 |
|
|
| 3542 |
-- |
|
| 3522 | 3543 |
-- Name: _13_list_of_distinct_verbatim_taxa_in_each_plot_in_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
| 3523 | 3544 |
-- |
| 3524 | 3545 |
|
| ... | ... | |
| 3526 | 3547 |
|
| 3527 | 3548 |
|
| 3528 | 3549 |
-- |
| 3550 |
-- Name: VIEW _13_list_of_distinct_verbatim_taxa_in_each_plot_in_each_project; Type: COMMENT; Schema: public_validation_plots; Owner: - |
|
| 3551 |
-- |
|
| 3552 |
|
|
| 3553 |
|
|
| 3554 |
|
|
| 3555 |
|
|
| 3556 |
-- |
|
| 3529 | 3557 |
-- Name: _14_count_of_indiv_per_verbatim_taxon_per_plot_in_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
| 3530 | 3558 |
-- |
| 3531 | 3559 |
|
| ... | ... | |
| 3533 | 3561 |
|
| 3534 | 3562 |
|
| 3535 | 3563 |
-- |
| 3564 |
-- Name: VIEW _14_count_of_indiv_per_verbatim_taxon_per_plot_in_each_project; Type: COMMENT; Schema: public_validation_plots; Owner: - |
|
| 3565 |
-- |
|
| 3566 |
|
|
| 3567 |
|
|
| 3568 |
|
|
| 3569 |
|
|
| 3570 |
-- |
|
| 3536 | 3571 |
-- Name: _15_pct_cover_of_each_verb_taxon_in_each_plot_in_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
| 3537 | 3572 |
-- |
| 3538 | 3573 |
|
| ... | ... | |
| 3540 | 3575 |
|
| 3541 | 3576 |
|
| 3542 | 3577 |
-- |
| 3578 |
-- Name: VIEW _15_pct_cover_of_each_verb_taxon_in_each_plot_in_each_project; Type: COMMENT; Schema: public_validation_plots; Owner: - |
|
| 3579 |
-- |
|
| 3580 |
|
|
| 3581 |
|
|
| 3582 |
|
|
| 3583 |
|
|
| 3584 |
-- |
|
| 3543 | 3585 |
-- Name: _17_count_of_subplots_per_plot_for_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
| 3544 | 3586 |
-- |
| 3545 | 3587 |
|
| ... | ... | |
| 3553 | 3595 |
|
| 3554 | 3596 |
|
| 3555 | 3597 |
|
| 3598 |
-- |
|
| 3599 |
-- Name: VIEW _18_list_of_subplots_codes_for_each_plot_for_each_project; Type: COMMENT; Schema: public_validation_plots; Owner: - |
|
| 3600 |
-- |
|
| 3556 | 3601 |
|
| 3557 | 3602 |
|
| 3603 |
|
|
| 3604 |
|
|
| 3605 |
|
|
| 3606 |
|
|
| 3558 | 3607 |
-- |
| 3559 | 3608 |
-- Name: _01_count_records; Type: VIEW; Schema: public_validation_traits; Owner: - |
| 3560 | 3609 |
-- |
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 5285 | 5285 |
|
| 5286 | 5286 |
|
| 5287 | 5287 |
-- |
| 5288 |
-- Name: VIEW _10_count_of_individuals_per_plot_in_each_project; Type: COMMENT; Schema: public_validation_plots; Owner: - |
|
| 5289 |
-- |
|
| 5290 |
|
|
| 5291 |
COMMENT ON VIEW _10_count_of_individuals_per_plot_in_each_project IS 'Method: count taxonObservations |
|
| 5292 |
Note 1: `individuals` should be NULL for plots which use percent cover or line-intercept methods. |
|
| 5293 |
Note 2: Does this method requires that plots have 2-level nesting of subplots within plots? |
|
| 5294 |
'; |
|
| 5295 |
|
|
| 5296 |
|
|
| 5297 |
-- |
|
| 5288 | 5298 |
-- Name: _11_count_of_stems_per_plot_in_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
| 5289 | 5299 |
-- |
| 5290 | 5300 |
|
| ... | ... | |
| 5307 | 5317 |
|
| 5308 | 5318 |
|
| 5309 | 5319 |
-- |
| 5320 |
-- Name: VIEW _11_count_of_stems_per_plot_in_each_project; Type: COMMENT; Schema: public_validation_plots; Owner: - |
|
| 5321 |
-- |
|
| 5322 |
|
|
| 5323 |
COMMENT ON VIEW _11_count_of_stems_per_plot_in_each_project IS 'Method: count records in stemobservation table |
|
| 5324 |
'; |
|
| 5325 |
|
|
| 5326 |
|
|
| 5327 |
-- |
|
| 5310 | 5328 |
-- Name: _12_count_of_verbatim_taxa_per_plot_in_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
| 5311 | 5329 |
-- |
| 5312 | 5330 |
|
| ... | ... | |
| 5328 | 5346 |
|
| 5329 | 5347 |
|
| 5330 | 5348 |
-- |
| 5349 |
-- Name: VIEW _12_count_of_verbatim_taxa_per_plot_in_each_project; Type: COMMENT; Schema: public_validation_plots; Owner: - |
|
| 5350 |
-- |
|
| 5351 |
|
|
| 5352 |
COMMENT ON VIEW _12_count_of_verbatim_taxa_per_plot_in_each_project IS 'Check: join to source db by all columns, returns same number of rows |
|
| 5353 |
Note: Must perform equivalent concatenation of taxonomic field in source db. |
|
| 5354 |
NOT YET READY, NEED TO INCLUDE SUBSPECIES, IF ANY |
|
| 5355 |
'; |
|
| 5356 |
|
|
| 5357 |
|
|
| 5358 |
-- |
|
| 5331 | 5359 |
-- Name: _13_list_of_distinct_verbatim_taxa_in_each_plot_in_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
| 5332 | 5360 |
-- |
| 5333 | 5361 |
|
| ... | ... | |
| 5348 | 5376 |
|
| 5349 | 5377 |
|
| 5350 | 5378 |
-- |
| 5379 |
-- Name: VIEW _13_list_of_distinct_verbatim_taxa_in_each_plot_in_each_project; Type: COMMENT; Schema: public_validation_plots; Owner: - |
|
| 5380 |
-- |
|
| 5381 |
|
|
| 5382 |
COMMENT ON VIEW _13_list_of_distinct_verbatim_taxa_in_each_plot_in_each_project IS 'Note: Must perform equivalent concatenation of taxonomic field in source db. |
|
| 5383 |
'; |
|
| 5384 |
|
|
| 5385 |
|
|
| 5386 |
-- |
|
| 5351 | 5387 |
-- Name: _14_count_of_indiv_per_verbatim_taxon_per_plot_in_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
| 5352 | 5388 |
-- |
| 5353 | 5389 |
|
| ... | ... | |
| 5371 | 5407 |
|
| 5372 | 5408 |
|
| 5373 | 5409 |
-- |
| 5410 |
-- Name: VIEW _14_count_of_indiv_per_verbatim_taxon_per_plot_in_each_project; Type: COMMENT; Schema: public_validation_plots; Owner: - |
|
| 5411 |
-- |
|
| 5412 |
|
|
| 5413 |
COMMENT ON VIEW _14_count_of_indiv_per_verbatim_taxon_per_plot_in_each_project IS 'Note: Must do equivalent concatenation of taxonomic field in source db. |
|
| 5414 |
'; |
|
| 5415 |
|
|
| 5416 |
|
|
| 5417 |
-- |
|
| 5374 | 5418 |
-- Name: _15_pct_cover_of_each_verb_taxon_in_each_plot_in_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
| 5375 | 5419 |
-- |
| 5376 | 5420 |
|
| ... | ... | |
| 5395 | 5439 |
|
| 5396 | 5440 |
|
| 5397 | 5441 |
-- |
| 5442 |
-- Name: VIEW _15_pct_cover_of_each_verb_taxon_in_each_plot_in_each_project; Type: COMMENT; Schema: public_validation_plots; Owner: - |
|
| 5443 |
-- |
|
| 5444 |
|
|
| 5445 |
COMMENT ON VIEW _15_pct_cover_of_each_verb_taxon_in_each_plot_in_each_project IS 'Applies to: aggregate-cover plots only |
|
| 5446 |
Method: sums percent cover in aggregateoccurrence (as recorded in coverindex) |
|
| 5447 |
Check: join to source db by all columns, returns same number of rows |
|
| 5448 |
Note: Must do equivalent concatenation of taxonomic field in source db. |
|
| 5449 |
'; |
|
| 5450 |
|
|
| 5451 |
|
|
| 5452 |
-- |
|
| 5398 | 5453 |
-- Name: _17_count_of_subplots_per_plot_for_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
| 5399 | 5454 |
-- |
| 5400 | 5455 |
|
| ... | ... | |
| 5429 | 5484 |
ORDER BY p.projectname, l.authorlocationcode; |
| 5430 | 5485 |
|
| 5431 | 5486 |
|
| 5487 |
-- |
|
| 5488 |
-- Name: VIEW _18_list_of_subplots_codes_for_each_plot_for_each_project; Type: COMMENT; Schema: public_validation_plots; Owner: - |
|
| 5489 |
-- |
|
| 5490 |
|
|
| 5491 |
COMMENT ON VIEW _18_list_of_subplots_codes_for_each_plot_for_each_project IS 'DOESN''T YET WORK PROPERLY |
|
| 5492 |
'; |
|
| 5493 |
|
|
| 5494 |
|
|
| 5432 | 5495 |
SET search_path = public_validation_traits, pg_catalog; |
| 5433 | 5496 |
|
| 5434 | 5497 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: public_validation_plots: added Brad's notes as comments