4752 |
4752 |
-- Data for Name: address; Type: TABLE DATA; Schema: public; Owner: -
|
4753 |
4753 |
--
|
4754 |
4754 |
|
4755 |
|
COPY address (address_id, party_id, organization_id, orgposition, email, deliverypoint, city, administrativearea, postalcode, country, currentflag, addressstartdate) FROM stdin;
|
4756 |
|
\.
|
4757 |
4755 |
|
4758 |
4756 |
|
4759 |
4757 |
--
|
4760 |
4758 |
-- Data for Name: aggregateoccurrence; Type: TABLE DATA; Schema: public; Owner: -
|
4761 |
4759 |
--
|
4762 |
4760 |
|
4763 |
|
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;
|
4764 |
|
\.
|
4765 |
4761 |
|
4766 |
4762 |
|
4767 |
4763 |
--
|
4768 |
4764 |
-- Data for Name: analytical_aggregate; Type: TABLE DATA; Schema: public; Owner: -
|
4769 |
4765 |
--
|
4770 |
4766 |
|
4771 |
|
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;
|
4772 |
|
\.
|
4773 |
4767 |
|
4774 |
4768 |
|
4775 |
4769 |
--
|
4776 |
4770 |
-- Data for Name: analytical_stem; Type: TABLE DATA; Schema: public; Owner: -
|
4777 |
4771 |
--
|
4778 |
4772 |
|
4779 |
|
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;
|
4780 |
|
\.
|
4781 |
4773 |
|
4782 |
4774 |
|
4783 |
4775 |
--
|
4784 |
4776 |
-- Data for Name: classcontributor; Type: TABLE DATA; Schema: public; Owner: -
|
4785 |
4777 |
--
|
4786 |
4778 |
|
4787 |
|
COPY classcontributor (classcontributor_id, commclass_id, party_id, role) FROM stdin;
|
4788 |
|
\.
|
4789 |
4779 |
|
4790 |
4780 |
|
4791 |
4781 |
--
|
4792 |
4782 |
-- Data for Name: commclass; Type: TABLE DATA; Schema: public; Owner: -
|
4793 |
4783 |
--
|
4794 |
4784 |
|
4795 |
|
COPY commclass (commclass_id, locationevent_id, inspection, tableanalysis, multivariateanalysis, classpublication_id, classnotes, commname, commcode, commframework, commlevel, classstartdate, classstopdate, expertsystem, accessioncode) FROM stdin;
|
4796 |
|
\.
|
4797 |
4785 |
|
4798 |
4786 |
|
4799 |
4787 |
--
|
4800 |
4788 |
-- Data for Name: commconcept; Type: TABLE DATA; Schema: public; Owner: -
|
4801 |
4789 |
--
|
4802 |
4790 |
|
4803 |
|
COPY commconcept (commconcept_id, commname_id, reference_id, commdescription, d_obscount, commname, d_currentaccepted, accessioncode) FROM stdin;
|
4804 |
|
\.
|
4805 |
4791 |
|
4806 |
4792 |
|
4807 |
4793 |
--
|
4808 |
4794 |
-- Data for Name: commcorrelation; Type: TABLE DATA; Schema: public; Owner: -
|
4809 |
4795 |
--
|
4810 |
4796 |
|
4811 |
|
COPY commcorrelation (commcorrelation_id, commstatus_id, commconcept_id, commconvergence, correlationstart, correlationstop) FROM stdin;
|
4812 |
|
\.
|
4813 |
4797 |
|
4814 |
4798 |
|
4815 |
4799 |
--
|
4816 |
4800 |
-- Data for Name: commdetermination; Type: TABLE DATA; Schema: public; Owner: -
|
4817 |
4801 |
--
|
4818 |
4802 |
|
4819 |
|
COPY commdetermination (commdetermination_id, commclass_id, commconcept_id, commcode, commname, classfit, classconfidence, commauthority_id, notes, type, nomenclaturaltype) FROM stdin;
|
4820 |
|
\.
|
4821 |
4803 |
|
4822 |
4804 |
|
4823 |
4805 |
--
|
4824 |
4806 |
-- Data for Name: commlineage; Type: TABLE DATA; Schema: public; Owner: -
|
4825 |
4807 |
--
|
4826 |
4808 |
|
4827 |
|
COPY commlineage (commlineage_id, parentcommstatus_id, childcommstatus_id) FROM stdin;
|
4828 |
|
\.
|
4829 |
4809 |
|
4830 |
4810 |
|
4831 |
4811 |
--
|
4832 |
4812 |
-- Data for Name: commname; Type: TABLE DATA; Schema: public; Owner: -
|
4833 |
4813 |
--
|
4834 |
4814 |
|
4835 |
|
COPY commname (commname_id, commname, reference_id, dateentered) FROM stdin;
|
4836 |
|
\.
|
4837 |
4815 |
|
4838 |
4816 |
|
4839 |
4817 |
--
|
4840 |
4818 |
-- Data for Name: commstatus; Type: TABLE DATA; Schema: public; Owner: -
|
4841 |
4819 |
--
|
4842 |
4820 |
|
4843 |
|
COPY commstatus (commstatus_id, commconcept_id, reference_id, commconceptstatus, commparent_id, commlevel, commpartycomments, party_id, startdate, stopdate, accessioncode) FROM stdin;
|
4844 |
|
\.
|
4845 |
4821 |
|
4846 |
4822 |
|
4847 |
4823 |
--
|
4848 |
4824 |
-- Data for Name: commusage; Type: TABLE DATA; Schema: public; Owner: -
|
4849 |
4825 |
--
|
4850 |
4826 |
|
4851 |
|
COPY commusage (commusage_id, commname_id, commname, commconcept_id, commnamestatus, classsystem, party_id, commstatus_id, usagestart, usagestop) FROM stdin;
|
4852 |
|
\.
|
4853 |
4827 |
|
4854 |
4828 |
|
4855 |
4829 |
--
|
4856 |
4830 |
-- Data for Name: coordinates; Type: TABLE DATA; Schema: public; Owner: -
|
4857 |
4831 |
--
|
4858 |
4832 |
|
4859 |
|
COPY coordinates (coordinates_id, reference_id, latitude_deg, longitude_deg, verbatimlatitude, verbatimlongitude, verbatimcoordinates, footprintgeometry_dwc, coordsaccuracy_deg) FROM stdin;
|
4860 |
|
\.
|
4861 |
4833 |
|
4862 |
4834 |
|
4863 |
4835 |
--
|
4864 |
4836 |
-- Data for Name: coverindex; Type: TABLE DATA; Schema: public; Owner: -
|
4865 |
4837 |
--
|
4866 |
4838 |
|
4867 |
|
COPY coverindex (coverindex_id, covermethod_id, covercode, upperlimit, lowerlimit, coverpercent, indexdescription) FROM stdin;
|
4868 |
|
\.
|
4869 |
4839 |
|
4870 |
4840 |
|
4871 |
4841 |
--
|
4872 |
4842 |
-- Data for Name: covermethod; Type: TABLE DATA; Schema: public; Owner: -
|
4873 |
4843 |
--
|
4874 |
4844 |
|
4875 |
|
COPY covermethod (covermethod_id, reference_id, covertype, coverestimationmethod, accessioncode) FROM stdin;
|
4876 |
|
\.
|
4877 |
4845 |
|
4878 |
4846 |
|
4879 |
4847 |
--
|
4880 |
4848 |
-- Data for Name: definedvalue; Type: TABLE DATA; Schema: public; Owner: -
|
4881 |
4849 |
--
|
4882 |
4850 |
|
4883 |
|
COPY definedvalue (definedvalue_id, userdefined_id, tablerecord_id, definedvalue) FROM stdin;
|
4884 |
|
\.
|
4885 |
4851 |
|
4886 |
4852 |
|
4887 |
4853 |
--
|
4888 |
4854 |
-- Data for Name: disturbanceobs; Type: TABLE DATA; Schema: public; Owner: -
|
4889 |
4855 |
--
|
4890 |
4856 |
|
4891 |
|
COPY disturbanceobs (disturbanceobs_id, locationevent_id, disturbancetype, disturbanceintensity, disturbanceage, disturbanceextent, disturbancecomment) FROM stdin;
|
4892 |
|
\.
|
4893 |
4857 |
|
4894 |
4858 |
|
4895 |
4859 |
--
|
4896 |
4860 |
-- Data for Name: family_higher_plant_group; Type: TABLE DATA; Schema: public; Owner: -
|
4897 |
4861 |
--
|
4898 |
4862 |
|
4899 |
|
COPY family_higher_plant_group (family, higher_plant_group) FROM stdin;
|
4900 |
|
\.
|
4901 |
4863 |
|
4902 |
4864 |
|
4903 |
4865 |
--
|
4904 |
4866 |
-- Data for Name: geoscrub_input; Type: TABLE DATA; Schema: public; Owner: -
|
4905 |
4867 |
--
|
4906 |
4868 |
|
4907 |
|
COPY geoscrub_input (country, "stateProvince", county, "decimalLatitude", "decimalLongitude") FROM stdin;
|
4908 |
|
\.
|
4909 |
4869 |
|
4910 |
4870 |
|
4911 |
4871 |
--
|
4912 |
4872 |
-- Data for Name: graphic; Type: TABLE DATA; Schema: public; Owner: -
|
4913 |
4873 |
--
|
4914 |
4874 |
|
4915 |
|
COPY graphic (graphic_id, locationevent_id, graphicname, graphiclocation, graphicdescription, graphictype, graphicdata, graphicdate, accessioncode) FROM stdin;
|
4916 |
|
\.
|
4917 |
4875 |
|
4918 |
4876 |
|
4919 |
4877 |
--
|
4920 |
4878 |
-- Data for Name: higher_plant_group_nodes; Type: TABLE DATA; Schema: public; Owner: -
|
4921 |
4879 |
--
|
4922 |
4880 |
|
4923 |
|
COPY higher_plant_group_nodes (higher_plant_group, node_name) FROM stdin;
|
4924 |
|
bryophytes Anthocerotophyta
|
4925 |
|
bryophytes Marchantiophyta
|
4926 |
|
bryophytes Bryophyta
|
4927 |
|
ferns and allies Anthocerotophyta
|
4928 |
|
ferns and allies Marchantiophyta
|
4929 |
|
ferns and allies Bryophyta
|
4930 |
|
ferns and allies Moniliformopses
|
4931 |
|
flowering plants Magnoliophyta
|
4932 |
|
gymnosperms (conifers) Coniferophyta
|
4933 |
|
gymnosperms (non-conifer) Cycadophyta
|
4934 |
|
gymnosperms (non-conifer) Ginkgophyta
|
4935 |
|
gymnosperms (non-conifer) Gnetophyta
|
4936 |
|
\.
|
|
4881 |
INSERT INTO higher_plant_group_nodes VALUES ('bryophytes', 'Anthocerotophyta');
|
|
4882 |
INSERT INTO higher_plant_group_nodes VALUES ('bryophytes', 'Marchantiophyta');
|
|
4883 |
INSERT INTO higher_plant_group_nodes VALUES ('bryophytes', 'Bryophyta');
|
|
4884 |
INSERT INTO higher_plant_group_nodes VALUES ('ferns and allies', 'Anthocerotophyta');
|
|
4885 |
INSERT INTO higher_plant_group_nodes VALUES ('ferns and allies', 'Marchantiophyta');
|
|
4886 |
INSERT INTO higher_plant_group_nodes VALUES ('ferns and allies', 'Bryophyta');
|
|
4887 |
INSERT INTO higher_plant_group_nodes VALUES ('ferns and allies', 'Moniliformopses');
|
|
4888 |
INSERT INTO higher_plant_group_nodes VALUES ('flowering plants', 'Magnoliophyta');
|
|
4889 |
INSERT INTO higher_plant_group_nodes VALUES ('gymnosperms (conifers)', 'Coniferophyta');
|
|
4890 |
INSERT INTO higher_plant_group_nodes VALUES ('gymnosperms (non-conifer)', 'Cycadophyta');
|
|
4891 |
INSERT INTO higher_plant_group_nodes VALUES ('gymnosperms (non-conifer)', 'Ginkgophyta');
|
|
4892 |
INSERT INTO higher_plant_group_nodes VALUES ('gymnosperms (non-conifer)', 'Gnetophyta');
|
4937 |
4893 |
|
4938 |
4894 |
|
4939 |
4895 |
--
|
4940 |
4896 |
-- Data for Name: location; Type: TABLE DATA; Schema: public; Owner: -
|
4941 |
4897 |
--
|
4942 |
4898 |
|
4943 |
|
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;
|
4944 |
|
\.
|
4945 |
4899 |
|
4946 |
4900 |
|
4947 |
4901 |
--
|
4948 |
4902 |
-- Data for Name: locationevent; Type: TABLE DATA; Schema: public; Owner: -
|
4949 |
4903 |
--
|
4950 |
4904 |
|
4951 |
|
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;
|
4952 |
|
\.
|
4953 |
4905 |
|
4954 |
4906 |
|
4955 |
4907 |
--
|
4956 |
4908 |
-- Data for Name: locationeventcontributor; Type: TABLE DATA; Schema: public; Owner: -
|
4957 |
4909 |
--
|
4958 |
4910 |
|
4959 |
|
COPY locationeventcontributor (locationeventcontributor_id, locationevent_id, party_id, role, contributiondate) FROM stdin;
|
4960 |
|
\.
|
4961 |
4911 |
|
4962 |
4912 |
|
4963 |
4913 |
--
|
4964 |
4914 |
-- Data for Name: locationeventsynonym; Type: TABLE DATA; Schema: public; Owner: -
|
4965 |
4915 |
--
|
4966 |
4916 |
|
4967 |
|
COPY locationeventsynonym (locationeventsynonym_id, synonymlocationevent_id, primarylocationevent_id, party_id, role, synonymcomment, classstartdate, classstopdate, accessioncode) FROM stdin;
|
4968 |
|
\.
|
4969 |
4917 |
|
4970 |
4918 |
|
4971 |
4919 |
--
|
4972 |
4920 |
-- Data for Name: locationplace; Type: TABLE DATA; Schema: public; Owner: -
|
4973 |
4921 |
--
|
4974 |
4922 |
|
4975 |
|
COPY locationplace (locationplace_id, location_id, place_id, identifier_id) FROM stdin;
|
4976 |
|
\.
|
4977 |
4923 |
|
4978 |
4924 |
|
4979 |
4925 |
--
|
4980 |
4926 |
-- Data for Name: method; Type: TABLE DATA; Schema: public; Owner: -
|
4981 |
4927 |
--
|
4982 |
4928 |
|
4983 |
|
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;
|
4984 |
|
\.
|
4985 |
4929 |
|
4986 |
4930 |
|
4987 |
4931 |
--
|
4988 |
4932 |
-- Data for Name: methodtaxonclass; Type: TABLE DATA; Schema: public; Owner: -
|
4989 |
4933 |
--
|
4990 |
4934 |
|
4991 |
|
COPY methodtaxonclass (methodtaxonclass_id, method_id, taxonlabel_id, included, submethod_id, taxonclass) FROM stdin;
|
4992 |
|
\.
|
4993 |
4935 |
|
4994 |
4936 |
|
4995 |
4937 |
--
|
4996 |
4938 |
-- Data for Name: note; Type: TABLE DATA; Schema: public; Owner: -
|
4997 |
4939 |
--
|
4998 |
4940 |
|
4999 |
|
COPY note (note_id, notelink_id, party_id, role, notetype, notetext, notedate, accessioncode) FROM stdin;
|
5000 |
|
\.
|
5001 |
4941 |
|
5002 |
4942 |
|
5003 |
4943 |
--
|
5004 |
4944 |
-- Data for Name: notelink; Type: TABLE DATA; Schema: public; Owner: -
|
5005 |
4945 |
--
|
5006 |
4946 |
|
5007 |
|
COPY notelink (notelink_id, tablename, attributename, tablerecord) FROM stdin;
|
5008 |
|
\.
|
5009 |
4947 |
|
5010 |
4948 |
|
5011 |
4949 |
--
|
5012 |
4950 |
-- Data for Name: party; Type: TABLE DATA; Schema: public; Owner: -
|
5013 |
4951 |
--
|
5014 |
4952 |
|
5015 |
|
COPY party (party_id, reference_id, fullname, salutation, givenname, middlename, surname, organizationname, currentname_id, contactinstructions, email, partytype, partypublic, d_obscount, accessioncode) FROM stdin;
|
5016 |
|
\.
|
5017 |
4953 |
|
5018 |
4954 |
|
5019 |
4955 |
--
|
5020 |
4956 |
-- Data for Name: partymember; Type: TABLE DATA; Schema: public; Owner: -
|
5021 |
4957 |
--
|
5022 |
4958 |
|
5023 |
|
COPY partymember (partymember_id, parentparty_id, childparty_id, role, memberstart, memberstop) FROM stdin;
|
5024 |
|
\.
|
5025 |
4959 |
|
5026 |
4960 |
|
5027 |
4961 |
--
|
5028 |
4962 |
-- Data for Name: place; Type: TABLE DATA; Schema: public; Owner: -
|
5029 |
4963 |
--
|
5030 |
4964 |
|
5031 |
|
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;
|
5032 |
|
\.
|
5033 |
4965 |
|
5034 |
4966 |
|
5035 |
4967 |
--
|
5036 |
4968 |
-- Data for Name: placecorrelation; Type: TABLE DATA; Schema: public; Owner: -
|
5037 |
4969 |
--
|
5038 |
4970 |
|
5039 |
|
COPY placecorrelation (placecorrelation_id, parentplace_id, childplace_id, placeconvergence) FROM stdin;
|
5040 |
|
\.
|
5041 |
4971 |
|
5042 |
4972 |
|
5043 |
4973 |
--
|
5044 |
4974 |
-- Data for Name: placename; Type: TABLE DATA; Schema: public; Owner: -
|
5045 |
4975 |
--
|
5046 |
4976 |
|
5047 |
|
COPY placename (placename_id, parent_id, rank, placename) FROM stdin;
|
5048 |
|
\.
|
5049 |
4977 |
|
5050 |
4978 |
|
5051 |
4979 |
--
|
5052 |
4980 |
-- Data for Name: placename_ancestor; Type: TABLE DATA; Schema: public; Owner: -
|
5053 |
4981 |
--
|
5054 |
4982 |
|
5055 |
|
COPY placename_ancestor (placename_id, ancestor_id) FROM stdin;
|
5056 |
|
\.
|
5057 |
4983 |
|
5058 |
4984 |
|
5059 |
4985 |
--
|
5060 |
4986 |
-- Data for Name: plant; Type: TABLE DATA; Schema: public; Owner: -
|
5061 |
4987 |
--
|
5062 |
4988 |
|
5063 |
|
COPY plant (plant_id) FROM stdin;
|
5064 |
|
\.
|
5065 |
4989 |
|
5066 |
4990 |
|
5067 |
4991 |
--
|
5068 |
4992 |
-- Data for Name: plantobservation; Type: TABLE DATA; Schema: public; Owner: -
|
5069 |
4993 |
--
|
5070 |
4994 |
|
5071 |
|
COPY plantobservation (plantobservation_id, reference_id, sourceaccessioncode, aggregateoccurrence_id, overallheight_m, overallheightaccuracy_m, collectionnumber, stemcount, plant_id, accessioncode) FROM stdin;
|
5072 |
|
\.
|
5073 |
4995 |
|
5074 |
4996 |
|
5075 |
4997 |
--
|
5076 |
4998 |
-- Data for Name: project; Type: TABLE DATA; Schema: public; Owner: -
|
5077 |
4999 |
--
|
5078 |
5000 |
|
5079 |
|
COPY project (project_id, reference_id, sourceaccessioncode, projectname, projectdescription, startdate, stopdate, d_obscount, d_lastlocationaddeddate, accessioncode) FROM stdin;
|
5080 |
|
\.
|
5081 |
5001 |
|
5082 |
5002 |
|
5083 |
5003 |
--
|
5084 |
5004 |
-- Data for Name: projectcontributor; Type: TABLE DATA; Schema: public; Owner: -
|
5085 |
5005 |
--
|
5086 |
5006 |
|
5087 |
|
COPY projectcontributor (projectcontributor_id, project_id, party_id, role, surname, cheatrole) FROM stdin;
|
5088 |
|
\.
|
5089 |
5007 |
|
5090 |
5008 |
|
5091 |
5009 |
--
|
5092 |
5010 |
-- Data for Name: reference; Type: TABLE DATA; Schema: public; Owner: -
|
5093 |
5011 |
--
|
5094 |
5012 |
|
5095 |
|
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;
|
5096 |
|
\.
|
5097 |
5013 |
|
5098 |
5014 |
|
5099 |
5015 |
--
|
5100 |
5016 |
-- Data for Name: referencealtident; Type: TABLE DATA; Schema: public; Owner: -
|
5101 |
5017 |
--
|
5102 |
5018 |
|
5103 |
|
COPY referencealtident (referencealtident_id, reference_id, system, identifier) FROM stdin;
|
5104 |
|
\.
|
5105 |
5019 |
|
5106 |
5020 |
|
5107 |
5021 |
--
|
5108 |
5022 |
-- Data for Name: referencecontributor; Type: TABLE DATA; Schema: public; Owner: -
|
5109 |
5023 |
--
|
5110 |
5024 |
|
5111 |
|
COPY referencecontributor (referencecontributor_id, reference_id, referenceparty_id, roletype, "position") FROM stdin;
|
5112 |
|
\.
|
5113 |
5025 |
|
5114 |
5026 |
|
5115 |
5027 |
--
|
5116 |
5028 |
-- Data for Name: referencejournal; Type: TABLE DATA; Schema: public; Owner: -
|
5117 |
5029 |
--
|
5118 |
5030 |
|
5119 |
|
COPY referencejournal (referencejournal_id, journal, issn, abbreviation, accessioncode) FROM stdin;
|
5120 |
|
\.
|
5121 |
5031 |
|
5122 |
5032 |
|
5123 |
5033 |
--
|
5124 |
5034 |
-- Data for Name: referenceparty; Type: TABLE DATA; Schema: public; Owner: -
|
5125 |
5035 |
--
|
5126 |
5036 |
|
5127 |
|
COPY referenceparty (referenceparty_id, type, positionname, salutation, givenname, surname, suffix, organizationname, currentparty_id, accessioncode) FROM stdin;
|
5128 |
|
\.
|
5129 |
5037 |
|
5130 |
5038 |
|
5131 |
5039 |
--
|
5132 |
5040 |
-- Data for Name: revision; Type: TABLE DATA; Schema: public; Owner: -
|
5133 |
5041 |
--
|
5134 |
5042 |
|
5135 |
|
COPY revision (revision_id, tablename, tableattribute, tablerecord, previousvaluetext, previousvaluetype, previousrevision_id, revisiondate) FROM stdin;
|
5136 |
|
\.
|
5137 |
5043 |
|
5138 |
5044 |
|
5139 |
5045 |
--
|
5140 |
5046 |
-- Data for Name: soilobs; Type: TABLE DATA; Schema: public; Owner: -
|
5141 |
5047 |
--
|
5142 |
5048 |
|
5143 |
|
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;
|
5144 |
|
\.
|
5145 |
5049 |
|
5146 |
5050 |
|
5147 |
5051 |
--
|
5148 |
5052 |
-- Data for Name: soiltaxon; Type: TABLE DATA; Schema: public; Owner: -
|
5149 |
5053 |
--
|
5150 |
5054 |
|
5151 |
|
COPY soiltaxon (soiltaxon_id, soilcode, soilname, soillevel, soilparent_id, soilframework, accessioncode) FROM stdin;
|
5152 |
|
\.
|
5153 |
5055 |
|
5154 |
5056 |
|
5155 |
5057 |
--
|
5156 |
5058 |
-- Data for Name: specimen; Type: TABLE DATA; Schema: public; Owner: -
|
5157 |
5059 |
--
|
5158 |
5060 |
|
5159 |
|
COPY specimen (specimen_id) FROM stdin;
|
5160 |
|
\.
|
5161 |
5061 |
|
5162 |
5062 |
|
5163 |
5063 |
--
|
5164 |
5064 |
-- Data for Name: specimenreplicate; Type: TABLE DATA; Schema: public; Owner: -
|
5165 |
5065 |
--
|
5166 |
5066 |
|
5167 |
|
COPY specimenreplicate (specimenreplicate_id, reference_id, sourceaccessioncode, plantobservation_id, institution_id, collectioncode_dwc, catalognumber_dwc, description, specimen_id, accessioncode) FROM stdin;
|
5168 |
|
\.
|
5169 |
5067 |
|
5170 |
5068 |
|
5171 |
5069 |
--
|
5172 |
5070 |
-- Data for Name: stemobservation; Type: TABLE DATA; Schema: public; Owner: -
|
5173 |
5071 |
--
|
5174 |
5072 |
|
5175 |
|
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;
|
5176 |
|
\.
|
5177 |
5073 |
|
5178 |
5074 |
|
5179 |
5075 |
--
|
5180 |
5076 |
-- Data for Name: stratum; Type: TABLE DATA; Schema: public; Owner: -
|
5181 |
5077 |
--
|
5182 |
5078 |
|
5183 |
|
COPY stratum (stratum_id, locationevent_id, stratumheight, stratumbase, stratumcover, area, method_id) FROM stdin;
|
5184 |
|
\.
|
5185 |
5079 |
|
5186 |
5080 |
|
5187 |
5081 |
--
|
5188 |
5082 |
-- Data for Name: taxonalt; Type: TABLE DATA; Schema: public; Owner: -
|
5189 |
5083 |
--
|
5190 |
5084 |
|
5191 |
|
COPY taxonalt (taxonalt_id, taxondetermination_id, taxonlabel_id, taxonaltfit, taxonaltconfidence, taxonaltnotes) FROM stdin;
|
5192 |
|
\.
|
5193 |
5085 |
|
5194 |
5086 |
|
5195 |
5087 |
--
|
5196 |
5088 |
-- Data for Name: taxonconcept; Type: TABLE DATA; Schema: public; Owner: -
|
5197 |
5089 |
--
|
5198 |
5090 |
|
5199 |
|
COPY taxonconcept (taxonlabel_id, concept_reference_id) FROM stdin;
|
5200 |
|
\.
|
5201 |
5091 |
|
5202 |
5092 |
|
5203 |
5093 |
--
|
5204 |
5094 |
-- Data for Name: taxoncorrelation; Type: TABLE DATA; Schema: public; Owner: -
|
5205 |
5095 |
--
|
5206 |
5096 |
|
5207 |
|
COPY taxoncorrelation (taxoncorrelation_id, taxonstatus_id, taxonlabel_id, plantconvergence, correlationstart, correlationstop) FROM stdin;
|
5208 |
|
\.
|
5209 |
5097 |
|
5210 |
5098 |
|
5211 |
5099 |
--
|
5212 |
5100 |
-- Data for Name: taxondetermination; Type: TABLE DATA; Schema: public; Owner: -
|
5213 |
5101 |
--
|
5214 |
5102 |
|
5215 |
|
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;
|
5216 |
|
\.
|
5217 |
5103 |
|
5218 |
5104 |
|
5219 |
5105 |
--
|
5220 |
5106 |
-- Data for Name: taxonlabel; Type: TABLE DATA; Schema: public; Owner: -
|
5221 |
5107 |
--
|
5222 |
5108 |
|
5223 |
|
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;
|
5224 |
|
\.
|
5225 |
5109 |
|
5226 |
5110 |
|
5227 |
5111 |
--
|
5228 |
5112 |
-- Data for Name: taxonlabel_relationship; Type: TABLE DATA; Schema: public; Owner: -
|
5229 |
5113 |
--
|
5230 |
5114 |
|
5231 |
|
COPY taxonlabel_relationship (descendant_id, ancestor_id, relationship) FROM stdin;
|
5232 |
|
\.
|
5233 |
5115 |
|
5234 |
5116 |
|
5235 |
5117 |
--
|
5236 |
5118 |
-- Data for Name: taxonlineage; Type: TABLE DATA; Schema: public; Owner: -
|
5237 |
5119 |
--
|
5238 |
5120 |
|
5239 |
|
COPY taxonlineage (taxonlineage_id, childtaxonstatus_id, parenttaxonstatus_id) FROM stdin;
|
5240 |
|
\.
|
5241 |
5121 |
|
5242 |
5122 |
|
5243 |
5123 |
--
|
5244 |
5124 |
-- Data for Name: taxonoccurrence; Type: TABLE DATA; Schema: public; Owner: -
|
5245 |
5125 |
--
|
5246 |
5126 |
|
5247 |
|
COPY taxonoccurrence (taxonoccurrence_id, reference_id, sourceaccessioncode, locationevent_id, authortaxoncode, verbatimcollectorname, growthform, iscultivated, cultivatedbasis, isnative, accessioncode) FROM stdin;
|
5248 |
|
\.
|
5249 |
5127 |
|
5250 |
5128 |
|
5251 |
5129 |
--
|
5252 |
5130 |
-- Data for Name: taxonstatus; Type: TABLE DATA; Schema: public; Owner: -
|
5253 |
5131 |
--
|
5254 |
5132 |
|
5255 |
|
COPY taxonstatus (taxonstatus_id, taxonlabel_id, party_id, taxonlabelstatus, reference_id, plantpartycomments, startdate, stopdate, accessioncode) FROM stdin;
|
5256 |
|
\.
|
5257 |
5133 |
|
5258 |
5134 |
|
5259 |
5135 |
--
|
5260 |
5136 |
-- Data for Name: taxonverbatim; Type: TABLE DATA; Schema: public; Owner: -
|
5261 |
5137 |
--
|
5262 |
5138 |
|
5263 |
|
COPY taxonverbatim (taxonverbatim_id, taxonlabel_id, verbatimrank, taxonomicname, taxonname, author, family, genus, specific_epithet, morphospecies, description) FROM stdin;
|
5264 |
|
\.
|
5265 |
5139 |
|
5266 |
5140 |
|
5267 |
5141 |
--
|
5268 |
5142 |
-- Data for Name: telephone; Type: TABLE DATA; Schema: public; Owner: -
|
5269 |
5143 |
--
|
5270 |
5144 |
|
5271 |
|
COPY telephone (telephone_id, party_id, phonenumber, phonetype) FROM stdin;
|
5272 |
|
\.
|
5273 |
5145 |
|
5274 |
5146 |
|
5275 |
5147 |
--
|
5276 |
5148 |
-- Data for Name: trait; Type: TABLE DATA; Schema: public; Owner: -
|
5277 |
5149 |
--
|
5278 |
5150 |
|
5279 |
|
COPY trait (trait_id, stemobservation_id, type, value) FROM stdin;
|
5280 |
|
\.
|
5281 |
5151 |
|
5282 |
5152 |
|
5283 |
5153 |
--
|
5284 |
5154 |
-- Data for Name: userdefined; Type: TABLE DATA; Schema: public; Owner: -
|
5285 |
5155 |
--
|
5286 |
5156 |
|
5287 |
|
COPY userdefined (userdefined_id, userdefinedname, userdefinedmetadata, userdefinedcategory, userdefinedtype, tablename, accessioncode) FROM stdin;
|
5288 |
|
\.
|
5289 |
5157 |
|
5290 |
5158 |
|
5291 |
5159 |
--
|
5292 |
5160 |
-- Data for Name: voucher; Type: TABLE DATA; Schema: public; Owner: -
|
5293 |
5161 |
--
|
5294 |
5162 |
|
5295 |
|
COPY voucher (voucher_id, taxonoccurrence_id, specimenreplicate_id) FROM stdin;
|
5296 |
|
\.
|
5297 |
5163 |
|
5298 |
5164 |
|
5299 |
5165 |
--
|
pg_dump_vegbien: When not in data mode, use --inserts so the INSERT statements generated can be run directly in pgAdmin, they can be directly translated to MySQL, and an empty COPY FROM statement isn't generated for every table