Revision 14459
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 3227 | 3227 |
USE default_schema; |
| 3228 | 3228 |
|
| 3229 | 3229 |
-- |
| 3230 |
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 3230 |
-- Name: stemobservation; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 3231 | 3231 |
-- |
| 3232 | 3232 |
|
| 3233 |
CREATE TABLE analytical_stem ( |
|
| 3233 |
CREATE TABLE stemobservation ( |
|
| 3234 |
stemobservation_id int(11) NOT NULL, |
|
| 3235 |
source_id int(11) NOT NULL, |
|
| 3236 |
sourceaccessioncode varchar(255), |
|
| 3237 |
plantobservation_id int(11) NOT NULL, |
|
| 3238 |
authorstemcode varchar(255), |
|
| 3239 |
tag varchar(255), |
|
| 3240 |
tags varchar(255), |
|
| 3241 |
xposition_m double, |
|
| 3242 |
yposition_m double, |
|
| 3243 |
diameterbreastheight_m double, |
|
| 3244 |
basaldiameter_m double, |
|
| 3245 |
diameteraccuracy_m double, |
|
| 3246 |
height_m double, |
|
| 3247 |
heightfirstbranch_m double, |
|
| 3248 |
heightaccuracy_m double, |
|
| 3249 |
health varchar(255), |
|
| 3250 |
age double |
|
| 3251 |
); |
|
| 3252 |
|
|
| 3253 |
|
|
| 3254 |
-- |
|
| 3255 |
-- Name: TABLE stemobservation; Type: COMMENT; Schema: public; Owner: - |
|
| 3256 |
-- |
|
| 3257 |
|
|
| 3258 |
|
|
| 3259 |
|
|
| 3260 |
|
|
| 3261 |
-- |
|
| 3262 |
-- Name: COLUMN stemobservation.tags; Type: COMMENT; Schema: public; Owner: - |
|
| 3263 |
-- |
|
| 3264 |
|
|
| 3265 |
|
|
| 3266 |
|
|
| 3267 |
|
|
| 3268 |
-- |
|
| 3269 |
-- Name: viewFullOccurrence_individual; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 3270 |
-- |
|
| 3271 |
|
|
| 3272 |
CREATE TABLE `viewFullOccurrence_individual` ( |
|
| 3234 | 3273 |
`datasource__@Brad__.identifier_examples@vegpath.org` varchar(255) NOT NULL, |
| 3235 | 3274 |
`country__@DwC__@vegpath.org` varchar(255), |
| 3236 | 3275 |
`stateProvince__@DwC__@vegpath.org` varchar(255), |
| ... | ... | |
| 3299 | 3338 |
`individualID__@DwC__@vegpath.org` varchar(255), |
| 3300 | 3339 |
`individualCount__@DwC__@vegpath.org` int(11), |
| 3301 | 3340 |
`plantobservation.``_id__@VegBIEN__.public@vegpath.org` int(11), |
| 3302 |
`stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org` double, |
|
| 3303 |
`stemHeight[_m]__@VegBank__.stemCount@vegpath.org` double, |
|
| 3304 |
`[tag=]identificationLabel__@VegX__.individual@vegpath.org` varchar(255), |
|
| 3305 |
`relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org` double, |
|
| 3306 |
`relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org` double, |
|
| 3307 |
`stemCode__@VegBank__.stemLocation@vegpath.org` varchar(255), |
|
| 3308 | 3341 |
`TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org` int(11) NOT NULL |
| 3309 | 3342 |
); |
| 3310 | 3343 |
|
| 3311 | 3344 |
|
| 3312 | 3345 |
-- |
| 3313 |
-- Name: COLUMN analytical_stem.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3346 |
-- Name: COLUMN `viewFullOccurrence_individual`.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3314 | 3347 |
-- |
| 3315 | 3348 |
|
| 3316 | 3349 |
|
| 3317 | 3350 |
|
| 3318 | 3351 |
|
| 3319 | 3352 |
-- |
| 3320 |
-- Name: COLUMN analytical_stem.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3353 |
-- Name: COLUMN `viewFullOccurrence_individual`.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3321 | 3354 |
-- |
| 3322 | 3355 |
|
| 3323 | 3356 |
|
| 3324 | 3357 |
|
| 3325 | 3358 |
|
| 3326 | 3359 |
-- |
| 3327 |
-- Name: COLUMN analytical_stem.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3360 |
-- Name: COLUMN `viewFullOccurrence_individual`.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3328 | 3361 |
-- |
| 3329 | 3362 |
|
| 3330 | 3363 |
|
| 3331 | 3364 |
|
| 3332 | 3365 |
|
| 3333 | 3366 |
-- |
| 3334 |
-- Name: COLUMN analytical_stem.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3367 |
-- Name: COLUMN `viewFullOccurrence_individual`.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3335 | 3368 |
-- |
| 3336 | 3369 |
|
| 3337 | 3370 |
|
| 3338 | 3371 |
|
| 3339 | 3372 |
|
| 3340 | 3373 |
-- |
| 3341 |
-- Name: COLUMN analytical_stem.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3374 |
-- Name: COLUMN `viewFullOccurrence_individual`.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3342 | 3375 |
-- |
| 3343 | 3376 |
|
| 3344 | 3377 |
|
| 3345 | 3378 |
|
| 3346 | 3379 |
|
| 3347 | 3380 |
-- |
| 3348 |
-- Name: COLUMN analytical_stem.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3381 |
-- Name: COLUMN `viewFullOccurrence_individual`.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3349 | 3382 |
-- |
| 3350 | 3383 |
|
| 3351 | 3384 |
|
| 3352 | 3385 |
|
| 3353 | 3386 |
|
| 3354 | 3387 |
-- |
| 3355 |
-- Name: COLUMN analytical_stem.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3388 |
-- Name: COLUMN `viewFullOccurrence_individual`.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3356 | 3389 |
-- |
| 3357 | 3390 |
|
| 3358 | 3391 |
|
| 3359 | 3392 |
|
| 3360 | 3393 |
|
| 3361 | 3394 |
-- |
| 3362 |
-- Name: COLUMN analytical_stem.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3395 |
-- Name: COLUMN `viewFullOccurrence_individual`.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3363 | 3396 |
-- |
| 3364 | 3397 |
|
| 3365 | 3398 |
|
| 3366 | 3399 |
|
| 3367 | 3400 |
|
| 3368 | 3401 |
-- |
| 3369 |
-- Name: COLUMN analytical_stem.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3402 |
-- Name: COLUMN `viewFullOccurrence_individual`.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3370 | 3403 |
-- |
| 3371 | 3404 |
|
| 3372 | 3405 |
|
| 3373 | 3406 |
|
| 3374 | 3407 |
|
| 3375 | 3408 |
-- |
| 3376 |
-- Name: COLUMN analytical_stem.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3409 |
-- Name: COLUMN `viewFullOccurrence_individual`.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3377 | 3410 |
-- |
| 3378 | 3411 |
|
| 3379 | 3412 |
|
| 3380 | 3413 |
|
| 3381 | 3414 |
|
| 3382 | 3415 |
-- |
| 3383 |
-- Name: COLUMN analytical_stem.geovalid_bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 3416 |
-- Name: COLUMN `viewFullOccurrence_individual`.geovalid_bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 3384 | 3417 |
-- |
| 3385 | 3418 |
|
| 3386 | 3419 |
|
| 3387 | 3420 |
|
| 3388 | 3421 |
|
| 3389 | 3422 |
-- |
| 3390 |
-- Name: COLUMN analytical_stem.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3423 |
-- Name: COLUMN `viewFullOccurrence_individual`.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3391 | 3424 |
-- |
| 3392 | 3425 |
|
| 3393 | 3426 |
|
| 3394 | 3427 |
|
| 3395 | 3428 |
|
| 3396 | 3429 |
-- |
| 3397 |
-- Name: COLUMN analytical_stem.`projectID__@VegX__.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3430 |
-- Name: COLUMN `viewFullOccurrence_individual`.`projectID__@VegX__.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3398 | 3431 |
-- |
| 3399 | 3432 |
|
| 3400 | 3433 |
|
| 3401 | 3434 |
|
| 3402 | 3435 |
|
| 3403 | 3436 |
-- |
| 3404 |
-- Name: COLUMN analytical_stem.`projectContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3437 |
-- Name: COLUMN `viewFullOccurrence_individual`.`projectContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3405 | 3438 |
-- |
| 3406 | 3439 |
|
| 3407 | 3440 |
|
| 3408 | 3441 |
|
| 3409 | 3442 |
|
| 3410 | 3443 |
-- |
| 3411 |
-- Name: COLUMN analytical_stem.`locationID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3444 |
-- Name: COLUMN `viewFullOccurrence_individual`.`locationID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3412 | 3445 |
-- |
| 3413 | 3446 |
|
| 3414 | 3447 |
|
| 3415 | 3448 |
|
| 3416 | 3449 |
|
| 3417 | 3450 |
-- |
| 3418 |
-- Name: COLUMN analytical_stem.`plotName__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3451 |
-- Name: COLUMN `viewFullOccurrence_individual`.`plotName__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3419 | 3452 |
-- |
| 3420 | 3453 |
|
| 3421 | 3454 |
|
| 3422 | 3455 |
|
| 3423 | 3456 |
|
| 3424 | 3457 |
-- |
| 3425 |
-- Name: COLUMN analytical_stem.`subplot__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3458 |
-- Name: COLUMN `viewFullOccurrence_individual`.`subplot__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3426 | 3459 |
-- |
| 3427 | 3460 |
|
| 3428 | 3461 |
|
| 3429 | 3462 |
|
| 3430 | 3463 |
|
| 3431 | 3464 |
-- |
| 3432 |
-- Name: COLUMN analytical_stem.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 3465 |
-- Name: COLUMN `viewFullOccurrence_individual`.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 3433 | 3466 |
-- |
| 3434 | 3467 |
|
| 3435 | 3468 |
|
| 3436 | 3469 |
|
| 3437 | 3470 |
|
| 3438 | 3471 |
-- |
| 3439 |
-- Name: COLUMN analytical_stem.`locationevent.locationevent_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3472 |
-- Name: COLUMN `viewFullOccurrence_individual`.`locationevent.locationevent_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3440 | 3473 |
-- |
| 3441 | 3474 |
|
| 3442 | 3475 |
|
| 3443 | 3476 |
|
| 3444 | 3477 |
|
| 3445 | 3478 |
-- |
| 3446 |
-- Name: COLUMN analytical_stem.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3479 |
-- Name: COLUMN `viewFullOccurrence_individual`.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3447 | 3480 |
-- |
| 3448 | 3481 |
|
| 3449 | 3482 |
|
| 3450 | 3483 |
|
| 3451 | 3484 |
|
| 3452 | 3485 |
-- |
| 3453 |
-- Name: COLUMN analytical_stem.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3486 |
-- Name: COLUMN `viewFullOccurrence_individual`.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3454 | 3487 |
-- |
| 3455 | 3488 |
|
| 3456 | 3489 |
|
| 3457 | 3490 |
|
| 3458 | 3491 |
|
| 3459 | 3492 |
-- |
| 3460 |
-- Name: COLUMN analytical_stem.`slopeAspect[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3493 |
-- Name: COLUMN `viewFullOccurrence_individual`.`slopeAspect[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3461 | 3494 |
-- |
| 3462 | 3495 |
|
| 3463 | 3496 |
|
| 3464 | 3497 |
|
| 3465 | 3498 |
|
| 3466 | 3499 |
-- |
| 3467 |
-- Name: COLUMN analytical_stem.`slopeGradient[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3500 |
-- Name: COLUMN `viewFullOccurrence_individual`.`slopeGradient[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3468 | 3501 |
-- |
| 3469 | 3502 |
|
| 3470 | 3503 |
|
| 3471 | 3504 |
|
| 3472 | 3505 |
|
| 3473 | 3506 |
-- |
| 3474 |
-- Name: COLUMN analytical_stem.`plot.area[_ha]__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3507 |
-- Name: COLUMN `viewFullOccurrence_individual`.`plot.area[_ha]__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3475 | 3508 |
-- |
| 3476 | 3509 |
|
| 3477 | 3510 |
|
| 3478 | 3511 |
|
| 3479 | 3512 |
|
| 3480 | 3513 |
-- |
| 3481 |
-- Name: COLUMN analytical_stem.`samplingProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3514 |
-- Name: COLUMN `viewFullOccurrence_individual`.`samplingProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3482 | 3515 |
-- |
| 3483 | 3516 |
|
| 3484 | 3517 |
|
| 3485 | 3518 |
|
| 3486 | 3519 |
|
| 3487 | 3520 |
-- |
| 3488 |
-- Name: COLUMN analytical_stem.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3521 |
-- Name: COLUMN `viewFullOccurrence_individual`.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3489 | 3522 |
-- |
| 3490 | 3523 |
|
| 3491 | 3524 |
|
| 3492 | 3525 |
|
| 3493 | 3526 |
|
| 3494 | 3527 |
-- |
| 3495 |
-- Name: COLUMN analytical_stem.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3528 |
-- Name: COLUMN `viewFullOccurrence_individual`.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3496 | 3529 |
-- |
| 3497 | 3530 |
|
| 3498 | 3531 |
|
| 3499 | 3532 |
|
| 3500 | 3533 |
|
| 3501 | 3534 |
-- |
| 3502 |
-- Name: COLUMN analytical_stem.`stratumName__@VegX__.stratum@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3535 |
-- Name: COLUMN `viewFullOccurrence_individual`.`stratumName__@VegX__.stratum@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3503 | 3536 |
-- |
| 3504 | 3537 |
|
| 3505 | 3538 |
|
| 3506 | 3539 |
|
| 3507 | 3540 |
|
| 3508 | 3541 |
-- |
| 3509 |
-- Name: COLUMN analytical_stem.`communityConcept.name__@VegX__.communityDet@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3542 |
-- Name: COLUMN `viewFullOccurrence_individual`.`communityConcept.name__@VegX__.communityDet@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3510 | 3543 |
-- |
| 3511 | 3544 |
|
| 3512 | 3545 |
|
| 3513 | 3546 |
|
| 3514 | 3547 |
|
| 3515 | 3548 |
-- |
| 3516 |
-- Name: COLUMN analytical_stem.`observationContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3549 |
-- Name: COLUMN `viewFullOccurrence_individual`.`observationContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3517 | 3550 |
-- |
| 3518 | 3551 |
|
| 3519 | 3552 |
|
| 3520 | 3553 |
|
| 3521 | 3554 |
|
| 3522 | 3555 |
-- |
| 3523 |
-- Name: COLUMN analytical_stem.`[custodial_]institutionCode[s]__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3556 |
-- Name: COLUMN `viewFullOccurrence_individual`.`[custodial_]institutionCode[s]__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3524 | 3557 |
-- |
| 3525 | 3558 |
|
| 3526 | 3559 |
|
| 3527 | 3560 |
|
| 3528 | 3561 |
|
| 3529 | 3562 |
-- |
| 3530 |
-- Name: COLUMN analytical_stem.`collectionCode__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3563 |
-- Name: COLUMN `viewFullOccurrence_individual`.`collectionCode__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3531 | 3564 |
-- |
| 3532 | 3565 |
|
| 3533 | 3566 |
|
| 3534 | 3567 |
|
| 3535 | 3568 |
|
| 3536 | 3569 |
-- |
| 3537 |
-- Name: COLUMN analytical_stem.`catalogNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3570 |
-- Name: COLUMN `viewFullOccurrence_individual`.`catalogNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3538 | 3571 |
-- |
| 3539 | 3572 |
|
| 3540 | 3573 |
|
| 3541 | 3574 |
|
| 3542 | 3575 |
|
| 3543 | 3576 |
-- |
| 3544 |
-- Name: COLUMN analytical_stem.`occurrenceID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3577 |
-- Name: COLUMN `viewFullOccurrence_individual`.`occurrenceID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3545 | 3578 |
-- |
| 3546 | 3579 |
|
| 3547 | 3580 |
|
| 3548 | 3581 |
|
| 3549 | 3582 |
|
| 3550 | 3583 |
-- |
| 3551 |
-- Name: COLUMN analytical_stem.`recordedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3584 |
-- Name: COLUMN `viewFullOccurrence_individual`.`recordedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3552 | 3585 |
-- |
| 3553 | 3586 |
|
| 3554 | 3587 |
|
| 3555 | 3588 |
|
| 3556 | 3589 |
|
| 3557 | 3590 |
-- |
| 3558 |
-- Name: COLUMN analytical_stem.`recordNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3591 |
-- Name: COLUMN `viewFullOccurrence_individual`.`recordNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3559 | 3592 |
-- |
| 3560 | 3593 |
|
| 3561 | 3594 |
|
| 3562 | 3595 |
|
| 3563 | 3596 |
|
| 3564 | 3597 |
-- |
| 3565 |
-- Name: COLUMN analytical_stem.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3598 |
-- Name: COLUMN `viewFullOccurrence_individual`.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3566 | 3599 |
-- |
| 3567 | 3600 |
|
| 3568 | 3601 |
|
| 3569 | 3602 |
|
| 3570 | 3603 |
|
| 3571 | 3604 |
-- |
| 3572 |
-- Name: COLUMN analytical_stem.`[verbatim_]family__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3605 |
-- Name: COLUMN `viewFullOccurrence_individual`.`[verbatim_]family__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3573 | 3606 |
-- |
| 3574 | 3607 |
|
| 3575 | 3608 |
|
| 3576 | 3609 |
|
| 3577 | 3610 |
|
| 3578 | 3611 |
-- |
| 3579 |
-- Name: COLUMN analytical_stem.`[verbatim_]scientificName__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3612 |
-- Name: COLUMN `viewFullOccurrence_individual`.`[verbatim_]scientificName__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3580 | 3613 |
-- |
| 3581 | 3614 |
|
| 3582 | 3615 |
|
| 3583 | 3616 |
|
| 3584 | 3617 |
|
| 3585 | 3618 |
-- |
| 3586 |
-- Name: COLUMN analytical_stem.`identifiedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3619 |
-- Name: COLUMN `viewFullOccurrence_individual`.`identifiedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3587 | 3620 |
-- |
| 3588 | 3621 |
|
| 3589 | 3622 |
|
| 3590 | 3623 |
|
| 3591 | 3624 |
|
| 3592 | 3625 |
-- |
| 3593 |
-- Name: COLUMN analytical_stem.`dateIdentified__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3626 |
-- Name: COLUMN `viewFullOccurrence_individual`.`dateIdentified__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3594 | 3627 |
-- |
| 3595 | 3628 |
|
| 3596 | 3629 |
|
| 3597 | 3630 |
|
| 3598 | 3631 |
|
| 3599 | 3632 |
-- |
| 3600 |
-- Name: COLUMN analytical_stem.`identificationRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3633 |
-- Name: COLUMN `viewFullOccurrence_individual`.`identificationRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3601 | 3634 |
-- |
| 3602 | 3635 |
|
| 3603 | 3636 |
|
| 3604 | 3637 |
|
| 3605 | 3638 |
|
| 3606 | 3639 |
-- |
| 3607 |
-- Name: COLUMN analytical_stem.`Family_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3640 |
-- Name: COLUMN `viewFullOccurrence_individual`.`Family_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3608 | 3641 |
-- |
| 3609 | 3642 |
|
| 3610 | 3643 |
|
| 3611 | 3644 |
|
| 3612 | 3645 |
|
| 3613 | 3646 |
-- |
| 3614 |
-- Name: COLUMN analytical_stem.`Name_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3647 |
-- Name: COLUMN `viewFullOccurrence_individual`.`Name_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3615 | 3648 |
-- |
| 3616 | 3649 |
|
| 3617 | 3650 |
|
| 3618 | 3651 |
|
| 3619 | 3652 |
|
| 3620 | 3653 |
-- |
| 3621 |
-- Name: COLUMN analytical_stem.`Name_matched_author__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3654 |
-- Name: COLUMN `viewFullOccurrence_individual`.`Name_matched_author__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3622 | 3655 |
-- |
| 3623 | 3656 |
|
| 3624 | 3657 |
|
| 3625 | 3658 |
|
| 3626 | 3659 |
|
| 3627 | 3660 |
-- |
| 3628 |
-- Name: COLUMN analytical_stem.`[higher_plant_group~]higherClassification__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3661 |
-- Name: COLUMN `viewFullOccurrence_individual`.`[higher_plant_group~]higherClassification__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3629 | 3662 |
-- |
| 3630 | 3663 |
|
| 3631 | 3664 |
|
| 3632 | 3665 |
|
| 3633 | 3666 |
|
| 3634 | 3667 |
-- |
| 3635 |
-- Name: COLUMN analytical_stem.`taxonomicStatus__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3668 |
-- Name: COLUMN `viewFullOccurrence_individual`.`taxonomicStatus__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3636 | 3669 |
-- |
| 3637 | 3670 |
|
| 3638 | 3671 |
|
| 3639 | 3672 |
|
| 3640 | 3673 |
|
| 3641 | 3674 |
-- |
| 3642 |
-- Name: COLUMN analytical_stem.scrubbed_family; Type: COMMENT; Schema: public; Owner: -
|
|
| 3675 |
-- Name: COLUMN `viewFullOccurrence_individual`.scrubbed_family; Type: COMMENT; Schema: public; Owner: -
|
|
| 3643 | 3676 |
-- |
| 3644 | 3677 |
|
| 3645 | 3678 |
|
| 3646 | 3679 |
|
| 3647 | 3680 |
|
| 3648 | 3681 |
-- |
| 3649 |
-- Name: COLUMN analytical_stem.scrubbed_genus; Type: COMMENT; Schema: public; Owner: -
|
|
| 3682 |
-- Name: COLUMN `viewFullOccurrence_individual`.scrubbed_genus; Type: COMMENT; Schema: public; Owner: -
|
|
| 3650 | 3683 |
-- |
| 3651 | 3684 |
|
| 3652 | 3685 |
|
| 3653 | 3686 |
|
| 3654 | 3687 |
|
| 3655 | 3688 |
-- |
| 3656 |
-- Name: COLUMN analytical_stem.scrubbed_specific_epithet; Type: COMMENT; Schema: public; Owner: -
|
|
| 3689 |
-- Name: COLUMN `viewFullOccurrence_individual`.scrubbed_specific_epithet; Type: COMMENT; Schema: public; Owner: -
|
|
| 3657 | 3690 |
-- |
| 3658 | 3691 |
|
| 3659 | 3692 |
|
| 3660 | 3693 |
|
| 3661 | 3694 |
|
| 3662 | 3695 |
-- |
| 3663 |
-- Name: COLUMN analytical_stem.scrubbed_species_binomial; Type: COMMENT; Schema: public; Owner: -
|
|
| 3696 |
-- Name: COLUMN `viewFullOccurrence_individual`.scrubbed_species_binomial; Type: COMMENT; Schema: public; Owner: -
|
|
| 3664 | 3697 |
-- |
| 3665 | 3698 |
|
| 3666 | 3699 |
|
| 3667 | 3700 |
|
| 3668 | 3701 |
|
| 3669 | 3702 |
-- |
| 3670 |
-- Name: COLUMN analytical_stem.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: -
|
|
| 3703 |
-- Name: COLUMN `viewFullOccurrence_individual`.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: -
|
|
| 3671 | 3704 |
-- |
| 3672 | 3705 |
|
| 3673 | 3706 |
|
| 3674 | 3707 |
|
| 3675 | 3708 |
|
| 3676 | 3709 |
-- |
| 3677 |
-- Name: COLUMN analytical_stem.scrubbed_author; Type: COMMENT; Schema: public; Owner: -
|
|
| 3710 |
-- Name: COLUMN `viewFullOccurrence_individual`.scrubbed_author; Type: COMMENT; Schema: public; Owner: -
|
|
| 3678 | 3711 |
-- |
| 3679 | 3712 |
|
| 3680 | 3713 |
|
| 3681 | 3714 |
|
| 3682 | 3715 |
|
| 3683 | 3716 |
-- |
| 3684 |
-- Name: COLUMN analytical_stem.scrubbed_taxon_name_with_author; Type: COMMENT; Schema: public; Owner: -
|
|
| 3717 |
-- Name: COLUMN `viewFullOccurrence_individual`.scrubbed_taxon_name_with_author; Type: COMMENT; Schema: public; Owner: -
|
|
| 3685 | 3718 |
-- |
| 3686 | 3719 |
|
| 3687 | 3720 |
|
| 3688 | 3721 |
|
| 3689 | 3722 |
|
| 3690 | 3723 |
-- |
| 3691 |
-- Name: COLUMN analytical_stem.`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3724 |
-- Name: COLUMN `viewFullOccurrence_individual`.`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3692 | 3725 |
-- |
| 3693 | 3726 |
|
| 3694 | 3727 |
|
| 3695 | 3728 |
|
| 3696 | 3729 |
|
| 3697 | 3730 |
-- |
| 3698 |
-- Name: COLUMN analytical_stem.`[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3731 |
-- Name: COLUMN `viewFullOccurrence_individual`.`[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3699 | 3732 |
-- |
| 3700 | 3733 |
|
| 3701 | 3734 |
|
| 3702 | 3735 |
|
| 3703 | 3736 |
|
| 3704 | 3737 |
-- |
| 3705 |
-- Name: COLUMN analytical_stem.`reproductiveCondition__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3738 |
-- Name: COLUMN `viewFullOccurrence_individual`.`reproductiveCondition__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3706 | 3739 |
-- |
| 3707 | 3740 |
|
| 3708 | 3741 |
|
| 3709 | 3742 |
|
| 3710 | 3743 |
|
| 3711 | 3744 |
-- |
| 3712 |
-- Name: COLUMN analytical_stem.cultivated_bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 3745 |
-- Name: COLUMN `viewFullOccurrence_individual`.cultivated_bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 3713 | 3746 |
-- |
| 3714 | 3747 |
|
| 3715 | 3748 |
|
| 3716 | 3749 |
|
| 3717 | 3750 |
|
| 3718 | 3751 |
-- |
| 3719 |
-- Name: COLUMN analytical_stem.`cultivatedBasis_bien`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3752 |
-- Name: COLUMN `viewFullOccurrence_individual`.`cultivatedBasis_bien`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3720 | 3753 |
-- |
| 3721 | 3754 |
|
| 3722 | 3755 |
|
| 3723 | 3756 |
|
| 3724 | 3757 |
|
| 3725 | 3758 |
-- |
| 3726 |
-- Name: COLUMN analytical_stem.`occurrenceRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3759 |
-- Name: COLUMN `viewFullOccurrence_individual`.`occurrenceRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3727 | 3760 |
-- |
| 3728 | 3761 |
|
| 3729 | 3762 |
|
| 3730 | 3763 |
|
| 3731 | 3764 |
|
| 3732 | 3765 |
-- |
| 3733 |
-- Name: COLUMN analytical_stem.`coverPercent__@VegX__.attribute.ordinal@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3766 |
-- Name: COLUMN `viewFullOccurrence_individual`.`coverPercent__@VegX__.attribute.ordinal@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3734 | 3767 |
-- |
| 3735 | 3768 |
|
| 3736 | 3769 |
|
| 3737 | 3770 |
|
| 3738 | 3771 |
|
| 3739 | 3772 |
-- |
| 3740 |
-- Name: COLUMN analytical_stem.`taxonObservation[.id]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3773 |
-- Name: COLUMN `viewFullOccurrence_individual`.`taxonObservation[.id]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3741 | 3774 |
-- |
| 3742 | 3775 |
|
| 3743 | 3776 |
|
| 3744 | 3777 |
|
| 3745 | 3778 |
|
| 3746 | 3779 |
-- |
| 3747 |
-- Name: COLUMN analytical_stem.`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3780 |
-- Name: COLUMN `viewFullOccurrence_individual`.`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3748 | 3781 |
-- |
| 3749 | 3782 |
|
| 3750 | 3783 |
|
| 3751 | 3784 |
|
| 3752 | 3785 |
|
| 3753 | 3786 |
-- |
| 3754 |
-- Name: COLUMN analytical_stem.`aggregateOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3787 |
-- Name: COLUMN `viewFullOccurrence_individual`.`aggregateOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3755 | 3788 |
-- |
| 3756 | 3789 |
|
| 3757 | 3790 |
|
| 3758 | 3791 |
|
| 3759 | 3792 |
|
| 3760 | 3793 |
-- |
| 3761 |
-- Name: COLUMN analytical_stem.`individualOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3794 |
-- Name: COLUMN `viewFullOccurrence_individual`.`individualOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3762 | 3795 |
-- |
| 3763 | 3796 |
|
| 3764 | 3797 |
|
| 3765 | 3798 |
|
| 3766 | 3799 |
|
| 3767 | 3800 |
-- |
| 3768 |
-- Name: COLUMN analytical_stem.`individualID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3801 |
-- Name: COLUMN `viewFullOccurrence_individual`.`individualID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3769 | 3802 |
-- |
| 3770 | 3803 |
|
| 3771 | 3804 |
|
| 3772 | 3805 |
|
| 3773 | 3806 |
|
| 3774 | 3807 |
-- |
| 3775 |
-- Name: COLUMN analytical_stem.`individualCount__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3808 |
-- Name: COLUMN `viewFullOccurrence_individual`.`individualCount__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3776 | 3809 |
-- |
| 3777 | 3810 |
|
| 3778 | 3811 |
|
| 3779 | 3812 |
|
| 3780 | 3813 |
|
| 3781 | 3814 |
-- |
| 3782 |
-- Name: COLUMN analytical_stem.`stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3815 |
-- Name: COLUMN `viewFullOccurrence_individual`.`plantobservation.``_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3783 | 3816 |
-- |
| 3784 | 3817 |
|
| 3785 | 3818 |
|
| 3786 | 3819 |
|
| 3787 | 3820 |
|
| 3788 | 3821 |
-- |
| 3789 |
-- Name: COLUMN analytical_stem.`stemHeight[_m]__@VegBank__.stemCount@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3822 |
-- Name: COLUMN `viewFullOccurrence_individual`.`TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3790 | 3823 |
-- |
| 3791 | 3824 |
|
| 3792 | 3825 |
|
| 3793 | 3826 |
|
| 3794 | 3827 |
|
| 3795 | 3828 |
-- |
| 3796 |
-- Name: COLUMN analytical_stem.`[tag=]identificationLabel__@VegX__.individual@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3829 |
-- Name: analytical_stem_view; Type: VIEW; Schema: public; Owner: -
|
|
| 3797 | 3830 |
-- |
| 3798 | 3831 |
|
| 3799 | 3832 |
|
| 3800 | 3833 |
|
| 3801 | 3834 |
|
| 3802 | 3835 |
-- |
| 3803 |
-- Name: COLUMN analytical_stem.`relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3836 |
-- Name: VIEW analytical_stem_view; Type: COMMENT; Schema: public; Owner: -
|
|
| 3804 | 3837 |
-- |
| 3805 | 3838 |
|
| 3806 | 3839 |
|
| 3807 | 3840 |
|
| 3808 | 3841 |
|
| 3809 | 3842 |
-- |
| 3810 |
-- Name: COLUMN analytical_stem.`relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3843 |
-- Name: COLUMN analytical_stem_view.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3811 | 3844 |
-- |
| 3812 | 3845 |
|
| 3813 | 3846 |
|
| 3814 | 3847 |
|
| 3815 | 3848 |
|
| 3816 | 3849 |
-- |
| 3817 |
-- Name: COLUMN analytical_stem.`stemCode__@VegBank__.stemLocation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3850 |
-- Name: COLUMN analytical_stem_view.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3818 | 3851 |
-- |
| 3819 | 3852 |
|
| 3820 | 3853 |
|
| 3821 | 3854 |
|
| 3822 | 3855 |
|
| 3823 | 3856 |
-- |
| 3824 |
-- Name: COLUMN analytical_stem.`TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3857 |
-- Name: COLUMN analytical_stem_view.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3825 | 3858 |
-- |
| 3826 | 3859 |
|
| 3827 | 3860 |
|
| 3828 | 3861 |
|
| 3829 | 3862 |
|
| 3830 | 3863 |
-- |
| 3831 |
-- Name: 2013-10-18.Brian_Enquist.Canadensys; Type: VIEW; Schema: public; Owner: -
|
|
| 3864 |
-- Name: COLUMN analytical_stem_view.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3832 | 3865 |
-- |
| 3833 | 3866 |
|
| 3834 | 3867 |
|
| 3835 | 3868 |
|
| 3836 | 3869 |
|
| 3837 | 3870 |
-- |
| 3838 |
-- Name: 2013-7-10.Naia.range_limiting_factors; Type: VIEW; Schema: public; Owner: -
|
|
| 3871 |
-- Name: COLUMN analytical_stem_view.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3839 | 3872 |
-- |
| 3840 | 3873 |
|
| 3841 | 3874 |
|
| 3842 | 3875 |
|
| 3843 | 3876 |
|
| 3844 | 3877 |
-- |
| 3845 |
-- Name: 2014-3-11.Jeff_Ott.climatic_range_determinants; Type: VIEW; Schema: public; Owner: -
|
|
| 3878 |
-- Name: COLUMN analytical_stem_view.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3846 | 3879 |
-- |
| 3847 | 3880 |
|
| 3848 | 3881 |
|
| 3849 | 3882 |
|
| 3850 | 3883 |
|
| 3851 | 3884 |
-- |
| 3852 |
-- Name: 2014-6-12.Jeff_Ott.climatic_range_determinants; Type: VIEW; Schema: public; Owner: -
|
|
| 3885 |
-- Name: COLUMN analytical_stem_view.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3853 | 3886 |
-- |
| 3854 | 3887 |
|
| 3855 | 3888 |
|
| 3856 | 3889 |
|
| 3857 | 3890 |
|
| 3858 | 3891 |
-- |
| 3859 |
-- Name: iucn_red_list; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 3892 |
-- Name: COLUMN analytical_stem_view.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3860 | 3893 |
-- |
| 3861 | 3894 |
|
| 3862 |
CREATE TABLE iucn_red_list ( |
|
| 3863 |
accepted_family varchar(255) NOT NULL, |
|
| 3864 |
accepted_species_binomial varchar(255) NOT NULL |
|
| 3865 |
); |
|
| 3866 | 3895 |
|
| 3867 | 3896 |
|
| 3868 |
-- |
|
| 3869 |
-- Name: source; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 3870 |
-- |
|
| 3871 | 3897 |
|
| 3872 |
CREATE TABLE source ( |
|
| 3873 |
source_id int(11) NOT NULL, |
|
| 3874 |
matched_source_id int(11), |
|
| 3875 |
parent_id int(11), |
|
| 3876 |
shortname varchar(255) NOT NULL, |
|
| 3877 |
citation varchar(255), |
|
| 3878 |
sourcetype varchar(255), |
|
| 3879 |
accesslevel varchar(255), |
|
| 3880 |
accessconditions varchar(255), |
|
| 3881 |
observationtype varchar(255), |
|
| 3882 |
title varchar(255), |
|
| 3883 |
titlesuperior varchar(255), |
|
| 3884 |
volume varchar(255), |
|
| 3885 |
issue varchar(255), |
|
| 3886 |
pagerange varchar(255), |
|
| 3887 |
totalpages int(11), |
|
| 3888 |
publisher varchar(255), |
|
| 3889 |
publicationplace varchar(255), |
|
| 3890 |
isbn varchar(255), |
|
| 3891 |
edition varchar(255), |
|
| 3892 |
numberofvolumes int(11), |
|
| 3893 |
chapternumber int(11), |
|
| 3894 |
reportnumber int(11), |
|
| 3895 |
communicationtype varchar(255), |
|
| 3896 |
degree varchar(255), |
|
| 3897 |
url varchar(255), |
|
| 3898 |
doi varchar(255), |
|
| 3899 |
additionalinfo varchar(255), |
|
| 3900 |
pubdate date, |
|
| 3901 |
accessdate date, |
|
| 3902 |
conferencedate date, |
|
| 3903 |
datecreated date NOT NULL, |
|
| 3904 |
createdby varchar(255), |
|
| 3905 |
datelastmodified date NOT NULL, |
|
| 3906 |
lastmodifiedby varchar(255), |
|
| 3907 |
import_revision varchar(255) |
|
| 3908 |
); |
|
| 3909 |
|
|
| 3910 |
|
|
| 3911 | 3898 |
-- |
| 3912 |
-- Name: 2014-6-4.Iara_Lacher.reserve_prioritization; Type: VIEW; Schema: public; Owner: -
|
|
| 3899 |
-- Name: COLUMN analytical_stem_view.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3913 | 3900 |
-- |
| 3914 | 3901 |
|
| 3915 | 3902 |
|
| 3916 | 3903 |
|
| 3917 | 3904 |
|
| 3918 | 3905 |
-- |
| 3919 |
-- Name: address; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 3906 |
-- Name: COLUMN analytical_stem_view.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3920 | 3907 |
-- |
| 3921 | 3908 |
|
| 3922 |
CREATE TABLE address ( |
|
| 3923 |
address_id int(11) NOT NULL, |
|
| 3924 |
party_id int(11) NOT NULL, |
|
| 3925 |
organization_id int(11), |
|
| 3926 |
orgposition varchar(255), |
|
| 3927 |
email varchar(255), |
|
| 3928 |
street varchar(255), |
|
| 3929 |
street2 varchar(255), |
|
| 3930 |
city varchar(255), |
|
| 3931 |
stateprovince varchar(255), |
|
| 3932 |
postalcode varchar(255), |
|
| 3933 |
country varchar(255), |
|
| 3934 |
currentflag int(1), |
|
| 3935 |
addressstartdate date |
|
| 3936 |
); |
|
| 3937 | 3909 |
|
| 3938 | 3910 |
|
| 3911 |
|
|
| 3939 | 3912 |
-- |
| 3940 |
-- Name: address_address_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 3913 |
-- Name: COLUMN analytical_stem_view.geovalid_bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 3941 | 3914 |
-- |
| 3942 | 3915 |
|
| 3943 | 3916 |
|
| 3944 | 3917 |
|
| 3945 | 3918 |
|
| 3946 | 3919 |
-- |
| 3947 |
-- Name: address_address_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 3920 |
-- Name: COLUMN analytical_stem_view.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3948 | 3921 |
-- |
| 3949 | 3922 |
|
| 3950 | 3923 |
|
| 3951 | 3924 |
|
| 3952 | 3925 |
|
| 3953 | 3926 |
-- |
| 3954 |
-- Name: aggregateoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 3927 |
-- Name: COLUMN analytical_stem_view.`projectID__@VegX__.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3955 | 3928 |
-- |
| 3956 | 3929 |
|
| 3957 |
CREATE TABLE aggregateoccurrence ( |
|
| 3958 |
aggregateoccurrence_id int(11) NOT NULL, |
|
| 3959 |
source_id int(11) NOT NULL, |
|
| 3960 |
sourceaccessioncode varchar(255), |
|
| 3961 |
taxonoccurrence_id int(11), |
|
| 3962 |
collectiondate date, |
|
| 3963 |
cover_fraction double, |
|
| 3964 |
linecover_m double, |
|
| 3965 |
basalarea_m2 double, |
|
| 3966 |
biomass_kg_m2 double, |
|
| 3967 |
inferencearea_m2 double, |
|
| 3968 |
count int(11), |
|
| 3969 |
stratum_id int(11), |
|
| 3970 |
coverindex_id int(11), |
|
| 3971 |
occurrencestatus_dwc varchar(255) DEFAULT 'present' NOT NULL, |
|
| 3972 |
method_id int(11), |
|
| 3973 |
notes varchar(255) |
|
| 3974 |
); |
|
| 3975 | 3930 |
|
| 3976 | 3931 |
|
| 3932 |
|
|
| 3977 | 3933 |
-- |
| 3978 |
-- Name: TABLE aggregateoccurrence; Type: COMMENT; Schema: public; Owner: -
|
|
| 3934 |
-- Name: COLUMN analytical_stem_view.`projectContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3979 | 3935 |
-- |
| 3980 | 3936 |
|
| 3981 | 3937 |
|
| 3982 | 3938 |
|
| 3983 | 3939 |
|
| 3984 | 3940 |
-- |
| 3985 |
-- Name: COLUMN aggregateoccurrence.linecover_m; Type: COMMENT; Schema: public; Owner: -
|
|
| 3941 |
-- Name: COLUMN analytical_stem_view.`locationID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3986 | 3942 |
-- |
| 3987 | 3943 |
|
| 3988 | 3944 |
|
| 3989 | 3945 |
|
| 3990 | 3946 |
|
| 3991 | 3947 |
-- |
| 3992 |
-- Name: COLUMN aggregateoccurrence.occurrencestatus_dwc; Type: COMMENT; Schema: public; Owner: -
|
|
| 3948 |
-- Name: COLUMN analytical_stem_view.`plotName__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3993 | 3949 |
-- |
| 3994 | 3950 |
|
| 3995 | 3951 |
|
| 3996 | 3952 |
|
| 3997 | 3953 |
|
| 3998 | 3954 |
-- |
| 3999 |
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 3955 |
-- Name: COLUMN analytical_stem_view.`subplot__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4000 | 3956 |
-- |
| 4001 | 3957 |
|
| 4002 | 3958 |
|
| 4003 | 3959 |
|
| 4004 | 3960 |
|
| 4005 | 3961 |
-- |
| 4006 |
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 3962 |
-- Name: COLUMN analytical_stem_view.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 4007 | 3963 |
-- |
| 4008 | 3964 |
|
| 4009 | 3965 |
|
| 4010 | 3966 |
|
| 4011 | 3967 |
|
| 4012 | 3968 |
-- |
| 4013 |
-- Name: analytical_plot; Type: VIEW; Schema: public; Owner: -
|
|
| 3969 |
-- Name: COLUMN analytical_stem_view.`locationevent.locationevent_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4014 | 3970 |
-- |
| 4015 | 3971 |
|
| 4016 | 3972 |
|
| 4017 | 3973 |
|
| 4018 | 3974 |
|
| 4019 | 3975 |
-- |
| 4020 |
-- Name: COLUMN analytical_plot.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3976 |
-- Name: COLUMN analytical_stem_view.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4021 | 3977 |
-- |
| 4022 | 3978 |
|
| 4023 | 3979 |
|
| 4024 | 3980 |
|
| 4025 | 3981 |
|
| 4026 | 3982 |
-- |
| 4027 |
-- Name: COLUMN analytical_plot.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3983 |
-- Name: COLUMN analytical_stem_view.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4028 | 3984 |
-- |
| 4029 | 3985 |
|
| 4030 | 3986 |
|
| 4031 | 3987 |
|
| 4032 | 3988 |
|
| 4033 | 3989 |
-- |
| 4034 |
-- Name: COLUMN analytical_plot.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3990 |
-- Name: COLUMN analytical_stem_view.`slopeAspect[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4035 | 3991 |
-- |
| 4036 | 3992 |
|
| 4037 | 3993 |
|
| 4038 | 3994 |
|
| 4039 | 3995 |
|
| 4040 | 3996 |
-- |
| 4041 |
-- Name: COLUMN analytical_plot.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 3997 |
-- Name: COLUMN analytical_stem_view.`slopeGradient[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4042 | 3998 |
-- |
| 4043 | 3999 |
|
| 4044 | 4000 |
|
| 4045 | 4001 |
|
| 4046 | 4002 |
|
| 4047 | 4003 |
-- |
| 4048 |
-- Name: COLUMN analytical_plot.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4004 |
-- Name: COLUMN analytical_stem_view.`plot.area[_ha]__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4049 | 4005 |
-- |
| 4050 | 4006 |
|
| 4051 | 4007 |
|
| 4052 | 4008 |
|
| 4053 | 4009 |
|
| 4054 | 4010 |
-- |
| 4055 |
-- Name: COLUMN analytical_plot.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4011 |
-- Name: COLUMN analytical_stem_view.`samplingProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4056 | 4012 |
-- |
| 4057 | 4013 |
|
| 4058 | 4014 |
|
| 4059 | 4015 |
|
| 4060 | 4016 |
|
| 4061 | 4017 |
-- |
| 4062 |
-- Name: COLUMN analytical_plot.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4018 |
-- Name: COLUMN analytical_stem_view.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4063 | 4019 |
-- |
| 4064 | 4020 |
|
| 4065 | 4021 |
|
| 4066 | 4022 |
|
| 4067 | 4023 |
|
| 4068 | 4024 |
-- |
| 4069 |
-- Name: COLUMN analytical_plot.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4025 |
-- Name: COLUMN analytical_stem_view.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4070 | 4026 |
-- |
| 4071 | 4027 |
|
| 4072 | 4028 |
|
| 4073 | 4029 |
|
| 4074 | 4030 |
|
| 4075 | 4031 |
-- |
| 4076 |
-- Name: COLUMN analytical_plot.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4032 |
-- Name: COLUMN analytical_stem_view.`stratumName__@VegX__.stratum@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4077 | 4033 |
-- |
| 4078 | 4034 |
|
| 4079 | 4035 |
|
| 4080 | 4036 |
|
| 4081 | 4037 |
|
| 4082 | 4038 |
-- |
| 4083 |
-- Name: COLUMN analytical_plot.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4039 |
-- Name: COLUMN analytical_stem_view.`communityConcept.name__@VegX__.communityDet@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4084 | 4040 |
-- |
| 4085 | 4041 |
|
| 4086 | 4042 |
|
| 4087 | 4043 |
|
| 4088 | 4044 |
|
| 4089 | 4045 |
-- |
| 4090 |
-- Name: COLUMN analytical_plot.geovalid_bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 4046 |
-- Name: COLUMN analytical_stem_view.`observationContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4091 | 4047 |
-- |
| 4092 | 4048 |
|
| 4093 | 4049 |
|
| 4094 | 4050 |
|
| 4095 | 4051 |
|
| 4096 | 4052 |
-- |
| 4097 |
-- Name: COLUMN analytical_plot.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4053 |
-- Name: COLUMN analytical_stem_view.`[custodial_]institutionCode[s]__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4098 | 4054 |
-- |
| 4099 | 4055 |
|
| 4100 | 4056 |
|
| 4101 | 4057 |
|
| 4102 | 4058 |
|
| 4103 | 4059 |
-- |
| 4104 |
-- Name: COLUMN analytical_plot.`projectID__@VegX__.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4060 |
-- Name: COLUMN analytical_stem_view.`collectionCode__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4105 | 4061 |
-- |
| 4106 | 4062 |
|
| 4107 | 4063 |
|
| 4108 | 4064 |
|
| 4109 | 4065 |
|
| 4110 | 4066 |
-- |
| 4111 |
-- Name: COLUMN analytical_plot.`projectContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4067 |
-- Name: COLUMN analytical_stem_view.`catalogNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4112 | 4068 |
-- |
| 4113 | 4069 |
|
| 4114 | 4070 |
|
| 4115 | 4071 |
|
| 4116 | 4072 |
|
| 4117 | 4073 |
-- |
| 4118 |
-- Name: COLUMN analytical_plot.`locationID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4074 |
-- Name: COLUMN analytical_stem_view.`occurrenceID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4119 | 4075 |
-- |
| 4120 | 4076 |
|
| 4121 | 4077 |
|
| 4122 | 4078 |
|
| 4123 | 4079 |
|
| 4124 | 4080 |
-- |
| 4125 |
-- Name: COLUMN analytical_plot.`plotName__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4081 |
-- Name: COLUMN analytical_stem_view.`recordedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4126 | 4082 |
-- |
| 4127 | 4083 |
|
| 4128 | 4084 |
|
| 4129 | 4085 |
|
| 4130 | 4086 |
|
| 4131 | 4087 |
-- |
| 4132 |
-- Name: COLUMN analytical_plot.`subplot__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4088 |
-- Name: COLUMN analytical_stem_view.`recordNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4133 | 4089 |
-- |
| 4134 | 4090 |
|
| 4135 | 4091 |
|
| 4136 | 4092 |
|
| 4137 | 4093 |
|
| 4138 | 4094 |
-- |
| 4139 |
-- Name: COLUMN analytical_plot.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 4095 |
-- Name: COLUMN analytical_stem_view.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4140 | 4096 |
-- |
| 4141 | 4097 |
|
| 4142 | 4098 |
|
| 4143 | 4099 |
|
| 4144 | 4100 |
|
| 4145 | 4101 |
-- |
| 4146 |
-- Name: COLUMN analytical_plot.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4102 |
-- Name: COLUMN analytical_stem_view.`[verbatim_]family__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4147 | 4103 |
-- |
| 4148 | 4104 |
|
| 4149 | 4105 |
|
| 4150 | 4106 |
|
| 4151 | 4107 |
|
| 4152 | 4108 |
-- |
| 4153 |
-- Name: COLUMN analytical_plot.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4109 |
-- Name: COLUMN analytical_stem_view.`[verbatim_]scientificName__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4154 | 4110 |
-- |
| 4155 | 4111 |
|
| 4156 | 4112 |
|
| 4157 | 4113 |
|
| 4158 | 4114 |
|
| 4159 | 4115 |
-- |
| 4160 |
-- Name: COLUMN analytical_plot.`slopeAspect[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4116 |
-- Name: COLUMN analytical_stem_view.`identifiedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4161 | 4117 |
-- |
| 4162 | 4118 |
|
| 4163 | 4119 |
|
| 4164 | 4120 |
|
| 4165 | 4121 |
|
| 4166 | 4122 |
-- |
| 4167 |
-- Name: COLUMN analytical_plot.`slopeGradient[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4123 |
-- Name: COLUMN analytical_stem_view.`dateIdentified__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4168 | 4124 |
-- |
| 4169 | 4125 |
|
| 4170 | 4126 |
|
| 4171 | 4127 |
|
| 4172 | 4128 |
|
| 4173 | 4129 |
-- |
| 4174 |
-- Name: COLUMN analytical_plot.`plot.area[_ha]__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4130 |
-- Name: COLUMN analytical_stem_view.`identificationRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4175 | 4131 |
-- |
| 4176 | 4132 |
|
| 4177 | 4133 |
|
| 4178 | 4134 |
|
| 4179 | 4135 |
|
| 4180 | 4136 |
-- |
| 4181 |
-- Name: COLUMN analytical_plot.`samplingProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4137 |
-- Name: COLUMN analytical_stem_view.`Family_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4182 | 4138 |
-- |
| 4183 | 4139 |
|
| 4184 | 4140 |
|
| 4185 | 4141 |
|
| 4186 | 4142 |
|
| 4187 | 4143 |
-- |
| 4188 |
-- Name: COLUMN analytical_plot.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4144 |
-- Name: COLUMN analytical_stem_view.`Name_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4189 | 4145 |
-- |
| 4190 | 4146 |
|
| 4191 | 4147 |
|
| 4192 | 4148 |
|
| 4193 | 4149 |
|
| 4194 | 4150 |
-- |
| 4195 |
-- Name: COLUMN analytical_plot.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4151 |
-- Name: COLUMN analytical_stem_view.`Name_matched_author__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4196 | 4152 |
-- |
| 4197 | 4153 |
|
| 4198 | 4154 |
|
| 4199 | 4155 |
|
| 4200 | 4156 |
|
| 4201 | 4157 |
-- |
| 4202 |
-- Name: COLUMN analytical_plot.`stratumName__@VegX__.stratum@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4158 |
-- Name: COLUMN analytical_stem_view.`[higher_plant_group~]higherClassification__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4203 | 4159 |
-- |
| 4204 | 4160 |
|
| 4205 | 4161 |
|
| 4206 | 4162 |
|
| 4207 | 4163 |
|
| 4208 | 4164 |
-- |
| 4209 |
-- Name: COLUMN analytical_plot.`communityConcept.name__@VegX__.communityDet@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4165 |
-- Name: COLUMN analytical_stem_view.`taxonomicStatus__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4210 | 4166 |
-- |
| 4211 | 4167 |
|
| 4212 | 4168 |
|
| 4213 | 4169 |
|
| 4214 | 4170 |
|
| 4215 | 4171 |
-- |
| 4216 |
-- Name: COLUMN analytical_plot.`observationContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4172 |
-- Name: COLUMN analytical_stem_view.scrubbed_family; Type: COMMENT; Schema: public; Owner: -
|
|
| 4217 | 4173 |
-- |
| 4218 | 4174 |
|
| 4219 | 4175 |
|
| 4220 | 4176 |
|
| 4221 | 4177 |
|
| 4222 | 4178 |
-- |
| 4223 |
-- Name: COLUMN analytical_plot.`recordedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4179 |
-- Name: COLUMN analytical_stem_view.scrubbed_genus; Type: COMMENT; Schema: public; Owner: -
|
|
| 4224 | 4180 |
-- |
| 4225 | 4181 |
|
| 4226 | 4182 |
|
| 4227 | 4183 |
|
| 4228 | 4184 |
|
| 4229 | 4185 |
-- |
| 4230 |
-- Name: COLUMN analytical_plot.`recordNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4186 |
-- Name: COLUMN analytical_stem_view.scrubbed_specific_epithet; Type: COMMENT; Schema: public; Owner: -
|
|
| 4231 | 4187 |
-- |
| 4232 | 4188 |
|
| 4233 | 4189 |
|
| 4234 | 4190 |
|
| 4235 | 4191 |
|
| 4236 | 4192 |
-- |
| 4237 |
-- Name: COLUMN analytical_plot.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4193 |
-- Name: COLUMN analytical_stem_view.scrubbed_species_binomial; Type: COMMENT; Schema: public; Owner: -
|
|
| 4238 | 4194 |
-- |
| 4239 | 4195 |
|
| 4240 | 4196 |
|
| 4241 | 4197 |
|
| 4242 | 4198 |
|
| 4243 | 4199 |
-- |
| 4244 |
-- Name: COLUMN analytical_plot.`[verbatim_]family__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4200 |
-- Name: COLUMN analytical_stem_view.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: -
|
|
| 4245 | 4201 |
-- |
| 4246 | 4202 |
|
| 4247 | 4203 |
|
| 4248 | 4204 |
|
| 4249 | 4205 |
|
| 4250 | 4206 |
-- |
| 4251 |
-- Name: COLUMN analytical_plot.`[verbatim_]scientificName__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4207 |
-- Name: COLUMN analytical_stem_view.scrubbed_author; Type: COMMENT; Schema: public; Owner: -
|
|
| 4252 | 4208 |
-- |
| 4253 | 4209 |
|
| 4254 | 4210 |
|
| 4255 | 4211 |
|
| 4256 | 4212 |
|
| 4257 | 4213 |
-- |
| 4258 |
-- Name: COLUMN analytical_plot.`identifiedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4214 |
-- Name: COLUMN analytical_stem_view.scrubbed_taxon_name_with_author; Type: COMMENT; Schema: public; Owner: -
|
|
| 4259 | 4215 |
-- |
| 4260 | 4216 |
|
| 4261 | 4217 |
|
| 4262 | 4218 |
|
| 4263 | 4219 |
|
| 4264 | 4220 |
-- |
| 4265 |
-- Name: COLUMN analytical_plot.`dateIdentified__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4221 |
-- Name: COLUMN analytical_stem_view.`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4266 | 4222 |
-- |
| 4267 | 4223 |
|
| 4268 | 4224 |
|
| 4269 | 4225 |
|
| 4270 | 4226 |
|
| 4271 | 4227 |
-- |
| 4272 |
-- Name: COLUMN analytical_plot.`identificationRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4228 |
-- Name: COLUMN analytical_stem_view.`[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4273 | 4229 |
-- |
| 4274 | 4230 |
|
| 4275 | 4231 |
|
| 4276 | 4232 |
|
| 4277 | 4233 |
|
| 4278 | 4234 |
-- |
| 4279 |
-- Name: COLUMN analytical_plot.`Family_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4235 |
-- Name: COLUMN analytical_stem_view.`reproductiveCondition__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4280 | 4236 |
-- |
| 4281 | 4237 |
|
| 4282 | 4238 |
|
| 4283 | 4239 |
|
| 4284 | 4240 |
|
| 4285 | 4241 |
-- |
| 4286 |
-- Name: COLUMN analytical_plot.`Name_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4242 |
-- Name: COLUMN analytical_stem_view.cultivated_bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 4287 | 4243 |
-- |
| 4288 | 4244 |
|
| 4289 | 4245 |
|
| 4290 | 4246 |
|
| 4291 | 4247 |
|
| 4292 | 4248 |
-- |
| 4293 |
-- Name: COLUMN analytical_plot.`Name_matched_author__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4249 |
-- Name: COLUMN analytical_stem_view.`cultivatedBasis_bien`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4294 | 4250 |
-- |
| 4295 | 4251 |
|
| 4296 | 4252 |
|
| 4297 | 4253 |
|
| 4298 | 4254 |
|
| 4299 | 4255 |
-- |
| 4300 |
-- Name: COLUMN analytical_plot.scrubbed_family; Type: COMMENT; Schema: public; Owner: -
|
|
| 4256 |
-- Name: COLUMN analytical_stem_view.`occurrenceRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4301 | 4257 |
-- |
| 4302 | 4258 |
|
| 4303 | 4259 |
|
| 4304 | 4260 |
|
| 4305 | 4261 |
|
| 4306 | 4262 |
-- |
| 4307 |
-- Name: COLUMN analytical_plot.scrubbed_genus; Type: COMMENT; Schema: public; Owner: -
|
|
| 4263 |
-- Name: COLUMN analytical_stem_view.`coverPercent__@VegX__.attribute.ordinal@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4308 | 4264 |
-- |
| 4309 | 4265 |
|
| 4310 | 4266 |
|
| 4311 | 4267 |
|
| 4312 | 4268 |
|
| 4313 | 4269 |
-- |
| 4314 |
-- Name: COLUMN analytical_plot.`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4270 |
-- Name: COLUMN analytical_stem_view.`taxonObservation[.id]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4315 | 4271 |
-- |
| 4316 | 4272 |
|
| 4317 | 4273 |
|
| 4318 | 4274 |
|
| 4319 | 4275 |
|
| 4320 | 4276 |
-- |
| 4321 |
-- Name: COLUMN analytical_plot.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: -
|
|
| 4277 |
-- Name: COLUMN analytical_stem_view.`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4322 | 4278 |
-- |
| 4323 | 4279 |
|
| 4324 | 4280 |
|
| 4325 | 4281 |
|
| 4326 | 4282 |
|
| 4327 | 4283 |
-- |
| 4328 |
-- Name: COLUMN analytical_plot.scrubbed_author; Type: COMMENT; Schema: public; Owner: -
|
|
| 4284 |
-- Name: COLUMN analytical_stem_view.`aggregateOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4329 | 4285 |
-- |
| 4330 | 4286 |
|
| 4331 | 4287 |
|
| 4332 | 4288 |
|
| 4333 | 4289 |
|
| 4334 | 4290 |
-- |
| 4335 |
-- Name: COLUMN analytical_plot.`[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4291 |
-- Name: COLUMN analytical_stem_view.`individualOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4336 | 4292 |
-- |
| 4337 | 4293 |
|
| 4338 | 4294 |
|
| 4339 | 4295 |
|
| 4340 | 4296 |
|
| 4341 | 4297 |
-- |
| 4342 |
-- Name: COLUMN analytical_plot.`reproductiveCondition__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4298 |
-- Name: COLUMN analytical_stem_view.`individualID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4343 | 4299 |
-- |
| 4344 | 4300 |
|
| 4345 | 4301 |
|
| 4346 | 4302 |
|
| 4347 | 4303 |
|
| 4348 | 4304 |
-- |
| 4349 |
-- Name: COLUMN analytical_plot.cultivated_bien; Type: COMMENT; Schema: public; Owner: -
|
|
| 4305 |
-- Name: COLUMN analytical_stem_view.`individualCount__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4350 | 4306 |
-- |
| 4351 | 4307 |
|
| 4352 | 4308 |
|
| 4353 | 4309 |
|
| 4354 | 4310 |
|
| 4355 | 4311 |
-- |
| 4356 |
-- Name: COLUMN analytical_plot.`cultivatedBasis_bien`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4312 |
-- Name: COLUMN analytical_stem_view.`stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4357 | 4313 |
-- |
| 4358 | 4314 |
|
| 4359 | 4315 |
|
| 4360 | 4316 |
|
| 4361 | 4317 |
|
| 4362 | 4318 |
-- |
| 4363 |
-- Name: COLUMN analytical_plot.`occurrenceRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4319 |
-- Name: COLUMN analytical_stem_view.`stemHeight[_m]__@VegBank__.stemCount@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4364 | 4320 |
-- |
| 4365 | 4321 |
|
| 4366 | 4322 |
|
| 4367 | 4323 |
|
| 4368 | 4324 |
|
| 4369 | 4325 |
-- |
| 4370 |
-- Name: COLUMN analytical_plot.`coverPercent__@VegX__.attribute.ordinal@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4326 |
-- Name: COLUMN analytical_stem_view.`[tag=]identificationLabel__@VegX__.individual@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4371 | 4327 |
-- |
| 4372 | 4328 |
|
| 4373 | 4329 |
|
| 4374 | 4330 |
|
| 4375 | 4331 |
|
| 4376 | 4332 |
-- |
| 4377 |
-- Name: COLUMN analytical_plot.`stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4333 |
-- Name: COLUMN analytical_stem_view.`relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4378 | 4334 |
-- |
| 4379 | 4335 |
|
| 4380 | 4336 |
|
| 4381 | 4337 |
|
| 4382 | 4338 |
|
| 4383 | 4339 |
-- |
| 4384 |
-- Name: COLUMN analytical_plot.`stemHeight[_m]__@VegBank__.stemCount@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4340 |
-- Name: COLUMN analytical_stem_view.`relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4385 | 4341 |
-- |
| 4386 | 4342 |
|
| 4387 | 4343 |
|
| 4388 | 4344 |
|
| 4389 | 4345 |
|
| 4390 | 4346 |
-- |
| 4391 |
-- Name: COLUMN analytical_plot.`[tag=]identificationLabel__@VegX__.individual@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4347 |
-- Name: COLUMN analytical_stem_view.`stemCode__@VegBank__.stemLocation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4392 | 4348 |
-- |
| 4393 | 4349 |
|
| 4394 | 4350 |
|
| 4395 | 4351 |
|
| 4396 | 4352 |
|
| 4397 | 4353 |
-- |
| 4398 |
-- Name: COLUMN analytical_plot.`relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4354 |
-- Name: 2013-10-18.Brian_Enquist.Canadensys; Type: VIEW; Schema: public; Owner: -
|
|
| 4399 | 4355 |
-- |
| 4400 | 4356 |
|
| 4401 | 4357 |
|
| 4402 | 4358 |
|
| 4403 | 4359 |
|
| 4404 | 4360 |
-- |
| 4405 |
-- Name: COLUMN analytical_plot.`relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4361 |
-- Name: 2013-7-10.Naia.range_limiting_factors; Type: VIEW; Schema: public; Owner: -
|
|
| 4406 | 4362 |
-- |
| 4407 | 4363 |
|
| 4408 | 4364 |
|
| 4409 | 4365 |
|
| 4410 | 4366 |
|
| 4411 | 4367 |
-- |
| 4412 |
-- Name: COLUMN analytical_plot.`taxonObservation[.id]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4368 |
-- Name: 2014-3-11.Jeff_Ott.climatic_range_determinants; Type: VIEW; Schema: public; Owner: -
|
|
| 4413 | 4369 |
-- |
| 4414 | 4370 |
|
| 4415 | 4371 |
|
| 4416 | 4372 |
|
| 4417 | 4373 |
|
| 4418 | 4374 |
-- |
| 4419 |
-- Name: COLUMN analytical_plot.`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4375 |
-- Name: 2014-6-12.Jeff_Ott.climatic_range_determinants; Type: VIEW; Schema: public; Owner: -
|
|
| 4420 | 4376 |
-- |
| 4421 | 4377 |
|
| 4422 | 4378 |
|
| 4423 | 4379 |
|
| 4424 | 4380 |
|
| 4425 | 4381 |
-- |
| 4426 |
-- Name: COLUMN analytical_plot.`aggregateOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4382 |
-- Name: iucn_red_list; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 4427 | 4383 |
-- |
| 4428 | 4384 |
|
| 4385 |
CREATE TABLE iucn_red_list ( |
|
| 4386 |
accepted_family varchar(255) NOT NULL, |
|
| 4387 |
accepted_species_binomial varchar(255) NOT NULL |
|
| 4388 |
); |
|
| 4429 | 4389 |
|
| 4430 | 4390 |
|
| 4431 |
|
|
| 4432 | 4391 |
-- |
| 4433 |
-- Name: COLUMN analytical_plot.`individualOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4392 |
-- Name: source; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 4434 | 4393 |
-- |
| 4435 | 4394 |
|
| 4395 |
CREATE TABLE source ( |
|
| 4396 |
source_id int(11) NOT NULL, |
|
| 4397 |
matched_source_id int(11), |
|
| 4398 |
parent_id int(11), |
|
| 4399 |
shortname varchar(255) NOT NULL, |
|
| 4400 |
citation varchar(255), |
|
Also available in: Unified diff
schemas/public_.sql: derived views: use analytical_stem_view instead of analytical_stem because analytical_stem is no longer materialized (viewFullOccurrence_individual_view is materialized instead)