#!/bin/bash -e

. "$(dirname "${BASH_SOURCE[0]}")"/../lib/runscripts/extract.run "$@"

# runtime: 1:10 min ("69m6.944s") @r14827 @vegbiendev

# export_only() runtime: 1:10 min ("68m31.489s") @r14827 @vegbiendev

# rowcount: 2 million observations (`wc -l`:1814106)

# view SQL:

if false; then : <<'eof'

CREATE OR REPLACE VIEW "2015-1-16.Bob_Peet.sPlot" AS 

 SELECT view_full_occurrence_individual.plot_name AS "PlotName",

    view_full_occurrence_individual.locationevent_id AS "plot GUID",

    _ha_to_m2(view_full_occurrence_individual.plot_area_ha) AS "Plot.Area (m2)",

    view_full_occurrence_individual.latitude AS "decimalLatitude",

    view_full_occurrence_individual.longitude AS "decimalLongitude",

    view_full_occurrence_individual.coord_uncertainty_m AS "coordinateUncertaintyInMeters",

    view_full_occurrence_individual.scrubbed_species_binomial AS "Species name",

    view_full_occurrence_individual.scrubbed_taxon_name_no_author AS "Scrubbed_taxon_name_no_author",

    view_full_occurrence_individual.cover_percent AS "coverPercent",

    view_full_occurrence_individual.event_date AS "EventDate",

    view_full_occurrence_individual.elevation_m AS "ElevationInMeters",

    view_full_occurrence_individual.slope_gradient_deg AS "SlopeGradient",

    view_full_occurrence_individual.slope_aspect_deg AS "SlopeAspect",

    view_full_occurrence_individual.country AS "Country",

    view_full_occurrence_individual.community_concept_name AS "CommunityConcept.Name",

    view_full_occurrence_individual.datasource,

    view_full_occurrence_individual.project_id,

    view_full_occurrence_individual.project_contributors

   FROM view_full_occurrence_individual

  WHERE (view_full_occurrence_individual.datasource = ANY ('{CVS,SALVIAS,VegBank}'::text[])) AND COALESCE(view_full_occurrence_individual.is_geovalid::boolean, true) AND NOT COALESCE(view_full_occurrence_individual.is_cultivated::boolean, false);

GRANT SELECT ON TABLE "2015-1-16.Bob_Peet.sPlot" TO bien_read;

eof

fi