Revision 13842
Added by Aaron Marcuse-Kubitza over 10 years ago
| 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 |
-- |
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