Project

General

Profile

« Previous | Next » 

Revision 6038

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

View differences:

schemas/vegbien.my.sql
3779 3779

  
3780 3780

  
3781 3781

  
3782

  
3783 3782
--
3784 3783
-- Data for Name: aggregateoccurrence; Type: TABLE DATA; Schema: public; Owner: -
3785 3784
--
3786 3785

  
3787 3786

  
3788 3787

  
3789

  
3790 3788
--
3791 3789
-- Data for Name: analytical_aggregate; Type: TABLE DATA; Schema: public; Owner: -
3792 3790
--
3793 3791

  
3794 3792

  
3795 3793

  
3796

  
3797 3794
--
3798 3795
-- Data for Name: analytical_stem; Type: TABLE DATA; Schema: public; Owner: -
3799 3796
--
3800 3797

  
3801 3798

  
3802 3799

  
3803

  
3804 3800
--
3805 3801
-- Data for Name: classcontributor; Type: TABLE DATA; Schema: public; Owner: -
3806 3802
--
3807 3803

  
3808 3804

  
3809 3805

  
3810

  
3811 3806
--
3812 3807
-- Data for Name: commclass; Type: TABLE DATA; Schema: public; Owner: -
3813 3808
--
3814 3809

  
3815 3810

  
3816 3811

  
3817

  
3818 3812
--
3819 3813
-- Data for Name: commconcept; Type: TABLE DATA; Schema: public; Owner: -
3820 3814
--
3821 3815

  
3822 3816

  
3823 3817

  
3824

  
3825 3818
--
3826 3819
-- Data for Name: commcorrelation; Type: TABLE DATA; Schema: public; Owner: -
3827 3820
--
3828 3821

  
3829 3822

  
3830 3823

  
3831

  
3832 3824
--
3833 3825
-- Data for Name: commdetermination; Type: TABLE DATA; Schema: public; Owner: -
3834 3826
--
3835 3827

  
3836 3828

  
3837 3829

  
3838

  
3839 3830
--
3840 3831
-- Data for Name: commlineage; Type: TABLE DATA; Schema: public; Owner: -
3841 3832
--
3842 3833

  
3843 3834

  
3844 3835

  
3845

  
3846 3836
--
3847 3837
-- Data for Name: commname; Type: TABLE DATA; Schema: public; Owner: -
3848 3838
--
3849 3839

  
3850 3840

  
3851 3841

  
3852

  
3853 3842
--
3854 3843
-- Data for Name: commstatus; Type: TABLE DATA; Schema: public; Owner: -
3855 3844
--
3856 3845

  
3857 3846

  
3858 3847

  
3859

  
3860 3848
--
3861 3849
-- Data for Name: commusage; Type: TABLE DATA; Schema: public; Owner: -
3862 3850
--
3863 3851

  
3864 3852

  
3865 3853

  
3866

  
3867 3854
--
3868 3855
-- Data for Name: coordinates; Type: TABLE DATA; Schema: public; Owner: -
3869 3856
--
3870 3857

  
3871 3858

  
3872 3859

  
3873

  
3874 3860
--
3875 3861
-- Data for Name: coverindex; Type: TABLE DATA; Schema: public; Owner: -
3876 3862
--
3877 3863

  
3878 3864

  
3879 3865

  
3880

  
3881 3866
--
3882 3867
-- Data for Name: covermethod; Type: TABLE DATA; Schema: public; Owner: -
3883 3868
--
3884 3869

  
3885 3870

  
3886 3871

  
3887

  
3888 3872
--
3889 3873
-- Data for Name: definedvalue; Type: TABLE DATA; Schema: public; Owner: -
3890 3874
--
3891 3875

  
3892 3876

  
3893 3877

  
3894

  
3895 3878
--
3896 3879
-- Data for Name: disturbanceobs; Type: TABLE DATA; Schema: public; Owner: -
3897 3880
--
3898 3881

  
3899 3882

  
3900 3883

  
3901

  
3902 3884
--
3903 3885
-- Data for Name: family_higher_plant_group; Type: TABLE DATA; Schema: public; Owner: -
3904 3886
--
3905 3887

  
3906 3888

  
3907 3889

  
3908

  
3909 3890
--
3910 3891
-- Data for Name: geoscrub_input; Type: TABLE DATA; Schema: public; Owner: -
3911 3892
--
3912 3893

  
3913 3894

  
3914 3895

  
3915

  
3916 3896
--
3917 3897
-- Data for Name: graphic; Type: TABLE DATA; Schema: public; Owner: -
3918 3898
--
3919 3899

  
3920 3900

  
3921 3901

  
3922

  
3923 3902
--
3924 3903
-- Data for Name: higher_plant_group_nodes; Type: TABLE DATA; Schema: public; Owner: -
3925 3904
--
3926 3905

  
3906
INSERT INTO higher_plant_group_nodes VALUES ('bryophytes', 'Anthocerotophyta');
3907
INSERT INTO higher_plant_group_nodes VALUES ('bryophytes', 'Marchantiophyta');
3908
INSERT INTO higher_plant_group_nodes VALUES ('bryophytes', 'Bryophyta');
3909
INSERT INTO higher_plant_group_nodes VALUES ('ferns and allies', 'Anthocerotophyta');
3910
INSERT INTO higher_plant_group_nodes VALUES ('ferns and allies', 'Marchantiophyta');
3911
INSERT INTO higher_plant_group_nodes VALUES ('ferns and allies', 'Bryophyta');
3912
INSERT INTO higher_plant_group_nodes VALUES ('ferns and allies', 'Moniliformopses');
3913
INSERT INTO higher_plant_group_nodes VALUES ('flowering plants', 'Magnoliophyta');
3914
INSERT INTO higher_plant_group_nodes VALUES ('gymnosperms (conifers)', 'Coniferophyta');
3915
INSERT INTO higher_plant_group_nodes VALUES ('gymnosperms (non-conifer)', 'Cycadophyta');
3916
INSERT INTO higher_plant_group_nodes VALUES ('gymnosperms (non-conifer)', 'Ginkgophyta');
3917
INSERT INTO higher_plant_group_nodes VALUES ('gymnosperms (non-conifer)', 'Gnetophyta');
3927 3918

  
3928 3919

  
3929

  
3930 3920
--
3931 3921
-- Data for Name: location; Type: TABLE DATA; Schema: public; Owner: -
3932 3922
--
3933 3923

  
3934 3924

  
3935 3925

  
3936

  
3937 3926
--
3938 3927
-- Data for Name: locationevent; Type: TABLE DATA; Schema: public; Owner: -
3939 3928
--
3940 3929

  
3941 3930

  
3942 3931

  
3943

  
3944 3932
--
3945 3933
-- Data for Name: locationeventcontributor; Type: TABLE DATA; Schema: public; Owner: -
3946 3934
--
3947 3935

  
3948 3936

  
3949 3937

  
3950

  
3951 3938
--
3952 3939
-- Data for Name: locationeventsynonym; Type: TABLE DATA; Schema: public; Owner: -
3953 3940
--
3954 3941

  
3955 3942

  
3956 3943

  
3957

  
3958 3944
--
3959 3945
-- Data for Name: locationplace; Type: TABLE DATA; Schema: public; Owner: -
3960 3946
--
3961 3947

  
3962 3948

  
3963 3949

  
3964

  
3965 3950
--
3966 3951
-- Data for Name: method; Type: TABLE DATA; Schema: public; Owner: -
3967 3952
--
3968 3953

  
3969 3954

  
3970 3955

  
3971

  
3972 3956
--
3973 3957
-- Data for Name: methodtaxonclass; Type: TABLE DATA; Schema: public; Owner: -
3974 3958
--
3975 3959

  
3976 3960

  
3977 3961

  
3978

  
3979 3962
--
3980 3963
-- Data for Name: note; Type: TABLE DATA; Schema: public; Owner: -
3981 3964
--
3982 3965

  
3983 3966

  
3984 3967

  
3985

  
3986 3968
--
3987 3969
-- Data for Name: notelink; Type: TABLE DATA; Schema: public; Owner: -
3988 3970
--
3989 3971

  
3990 3972

  
3991 3973

  
3992

  
3993 3974
--
3994 3975
-- Data for Name: party; Type: TABLE DATA; Schema: public; Owner: -
3995 3976
--
3996 3977

  
3997 3978

  
3998 3979

  
3999

  
4000 3980
--
4001 3981
-- Data for Name: partymember; Type: TABLE DATA; Schema: public; Owner: -
4002 3982
--
4003 3983

  
4004 3984

  
4005 3985

  
4006

  
4007 3986
--
4008 3987
-- Data for Name: place; Type: TABLE DATA; Schema: public; Owner: -
4009 3988
--
4010 3989

  
4011 3990

  
4012 3991

  
4013

  
4014 3992
--
4015 3993
-- Data for Name: placecorrelation; Type: TABLE DATA; Schema: public; Owner: -
4016 3994
--
4017 3995

  
4018 3996

  
4019 3997

  
4020

  
4021 3998
--
4022 3999
-- Data for Name: placename; Type: TABLE DATA; Schema: public; Owner: -
4023 4000
--
4024 4001

  
4025 4002

  
4026 4003

  
4027

  
4028 4004
--
4029 4005
-- Data for Name: placename_ancestor; Type: TABLE DATA; Schema: public; Owner: -
4030 4006
--
4031 4007

  
4032 4008

  
4033 4009

  
4034

  
4035 4010
--
4036 4011
-- Data for Name: plant; Type: TABLE DATA; Schema: public; Owner: -
4037 4012
--
4038 4013

  
4039 4014

  
4040 4015

  
4041

  
4042 4016
--
4043 4017
-- Data for Name: plantobservation; Type: TABLE DATA; Schema: public; Owner: -
4044 4018
--
4045 4019

  
4046 4020

  
4047 4021

  
4048

  
4049 4022
--
4050 4023
-- Data for Name: project; Type: TABLE DATA; Schema: public; Owner: -
4051 4024
--
4052 4025

  
4053 4026

  
4054 4027

  
4055

  
4056 4028
--
4057 4029
-- Data for Name: projectcontributor; Type: TABLE DATA; Schema: public; Owner: -
4058 4030
--
4059 4031

  
4060 4032

  
4061 4033

  
4062

  
4063 4034
--
4064 4035
-- Data for Name: reference; Type: TABLE DATA; Schema: public; Owner: -
4065 4036
--
4066 4037

  
4067 4038

  
4068 4039

  
4069

  
4070 4040
--
4071 4041
-- Data for Name: referencealtident; Type: TABLE DATA; Schema: public; Owner: -
4072 4042
--
4073 4043

  
4074 4044

  
4075 4045

  
4076

  
4077 4046
--
4078 4047
-- Data for Name: referencecontributor; Type: TABLE DATA; Schema: public; Owner: -
4079 4048
--
4080 4049

  
4081 4050

  
4082 4051

  
4083

  
4084 4052
--
4085 4053
-- Data for Name: referencejournal; Type: TABLE DATA; Schema: public; Owner: -
4086 4054
--
4087 4055

  
4088 4056

  
4089 4057

  
4090

  
4091 4058
--
4092 4059
-- Data for Name: referenceparty; Type: TABLE DATA; Schema: public; Owner: -
4093 4060
--
4094 4061

  
4095 4062

  
4096 4063

  
4097

  
4098 4064
--
4099 4065
-- Data for Name: revision; Type: TABLE DATA; Schema: public; Owner: -
4100 4066
--
4101 4067

  
4102 4068

  
4103 4069

  
4104

  
4105 4070
--
4106 4071
-- Data for Name: soilobs; Type: TABLE DATA; Schema: public; Owner: -
4107 4072
--
4108 4073

  
4109 4074

  
4110 4075

  
4111

  
4112 4076
--
4113 4077
-- Data for Name: soiltaxon; Type: TABLE DATA; Schema: public; Owner: -
4114 4078
--
4115 4079

  
4116 4080

  
4117 4081

  
4118

  
4119 4082
--
4120 4083
-- Data for Name: specimen; Type: TABLE DATA; Schema: public; Owner: -
4121 4084
--
4122 4085

  
4123 4086

  
4124 4087

  
4125

  
4126 4088
--
4127 4089
-- Data for Name: specimenreplicate; Type: TABLE DATA; Schema: public; Owner: -
4128 4090
--
4129 4091

  
4130 4092

  
4131 4093

  
4132

  
4133 4094
--
4134 4095
-- Data for Name: stemobservation; Type: TABLE DATA; Schema: public; Owner: -
4135 4096
--
4136 4097

  
4137 4098

  
4138 4099

  
4139

  
4140 4100
--
4141 4101
-- Data for Name: stratum; Type: TABLE DATA; Schema: public; Owner: -
4142 4102
--
4143 4103

  
4144 4104

  
4145 4105

  
4146

  
4147 4106
--
4148 4107
-- Data for Name: taxonalt; Type: TABLE DATA; Schema: public; Owner: -
4149 4108
--
4150 4109

  
4151 4110

  
4152 4111

  
4153

  
4154 4112
--
4155 4113
-- Data for Name: taxonconcept; Type: TABLE DATA; Schema: public; Owner: -
4156 4114
--
4157 4115

  
4158 4116

  
4159 4117

  
4160

  
4161 4118
--
4162 4119
-- Data for Name: taxoncorrelation; Type: TABLE DATA; Schema: public; Owner: -
4163 4120
--
4164 4121

  
4165 4122

  
4166 4123

  
4167

  
4168 4124
--
4169 4125
-- Data for Name: taxondetermination; Type: TABLE DATA; Schema: public; Owner: -
4170 4126
--
4171 4127

  
4172 4128

  
4173 4129

  
4174

  
4175 4130
--
4176 4131
-- Data for Name: taxonlabel; Type: TABLE DATA; Schema: public; Owner: -
4177 4132
--
4178 4133

  
4179 4134

  
4180 4135

  
4181

  
4182 4136
--
4183 4137
-- Data for Name: taxonlabel_relationship; Type: TABLE DATA; Schema: public; Owner: -
4184 4138
--
4185 4139

  
4186 4140

  
4187 4141

  
4188

  
4189 4142
--
4190 4143
-- Data for Name: taxonlineage; Type: TABLE DATA; Schema: public; Owner: -
4191 4144
--
4192 4145

  
4193 4146

  
4194 4147

  
4195

  
4196 4148
--
4197 4149
-- Data for Name: taxonoccurrence; Type: TABLE DATA; Schema: public; Owner: -
4198 4150
--
4199 4151

  
4200 4152

  
4201 4153

  
4202

  
4203 4154
--
4204 4155
-- Data for Name: taxonstatus; Type: TABLE DATA; Schema: public; Owner: -
4205 4156
--
4206 4157

  
4207 4158

  
4208 4159

  
4209

  
4210 4160
--
4211 4161
-- Data for Name: taxonverbatim; Type: TABLE DATA; Schema: public; Owner: -
4212 4162
--
4213 4163

  
4214 4164

  
4215 4165

  
4216

  
4217 4166
--
4218 4167
-- Data for Name: telephone; Type: TABLE DATA; Schema: public; Owner: -
4219 4168
--
4220 4169

  
4221 4170

  
4222 4171

  
4223

  
4224 4172
--
4225 4173
-- Data for Name: trait; Type: TABLE DATA; Schema: public; Owner: -
4226 4174
--
4227 4175

  
4228 4176

  
4229 4177

  
4230

  
4231 4178
--
4232 4179
-- Data for Name: userdefined; Type: TABLE DATA; Schema: public; Owner: -
4233 4180
--
4234 4181

  
4235 4182

  
4236 4183

  
4237

  
4238 4184
--
4239 4185
-- Data for Name: voucher; Type: TABLE DATA; Schema: public; Owner: -
4240 4186
--
4241 4187

  
4242 4188

  
4243 4189

  
4244

  
4245 4190
--
4246 4191
-- Name: address_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
4247 4192
--
schemas/vegbien.sql
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
--
bin/pg_dump_vegbien
19 19
    else set -- "$@" --format=c --compress=9
20 20
    fi
21 21
    owners=1
22
elif test -n "$schema"; then set -- "$@" --schema-only
22
else
23
    set -- "$@" --inserts
24
    test -n "$schema" && set -- "$@" --schema-only
23 25
fi
24 26
test -n "$owners" || set -- "$@" --no-owner --no-privileges
25 27
set -- "$@" $opts

Also available in: Unified diff