Revision 14938
Added by Aaron Marcuse-Kubitza about 10 years ago
| trunk/schemas/public_.sql | ||
|---|---|---|
| 11364 | 11364 |
SELECT taxon_scrub."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" AS "scientificName", |
| 11365 | 11365 |
trait.name AS "measurementType", |
| 11366 | 11366 |
trait.value AS "measurementValue", |
| 11367 |
trait.units AS "measurementUnit" |
|
| 11368 |
FROM (((((trait |
|
| 11367 |
trait.units AS "measurementUnit", |
|
| 11368 |
"plot.**".country, |
|
| 11369 |
"plot.**".state_province, |
|
| 11370 |
"plot.**".county, |
|
| 11371 |
"plot.**".locality, |
|
| 11372 |
"plot.**".latitude, |
|
| 11373 |
"plot.**".longitude, |
|
| 11374 |
"plot.**".coord_uncertainty_m |
|
| 11375 |
FROM ((((((trait |
|
| 11369 | 11376 |
LEFT JOIN taxonoccurrence USING (taxonoccurrence_id)) |
| 11370 | 11377 |
LEFT JOIN taxondetermination ON (((taxondetermination.taxonoccurrence_id = taxonoccurrence.taxonoccurrence_id) AND taxondetermination.iscurrent))) |
| 11371 | 11378 |
LEFT JOIN taxonverbatim USING (taxonverbatim_id)) |
| 11372 | 11379 |
LEFT JOIN taxonlabel USING (taxonlabel_id)) |
| 11373 | 11380 |
LEFT JOIN "TNRS".taxon_scrub ON ((taxon_scrub."*Name_submitted" = taxonlabel.taxonomicname))) |
| 11381 |
LEFT JOIN "plot.**" USING (locationevent_id)) |
|
| 11374 | 11382 |
WHERE (taxon_scrub."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" IS NOT NULL); |
| 11375 | 11383 |
|
| 11376 | 11384 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 11364 | 11364 |
SELECT taxon_scrub."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" AS "scientificName", |
| 11365 | 11365 |
trait.name AS "measurementType", |
| 11366 | 11366 |
trait.value AS "measurementValue", |
| 11367 |
trait.units AS "measurementUnit" |
|
| 11368 |
FROM (((((trait |
|
| 11367 |
trait.units AS "measurementUnit", |
|
| 11368 |
"plot.**".country, |
|
| 11369 |
"plot.**".state_province, |
|
| 11370 |
"plot.**".county, |
|
| 11371 |
"plot.**".locality, |
|
| 11372 |
"plot.**".latitude, |
|
| 11373 |
"plot.**".longitude, |
|
| 11374 |
"plot.**".coord_uncertainty_m |
|
| 11375 |
FROM ((((((trait |
|
| 11369 | 11376 |
LEFT JOIN taxonoccurrence USING (taxonoccurrence_id)) |
| 11370 | 11377 |
LEFT JOIN taxondetermination ON (((taxondetermination.taxonoccurrence_id = taxonoccurrence.taxonoccurrence_id) AND taxondetermination.iscurrent))) |
| 11371 | 11378 |
LEFT JOIN taxonverbatim USING (taxonverbatim_id)) |
| 11372 | 11379 |
LEFT JOIN taxonlabel USING (taxonlabel_id)) |
| 11373 | 11380 |
LEFT JOIN "TNRS".taxon_scrub ON ((taxon_scrub."*Name_submitted" = taxonlabel.taxonomicname))) |
| 11381 |
LEFT JOIN "plot.**" USING (locationevent_id)) |
|
| 11374 | 11382 |
WHERE (taxon_scrub."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" IS NOT NULL); |
| 11375 | 11383 |
|
| 11376 | 11384 |
|
Also available in: Unified diff
schemas/public_.sql: taxon_trait_view: added geospatial columns