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),

);