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

--

--

-- Name: VIEW top_plot; Type: COMMENT; Schema: public; Owner: -

--

--

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

--

--

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

--

CREATE VIEW top_plot AS

 SELECT location.location_id, 

    location.source_id, 

    location.sourceaccessioncode, 

    location.top_plot, 

    location.parent_id, 

    location.authorlocationcode, 

    location.place_id, 

    location.accesslevel, 

    location.accessconditions, 

    location.sublocationxposition_m, 

    location.sublocationyposition_m, 

    location.iscultivated, 

    location.authorzone, 

    location.authordatum, 

    location.authorlocation, 

    location.locationnarrative, 

    location.azimuth, 

    location.shape, 

    location.area_m2, 

    location.standsize, 

    location.placementmethod, 

    location.permanence, 

    location.layoutnarrative, 

    location.elevation_m, 

    location.elevationaccuracy_m, 

    location.elevationrange_m, 

    location.verbatimelevation, 

    location.slopeaspect_deg, 

    location.minslopeaspect_deg, 

    location.maxslopeaspect_deg, 

    location.slopegradient_fraction, 

    location.minslopegradient_fraction, 

    location.maxslopegradient_fraction, 

    location.topoposition, 

    location.landform, 

    location.surficialdeposits, 

    location.rocktype, 

    location.submitter_surname, 

    location.submitter_givenname, 

    location.submitter_email, 

    location.notespublic, 

    location.notesmgt, 

    location.revisions, 

    location.dateentered, 

    location.locationrationalenarrative

   FROM location

  WHERE (location.parent_id IS NULL);

--

-- Name: VIEW top_plot; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON VIEW top_plot IS 'when updating, use * as the column list';

--

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

--

REVOKE ALL ON TABLE top_plot FROM PUBLIC;

REVOKE ALL ON TABLE top_plot FROM bien;

GRANT ALL ON TABLE top_plot TO bien;

GRANT SELECT ON TABLE top_plot TO bien_read;

--