COPY address (address_id, party_id, organization_id, orgposition, email, deliverypoint, city, administrativearea, postalcode, country, currentflag, addressstartdate) FROM stdin;

\.

COPY aggregateoccurrence (aggregateoccurrence_id, reference_id, sourceaccessioncode, taxonoccurrence_id, collectiondate, cover_fraction, linecover_m, basalarea_m2, biomass_kg_m2, inferencearea_m2, count, stratum_id, coverindex_id, occurrencestatus_dwc, method_id, notes, accessioncode) FROM stdin;

\.

COPY analytical_aggregate ("institutionCode", country, "stateProvince", county, "decimalLatitude", "decimalLongitude", "georeferenceValid", "isNewWorld", "distanceToCountry_km", "distanceToStateProvince_km", "plotName", "elevationInMeters", "plotArea_ha", "samplingProtocol", "dateCollected", family, genus, "speciesBinomial", "scientificName", "scientificNameAuthorship", "scientificNameWithMorphospecies", "growthForm", cultivated, "cultivatedBasis", "coverPercent", "individualCount", "individualCount_1cm_or_more", "individualCount_2_5cm_or_more", "individualCount_10cm_or_more") FROM stdin;

\.

COPY analytical_stem ("institutionCode", country, "stateProvince", county, "decimalLatitude", "decimalLongitude", "georeferenceValid", "isNewWorld", "distanceToCountry_km", "distanceToStateProvince_km", "plotName", "elevationInMeters", "plotArea_ha", "samplingProtocol", "dateCollected", family, genus, "speciesBinomial", "scientificName", "scientificNameAuthorship", "scientificNameWithMorphospecies", "identifiedBy", "growthForm", cultivated, "cultivatedBasis", "coverPercent", "diameterBreastHeight_cm", height_m, tag, "organismX_m", "organismY_m", "recordedBy", "recordNumber") FROM stdin;

\.

COPY classcontributor (classcontributor_id, commclass_id, party_id, role) FROM stdin;

\.

COPY commclass (commclass_id, locationevent_id, inspection, tableanalysis, multivariateanalysis, classpublication_id, classnotes, commname, commcode, commframework, commlevel, classstartdate, classstopdate, expertsystem, accessioncode) FROM stdin;

\.

COPY commconcept (commconcept_id, commname_id, reference_id, commdescription, d_obscount, commname, d_currentaccepted, accessioncode) FROM stdin;

\.

COPY commcorrelation (commcorrelation_id, commstatus_id, commconcept_id, commconvergence, correlationstart, correlationstop) FROM stdin;

\.

COPY commdetermination (commdetermination_id, commclass_id, commconcept_id, commcode, commname, classfit, classconfidence, commauthority_id, notes, type, nomenclaturaltype) FROM stdin;

\.

COPY commlineage (commlineage_id, parentcommstatus_id, childcommstatus_id) FROM stdin;

\.

COPY commname (commname_id, commname, reference_id, dateentered) FROM stdin;

\.

COPY commstatus (commstatus_id, commconcept_id, reference_id, commconceptstatus, commparent_id, commlevel, commpartycomments, party_id, startdate, stopdate, accessioncode) FROM stdin;

\.

COPY commusage (commusage_id, commname_id, commname, commconcept_id, commnamestatus, classsystem, party_id, commstatus_id, usagestart, usagestop) FROM stdin;

\.

COPY coordinates (coordinates_id, reference_id, latitude_deg, longitude_deg, verbatimlatitude, verbatimlongitude, verbatimcoordinates, footprintgeometry_dwc, coordsaccuracy_deg) FROM stdin;

\.

COPY coverindex (coverindex_id, covermethod_id, covercode, upperlimit, lowerlimit, coverpercent, indexdescription) FROM stdin;

\.

COPY covermethod (covermethod_id, reference_id, covertype, coverestimationmethod, accessioncode) FROM stdin;

\.

COPY definedvalue (definedvalue_id, userdefined_id, tablerecord_id, definedvalue) FROM stdin;

\.

COPY disturbanceobs (disturbanceobs_id, locationevent_id, disturbancetype, disturbanceintensity, disturbanceage, disturbanceextent, disturbancecomment) FROM stdin;

\.

COPY family_higher_plant_group (family, higher_plant_group) FROM stdin;

\.

COPY geoscrub_input (country, "stateProvince", county, "decimalLatitude", "decimalLongitude") FROM stdin;

\.

COPY graphic (graphic_id, locationevent_id, graphicname, graphiclocation, graphicdescription, graphictype, graphicdata, graphicdate, accessioncode) FROM stdin;

\.

COPY higher_plant_group_nodes (higher_plant_group, node_name) FROM stdin;

bryophytes	Anthocerotophyta

bryophytes	Marchantiophyta

bryophytes	Bryophyta

ferns and allies	Anthocerotophyta

ferns and allies	Marchantiophyta

ferns and allies	Bryophyta

ferns and allies	Moniliformopses

flowering plants	Magnoliophyta

