Revision 13705
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 4201 | 4201 |
|
| 4202 | 4202 |
|
| 4203 | 4203 |
-- |
| 4204 |
-- Name: COLUMN analytical_stem_view.`country@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4204 |
-- Name: COLUMN analytical_stem_view.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4205 | 4205 |
-- |
| 4206 | 4206 |
|
| 4207 | 4207 |
|
| 4208 | 4208 |
|
| 4209 | 4209 |
|
| 4210 | 4210 |
-- |
| 4211 |
-- Name: COLUMN analytical_stem_view.`stateProvince@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4211 |
-- Name: COLUMN analytical_stem_view.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4212 | 4212 |
-- |
| 4213 | 4213 |
|
| 4214 | 4214 |
|
| 4215 | 4215 |
|
| 4216 | 4216 |
|
| 4217 | 4217 |
-- |
| 4218 |
-- Name: COLUMN analytical_stem_view.`county@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4218 |
-- Name: COLUMN analytical_stem_view.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4219 | 4219 |
-- |
| 4220 | 4220 |
|
| 4221 | 4221 |
|
| 4222 | 4222 |
|
| 4223 | 4223 |
|
| 4224 | 4224 |
-- |
| 4225 |
-- Name: COLUMN analytical_stem_view.`locality@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4225 |
-- Name: COLUMN analytical_stem_view.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4226 | 4226 |
-- |
| 4227 | 4227 |
|
| 4228 | 4228 |
|
| 4229 | 4229 |
|
| 4230 | 4230 |
|
| 4231 | 4231 |
-- |
| 4232 |
-- Name: COLUMN analytical_stem_view.`decimalLatitude@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4232 |
-- Name: COLUMN analytical_stem_view.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4233 | 4233 |
-- |
| 4234 | 4234 |
|
| 4235 | 4235 |
|
| 4236 | 4236 |
|
| 4237 | 4237 |
|
| 4238 | 4238 |
-- |
| 4239 |
-- Name: COLUMN analytical_stem_view.`decimalLongitude@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4239 |
-- Name: COLUMN analytical_stem_view.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4240 | 4240 |
-- |
| 4241 | 4241 |
|
| 4242 | 4242 |
|
| 4243 | 4243 |
|
| 4244 | 4244 |
|
| 4245 | 4245 |
-- |
| 4246 |
-- Name: COLUMN analytical_stem_view.`coordinateUncertaintyInMeters@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4246 |
-- Name: COLUMN analytical_stem_view.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4247 | 4247 |
-- |
| 4248 | 4248 |
|
| 4249 | 4249 |
|
| ... | ... | |
| 4278 | 4278 |
|
| 4279 | 4279 |
|
| 4280 | 4280 |
-- |
| 4281 |
-- Name: COLUMN analytical_stem_view.`projectID@VegX.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4281 |
-- Name: COLUMN analytical_stem_view.`projectID__@VegX__.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4282 | 4282 |
-- |
| 4283 | 4283 |
|
| 4284 | 4284 |
|
| ... | ... | |
| 4292 | 4292 |
|
| 4293 | 4293 |
|
| 4294 | 4294 |
-- |
| 4295 |
-- Name: COLUMN analytical_stem_view.`locationID@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4295 |
-- Name: COLUMN analytical_stem_view.`locationID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4296 | 4296 |
-- |
| 4297 | 4297 |
|
| 4298 | 4298 |
|
| 4299 | 4299 |
|
| 4300 | 4300 |
|
| 4301 | 4301 |
-- |
| 4302 |
-- Name: COLUMN analytical_stem_view.`plotName@VegX.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4302 |
-- Name: COLUMN analytical_stem_view.`plotName__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4303 | 4303 |
-- |
| 4304 | 4304 |
|
| 4305 | 4305 |
|
| 4306 | 4306 |
|
| 4307 | 4307 |
|
| 4308 | 4308 |
-- |
| 4309 |
-- Name: COLUMN analytical_stem_view.`subplot@SALVIAS@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4309 |
-- Name: COLUMN analytical_stem_view.`subplot__@SALVIAS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4310 | 4310 |
-- |
| 4311 | 4311 |
|
| 4312 | 4312 |
|
| ... | ... | |
| 4320 | 4320 |
|
| 4321 | 4321 |
|
| 4322 | 4322 |
-- |
| 4323 |
-- Name: COLUMN analytical_stem_view.`locationevent.locationevent_id@VegBIEN.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4323 |
-- Name: COLUMN analytical_stem_view.`locationevent.locationevent_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4324 | 4324 |
-- |
| 4325 | 4325 |
|
| 4326 | 4326 |
|
| 4327 | 4327 |
|
| 4328 | 4328 |
|
| 4329 | 4329 |
-- |
| 4330 |
-- Name: COLUMN analytical_stem_view.`eventDate@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4330 |
-- Name: COLUMN analytical_stem_view.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4331 | 4331 |
-- |
| 4332 | 4332 |
|
| 4333 | 4333 |
|
| ... | ... | |
| 4341 | 4341 |
|
| 4342 | 4342 |
|
| 4343 | 4343 |
-- |
| 4344 |
-- Name: COLUMN analytical_stem_view.`slopeAspect@VegX.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4344 |
-- Name: COLUMN analytical_stem_view.`slopeAspect__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4345 | 4345 |
-- |
| 4346 | 4346 |
|
| 4347 | 4347 |
|
| 4348 | 4348 |
|
| 4349 | 4349 |
|
| 4350 | 4350 |
-- |
| 4351 |
-- Name: COLUMN analytical_stem_view.`slopeGradient@VegX.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4351 |
-- Name: COLUMN analytical_stem_view.`slopeGradient__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4352 | 4352 |
-- |
| 4353 | 4353 |
|
| 4354 | 4354 |
|
| ... | ... | |
| 4362 | 4362 |
|
| 4363 | 4363 |
|
| 4364 | 4364 |
-- |
| 4365 |
-- Name: COLUMN analytical_stem_view.`samplingProtocol@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4365 |
-- Name: COLUMN analytical_stem_view.`samplingProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4366 | 4366 |
-- |
| 4367 | 4367 |
|
| 4368 | 4368 |
|
| ... | ... | |
| 4425 | 4425 |
|
| 4426 | 4426 |
|
| 4427 | 4427 |
-- |
| 4428 |
-- Name: COLUMN analytical_stem_view.`occurrenceID@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4428 |
-- Name: COLUMN analytical_stem_view.`occurrenceID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4429 | 4429 |
-- |
| 4430 | 4430 |
|
| 4431 | 4431 |
|
| 4432 | 4432 |
|
| 4433 | 4433 |
|
| 4434 | 4434 |
-- |
| 4435 |
-- Name: COLUMN analytical_stem_view.`recordedBy@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4435 |
-- Name: COLUMN analytical_stem_view.`recordedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4436 | 4436 |
-- |
| 4437 | 4437 |
|
| 4438 | 4438 |
|
| 4439 | 4439 |
|
| 4440 | 4440 |
|
| 4441 | 4441 |
-- |
| 4442 |
-- Name: COLUMN analytical_stem_view.`recordNumber@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4442 |
-- Name: COLUMN analytical_stem_view.`recordNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4443 | 4443 |
-- |
| 4444 | 4444 |
|
| 4445 | 4445 |
|
| ... | ... | |
| 4467 | 4467 |
|
| 4468 | 4468 |
|
| 4469 | 4469 |
-- |
| 4470 |
-- Name: COLUMN analytical_stem_view.`identifiedBy@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4470 |
-- Name: COLUMN analytical_stem_view.`identifiedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4471 | 4471 |
-- |
| 4472 | 4472 |
|
| 4473 | 4473 |
|
| 4474 | 4474 |
|
| 4475 | 4475 |
|
| 4476 | 4476 |
-- |
| 4477 |
-- Name: COLUMN analytical_stem_view.`dateIdentified@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4477 |
-- Name: COLUMN analytical_stem_view.`dateIdentified__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4478 | 4478 |
-- |
| 4479 | 4479 |
|
| 4480 | 4480 |
|
| 4481 | 4481 |
|
| 4482 | 4482 |
|
| 4483 | 4483 |
-- |
| 4484 |
-- Name: COLUMN analytical_stem_view.`identificationRemarks@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4484 |
-- Name: COLUMN analytical_stem_view.`identificationRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4485 | 4485 |
-- |
| 4486 | 4486 |
|
| 4487 | 4487 |
|
| 4488 | 4488 |
|
| 4489 | 4489 |
|
| 4490 | 4490 |
-- |
| 4491 |
-- Name: COLUMN analytical_stem_view.`Family_matched@TNRS@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4491 |
-- Name: COLUMN analytical_stem_view.`Family_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4492 | 4492 |
-- |
| 4493 | 4493 |
|
| 4494 | 4494 |
|
| ... | ... | |
| 4572 | 4572 |
|
| 4573 | 4573 |
|
| 4574 | 4574 |
-- |
| 4575 |
-- Name: COLUMN analytical_stem_view.`speciesBinomialWithMorphospecies@VegCore@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4575 |
-- Name: COLUMN analytical_stem_view.`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4576 | 4576 |
-- |
| 4577 | 4577 |
|
| 4578 | 4578 |
|
| ... | ... | |
| 4586 | 4586 |
|
| 4587 | 4587 |
|
| 4588 | 4588 |
-- |
| 4589 |
-- Name: COLUMN analytical_stem_view.`reproductiveCondition@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4589 |
-- Name: COLUMN analytical_stem_view.`reproductiveCondition__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4590 | 4590 |
-- |
| 4591 | 4591 |
|
| 4592 | 4592 |
|
| ... | ... | |
| 4614 | 4614 |
|
| 4615 | 4615 |
|
| 4616 | 4616 |
-- |
| 4617 |
-- Name: COLUMN analytical_stem_view.`occurrenceRemarks@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4617 |
-- Name: COLUMN analytical_stem_view.`occurrenceRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4618 | 4618 |
-- |
| 4619 | 4619 |
|
| 4620 | 4620 |
|
| 4621 | 4621 |
|
| 4622 | 4622 |
|
| 4623 | 4623 |
-- |
| 4624 |
-- Name: COLUMN analytical_stem_view.`coverPercent@VegX.attribute.ordinal@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4624 |
-- Name: COLUMN analytical_stem_view.`coverPercent__@VegX__.attribute.ordinal@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4625 | 4625 |
-- |
| 4626 | 4626 |
|
| 4627 | 4627 |
|
| ... | ... | |
| 4698 | 4698 |
|
| 4699 | 4699 |
|
| 4700 | 4700 |
-- |
| 4701 |
-- Name: COLUMN analytical_stem_view.`individualCount@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4701 |
-- Name: COLUMN analytical_stem_view.`individualCount__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4702 | 4702 |
-- |
| 4703 | 4703 |
|
| 4704 | 4704 |
|
| 4705 | 4705 |
|
| 4706 | 4706 |
|
| 4707 | 4707 |
-- |
| 4708 |
-- Name: COLUMN analytical_stem_view.`stemCode@VegBank.stemlocation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4708 |
-- Name: COLUMN analytical_stem_view.`stemCode__@VegBank__.stemlocation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
|
|
| 4709 | 4709 |
-- |
| 4710 | 4710 |
|
| 4711 | 4711 |
|
| trunk/schemas/public_.sql | ||
|---|---|---|
| 6735 | 6735 |
|
| 6736 | 6736 |
CREATE VIEW analytical_stem_view AS |
| 6737 | 6737 |
SELECT "plot.**".datasource, |
| 6738 |
"plot.**".country AS "country@DwC@vegpath.org",
|
|
| 6739 |
"plot.**"."stateProvince" AS "stateProvince@DwC@vegpath.org",
|
|
| 6740 |
"plot.**".county AS "county@DwC@vegpath.org",
|
|
| 6741 |
"plot.**".locality AS "locality@DwC@vegpath.org",
|
|
| 6742 |
"plot.**"."decimalLatitude" AS "decimalLatitude@DwC@vegpath.org",
|
|
| 6743 |
"plot.**"."decimalLongitude" AS "decimalLongitude@DwC@vegpath.org",
|
|
| 6744 |
"plot.**"."coordinateUncertaintyInMeters" AS "coordinateUncertaintyInMeters@DwC@vegpath.org",
|
|
| 6738 |
"plot.**".country AS "country__@DwC__@vegpath.org",
|
|
| 6739 |
"plot.**"."stateProvince" AS "stateProvince__@DwC__@vegpath.org",
|
|
| 6740 |
"plot.**".county AS "county__@DwC__@vegpath.org",
|
|
| 6741 |
"plot.**".locality AS "locality__@DwC__@vegpath.org",
|
|
| 6742 |
"plot.**"."decimalLatitude" AS "decimalLatitude__@DwC__@vegpath.org",
|
|
| 6743 |
"plot.**"."decimalLongitude" AS "decimalLongitude__@DwC__@vegpath.org",
|
|
| 6744 |
"plot.**"."coordinateUncertaintyInMeters" AS "coordinateUncertaintyInMeters__@DwC__@vegpath.org",
|
|
| 6745 | 6745 |
"plot.**"."coordinateSource_bien", |
| 6746 | 6746 |
"plot.**"."georeferenceProtocol_bien", |
| 6747 | 6747 |
"plot.**".geovalid_bien, |
| 6748 | 6748 |
"plot.**"."isNewWorld_bien", |
| 6749 |
"plot.**"."projectID" AS "projectID@VegX.plotObservation@vegpath.org",
|
|
| 6749 |
"plot.**"."projectID" AS "projectID__@VegX__.plotObservation@vegpath.org",
|
|
| 6750 | 6750 |
"plot.**".project_contributors, |
| 6751 |
"plot.**"."locationID" AS "locationID@DwC@vegpath.org",
|
|
| 6752 |
"plot.**"."locationName" AS "plotName@VegX.plot@vegpath.org",
|
|
| 6753 |
"plot.**".subplot AS "subplot@SALVIAS@vegpath.org",
|
|
| 6751 |
"plot.**"."locationID" AS "locationID__@DwC__@vegpath.org",
|
|
| 6752 |
"plot.**"."locationName" AS "plotName__@VegX__.plot@vegpath.org",
|
|
| 6753 |
"plot.**".subplot AS "subplot__@SALVIAS__@vegpath.org",
|
|
| 6754 | 6754 |
"plot.**".location__cultivated__bien, |
| 6755 |
"plot.**".locationevent__pkey AS "locationevent.locationevent_id@VegBIEN.public@vegpath.org",
|
|
| 6756 |
"plot.**"."eventDate" AS "eventDate@DwC@vegpath.org",
|
|
| 6755 |
"plot.**".locationevent__pkey AS "locationevent.locationevent_id__@VegBIEN__.public@vegpath.org",
|
|
| 6756 |
"plot.**"."eventDate" AS "eventDate__@DwC__@vegpath.org",
|
|
| 6757 | 6757 |
"plot.**"."elevationInMeters", |
| 6758 |
"plot.**"."slopeAspect" AS "slopeAspect@VegX.plot@vegpath.org",
|
|
| 6759 |
"plot.**"."slopeGradient" AS "slopeGradient@VegX.plot@vegpath.org",
|
|
| 6758 |
"plot.**"."slopeAspect" AS "slopeAspect__@VegX__.plot@vegpath.org",
|
|
| 6759 |
"plot.**"."slopeGradient" AS "slopeGradient__@VegX__.plot@vegpath.org",
|
|
| 6760 | 6760 |
"plot.**"."plotArea_ha", |
| 6761 |
"plot.**"."samplingProtocol" AS "samplingProtocol@DwC@vegpath.org",
|
|
| 6761 |
"plot.**"."samplingProtocol" AS "samplingProtocol__@DwC__@vegpath.org",
|
|
| 6762 | 6762 |
"plot.**"."temperature_C", |
| 6763 | 6763 |
"plot.**".precipitation_m, |
| 6764 | 6764 |
"plot.**".stratum__name, |
| ... | ... | |
| 6767 | 6767 |
sourcelist.name AS "specimenHolderInstitutions", |
| 6768 | 6768 |
specimenreplicate.collectioncode_dwc AS collection, |
| 6769 | 6769 |
specimenreplicate.catalognumber_dwc AS "accessionNumber", |
| 6770 |
specimenreplicate.sourceaccessioncode AS "occurrenceID@DwC@vegpath.org",
|
|
| 6771 |
collector.fullname AS "recordedBy@DwC@vegpath.org",
|
|
| 6772 |
plantobservation.authorplantcode AS "recordNumber@DwC@vegpath.org",
|
|
| 6770 |
specimenreplicate.sourceaccessioncode AS "occurrenceID__@DwC__@vegpath.org",
|
|
| 6771 |
collector.fullname AS "recordedBy__@DwC__@vegpath.org",
|
|
| 6772 |
plantobservation.authorplantcode AS "recordNumber__@DwC__@vegpath.org",
|
|
| 6773 | 6773 |
COALESCE(aggregateoccurrence.collectiondate, "plot.**"."eventDate") AS "dateCollected", |
| 6774 | 6774 |
taxonverbatim.family AS family_verbatim, |
| 6775 | 6775 |
COALESCE(taxonverbatim.taxonomicname, (taxonverbatim.taxonname || COALESCE((' '::text || taxonverbatim.author), ''::text)), taxonlabel.taxonomicname) AS "scientificName_verbatim",
|
| 6776 |
identifiedby.fullname AS "identifiedBy@DwC@vegpath.org",
|
|
| 6777 |
taxondetermination.determinationdate AS "dateIdentified@DwC@vegpath.org",
|
|
| 6778 |
taxondetermination.notes AS "identificationRemarks@DwC@vegpath.org",
|
|
| 6779 |
taxon_scrub."matchedFamily" AS "Family_matched@TNRS@vegpath.org",
|
|
| 6776 |
identifiedby.fullname AS "identifiedBy__@DwC__@vegpath.org",
|
|
| 6777 |
taxondetermination.determinationdate AS "dateIdentified__@DwC__@vegpath.org",
|
|
| 6778 |
taxondetermination.notes AS "identificationRemarks__@DwC__@vegpath.org",
|
|
| 6779 |
taxon_scrub."matchedFamily" AS "Family_matched__@TNRS__@vegpath.org",
|
|
| 6780 | 6780 |
taxon_scrub."matchedTaxonName" AS "taxonName_matched", |
| 6781 | 6781 |
taxon_scrub."matchedScientificNameAuthorship" AS "scientificNameAuthorship_matched", |
| 6782 | 6782 |
family_higher_plant_group.higher_plant_group AS "higherPlantGroup_bien", |
| ... | ... | |
| 6788 | 6788 |
taxon_scrub.scrubbed_taxon_name_no_author, |
| 6789 | 6789 |
taxon_scrub.scrubbed_author, |
| 6790 | 6790 |
taxon_scrub.scrubbed_taxon_name_with_author, |
| 6791 |
taxon_scrub.scrubbed_morphospecies_binomial AS "speciesBinomialWithMorphospecies@VegCore@vegpath.org",
|
|
| 6791 |
taxon_scrub.scrubbed_morphospecies_binomial AS "speciesBinomialWithMorphospecies__@VegCore__@vegpath.org",
|
|
| 6792 | 6792 |
taxonoccurrence.growthform AS "growthForm", |
| 6793 |
plantobservation.reproductivecondition AS "reproductiveCondition@DwC@vegpath.org",
|
|
| 6793 |
plantobservation.reproductivecondition AS "reproductiveCondition__@DwC__@vegpath.org",
|
|
| 6794 | 6794 |
((threatened_taxonlabel.taxonlabel_id IS NOT NULL))::integer AS threatened_bien, |
| 6795 | 6795 |
(((cultivated_family_locations.country IS NOT NULL) OR _or(taxonoccurrence.iscultivated, "plot.**".location__cultivated__bien)))::integer AS cultivated_bien, |
| 6796 | 6796 |
CASE |
| ... | ... | |
| 6798 | 6798 |
WHEN ("plot.**".location__cultivated__bien IS NOT NULL) THEN NULL::text
|
| 6799 | 6799 |
ELSE NULL::text |
| 6800 | 6800 |
END AS "cultivatedBasis_bien", |
| 6801 |
aggregateoccurrence.notes AS "occurrenceRemarks@DwC@vegpath.org",
|
|
| 6802 |
_fraction_to_percent(aggregateoccurrence.cover_fraction) AS "coverPercent@VegX.attribute.ordinal@vegpath.org",
|
|
| 6801 |
aggregateoccurrence.notes AS "occurrenceRemarks__@DwC__@vegpath.org",
|
|
| 6802 |
_fraction_to_percent(aggregateoccurrence.cover_fraction) AS "coverPercent__@VegX__.attribute.ordinal@vegpath.org",
|
|
| 6803 | 6803 |
_m_to_cm(stemobservation.diameterbreastheight_m) AS "diameterBreastHeight_cm", |
| 6804 | 6804 |
stemobservation.height_m, |
| 6805 | 6805 |
stemobservation.tag, |
| ... | ... | |
| 6810 | 6810 |
aggregateoccurrence.sourceaccessioncode AS "aggregateOrganismObservationID", |
| 6811 | 6811 |
plantobservation.sourceaccessioncode AS "individualObservationID", |
| 6812 | 6812 |
plantobservation.authorplantcode AS "individualCode", |
| 6813 |
aggregateoccurrence.count AS "individualCount@DwC@vegpath.org",
|
|
| 6814 |
stemobservation.authorstemcode AS "stemCode@VegBank.stemlocation@vegpath.org"
|
|
| 6813 |
aggregateoccurrence.count AS "individualCount__@DwC__@vegpath.org",
|
|
| 6814 |
stemobservation.authorstemcode AS "stemCode__@VegBank__.stemlocation@vegpath.org"
|
|
| 6815 | 6815 |
FROM ((((((((((((((("plot.**"
|
| 6816 | 6816 |
LEFT JOIN taxonoccurrence ON ((taxonoccurrence.locationevent_id = "plot.**".locationevent__pkey))) |
| 6817 | 6817 |
LEFT JOIN party collector ON ((collector.party_id = taxonoccurrence.collector_id))) |
| ... | ... | |
| 6849 | 6849 |
|
| 6850 | 6850 |
|
| 6851 | 6851 |
-- |
| 6852 |
-- Name: COLUMN analytical_stem_view."country@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6852 |
-- Name: COLUMN analytical_stem_view."country__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6853 | 6853 |
-- |
| 6854 | 6854 |
|
| 6855 |
COMMENT ON COLUMN analytical_stem_view."country@DwC@vegpath.org" IS 'geoscrub.geoscrub_output.acceptedCountry@VegBIEN@vegpath.org;
|
|
| 6855 |
COMMENT ON COLUMN analytical_stem_view."country__@DwC__@vegpath.org" IS 'geoscrub.geoscrub_output.acceptedCountry@VegBIEN@vegpath.org;
|
|
| 6856 | 6856 |
"The name of the country or major administrative unit in which the Location occurs"'; |
| 6857 | 6857 |
|
| 6858 | 6858 |
|
| 6859 | 6859 |
-- |
| 6860 |
-- Name: COLUMN analytical_stem_view."stateProvince@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6860 |
-- Name: COLUMN analytical_stem_view."stateProvince__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6861 | 6861 |
-- |
| 6862 | 6862 |
|
| 6863 |
COMMENT ON COLUMN analytical_stem_view."stateProvince@DwC@vegpath.org" IS '"The name of the next smaller administrative region than country (state, province, canton, department, region, etc.) in which the Location occurs"';
|
|
| 6863 |
COMMENT ON COLUMN analytical_stem_view."stateProvince__@DwC__@vegpath.org" IS '"The name of the next smaller administrative region than country (state, province, canton, department, region, etc.) in which the Location occurs"';
|
|
| 6864 | 6864 |
|
| 6865 | 6865 |
|
| 6866 | 6866 |
-- |
| 6867 |
-- Name: COLUMN analytical_stem_view."county@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6867 |
-- Name: COLUMN analytical_stem_view."county__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6868 | 6868 |
-- |
| 6869 | 6869 |
|
| 6870 |
COMMENT ON COLUMN analytical_stem_view."county@DwC@vegpath.org" IS '"The full, unabbreviated name of the next smaller administrative region than stateProvince (county, shire, department, etc.) in which the Location occurs"';
|
|
| 6870 |
COMMENT ON COLUMN analytical_stem_view."county__@DwC__@vegpath.org" IS '"The full, unabbreviated name of the next smaller administrative region than stateProvince (county, shire, department, etc.) in which the Location occurs"';
|
|
| 6871 | 6871 |
|
| 6872 | 6872 |
|
| 6873 | 6873 |
-- |
| 6874 |
-- Name: COLUMN analytical_stem_view."locality@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6874 |
-- Name: COLUMN analytical_stem_view."locality__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6875 | 6875 |
-- |
| 6876 | 6876 |
|
| 6877 |
COMMENT ON COLUMN analytical_stem_view."locality@DwC@vegpath.org" IS '"The specific description of the place"';
|
|
| 6877 |
COMMENT ON COLUMN analytical_stem_view."locality__@DwC__@vegpath.org" IS '"The specific description of the place"';
|
|
| 6878 | 6878 |
|
| 6879 | 6879 |
|
| 6880 | 6880 |
-- |
| 6881 |
-- Name: COLUMN analytical_stem_view."decimalLatitude@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6881 |
-- Name: COLUMN analytical_stem_view."decimalLatitude__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6882 | 6882 |
-- |
| 6883 | 6883 |
|
| 6884 |
COMMENT ON COLUMN analytical_stem_view."decimalLatitude@DwC@vegpath.org" IS '"The geographic latitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"';
|
|
| 6884 |
COMMENT ON COLUMN analytical_stem_view."decimalLatitude__@DwC__@vegpath.org" IS '"The geographic latitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"';
|
|
| 6885 | 6885 |
|
| 6886 | 6886 |
|
| 6887 | 6887 |
-- |
| 6888 |
-- Name: COLUMN analytical_stem_view."decimalLongitude@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6888 |
-- Name: COLUMN analytical_stem_view."decimalLongitude__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6889 | 6889 |
-- |
| 6890 | 6890 |
|
| 6891 |
COMMENT ON COLUMN analytical_stem_view."decimalLongitude@DwC@vegpath.org" IS '"The geographic longitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"';
|
|
| 6891 |
COMMENT ON COLUMN analytical_stem_view."decimalLongitude__@DwC__@vegpath.org" IS '"The geographic longitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"';
|
|
| 6892 | 6892 |
|
| 6893 | 6893 |
|
| 6894 | 6894 |
-- |
| 6895 |
-- Name: COLUMN analytical_stem_view."coordinateUncertaintyInMeters@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6895 |
-- Name: COLUMN analytical_stem_view."coordinateUncertaintyInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6896 | 6896 |
-- |
| 6897 | 6897 |
|
| 6898 |
COMMENT ON COLUMN analytical_stem_view."coordinateUncertaintyInMeters@DwC@vegpath.org" IS '"The horizontal distance (in meters) from the given decimalLatitude and decimalLongitude describing the smallest circle containing the whole of the Location"';
|
|
| 6898 |
COMMENT ON COLUMN analytical_stem_view."coordinateUncertaintyInMeters__@DwC__@vegpath.org" IS '"The horizontal distance (in meters) from the given decimalLatitude and decimalLongitude describing the smallest circle containing the whole of the Location"';
|
|
| 6899 | 6899 |
|
| 6900 | 6900 |
|
| 6901 | 6901 |
-- |
| ... | ... | |
| 6927 | 6927 |
|
| 6928 | 6928 |
|
| 6929 | 6929 |
-- |
| 6930 |
-- Name: COLUMN analytical_stem_view."projectID@VegX.plotObservation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6930 |
-- Name: COLUMN analytical_stem_view."projectID__@VegX__.plotObservation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6931 | 6931 |
-- |
| 6932 | 6932 |
|
| 6933 |
COMMENT ON COLUMN analytical_stem_view."projectID@VegX.plotObservation@vegpath.org" IS 'project.sourceaccessioncode@VegBIEN.public@vegpath.org;
|
|
| 6933 |
COMMENT ON COLUMN analytical_stem_view."projectID__@VegX__.plotObservation@vegpath.org" IS 'project.sourceaccessioncode@VegBIEN.public@vegpath.org;
|
|
| 6934 | 6934 |
"A reference to a specific ''project''"'; |
| 6935 | 6935 |
|
| 6936 | 6936 |
|
| ... | ... | |
| 6942 | 6942 |
|
| 6943 | 6943 |
|
| 6944 | 6944 |
-- |
| 6945 |
-- Name: COLUMN analytical_stem_view."locationID@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6945 |
-- Name: COLUMN analytical_stem_view."locationID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6946 | 6946 |
-- |
| 6947 | 6947 |
|
| 6948 |
COMMENT ON COLUMN analytical_stem_view."locationID@DwC@vegpath.org" IS '"An identifier for the set of location information (data associated with dcterms:Location)"';
|
|
| 6948 |
COMMENT ON COLUMN analytical_stem_view."locationID__@DwC__@vegpath.org" IS '"An identifier for the set of location information (data associated with dcterms:Location)"';
|
|
| 6949 | 6949 |
|
| 6950 | 6950 |
|
| 6951 | 6951 |
-- |
| 6952 |
-- Name: COLUMN analytical_stem_view."plotName@VegX.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6952 |
-- Name: COLUMN analytical_stem_view."plotName__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6953 | 6953 |
-- |
| 6954 | 6954 |
|
| 6955 |
COMMENT ON COLUMN analytical_stem_view."plotName@VegX.plot@vegpath.org" IS '"Name or label for a plot"';
|
|
| 6955 |
COMMENT ON COLUMN analytical_stem_view."plotName__@VegX__.plot@vegpath.org" IS '"Name or label for a plot"';
|
|
| 6956 | 6956 |
|
| 6957 | 6957 |
|
| 6958 | 6958 |
-- |
| 6959 |
-- Name: COLUMN analytical_stem_view."subplot@SALVIAS@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6959 |
-- Name: COLUMN analytical_stem_view."subplot__@SALVIAS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6960 | 6960 |
-- |
| 6961 | 6961 |
|
| 6962 |
COMMENT ON COLUMN analytical_stem_view."subplot@SALVIAS@vegpath.org" IS 'location.authorlocationcode@VegBIEN.public@vegpath.org;
|
|
| 6962 |
COMMENT ON COLUMN analytical_stem_view."subplot__@SALVIAS__@vegpath.org" IS 'location.authorlocationcode@VegBIEN.public@vegpath.org;
|
|
| 6963 | 6963 |
"Code for subplot, line, or any other subsample or subdivision of plot"'; |
| 6964 | 6964 |
|
| 6965 | 6965 |
|
| ... | ... | |
| 6971 | 6971 |
|
| 6972 | 6972 |
|
| 6973 | 6973 |
-- |
| 6974 |
-- Name: COLUMN analytical_stem_view."locationevent.locationevent_id@VegBIEN.public@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6974 |
-- Name: COLUMN analytical_stem_view."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6975 | 6975 |
-- |
| 6976 | 6976 |
|
| 6977 |
COMMENT ON COLUMN analytical_stem_view."locationevent.locationevent_id@VegBIEN.public@vegpath.org" IS 'locationevent.locationevent_id@VegBIEN.public@vegpath.org;
|
|
| 6977 |
COMMENT ON COLUMN analytical_stem_view."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org" IS 'locationevent.locationevent_id@VegBIEN.public@vegpath.org;
|
|
| 6978 | 6978 |
autogenerated ID for locationevent'; |
| 6979 | 6979 |
|
| 6980 | 6980 |
|
| 6981 | 6981 |
-- |
| 6982 |
-- Name: COLUMN analytical_stem_view."eventDate@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6982 |
-- Name: COLUMN analytical_stem_view."eventDate__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6983 | 6983 |
-- |
| 6984 | 6984 |
|
| 6985 |
COMMENT ON COLUMN analytical_stem_view."eventDate@DwC@vegpath.org" IS '"The date-time or interval during which an Event occurred. For occurrences, this is the date-time when the event was recorded."';
|
|
| 6985 |
COMMENT ON COLUMN analytical_stem_view."eventDate__@DwC__@vegpath.org" IS '"The date-time or interval during which an Event occurred. For occurrences, this is the date-time when the event was recorded."';
|
|
| 6986 | 6986 |
|
| 6987 | 6987 |
|
| 6988 | 6988 |
-- |
| ... | ... | |
| 6993 | 6993 |
|
| 6994 | 6994 |
|
| 6995 | 6995 |
-- |
| 6996 |
-- Name: COLUMN analytical_stem_view."slopeAspect@VegX.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6996 |
-- Name: COLUMN analytical_stem_view."slopeAspect__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6997 | 6997 |
-- |
| 6998 | 6998 |
|
| 6999 |
COMMENT ON COLUMN analytical_stem_view."slopeAspect@VegX.plot@vegpath.org" IS '"Representative azimuth of slope gradient (0-360 degrees) or as a cardinal direction (e.g. N, S, NE)"';
|
|
| 6999 |
COMMENT ON COLUMN analytical_stem_view."slopeAspect__@VegX__.plot@vegpath.org" IS '"Representative azimuth of slope gradient (0-360 degrees) or as a cardinal direction (e.g. N, S, NE)"';
|
|
| 7000 | 7000 |
|
| 7001 | 7001 |
|
| 7002 | 7002 |
-- |
| 7003 |
-- Name: COLUMN analytical_stem_view."slopeGradient@VegX.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7003 |
-- Name: COLUMN analytical_stem_view."slopeGradient__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7004 | 7004 |
-- |
| 7005 | 7005 |
|
| 7006 |
COMMENT ON COLUMN analytical_stem_view."slopeGradient@VegX.plot@vegpath.org" IS '"Representative inclination of slope in degrees"';
|
|
| 7006 |
COMMENT ON COLUMN analytical_stem_view."slopeGradient__@VegX__.plot@vegpath.org" IS '"Representative inclination of slope in degrees"';
|
|
| 7007 | 7007 |
|
| 7008 | 7008 |
|
| 7009 | 7009 |
-- |
| ... | ... | |
| 7014 | 7014 |
|
| 7015 | 7015 |
|
| 7016 | 7016 |
-- |
| 7017 |
-- Name: COLUMN analytical_stem_view."samplingProtocol@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7017 |
-- Name: COLUMN analytical_stem_view."samplingProtocol__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7018 | 7018 |
-- |
| 7019 | 7019 |
|
| 7020 |
COMMENT ON COLUMN analytical_stem_view."samplingProtocol@DwC@vegpath.org" IS '"The name of, reference to, or description of the method or protocol used during an Event"';
|
|
| 7020 |
COMMENT ON COLUMN analytical_stem_view."samplingProtocol__@DwC__@vegpath.org" IS '"The name of, reference to, or description of the method or protocol used during an Event"';
|
|
| 7021 | 7021 |
|
| 7022 | 7022 |
|
| 7023 | 7023 |
-- |
| ... | ... | |
| 7077 | 7077 |
|
| 7078 | 7078 |
|
| 7079 | 7079 |
-- |
| 7080 |
-- Name: COLUMN analytical_stem_view."occurrenceID@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7080 |
-- Name: COLUMN analytical_stem_view."occurrenceID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7081 | 7081 |
-- |
| 7082 | 7082 |
|
| 7083 |
COMMENT ON COLUMN analytical_stem_view."occurrenceID@DwC@vegpath.org" IS '"An identifier for the Occurrence (as opposed to a particular digital record of the occurrence). In the absence of a persistent global unique identifier, construct one from a combination of identifiers in the record that will most closely make the occurrenceID globally unique."';
|
|
| 7083 |
COMMENT ON COLUMN analytical_stem_view."occurrenceID__@DwC__@vegpath.org" IS '"An identifier for the Occurrence (as opposed to a particular digital record of the occurrence). In the absence of a persistent global unique identifier, construct one from a combination of identifiers in the record that will most closely make the occurrenceID globally unique."';
|
|
| 7084 | 7084 |
|
| 7085 | 7085 |
|
| 7086 | 7086 |
-- |
| 7087 |
-- Name: COLUMN analytical_stem_view."recordedBy@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7087 |
-- Name: COLUMN analytical_stem_view."recordedBy__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7088 | 7088 |
-- |
| 7089 | 7089 |
|
| 7090 |
COMMENT ON COLUMN analytical_stem_view."recordedBy@DwC@vegpath.org" IS '"A list (concatenated and separated) of names of people, groups, or organizations responsible for recording the original Occurrence. The primary collector or observer, especially one who applies a personal identifier (recordNumber), should be listed first."';
|
|
| 7090 |
COMMENT ON COLUMN analytical_stem_view."recordedBy__@DwC__@vegpath.org" IS '"A list (concatenated and separated) of names of people, groups, or organizations responsible for recording the original Occurrence. The primary collector or observer, especially one who applies a personal identifier (recordNumber), should be listed first."';
|
|
| 7091 | 7091 |
|
| 7092 | 7092 |
|
| 7093 | 7093 |
-- |
| 7094 |
-- Name: COLUMN analytical_stem_view."recordNumber@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7094 |
-- Name: COLUMN analytical_stem_view."recordNumber__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7095 | 7095 |
-- |
| 7096 | 7096 |
|
| 7097 |
COMMENT ON COLUMN analytical_stem_view."recordNumber@DwC@vegpath.org" IS '"An identifier given to the Occurrence at the time it was recorded. Often serves as a link between field notes and an Occurrence record, such as a specimen collector''s number."';
|
|
| 7097 |
COMMENT ON COLUMN analytical_stem_view."recordNumber__@DwC__@vegpath.org" IS '"An identifier given to the Occurrence at the time it was recorded. Often serves as a link between field notes and an Occurrence record, such as a specimen collector''s number."';
|
|
| 7098 | 7098 |
|
| 7099 | 7099 |
|
| 7100 | 7100 |
-- |
| ... | ... | |
| 7119 | 7119 |
|
| 7120 | 7120 |
|
| 7121 | 7121 |
-- |
| 7122 |
-- Name: COLUMN analytical_stem_view."identifiedBy@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7122 |
-- Name: COLUMN analytical_stem_view."identifiedBy__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7123 | 7123 |
-- |
| 7124 | 7124 |
|
| 7125 |
COMMENT ON COLUMN analytical_stem_view."identifiedBy@DwC@vegpath.org" IS '"A list (concatenated and separated) of names of people, groups, or organizations who assigned the Taxon to the subject"';
|
|
| 7125 |
COMMENT ON COLUMN analytical_stem_view."identifiedBy__@DwC__@vegpath.org" IS '"A list (concatenated and separated) of names of people, groups, or organizations who assigned the Taxon to the subject"';
|
|
| 7126 | 7126 |
|
| 7127 | 7127 |
|
| 7128 | 7128 |
-- |
| 7129 |
-- Name: COLUMN analytical_stem_view."dateIdentified@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7129 |
-- Name: COLUMN analytical_stem_view."dateIdentified__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7130 | 7130 |
-- |
| 7131 | 7131 |
|
| 7132 |
COMMENT ON COLUMN analytical_stem_view."dateIdentified@DwC@vegpath.org" IS '"The date on which the subject was identified as representing the Taxon"';
|
|
| 7132 |
COMMENT ON COLUMN analytical_stem_view."dateIdentified__@DwC__@vegpath.org" IS '"The date on which the subject was identified as representing the Taxon"';
|
|
| 7133 | 7133 |
|
| 7134 | 7134 |
|
| 7135 | 7135 |
-- |
| 7136 |
-- Name: COLUMN analytical_stem_view."identificationRemarks@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7136 |
-- Name: COLUMN analytical_stem_view."identificationRemarks__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7137 | 7137 |
-- |
| 7138 | 7138 |
|
| 7139 |
COMMENT ON COLUMN analytical_stem_view."identificationRemarks@DwC@vegpath.org" IS '"Comments or notes about the Identification"';
|
|
| 7139 |
COMMENT ON COLUMN analytical_stem_view."identificationRemarks__@DwC__@vegpath.org" IS '"Comments or notes about the Identification"';
|
|
| 7140 | 7140 |
|
| 7141 | 7141 |
|
| 7142 | 7142 |
-- |
| 7143 |
-- Name: COLUMN analytical_stem_view."Family_matched@TNRS@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7143 |
-- Name: COLUMN analytical_stem_view."Family_matched__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7144 | 7144 |
-- |
| 7145 | 7145 |
|
| 7146 |
COMMENT ON COLUMN analytical_stem_view."Family_matched@TNRS@vegpath.org" IS 'TNRS.taxon_scrub.matchedFamily@VegBIEN.public@vegpath.org;
|
|
| 7146 |
COMMENT ON COLUMN analytical_stem_view."Family_matched__@TNRS__@vegpath.org" IS 'TNRS.taxon_scrub.matchedFamily@VegBIEN.public@vegpath.org;
|
|
| 7147 | 7147 |
"The closest matching family in the TNRS database to the family submitted"'; |
| 7148 | 7148 |
|
| 7149 | 7149 |
|
| ... | ... | |
| 7225 | 7225 |
|
| 7226 | 7226 |
|
| 7227 | 7227 |
-- |
| 7228 |
-- Name: COLUMN analytical_stem_view."speciesBinomialWithMorphospecies@VegCore@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7228 |
-- Name: COLUMN analytical_stem_view."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7229 | 7229 |
-- |
| 7230 | 7230 |
|
| 7231 |
COMMENT ON COLUMN analytical_stem_view."speciesBinomialWithMorphospecies@VegCore@vegpath.org" IS 'TNRS.taxon_scrub.scrubbed_morphospecies_binomial@VegBIEN.public@vegpath.org;
|
|
| 7231 |
COMMENT ON COLUMN analytical_stem_view."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org" IS 'TNRS.taxon_scrub.scrubbed_morphospecies_binomial@VegBIEN.public@vegpath.org;
|
|
| 7232 | 7232 |
"combine the `taxon` plus `morphospecies` to produce a unique string, `taxonMorphospecies`"'; |
| 7233 | 7233 |
|
| 7234 | 7234 |
|
| ... | ... | |
| 7240 | 7240 |
|
| 7241 | 7241 |
|
| 7242 | 7242 |
-- |
| 7243 |
-- Name: COLUMN analytical_stem_view."reproductiveCondition@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7243 |
-- Name: COLUMN analytical_stem_view."reproductiveCondition__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7244 | 7244 |
-- |
| 7245 | 7245 |
|
| 7246 |
COMMENT ON COLUMN analytical_stem_view."reproductiveCondition@DwC@vegpath.org" IS '"The reproductive condition of the biological individual(s) represented in the Occurrence. Recommended best practice is to use a controlled vocabulary."';
|
|
| 7246 |
COMMENT ON COLUMN analytical_stem_view."reproductiveCondition__@DwC__@vegpath.org" IS '"The reproductive condition of the biological individual(s) represented in the Occurrence. Recommended best practice is to use a controlled vocabulary."';
|
|
| 7247 | 7247 |
|
| 7248 | 7248 |
|
| 7249 | 7249 |
-- |
| ... | ... | |
| 7268 | 7268 |
|
| 7269 | 7269 |
|
| 7270 | 7270 |
-- |
| 7271 |
-- Name: COLUMN analytical_stem_view."occurrenceRemarks@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7271 |
-- Name: COLUMN analytical_stem_view."occurrenceRemarks__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7272 | 7272 |
-- |
| 7273 | 7273 |
|
| 7274 |
COMMENT ON COLUMN analytical_stem_view."occurrenceRemarks@DwC@vegpath.org" IS '"Comments or notes about the Occurrence"';
|
|
| 7274 |
COMMENT ON COLUMN analytical_stem_view."occurrenceRemarks__@DwC__@vegpath.org" IS '"Comments or notes about the Occurrence"';
|
|
| 7275 | 7275 |
|
| 7276 | 7276 |
|
| 7277 | 7277 |
-- |
| 7278 |
-- Name: COLUMN analytical_stem_view."coverPercent@VegX.attribute.ordinal@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7278 |
-- Name: COLUMN analytical_stem_view."coverPercent__@VegX__.attribute.ordinal@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7279 | 7279 |
-- |
| 7280 | 7280 |
|
| 7281 |
COMMENT ON COLUMN analytical_stem_view."coverPercent@VegX.attribute.ordinal@vegpath.org" IS '"Average cover of the index in percent"';
|
|
| 7281 |
COMMENT ON COLUMN analytical_stem_view."coverPercent__@VegX__.attribute.ordinal@vegpath.org" IS '"Average cover of the index in percent"';
|
|
| 7282 | 7282 |
|
| 7283 | 7283 |
|
| 7284 | 7284 |
-- |
| ... | ... | |
| 7352 | 7352 |
|
| 7353 | 7353 |
|
| 7354 | 7354 |
-- |
| 7355 |
-- Name: COLUMN analytical_stem_view."individualCount@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7355 |
-- Name: COLUMN analytical_stem_view."individualCount__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7356 | 7356 |
-- |
| 7357 | 7357 |
|
| 7358 |
COMMENT ON COLUMN analytical_stem_view."individualCount@DwC@vegpath.org" IS '"The number of individuals represented present at the time of the Occurrence"';
|
|
| 7358 |
COMMENT ON COLUMN analytical_stem_view."individualCount__@DwC__@vegpath.org" IS '"The number of individuals represented present at the time of the Occurrence"';
|
|
| 7359 | 7359 |
|
| 7360 | 7360 |
|
| 7361 | 7361 |
-- |
| 7362 |
-- Name: COLUMN analytical_stem_view."stemCode@VegBank.stemlocation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7362 |
-- Name: COLUMN analytical_stem_view."stemCode__@VegBank__.stemlocation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7363 | 7363 |
-- |
| 7364 | 7364 |
|
| 7365 |
COMMENT ON COLUMN analytical_stem_view."stemCode@VegBank.stemlocation@vegpath.org" IS 'stemobservation.authorstemcode@VegBIEN.public@vegpath.org;
|
|
| 7365 |
COMMENT ON COLUMN analytical_stem_view."stemCode__@VegBank__.stemlocation@vegpath.org" IS 'stemobservation.authorstemcode@VegBIEN.public@vegpath.org;
|
|
| 7366 | 7366 |
"Name or code applied to a specific stem in the plot. This is generally a numeric label to associate a field data entry with a stem in the database."'; |
| 7367 | 7367 |
|
| 7368 | 7368 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 6735 | 6735 |
|
| 6736 | 6736 |
CREATE VIEW analytical_stem_view AS |
| 6737 | 6737 |
SELECT "plot.**".datasource, |
| 6738 |
"plot.**".country AS "country@DwC@vegpath.org",
|
|
| 6739 |
"plot.**"."stateProvince" AS "stateProvince@DwC@vegpath.org",
|
|
| 6740 |
"plot.**".county AS "county@DwC@vegpath.org",
|
|
| 6741 |
"plot.**".locality AS "locality@DwC@vegpath.org",
|
|
| 6742 |
"plot.**"."decimalLatitude" AS "decimalLatitude@DwC@vegpath.org",
|
|
| 6743 |
"plot.**"."decimalLongitude" AS "decimalLongitude@DwC@vegpath.org",
|
|
| 6744 |
"plot.**"."coordinateUncertaintyInMeters" AS "coordinateUncertaintyInMeters@DwC@vegpath.org",
|
|
| 6738 |
"plot.**".country AS "country__@DwC__@vegpath.org",
|
|
| 6739 |
"plot.**"."stateProvince" AS "stateProvince__@DwC__@vegpath.org",
|
|
| 6740 |
"plot.**".county AS "county__@DwC__@vegpath.org",
|
|
| 6741 |
"plot.**".locality AS "locality__@DwC__@vegpath.org",
|
|
| 6742 |
"plot.**"."decimalLatitude" AS "decimalLatitude__@DwC__@vegpath.org",
|
|
| 6743 |
"plot.**"."decimalLongitude" AS "decimalLongitude__@DwC__@vegpath.org",
|
|
| 6744 |
"plot.**"."coordinateUncertaintyInMeters" AS "coordinateUncertaintyInMeters__@DwC__@vegpath.org",
|
|
| 6745 | 6745 |
"plot.**"."coordinateSource_bien", |
| 6746 | 6746 |
"plot.**"."georeferenceProtocol_bien", |
| 6747 | 6747 |
"plot.**".geovalid_bien, |
| 6748 | 6748 |
"plot.**"."isNewWorld_bien", |
| 6749 |
"plot.**"."projectID" AS "projectID@VegX.plotObservation@vegpath.org",
|
|
| 6749 |
"plot.**"."projectID" AS "projectID__@VegX__.plotObservation@vegpath.org",
|
|
| 6750 | 6750 |
"plot.**".project_contributors, |
| 6751 |
"plot.**"."locationID" AS "locationID@DwC@vegpath.org",
|
|
| 6752 |
"plot.**"."locationName" AS "plotName@VegX.plot@vegpath.org",
|
|
| 6753 |
"plot.**".subplot AS "subplot@SALVIAS@vegpath.org",
|
|
| 6751 |
"plot.**"."locationID" AS "locationID__@DwC__@vegpath.org",
|
|
| 6752 |
"plot.**"."locationName" AS "plotName__@VegX__.plot@vegpath.org",
|
|
| 6753 |
"plot.**".subplot AS "subplot__@SALVIAS__@vegpath.org",
|
|
| 6754 | 6754 |
"plot.**".location__cultivated__bien, |
| 6755 |
"plot.**".locationevent__pkey AS "locationevent.locationevent_id@VegBIEN.public@vegpath.org",
|
|
| 6756 |
"plot.**"."eventDate" AS "eventDate@DwC@vegpath.org",
|
|
| 6755 |
"plot.**".locationevent__pkey AS "locationevent.locationevent_id__@VegBIEN__.public@vegpath.org",
|
|
| 6756 |
"plot.**"."eventDate" AS "eventDate__@DwC__@vegpath.org",
|
|
| 6757 | 6757 |
"plot.**"."elevationInMeters", |
| 6758 |
"plot.**"."slopeAspect" AS "slopeAspect@VegX.plot@vegpath.org",
|
|
| 6759 |
"plot.**"."slopeGradient" AS "slopeGradient@VegX.plot@vegpath.org",
|
|
| 6758 |
"plot.**"."slopeAspect" AS "slopeAspect__@VegX__.plot@vegpath.org",
|
|
| 6759 |
"plot.**"."slopeGradient" AS "slopeGradient__@VegX__.plot@vegpath.org",
|
|
| 6760 | 6760 |
"plot.**"."plotArea_ha", |
| 6761 |
"plot.**"."samplingProtocol" AS "samplingProtocol@DwC@vegpath.org",
|
|
| 6761 |
"plot.**"."samplingProtocol" AS "samplingProtocol__@DwC__@vegpath.org",
|
|
| 6762 | 6762 |
"plot.**"."temperature_C", |
| 6763 | 6763 |
"plot.**".precipitation_m, |
| 6764 | 6764 |
"plot.**".stratum__name, |
| ... | ... | |
| 6767 | 6767 |
sourcelist.name AS "specimenHolderInstitutions", |
| 6768 | 6768 |
specimenreplicate.collectioncode_dwc AS collection, |
| 6769 | 6769 |
specimenreplicate.catalognumber_dwc AS "accessionNumber", |
| 6770 |
specimenreplicate.sourceaccessioncode AS "occurrenceID@DwC@vegpath.org",
|
|
| 6771 |
collector.fullname AS "recordedBy@DwC@vegpath.org",
|
|
| 6772 |
plantobservation.authorplantcode AS "recordNumber@DwC@vegpath.org",
|
|
| 6770 |
specimenreplicate.sourceaccessioncode AS "occurrenceID__@DwC__@vegpath.org",
|
|
| 6771 |
collector.fullname AS "recordedBy__@DwC__@vegpath.org",
|
|
| 6772 |
plantobservation.authorplantcode AS "recordNumber__@DwC__@vegpath.org",
|
|
| 6773 | 6773 |
COALESCE(aggregateoccurrence.collectiondate, "plot.**"."eventDate") AS "dateCollected", |
| 6774 | 6774 |
taxonverbatim.family AS family_verbatim, |
| 6775 | 6775 |
COALESCE(taxonverbatim.taxonomicname, (taxonverbatim.taxonname || COALESCE((' '::text || taxonverbatim.author), ''::text)), taxonlabel.taxonomicname) AS "scientificName_verbatim",
|
| 6776 |
identifiedby.fullname AS "identifiedBy@DwC@vegpath.org",
|
|
| 6777 |
taxondetermination.determinationdate AS "dateIdentified@DwC@vegpath.org",
|
|
| 6778 |
taxondetermination.notes AS "identificationRemarks@DwC@vegpath.org",
|
|
| 6779 |
taxon_scrub."matchedFamily" AS "Family_matched@TNRS@vegpath.org",
|
|
| 6776 |
identifiedby.fullname AS "identifiedBy__@DwC__@vegpath.org",
|
|
| 6777 |
taxondetermination.determinationdate AS "dateIdentified__@DwC__@vegpath.org",
|
|
| 6778 |
taxondetermination.notes AS "identificationRemarks__@DwC__@vegpath.org",
|
|
| 6779 |
taxon_scrub."matchedFamily" AS "Family_matched__@TNRS__@vegpath.org",
|
|
| 6780 | 6780 |
taxon_scrub."matchedTaxonName" AS "taxonName_matched", |
| 6781 | 6781 |
taxon_scrub."matchedScientificNameAuthorship" AS "scientificNameAuthorship_matched", |
| 6782 | 6782 |
family_higher_plant_group.higher_plant_group AS "higherPlantGroup_bien", |
| ... | ... | |
| 6788 | 6788 |
taxon_scrub.scrubbed_taxon_name_no_author, |
| 6789 | 6789 |
taxon_scrub.scrubbed_author, |
| 6790 | 6790 |
taxon_scrub.scrubbed_taxon_name_with_author, |
| 6791 |
taxon_scrub.scrubbed_morphospecies_binomial AS "speciesBinomialWithMorphospecies@VegCore@vegpath.org",
|
|
| 6791 |
taxon_scrub.scrubbed_morphospecies_binomial AS "speciesBinomialWithMorphospecies__@VegCore__@vegpath.org",
|
|
| 6792 | 6792 |
taxonoccurrence.growthform AS "growthForm", |
| 6793 |
plantobservation.reproductivecondition AS "reproductiveCondition@DwC@vegpath.org",
|
|
| 6793 |
plantobservation.reproductivecondition AS "reproductiveCondition__@DwC__@vegpath.org",
|
|
| 6794 | 6794 |
((threatened_taxonlabel.taxonlabel_id IS NOT NULL))::integer AS threatened_bien, |
| 6795 | 6795 |
(((cultivated_family_locations.country IS NOT NULL) OR _or(taxonoccurrence.iscultivated, "plot.**".location__cultivated__bien)))::integer AS cultivated_bien, |
| 6796 | 6796 |
CASE |
| ... | ... | |
| 6798 | 6798 |
WHEN ("plot.**".location__cultivated__bien IS NOT NULL) THEN NULL::text
|
| 6799 | 6799 |
ELSE NULL::text |
| 6800 | 6800 |
END AS "cultivatedBasis_bien", |
| 6801 |
aggregateoccurrence.notes AS "occurrenceRemarks@DwC@vegpath.org",
|
|
| 6802 |
_fraction_to_percent(aggregateoccurrence.cover_fraction) AS "coverPercent@VegX.attribute.ordinal@vegpath.org",
|
|
| 6801 |
aggregateoccurrence.notes AS "occurrenceRemarks__@DwC__@vegpath.org",
|
|
| 6802 |
_fraction_to_percent(aggregateoccurrence.cover_fraction) AS "coverPercent__@VegX__.attribute.ordinal@vegpath.org",
|
|
| 6803 | 6803 |
_m_to_cm(stemobservation.diameterbreastheight_m) AS "diameterBreastHeight_cm", |
| 6804 | 6804 |
stemobservation.height_m, |
| 6805 | 6805 |
stemobservation.tag, |
| ... | ... | |
| 6810 | 6810 |
aggregateoccurrence.sourceaccessioncode AS "aggregateOrganismObservationID", |
| 6811 | 6811 |
plantobservation.sourceaccessioncode AS "individualObservationID", |
| 6812 | 6812 |
plantobservation.authorplantcode AS "individualCode", |
| 6813 |
aggregateoccurrence.count AS "individualCount@DwC@vegpath.org",
|
|
| 6814 |
stemobservation.authorstemcode AS "stemCode@VegBank.stemlocation@vegpath.org"
|
|
| 6813 |
aggregateoccurrence.count AS "individualCount__@DwC__@vegpath.org",
|
|
| 6814 |
stemobservation.authorstemcode AS "stemCode__@VegBank__.stemlocation@vegpath.org"
|
|
| 6815 | 6815 |
FROM ((((((((((((((("plot.**"
|
| 6816 | 6816 |
LEFT JOIN taxonoccurrence ON ((taxonoccurrence.locationevent_id = "plot.**".locationevent__pkey))) |
| 6817 | 6817 |
LEFT JOIN party collector ON ((collector.party_id = taxonoccurrence.collector_id))) |
| ... | ... | |
| 6849 | 6849 |
|
| 6850 | 6850 |
|
| 6851 | 6851 |
-- |
| 6852 |
-- Name: COLUMN analytical_stem_view."country@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6852 |
-- Name: COLUMN analytical_stem_view."country__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6853 | 6853 |
-- |
| 6854 | 6854 |
|
| 6855 |
COMMENT ON COLUMN analytical_stem_view."country@DwC@vegpath.org" IS 'geoscrub.geoscrub_output.acceptedCountry@VegBIEN@vegpath.org;
|
|
| 6855 |
COMMENT ON COLUMN analytical_stem_view."country__@DwC__@vegpath.org" IS 'geoscrub.geoscrub_output.acceptedCountry@VegBIEN@vegpath.org;
|
|
| 6856 | 6856 |
"The name of the country or major administrative unit in which the Location occurs"'; |
| 6857 | 6857 |
|
| 6858 | 6858 |
|
| 6859 | 6859 |
-- |
| 6860 |
-- Name: COLUMN analytical_stem_view."stateProvince@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6860 |
-- Name: COLUMN analytical_stem_view."stateProvince__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6861 | 6861 |
-- |
| 6862 | 6862 |
|
| 6863 |
COMMENT ON COLUMN analytical_stem_view."stateProvince@DwC@vegpath.org" IS '"The name of the next smaller administrative region than country (state, province, canton, department, region, etc.) in which the Location occurs"';
|
|
| 6863 |
COMMENT ON COLUMN analytical_stem_view."stateProvince__@DwC__@vegpath.org" IS '"The name of the next smaller administrative region than country (state, province, canton, department, region, etc.) in which the Location occurs"';
|
|
| 6864 | 6864 |
|
| 6865 | 6865 |
|
| 6866 | 6866 |
-- |
| 6867 |
-- Name: COLUMN analytical_stem_view."county@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6867 |
-- Name: COLUMN analytical_stem_view."county__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6868 | 6868 |
-- |
| 6869 | 6869 |
|
| 6870 |
COMMENT ON COLUMN analytical_stem_view."county@DwC@vegpath.org" IS '"The full, unabbreviated name of the next smaller administrative region than stateProvince (county, shire, department, etc.) in which the Location occurs"';
|
|
| 6870 |
COMMENT ON COLUMN analytical_stem_view."county__@DwC__@vegpath.org" IS '"The full, unabbreviated name of the next smaller administrative region than stateProvince (county, shire, department, etc.) in which the Location occurs"';
|
|
| 6871 | 6871 |
|
| 6872 | 6872 |
|
| 6873 | 6873 |
-- |
| 6874 |
-- Name: COLUMN analytical_stem_view."locality@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6874 |
-- Name: COLUMN analytical_stem_view."locality__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6875 | 6875 |
-- |
| 6876 | 6876 |
|
| 6877 |
COMMENT ON COLUMN analytical_stem_view."locality@DwC@vegpath.org" IS '"The specific description of the place"';
|
|
| 6877 |
COMMENT ON COLUMN analytical_stem_view."locality__@DwC__@vegpath.org" IS '"The specific description of the place"';
|
|
| 6878 | 6878 |
|
| 6879 | 6879 |
|
| 6880 | 6880 |
-- |
| 6881 |
-- Name: COLUMN analytical_stem_view."decimalLatitude@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6881 |
-- Name: COLUMN analytical_stem_view."decimalLatitude__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6882 | 6882 |
-- |
| 6883 | 6883 |
|
| 6884 |
COMMENT ON COLUMN analytical_stem_view."decimalLatitude@DwC@vegpath.org" IS '"The geographic latitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"';
|
|
| 6884 |
COMMENT ON COLUMN analytical_stem_view."decimalLatitude__@DwC__@vegpath.org" IS '"The geographic latitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"';
|
|
| 6885 | 6885 |
|
| 6886 | 6886 |
|
| 6887 | 6887 |
-- |
| 6888 |
-- Name: COLUMN analytical_stem_view."decimalLongitude@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6888 |
-- Name: COLUMN analytical_stem_view."decimalLongitude__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6889 | 6889 |
-- |
| 6890 | 6890 |
|
| 6891 |
COMMENT ON COLUMN analytical_stem_view."decimalLongitude@DwC@vegpath.org" IS '"The geographic longitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"';
|
|
| 6891 |
COMMENT ON COLUMN analytical_stem_view."decimalLongitude__@DwC__@vegpath.org" IS '"The geographic longitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"';
|
|
| 6892 | 6892 |
|
| 6893 | 6893 |
|
| 6894 | 6894 |
-- |
| 6895 |
-- Name: COLUMN analytical_stem_view."coordinateUncertaintyInMeters@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6895 |
-- Name: COLUMN analytical_stem_view."coordinateUncertaintyInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6896 | 6896 |
-- |
| 6897 | 6897 |
|
| 6898 |
COMMENT ON COLUMN analytical_stem_view."coordinateUncertaintyInMeters@DwC@vegpath.org" IS '"The horizontal distance (in meters) from the given decimalLatitude and decimalLongitude describing the smallest circle containing the whole of the Location"';
|
|
| 6898 |
COMMENT ON COLUMN analytical_stem_view."coordinateUncertaintyInMeters__@DwC__@vegpath.org" IS '"The horizontal distance (in meters) from the given decimalLatitude and decimalLongitude describing the smallest circle containing the whole of the Location"';
|
|
| 6899 | 6899 |
|
| 6900 | 6900 |
|
| 6901 | 6901 |
-- |
| ... | ... | |
| 6927 | 6927 |
|
| 6928 | 6928 |
|
| 6929 | 6929 |
-- |
| 6930 |
-- Name: COLUMN analytical_stem_view."projectID@VegX.plotObservation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6930 |
-- Name: COLUMN analytical_stem_view."projectID__@VegX__.plotObservation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6931 | 6931 |
-- |
| 6932 | 6932 |
|
| 6933 |
COMMENT ON COLUMN analytical_stem_view."projectID@VegX.plotObservation@vegpath.org" IS 'project.sourceaccessioncode@VegBIEN.public@vegpath.org;
|
|
| 6933 |
COMMENT ON COLUMN analytical_stem_view."projectID__@VegX__.plotObservation@vegpath.org" IS 'project.sourceaccessioncode@VegBIEN.public@vegpath.org;
|
|
| 6934 | 6934 |
"A reference to a specific ''project''"'; |
| 6935 | 6935 |
|
| 6936 | 6936 |
|
| ... | ... | |
| 6942 | 6942 |
|
| 6943 | 6943 |
|
| 6944 | 6944 |
-- |
| 6945 |
-- Name: COLUMN analytical_stem_view."locationID@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6945 |
-- Name: COLUMN analytical_stem_view."locationID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6946 | 6946 |
-- |
| 6947 | 6947 |
|
| 6948 |
COMMENT ON COLUMN analytical_stem_view."locationID@DwC@vegpath.org" IS '"An identifier for the set of location information (data associated with dcterms:Location)"';
|
|
| 6948 |
COMMENT ON COLUMN analytical_stem_view."locationID__@DwC__@vegpath.org" IS '"An identifier for the set of location information (data associated with dcterms:Location)"';
|
|
| 6949 | 6949 |
|
| 6950 | 6950 |
|
| 6951 | 6951 |
-- |
| 6952 |
-- Name: COLUMN analytical_stem_view."plotName@VegX.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6952 |
-- Name: COLUMN analytical_stem_view."plotName__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6953 | 6953 |
-- |
| 6954 | 6954 |
|
| 6955 |
COMMENT ON COLUMN analytical_stem_view."plotName@VegX.plot@vegpath.org" IS '"Name or label for a plot"';
|
|
| 6955 |
COMMENT ON COLUMN analytical_stem_view."plotName__@VegX__.plot@vegpath.org" IS '"Name or label for a plot"';
|
|
| 6956 | 6956 |
|
| 6957 | 6957 |
|
| 6958 | 6958 |
-- |
| 6959 |
-- Name: COLUMN analytical_stem_view."subplot@SALVIAS@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6959 |
-- Name: COLUMN analytical_stem_view."subplot__@SALVIAS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6960 | 6960 |
-- |
| 6961 | 6961 |
|
| 6962 |
COMMENT ON COLUMN analytical_stem_view."subplot@SALVIAS@vegpath.org" IS 'location.authorlocationcode@VegBIEN.public@vegpath.org;
|
|
| 6962 |
COMMENT ON COLUMN analytical_stem_view."subplot__@SALVIAS__@vegpath.org" IS 'location.authorlocationcode@VegBIEN.public@vegpath.org;
|
|
| 6963 | 6963 |
"Code for subplot, line, or any other subsample or subdivision of plot"'; |
| 6964 | 6964 |
|
| 6965 | 6965 |
|
| ... | ... | |
| 6971 | 6971 |
|
| 6972 | 6972 |
|
| 6973 | 6973 |
-- |
| 6974 |
-- Name: COLUMN analytical_stem_view."locationevent.locationevent_id@VegBIEN.public@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6974 |
-- Name: COLUMN analytical_stem_view."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6975 | 6975 |
-- |
| 6976 | 6976 |
|
| 6977 |
COMMENT ON COLUMN analytical_stem_view."locationevent.locationevent_id@VegBIEN.public@vegpath.org" IS 'locationevent.locationevent_id@VegBIEN.public@vegpath.org;
|
|
| 6977 |
COMMENT ON COLUMN analytical_stem_view."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org" IS 'locationevent.locationevent_id@VegBIEN.public@vegpath.org;
|
|
| 6978 | 6978 |
autogenerated ID for locationevent'; |
| 6979 | 6979 |
|
| 6980 | 6980 |
|
| 6981 | 6981 |
-- |
| 6982 |
-- Name: COLUMN analytical_stem_view."eventDate@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6982 |
-- Name: COLUMN analytical_stem_view."eventDate__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6983 | 6983 |
-- |
| 6984 | 6984 |
|
| 6985 |
COMMENT ON COLUMN analytical_stem_view."eventDate@DwC@vegpath.org" IS '"The date-time or interval during which an Event occurred. For occurrences, this is the date-time when the event was recorded."';
|
|
| 6985 |
COMMENT ON COLUMN analytical_stem_view."eventDate__@DwC__@vegpath.org" IS '"The date-time or interval during which an Event occurred. For occurrences, this is the date-time when the event was recorded."';
|
|
| 6986 | 6986 |
|
| 6987 | 6987 |
|
| 6988 | 6988 |
-- |
| ... | ... | |
| 6993 | 6993 |
|
| 6994 | 6994 |
|
| 6995 | 6995 |
-- |
| 6996 |
-- Name: COLUMN analytical_stem_view."slopeAspect@VegX.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6996 |
-- Name: COLUMN analytical_stem_view."slopeAspect__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 6997 | 6997 |
-- |
| 6998 | 6998 |
|
| 6999 |
COMMENT ON COLUMN analytical_stem_view."slopeAspect@VegX.plot@vegpath.org" IS '"Representative azimuth of slope gradient (0-360 degrees) or as a cardinal direction (e.g. N, S, NE)"';
|
|
| 6999 |
COMMENT ON COLUMN analytical_stem_view."slopeAspect__@VegX__.plot@vegpath.org" IS '"Representative azimuth of slope gradient (0-360 degrees) or as a cardinal direction (e.g. N, S, NE)"';
|
|
| 7000 | 7000 |
|
| 7001 | 7001 |
|
| 7002 | 7002 |
-- |
| 7003 |
-- Name: COLUMN analytical_stem_view."slopeGradient@VegX.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7003 |
-- Name: COLUMN analytical_stem_view."slopeGradient__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7004 | 7004 |
-- |
| 7005 | 7005 |
|
| 7006 |
COMMENT ON COLUMN analytical_stem_view."slopeGradient@VegX.plot@vegpath.org" IS '"Representative inclination of slope in degrees"';
|
|
| 7006 |
COMMENT ON COLUMN analytical_stem_view."slopeGradient__@VegX__.plot@vegpath.org" IS '"Representative inclination of slope in degrees"';
|
|
| 7007 | 7007 |
|
| 7008 | 7008 |
|
| 7009 | 7009 |
-- |
| ... | ... | |
| 7014 | 7014 |
|
| 7015 | 7015 |
|
| 7016 | 7016 |
-- |
| 7017 |
-- Name: COLUMN analytical_stem_view."samplingProtocol@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7017 |
-- Name: COLUMN analytical_stem_view."samplingProtocol__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7018 | 7018 |
-- |
| 7019 | 7019 |
|
| 7020 |
COMMENT ON COLUMN analytical_stem_view."samplingProtocol@DwC@vegpath.org" IS '"The name of, reference to, or description of the method or protocol used during an Event"';
|
|
| 7020 |
COMMENT ON COLUMN analytical_stem_view."samplingProtocol__@DwC__@vegpath.org" IS '"The name of, reference to, or description of the method or protocol used during an Event"';
|
|
| 7021 | 7021 |
|
| 7022 | 7022 |
|
| 7023 | 7023 |
-- |
| ... | ... | |
| 7077 | 7077 |
|
| 7078 | 7078 |
|
| 7079 | 7079 |
-- |
| 7080 |
-- Name: COLUMN analytical_stem_view."occurrenceID@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7080 |
-- Name: COLUMN analytical_stem_view."occurrenceID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7081 | 7081 |
-- |
| 7082 | 7082 |
|
| 7083 |
COMMENT ON COLUMN analytical_stem_view."occurrenceID@DwC@vegpath.org" IS '"An identifier for the Occurrence (as opposed to a particular digital record of the occurrence). In the absence of a persistent global unique identifier, construct one from a combination of identifiers in the record that will most closely make the occurrenceID globally unique."';
|
|
| 7083 |
COMMENT ON COLUMN analytical_stem_view."occurrenceID__@DwC__@vegpath.org" IS '"An identifier for the Occurrence (as opposed to a particular digital record of the occurrence). In the absence of a persistent global unique identifier, construct one from a combination of identifiers in the record that will most closely make the occurrenceID globally unique."';
|
|
| 7084 | 7084 |
|
| 7085 | 7085 |
|
| 7086 | 7086 |
-- |
| 7087 |
-- Name: COLUMN analytical_stem_view."recordedBy@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7087 |
-- Name: COLUMN analytical_stem_view."recordedBy__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7088 | 7088 |
-- |
| 7089 | 7089 |
|
| 7090 |
COMMENT ON COLUMN analytical_stem_view."recordedBy@DwC@vegpath.org" IS '"A list (concatenated and separated) of names of people, groups, or organizations responsible for recording the original Occurrence. The primary collector or observer, especially one who applies a personal identifier (recordNumber), should be listed first."';
|
|
| 7090 |
COMMENT ON COLUMN analytical_stem_view."recordedBy__@DwC__@vegpath.org" IS '"A list (concatenated and separated) of names of people, groups, or organizations responsible for recording the original Occurrence. The primary collector or observer, especially one who applies a personal identifier (recordNumber), should be listed first."';
|
|
| 7091 | 7091 |
|
| 7092 | 7092 |
|
| 7093 | 7093 |
-- |
| 7094 |
-- Name: COLUMN analytical_stem_view."recordNumber@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7094 |
-- Name: COLUMN analytical_stem_view."recordNumber__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7095 | 7095 |
-- |
| 7096 | 7096 |
|
| 7097 |
COMMENT ON COLUMN analytical_stem_view."recordNumber@DwC@vegpath.org" IS '"An identifier given to the Occurrence at the time it was recorded. Often serves as a link between field notes and an Occurrence record, such as a specimen collector''s number."';
|
|
| 7097 |
COMMENT ON COLUMN analytical_stem_view."recordNumber__@DwC__@vegpath.org" IS '"An identifier given to the Occurrence at the time it was recorded. Often serves as a link between field notes and an Occurrence record, such as a specimen collector''s number."';
|
|
| 7098 | 7098 |
|
| 7099 | 7099 |
|
| 7100 | 7100 |
-- |
| ... | ... | |
| 7119 | 7119 |
|
| 7120 | 7120 |
|
| 7121 | 7121 |
-- |
| 7122 |
-- Name: COLUMN analytical_stem_view."identifiedBy@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7122 |
-- Name: COLUMN analytical_stem_view."identifiedBy__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7123 | 7123 |
-- |
| 7124 | 7124 |
|
| 7125 |
COMMENT ON COLUMN analytical_stem_view."identifiedBy@DwC@vegpath.org" IS '"A list (concatenated and separated) of names of people, groups, or organizations who assigned the Taxon to the subject"';
|
|
| 7125 |
COMMENT ON COLUMN analytical_stem_view."identifiedBy__@DwC__@vegpath.org" IS '"A list (concatenated and separated) of names of people, groups, or organizations who assigned the Taxon to the subject"';
|
|
| 7126 | 7126 |
|
| 7127 | 7127 |
|
| 7128 | 7128 |
-- |
| 7129 |
-- Name: COLUMN analytical_stem_view."dateIdentified@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7129 |
-- Name: COLUMN analytical_stem_view."dateIdentified__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7130 | 7130 |
-- |
| 7131 | 7131 |
|
| 7132 |
COMMENT ON COLUMN analytical_stem_view."dateIdentified@DwC@vegpath.org" IS '"The date on which the subject was identified as representing the Taxon"';
|
|
| 7132 |
COMMENT ON COLUMN analytical_stem_view."dateIdentified__@DwC__@vegpath.org" IS '"The date on which the subject was identified as representing the Taxon"';
|
|
| 7133 | 7133 |
|
| 7134 | 7134 |
|
| 7135 | 7135 |
-- |
| 7136 |
-- Name: COLUMN analytical_stem_view."identificationRemarks@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7136 |
-- Name: COLUMN analytical_stem_view."identificationRemarks__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7137 | 7137 |
-- |
| 7138 | 7138 |
|
| 7139 |
COMMENT ON COLUMN analytical_stem_view."identificationRemarks@DwC@vegpath.org" IS '"Comments or notes about the Identification"';
|
|
| 7139 |
COMMENT ON COLUMN analytical_stem_view."identificationRemarks__@DwC__@vegpath.org" IS '"Comments or notes about the Identification"';
|
|
| 7140 | 7140 |
|
| 7141 | 7141 |
|
| 7142 | 7142 |
-- |
| 7143 |
-- Name: COLUMN analytical_stem_view."Family_matched@TNRS@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7143 |
-- Name: COLUMN analytical_stem_view."Family_matched__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7144 | 7144 |
-- |
| 7145 | 7145 |
|
| 7146 |
COMMENT ON COLUMN analytical_stem_view."Family_matched@TNRS@vegpath.org" IS 'TNRS.taxon_scrub.matchedFamily@VegBIEN.public@vegpath.org;
|
|
| 7146 |
COMMENT ON COLUMN analytical_stem_view."Family_matched__@TNRS__@vegpath.org" IS 'TNRS.taxon_scrub.matchedFamily@VegBIEN.public@vegpath.org;
|
|
| 7147 | 7147 |
"The closest matching family in the TNRS database to the family submitted"'; |
| 7148 | 7148 |
|
| 7149 | 7149 |
|
| ... | ... | |
| 7225 | 7225 |
|
| 7226 | 7226 |
|
| 7227 | 7227 |
-- |
| 7228 |
-- Name: COLUMN analytical_stem_view."speciesBinomialWithMorphospecies@VegCore@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7228 |
-- Name: COLUMN analytical_stem_view."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7229 | 7229 |
-- |
| 7230 | 7230 |
|
| 7231 |
COMMENT ON COLUMN analytical_stem_view."speciesBinomialWithMorphospecies@VegCore@vegpath.org" IS 'TNRS.taxon_scrub.scrubbed_morphospecies_binomial@VegBIEN.public@vegpath.org;
|
|
| 7231 |
COMMENT ON COLUMN analytical_stem_view."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org" IS 'TNRS.taxon_scrub.scrubbed_morphospecies_binomial@VegBIEN.public@vegpath.org;
|
|
| 7232 | 7232 |
"combine the `taxon` plus `morphospecies` to produce a unique string, `taxonMorphospecies`"'; |
| 7233 | 7233 |
|
| 7234 | 7234 |
|
| ... | ... | |
| 7240 | 7240 |
|
| 7241 | 7241 |
|
| 7242 | 7242 |
-- |
| 7243 |
-- Name: COLUMN analytical_stem_view."reproductiveCondition@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7243 |
-- Name: COLUMN analytical_stem_view."reproductiveCondition__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7244 | 7244 |
-- |
| 7245 | 7245 |
|
| 7246 |
COMMENT ON COLUMN analytical_stem_view."reproductiveCondition@DwC@vegpath.org" IS '"The reproductive condition of the biological individual(s) represented in the Occurrence. Recommended best practice is to use a controlled vocabulary."';
|
|
| 7246 |
COMMENT ON COLUMN analytical_stem_view."reproductiveCondition__@DwC__@vegpath.org" IS '"The reproductive condition of the biological individual(s) represented in the Occurrence. Recommended best practice is to use a controlled vocabulary."';
|
|
| 7247 | 7247 |
|
| 7248 | 7248 |
|
| 7249 | 7249 |
-- |
| ... | ... | |
| 7268 | 7268 |
|
| 7269 | 7269 |
|
| 7270 | 7270 |
-- |
| 7271 |
-- Name: COLUMN analytical_stem_view."occurrenceRemarks@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7271 |
-- Name: COLUMN analytical_stem_view."occurrenceRemarks__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7272 | 7272 |
-- |
| 7273 | 7273 |
|
| 7274 |
COMMENT ON COLUMN analytical_stem_view."occurrenceRemarks@DwC@vegpath.org" IS '"Comments or notes about the Occurrence"';
|
|
| 7274 |
COMMENT ON COLUMN analytical_stem_view."occurrenceRemarks__@DwC__@vegpath.org" IS '"Comments or notes about the Occurrence"';
|
|
| 7275 | 7275 |
|
| 7276 | 7276 |
|
| 7277 | 7277 |
-- |
| 7278 |
-- Name: COLUMN analytical_stem_view."coverPercent@VegX.attribute.ordinal@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7278 |
-- Name: COLUMN analytical_stem_view."coverPercent__@VegX__.attribute.ordinal@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7279 | 7279 |
-- |
| 7280 | 7280 |
|
| 7281 |
COMMENT ON COLUMN analytical_stem_view."coverPercent@VegX.attribute.ordinal@vegpath.org" IS '"Average cover of the index in percent"';
|
|
| 7281 |
COMMENT ON COLUMN analytical_stem_view."coverPercent__@VegX__.attribute.ordinal@vegpath.org" IS '"Average cover of the index in percent"';
|
|
| 7282 | 7282 |
|
| 7283 | 7283 |
|
| 7284 | 7284 |
-- |
| ... | ... | |
| 7352 | 7352 |
|
| 7353 | 7353 |
|
| 7354 | 7354 |
-- |
| 7355 |
-- Name: COLUMN analytical_stem_view."individualCount@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7355 |
-- Name: COLUMN analytical_stem_view."individualCount__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7356 | 7356 |
-- |
| 7357 | 7357 |
|
| 7358 |
COMMENT ON COLUMN analytical_stem_view."individualCount@DwC@vegpath.org" IS '"The number of individuals represented present at the time of the Occurrence"';
|
|
| 7358 |
COMMENT ON COLUMN analytical_stem_view."individualCount__@DwC__@vegpath.org" IS '"The number of individuals represented present at the time of the Occurrence"';
|
|
| 7359 | 7359 |
|
| 7360 | 7360 |
|
| 7361 | 7361 |
-- |
| 7362 |
-- Name: COLUMN analytical_stem_view."stemCode@VegBank.stemlocation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7362 |
-- Name: COLUMN analytical_stem_view."stemCode__@VegBank__.stemlocation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
|
| 7363 | 7363 |
-- |
| 7364 | 7364 |
|
| 7365 |
COMMENT ON COLUMN analytical_stem_view."stemCode@VegBank.stemlocation@vegpath.org" IS 'stemobservation.authorstemcode@VegBIEN.public@vegpath.org;
|
|
| 7365 |
COMMENT ON COLUMN analytical_stem_view."stemCode__@VegBank__.stemlocation@vegpath.org" IS 'stemobservation.authorstemcode@VegBIEN.public@vegpath.org;
|
|
| 7366 | 7366 |
"Name or code applied to a specific stem in the plot. This is generally a numeric label to associate a field data entry with a stem in the database."'; |
| 7367 | 7367 |
|
| 7368 | 7368 |
|
Also available in: Unified diff
schemas/public_.sql: analytical_stem_view: applied data dictionary renamings, using the steps at wiki.vegpath.org/VegBIEN_schema_refactoring#apply-data-dictionary-renamings-to-database