-- Name: _fraction_to_percent(double precision); Type: FUNCTION; Schema: public; Owner: bien

--

CREATE FUNCTION _fraction_to_percent(value double precision) RETURNS double precision

    LANGUAGE sql IMMUTABLE STRICT

    AS $_$

SELECT $1*100.

$_$;

ALTER FUNCTION public._fraction_to_percent(value double precision) OWNER TO bien;

--

    SELECT datasource.organizationname AS "dataSourceName", taxonconcept.family, taxonconcept.genus, taxonconcept.species, COALESCE(taxonconcept.taxonomicnamewithauthor, taxonconcept.taxonomicname) AS taxon, taxonconcept.author AS "taxonAuthor", taxonconcept.taxonname AS "taxonMorphospecies", placepath.country, placepath.stateprovince AS "stateProvince", placepath.county AS "countyParish", taxonoccurrence.verbatimcollectorname AS collector, plantobservation.collectionnumber AS "collectionNumber", array_to_string(ARRAY[identifiedby.givenname, identifiedby.middlename, identifiedby.surname], ' '::text) AS "identifiedBy", aggregateoccurrence.collectiondate AS "observationDate", location.authorlocationcode AS "plotCode", functions._m2_to_ha(location.area_m2) AS "plotAreaHa", method.name AS "plotMethod", locationcoords.latitude_deg AS latitude, locationcoords.longitude_deg AS longitude, location.elevation_m, taxonoccurrence.iscultivated AS "isCultivated", taxonoccurrence.cultivatedbasis AS "isCultivatedReason", _fraction_to_percent(aggregateoccurrence.cover_fraction) AS "pctCover" FROM (((((((((((((location JOIN party datasource ON (((datasource.party_id = location.creator_id) AND (datasource.organizationname IS NOT NULL)))) LEFT JOIN locationcoords USING (location_id)) LEFT JOIN locationplace USING (location_id)) LEFT JOIN placepath USING (placepath_id)) JOIN locationevent USING (location_id)) LEFT JOIN method USING (method_id)) JOIN taxonoccurrence USING (locationevent_id)) JOIN taxondetermination USING (taxonoccurrence_id)) LEFT JOIN party identifiedby ON ((identifiedby.party_id = taxondetermination.party_id))) JOIN taxonconcept USING (taxonconcept_id)) LEFT JOIN aggregateoccurrence USING (taxonoccurrence_id)) LEFT JOIN plantobservation USING (aggregateoccurrence_id)) LEFT JOIN specimenreplicate USING (plantobservation_id));

725	2	1	\N	18	380	\N	\N	\N	\N	\N	\N	Poa annua	\N	\N	\N	\N	\N	\N	\N

728	2	2	\N	18	18	\N	\N	\N	\N	\N	\N	Poa annua L.	\N	\N	\N	\N	\N	\N	\N

731	2	3	\N	18	570	\N	\N	\N	\N	\N	\N	Poa annua var. eriolepis	\N	\N	\N	\N	\N	\N	\N

734	2	4	\N	94	494	\N	\N	\N	\N	\N	\N	Poa annua subsp. exilis	\N	\N	\N	\N	\N	\N	\N

737	2	5	\N	94	456	\N	\N	\N	\N	\N	\N	Poa annua ssp. exilis	\N	\N	\N	\N	\N	\N	\N

740	2	6	\N	512	532	\N	\N	\N	\N	\N	\N	Poa annua subvar. minima	\N	\N	\N	\N	\N	\N	\N

743	2	7	\N	56	418	\N	\N	\N	\N	\N	\N	Poa annua fo. lanuginosa	\N	\N	\N	\N	\N	\N	\N

746	2	8	\N	588	646	\N	\N	\N	\N	\N	\N	Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire	\N	\N	\N	\N	\N	\N	\N

749	2	9	\N	588	608	\N	\N	\N	\N	\N	\N	Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire	\N	\N	\N	\N	\N	\N	\N

752	2	10	\N	246	304	\N	\N	\N	\N	\N	\N	Fabaceae Inga sp.3	\N	\N	\N	\N	\N	\N	\N

755	2	11	\N	246	266	\N	\N	\N	\N	\N	\N	Fabaceae Inga "fuzzy leaf"	\N	\N	\N	\N	\N	\N	\N

758	2	12	\N	208	342	\N	\N	\N	\N	\N	\N	Fabaceae unknown #2	\N	\N	\N	\N	\N	\N	\N

761	2	13	\N	208	228	\N	\N	\N	\N	\N	\N	Fabaceae Boyle#6500	\N	\N	\N	\N	\N	\N	\N

764	2	14	\N	\N	684	\N	\N	\N	\N	\N	\N	Fam_indet. Boyle#6501	\N	\N	\N	\N	\N	\N	\N

767	2	15	\N	132	190	\N	\N	\N	\N	\N	\N	Compositae indet. sp.1	\N	\N	\N	\N	\N	\N	\N