gymnosperms (conifers)	Coniferophyta

gymnosperms (non-conifer)	Cycadophyta

gymnosperms (non-conifer)	Ginkgophyta

gymnosperms (non-conifer)	Gnetophyta

\.

COPY location (location_id, reference_id, sourceaccessioncode, parent_id, authorlocationcode, confidentialitystatus, confidentialityreason, sublocationxposition_m, sublocationyposition_m, authorzone, authordatum, authorlocation, locationnarrative, azimuth, shape, area_m2, standsize, placementmethod, permanence, layoutnarrative, elevation_m, elevationaccuracy_m, elevationrange_m, verbatimelevation, slopeaspect_deg, minslopeaspect_deg, maxslopeaspect_deg, slopegradient_fraction, minslopegradient_fraction, maxslopegradient_fraction, topoposition, landform, surficialdeposits, rocktype, submitter_surname, submitter_givenname, submitter_email, notespublic, notesmgt, revisions, dateentered, locationrationalenarrative, accessioncode) FROM stdin;

\.

COPY locationevent (locationevent_id, reference_id, sourceaccessioncode, parent_id, location_id, project_id, authoreventcode, previous_id, obsstartdate, obsenddate, dateaccuracy, method_id, temperature_c, precipitation_m, autotaxoncover, originaldata, effortlevel, floristicquality, bryophytequality, lichenquality, locationeventnarrative, landscapenarrative, homogeneity, phenologicaspect, representativeness, standmaturity, successionalstatus, basalarea, hydrologicregime, soilmoistureregime, soildrainage, watersalinity, waterdepth_m, shoredistance, soildepth, organicdepth, soiltaxon_id, soiltaxonsrc, percentbedrock, percentrockgravel, percentwood, percentlitter, percentbaresoil, percentwater, percentother, nameother, treeht, shrubht, fieldht, nonvascularht, submergedht, treecover, shrubcover, fieldcover, nonvascularcover, floatingcover, submergedcover, dominantstratum, growthform1type, growthform2type, growthform3type, growthform1cover, growthform2cover, growthform3cover, totalcover, notespublic, notesmgt, revisions, dateentered, toptaxon1name, toptaxon2name, toptaxon3name, toptaxon4name, toptaxon5name, numberoftaxa, accessioncode) FROM stdin;

\.

COPY locationeventcontributor (locationeventcontributor_id, locationevent_id, party_id, role, contributiondate) FROM stdin;

\.

COPY locationeventsynonym (locationeventsynonym_id, synonymlocationevent_id, primarylocationevent_id, party_id, role, synonymcomment, classstartdate, classstopdate, accessioncode) FROM stdin;

\.

COPY locationplace (locationplace_id, location_id, place_id, identifier_id) FROM stdin;

\.

COPY method (method_id, reference_id, name, description, diameterheight_m, mindiameter_m, maxdiameter_m, minheight_m, maxheight_m, observationtype, observationmeasure, covermethod_id, samplingfactor, coverbasis, stemsamplemethod, shape, length_m, width_m, radius_m, area_m2, samplearea_m2, subplotspacing_m, subplotmethod_id, pointsperline, accessioncode) FROM stdin;

\.

COPY methodtaxonclass (methodtaxonclass_id, method_id, taxonlabel_id, included, submethod_id, taxonclass) FROM stdin;

\.

COPY note (note_id, notelink_id, party_id, role, notetype, notetext, notedate, accessioncode) FROM stdin;

\.

COPY notelink (notelink_id, tablename, attributename, tablerecord) FROM stdin;

\.

COPY party (party_id, reference_id, fullname, salutation, givenname, middlename, surname, organizationname, currentname_id, contactinstructions, email, partytype, partypublic, d_obscount, accessioncode) FROM stdin;

\.

COPY partymember (partymember_id, parentparty_id, childparty_id, role, memberstart, memberstop) FROM stdin;

\.

COPY place (place_id, reference_id, placecode, canon_place_id, matched_place_id, coordinates_id, placename_id, continent, country, stateprovince, county, description, georeference_valid, distance_to_country_m, distance_to_state_m) FROM stdin;

\.

COPY placecorrelation (placecorrelation_id, parentplace_id, childplace_id, placeconvergence) FROM stdin;

\.

COPY placename (placename_id, parent_id, rank, placename) FROM stdin;

\.

COPY placename_ancestor (placename_id, ancestor_id) FROM stdin;

\.

COPY plant (plant_id) FROM stdin;

\.

COPY plantobservation (plantobservation_id, reference_id, sourceaccessioncode, aggregateoccurrence_id, overallheight_m, overallheightaccuracy_m, collectionnumber, stemcount, plant_id, accessioncode) FROM stdin;

\.

COPY project (project_id, reference_id, sourceaccessioncode, projectname, projectdescription, startdate, stopdate, d_obscount, d_lastlocationaddeddate, accessioncode) FROM stdin;

\.

COPY projectcontributor (projectcontributor_id, project_id, party_id, role, surname, cheatrole) FROM stdin;

