Revision 9405
Added by Aaron Marcuse-Kubitza over 11 years ago
schemas/vegbien.sql | ||
---|---|---|
3780 | 3780 |
-- |
3781 | 3781 |
|
3782 | 3782 |
CREATE VIEW range_modeling_input AS |
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; |
|
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, analytical_stem."higherPlantGroup_bien" AS higher_plant_group FROM analytical_stem;
|
|
3784 | 3784 |
|
3785 | 3785 |
|
3786 | 3786 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: range_modeling_input: added higher_plant_group, for use in restricting rows to plants