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

--

CREATE VIEW native_status_resolver AS

 SELECT DISTINCT view_full_occurrence_individual.taxonobservation_id AS id,

    view_full_occurrence_individual.scrubbed_family AS family,

    view_full_occurrence_individual.scrubbed_genus AS genus,

    view_full_occurrence_individual.scrubbed_species_binomial AS species_binomial,

    view_full_occurrence_individual.country,

    view_full_occurrence_individual.state_province AS "stateProvince",

    view_full_occurrence_individual.county

   FROM view_full_occurrence_individual

  WHERE ((COALESCE((view_full_occurrence_individual.is_geovalid)::boolean, true) AND (COALESCE((view_full_occurrence_individual.is_new_world)::boolean, false) OR in_new_world(view_full_occurrence_individual.latitude, view_full_occurrence_individual.longitude))) AND (view_full_occurrence_individual.scrubbed_species_binomial IS NOT NULL));

--

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

--

REVOKE ALL ON TABLE native_status_resolver FROM PUBLIC;

REVOKE ALL ON TABLE native_status_resolver FROM bien;

GRANT ALL ON TABLE native_status_resolver TO bien;

GRANT SELECT ON TABLE native_status_resolver TO bien_read;

--