Revision 14441
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.my.sql | ||
|---|---|---|
| 8349 | 8349 |
|
| 8350 | 8350 |
|
| 8351 | 8351 |
-- |
| 8352 |
-- Name: viewFullOccurrence_individual; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 8353 |
-- |
|
| 8354 |
|
|
| 8355 |
CREATE TABLE `viewFullOccurrence_individual` ( |
|
| 8356 |
`datasource__@Brad__.identifier_examples@vegpath.org` varchar(255) NOT NULL, |
|
| 8357 |
`country__@DwC__@vegpath.org` varchar(255), |
|
| 8358 |
`stateProvince__@DwC__@vegpath.org` varchar(255), |
|
| 8359 |
`county__@DwC__@vegpath.org` varchar(255), |
|
| 8360 |
`locality__@DwC__@vegpath.org` varchar(255), |
|
| 8361 |
`decimalLatitude__@DwC__@vegpath.org` double, |
|
| 8362 |
`decimalLongitude__@DwC__@vegpath.org` double, |
|
| 8363 |
`coordinateUncertaintyInMeters__@DwC__@vegpath.org` double, |
|
| 8364 |
`georeferenceSources__@DwC__@vegpath.org` coordinatesource, |
|
| 8365 |
`georeferenceProtocol__@DwC__@vegpath.org` varchar(255), |
|
| 8366 |
geovalid_bien int(11), |
|
| 8367 |
`isNewWorld_bien` int(11), |
|
| 8368 |
`projectID__@VegX__.plotObservation@vegpath.org` varchar(255), |
|
| 8369 |
`projectContributor[s]__@VegBank__@vegpath.org` varchar(255), |
|
| 8370 |
`locationID__@DwC__@vegpath.org` varchar(255) NOT NULL, |
|
| 8371 |
`plotName__@VegX__.plot@vegpath.org` varchar(255), |
|
| 8372 |
`subplot__@SALVIAS__.Plot_data@vegpath.org` varchar(255), |
|
| 8373 |
location__cultivated__bien int(1), |
|
| 8374 |
`locationevent.locationevent_id__@VegBIEN__.public@vegpath.org` int(11), |
|
| 8375 |
`eventDate__@DwC__@vegpath.org` date, |
|
| 8376 |
`(-minimum-)ElevationInMeters__@DwC__@vegpath.org` double, |
|
| 8377 |
`slopeAspect[_deg]__@VegX__.plot@vegpath.org` double, |
|
| 8378 |
`slopeGradient[_deg]__@VegX__.plot@vegpath.org` double, |
|
| 8379 |
`plot.area[_ha]__@VegX__@vegpath.org` double, |
|
| 8380 |
`samplingProtocol__@DwC__@vegpath.org` varchar(255), |
|
| 8381 |
`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org` double, |
|
| 8382 |
`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org` double, |
|
| 8383 |
`stratumName__@VegX__.stratum@vegpath.org` varchar(255), |
|
| 8384 |
`communityConcept.name__@VegX__.communityDet@vegpath.org` varchar(255), |
|
| 8385 |
`observationContributor[s]__@VegBank__@vegpath.org` varchar(255), |
|
| 8386 |
`[custodial_]institutionCode[s]__@DwC__@vegpath.org` varchar(255), |
|
| 8387 |
`collectionCode__@DwC__@vegpath.org` varchar(255), |
|
| 8388 |
`catalogNumber__@DwC__@vegpath.org` varchar(255), |
|
| 8389 |
`occurrenceID__@DwC__@vegpath.org` varchar(255), |
|
| 8390 |
`recordedBy__@DwC__@vegpath.org` varchar(255), |
|
| 8391 |
`recordNumber__@DwC__@vegpath.org` varchar(255), |
|
| 8392 |
`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org` date, |
|
| 8393 |
`[verbatim_]family__@DwC__@vegpath.org` varchar(255), |
|
| 8394 |
`[verbatim_]scientificName__@DwC__@vegpath.org` varchar(255), |
|
| 8395 |
`identifiedBy__@DwC__@vegpath.org` varchar(255), |
|
| 8396 |
`dateIdentified__@DwC__@vegpath.org` date, |
|
| 8397 |
`identificationRemarks__@DwC__@vegpath.org` varchar(255), |
|
| 8398 |
`Family_matched__@TNRS__@vegpath.org` varchar(255), |
|
| 8399 |
`Name_matched__@TNRS__@vegpath.org` varchar(255), |
|
| 8400 |
`Name_matched_author__@TNRS__@vegpath.org` varchar(255), |
|
| 8401 |
`[higher_plant_group~]higherClassification__@DwC__@vegpath.org` higher_plant_group, |
|
| 8402 |
`taxonomicStatus__@DwC__@vegpath.org` varchar(255), |
|
| 8403 |
scrubbed_family varchar(255), |
|
| 8404 |
scrubbed_genus varchar(255), |
|
| 8405 |
scrubbed_specific_epithet varchar(255), |
|
| 8406 |
scrubbed_species_binomial varchar(255), |
|
| 8407 |
scrubbed_taxon_name_no_author varchar(255), |
|
| 8408 |
scrubbed_author varchar(255), |
|
| 8409 |
scrubbed_taxon_name_with_author varchar(255), |
|
| 8410 |
`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org` varchar(255), |
|
| 8411 |
`[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org` growthform, |
|
| 8412 |
`reproductiveCondition__@DwC__@vegpath.org` varchar(255), |
|
| 8413 |
cultivated_bien int(11), |
|
| 8414 |
`cultivatedBasis_bien` varchar(255), |
|
| 8415 |
`occurrenceRemarks__@DwC__@vegpath.org` varchar(255), |
|
| 8416 |
`coverPercent__@VegX__.attribute.ordinal@vegpath.org` double, |
|
| 8417 |
`taxonObservation[.id]__@VegBank__@vegpath.org` varchar(255), |
|
| 8418 |
`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org` varchar(255), |
|
| 8419 |
`aggregateOrganismObservation.id__@VegX__@vegpath.org` varchar(255), |
|
| 8420 |
`individualOrganismObservation.id__@VegX__@vegpath.org` varchar(255), |
|
| 8421 |
`individualID__@DwC__@vegpath.org` varchar(255), |
|
| 8422 |
`individualCount__@DwC__@vegpath.org` int(11), |
|
| 8423 |
`plantobservation.``_id__@VegBIEN__.public@vegpath.org` int(11), |
|
| 8424 |
`TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org` int(11) NOT NULL |
|
| 8425 |
); |
|
| 8426 |
|
|
| 8427 |
|
|
| 8428 |
-- |
|
| 8429 |
-- Name: COLUMN `viewFullOccurrence_individual`.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8430 |
-- |
|
| 8431 |
|
|
| 8432 |
|
|
| 8433 |
|
|
| 8434 |
|
|
| 8435 |
-- |
|
| 8436 |
-- Name: COLUMN `viewFullOccurrence_individual`.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8437 |
-- |
|
| 8438 |
|
|
| 8439 |
|
|
| 8440 |
|
|
| 8441 |
|
|
| 8442 |
-- |
|
| 8443 |
-- Name: COLUMN `viewFullOccurrence_individual`.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8444 |
-- |
|
| 8445 |
|
|
| 8446 |
|
|
| 8447 |
|
|
| 8448 |
|
|
| 8449 |
-- |
|
| 8450 |
-- Name: COLUMN `viewFullOccurrence_individual`.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8451 |
-- |
|
| 8452 |
|
|
| 8453 |
|
|
| 8454 |
|
|
| 8455 |
|
|
| 8456 |
-- |
|
| 8457 |
-- Name: COLUMN `viewFullOccurrence_individual`.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8458 |
-- |
|
| 8459 |
|
|
| 8460 |
|
|
| 8461 |
|
|
| 8462 |
|
|
| 8463 |
-- |
|
| 8464 |
-- Name: COLUMN `viewFullOccurrence_individual`.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8465 |
-- |
|
| 8466 |
|
|
| 8467 |
|
|
| 8468 |
|
|
| 8469 |
|
|
| 8470 |
-- |
|
| 8471 |
-- Name: COLUMN `viewFullOccurrence_individual`.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8472 |
-- |
|
| 8473 |
|
|
| 8474 |
|
|
| 8475 |
|
|
| 8476 |
|
|
| 8477 |
-- |
|
| 8478 |
-- Name: COLUMN `viewFullOccurrence_individual`.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8479 |
-- |
|
| 8480 |
|
|
| 8481 |
|
|
| 8482 |
|
|
| 8483 |
|
|
| 8484 |
-- |
|
| 8485 |
-- Name: COLUMN `viewFullOccurrence_individual`.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8486 |
-- |
|
| 8487 |
|
|
| 8488 |
|
|
| 8489 |
|
|
| 8490 |
|
|
| 8491 |
-- |
|
| 8492 |
-- Name: COLUMN `viewFullOccurrence_individual`.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8493 |
-- |
|
| 8494 |
|
|
| 8495 |
|
|
| 8496 |
|
|
| 8497 |
|
|
| 8498 |
-- |
|
| 8499 |
-- Name: COLUMN `viewFullOccurrence_individual`.geovalid_bien; Type: COMMENT; Schema: public; Owner: - |
|
| 8500 |
-- |
|
| 8501 |
|
|
| 8502 |
|
|
| 8503 |
|
|
| 8504 |
|
|
| 8505 |
-- |
|
| 8506 |
-- Name: COLUMN `viewFullOccurrence_individual`.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: - |
|
| 8507 |
-- |
|
| 8508 |
|
|
| 8509 |
|
|
| 8510 |
|
|
| 8511 |
|
|
| 8512 |
-- |
|
| 8513 |
-- Name: COLUMN `viewFullOccurrence_individual`.`projectID__@VegX__.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8514 |
-- |
|
| 8515 |
|
|
| 8516 |
|
|
| 8517 |
|
|
| 8518 |
|
|
| 8519 |
-- |
|
| 8520 |
-- Name: COLUMN `viewFullOccurrence_individual`.`projectContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8521 |
-- |
|
| 8522 |
|
|
| 8523 |
|
|
| 8524 |
|
|
| 8525 |
|
|
| 8526 |
-- |
|
| 8527 |
-- Name: COLUMN `viewFullOccurrence_individual`.`locationID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8528 |
-- |
|
| 8529 |
|
|
| 8530 |
|
|
| 8531 |
|
|
| 8532 |
|
|
| 8533 |
-- |
|
| 8534 |
-- Name: COLUMN `viewFullOccurrence_individual`.`plotName__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8535 |
-- |
|
| 8536 |
|
|
| 8537 |
|
|
| 8538 |
|
|
| 8539 |
|
|
| 8540 |
-- |
|
| 8541 |
-- Name: COLUMN `viewFullOccurrence_individual`.`subplot__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8542 |
-- |
|
| 8543 |
|
|
| 8544 |
|
|
| 8545 |
|
|
| 8546 |
|
|
| 8547 |
-- |
|
| 8548 |
-- Name: COLUMN `viewFullOccurrence_individual`.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: - |
|
| 8549 |
-- |
|
| 8550 |
|
|
| 8551 |
|
|
| 8552 |
|
|
| 8553 |
|
|
| 8554 |
-- |
|
| 8555 |
-- Name: COLUMN `viewFullOccurrence_individual`.`locationevent.locationevent_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8556 |
-- |
|
| 8557 |
|
|
| 8558 |
|
|
| 8559 |
|
|
| 8560 |
|
|
| 8561 |
-- |
|
| 8562 |
-- Name: COLUMN `viewFullOccurrence_individual`.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8563 |
-- |
|
| 8564 |
|
|
| 8565 |
|
|
| 8566 |
|
|
| 8567 |
|
|
| 8568 |
-- |
|
| 8569 |
-- Name: COLUMN `viewFullOccurrence_individual`.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8570 |
-- |
|
| 8571 |
|
|
| 8572 |
|
|
| 8573 |
|
|
| 8574 |
|
|
| 8575 |
-- |
|
| 8576 |
-- Name: COLUMN `viewFullOccurrence_individual`.`slopeAspect[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8577 |
-- |
|
| 8578 |
|
|
| 8579 |
|
|
| 8580 |
|
|
| 8581 |
|
|
| 8582 |
-- |
|
| 8583 |
-- Name: COLUMN `viewFullOccurrence_individual`.`slopeGradient[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8584 |
-- |
|
| 8585 |
|
|
| 8586 |
|
|
| 8587 |
|
|
| 8588 |
|
|
| 8589 |
-- |
|
| 8590 |
-- Name: COLUMN `viewFullOccurrence_individual`.`plot.area[_ha]__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8591 |
-- |
|
| 8592 |
|
|
| 8593 |
|
|
| 8594 |
|
|
| 8595 |
|
|
| 8596 |
-- |
|
| 8597 |
-- Name: COLUMN `viewFullOccurrence_individual`.`samplingProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8598 |
-- |
|
| 8599 |
|
|
| 8600 |
|
|
| 8601 |
|
|
| 8602 |
|
|
| 8603 |
-- |
|
| 8604 |
-- Name: COLUMN `viewFullOccurrence_individual`.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8605 |
-- |
|
| 8606 |
|
|
| 8607 |
|
|
| 8608 |
|
|
| 8609 |
|
|
| 8610 |
-- |
|
| 8611 |
-- Name: COLUMN `viewFullOccurrence_individual`.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8612 |
-- |
|
| 8613 |
|
|
| 8614 |
|
|
| 8615 |
|
|
| 8616 |
|
|
| 8617 |
-- |
|
| 8618 |
-- Name: COLUMN `viewFullOccurrence_individual`.`stratumName__@VegX__.stratum@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8619 |
-- |
|
| 8620 |
|
|
| 8621 |
|
|
| 8622 |
|
|
| 8623 |
|
|
| 8624 |
-- |
|
| 8625 |
-- Name: COLUMN `viewFullOccurrence_individual`.`communityConcept.name__@VegX__.communityDet@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8626 |
-- |
|
| 8627 |
|
|
| 8628 |
|
|
| 8629 |
|
|
| 8630 |
|
|
| 8631 |
-- |
|
| 8632 |
-- Name: COLUMN `viewFullOccurrence_individual`.`observationContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8633 |
-- |
|
| 8634 |
|
|
| 8635 |
|
|
| 8636 |
|
|
| 8637 |
|
|
| 8638 |
-- |
|
| 8639 |
-- Name: COLUMN `viewFullOccurrence_individual`.`[custodial_]institutionCode[s]__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8640 |
-- |
|
| 8641 |
|
|
| 8642 |
|
|
| 8643 |
|
|
| 8644 |
|
|
| 8645 |
-- |
|
| 8646 |
-- Name: COLUMN `viewFullOccurrence_individual`.`collectionCode__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8647 |
-- |
|
| 8648 |
|
|
| 8649 |
|
|
| 8650 |
|
|
| 8651 |
|
|
| 8652 |
-- |
|
| 8653 |
-- Name: COLUMN `viewFullOccurrence_individual`.`catalogNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8654 |
-- |
|
| 8655 |
|
|
| 8656 |
|
|
| 8657 |
|
|
| 8658 |
|
|
| 8659 |
-- |
|
| 8660 |
-- Name: COLUMN `viewFullOccurrence_individual`.`occurrenceID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8661 |
-- |
|
| 8662 |
|
|
| 8663 |
|
|
| 8664 |
|
|
| 8665 |
|
|
| 8666 |
-- |
|
| 8667 |
-- Name: COLUMN `viewFullOccurrence_individual`.`recordedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8668 |
-- |
|
| 8669 |
|
|
| 8670 |
|
|
| 8671 |
|
|
| 8672 |
|
|
| 8673 |
-- |
|
| 8674 |
-- Name: COLUMN `viewFullOccurrence_individual`.`recordNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8675 |
-- |
|
| 8676 |
|
|
| 8677 |
|
|
| 8678 |
|
|
| 8679 |
|
|
| 8680 |
-- |
|
| 8681 |
-- Name: COLUMN `viewFullOccurrence_individual`.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8682 |
-- |
|
| 8683 |
|
|
| 8684 |
|
|
| 8685 |
|
|
| 8686 |
|
|
| 8687 |
-- |
|
| 8688 |
-- Name: COLUMN `viewFullOccurrence_individual`.`[verbatim_]family__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8689 |
-- |
|
| 8690 |
|
|
| 8691 |
|
|
| 8692 |
|
|
| 8693 |
|
|
| 8694 |
-- |
|
| 8695 |
-- Name: COLUMN `viewFullOccurrence_individual`.`[verbatim_]scientificName__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8696 |
-- |
|
| 8697 |
|
|
| 8698 |
|
|
| 8699 |
|
|
| 8700 |
|
|
| 8701 |
-- |
|
| 8702 |
-- Name: COLUMN `viewFullOccurrence_individual`.`identifiedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8703 |
-- |
|
| 8704 |
|
|
| 8705 |
|
|
| 8706 |
|
|
| 8707 |
|
|
| 8708 |
-- |
|
| 8709 |
-- Name: COLUMN `viewFullOccurrence_individual`.`dateIdentified__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8710 |
-- |
|
| 8711 |
|
|
| 8712 |
|
|
| 8713 |
|
|
| 8714 |
|
|
| 8715 |
-- |
|
| 8716 |
-- Name: COLUMN `viewFullOccurrence_individual`.`identificationRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8717 |
-- |
|
| 8718 |
|
|
| 8719 |
|
|
| 8720 |
|
|
| 8721 |
|
|
| 8722 |
-- |
|
| 8723 |
-- Name: COLUMN `viewFullOccurrence_individual`.`Family_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8724 |
-- |
|
| 8725 |
|
|
| 8726 |
|
|
| 8727 |
|
|
| 8728 |
|
|
| 8729 |
-- |
|
| 8730 |
-- Name: COLUMN `viewFullOccurrence_individual`.`Name_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8731 |
-- |
|
| 8732 |
|
|
| 8733 |
|
|
| 8734 |
|
|
| 8735 |
|
|
| 8736 |
-- |
|
| 8737 |
-- Name: COLUMN `viewFullOccurrence_individual`.`Name_matched_author__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8738 |
-- |
|
| 8739 |
|
|
| 8740 |
|
|
| 8741 |
|
|
| 8742 |
|
|
| 8743 |
-- |
|
| 8744 |
-- Name: COLUMN `viewFullOccurrence_individual`.`[higher_plant_group~]higherClassification__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8745 |
-- |
|
| 8746 |
|
|
| 8747 |
|
|
| 8748 |
|
|
| 8749 |
|
|
| 8750 |
-- |
|
| 8751 |
-- Name: COLUMN `viewFullOccurrence_individual`.`taxonomicStatus__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8752 |
-- |
|
| 8753 |
|
|
| 8754 |
|
|
| 8755 |
|
|
| 8756 |
|
|
| 8757 |
-- |
|
| 8758 |
-- Name: COLUMN `viewFullOccurrence_individual`.scrubbed_family; Type: COMMENT; Schema: public; Owner: - |
|
| 8759 |
-- |
|
| 8760 |
|
|
| 8761 |
|
|
| 8762 |
|
|
| 8763 |
|
|
| 8764 |
-- |
|
| 8765 |
-- Name: COLUMN `viewFullOccurrence_individual`.scrubbed_genus; Type: COMMENT; Schema: public; Owner: - |
|
| 8766 |
-- |
|
| 8767 |
|
|
| 8768 |
|
|
| 8769 |
|
|
| 8770 |
|
|
| 8771 |
-- |
|
| 8772 |
-- Name: COLUMN `viewFullOccurrence_individual`.scrubbed_specific_epithet; Type: COMMENT; Schema: public; Owner: - |
|
| 8773 |
-- |
|
| 8774 |
|
|
| 8775 |
|
|
| 8776 |
|
|
| 8777 |
|
|
| 8778 |
-- |
|
| 8779 |
-- Name: COLUMN `viewFullOccurrence_individual`.scrubbed_species_binomial; Type: COMMENT; Schema: public; Owner: - |
|
| 8780 |
-- |
|
| 8781 |
|
|
| 8782 |
|
|
| 8783 |
|
|
| 8784 |
|
|
| 8785 |
-- |
|
| 8786 |
-- Name: COLUMN `viewFullOccurrence_individual`.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: - |
|
| 8787 |
-- |
|
| 8788 |
|
|
| 8789 |
|
|
| 8790 |
|
|
| 8791 |
|
|
| 8792 |
-- |
|
| 8793 |
-- Name: COLUMN `viewFullOccurrence_individual`.scrubbed_author; Type: COMMENT; Schema: public; Owner: - |
|
| 8794 |
-- |
|
| 8795 |
|
|
| 8796 |
|
|
| 8797 |
|
|
| 8798 |
|
|
| 8799 |
-- |
|
| 8800 |
-- Name: COLUMN `viewFullOccurrence_individual`.scrubbed_taxon_name_with_author; Type: COMMENT; Schema: public; Owner: - |
|
| 8801 |
-- |
|
| 8802 |
|
|
| 8803 |
|
|
| 8804 |
|
|
| 8805 |
|
|
| 8806 |
-- |
|
| 8807 |
-- Name: COLUMN `viewFullOccurrence_individual`.`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8808 |
-- |
|
| 8809 |
|
|
| 8810 |
|
|
| 8811 |
|
|
| 8812 |
|
|
| 8813 |
-- |
|
| 8814 |
-- Name: COLUMN `viewFullOccurrence_individual`.`[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8815 |
-- |
|
| 8816 |
|
|
| 8817 |
|
|
| 8818 |
|
|
| 8819 |
|
|
| 8820 |
-- |
|
| 8821 |
-- Name: COLUMN `viewFullOccurrence_individual`.`reproductiveCondition__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8822 |
-- |
|
| 8823 |
|
|
| 8824 |
|
|
| 8825 |
|
|
| 8826 |
|
|
| 8827 |
-- |
|
| 8828 |
-- Name: COLUMN `viewFullOccurrence_individual`.cultivated_bien; Type: COMMENT; Schema: public; Owner: - |
|
| 8829 |
-- |
|
| 8830 |
|
|
| 8831 |
|
|
| 8832 |
|
|
| 8833 |
|
|
| 8834 |
-- |
|
| 8835 |
-- Name: COLUMN `viewFullOccurrence_individual`.`cultivatedBasis_bien`; Type: COMMENT; Schema: public; Owner: - |
|
| 8836 |
-- |
|
| 8837 |
|
|
| 8838 |
|
|
| 8839 |
|
|
| 8840 |
|
|
| 8841 |
-- |
|
| 8842 |
-- Name: COLUMN `viewFullOccurrence_individual`.`occurrenceRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8843 |
-- |
|
| 8844 |
|
|
| 8845 |
|
|
| 8846 |
|
|
| 8847 |
|
|
| 8848 |
-- |
|
| 8849 |
-- Name: COLUMN `viewFullOccurrence_individual`.`coverPercent__@VegX__.attribute.ordinal@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8850 |
-- |
|
| 8851 |
|
|
| 8852 |
|
|
| 8853 |
|
|
| 8854 |
|
|
| 8855 |
-- |
|
| 8856 |
-- Name: COLUMN `viewFullOccurrence_individual`.`taxonObservation[.id]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8857 |
-- |
|
| 8858 |
|
|
| 8859 |
|
|
| 8860 |
|
|
| 8861 |
|
|
| 8862 |
-- |
|
| 8863 |
-- Name: COLUMN `viewFullOccurrence_individual`.`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8864 |
-- |
|
| 8865 |
|
|
| 8866 |
|
|
| 8867 |
|
|
| 8868 |
|
|
| 8869 |
-- |
|
| 8870 |
-- Name: COLUMN `viewFullOccurrence_individual`.`aggregateOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8871 |
-- |
|
| 8872 |
|
|
| 8873 |
|
|
| 8874 |
|
|
| 8875 |
|
|
| 8876 |
-- |
|
| 8877 |
-- Name: COLUMN `viewFullOccurrence_individual`.`individualOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8878 |
-- |
|
| 8879 |
|
|
| 8880 |
|
|
| 8881 |
|
|
| 8882 |
|
|
| 8883 |
-- |
|
| 8884 |
-- Name: COLUMN `viewFullOccurrence_individual`.`individualID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8885 |
-- |
|
| 8886 |
|
|
| 8887 |
|
|
| 8888 |
|
|
| 8889 |
|
|
| 8890 |
-- |
|
| 8891 |
-- Name: COLUMN `viewFullOccurrence_individual`.`individualCount__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8892 |
-- |
|
| 8893 |
|
|
| 8894 |
|
|
| 8895 |
|
|
| 8896 |
|
|
| 8897 |
-- |
|
| 8898 |
-- Name: COLUMN `viewFullOccurrence_individual`.`plantobservation.``_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8899 |
-- |
|
| 8900 |
|
|
| 8901 |
|
|
| 8902 |
|
|
| 8903 |
|
|
| 8904 |
-- |
|
| 8905 |
-- Name: COLUMN `viewFullOccurrence_individual`.`TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 8906 |
-- |
|
| 8907 |
|
|
| 8908 |
|
|
| 8909 |
|
|
| 8910 |
|
|
| 8911 |
-- |
|
| 8912 |
-- Name: viewFullOccurrence_individual_TAXONOBSERVATION_ID__@VegBank_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 8913 |
-- |
|
| 8914 |
|
|
| 8915 |
|
|
| 8916 |
|
|
| 8917 |
|
|
| 8918 |
-- |
|
| 8919 |
-- Name: viewFullOccurrence_individual_TAXONOBSERVATION_ID__@VegBank_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 8920 |
-- |
|
| 8921 |
|
|
| 8922 |
|
|
| 8923 |
|
|
| 8924 |
|
|
| 8925 |
-- |
|
| 8352 | 8926 |
-- Name: voucher; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 8353 | 8927 |
-- |
| 8354 | 8928 |
|
| ... | ... | |
| 9218 | 9792 |
|
| 9219 | 9793 |
|
| 9220 | 9794 |
-- |
| 9795 |
-- Name: TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org; Type: DEFAULT; Schema: public; Owner: - |
|
| 9796 |
-- |
|
| 9797 |
|
|
| 9798 |
|
|
| 9799 |
|
|
| 9800 |
|
|
| 9801 |
-- |
|
| 9221 | 9802 |
-- Name: voucher_id; Type: DEFAULT; Schema: public; Owner: - |
| 9222 | 9803 |
-- |
| 9223 | 9804 |
|
| ... | ... | |
| 11601 | 12182 |
|
| 11602 | 12183 |
|
| 11603 | 12184 |
-- |
| 12185 |
-- Data for Name: viewFullOccurrence_individual; Type: TABLE DATA; Schema: public; Owner: - |
|
| 12186 |
-- |
|
| 12187 |
|
|
| 12188 |
|
|
| 12189 |
|
|
| 12190 |
-- |
|
| 12191 |
-- Name: viewFullOccurrence_individual_TAXONOBSERVATION_ID__@VegBank_seq; Type: SEQUENCE SET; Schema: public; Owner: - |
|
| 12192 |
-- |
|
| 12193 |
|
|
| 12194 |
|
|
| 12195 |
|
|
| 12196 |
-- |
|
| 11604 | 12197 |
-- Data for Name: voucher; Type: TABLE DATA; Schema: public; Owner: - |
| 11605 | 12198 |
-- |
| 11606 | 12199 |
|
| ... | ... | |
| 12531 | 13124 |
|
| 12532 | 13125 |
|
| 12533 | 13126 |
-- |
| 13127 |
-- Name: viewFullOccurrence_individual_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 13128 |
-- |
|
| 13129 |
|
|
| 13130 |
ALTER TABLE `viewFullOccurrence_individual` |
|
| 13131 |
ADD CONSTRAINT `viewFullOccurrence_individual_pkey` PRIMARY KEY (`TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org`); |
|
| 13132 |
|
|
| 13133 |
|
|
| 13134 |
-- |
|
| 12534 | 13135 |
-- Name: voucher_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 12535 | 13136 |
-- |
| 12536 | 13137 |
|
| ... | ... | |
| 13674 | 14275 |
|
| 13675 | 14276 |
|
| 13676 | 14277 |
-- |
| 14278 |
-- Name: viewFullOccurrence_individual_datasource__@Brad__.identifi_idx1; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 14279 |
-- |
|
| 14280 |
|
|
| 14281 |
CREATE INDEX `viewFullOccurrence_individual_datasource__@Brad__.identifi_idx1` ON `viewFullOccurrence_individual` (`datasource__@Brad__.identifier_examples@vegpath.org`, `[custodial_]institutionCode[s]__@DwC__@vegpath.org`, `collectionCode__@DwC__@vegpath.org`, `catalogNumber__@DwC__@vegpath.org`); |
|
| 14282 |
|
|
| 14283 |
|
|
| 14284 |
-- |
|
| 14285 |
-- Name: viewFullOccurrence_individual_datasource__@Brad__.identifi_idx2; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 14286 |
-- |
|
| 14287 |
|
|
| 14288 |
CREATE INDEX `viewFullOccurrence_individual_datasource__@Brad__.identifi_idx2` ON `viewFullOccurrence_individual` (`datasource__@Brad__.identifier_examples@vegpath.org`, `projectID__@VegX__.plotObservation@vegpath.org`, `locationID__@DwC__@vegpath.org`, `eventDate__@DwC__@vegpath.org`); |
|
| 14289 |
|
|
| 14290 |
|
|
| 14291 |
-- |
|
| 14292 |
-- Name: viewFullOccurrence_individual_datasource__@Brad__.identifie_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 14293 |
-- |
|
| 14294 |
|
|
| 14295 |
CREATE INDEX `viewFullOccurrence_individual_datasource__@Brad__.identifie_idx` ON `viewFullOccurrence_individual` (`datasource__@Brad__.identifier_examples@vegpath.org`, `occurrenceID__@DwC__@vegpath.org`); |
|
| 14296 |
|
|
| 14297 |
|
|
| 14298 |
-- |
|
| 14299 |
-- Name: viewFullOccurrence_individual_speciesBinomialWithMorphospec_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 14300 |
-- |
|
| 14301 |
|
|
| 14302 |
CREATE INDEX `viewFullOccurrence_individual_speciesBinomialWithMorphospec_idx` ON `viewFullOccurrence_individual` (`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org`); |
|
| 14303 |
|
|
| 14304 |
|
|
| 14305 |
-- |
|
| 13677 | 14306 |
-- Name: voucher_specimenreplicate_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 13678 | 14307 |
-- |
| 13679 | 14308 |
|
| ... | ... | |
| 15788 | 16417 |
|
| 15789 | 16418 |
|
| 15790 | 16419 |
-- |
| 16420 |
-- Name: viewFullOccurrence_individual; Type: ACL; Schema: public; Owner: - |
|
| 16421 |
-- |
|
| 16422 |
|
|
| 16423 |
|
|
| 16424 |
|
|
| 16425 |
|
|
| 16426 |
|
|
| 16427 |
|
|
| 16428 |
|
|
| 16429 |
-- |
|
| 15791 | 16430 |
-- Name: voucher; Type: ACL; Schema: public; Owner: - |
| 15792 | 16431 |
-- |
| 15793 | 16432 |
|
Also available in: Unified diff
schemas/public_.sql: added viewFullOccurrence_individual by running viewFullOccurrence_individual_view_modify()