biomass double precision,

    inferencearea double precision,

    count int(11),

    sourceaccessioncode text,

    plantobservation_id int(11),

    stratum_id int(11),

    coverindex_id int(11),

    occurrencestatus_dwc text DEFAULT 'present' NOT NULL,

    method_id int(11),

);

    confidentialityreason text,

    publiclatitude double precision,

    publiclongitude double precision,

    sublocationxposition double precision,

    sublocationyposition double precision,

    authore text,

    notesmgt int(1),

    revisions int(1),

    dateentered timestamp NULL ,

);

    location_id int(11),

    project_id int(11),

    authorlocationcode text,

    sourceaccessioncode text,

    previous_id int(11),

    dateaccuracy text,

    toptaxon3name text,

    toptaxon4name text,

    toptaxon5name text,

);

    reference_id int(11),

    name text NOT NULL,

    description text,

    diameterheight double precision,

    mindiameter double precision,

    maxdiameter double precision,

    samplearea double precision,

    subplotspacing double precision,

    subplotmethod_id int(11),

);

    overallheight double precision,

    overallheightaccuracy double precision,

    authorplantcode text,

    stemcount int(11),

    sourceaccessioncode text,

);

    stopdate timestamp NULL,

    d_obscount int(11),

    d_lastlocationaddeddate timestamp NULL,

);

    collectiondate timestamp NULL,

    museum_id int(11),

    sourceaccessioncode text,

    taxonoccurrence_id int(11) NOT NULL,

    collectionnumber text,

    specimen_id int(11),

);

    biomass double precision,

    inferencearea double precision,

    count integer,

    sourceaccessioncode text,

    plantobservation_id integer,

    stratum_id integer,

    occurrencestatus_dwc occurrencestatus_dwc DEFAULT 'present'::occurrencestatus_dwc NOT NULL,

    method_id integer,

    linecover double precision,

    CONSTRAINT aggregateoccurrence_plantobservation_count_1 CHECK (((plantobservation_id IS NULL) OR (NOT (count IS DISTINCT FROM 1))))

);

    confidentialityreason text,

    publiclatitude double precision,

    publiclongitude double precision,

    sublocationxposition double precision,

    sublocationyposition double precision,

    authore text,

    notesmgt boolean,

    revisions boolean,

    dateentered timestamp with time zone DEFAULT now(),

);

    location_id integer,

    project_id integer,

    authorlocationcode text,

    sourceaccessioncode text,

    previous_id integer,

    dateaccuracy text,

    toptaxon3name text,

    toptaxon4name text,

    toptaxon5name text,

);

    reference_id integer,

    name text NOT NULL,

    description text,

    diameterheight double precision,

    mindiameter double precision,

    maxdiameter double precision,

    samplearea double precision,

    subplotspacing double precision,

    subplotmethod_id integer,

);

    overallheight double precision,

    overallheightaccuracy double precision,

    authorplantcode text,

    stemcount integer,

    sourceaccessioncode text,

);

    stopdate timestamp with time zone,

    d_obscount integer,

    d_lastlocationaddeddate timestamp with time zone,

);

    collectiondate timestamp with time zone,

    museum_id integer,

    sourceaccessioncode text,

    taxonoccurrence_id integer NOT NULL,

    collectionnumber text,

    specimen_id integer,

);