-- Name: range_modeling_input; Type: VIEW; Schema: public; Owner: -

--

--

-- Name: range_modeling_input; Type: ACL; Schema: public; Owner: -

--

--

-- Name: range_modeling_input; Type: VIEW; Schema: public; Owner: -

--

CREATE VIEW range_modeling_input AS

    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;

--

-- Name: range_modeling_input; Type: ACL; Schema: public; Owner: -

--

REVOKE ALL ON TABLE range_modeling_input FROM PUBLIC;

REVOKE ALL ON TABLE range_modeling_input FROM bien;

GRANT ALL ON TABLE range_modeling_input TO bien;

GRANT SELECT ON TABLE range_modeling_input TO bien_read;

--