Revision 13842
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 3254 | 3254 |
|
| 3255 | 3255 |
|
| 3256 | 3256 |
-- |
| 3257 |
-- Name: COLUMN analytical_stem.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3258 |
-- |
|
| 3259 |
|
|
| 3260 |
|
|
| 3261 |
|
|
| 3262 |
|
|
| 3263 |
-- |
|
| 3264 |
-- Name: COLUMN analytical_stem.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3265 |
-- |
|
| 3266 |
|
|
| 3267 |
|
|
| 3268 |
|
|
| 3269 |
|
|
| 3270 |
-- |
|
| 3271 |
-- Name: COLUMN analytical_stem.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3272 |
-- |
|
| 3273 |
|
|
| 3274 |
|
|
| 3275 |
|
|
| 3276 |
|
|
| 3277 |
-- |
|
| 3278 |
-- Name: COLUMN analytical_stem.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3279 |
-- |
|
| 3280 |
|
|
| 3281 |
|
|
| 3282 |
|
|
| 3283 |
|
|
| 3284 |
-- |
|
| 3285 |
-- Name: COLUMN analytical_stem.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3286 |
-- |
|
| 3287 |
|
|
| 3288 |
|
|
| 3289 |
|
|
| 3290 |
|
|
| 3291 |
-- |
|
| 3292 |
-- Name: COLUMN analytical_stem.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3293 |
-- |
|
| 3294 |
|
|
| 3295 |
|
|
| 3296 |
|
|
| 3297 |
|
|
| 3298 |
-- |
|
| 3299 |
-- Name: COLUMN analytical_stem.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3300 |
-- |
|
| 3301 |
|
|
| 3302 |
|
|
| 3303 |
|
|
| 3304 |
|
|
| 3305 |
-- |
|
| 3306 |
-- Name: COLUMN analytical_stem.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3307 |
-- |
|
| 3308 |
|
|
| 3309 |
|
|
| 3310 |
|
|
| 3311 |
|
|
| 3312 |
-- |
|
| 3313 |
-- Name: COLUMN analytical_stem.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3314 |
-- |
|
| 3315 |
|
|
| 3316 |
|
|
| 3317 |
|
|
| 3318 |
|
|
| 3319 |
-- |
|
| 3320 |
-- Name: COLUMN analytical_stem.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3321 |
-- |
|
| 3322 |
|
|
| 3323 |
|
|
| 3324 |
|
|
| 3325 |
|
|
| 3326 |
-- |
|
| 3327 |
-- Name: COLUMN analytical_stem.geovalid_bien; Type: COMMENT; Schema: public; Owner: - |
|
| 3328 |
-- |
|
| 3329 |
|
|
| 3330 |
|
|
| 3331 |
|
|
| 3332 |
|
|
| 3333 |
-- |
|
| 3334 |
-- Name: COLUMN analytical_stem.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: - |
|
| 3335 |
-- |
|
| 3336 |
|
|
| 3337 |
|
|
| 3338 |
|
|
| 3339 |
|
|
| 3340 |
-- |
|
| 3341 |
-- Name: COLUMN analytical_stem.`projectID__@VegX__.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3342 |
-- |
|
| 3343 |
|
|
| 3344 |
|
|
| 3345 |
|
|
| 3346 |
|
|
| 3347 |
-- |
|
| 3348 |
-- Name: COLUMN analytical_stem.`projectContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3349 |
-- |
|
| 3350 |
|
|
| 3351 |
|
|
| 3352 |
|
|
| 3353 |
|
|
| 3354 |
-- |
|
| 3355 |
-- Name: COLUMN analytical_stem.`locationID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3356 |
-- |
|
| 3357 |
|
|
| 3358 |
|
|
| 3359 |
|
|
| 3360 |
|
|
| 3361 |
-- |
|
| 3362 |
-- Name: COLUMN analytical_stem.`plotName__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3363 |
-- |
|
| 3364 |
|
|
| 3365 |
|
|
| 3366 |
|
|
| 3367 |
|
|
| 3368 |
-- |
|
| 3369 |
-- Name: COLUMN analytical_stem.`subplot__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3370 |
-- |
|
| 3371 |
|
|
| 3372 |
|
|
| 3373 |
|
|
| 3374 |
|
|
| 3375 |
-- |
|
| 3376 |
-- Name: COLUMN analytical_stem.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: - |
|
| 3377 |
-- |
|
| 3378 |
|
|
| 3379 |
|
|
| 3380 |
|
|
| 3381 |
|
|
| 3382 |
-- |
|
| 3383 |
-- Name: COLUMN analytical_stem.`locationevent.locationevent_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3384 |
-- |
|
| 3385 |
|
|
| 3386 |
|
|
| 3387 |
|
|
| 3388 |
|
|
| 3389 |
-- |
|
| 3390 |
-- Name: COLUMN analytical_stem.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3391 |
-- |
|
| 3392 |
|
|
| 3393 |
|
|
| 3394 |
|
|
| 3395 |
|
|
| 3396 |
-- |
|
| 3397 |
-- Name: COLUMN analytical_stem.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3398 |
-- |
|
| 3399 |
|
|
| 3400 |
|
|
| 3401 |
|
|
| 3402 |
|
|
| 3403 |
-- |
|
| 3404 |
-- Name: COLUMN analytical_stem.`slopeAspect[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3405 |
-- |
|
| 3406 |
|
|
| 3407 |
|
|
| 3408 |
|
|
| 3409 |
|
|
| 3410 |
-- |
|
| 3411 |
-- Name: COLUMN analytical_stem.`slopeGradient[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3412 |
-- |
|
| 3413 |
|
|
| 3414 |
|
|
| 3415 |
|
|
| 3416 |
|
|
| 3417 |
-- |
|
| 3418 |
-- Name: COLUMN analytical_stem.`plot.area[_ha]__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3419 |
-- |
|
| 3420 |
|
|
| 3421 |
|
|
| 3422 |
|
|
| 3423 |
|
|
| 3424 |
-- |
|
| 3425 |
-- Name: COLUMN analytical_stem.`samplingProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3426 |
-- |
|
| 3427 |
|
|
| 3428 |
|
|
| 3429 |
|
|
| 3430 |
|
|
| 3431 |
-- |
|
| 3432 |
-- Name: COLUMN analytical_stem.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3433 |
-- |
|
| 3434 |
|
|
| 3435 |
|
|
| 3436 |
|
|
| 3437 |
|
|
| 3438 |
-- |
|
| 3439 |
-- Name: COLUMN analytical_stem.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3440 |
-- |
|
| 3441 |
|
|
| 3442 |
|
|
| 3443 |
|
|
| 3444 |
|
|
| 3445 |
-- |
|
| 3446 |
-- Name: COLUMN analytical_stem.`stratumName__@VegX__.stratum@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3447 |
-- |
|
| 3448 |
|
|
| 3449 |
|
|
| 3450 |
|
|
| 3451 |
|
|
| 3452 |
-- |
|
| 3453 |
-- Name: COLUMN analytical_stem.`communityConcept.name__@VegX__.communityDet@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3454 |
-- |
|
| 3455 |
|
|
| 3456 |
|
|
| 3457 |
|
|
| 3458 |
|
|
| 3459 |
-- |
|
| 3460 |
-- Name: COLUMN analytical_stem.`observationContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3461 |
-- |
|
| 3462 |
|
|
| 3463 |
|
|
| 3464 |
|
|
| 3465 |
|
|
| 3466 |
-- |
|
| 3467 |
-- Name: COLUMN analytical_stem.`[custodial_]institutionCode[s]__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3468 |
-- |
|
| 3469 |
|
|
| 3470 |
|
|
| 3471 |
|
|
| 3472 |
|
|
| 3473 |
-- |
|
| 3474 |
-- Name: COLUMN analytical_stem.`collectionCode__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3475 |
-- |
|
| 3476 |
|
|
| 3477 |
|
|
| 3478 |
|
|
| 3479 |
|
|
| 3480 |
-- |
|
| 3481 |
-- Name: COLUMN analytical_stem.`catalogNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3482 |
-- |
|
| 3483 |
|
|
| 3484 |
|
|
| 3485 |
|
|
| 3486 |
|
|
| 3487 |
-- |
|
| 3488 |
-- Name: COLUMN analytical_stem.`occurrenceID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3489 |
-- |
|
| 3490 |
|
|
| 3491 |
|
|
| 3492 |
|
|
| 3493 |
|
|
| 3494 |
-- |
|
| 3495 |
-- Name: COLUMN analytical_stem.`recordedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3496 |
-- |
|
| 3497 |
|
|
| 3498 |
|
|
| 3499 |
|
|
| 3500 |
|
|
| 3501 |
-- |
|
| 3502 |
-- Name: COLUMN analytical_stem.`recordNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3503 |
-- |
|
| 3504 |
|
|
| 3505 |
|
|
| 3506 |
|
|
| 3507 |
|
|
| 3508 |
-- |
|
| 3509 |
-- Name: COLUMN analytical_stem.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3510 |
-- |
|
| 3511 |
|
|
| 3512 |
|
|
| 3513 |
|
|
| 3514 |
|
|
| 3515 |
-- |
|
| 3516 |
-- Name: COLUMN analytical_stem.`[verbatim_]family__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3517 |
-- |
|
| 3518 |
|
|
| 3519 |
|
|
| 3520 |
|
|
| 3521 |
|
|
| 3522 |
-- |
|
| 3523 |
-- Name: COLUMN analytical_stem.`[verbatim_]scientificName__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3524 |
-- |
|
| 3525 |
|
|
| 3526 |
|
|
| 3527 |
|
|
| 3528 |
|
|
| 3529 |
-- |
|
| 3530 |
-- Name: COLUMN analytical_stem.`identifiedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3531 |
-- |
|
| 3532 |
|
|
| 3533 |
|
|
| 3534 |
|
|
| 3535 |
|
|
| 3536 |
-- |
|
| 3537 |
-- Name: COLUMN analytical_stem.`dateIdentified__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3538 |
-- |
|
| 3539 |
|
|
| 3540 |
|
|
| 3541 |
|
|
| 3542 |
|
|
| 3543 |
-- |
|
| 3544 |
-- Name: COLUMN analytical_stem.`identificationRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3545 |
-- |
|
| 3546 |
|
|
| 3547 |
|
|
| 3548 |
|
|
| 3549 |
|
|
| 3550 |
-- |
|
| 3551 |
-- Name: COLUMN analytical_stem.`Family_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3552 |
-- |
|
| 3553 |
|
|
| 3554 |
|
|
| 3555 |
|
|
| 3556 |
|
|
| 3557 |
-- |
|
| 3558 |
-- Name: COLUMN analytical_stem.`Name_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3559 |
-- |
|
| 3560 |
|
|
| 3561 |
|
|
| 3562 |
|
|
| 3563 |
|
|
| 3564 |
-- |
|
| 3565 |
-- Name: COLUMN analytical_stem.`Name_matched_author__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3566 |
-- |
|
| 3567 |
|
|
| 3568 |
|
|
| 3569 |
|
|
| 3570 |
|
|
| 3571 |
-- |
|
| 3572 |
-- Name: COLUMN analytical_stem.`[higher_plant_group~]higherClassification__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3573 |
-- |
|
| 3574 |
|
|
| 3575 |
|
|
| 3576 |
|
|
| 3577 |
|
|
| 3578 |
-- |
|
| 3579 |
-- Name: COLUMN analytical_stem.`taxonomicStatus__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3580 |
-- |
|
| 3581 |
|
|
| 3582 |
|
|
| 3583 |
|
|
| 3584 |
|
|
| 3585 |
-- |
|
| 3586 |
-- Name: COLUMN analytical_stem.scrubbed_family; Type: COMMENT; Schema: public; Owner: - |
|
| 3587 |
-- |
|
| 3588 |
|
|
| 3589 |
|
|
| 3590 |
|
|
| 3591 |
|
|
| 3592 |
-- |
|
| 3593 |
-- Name: COLUMN analytical_stem.scrubbed_genus; Type: COMMENT; Schema: public; Owner: - |
|
| 3594 |
-- |
|
| 3595 |
|
|
| 3596 |
|
|
| 3597 |
|
|
| 3598 |
|
|
| 3599 |
-- |
|
| 3600 |
-- Name: COLUMN analytical_stem.scrubbed_specific_epithet; Type: COMMENT; Schema: public; Owner: - |
|
| 3601 |
-- |
|
| 3602 |
|
|
| 3603 |
|
|
| 3604 |
|
|
| 3605 |
|
|
| 3606 |
-- |
|
| 3607 |
-- Name: COLUMN analytical_stem.scrubbed_species_binomial; Type: COMMENT; Schema: public; Owner: - |
|
| 3608 |
-- |
|
| 3609 |
|
|
| 3610 |
|
|
| 3611 |
|
|
| 3612 |
|
|
| 3613 |
-- |
|
| 3614 |
-- Name: COLUMN analytical_stem.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: - |
|
| 3615 |
-- |
|
| 3616 |
|
|
| 3617 |
|
|
| 3618 |
|
|
| 3619 |
|
|
| 3620 |
-- |
|
| 3621 |
-- Name: COLUMN analytical_stem.scrubbed_author; Type: COMMENT; Schema: public; Owner: - |
|
| 3622 |
-- |
|
| 3623 |
|
|
| 3624 |
|
|
| 3625 |
|
|
| 3626 |
|
|
| 3627 |
-- |
|
| 3628 |
-- Name: COLUMN analytical_stem.scrubbed_taxon_name_with_author; Type: COMMENT; Schema: public; Owner: - |
|
| 3629 |
-- |
|
| 3630 |
|
|
| 3631 |
|
|
| 3632 |
|
|
| 3633 |
|
|
| 3634 |
-- |
|
| 3635 |
-- Name: COLUMN analytical_stem.`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3636 |
-- |
|
| 3637 |
|
|
| 3638 |
|
|
| 3639 |
|
|
| 3640 |
|
|
| 3641 |
-- |
|
| 3642 |
-- Name: COLUMN analytical_stem.`[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3643 |
-- |
|
| 3644 |
|
|
| 3645 |
|
|
| 3646 |
|
|
| 3647 |
|
|
| 3648 |
-- |
|
| 3649 |
-- Name: COLUMN analytical_stem.`reproductiveCondition__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3650 |
-- |
|
| 3651 |
|
|
| 3652 |
|
|
| 3653 |
|
|
| 3654 |
|
|
| 3655 |
-- |
|
| 3656 |
-- Name: COLUMN analytical_stem.threatened_bien; Type: COMMENT; Schema: public; Owner: - |
|
| 3657 |
-- |
|
| 3658 |
|
|
| 3659 |
|
|
| 3660 |
|
|
| 3661 |
|
|
| 3662 |
-- |
|
| 3663 |
-- Name: COLUMN analytical_stem.cultivated_bien; Type: COMMENT; Schema: public; Owner: - |
|
| 3664 |
-- |
|
| 3665 |
|
|
| 3666 |
|
|
| 3667 |
|
|
| 3668 |
|
|
| 3669 |
-- |
|
| 3670 |
-- Name: COLUMN analytical_stem.`cultivatedBasis_bien`; Type: COMMENT; Schema: public; Owner: - |
|
| 3671 |
-- |
|
| 3672 |
|
|
| 3673 |
|
|
| 3674 |
|
|
| 3675 |
|
|
| 3676 |
-- |
|
| 3677 |
-- Name: COLUMN analytical_stem.`occurrenceRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3678 |
-- |
|
| 3679 |
|
|
| 3680 |
|
|
| 3681 |
|
|
| 3682 |
|
|
| 3683 |
-- |
|
| 3684 |
-- Name: COLUMN analytical_stem.`coverPercent__@VegX__.attribute.ordinal@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3685 |
-- |
|
| 3686 |
|
|
| 3687 |
|
|
| 3688 |
|
|
| 3689 |
|
|
| 3690 |
-- |
|
| 3691 |
-- Name: COLUMN analytical_stem.`stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3692 |
-- |
|
| 3693 |
|
|
| 3694 |
|
|
| 3695 |
|
|
| 3696 |
|
|
| 3697 |
-- |
|
| 3698 |
-- Name: COLUMN analytical_stem.`stemHeight[_m]__@VegBank__.stemCount@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3699 |
-- |
|
| 3700 |
|
|
| 3701 |
|
|
| 3702 |
|
|
| 3703 |
|
|
| 3704 |
-- |
|
| 3705 |
-- Name: COLUMN analytical_stem.`[tag=]identificationLabel__@VegX__.individual@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3706 |
-- |
|
| 3707 |
|
|
| 3708 |
|
|
| 3709 |
|
|
| 3710 |
|
|
| 3711 |
-- |
|
| 3712 |
-- Name: COLUMN analytical_stem.`relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3713 |
-- |
|
| 3714 |
|
|
| 3715 |
|
|
| 3716 |
|
|
| 3717 |
|
|
| 3718 |
-- |
|
| 3719 |
-- Name: COLUMN analytical_stem.`relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3720 |
-- |
|
| 3721 |
|
|
| 3722 |
|
|
| 3723 |
|
|
| 3724 |
|
|
| 3725 |
-- |
|
| 3726 |
-- Name: COLUMN analytical_stem.`taxonObservation[.id]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3727 |
-- |
|
| 3728 |
|
|
| 3729 |
|
|
| 3730 |
|
|
| 3731 |
|
|
| 3732 |
-- |
|
| 3733 |
-- Name: COLUMN analytical_stem.`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3734 |
-- |
|
| 3735 |
|
|
| 3736 |
|
|
| 3737 |
|
|
| 3738 |
|
|
| 3739 |
-- |
|
| 3740 |
-- Name: COLUMN analytical_stem.`aggregateOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3741 |
-- |
|
| 3742 |
|
|
| 3743 |
|
|
| 3744 |
|
|
| 3745 |
|
|
| 3746 |
-- |
|
| 3747 |
-- Name: COLUMN analytical_stem.`individualOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3748 |
-- |
|
| 3749 |
|
|
| 3750 |
|
|
| 3751 |
|
|
| 3752 |
|
|
| 3753 |
-- |
|
| 3754 |
-- Name: COLUMN analytical_stem.`individualID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3755 |
-- |
|
| 3756 |
|
|
| 3757 |
|
|
| 3758 |
|
|
| 3759 |
|
|
| 3760 |
-- |
|
| 3761 |
-- Name: COLUMN analytical_stem.`individualCount__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3762 |
-- |
|
| 3763 |
|
|
| 3764 |
|
|
| 3765 |
|
|
| 3766 |
|
|
| 3767 |
-- |
|
| 3768 |
-- Name: COLUMN analytical_stem.`stemCode__@VegBank__.stemLocation@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 3769 |
-- |
|
| 3770 |
|
|
| 3771 |
|
|
| 3772 |
|
|
| 3773 |
|
|
| 3774 |
-- |
|
| 3257 | 3775 |
-- Name: 2013-10-18.Brian_Enquist.Canadensys; Type: VIEW; Schema: public; Owner: - |
| 3258 | 3776 |
-- |
| 3259 | 3777 |
|
| ... | ... | |
| 3397 | 3915 |
|
| 3398 | 3916 |
|
| 3399 | 3917 |
-- |
| 3400 |
-- Name: analytical_stem_taxon_occurrence__pkey_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 3918 |
-- Name: analytical_stem_TAXONOBSERVATION_ID__@VegBank__.taxonObserv_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 3401 | 3919 |
-- |
| 3402 | 3920 |
|
| 3403 | 3921 |
|
| 3404 | 3922 |
|
| 3405 | 3923 |
|
| 3406 | 3924 |
-- |
| 3407 |
-- Name: analytical_stem_taxon_occurrence__pkey_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 3925 |
-- Name: analytical_stem_TAXONOBSERVATION_ID__@VegBank__.taxonObserv_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 3408 | 3926 |
-- |
| 3409 | 3927 |
|
| 3410 | 3928 |
|
| ... | ... | |
| 7210 | 7728 |
|
| 7211 | 7729 |
|
| 7212 | 7730 |
-- |
| 7213 |
-- Name: analytical_stem_taxon_occurrence__pkey_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 7731 |
-- Name: analytical_stem_TAXONOBSERVATION_ID__@VegBank__.taxonObserv_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 7214 | 7732 |
-- |
| 7215 | 7733 |
|
| 7216 | 7734 |
|
| ... | ... | |
| 10565 | 11083 |
|
| 10566 | 11084 |
|
| 10567 | 11085 |
-- |
| 10568 |
-- Name: analytical_stem_datasource_occurrenceID_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 11086 |
-- Name: analytical_stem_datasource__@Brad__.identifier_examples@ve_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 10569 | 11087 |
-- |
| 10570 | 11088 |
|
| 10571 |
CREATE INDEX `analytical_stem_datasource_occurrenceID_idx` ON analytical_stem (`datasource__@Brad__.identifier_examples@vegpath.org`, `occurrenceID__@DwC__@vegpath.org`);
|
|
| 11089 |
CREATE INDEX `analytical_stem_datasource__@Brad__.identifier_examples@ve_idx1` ON analytical_stem (`datasource__@Brad__.identifier_examples@vegpath.org`, `[custodial_]institutionCode[s]__@DwC__@vegpath.org`, `collectionCode__@DwC__@vegpath.org`, `catalogNumber__@DwC__@vegpath.org`);
|
|
| 10572 | 11090 |
|
| 10573 | 11091 |
|
| 10574 | 11092 |
-- |
| 10575 |
-- Name: analytical_stem_datasource_projectID_locationID_eventDate_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 11093 |
-- Name: analytical_stem_datasource__@Brad__.identifier_examples@ve_idx2; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 10576 | 11094 |
-- |
| 10577 | 11095 |
|
| 10578 |
CREATE INDEX `analytical_stem_datasource_projectID_locationID_eventDate_idx` ON analytical_stem (`datasource__@Brad__.identifier_examples@vegpath.org`, `projectID__@VegX__.plotObservation@vegpath.org`, `locationID__@DwC__@vegpath.org`, `eventDate__@DwC__@vegpath.org`);
|
|
| 11096 |
CREATE INDEX `analytical_stem_datasource__@Brad__.identifier_examples@ve_idx2` ON analytical_stem (`datasource__@Brad__.identifier_examples@vegpath.org`, `projectID__@VegX__.plotObservation@vegpath.org`, `locationID__@DwC__@vegpath.org`, `eventDate__@DwC__@vegpath.org`);
|
|
| 10579 | 11097 |
|
| 10580 | 11098 |
|
| 10581 | 11099 |
-- |
| 10582 |
-- Name: analytical_stem_datasource_specimenHolderInstitutions_colle_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 11100 |
-- Name: analytical_stem_datasource__@Brad__.identifier_examples@veg_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 10583 | 11101 |
-- |
| 10584 | 11102 |
|
| 10585 |
CREATE INDEX `analytical_stem_datasource_specimenHolderInstitutions_colle_idx` ON analytical_stem (`datasource__@Brad__.identifier_examples@vegpath.org`, `[custodial_]institutionCode[s]__@DwC__@vegpath.org`, `collectionCode__@DwC__@vegpath.org`, `catalogNumber__@DwC__@vegpath.org`);
|
|
| 11103 |
CREATE INDEX `analytical_stem_datasource__@Brad__.identifier_examples@veg_idx` ON analytical_stem (`datasource__@Brad__.identifier_examples@vegpath.org`, `occurrenceID__@DwC__@vegpath.org`);
|
|
| 10586 | 11104 |
|
| 10587 | 11105 |
|
| 10588 | 11106 |
-- |
| 10589 |
-- Name: analytical_stem_scrubbed_morphospecies_binomial_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 11107 |
-- Name: analytical_stem_speciesBinomialWithMorphospecies__@VegCore__idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 10590 | 11108 |
-- |
| 10591 | 11109 |
|
| 10592 |
CREATE INDEX analytical_stem_scrubbed_morphospecies_binomial_idx ON analytical_stem (`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org`);
|
|
| 11110 |
CREATE INDEX `analytical_stem_speciesBinomialWithMorphospecies__@VegCore__idx` ON analytical_stem (`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org`);
|
|
| 10593 | 11111 |
|
| 10594 | 11112 |
|
| 10595 | 11113 |
-- |
| trunk/schemas/public_.sql | ||
|---|---|---|
| 5454 | 5454 |
|
| 5455 | 5455 |
|
| 5456 | 5456 |
-- |
| 5457 |
-- Name: COLUMN analytical_stem."datasource__@Brad__.identifier_examples@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5458 |
-- |
|
| 5459 |
|
|
| 5460 |
COMMENT ON COLUMN analytical_stem."datasource__@Brad__.identifier_examples@vegpath.org" IS 'variant of DwC term'; |
|
| 5461 |
|
|
| 5462 |
|
|
| 5463 |
-- |
|
| 5464 |
-- Name: COLUMN analytical_stem."country__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5465 |
-- |
|
| 5466 |
|
|
| 5467 |
COMMENT ON COLUMN analytical_stem."country__@DwC__@vegpath.org" IS 'geoscrub.geoscrub_output.acceptedCountry@VegBIEN@vegpath.org; |
|
| 5468 |
"The name of the country or major administrative unit in which the Location occurs"'; |
|
| 5469 |
|
|
| 5470 |
|
|
| 5471 |
-- |
|
| 5472 |
-- Name: COLUMN analytical_stem."stateProvince__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5473 |
-- |
|
| 5474 |
|
|
| 5475 |
COMMENT ON COLUMN analytical_stem."stateProvince__@DwC__@vegpath.org" IS '"The name of the next smaller administrative region than country (state, province, canton, department, region, etc.) in which the Location occurs"'; |
|
| 5476 |
|
|
| 5477 |
|
|
| 5478 |
-- |
|
| 5479 |
-- Name: COLUMN analytical_stem."county__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5480 |
-- |
|
| 5481 |
|
|
| 5482 |
COMMENT ON COLUMN analytical_stem."county__@DwC__@vegpath.org" IS '"The full, unabbreviated name of the next smaller administrative region than stateProvince (county, shire, department, etc.) in which the Location occurs"'; |
|
| 5483 |
|
|
| 5484 |
|
|
| 5485 |
-- |
|
| 5486 |
-- Name: COLUMN analytical_stem."locality__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5487 |
-- |
|
| 5488 |
|
|
| 5489 |
COMMENT ON COLUMN analytical_stem."locality__@DwC__@vegpath.org" IS '"The specific description of the place"'; |
|
| 5490 |
|
|
| 5491 |
|
|
| 5492 |
-- |
|
| 5493 |
-- Name: COLUMN analytical_stem."decimalLatitude__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5494 |
-- |
|
| 5495 |
|
|
| 5496 |
COMMENT ON COLUMN analytical_stem."decimalLatitude__@DwC__@vegpath.org" IS '"The geographic latitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"'; |
|
| 5497 |
|
|
| 5498 |
|
|
| 5499 |
-- |
|
| 5500 |
-- Name: COLUMN analytical_stem."decimalLongitude__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5501 |
-- |
|
| 5502 |
|
|
| 5503 |
COMMENT ON COLUMN analytical_stem."decimalLongitude__@DwC__@vegpath.org" IS '"The geographic longitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"'; |
|
| 5504 |
|
|
| 5505 |
|
|
| 5506 |
-- |
|
| 5507 |
-- Name: COLUMN analytical_stem."coordinateUncertaintyInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5508 |
-- |
|
| 5509 |
|
|
| 5510 |
COMMENT ON COLUMN analytical_stem."coordinateUncertaintyInMeters__@DwC__@vegpath.org" IS '"The horizontal distance (in meters) from the given decimalLatitude and decimalLongitude describing the smallest circle containing the whole of the Location"'; |
|
| 5511 |
|
|
| 5512 |
|
|
| 5513 |
-- |
|
| 5514 |
-- Name: COLUMN analytical_stem."georeferenceSources__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5515 |
-- |
|
| 5516 |
|
|
| 5517 |
COMMENT ON COLUMN analytical_stem."georeferenceSources__@DwC__@vegpath.org" IS 'derived column'; |
|
| 5518 |
|
|
| 5519 |
|
|
| 5520 |
-- |
|
| 5521 |
-- Name: COLUMN analytical_stem."georeferenceProtocol__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5522 |
-- |
|
| 5523 |
|
|
| 5524 |
COMMENT ON COLUMN analytical_stem."georeferenceProtocol__@DwC__@vegpath.org" IS 'derived column'; |
|
| 5525 |
|
|
| 5526 |
|
|
| 5527 |
-- |
|
| 5528 |
-- Name: COLUMN analytical_stem.geovalid_bien; Type: COMMENT; Schema: public; Owner: - |
|
| 5529 |
-- |
|
| 5530 |
|
|
| 5531 |
COMMENT ON COLUMN analytical_stem.geovalid_bien IS 'derived column'; |
|
| 5532 |
|
|
| 5533 |
|
|
| 5534 |
-- |
|
| 5535 |
-- Name: COLUMN analytical_stem."isNewWorld_bien"; Type: COMMENT; Schema: public; Owner: - |
|
| 5536 |
-- |
|
| 5537 |
|
|
| 5538 |
COMMENT ON COLUMN analytical_stem."isNewWorld_bien" IS 'derived column'; |
|
| 5539 |
|
|
| 5540 |
|
|
| 5541 |
-- |
|
| 5542 |
-- Name: COLUMN analytical_stem."projectID__@VegX__.plotObservation@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5543 |
-- |
|
| 5544 |
|
|
| 5545 |
COMMENT ON COLUMN analytical_stem."projectID__@VegX__.plotObservation@vegpath.org" IS 'project.sourceaccessioncode@VegBIEN.public@vegpath.org; |
|
| 5546 |
"A reference to a specific ''project''"'; |
|
| 5547 |
|
|
| 5548 |
|
|
| 5549 |
-- |
|
| 5550 |
-- Name: COLUMN analytical_stem."projectContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5551 |
-- |
|
| 5552 |
|
|
| 5553 |
COMMENT ON COLUMN analytical_stem."projectContributor[s]__@VegBank__@vegpath.org" IS 'variant of VegBank term'; |
|
| 5554 |
|
|
| 5555 |
|
|
| 5556 |
-- |
|
| 5557 |
-- Name: COLUMN analytical_stem."locationID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5558 |
-- |
|
| 5559 |
|
|
| 5560 |
COMMENT ON COLUMN analytical_stem."locationID__@DwC__@vegpath.org" IS '"An identifier for the set of location information (data associated with dcterms:Location)"'; |
|
| 5561 |
|
|
| 5562 |
|
|
| 5563 |
-- |
|
| 5564 |
-- Name: COLUMN analytical_stem."plotName__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5565 |
-- |
|
| 5566 |
|
|
| 5567 |
COMMENT ON COLUMN analytical_stem."plotName__@VegX__.plot@vegpath.org" IS '"Name or label for a plot"'; |
|
| 5568 |
|
|
| 5569 |
|
|
| 5570 |
-- |
|
| 5571 |
-- Name: COLUMN analytical_stem."subplot__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5572 |
-- |
|
| 5573 |
|
|
| 5574 |
COMMENT ON COLUMN analytical_stem."subplot__@SALVIAS__.Plot_data@vegpath.org" IS 'location.authorlocationcode@VegBIEN.public@vegpath.org; |
|
| 5575 |
"Code for subplot, line, or any other subsample or subdivision of plot"'; |
|
| 5576 |
|
|
| 5577 |
|
|
| 5578 |
-- |
|
| 5579 |
-- Name: COLUMN analytical_stem.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: - |
|
| 5580 |
-- |
|
| 5581 |
|
|
| 5582 |
COMMENT ON COLUMN analytical_stem.location__cultivated__bien IS 'variant of DwC term'; |
|
| 5583 |
|
|
| 5584 |
|
|
| 5585 |
-- |
|
| 5586 |
-- Name: COLUMN analytical_stem."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5587 |
-- |
|
| 5588 |
|
|
| 5589 |
COMMENT ON COLUMN analytical_stem."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org" IS 'locationevent.locationevent_id@VegBIEN.public@vegpath.org; |
|
| 5590 |
autogenerated ID for locationevent'; |
|
| 5591 |
|
|
| 5592 |
|
|
| 5593 |
-- |
|
| 5594 |
-- Name: COLUMN analytical_stem."eventDate__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5595 |
-- |
|
| 5596 |
|
|
| 5597 |
COMMENT ON COLUMN analytical_stem."eventDate__@DwC__@vegpath.org" IS '"The date-time or interval during which an Event occurred. For occurrences, this is the date-time when the event was recorded."'; |
|
| 5598 |
|
|
| 5599 |
|
|
| 5600 |
-- |
|
| 5601 |
-- Name: COLUMN analytical_stem."(-minimum-)ElevationInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5602 |
-- |
|
| 5603 |
|
|
| 5604 |
COMMENT ON COLUMN analytical_stem."(-minimum-)ElevationInMeters__@DwC__@vegpath.org" IS 'variant of DwC term'; |
|
| 5605 |
|
|
| 5606 |
|
|
| 5607 |
-- |
|
| 5608 |
-- Name: COLUMN analytical_stem."slopeAspect[_deg]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5609 |
-- |
|
| 5610 |
|
|
| 5611 |
COMMENT ON COLUMN analytical_stem."slopeAspect[_deg]__@VegX__.plot@vegpath.org" IS '"Representative azimuth of slope gradient (0-360 degrees) or as a cardinal direction (e.g. N, S, NE)"'; |
|
| 5612 |
|
|
| 5613 |
|
|
| 5614 |
-- |
|
| 5615 |
-- Name: COLUMN analytical_stem."slopeGradient[_deg]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5616 |
-- |
|
| 5617 |
|
|
| 5618 |
COMMENT ON COLUMN analytical_stem."slopeGradient[_deg]__@VegX__.plot@vegpath.org" IS '"Representative inclination of slope in degrees"'; |
|
| 5619 |
|
|
| 5620 |
|
|
| 5621 |
-- |
|
| 5622 |
-- Name: COLUMN analytical_stem."plot.area[_ha]__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5623 |
-- |
|
| 5624 |
|
|
| 5625 |
COMMENT ON COLUMN analytical_stem."plot.area[_ha]__@VegX__@vegpath.org" IS 'variant of VegX term'; |
|
| 5626 |
|
|
| 5627 |
|
|
| 5628 |
-- |
|
| 5629 |
-- Name: COLUMN analytical_stem."samplingProtocol__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5630 |
-- |
|
| 5631 |
|
|
| 5632 |
COMMENT ON COLUMN analytical_stem."samplingProtocol__@DwC__@vegpath.org" IS '"The name of, reference to, or description of the method or protocol used during an Event"'; |
|
| 5633 |
|
|
| 5634 |
|
|
| 5635 |
-- |
|
| 5636 |
-- Name: COLUMN analytical_stem."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5637 |
-- |
|
| 5638 |
|
|
| 5639 |
COMMENT ON COLUMN analytical_stem."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org" IS 'variant of VegX term'; |
|
| 5640 |
|
|
| 5641 |
|
|
| 5642 |
-- |
|
| 5643 |
-- Name: COLUMN analytical_stem."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5644 |
-- |
|
| 5645 |
|
|
| 5646 |
COMMENT ON COLUMN analytical_stem."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org" IS 'variant of VegX term'; |
|
| 5647 |
|
|
| 5648 |
|
|
| 5649 |
-- |
|
| 5650 |
-- Name: COLUMN analytical_stem."stratumName__@VegX__.stratum@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5651 |
-- |
|
| 5652 |
|
|
| 5653 |
COMMENT ON COLUMN analytical_stem."stratumName__@VegX__.stratum@vegpath.org" IS 'from VegX, renamed'; |
|
| 5654 |
|
|
| 5655 |
|
|
| 5656 |
-- |
|
| 5657 |
-- Name: COLUMN analytical_stem."communityConcept.name__@VegX__.communityDet@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5658 |
-- |
|
| 5659 |
|
|
| 5660 |
COMMENT ON COLUMN analytical_stem."communityConcept.name__@VegX__.communityDet@vegpath.org" IS 'variant of VegX term'; |
|
| 5661 |
|
|
| 5662 |
|
|
| 5663 |
-- |
|
| 5664 |
-- Name: COLUMN analytical_stem."observationContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5665 |
-- |
|
| 5666 |
|
|
| 5667 |
COMMENT ON COLUMN analytical_stem."observationContributor[s]__@VegBank__@vegpath.org" IS 'variant of VegBank term'; |
|
| 5668 |
|
|
| 5669 |
|
|
| 5670 |
-- |
|
| 5671 |
-- Name: COLUMN analytical_stem."[custodial_]institutionCode[s]__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5672 |
-- |
|
| 5673 |
|
|
| 5674 |
COMMENT ON COLUMN analytical_stem."[custodial_]institutionCode[s]__@DwC__@vegpath.org" IS 'from DwC, renamed'; |
|
| 5675 |
|
|
| 5676 |
|
|
| 5677 |
-- |
|
| 5678 |
-- Name: COLUMN analytical_stem."collectionCode__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5679 |
-- |
|
| 5680 |
|
|
| 5681 |
COMMENT ON COLUMN analytical_stem."collectionCode__@DwC__@vegpath.org" IS 'from DwC, renamed'; |
|
| 5682 |
|
|
| 5683 |
|
|
| 5684 |
-- |
|
| 5685 |
-- Name: COLUMN analytical_stem."catalogNumber__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5686 |
-- |
|
| 5687 |
|
|
| 5688 |
COMMENT ON COLUMN analytical_stem."catalogNumber__@DwC__@vegpath.org" IS 'variant of DwC term'; |
|
| 5689 |
|
|
| 5690 |
|
|
| 5691 |
-- |
|
| 5692 |
-- Name: COLUMN analytical_stem."occurrenceID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5693 |
-- |
|
| 5694 |
|
|
| 5695 |
COMMENT ON COLUMN analytical_stem."occurrenceID__@DwC__@vegpath.org" IS '"An identifier for the Occurrence (as opposed to a particular digital record of the occurrence). In the absence of a persistent global unique identifier, construct one from a combination of identifiers in the record that will most closely make the occurrenceID globally unique."'; |
|
| 5696 |
|
|
| 5697 |
|
|
| 5698 |
-- |
|
| 5699 |
-- Name: COLUMN analytical_stem."recordedBy__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5700 |
-- |
|
| 5701 |
|
|
| 5702 |
COMMENT ON COLUMN analytical_stem."recordedBy__@DwC__@vegpath.org" IS '"A list (concatenated and separated) of names of people, groups, or organizations responsible for recording the original Occurrence. The primary collector or observer, especially one who applies a personal identifier (recordNumber), should be listed first."'; |
|
| 5703 |
|
|
| 5704 |
|
|
| 5705 |
-- |
|
| 5706 |
-- Name: COLUMN analytical_stem."recordNumber__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5707 |
-- |
|
| 5708 |
|
|
| 5709 |
COMMENT ON COLUMN analytical_stem."recordNumber__@DwC__@vegpath.org" IS '"An identifier given to the Occurrence at the time it was recorded. Often serves as a link between field notes and an Occurrence record, such as a specimen collector''s number."'; |
|
| 5710 |
|
|
| 5711 |
|
|
| 5712 |
-- |
|
| 5713 |
-- Name: COLUMN analytical_stem."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5714 |
-- |
|
| 5715 |
|
|
| 5716 |
COMMENT ON COLUMN analytical_stem."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org" IS 'variant of DwC term'; |
|
| 5717 |
|
|
| 5718 |
|
|
| 5719 |
-- |
|
| 5720 |
-- Name: COLUMN analytical_stem."[verbatim_]family__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5721 |
-- |
|
| 5722 |
|
|
| 5723 |
COMMENT ON COLUMN analytical_stem."[verbatim_]family__@DwC__@vegpath.org" IS 'variant of DwC term'; |
|
| 5724 |
|
|
| 5725 |
|
|
| 5726 |
-- |
|
| 5727 |
-- Name: COLUMN analytical_stem."[verbatim_]scientificName__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5728 |
-- |
|
| 5729 |
|
|
| 5730 |
COMMENT ON COLUMN analytical_stem."[verbatim_]scientificName__@DwC__@vegpath.org" IS 'variant of DwC term'; |
|
| 5731 |
|
|
| 5732 |
|
|
| 5733 |
-- |
|
| 5734 |
-- Name: COLUMN analytical_stem."identifiedBy__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5735 |
-- |
|
| 5736 |
|
|
| 5737 |
COMMENT ON COLUMN analytical_stem."identifiedBy__@DwC__@vegpath.org" IS '"A list (concatenated and separated) of names of people, groups, or organizations who assigned the Taxon to the subject"'; |
|
| 5738 |
|
|
| 5739 |
|
|
| 5740 |
-- |
|
| 5741 |
-- Name: COLUMN analytical_stem."dateIdentified__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5742 |
-- |
|
| 5743 |
|
|
| 5744 |
COMMENT ON COLUMN analytical_stem."dateIdentified__@DwC__@vegpath.org" IS '"The date on which the subject was identified as representing the Taxon"'; |
|
| 5745 |
|
|
| 5746 |
|
|
| 5747 |
-- |
|
| 5748 |
-- Name: COLUMN analytical_stem."identificationRemarks__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5749 |
-- |
|
| 5750 |
|
|
| 5751 |
COMMENT ON COLUMN analytical_stem."identificationRemarks__@DwC__@vegpath.org" IS '"Comments or notes about the Identification"'; |
|
| 5752 |
|
|
| 5753 |
|
|
| 5754 |
-- |
|
| 5755 |
-- Name: COLUMN analytical_stem."Family_matched__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5756 |
-- |
|
| 5757 |
|
|
| 5758 |
COMMENT ON COLUMN analytical_stem."Family_matched__@TNRS__@vegpath.org" IS 'TNRS.taxon_scrub.matchedFamily@VegBIEN.public@vegpath.org; |
|
| 5759 |
"The closest matching family in the TNRS database to the family submitted"'; |
|
| 5760 |
|
|
| 5761 |
|
|
| 5762 |
-- |
|
| 5763 |
-- Name: COLUMN analytical_stem."Name_matched__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5764 |
-- |
|
| 5765 |
|
|
| 5766 |
COMMENT ON COLUMN analytical_stem."Name_matched__@TNRS__@vegpath.org" IS 'from TNRS, renamed'; |
|
| 5767 |
|
|
| 5768 |
|
|
| 5769 |
-- |
|
| 5770 |
-- Name: COLUMN analytical_stem."Name_matched_author__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5771 |
-- |
|
| 5772 |
|
|
| 5773 |
COMMENT ON COLUMN analytical_stem."Name_matched_author__@TNRS__@vegpath.org" IS 'from TNRS, renamed'; |
|
| 5774 |
|
|
| 5775 |
|
|
| 5776 |
-- |
|
| 5777 |
-- Name: COLUMN analytical_stem."[higher_plant_group~]higherClassification__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5778 |
-- |
|
| 5779 |
|
|
| 5780 |
COMMENT ON COLUMN analytical_stem."[higher_plant_group~]higherClassification__@DwC__@vegpath.org" IS 'derived column'; |
|
| 5781 |
|
|
| 5782 |
|
|
| 5783 |
-- |
|
| 5784 |
-- Name: COLUMN analytical_stem."taxonomicStatus__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5785 |
-- |
|
| 5786 |
|
|
| 5787 |
COMMENT ON COLUMN analytical_stem."taxonomicStatus__@DwC__@vegpath.org" IS 'from DwC, renamed'; |
|
| 5788 |
|
|
| 5789 |
|
|
| 5790 |
-- |
|
| 5791 |
-- Name: COLUMN analytical_stem.scrubbed_family; Type: COMMENT; Schema: public; Owner: - |
|
| 5792 |
-- |
|
| 5793 |
|
|
| 5794 |
COMMENT ON COLUMN analytical_stem.scrubbed_family IS 'variant of TNRS term'; |
|
| 5795 |
|
|
| 5796 |
|
|
| 5797 |
-- |
|
| 5798 |
-- Name: COLUMN analytical_stem.scrubbed_genus; Type: COMMENT; Schema: public; Owner: - |
|
| 5799 |
-- |
|
| 5800 |
|
|
| 5801 |
COMMENT ON COLUMN analytical_stem.scrubbed_genus IS 'variant of TNRS term'; |
|
| 5802 |
|
|
| 5803 |
|
|
| 5804 |
-- |
|
| 5805 |
-- Name: COLUMN analytical_stem.scrubbed_specific_epithet; Type: COMMENT; Schema: public; Owner: - |
|
| 5806 |
-- |
|
| 5807 |
|
|
| 5808 |
COMMENT ON COLUMN analytical_stem.scrubbed_specific_epithet IS 'variant of TNRS term'; |
|
| 5809 |
|
|
| 5810 |
|
|
| 5811 |
-- |
|
| 5812 |
-- Name: COLUMN analytical_stem.scrubbed_species_binomial; Type: COMMENT; Schema: public; Owner: - |
|
| 5813 |
-- |
|
| 5814 |
|
|
| 5815 |
COMMENT ON COLUMN analytical_stem.scrubbed_species_binomial IS 'variant of TNRS term'; |
|
| 5816 |
|
|
| 5817 |
|
|
| 5818 |
-- |
|
| 5819 |
-- Name: COLUMN analytical_stem.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: - |
|
| 5820 |
-- |
|
| 5821 |
|
|
| 5822 |
COMMENT ON COLUMN analytical_stem.scrubbed_taxon_name_no_author IS 'variant of TNRS term'; |
|
| 5823 |
|
|
| 5824 |
|
|
| 5825 |
-- |
|
| 5826 |
-- Name: COLUMN analytical_stem.scrubbed_author; Type: COMMENT; Schema: public; Owner: - |
|
| 5827 |
-- |
|
| 5828 |
|
|
| 5829 |
COMMENT ON COLUMN analytical_stem.scrubbed_author IS 'variant of TNRS term'; |
|
| 5830 |
|
|
| 5831 |
|
|
| 5832 |
-- |
|
| 5833 |
-- Name: COLUMN analytical_stem.scrubbed_taxon_name_with_author; Type: COMMENT; Schema: public; Owner: - |
|
| 5834 |
-- |
|
| 5835 |
|
|
| 5836 |
COMMENT ON COLUMN analytical_stem.scrubbed_taxon_name_with_author IS 'variant of TNRS term'; |
|
| 5837 |
|
|
| 5838 |
|
|
| 5839 |
-- |
|
| 5840 |
-- Name: COLUMN analytical_stem."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5841 |
-- |
|
| 5842 |
|
|
| 5843 |
COMMENT ON COLUMN analytical_stem."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org" IS 'TNRS.taxon_scrub.scrubbed_morphospecies_binomial@VegBIEN.public@vegpath.org; |
|
| 5844 |
"combine the `taxon` plus `morphospecies` to produce a unique string, `taxonMorphospecies`"'; |
|
| 5845 |
|
|
| 5846 |
|
|
| 5847 |
-- |
|
| 5848 |
-- Name: COLUMN analytical_stem."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5849 |
-- |
|
| 5850 |
|
|
| 5851 |
COMMENT ON COLUMN analytical_stem."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org" IS 'from SALVIAS, renamed'; |
|
| 5852 |
|
|
| 5853 |
|
|
| 5854 |
-- |
|
| 5855 |
-- Name: COLUMN analytical_stem."reproductiveCondition__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5856 |
-- |
|
| 5857 |
|
|
| 5858 |
COMMENT ON COLUMN analytical_stem."reproductiveCondition__@DwC__@vegpath.org" IS '"The reproductive condition of the biological individual(s) represented in the Occurrence. Recommended best practice is to use a controlled vocabulary."'; |
|
| 5859 |
|
|
| 5860 |
|
|
| 5861 |
-- |
|
| 5862 |
-- Name: COLUMN analytical_stem.threatened_bien; Type: COMMENT; Schema: public; Owner: - |
|
| 5863 |
-- |
|
| 5864 |
|
|
| 5865 |
COMMENT ON COLUMN analytical_stem.threatened_bien IS 'derived column'; |
|
| 5866 |
|
|
| 5867 |
|
|
| 5868 |
-- |
|
| 5869 |
-- Name: COLUMN analytical_stem.cultivated_bien; Type: COMMENT; Schema: public; Owner: - |
|
| 5870 |
-- |
|
| 5871 |
|
|
| 5872 |
COMMENT ON COLUMN analytical_stem.cultivated_bien IS 'variant of DwC term'; |
|
| 5873 |
|
|
| 5874 |
|
|
| 5875 |
-- |
|
| 5876 |
-- Name: COLUMN analytical_stem."cultivatedBasis_bien"; Type: COMMENT; Schema: public; Owner: - |
|
| 5877 |
-- |
|
| 5878 |
|
|
| 5879 |
COMMENT ON COLUMN analytical_stem."cultivatedBasis_bien" IS 'derived column'; |
|
| 5880 |
|
|
| 5881 |
|
|
| 5882 |
-- |
|
| 5883 |
-- Name: COLUMN analytical_stem."occurrenceRemarks__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5884 |
-- |
|
| 5885 |
|
|
| 5886 |
COMMENT ON COLUMN analytical_stem."occurrenceRemarks__@DwC__@vegpath.org" IS '"Comments or notes about the Occurrence"'; |
|
| 5887 |
|
|
| 5888 |
|
|
| 5889 |
-- |
|
| 5890 |
-- Name: COLUMN analytical_stem."coverPercent__@VegX__.attribute.ordinal@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5891 |
-- |
|
| 5892 |
|
|
| 5893 |
COMMENT ON COLUMN analytical_stem."coverPercent__@VegX__.attribute.ordinal@vegpath.org" IS '"Average cover of the index in percent"'; |
|
| 5894 |
|
|
| 5895 |
|
|
| 5896 |
-- |
|
| 5897 |
-- Name: COLUMN analytical_stem."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5898 |
-- |
|
| 5899 |
|
|
| 5900 |
COMMENT ON COLUMN analytical_stem."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org" IS 'from SALVIAS, renamed'; |
|
| 5901 |
|
|
| 5902 |
|
|
| 5903 |
-- |
|
| 5904 |
-- Name: COLUMN analytical_stem."stemHeight[_m]__@VegBank__.stemCount@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5905 |
-- |
|
| 5906 |
|
|
| 5907 |
COMMENT ON COLUMN analytical_stem."stemHeight[_m]__@VegBank__.stemCount@vegpath.org" IS 'variant of VegX term'; |
|
| 5908 |
|
|
| 5909 |
|
|
| 5910 |
-- |
|
| 5911 |
-- Name: COLUMN analytical_stem."[tag=]identificationLabel__@VegX__.individual@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5912 |
-- |
|
| 5913 |
|
|
| 5914 |
COMMENT ON COLUMN analytical_stem."[tag=]identificationLabel__@VegX__.individual@vegpath.org" IS 'from VegX, renamed'; |
|
| 5915 |
|
|
| 5916 |
|
|
| 5917 |
-- |
|
| 5918 |
-- Name: COLUMN analytical_stem."relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5919 |
-- |
|
| 5920 |
|
|
| 5921 |
COMMENT ON COLUMN analytical_stem."relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org" IS 'variant of VegX term'; |
|
| 5922 |
|
|
| 5923 |
|
|
| 5924 |
-- |
|
| 5925 |
-- Name: COLUMN analytical_stem."relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5926 |
-- |
|
| 5927 |
|
|
| 5928 |
COMMENT ON COLUMN analytical_stem."relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org" IS 'variant of VegX term'; |
|
| 5929 |
|
|
| 5930 |
|
|
| 5931 |
-- |
|
| 5932 |
-- Name: COLUMN analytical_stem."taxonObservation[.id]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5933 |
-- |
|
| 5934 |
|
|
| 5935 |
COMMENT ON COLUMN analytical_stem."taxonObservation[.id]__@VegBank__@vegpath.org" IS 'from VegX, renamed'; |
|
| 5936 |
|
|
| 5937 |
|
|
| 5938 |
-- |
|
| 5939 |
-- Name: COLUMN analytical_stem."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5940 |
-- |
|
| 5941 |
|
|
| 5942 |
COMMENT ON COLUMN analytical_stem."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org" IS 'variant of VegBank term'; |
|
| 5943 |
|
|
| 5944 |
|
|
| 5945 |
-- |
|
| 5946 |
-- Name: COLUMN analytical_stem."aggregateOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5947 |
-- |
|
| 5948 |
|
|
| 5949 |
COMMENT ON COLUMN analytical_stem."aggregateOrganismObservation.id__@VegX__@vegpath.org" IS 'from VegX, renamed'; |
|
| 5950 |
|
|
| 5951 |
|
|
| 5952 |
-- |
|
| 5953 |
-- Name: COLUMN analytical_stem."individualOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5954 |
-- |
|
| 5955 |
|
|
| 5956 |
COMMENT ON COLUMN analytical_stem."individualOrganismObservation.id__@VegX__@vegpath.org" IS 'from VegX, renamed'; |
|
| 5957 |
|
|
| 5958 |
|
|
| 5959 |
-- |
|
| 5960 |
-- Name: COLUMN analytical_stem."individualID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5961 |
-- |
|
| 5962 |
|
|
| 5963 |
COMMENT ON COLUMN analytical_stem."individualID__@DwC__@vegpath.org" IS 'from SALVIAS, renamed'; |
|
| 5964 |
|
|
| 5965 |
|
|
| 5966 |
-- |
|
| 5967 |
-- Name: COLUMN analytical_stem."individualCount__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5968 |
-- |
|
| 5969 |
|
|
| 5970 |
COMMENT ON COLUMN analytical_stem."individualCount__@DwC__@vegpath.org" IS '"The number of individuals represented present at the time of the Occurrence"'; |
|
| 5971 |
|
|
| 5972 |
|
|
| 5973 |
-- |
|
| 5974 |
-- Name: COLUMN analytical_stem."stemCode__@VegBank__.stemLocation@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5975 |
-- |
|
| 5976 |
|
|
| 5977 |
COMMENT ON COLUMN analytical_stem."stemCode__@VegBank__.stemLocation@vegpath.org" IS 'stemobservation.authorstemcode@VegBIEN.public@vegpath.org; |
|
| 5978 |
"Name or code applied to a specific stem in the plot. This is generally a numeric label to associate a field data entry with a stem in the database."'; |
|
| 5979 |
|
|
| 5980 |
|
|
| 5981 |
-- |
|
| 5457 | 5982 |
-- Name: 2013-10-18.Brian_Enquist.Canadensys; Type: VIEW; Schema: public; Owner: - |
| 5458 | 5983 |
-- |
| 5459 | 5984 |
|
| ... | ... | |
| 5771 | 6296 |
|
| 5772 | 6297 |
|
| 5773 | 6298 |
-- |
| 5774 |
-- Name: analytical_stem_taxon_occurrence__pkey_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 6299 |
-- Name: analytical_stem_TAXONOBSERVATION_ID__@VegBank__.taxonObserv_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 5775 | 6300 |
-- |
| 5776 | 6301 |
|
| 5777 |
CREATE SEQUENCE analytical_stem_taxon_occurrence__pkey_seq
|
|
| 6302 |
CREATE SEQUENCE "analytical_stem_TAXONOBSERVATION_ID__@VegBank__.taxonObserv_seq"
|
|
| 5778 | 6303 |
START WITH 1 |
| 5779 | 6304 |
INCREMENT BY 1 |
| 5780 | 6305 |
NO MINVALUE |
| ... | ... | |
| 5783 | 6308 |
|
| 5784 | 6309 |
|
| 5785 | 6310 |
-- |
| 5786 |
-- Name: analytical_stem_taxon_occurrence__pkey_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 6311 |
-- Name: analytical_stem_TAXONOBSERVATION_ID__@VegBank__.taxonObserv_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 5787 | 6312 |
-- |
| 5788 | 6313 |
|
| 5789 |
ALTER SEQUENCE analytical_stem_taxon_occurrence__pkey_seq OWNED BY analytical_stem."TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org";
|
|
| 6314 |
ALTER SEQUENCE "analytical_stem_TAXONOBSERVATION_ID__@VegBank__.taxonObserv_seq" OWNED BY analytical_stem."TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org";
|
|
| 5790 | 6315 |
|
| 5791 | 6316 |
|
| 5792 | 6317 |
-- |
| ... | ... | |
| 10444 | 10969 |
-- Name: TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org; Type: DEFAULT; Schema: public; Owner: - |
| 10445 | 10970 |
-- |
| 10446 | 10971 |
|
| 10447 |
ALTER TABLE ONLY analytical_stem ALTER COLUMN "TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org" SET DEFAULT nextval('analytical_stem_taxon_occurrence__pkey_seq'::regclass);
|
|
| 10972 |
ALTER TABLE ONLY analytical_stem ALTER COLUMN "TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org" SET DEFAULT nextval('"analytical_stem_TAXONOBSERVATION_ID__@VegBank__.taxonObserv_seq"'::regclass);
|
|
| 10448 | 10973 |
|
| 10449 | 10974 |
|
| 10450 | 10975 |
-- |
| ... | ... | |
| 10863 | 11388 |
|
| 10864 | 11389 |
|
| 10865 | 11390 |
-- |
| 10866 |
-- Name: analytical_stem_taxon_occurrence__pkey_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 11391 |
-- Name: analytical_stem_TAXONOBSERVATION_ID__@VegBank__.taxonObserv_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
|
| 10867 | 11392 |
-- |
| 10868 | 11393 |
|
| 10869 | 11394 |
|
| ... | ... | |
| 14218 | 14743 |
|
| 14219 | 14744 |
|
| 14220 | 14745 |
-- |
| 14221 |
-- Name: analytical_stem_datasource_occurrenceID_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 14746 |
-- Name: analytical_stem_datasource__@Brad__.identifier_examples@ve_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 14222 | 14747 |
-- |
| 14223 | 14748 |
|
| 14224 |
CREATE INDEX "analytical_stem_datasource_occurrenceID_idx" ON analytical_stem USING btree ("datasource__@Brad__.identifier_examples@vegpath.org", "occurrenceID__@DwC__@vegpath.org");
|
|
| 14749 |
CREATE INDEX "analytical_stem_datasource__@Brad__.identifier_examples@ve_idx1" ON analytical_stem USING btree ("datasource__@Brad__.identifier_examples@vegpath.org", "[custodial_]institutionCode[s]__@DwC__@vegpath.org", "collectionCode__@DwC__@vegpath.org", "catalogNumber__@DwC__@vegpath.org");
|
|
| 14225 | 14750 |
|
| 14226 | 14751 |
|
| 14227 | 14752 |
-- |
| 14228 |
-- Name: analytical_stem_datasource_projectID_locationID_eventDate_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 14753 |
-- Name: analytical_stem_datasource__@Brad__.identifier_examples@ve_idx2; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 14229 | 14754 |
-- |
| 14230 | 14755 |
|
| 14231 |
CREATE INDEX "analytical_stem_datasource_projectID_locationID_eventDate_idx" ON analytical_stem USING btree ("datasource__@Brad__.identifier_examples@vegpath.org", "projectID__@VegX__.plotObservation@vegpath.org", "locationID__@DwC__@vegpath.org", "eventDate__@DwC__@vegpath.org");
|
|
| 14756 |
CREATE INDEX "analytical_stem_datasource__@Brad__.identifier_examples@ve_idx2" ON analytical_stem USING btree ("datasource__@Brad__.identifier_examples@vegpath.org", "projectID__@VegX__.plotObservation@vegpath.org", "locationID__@DwC__@vegpath.org", "eventDate__@DwC__@vegpath.org");
|
|
| 14232 | 14757 |
|
| 14233 | 14758 |
|
| 14234 | 14759 |
-- |
| 14235 |
-- Name: analytical_stem_datasource_specimenHolderInstitutions_colle_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 14760 |
-- Name: analytical_stem_datasource__@Brad__.identifier_examples@veg_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 14236 | 14761 |
-- |
| 14237 | 14762 |
|
| 14238 |
CREATE INDEX "analytical_stem_datasource_specimenHolderInstitutions_colle_idx" ON analytical_stem USING btree ("datasource__@Brad__.identifier_examples@vegpath.org", "[custodial_]institutionCode[s]__@DwC__@vegpath.org", "collectionCode__@DwC__@vegpath.org", "catalogNumber__@DwC__@vegpath.org");
|
|
| 14763 |
CREATE INDEX "analytical_stem_datasource__@Brad__.identifier_examples@veg_idx" ON analytical_stem USING btree ("datasource__@Brad__.identifier_examples@vegpath.org", "occurrenceID__@DwC__@vegpath.org");
|
|
| 14239 | 14764 |
|
| 14240 | 14765 |
|
| 14241 | 14766 |
-- |
| 14242 |
-- Name: analytical_stem_scrubbed_morphospecies_binomial_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 14767 |
-- Name: analytical_stem_speciesBinomialWithMorphospecies__@VegCore__idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 14243 | 14768 |
-- |
| 14244 | 14769 |
|
| 14245 |
CREATE INDEX analytical_stem_scrubbed_morphospecies_binomial_idx ON analytical_stem USING btree ("speciesBinomialWithMorphospecies__@VegCore__@vegpath.org");
|
|
| 14770 |
CREATE INDEX "analytical_stem_speciesBinomialWithMorphospecies__@VegCore__idx" ON analytical_stem USING btree ("speciesBinomialWithMorphospecies__@VegCore__@vegpath.org");
|
|
| 14246 | 14771 |
|
| 14247 | 14772 |
|
| 14248 | 14773 |
-- |
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 5454 | 5454 |
|
| 5455 | 5455 |
|
| 5456 | 5456 |
-- |
| 5457 |
-- Name: COLUMN analytical_stem."datasource__@Brad__.identifier_examples@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5458 |
-- |
|
| 5459 |
|
|
| 5460 |
COMMENT ON COLUMN analytical_stem."datasource__@Brad__.identifier_examples@vegpath.org" IS 'variant of DwC term'; |
|
| 5461 |
|
|
| 5462 |
|
|
| 5463 |
-- |
|
| 5464 |
-- Name: COLUMN analytical_stem."country__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5465 |
-- |
|
| 5466 |
|
|
| 5467 |
COMMENT ON COLUMN analytical_stem."country__@DwC__@vegpath.org" IS 'geoscrub.geoscrub_output.acceptedCountry@VegBIEN@vegpath.org; |
|
| 5468 |
"The name of the country or major administrative unit in which the Location occurs"'; |
|
| 5469 |
|
|
| 5470 |
|
|
| 5471 |
-- |
|
| 5472 |
-- Name: COLUMN analytical_stem."stateProvince__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5473 |
-- |
|
| 5474 |
|
|
| 5475 |
COMMENT ON COLUMN analytical_stem."stateProvince__@DwC__@vegpath.org" IS '"The name of the next smaller administrative region than country (state, province, canton, department, region, etc.) in which the Location occurs"'; |
|
| 5476 |
|
|
| 5477 |
|
|
| 5478 |
-- |
|
| 5479 |
-- Name: COLUMN analytical_stem."county__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5480 |
-- |
|
| 5481 |
|
|
| 5482 |
COMMENT ON COLUMN analytical_stem."county__@DwC__@vegpath.org" IS '"The full, unabbreviated name of the next smaller administrative region than stateProvince (county, shire, department, etc.) in which the Location occurs"'; |
|
| 5483 |
|
|
| 5484 |
|
|
| 5485 |
-- |
|
| 5486 |
-- Name: COLUMN analytical_stem."locality__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5487 |
-- |
|
| 5488 |
|
|
| 5489 |
COMMENT ON COLUMN analytical_stem."locality__@DwC__@vegpath.org" IS '"The specific description of the place"'; |
|
| 5490 |
|
|
| 5491 |
|
|
| 5492 |
-- |
|
| 5493 |
-- Name: COLUMN analytical_stem."decimalLatitude__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5494 |
-- |
|
| 5495 |
|
|
| 5496 |
COMMENT ON COLUMN analytical_stem."decimalLatitude__@DwC__@vegpath.org" IS '"The geographic latitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"'; |
|
| 5497 |
|
|
| 5498 |
|
|
| 5499 |
-- |
|
| 5500 |
-- Name: COLUMN analytical_stem."decimalLongitude__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5501 |
-- |
|
| 5502 |
|
|
| 5503 |
COMMENT ON COLUMN analytical_stem."decimalLongitude__@DwC__@vegpath.org" IS '"The geographic longitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"'; |
|
| 5504 |
|
|
| 5505 |
|
|
| 5506 |
-- |
|
| 5507 |
-- Name: COLUMN analytical_stem."coordinateUncertaintyInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5508 |
-- |
|
| 5509 |
|
|
| 5510 |
COMMENT ON COLUMN analytical_stem."coordinateUncertaintyInMeters__@DwC__@vegpath.org" IS '"The horizontal distance (in meters) from the given decimalLatitude and decimalLongitude describing the smallest circle containing the whole of the Location"'; |
|
| 5511 |
|
|
| 5512 |
|
|
| 5513 |
-- |
|
| 5514 |
-- Name: COLUMN analytical_stem."georeferenceSources__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5515 |
-- |
|
| 5516 |
|
|
| 5517 |
COMMENT ON COLUMN analytical_stem."georeferenceSources__@DwC__@vegpath.org" IS 'derived column'; |
|
| 5518 |
|
|
| 5519 |
|
|
| 5520 |
-- |
|
| 5521 |
-- Name: COLUMN analytical_stem."georeferenceProtocol__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5522 |
-- |
|
| 5523 |
|
|
| 5524 |
COMMENT ON COLUMN analytical_stem."georeferenceProtocol__@DwC__@vegpath.org" IS 'derived column'; |
|
| 5525 |
|
|
| 5526 |
|
|
| 5527 |
-- |
|
| 5528 |
-- Name: COLUMN analytical_stem.geovalid_bien; Type: COMMENT; Schema: public; Owner: - |
|
| 5529 |
-- |
|
| 5530 |
|
|
| 5531 |
COMMENT ON COLUMN analytical_stem.geovalid_bien IS 'derived column'; |
|
| 5532 |
|
|
| 5533 |
|
|
| 5534 |
-- |
|
| 5535 |
-- Name: COLUMN analytical_stem."isNewWorld_bien"; Type: COMMENT; Schema: public; Owner: - |
|
| 5536 |
-- |
|
| 5537 |
|
|
| 5538 |
COMMENT ON COLUMN analytical_stem."isNewWorld_bien" IS 'derived column'; |
|
| 5539 |
|
|
| 5540 |
|
|
| 5541 |
-- |
|
| 5542 |
-- Name: COLUMN analytical_stem."projectID__@VegX__.plotObservation@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5543 |
-- |
|
| 5544 |
|
|
| 5545 |
COMMENT ON COLUMN analytical_stem."projectID__@VegX__.plotObservation@vegpath.org" IS 'project.sourceaccessioncode@VegBIEN.public@vegpath.org; |
|
| 5546 |
"A reference to a specific ''project''"'; |
|
| 5547 |
|
|
| 5548 |
|
|
| 5549 |
-- |
|
| 5550 |
-- Name: COLUMN analytical_stem."projectContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5551 |
-- |
|
| 5552 |
|
|
| 5553 |
COMMENT ON COLUMN analytical_stem."projectContributor[s]__@VegBank__@vegpath.org" IS 'variant of VegBank term'; |
|
| 5554 |
|
|
| 5555 |
|
|
| 5556 |
-- |
|
| 5557 |
-- Name: COLUMN analytical_stem."locationID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5558 |
-- |
|
| 5559 |
|
|
| 5560 |
COMMENT ON COLUMN analytical_stem."locationID__@DwC__@vegpath.org" IS '"An identifier for the set of location information (data associated with dcterms:Location)"'; |
|
| 5561 |
|
|
| 5562 |
|
|
| 5563 |
-- |
|
| 5564 |
-- Name: COLUMN analytical_stem."plotName__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5565 |
-- |
|
| 5566 |
|
|
| 5567 |
COMMENT ON COLUMN analytical_stem."plotName__@VegX__.plot@vegpath.org" IS '"Name or label for a plot"'; |
|
| 5568 |
|
|
| 5569 |
|
|
| 5570 |
-- |
|
| 5571 |
-- Name: COLUMN analytical_stem."subplot__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5572 |
-- |
|
| 5573 |
|
|
| 5574 |
COMMENT ON COLUMN analytical_stem."subplot__@SALVIAS__.Plot_data@vegpath.org" IS 'location.authorlocationcode@VegBIEN.public@vegpath.org; |
|
| 5575 |
"Code for subplot, line, or any other subsample or subdivision of plot"'; |
|
| 5576 |
|
|
| 5577 |
|
|
| 5578 |
-- |
|
| 5579 |
-- Name: COLUMN analytical_stem.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: - |
|
| 5580 |
-- |
|
| 5581 |
|
|
| 5582 |
COMMENT ON COLUMN analytical_stem.location__cultivated__bien IS 'variant of DwC term'; |
|
| 5583 |
|
|
| 5584 |
|
|
| 5585 |
-- |
|
| 5586 |
-- Name: COLUMN analytical_stem."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5587 |
-- |
|
| 5588 |
|
|
| 5589 |
COMMENT ON COLUMN analytical_stem."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org" IS 'locationevent.locationevent_id@VegBIEN.public@vegpath.org; |
|
| 5590 |
autogenerated ID for locationevent'; |
|
| 5591 |
|
|
| 5592 |
|
|
| 5593 |
-- |
|
| 5594 |
-- Name: COLUMN analytical_stem."eventDate__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5595 |
-- |
|
| 5596 |
|
|
| 5597 |
COMMENT ON COLUMN analytical_stem."eventDate__@DwC__@vegpath.org" IS '"The date-time or interval during which an Event occurred. For occurrences, this is the date-time when the event was recorded."'; |
|
| 5598 |
|
|
| 5599 |
|
|
| 5600 |
-- |
|
| 5601 |
-- Name: COLUMN analytical_stem."(-minimum-)ElevationInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5602 |
-- |
|
| 5603 |
|
|
| 5604 |
COMMENT ON COLUMN analytical_stem."(-minimum-)ElevationInMeters__@DwC__@vegpath.org" IS 'variant of DwC term'; |
|
| 5605 |
|
|
| 5606 |
|
|
| 5607 |
-- |
|
| 5608 |
-- Name: COLUMN analytical_stem."slopeAspect[_deg]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5609 |
-- |
|
| 5610 |
|
|
| 5611 |
COMMENT ON COLUMN analytical_stem."slopeAspect[_deg]__@VegX__.plot@vegpath.org" IS '"Representative azimuth of slope gradient (0-360 degrees) or as a cardinal direction (e.g. N, S, NE)"'; |
|
| 5612 |
|
|
| 5613 |
|
|
| 5614 |
-- |
|
| 5615 |
-- Name: COLUMN analytical_stem."slopeGradient[_deg]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5616 |
-- |
|
| 5617 |
|
|
| 5618 |
COMMENT ON COLUMN analytical_stem."slopeGradient[_deg]__@VegX__.plot@vegpath.org" IS '"Representative inclination of slope in degrees"'; |
|
| 5619 |
|
|
| 5620 |
|
|
| 5621 |
-- |
|
| 5622 |
-- Name: COLUMN analytical_stem."plot.area[_ha]__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5623 |
-- |
|
| 5624 |
|
|
| 5625 |
COMMENT ON COLUMN analytical_stem."plot.area[_ha]__@VegX__@vegpath.org" IS 'variant of VegX term'; |
|
| 5626 |
|
|
| 5627 |
|
|
| 5628 |
-- |
|
| 5629 |
-- Name: COLUMN analytical_stem."samplingProtocol__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5630 |
-- |
|
| 5631 |
|
|
| 5632 |
COMMENT ON COLUMN analytical_stem."samplingProtocol__@DwC__@vegpath.org" IS '"The name of, reference to, or description of the method or protocol used during an Event"'; |
|
| 5633 |
|
|
| 5634 |
|
|
| 5635 |
-- |
|
| 5636 |
-- Name: COLUMN analytical_stem."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5637 |
-- |
|
| 5638 |
|
|
| 5639 |
COMMENT ON COLUMN analytical_stem."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org" IS 'variant of VegX term'; |
|
| 5640 |
|
|
| 5641 |
|
|
| 5642 |
-- |
|
| 5643 |
-- Name: COLUMN analytical_stem."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5644 |
-- |
|
| 5645 |
|
|
| 5646 |
COMMENT ON COLUMN analytical_stem."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org" IS 'variant of VegX term'; |
|
| 5647 |
|
|
| 5648 |
|
|
| 5649 |
-- |
|
| 5650 |
-- Name: COLUMN analytical_stem."stratumName__@VegX__.stratum@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5651 |
-- |
|
| 5652 |
|
|
| 5653 |
COMMENT ON COLUMN analytical_stem."stratumName__@VegX__.stratum@vegpath.org" IS 'from VegX, renamed'; |
|
| 5654 |
|
|
| 5655 |
|
|
| 5656 |
-- |
|
| 5657 |
-- Name: COLUMN analytical_stem."communityConcept.name__@VegX__.communityDet@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5658 |
-- |
|
| 5659 |
|
|
| 5660 |
COMMENT ON COLUMN analytical_stem."communityConcept.name__@VegX__.communityDet@vegpath.org" IS 'variant of VegX term'; |
|
| 5661 |
|
|
| 5662 |
|
|
| 5663 |
-- |
|
| 5664 |
-- Name: COLUMN analytical_stem."observationContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5665 |
-- |
|
| 5666 |
|
|
| 5667 |
COMMENT ON COLUMN analytical_stem."observationContributor[s]__@VegBank__@vegpath.org" IS 'variant of VegBank term'; |
|
| 5668 |
|
|
| 5669 |
|
|
| 5670 |
-- |
|
| 5671 |
-- Name: COLUMN analytical_stem."[custodial_]institutionCode[s]__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5672 |
-- |
|
| 5673 |
|
|
| 5674 |
COMMENT ON COLUMN analytical_stem."[custodial_]institutionCode[s]__@DwC__@vegpath.org" IS 'from DwC, renamed'; |
|
| 5675 |
|
|
| 5676 |
|
|
| 5677 |
-- |
|
| 5678 |
-- Name: COLUMN analytical_stem."collectionCode__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5679 |
-- |
|
| 5680 |
|
|
| 5681 |
COMMENT ON COLUMN analytical_stem."collectionCode__@DwC__@vegpath.org" IS 'from DwC, renamed'; |
|
| 5682 |
|
|
| 5683 |
|
|
| 5684 |
-- |
|
| 5685 |
-- Name: COLUMN analytical_stem."catalogNumber__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5686 |
-- |
|
| 5687 |
|
|
| 5688 |
COMMENT ON COLUMN analytical_stem."catalogNumber__@DwC__@vegpath.org" IS 'variant of DwC term'; |
|
| 5689 |
|
|
| 5690 |
|
|
| 5691 |
-- |
|
| 5692 |
-- Name: COLUMN analytical_stem."occurrenceID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5693 |
-- |
|
| 5694 |
|
|
| 5695 |
COMMENT ON COLUMN analytical_stem."occurrenceID__@DwC__@vegpath.org" IS '"An identifier for the Occurrence (as opposed to a particular digital record of the occurrence). In the absence of a persistent global unique identifier, construct one from a combination of identifiers in the record that will most closely make the occurrenceID globally unique."'; |
|
| 5696 |
|
|
| 5697 |
|
|
| 5698 |
-- |
|
| 5699 |
-- Name: COLUMN analytical_stem."recordedBy__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5700 |
-- |
|
| 5701 |
|
|
| 5702 |
COMMENT ON COLUMN analytical_stem."recordedBy__@DwC__@vegpath.org" IS '"A list (concatenated and separated) of names of people, groups, or organizations responsible for recording the original Occurrence. The primary collector or observer, especially one who applies a personal identifier (recordNumber), should be listed first."'; |
|
| 5703 |
|
|
| 5704 |
|
|
| 5705 |
-- |
|
| 5706 |
-- Name: COLUMN analytical_stem."recordNumber__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5707 |
-- |
|
| 5708 |
|
|
| 5709 |
COMMENT ON COLUMN analytical_stem."recordNumber__@DwC__@vegpath.org" IS '"An identifier given to the Occurrence at the time it was recorded. Often serves as a link between field notes and an Occurrence record, such as a specimen collector''s number."'; |
|
| 5710 |
|
|
| 5711 |
|
|
| 5712 |
-- |
|
| 5713 |
-- Name: COLUMN analytical_stem."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5714 |
-- |
|
| 5715 |
|
|
| 5716 |
COMMENT ON COLUMN analytical_stem."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org" IS 'variant of DwC term'; |
|
| 5717 |
|
|
| 5718 |
|
|
| 5719 |
-- |
|
| 5720 |
-- Name: COLUMN analytical_stem."[verbatim_]family__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5721 |
-- |
|
| 5722 |
|
|
| 5723 |
COMMENT ON COLUMN analytical_stem."[verbatim_]family__@DwC__@vegpath.org" IS 'variant of DwC term'; |
|
| 5724 |
|
|
| 5725 |
|
|
| 5726 |
-- |
|
| 5727 |
-- Name: COLUMN analytical_stem."[verbatim_]scientificName__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
| 5728 |
-- |
|
| 5729 |
|
|
| 5730 |
COMMENT ON COLUMN analytical_stem."[verbatim_]scientificName__@DwC__@vegpath.org" IS 'variant of DwC term'; |
|
| 5731 |
|
|
| 5732 |
|
|
| 5733 |
-- |
|
Also available in: Unified diff
schemas/public_.sql: ran analytical_stem_view_modify(), which transfers the column COMMENTs from analytical_stem_view to analytical_stem