-- Name: sync_aggregated_analytical_db_to_view(); Type: FUNCTION; Schema: public; Owner: -

--

--

-- Name: aggregated_analytical_db; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE aggregated_analytical_db (

    `institutionCode` text,

    country text,

    `stateProvince` text,

    county text,

    `decimalLatitude` double precision,

    `decimalLongitude` double precision,

    `plotName` text,

    `elevationInMeters` double precision,

    `plotArea_ha` double precision,

    `samplingProtocol` text,

    `dateCollected` date,

    family text,

    genus text,

    `speciesBinomial` text,

    `scientificName` text,

    `scientificNameAuthorship` text,

    `scientificNameWithMorphospecies` text,

    `individualCount` text,

    `individualCount_1_to_2_5cm` text,

    `individualCount_2_5_to_10cm` text,

    `individualCount_10cm_or_more` text

);

--

-- Name: analytical_db; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE analytical_db (

    `institutionCode` text,

    country text,

    `stateProvince` text,

    county text,

    `decimalLatitude` double precision,

    `decimalLongitude` double precision,

    `plotName` text,

    `elevationInMeters` double precision,

    `plotArea_ha` double precision,

    `samplingProtocol` text,

    `dateCollected` date,

    family text,

    genus text,

    `speciesBinomial` text,

    `scientificName` text,

    `scientificNameAuthorship` text,

    `scientificNameWithMorphospecies` text,

    `identifiedBy` text,

    `growthForm` text,

    cultivated int(1),

    `cultivatedBasis` text,

    `coverPercent` double precision,

    `diameterBreastHeight_cm` double precision,

    height_m double precision,

    tag text,

    `organismX_m` double precision,

    `organismY_m` double precision,

    `recordedBy` text,

    `recordNumber` text

);

--

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

--

--