sublocationxposition_m double precision,

    sublocationyposition_m double precision,

    area_m2 double precision,

    elevation_m double precision,

    elevationaccuracy_m double precision,

    elevationrange_m double precision,

    slopeaspect_deg double precision,

    minslopeaspect_deg double precision,

    maxslopeaspect_deg double precision,

    slopegradient_frac double precision,

    minslopegradient_frac double precision,

    maxslopegradient_frac double precision,

    latitude_deg double precision,

    longitude_deg double precision,

    coordsaccuracy_deg double precision,

-- Name: COLUMN locationcoords.coordsaccuracy_deg; Type: COMMENT; Schema: public; Owner: -

    temperature_c double precision,

    precipitation_m double precision,

    waterdepth_m double precision,

    overallheight_m double precision,

    overallheightaccuracy_m double precision,

    SELECT datasource.organizationname AS `dataSourceName`, taxonpath.family, taxonpath.genus, taxonpath.species, COALESCE(taxonpath.scientificnamewithauthor, taxonpath.scientificname) AS taxon, taxonpath.scientificnameauthor AS `taxonAuthor`, taxonpath.variety 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], CAST(' ' AS text)) AS `identifiedBy`, aggregateoccurrence.collectiondate AS `observationDate`, location.authorlocationcode AS `plotCode`, 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`, aggregateoccurrence.cover AS `pctCover` FROM (((((((((((((location JOIN party datasource ON (((datasource.party_id = location.datasource_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 taxonpath USING (taxonpath_id)) LEFT JOIN aggregateoccurrence USING (taxonoccurrence_id)) LEFT JOIN plantobservation USING (aggregateoccurrence_id)) LEFT JOIN specimenreplicate USING (plantobservation_id));

    xposition_m double precision,

    yposition_m double precision,

    diameterbreastheight_m double precision,

    basaldiameter_m double precision,

    diameteraccuracy_m double precision,

    height_m double precision,

    heightfirstbranch_m double precision,

    heightaccuracy_m double precision,