Project

General

Profile

« Previous | Next » 

Revision 9406

schemas/vegbien.sql: range_modeling_input: include only plants (i.e. rows with higher_plant_group IS NOT NULL)

View differences:

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, analytical_stem."higherPlantGroup_bien" AS higher_plant_group 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 WHERE (analytical_stem."higherPlantGroup_bien" IS NOT NULL);
3784 3784

  
3785 3785

  
3786 3786
--

Also available in: Unified diff