-- Name: 2014-6-12.Jeff_Ott.climatic_range_determinants; Type: VIEW; Schema: public; Owner: -

--

CREATE VIEW "2014-6-12.Jeff_Ott.climatic_range_determinants" AS

 SELECT analytical_stem.datasource, 

    analytical_stem."decimalLatitude", 

    analytical_stem."decimalLongitude", 

    analytical_stem."coordinateUncertaintyInMeters", 

    analytical_stem."dateCollected", 

    analytical_stem."higherPlantGroup_bien" AS "higherPlantGroup", 

    analytical_stem.scrubbed_family AS family, 

    analytical_stem.scrubbed_genus AS genus, 

    analytical_stem.scrubbed_species_binomial AS "speciesBinomial", 

    analytical_stem.scrubbed_taxon_name_with_author AS "scientificName"

   FROM analytical_stem

  WHERE ((((((COALESCE((analytical_stem.geovalid_bien)::boolean, false) AND COALESCE((analytical_stem."isNewWorld_bien")::boolean, false)) AND (NOT COALESCE((analytical_stem.cultivated_bien)::boolean, false))) AND (analytical_stem.scrubbed_family IS NOT NULL)) AND (analytical_stem."decimalLatitude" IS NOT NULL)) AND (analytical_stem."decimalLongitude" IS NOT NULL)) AND COALESCE((analytical_stem."coordinateUncertaintyInMeters" <= _km_to_m((10)::double precision)), true));

--

-- Name: 2014-6-12.Jeff_Ott.climatic_range_determinants; Type: ACL; Schema: public; Owner: -

--

REVOKE ALL ON TABLE "2014-6-12.Jeff_Ott.climatic_range_determinants" FROM PUBLIC;

REVOKE ALL ON TABLE "2014-6-12.Jeff_Ott.climatic_range_determinants" FROM bien;

GRANT ALL ON TABLE "2014-6-12.Jeff_Ott.climatic_range_determinants" TO bien;

GRANT SELECT ON TABLE "2014-6-12.Jeff_Ott.climatic_range_determinants" TO bien_read;

--