Project

General

Profile

« Previous | Next » 

Revision 9405

schemas/vegbien.sql: range_modeling_input: added higher_plant_group, for use in restricting rows to plants

View differences:

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