\.

COPY reference (reference_id, shortname, fulltext, referencetype, title, titlesuperior, referencejournal_id, volume, issue, pagerange, totalpages, publisher, publicationplace, isbn, edition, numberofvolumes, chapternumber, reportnumber, communicationtype, degree, url, doi, additionalinfo, pubdate, accessdate, conferencedate, accessioncode) FROM stdin;

\.

COPY referencealtident (referencealtident_id, reference_id, system, identifier) FROM stdin;

\.

COPY referencecontributor (referencecontributor_id, reference_id, referenceparty_id, roletype, "position") FROM stdin;

\.

COPY referencejournal (referencejournal_id, journal, issn, abbreviation, accessioncode) FROM stdin;

\.

COPY referenceparty (referenceparty_id, type, positionname, salutation, givenname, surname, suffix, organizationname, currentparty_id, accessioncode) FROM stdin;

\.

COPY revision (revision_id, tablename, tableattribute, tablerecord, previousvaluetext, previousvaluetype, previousrevision_id, revisiondate) FROM stdin;

\.

COPY soilobs (soilobs_id, locationevent_id, horizon, description, depthtop_m, depthbottom_m, color, texture, organic_fraction, sand_fraction, silt_fraction, clay_fraction, coarse_fraction, ph, acidity_fraction, basesaturation_fraction, cationexchangecapacity_cmol_kg, conductivity, carbon_fraction, phosphorus_fraction, potassium_fraction, magnesium_fraction, nitrogen_fraction, calcium_fraction, sodium_fraction) FROM stdin;

\.

COPY soiltaxon (soiltaxon_id, soilcode, soilname, soillevel, soilparent_id, soilframework, accessioncode) FROM stdin;

\.

COPY specimen (specimen_id) FROM stdin;

\.

COPY specimenreplicate (specimenreplicate_id, reference_id, sourceaccessioncode, plantobservation_id, institution_id, collectioncode_dwc, catalognumber_dwc, description, specimen_id, accessioncode) FROM stdin;

\.

COPY stemobservation (stemobservation_id, reference_id, sourceaccessioncode, plantobservation_id, authorstemcode, tag, tags, xposition_m, yposition_m, diameterbreastheight_m, basaldiameter_m, diameteraccuracy_m, height_m, heightfirstbranch_m, heightaccuracy_m, health, age, accessioncode) FROM stdin;

\.

COPY stratum (stratum_id, locationevent_id, stratumheight, stratumbase, stratumcover, area, method_id) FROM stdin;

\.

COPY taxonalt (taxonalt_id, taxondetermination_id, taxonlabel_id, taxonaltfit, taxonaltconfidence, taxonaltnotes) FROM stdin;

\.

COPY taxonconcept (taxonlabel_id, concept_reference_id) FROM stdin;

\.

COPY taxoncorrelation (taxoncorrelation_id, taxonstatus_id, taxonlabel_id, plantconvergence, correlationstart, correlationstop) FROM stdin;

\.

COPY taxondetermination (taxondetermination_id, taxonoccurrence_id, taxonverbatim_id, party_id, role, determinationtype, reference_id, isoriginal, iscurrent, taxonfit, taxonconfidence, grouptype, notes, notespublic, notesmgt, revisions, determinationdate, accessioncode) FROM stdin;

\.

COPY taxonlabel (taxonlabel_id, reference_id, sourceaccessioncode, creationdate, taxonstatus, canon_label_id, matched_label_id, matched_label_fit_fraction, parent_id, taxonepithet, rank, taxonomicname, accessioncode) FROM stdin;

\.

COPY taxonlabel_relationship (descendant_id, ancestor_id, relationship) FROM stdin;

\.

COPY taxonlineage (taxonlineage_id, childtaxonstatus_id, parenttaxonstatus_id) FROM stdin;

\.

COPY taxonoccurrence (taxonoccurrence_id, reference_id, sourceaccessioncode, locationevent_id, authortaxoncode, verbatimcollectorname, growthform, iscultivated, cultivatedbasis, isnative, accessioncode) FROM stdin;

\.

COPY taxonstatus (taxonstatus_id, taxonlabel_id, party_id, taxonlabelstatus, reference_id, plantpartycomments, startdate, stopdate, accessioncode) FROM stdin;

\.

COPY taxonverbatim (taxonverbatim_id, taxonlabel_id, verbatimrank, taxonomicname, taxonname, author, family, genus, specific_epithet, morphospecies, description) FROM stdin;

\.

COPY telephone (telephone_id, party_id, phonenumber, phonetype) FROM stdin;

\.

COPY trait (trait_id, stemobservation_id, type, value) FROM stdin;

\.

COPY userdefined (userdefined_id, userdefinedname, userdefinedmetadata, userdefinedcategory, userdefinedtype, tablename, accessioncode) FROM stdin;

\.

COPY voucher (voucher_id, taxonoccurrence_id, specimenreplicate_id) FROM stdin;

\.