Revision 8789
Added by Aaron Marcuse-Kubitza over 11 years ago
| vegbien.sql | ||
|---|---|---|
| 3780 | 3780 |
-- |
| 3781 | 3781 |
|
| 3782 | 3782 |
CREATE VIEW range_modeling_input AS |
| 3783 |
SELECT analytical_stem_view.datasource AS source, analytical_stem_view."institutionCode" AS first_publisher, analytical_stem_view."decimalLatitude" AS latitude_deg, analytical_stem_view."decimalLongitude" AS longitude_deg, analytical_stem_view.geovalid_bien AS geovalid, analytical_stem_view."speciesBinomialWithMorphospecies" AS species_taxon_name FROM analytical_stem_view;
|
|
| 3783 |
SELECT analytical_stem.datasource AS source, analytical_stem."institutionCode" AS first_publisher, analytical_stem."decimalLatitude" AS latitude_deg, analytical_stem."decimalLongitude" AS longitude_deg, analytical_stem.geovalid_bien AS geovalid, analytical_stem."speciesBinomialWithMorphospecies" AS species_taxon_name FROM analytical_stem;
|
|
| 3784 | 3784 |
|
| 3785 | 3785 |
|
| 3786 | 3786 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: range_modeling_input: use analytical_stem instead of analytical_stem_view because it takes a long time (~2 min) to get a row from the left-joined view, due to the large number of joins and large number of rows in the joined tables