Project

General

Profile

« Previous | Next » 

Revision 14483

schemas/public_.sql: analytical_stem_view: renamed to analytical_stem since this replaces the materialized analytical_stem table. note that this change has already been made on vegbiendev.

View differences:

trunk/schemas/vegbien.my.sql
1283 1283

  
1284 1284

  
1285 1285
--
1286
-- Name: analytical_stem_view_modify(varchar(255), anyelement); Type: FUNCTION; Schema: public; Owner: -
1286
-- Name: analytical_stem_modify(varchar(255), anyelement); Type: FUNCTION; Schema: public; Owner: -
1287 1287
--
1288 1288

  
1289 1289

  
1290 1290

  
1291 1291

  
1292 1292
--
1293
-- Name: FUNCTION analytical_stem_view_modify(view_query varchar(255), schema_anchor anyelement); Type: COMMENT; Schema: public; Owner: -
1293
-- Name: FUNCTION analytical_stem_modify(view_query varchar(255), schema_anchor anyelement); Type: COMMENT; Schema: public; Owner: -
1294 1294
--
1295 1295

  
1296 1296

  
......
3840 3840

  
3841 3841

  
3842 3842
--
3843
-- Name: analytical_stem_view; Type: VIEW; Schema: public; Owner: -
3843
-- Name: analytical_stem; Type: VIEW; Schema: public; Owner: -
3844 3844
--
3845 3845

  
3846 3846

  
3847 3847

  
3848 3848

  
3849 3849
--
3850
-- Name: VIEW analytical_stem_view; Type: COMMENT; Schema: public; Owner: -
3850
-- Name: VIEW analytical_stem; Type: COMMENT; Schema: public; Owner: -
3851 3851
--
3852 3852

  
3853 3853

  
3854 3854

  
3855 3855

  
3856 3856
--
3857
-- Name: COLUMN analytical_stem_view.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3857
-- Name: COLUMN analytical_stem.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3858 3858
--
3859 3859

  
3860 3860

  
3861 3861

  
3862 3862

  
3863 3863
--
3864
-- Name: COLUMN analytical_stem_view.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3864
-- Name: COLUMN analytical_stem.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3865 3865
--
3866 3866

  
3867 3867

  
3868 3868

  
3869 3869

  
3870 3870
--
3871
-- Name: COLUMN analytical_stem_view.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3871
-- Name: COLUMN analytical_stem.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3872 3872
--
3873 3873

  
3874 3874

  
3875 3875

  
3876 3876

  
3877 3877
--
3878
-- Name: COLUMN analytical_stem_view.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3878
-- Name: COLUMN analytical_stem.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3879 3879
--
3880 3880

  
3881 3881

  
3882 3882

  
3883 3883

  
3884 3884
--
3885
-- Name: COLUMN analytical_stem_view.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3885
-- Name: COLUMN analytical_stem.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3886 3886
--
3887 3887

  
3888 3888

  
3889 3889

  
3890 3890

  
3891 3891
--
3892
-- Name: COLUMN analytical_stem_view.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3892
-- Name: COLUMN analytical_stem.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3893 3893
--
3894 3894

  
3895 3895

  
3896 3896

  
3897 3897

  
3898 3898
--
3899
-- Name: COLUMN analytical_stem_view.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3899
-- Name: COLUMN analytical_stem.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3900 3900
--
3901 3901

  
3902 3902

  
3903 3903

  
3904 3904

  
3905 3905
--
3906
-- Name: COLUMN analytical_stem_view.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3906
-- Name: COLUMN analytical_stem.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3907 3907
--
3908 3908

  
3909 3909

  
3910 3910

  
3911 3911

  
3912 3912
--
3913
-- Name: COLUMN analytical_stem_view.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3913
-- Name: COLUMN analytical_stem.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3914 3914
--
3915 3915

  
3916 3916

  
3917 3917

  
3918 3918

  
3919 3919
--
3920
-- Name: COLUMN analytical_stem_view.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3920
-- Name: COLUMN analytical_stem.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3921 3921
--
3922 3922

  
3923 3923

  
3924 3924

  
3925 3925

  
3926 3926
--
3927
-- Name: COLUMN analytical_stem_view.geovalid_bien; Type: COMMENT; Schema: public; Owner: -
3927
-- Name: COLUMN analytical_stem.geovalid_bien; Type: COMMENT; Schema: public; Owner: -
3928 3928
--
3929 3929

  
3930 3930

  
3931 3931

  
3932 3932

  
3933 3933
--
3934
-- Name: COLUMN analytical_stem_view.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: -
3934
-- Name: COLUMN analytical_stem.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: -
3935 3935
--
3936 3936

  
3937 3937

  
3938 3938

  
3939 3939

  
3940 3940
--
3941
-- Name: COLUMN analytical_stem_view.`projectID__@VegX__.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3941
-- Name: COLUMN analytical_stem.`projectID__@VegX__.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3942 3942
--
3943 3943

  
3944 3944

  
3945 3945

  
3946 3946

  
3947 3947
--
3948
-- Name: COLUMN analytical_stem_view.`projectContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3948
-- Name: COLUMN analytical_stem.`projectContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3949 3949
--
3950 3950

  
3951 3951

  
3952 3952

  
3953 3953

  
3954 3954
--
3955
-- Name: COLUMN analytical_stem_view.`locationID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3955
-- Name: COLUMN analytical_stem.`locationID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3956 3956
--
3957 3957

  
3958 3958

  
3959 3959

  
3960 3960

  
3961 3961
--
3962
-- Name: COLUMN analytical_stem_view.`plotName__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3962
-- Name: COLUMN analytical_stem.`plotName__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3963 3963
--
3964 3964

  
3965 3965

  
3966 3966

  
3967 3967

  
3968 3968
--
3969
-- Name: COLUMN analytical_stem_view.`subplot__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3969
-- Name: COLUMN analytical_stem.`subplot__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3970 3970
--
3971 3971

  
3972 3972

  
3973 3973

  
3974 3974

  
3975 3975
--
3976
-- Name: COLUMN analytical_stem_view.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -
3976
-- Name: COLUMN analytical_stem.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -
3977 3977
--
3978 3978

  
3979 3979

  
3980 3980

  
3981 3981

  
3982 3982
--
3983
-- Name: COLUMN analytical_stem_view.`locationevent.locationevent_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3983
-- Name: COLUMN analytical_stem.`locationevent.locationevent_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3984 3984
--
3985 3985

  
3986 3986

  
3987 3987

  
3988 3988

  
3989 3989
--
3990
-- Name: COLUMN analytical_stem_view.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3990
-- Name: COLUMN analytical_stem.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3991 3991
--
3992 3992

  
3993 3993

  
3994 3994

  
3995 3995

  
3996 3996
--
3997
-- Name: COLUMN analytical_stem_view.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3997
-- Name: COLUMN analytical_stem.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3998 3998
--
3999 3999

  
4000 4000

  
4001 4001

  
4002 4002

  
4003 4003
--
4004
-- Name: COLUMN analytical_stem_view.`slopeAspect[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4004
-- Name: COLUMN analytical_stem.`slopeAspect[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4005 4005
--
4006 4006

  
4007 4007

  
4008 4008

  
4009 4009

  
4010 4010
--
4011
-- Name: COLUMN analytical_stem_view.`slopeGradient[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4011
-- Name: COLUMN analytical_stem.`slopeGradient[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4012 4012
--
4013 4013

  
4014 4014

  
4015 4015

  
4016 4016

  
4017 4017
--
4018
-- Name: COLUMN analytical_stem_view.`plot.area[_ha]__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4018
-- Name: COLUMN analytical_stem.`plot.area[_ha]__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4019 4019
--
4020 4020

  
4021 4021

  
4022 4022

  
4023 4023

  
4024 4024
--
4025
-- Name: COLUMN analytical_stem_view.`samplingProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4025
-- Name: COLUMN analytical_stem.`samplingProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4026 4026
--
4027 4027

  
4028 4028

  
4029 4029

  
4030 4030

  
4031 4031
--
4032
-- Name: COLUMN analytical_stem_view.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4032
-- Name: COLUMN analytical_stem.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4033 4033
--
4034 4034

  
4035 4035

  
4036 4036

  
4037 4037

  
4038 4038
--
4039
-- Name: COLUMN analytical_stem_view.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4039
-- Name: COLUMN analytical_stem.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4040 4040
--
4041 4041

  
4042 4042

  
4043 4043

  
4044 4044

  
4045 4045
--
4046
-- Name: COLUMN analytical_stem_view.`stratumName__@VegX__.stratum@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4046
-- Name: COLUMN analytical_stem.`stratumName__@VegX__.stratum@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4047 4047
--
4048 4048

  
4049 4049

  
4050 4050

  
4051 4051

  
4052 4052
--
4053
-- Name: COLUMN analytical_stem_view.`communityConcept.name__@VegX__.communityDet@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4053
-- Name: COLUMN analytical_stem.`communityConcept.name__@VegX__.communityDet@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4054 4054
--
4055 4055

  
4056 4056

  
4057 4057

  
4058 4058

  
4059 4059
--
4060
-- Name: COLUMN analytical_stem_view.`observationContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4060
-- Name: COLUMN analytical_stem.`observationContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4061 4061
--
4062 4062

  
4063 4063

  
4064 4064

  
4065 4065

  
4066 4066
--
4067
-- Name: COLUMN analytical_stem_view.`[custodial_]institutionCode[s]__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4067
-- Name: COLUMN analytical_stem.`[custodial_]institutionCode[s]__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4068 4068
--
4069 4069

  
4070 4070

  
4071 4071

  
4072 4072

  
4073 4073
--
4074
-- Name: COLUMN analytical_stem_view.`collectionCode__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4074
-- Name: COLUMN analytical_stem.`collectionCode__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4075 4075
--
4076 4076

  
4077 4077

  
4078 4078

  
4079 4079

  
4080 4080
--
4081
-- Name: COLUMN analytical_stem_view.`catalogNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4081
-- Name: COLUMN analytical_stem.`catalogNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4082 4082
--
4083 4083

  
4084 4084

  
4085 4085

  
4086 4086

  
4087 4087
--
4088
-- Name: COLUMN analytical_stem_view.`occurrenceID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4088
-- Name: COLUMN analytical_stem.`occurrenceID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4089 4089
--
4090 4090

  
4091 4091

  
4092 4092

  
4093 4093

  
4094 4094
--
4095
-- Name: COLUMN analytical_stem_view.`recordedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4095
-- Name: COLUMN analytical_stem.`recordedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4096 4096
--
4097 4097

  
4098 4098

  
4099 4099

  
4100 4100

  
4101 4101
--
4102
-- Name: COLUMN analytical_stem_view.`recordNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4102
-- Name: COLUMN analytical_stem.`recordNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4103 4103
--
4104 4104

  
4105 4105

  
4106 4106

  
4107 4107

  
4108 4108
--
4109
-- Name: COLUMN analytical_stem_view.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4109
-- Name: COLUMN analytical_stem.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4110 4110
--
4111 4111

  
4112 4112

  
4113 4113

  
4114 4114

  
4115 4115
--
4116
-- Name: COLUMN analytical_stem_view.`[verbatim_]family__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4116
-- Name: COLUMN analytical_stem.`[verbatim_]family__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4117 4117
--
4118 4118

  
4119 4119

  
4120 4120

  
4121 4121

  
4122 4122
--
4123
-- Name: COLUMN analytical_stem_view.`[verbatim_]scientificName__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4123
-- Name: COLUMN analytical_stem.`[verbatim_]scientificName__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4124 4124
--
4125 4125

  
4126 4126

  
4127 4127

  
4128 4128

  
4129 4129
--
4130
-- Name: COLUMN analytical_stem_view.`identifiedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4130
-- Name: COLUMN analytical_stem.`identifiedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4131 4131
--
4132 4132

  
4133 4133

  
4134 4134

  
4135 4135

  
4136 4136
--
4137
-- Name: COLUMN analytical_stem_view.`dateIdentified__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4137
-- Name: COLUMN analytical_stem.`dateIdentified__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4138 4138
--
4139 4139

  
4140 4140

  
4141 4141

  
4142 4142

  
4143 4143
--
4144
-- Name: COLUMN analytical_stem_view.`identificationRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4144
-- Name: COLUMN analytical_stem.`identificationRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4145 4145
--
4146 4146

  
4147 4147

  
4148 4148

  
4149 4149

  
4150 4150
--
4151
-- Name: COLUMN analytical_stem_view.`Family_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4151
-- Name: COLUMN analytical_stem.`Family_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4152 4152
--
4153 4153

  
4154 4154

  
4155 4155

  
4156 4156

  
4157 4157
--
4158
-- Name: COLUMN analytical_stem_view.`Name_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4158
-- Name: COLUMN analytical_stem.`Name_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4159 4159
--
4160 4160

  
4161 4161

  
4162 4162

  
4163 4163

  
4164 4164
--
4165
-- Name: COLUMN analytical_stem_view.`Name_matched_author__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4165
-- Name: COLUMN analytical_stem.`Name_matched_author__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4166 4166
--
4167 4167

  
4168 4168

  
4169 4169

  
4170 4170

  
4171 4171
--
4172
-- Name: COLUMN analytical_stem_view.`[higher_plant_group~]higherClassification__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4172
-- Name: COLUMN analytical_stem.`[higher_plant_group~]higherClassification__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4173 4173
--
4174 4174

  
4175 4175

  
4176 4176

  
4177 4177

  
4178 4178
--
4179
-- Name: COLUMN analytical_stem_view.`taxonomicStatus__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4179
-- Name: COLUMN analytical_stem.`taxonomicStatus__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4180 4180
--
4181 4181

  
4182 4182

  
4183 4183

  
4184 4184

  
4185 4185
--
4186
-- Name: COLUMN analytical_stem_view.scrubbed_family; Type: COMMENT; Schema: public; Owner: -
4186
-- Name: COLUMN analytical_stem.scrubbed_family; Type: COMMENT; Schema: public; Owner: -
4187 4187
--
4188 4188

  
4189 4189

  
4190 4190

  
4191 4191

  
4192 4192
--
4193
-- Name: COLUMN analytical_stem_view.scrubbed_genus; Type: COMMENT; Schema: public; Owner: -
4193
-- Name: COLUMN analytical_stem.scrubbed_genus; Type: COMMENT; Schema: public; Owner: -
4194 4194
--
4195 4195

  
4196 4196

  
4197 4197

  
4198 4198

  
4199 4199
--
4200
-- Name: COLUMN analytical_stem_view.scrubbed_specific_epithet; Type: COMMENT; Schema: public; Owner: -
4200
-- Name: COLUMN analytical_stem.scrubbed_specific_epithet; Type: COMMENT; Schema: public; Owner: -
4201 4201
--
4202 4202

  
4203 4203

  
4204 4204

  
4205 4205

  
4206 4206
--
4207
-- Name: COLUMN analytical_stem_view.scrubbed_species_binomial; Type: COMMENT; Schema: public; Owner: -
4207
-- Name: COLUMN analytical_stem.scrubbed_species_binomial; Type: COMMENT; Schema: public; Owner: -
4208 4208
--
4209 4209

  
4210 4210

  
4211 4211

  
4212 4212

  
4213 4213
--
4214
-- Name: COLUMN analytical_stem_view.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: -
4214
-- Name: COLUMN analytical_stem.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: -
4215 4215
--
4216 4216

  
4217 4217

  
4218 4218

  
4219 4219

  
4220 4220
--
4221
-- Name: COLUMN analytical_stem_view.scrubbed_author; Type: COMMENT; Schema: public; Owner: -
4221
-- Name: COLUMN analytical_stem.scrubbed_author; Type: COMMENT; Schema: public; Owner: -
4222 4222
--
4223 4223

  
4224 4224

  
4225 4225

  
4226 4226

  
4227 4227
--
4228
-- Name: COLUMN analytical_stem_view.scrubbed_taxon_name_with_author; Type: COMMENT; Schema: public; Owner: -
4228
-- Name: COLUMN analytical_stem.scrubbed_taxon_name_with_author; Type: COMMENT; Schema: public; Owner: -
4229 4229
--
4230 4230

  
4231 4231

  
4232 4232

  
4233 4233

  
4234 4234
--
4235
-- Name: COLUMN analytical_stem_view.`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4235
-- Name: COLUMN analytical_stem.`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4236 4236
--
4237 4237

  
4238 4238

  
4239 4239

  
4240 4240

  
4241 4241
--
4242
-- Name: COLUMN analytical_stem_view.`[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4242
-- Name: COLUMN analytical_stem.`[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4243 4243
--
4244 4244

  
4245 4245

  
4246 4246

  
4247 4247

  
4248 4248
--
4249
-- Name: COLUMN analytical_stem_view.`reproductiveCondition__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4249
-- Name: COLUMN analytical_stem.`reproductiveCondition__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4250 4250
--
4251 4251

  
4252 4252

  
4253 4253

  
4254 4254

  
4255 4255
--
4256
-- Name: COLUMN analytical_stem_view.cultivated_bien; Type: COMMENT; Schema: public; Owner: -
4256
-- Name: COLUMN analytical_stem.cultivated_bien; Type: COMMENT; Schema: public; Owner: -
4257 4257
--
4258 4258

  
4259 4259

  
4260 4260

  
4261 4261

  
4262 4262
--
4263
-- Name: COLUMN analytical_stem_view.`cultivatedBasis_bien`; Type: COMMENT; Schema: public; Owner: -
4263
-- Name: COLUMN analytical_stem.`cultivatedBasis_bien`; Type: COMMENT; Schema: public; Owner: -
4264 4264
--
4265 4265

  
4266 4266

  
4267 4267

  
4268 4268

  
4269 4269
--
4270
-- Name: COLUMN analytical_stem_view.`occurrenceRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4270
-- Name: COLUMN analytical_stem.`occurrenceRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4271 4271
--
4272 4272

  
4273 4273

  
4274 4274

  
4275 4275

  
4276 4276
--
4277
-- Name: COLUMN analytical_stem_view.`coverPercent__@VegX__.attribute.ordinal@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4277
-- Name: COLUMN analytical_stem.`coverPercent__@VegX__.attribute.ordinal@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4278 4278
--
4279 4279

  
4280 4280

  
4281 4281

  
4282 4282

  
4283 4283
--
4284
-- Name: COLUMN analytical_stem_view.`taxonObservation[.id]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4284
-- Name: COLUMN analytical_stem.`taxonObservation[.id]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4285 4285
--
4286 4286

  
4287 4287

  
4288 4288

  
4289 4289

  
4290 4290
--
4291
-- Name: COLUMN analytical_stem_view.`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4291
-- Name: COLUMN analytical_stem.`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4292 4292
--
4293 4293

  
4294 4294

  
4295 4295

  
4296 4296

  
4297 4297
--
4298
-- Name: COLUMN analytical_stem_view.`aggregateOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4298
-- Name: COLUMN analytical_stem.`aggregateOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4299 4299
--
4300 4300

  
4301 4301

  
4302 4302

  
4303 4303

  
4304 4304
--
4305
-- Name: COLUMN analytical_stem_view.`individualOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4305
-- Name: COLUMN analytical_stem.`individualOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4306 4306
--
4307 4307

  
4308 4308

  
4309 4309

  
4310 4310

  
4311 4311
--
4312
-- Name: COLUMN analytical_stem_view.`individualID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4312
-- Name: COLUMN analytical_stem.`individualID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4313 4313
--
4314 4314

  
4315 4315

  
4316 4316

  
4317 4317

  
4318 4318
--
4319
-- Name: COLUMN analytical_stem_view.`individualCount__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4319
-- Name: COLUMN analytical_stem.`individualCount__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4320 4320
--
4321 4321

  
4322 4322

  
4323 4323

  
4324 4324

  
4325 4325
--
4326
-- Name: COLUMN analytical_stem_view.`stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4326
-- Name: COLUMN analytical_stem.`stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4327 4327
--
4328 4328

  
4329 4329

  
4330 4330

  
4331 4331

  
4332 4332
--
4333
-- Name: COLUMN analytical_stem_view.`stemHeight[_m]__@VegBank__.stemCount@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4333
-- Name: COLUMN analytical_stem.`stemHeight[_m]__@VegBank__.stemCount@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4334 4334
--
4335 4335

  
4336 4336

  
4337 4337

  
4338 4338

  
4339 4339
--
4340
-- Name: COLUMN analytical_stem_view.`[tag=]identificationLabel__@VegX__.individual@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4340
-- Name: COLUMN analytical_stem.`[tag=]identificationLabel__@VegX__.individual@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4341 4341
--
4342 4342

  
4343 4343

  
4344 4344

  
4345 4345

  
4346 4346
--
4347
-- Name: COLUMN analytical_stem_view.`relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4347
-- Name: COLUMN analytical_stem.`relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4348 4348
--
4349 4349

  
4350 4350

  
4351 4351

  
4352 4352

  
4353 4353
--
4354
-- Name: COLUMN analytical_stem_view.`relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4354
-- Name: COLUMN analytical_stem.`relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4355 4355
--
4356 4356

  
4357 4357

  
4358 4358

  
4359 4359

  
4360 4360
--
4361
-- Name: COLUMN analytical_stem_view.`stemCode__@VegBank__.stemLocation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4361
-- Name: COLUMN analytical_stem.`stemCode__@VegBank__.stemLocation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4362 4362
--
4363 4363

  
4364 4364

  
......
14905 14905

  
14906 14906

  
14907 14907
--
14908
-- Name: analytical_stem_view; Type: ACL; Schema: public; Owner: -
14908
-- Name: analytical_stem; Type: ACL; Schema: public; Owner: -
14909 14909
--
14910 14910

  
14911 14911

  
trunk/schemas/public_.sql
1982 1982

  
1983 1983

  
1984 1984
--
1985
-- Name: analytical_stem_view_modify(text, anyelement); Type: FUNCTION; Schema: public; Owner: -
1985
-- Name: analytical_stem_modify(text, anyelement); Type: FUNCTION; Schema: public; Owner: -
1986 1986
--
1987 1987

  
1988
CREATE FUNCTION analytical_stem_view_modify(view_query text DEFAULT NULL::text, schema_anchor anyelement DEFAULT NULL::schema_anchor) RETURNS void
1988
CREATE FUNCTION analytical_stem_modify(view_query text DEFAULT NULL::text, schema_anchor anyelement DEFAULT NULL::schema_anchor) RETURNS void
1989 1989
    LANGUAGE plpgsql
1990 1990
    AS $$
1991 1991
/* must use LANGUAGE plpgsql because LANGUAGE sql does not support runtime
......
1996 1996
BEGIN
1997 1997
	PERFORM util.use_schema(schema_anchor);
1998 1998
	
1999
	PERFORM util.recreate_view('analytical_stem_view', view_query);
1999
	PERFORM util.recreate_view('analytical_stem', view_query);
2000 2000
END;
2001 2001
$$;
2002 2002

  
2003 2003

  
2004 2004
--
2005
-- Name: FUNCTION analytical_stem_view_modify(view_query text, schema_anchor anyelement); Type: COMMENT; Schema: public; Owner: -
2005
-- Name: FUNCTION analytical_stem_modify(view_query text, schema_anchor anyelement); Type: COMMENT; Schema: public; Owner: -
2006 2006
--
2007 2007

  
2008
COMMENT ON FUNCTION analytical_stem_view_modify(view_query text, schema_anchor anyelement) IS '
2008
COMMENT ON FUNCTION analytical_stem_modify(view_query text, schema_anchor anyelement) IS '
2009 2009
usage:
2010
SELECT "analytical_stem_view_modify"($$
2010
SELECT "analytical_stem_modify"($$
2011 2011
SELECT __
2012 2012
$$);
2013 2013

  
......
6185 6185

  
6186 6186

  
6187 6187
--
6188
-- Name: analytical_stem_view; Type: VIEW; Schema: public; Owner: -
6188
-- Name: analytical_stem; Type: VIEW; Schema: public; Owner: -
6189 6189
--
6190 6190

  
6191
CREATE VIEW analytical_stem_view AS
6191
CREATE VIEW analytical_stem AS
6192 6192
 SELECT view_full_occurrence_individual."datasource__@Brad__.identifier_examples@vegpath.org",
6193 6193
    view_full_occurrence_individual."country__@DwC__@vegpath.org",
6194 6194
    view_full_occurrence_individual."stateProvince__@DwC__@vegpath.org",
......
6269 6269

  
6270 6270

  
6271 6271
--
6272
-- Name: VIEW analytical_stem_view; Type: COMMENT; Schema: public; Owner: -
6272
-- Name: VIEW analytical_stem; Type: COMMENT; Schema: public; Owner: -
6273 6273
--
6274 6274

  
6275
COMMENT ON VIEW analytical_stem_view IS '
6275
COMMENT ON VIEW analytical_stem IS '
6276 6276
after updating this:
6277
SELECT analytical_stem_view_modify()
6277
SELECT analytical_stem_modify()
6278 6278
add applicable columns to analytical_specimen, analytical_plot
6279 6279
';
6280 6280

  
6281 6281

  
6282 6282
--
6283
-- Name: COLUMN analytical_stem_view."datasource__@Brad__.identifier_examples@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6283
-- Name: COLUMN analytical_stem."datasource__@Brad__.identifier_examples@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6284 6284
--
6285 6285

  
6286
COMMENT ON COLUMN analytical_stem_view."datasource__@Brad__.identifier_examples@vegpath.org" IS '"the person [or] institution that provided the data [to this database] (the *proximate* data provider)"';
6286
COMMENT ON COLUMN analytical_stem."datasource__@Brad__.identifier_examples@vegpath.org" IS '"the person [or] institution that provided the data [to this database] (the *proximate* data provider)"';
6287 6287

  
6288 6288

  
6289 6289
--
6290
-- Name: COLUMN analytical_stem_view."country__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6290
-- Name: COLUMN analytical_stem."country__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6291 6291
--
6292 6292

  
6293
COMMENT ON COLUMN analytical_stem_view."country__@DwC__@vegpath.org" IS 'http://geoscrub.geoscrub_output.acceptedCountry__@VegBIEN__@vegpath.org;
6293
COMMENT ON COLUMN analytical_stem."country__@DwC__@vegpath.org" IS 'http://geoscrub.geoscrub_output.acceptedCountry__@VegBIEN__@vegpath.org;
6294 6294
"The name of the country or major administrative unit in which the Location occurs"';
6295 6295

  
6296 6296

  
6297 6297
--
6298
-- Name: COLUMN analytical_stem_view."stateProvince__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6298
-- Name: COLUMN analytical_stem."stateProvince__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6299 6299
--
6300 6300

  
6301
COMMENT ON COLUMN analytical_stem_view."stateProvince__@DwC__@vegpath.org" IS '"The name of the next smaller administrative region than country (state, province, canton, department, region, etc.) in which the Location occurs"';
6301
COMMENT ON COLUMN analytical_stem."stateProvince__@DwC__@vegpath.org" IS '"The name of the next smaller administrative region than country (state, province, canton, department, region, etc.) in which the Location occurs"';
6302 6302

  
6303 6303

  
6304 6304
--
6305
-- Name: COLUMN analytical_stem_view."county__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6305
-- Name: COLUMN analytical_stem."county__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6306 6306
--
6307 6307

  
6308
COMMENT ON COLUMN analytical_stem_view."county__@DwC__@vegpath.org" IS '"The full, unabbreviated name of the next smaller administrative region than stateProvince (county, shire, department, etc.) in which the Location occurs"';
6308
COMMENT ON COLUMN analytical_stem."county__@DwC__@vegpath.org" IS '"The full, unabbreviated name of the next smaller administrative region than stateProvince (county, shire, department, etc.) in which the Location occurs"';
6309 6309

  
6310 6310

  
6311 6311
--
6312
-- Name: COLUMN analytical_stem_view."locality__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6312
-- Name: COLUMN analytical_stem."locality__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6313 6313
--
6314 6314

  
6315
COMMENT ON COLUMN analytical_stem_view."locality__@DwC__@vegpath.org" IS '"The specific description of the place"';
6315
COMMENT ON COLUMN analytical_stem."locality__@DwC__@vegpath.org" IS '"The specific description of the place"';
6316 6316

  
6317 6317

  
6318 6318
--
6319
-- Name: COLUMN analytical_stem_view."decimalLatitude__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6319
-- Name: COLUMN analytical_stem."decimalLatitude__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6320 6320
--
6321 6321

  
6322
COMMENT ON COLUMN analytical_stem_view."decimalLatitude__@DwC__@vegpath.org" IS '"The geographic latitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"';
6322
COMMENT ON COLUMN analytical_stem."decimalLatitude__@DwC__@vegpath.org" IS '"The geographic latitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"';
6323 6323

  
6324 6324

  
6325 6325
--
6326
-- Name: COLUMN analytical_stem_view."decimalLongitude__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6326
-- Name: COLUMN analytical_stem."decimalLongitude__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6327 6327
--
6328 6328

  
6329
COMMENT ON COLUMN analytical_stem_view."decimalLongitude__@DwC__@vegpath.org" IS '"The geographic longitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"';
6329
COMMENT ON COLUMN analytical_stem."decimalLongitude__@DwC__@vegpath.org" IS '"The geographic longitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"';
6330 6330

  
6331 6331

  
6332 6332
--
6333
-- Name: COLUMN analytical_stem_view."coordinateUncertaintyInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6333
-- Name: COLUMN analytical_stem."coordinateUncertaintyInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6334 6334
--
6335 6335

  
6336
COMMENT ON COLUMN analytical_stem_view."coordinateUncertaintyInMeters__@DwC__@vegpath.org" IS 'for a point observation, this is the fuzziness of the coordinates. for a plot (or other shape), this is the radius of the circle that circumscribes the entire plot, or the fuzziness, whichever is greater. note that the DwC definition is confusingly worded: it uses the ambiguous term Location, which sometimes refers to the asserted named place, but which they intended to refer to the plot or point.';
6336
COMMENT ON COLUMN analytical_stem."coordinateUncertaintyInMeters__@DwC__@vegpath.org" IS 'for a point observation, this is the fuzziness of the coordinates. for a plot (or other shape), this is the radius of the circle that circumscribes the entire plot, or the fuzziness, whichever is greater. note that the DwC definition is confusingly worded: it uses the ambiguous term Location, which sometimes refers to the asserted named place, but which they intended to refer to the plot or point.';
6337 6337

  
6338 6338

  
6339 6339
--
6340
-- Name: COLUMN analytical_stem_view."georeferenceSources__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6340
-- Name: COLUMN analytical_stem."georeferenceSources__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6341 6341
--
6342 6342

  
6343
COMMENT ON COLUMN analytical_stem_view."georeferenceSources__@DwC__@vegpath.org" IS '"A list (concatenated and separated) of maps, gazetteers, or other resources used to georeference the Location, described specifically enough to allow anyone in the future to use the same resources"';
6343
COMMENT ON COLUMN analytical_stem."georeferenceSources__@DwC__@vegpath.org" IS '"A list (concatenated and separated) of maps, gazetteers, or other resources used to georeference the Location, described specifically enough to allow anyone in the future to use the same resources"';
6344 6344

  
6345 6345

  
6346 6346
--
6347
-- Name: COLUMN analytical_stem_view."georeferenceProtocol__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6347
-- Name: COLUMN analytical_stem."georeferenceProtocol__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6348 6348
--
6349 6349

  
6350
COMMENT ON COLUMN analytical_stem_view."georeferenceProtocol__@DwC__@vegpath.org" IS '"A description or reference to the methods used to determine the spatial footprint, coordinates, and uncertainties"';
6350
COMMENT ON COLUMN analytical_stem."georeferenceProtocol__@DwC__@vegpath.org" IS '"A description or reference to the methods used to determine the spatial footprint, coordinates, and uncertainties"';
6351 6351

  
6352 6352

  
6353 6353
--
6354
-- Name: COLUMN analytical_stem_view.geovalid_bien; Type: COMMENT; Schema: public; Owner: -
6354
-- Name: COLUMN analytical_stem.geovalid_bien; Type: COMMENT; Schema: public; Owner: -
6355 6355
--
6356 6356

  
6357
COMMENT ON COLUMN analytical_stem_view.geovalid_bien IS 'whether the coordinates are within the boundary of the asserted named places';
6357
COMMENT ON COLUMN analytical_stem.geovalid_bien IS 'whether the coordinates are within the boundary of the asserted named places';
6358 6358

  
6359 6359

  
6360 6360
--
6361
-- Name: COLUMN analytical_stem_view."isNewWorld_bien"; Type: COMMENT; Schema: public; Owner: -
6361
-- Name: COLUMN analytical_stem."isNewWorld_bien"; Type: COMMENT; Schema: public; Owner: -
6362 6362
--
6363 6363

  
6364
COMMENT ON COLUMN analytical_stem_view."isNewWorld_bien" IS 'whether the country is in the Americas';
6364
COMMENT ON COLUMN analytical_stem."isNewWorld_bien" IS 'whether the country is in the Americas';
6365 6365

  
6366 6366

  
6367 6367
--
6368
-- Name: COLUMN analytical_stem_view."projectID__@VegX__.plotObservation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6368
-- Name: COLUMN analytical_stem."projectID__@VegX__.plotObservation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6369 6369
--
6370 6370

  
6371
COMMENT ON COLUMN analytical_stem_view."projectID__@VegX__.plotObservation@vegpath.org" IS 'http://project.sourceaccessioncode__@VegBIEN__.public@vegpath.org;
6371
COMMENT ON COLUMN analytical_stem."projectID__@VegX__.plotObservation@vegpath.org" IS 'http://project.sourceaccessioncode__@VegBIEN__.public@vegpath.org;
6372 6372
"A reference to a specific ''project''"';
6373 6373

  
6374 6374

  
6375 6375
--
6376
-- Name: COLUMN analytical_stem_view."projectContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6376
-- Name: COLUMN analytical_stem."projectContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6377 6377
--
6378 6378

  
6379
COMMENT ON COLUMN analytical_stem_view."projectContributor[s]__@VegBank__@vegpath.org" IS '"intersection entit[ies] used to ''link'' a party with a specific project wherein vegetation plots are described"';
6379
COMMENT ON COLUMN analytical_stem."projectContributor[s]__@VegBank__@vegpath.org" IS '"intersection entit[ies] used to ''link'' a party with a specific project wherein vegetation plots are described"';
6380 6380

  
6381 6381

  
6382 6382
--
6383
-- Name: COLUMN analytical_stem_view."locationID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6383
-- Name: COLUMN analytical_stem."locationID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6384 6384
--
6385 6385

  
6386
COMMENT ON COLUMN analytical_stem_view."locationID__@DwC__@vegpath.org" IS '"An identifier for the set of location information (data associated with dcterms:Location)"';
6386
COMMENT ON COLUMN analytical_stem."locationID__@DwC__@vegpath.org" IS '"An identifier for the set of location information (data associated with dcterms:Location)"';
6387 6387

  
6388 6388

  
6389 6389
--
6390
-- Name: COLUMN analytical_stem_view."plotName__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6390
-- Name: COLUMN analytical_stem."plotName__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6391 6391
--
6392 6392

  
6393
COMMENT ON COLUMN analytical_stem_view."plotName__@VegX__.plot@vegpath.org" IS '"Name or label for a plot"';
6393
COMMENT ON COLUMN analytical_stem."plotName__@VegX__.plot@vegpath.org" IS '"Name or label for a plot"';
6394 6394

  
6395 6395

  
6396 6396
--
6397
-- Name: COLUMN analytical_stem_view."subplot__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6397
-- Name: COLUMN analytical_stem."subplot__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6398 6398
--
6399 6399

  
6400
COMMENT ON COLUMN analytical_stem_view."subplot__@SALVIAS__.Plot_data@vegpath.org" IS 'http://location.authorlocationcode__@VegBIEN__.public@vegpath.org;
6400
COMMENT ON COLUMN analytical_stem."subplot__@SALVIAS__.Plot_data@vegpath.org" IS 'http://location.authorlocationcode__@VegBIEN__.public@vegpath.org;
6401 6401
"Code for subplot, line, or any other subsample or subdivision of plot"';
6402 6402

  
6403 6403

  
6404 6404
--
6405
-- Name: COLUMN analytical_stem_view.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -
6405
-- Name: COLUMN analytical_stem.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -
6406 6406
--
6407 6407

  
6408
COMMENT ON COLUMN analytical_stem_view.location__cultivated__bien IS 'whether the occurrence''s *location* was flagged as cultivated. note that this refers just to the cultivated status of the *location*; the occurrence may be cultivated even if the location isn''t.';
6408
COMMENT ON COLUMN analytical_stem.location__cultivated__bien IS 'whether the occurrence''s *location* was flagged as cultivated. note that this refers just to the cultivated status of the *location*; the occurrence may be cultivated even if the location isn''t.';
6409 6409

  
6410 6410

  
6411 6411
--
6412
-- Name: COLUMN analytical_stem_view."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6412
-- Name: COLUMN analytical_stem."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6413 6413
--
6414 6414

  
6415
COMMENT ON COLUMN analytical_stem_view."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org" IS 'http://locationevent.locationevent_id__@VegBIEN__.public@vegpath.org;
6415
COMMENT ON COLUMN analytical_stem."locationevent.locationevent_id__@VegBIEN__.public@vegpath.org" IS 'http://locationevent.locationevent_id__@VegBIEN__.public@vegpath.org;
6416 6416
autogenerated ID for locationevent';
6417 6417

  
6418 6418

  
6419 6419
--
6420
-- Name: COLUMN analytical_stem_view."eventDate__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6420
-- Name: COLUMN analytical_stem."eventDate__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6421 6421
--
6422 6422

  
6423
COMMENT ON COLUMN analytical_stem_view."eventDate__@DwC__@vegpath.org" IS '"The date-time or interval during which an Event occurred. For occurrences, this is the date-time when the event was recorded."';
6423
COMMENT ON COLUMN analytical_stem."eventDate__@DwC__@vegpath.org" IS '"The date-time or interval during which an Event occurred. For occurrences, this is the date-time when the event was recorded."';
6424 6424

  
6425 6425

  
6426 6426
--
6427
-- Name: COLUMN analytical_stem_view."(-minimum-)ElevationInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6427
-- Name: COLUMN analytical_stem."(-minimum-)ElevationInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6428 6428
--
6429 6429

  
6430
COMMENT ON COLUMN analytical_stem_view."(-minimum-)ElevationInMeters__@DwC__@vegpath.org" IS 'the "elevation (altitude, usually above sea level), in meters"';
6430
COMMENT ON COLUMN analytical_stem."(-minimum-)ElevationInMeters__@DwC__@vegpath.org" IS 'the "elevation (altitude, usually above sea level), in meters"';
6431 6431

  
6432 6432

  
6433 6433
--
6434
-- Name: COLUMN analytical_stem_view."slopeAspect[_deg]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6434
-- Name: COLUMN analytical_stem."slopeAspect[_deg]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6435 6435
--
6436 6436

  
6437
COMMENT ON COLUMN analytical_stem_view."slopeAspect[_deg]__@VegX__.plot@vegpath.org" IS '"Representative azimuth of slope gradient (0-360 degrees) or as a cardinal direction (e.g. N, S, NE)"';
6437
COMMENT ON COLUMN analytical_stem."slopeAspect[_deg]__@VegX__.plot@vegpath.org" IS '"Representative azimuth of slope gradient (0-360 degrees) or as a cardinal direction (e.g. N, S, NE)"';
6438 6438

  
6439 6439

  
6440 6440
--
6441
-- Name: COLUMN analytical_stem_view."slopeGradient[_deg]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6441
-- Name: COLUMN analytical_stem."slopeGradient[_deg]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6442 6442
--
6443 6443

  
6444
COMMENT ON COLUMN analytical_stem_view."slopeGradient[_deg]__@VegX__.plot@vegpath.org" IS '"Representative inclination of slope in degrees"';
6444
COMMENT ON COLUMN analytical_stem."slopeGradient[_deg]__@VegX__.plot@vegpath.org" IS '"Representative inclination of slope in degrees"';
6445 6445

  
6446 6446

  
6447 6447
--
6448
-- Name: COLUMN analytical_stem_view."plot.area[_ha]__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6448
-- Name: COLUMN analytical_stem."plot.area[_ha]__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6449 6449
--
6450 6450

  
6451
COMMENT ON COLUMN analytical_stem_view."plot.area[_ha]__@VegX__@vegpath.org" IS '"Total area of the plot"';
6451
COMMENT ON COLUMN analytical_stem."plot.area[_ha]__@VegX__@vegpath.org" IS '"Total area of the plot"';
6452 6452

  
6453 6453

  
6454 6454
--
6455
-- Name: COLUMN analytical_stem_view."samplingProtocol__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6455
-- Name: COLUMN analytical_stem."samplingProtocol__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6456 6456
--
6457 6457

  
6458
COMMENT ON COLUMN analytical_stem_view."samplingProtocol__@DwC__@vegpath.org" IS '"The name of, reference to, or description of the method or protocol used during an Event"';
6458
COMMENT ON COLUMN analytical_stem."samplingProtocol__@DwC__@vegpath.org" IS '"The name of, reference to, or description of the method or protocol used during an Event"';
6459 6459

  
6460 6460

  
6461 6461
--
6462
-- Name: COLUMN analytical_stem_view."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6462
-- Name: COLUMN analytical_stem."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6463 6463
--
6464 6464

  
6465
COMMENT ON COLUMN analytical_stem_view."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org" IS '"Temperature during observation [...] [in] Celsius"';
6465
COMMENT ON COLUMN analytical_stem."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org" IS '"Temperature during observation [...] [in] Celsius"';
6466 6466

  
6467 6467

  
6468 6468
--
6469
-- Name: COLUMN analytical_stem_view."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6469
-- Name: COLUMN analytical_stem."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6470 6470
--
6471 6471

  
6472
COMMENT ON COLUMN analytical_stem_view."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org" IS '"Total annual precipitation, in mm"';
6472
COMMENT ON COLUMN analytical_stem."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org" IS '"Total annual precipitation, in mm"';
6473 6473

  
6474 6474

  
6475 6475
--
6476
-- Name: COLUMN analytical_stem_view."stratumName__@VegX__.stratum@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6476
-- Name: COLUMN analytical_stem."stratumName__@VegX__.stratum@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6477 6477
--
6478 6478

  
6479
COMMENT ON COLUMN analytical_stem_view."stratumName__@VegX__.stratum@vegpath.org" IS '"Name associated with this stratum"';
6479
COMMENT ON COLUMN analytical_stem."stratumName__@VegX__.stratum@vegpath.org" IS '"Name associated with this stratum"';
6480 6480

  
6481 6481

  
6482 6482
--
6483
-- Name: COLUMN analytical_stem_view."communityConcept.name__@VegX__.communityDet@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6483
-- Name: COLUMN analytical_stem."communityConcept.name__@VegX__.communityDet@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6484 6484
--
6485 6485

  
6486
COMMENT ON COLUMN analytical_stem_view."communityConcept.name__@VegX__.communityDet@vegpath.org" IS '"A textual label for a community type. A community type is an abstract grouping of organisms that tend to co-occur on the landscape due to shared ecological requirements or preferences."';
6486
COMMENT ON COLUMN analytical_stem."communityConcept.name__@VegX__.communityDet@vegpath.org" IS '"A textual label for a community type. A community type is an abstract grouping of organisms that tend to co-occur on the landscape due to shared ecological requirements or preferences."';
6487 6487

  
6488 6488

  
6489 6489
--
6490
-- Name: COLUMN analytical_stem_view."observationContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6490
-- Name: COLUMN analytical_stem."observationContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6491 6491
--
6492 6492

  
6493
COMMENT ON COLUMN analytical_stem_view."observationContributor[s]__@VegBank__@vegpath.org" IS '"intersection[s] that link[] a party with a specific plot observation event"';
6493
COMMENT ON COLUMN analytical_stem."observationContributor[s]__@VegBank__@vegpath.org" IS '"intersection[s] that link[] a party with a specific plot observation event"';
6494 6494

  
6495 6495

  
6496 6496
--
6497
-- Name: COLUMN analytical_stem_view."[custodial_]institutionCode[s]__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6497
-- Name: COLUMN analytical_stem."[custodial_]institutionCode[s]__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6498 6498
--
6499 6499

  
6500
COMMENT ON COLUMN analytical_stem_view."[custodial_]institutionCode[s]__@DwC__@vegpath.org" IS '"The name[s] (or acronym[s]) in use by the institution[s] having custody of the object(s) or information referred to in the record"';
6500
COMMENT ON COLUMN analytical_stem."[custodial_]institutionCode[s]__@DwC__@vegpath.org" IS '"The name[s] (or acronym[s]) in use by the institution[s] having custody of the object(s) or information referred to in the record"';
6501 6501

  
6502 6502

  
6503 6503
--
6504
-- Name: COLUMN analytical_stem_view."collectionCode__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6504
-- Name: COLUMN analytical_stem."collectionCode__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6505 6505
--
6506 6506

  
6507
COMMENT ON COLUMN analytical_stem_view."collectionCode__@DwC__@vegpath.org" IS '"The name, acronym, coden, or initialism identifying the collection or data set from which the record was derived"';
6507
COMMENT ON COLUMN analytical_stem."collectionCode__@DwC__@vegpath.org" IS '"The name, acronym, coden, or initialism identifying the collection or data set from which the record was derived"';
6508 6508

  
6509 6509

  
6510 6510
--
6511
-- Name: COLUMN analytical_stem_view."catalogNumber__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6511
-- Name: COLUMN analytical_stem."catalogNumber__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6512 6512
--
6513 6513

  
6514
COMMENT ON COLUMN analytical_stem_view."catalogNumber__@DwC__@vegpath.org" IS '"An identifier (preferably unique) for the record within the data set or collection"';
6514
COMMENT ON COLUMN analytical_stem."catalogNumber__@DwC__@vegpath.org" IS '"An identifier (preferably unique) for the record within the data set or collection"';
6515 6515

  
6516 6516

  
6517 6517
--
6518
-- Name: COLUMN analytical_stem_view."occurrenceID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6518
-- Name: COLUMN analytical_stem."occurrenceID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6519 6519
--
6520 6520

  
6521
COMMENT ON COLUMN analytical_stem_view."occurrenceID__@DwC__@vegpath.org" IS '"An identifier for the Occurrence (as opposed to a particular digital record of the occurrence). In the absence of a persistent global unique identifier, construct one from a combination of identifiers in the record that will most closely make the occurrenceID globally unique."';
6521
COMMENT ON COLUMN analytical_stem."occurrenceID__@DwC__@vegpath.org" IS '"An identifier for the Occurrence (as opposed to a particular digital record of the occurrence). In the absence of a persistent global unique identifier, construct one from a combination of identifiers in the record that will most closely make the occurrenceID globally unique."';
6522 6522

  
6523 6523

  
6524 6524
--
6525
-- Name: COLUMN analytical_stem_view."recordedBy__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6525
-- Name: COLUMN analytical_stem."recordedBy__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6526 6526
--
6527 6527

  
6528
COMMENT ON COLUMN analytical_stem_view."recordedBy__@DwC__@vegpath.org" IS '"A list (concatenated and separated) of names of people, groups, or organizations responsible for recording the original Occurrence. The primary collector or observer, especially one who applies a personal identifier (recordNumber), should be listed first."';
6528
COMMENT ON COLUMN analytical_stem."recordedBy__@DwC__@vegpath.org" IS '"A list (concatenated and separated) of names of people, groups, or organizations responsible for recording the original Occurrence. The primary collector or observer, especially one who applies a personal identifier (recordNumber), should be listed first."';
6529 6529

  
6530 6530

  
6531 6531
--
6532
-- Name: COLUMN analytical_stem_view."recordNumber__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6532
-- Name: COLUMN analytical_stem."recordNumber__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6533 6533
--
6534 6534

  
6535
COMMENT ON COLUMN analytical_stem_view."recordNumber__@DwC__@vegpath.org" IS '"An identifier given to the Occurrence at the time it was recorded. Often serves as a link between field notes and an Occurrence record, such as a specimen collector''s number."';
6535
COMMENT ON COLUMN analytical_stem."recordNumber__@DwC__@vegpath.org" IS '"An identifier given to the Occurrence at the time it was recorded. Often serves as a link between field notes and an Occurrence record, such as a specimen collector''s number."';
6536 6536

  
6537 6537

  
6538 6538
--
6539
-- Name: COLUMN analytical_stem_view."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6539
-- Name: COLUMN analytical_stem."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6540 6540
--
6541 6541

  
6542
COMMENT ON COLUMN analytical_stem_view."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org" IS 'the "date-time (Common Era calendar) in a date-time period during which an organism or group of organisms was collected or observed"';
6542
COMMENT ON COLUMN analytical_stem."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org" IS 'the "date-time (Common Era calendar) in a date-time period during which an organism or group of organisms was collected or observed"';
6543 6543

  
6544 6544

  
6545 6545
--
6546
-- Name: COLUMN analytical_stem_view."[verbatim_]family__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6546
-- Name: COLUMN analytical_stem."[verbatim_]family__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6547 6547
--
6548 6548

  
6549
COMMENT ON COLUMN analytical_stem_view."[verbatim_]family__@DwC__@vegpath.org" IS '"The full scientific name of the family in which the taxon is classified [*before* any TNRS scrubbing]"';
6549
COMMENT ON COLUMN analytical_stem."[verbatim_]family__@DwC__@vegpath.org" IS '"The full scientific name of the family in which the taxon is classified [*before* any TNRS scrubbing]"';
6550 6550

  
6551 6551

  
6552 6552
--
6553
-- Name: COLUMN analytical_stem_view."[verbatim_]scientificName__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6553
-- Name: COLUMN analytical_stem."[verbatim_]scientificName__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6554 6554
--
6555 6555

  
6556
COMMENT ON COLUMN analytical_stem_view."[verbatim_]scientificName__@DwC__@vegpath.org" IS '"The full scientific name [*before* any TNRS scrubbing], with authorship and date information if known. When forming part of an Identification, this should be the name in lowest level taxonomic rank that can be determined."';
6556
COMMENT ON COLUMN analytical_stem."[verbatim_]scientificName__@DwC__@vegpath.org" IS '"The full scientific name [*before* any TNRS scrubbing], with authorship and date information if known. When forming part of an Identification, this should be the name in lowest level taxonomic rank that can be determined."';
6557 6557

  
6558 6558

  
6559 6559
--
6560
-- Name: COLUMN analytical_stem_view."identifiedBy__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6560
-- Name: COLUMN analytical_stem."identifiedBy__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6561 6561
--
6562 6562

  
6563
COMMENT ON COLUMN analytical_stem_view."identifiedBy__@DwC__@vegpath.org" IS '"A list (concatenated and separated) of names of people, groups, or organizations who assigned the Taxon to the subject"';
6563
COMMENT ON COLUMN analytical_stem."identifiedBy__@DwC__@vegpath.org" IS '"A list (concatenated and separated) of names of people, groups, or organizations who assigned the Taxon to the subject"';
6564 6564

  
6565 6565

  
6566 6566
--
6567
-- Name: COLUMN analytical_stem_view."dateIdentified__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6567
-- Name: COLUMN analytical_stem."dateIdentified__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6568 6568
--
6569 6569

  
6570
COMMENT ON COLUMN analytical_stem_view."dateIdentified__@DwC__@vegpath.org" IS '"The date on which the subject was identified as representing the Taxon"';
6570
COMMENT ON COLUMN analytical_stem."dateIdentified__@DwC__@vegpath.org" IS '"The date on which the subject was identified as representing the Taxon"';
6571 6571

  
6572 6572

  
6573 6573
--
6574
-- Name: COLUMN analytical_stem_view."identificationRemarks__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6574
-- Name: COLUMN analytical_stem."identificationRemarks__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6575 6575
--
6576 6576

  
6577
COMMENT ON COLUMN analytical_stem_view."identificationRemarks__@DwC__@vegpath.org" IS '"Comments or notes about the Identification"';
6577
COMMENT ON COLUMN analytical_stem."identificationRemarks__@DwC__@vegpath.org" IS '"Comments or notes about the Identification"';
6578 6578

  
6579 6579

  
6580 6580
--
6581
-- Name: COLUMN analytical_stem_view."Family_matched__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6581
-- Name: COLUMN analytical_stem."Family_matched__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6582 6582
--
6583 6583

  
6584
COMMENT ON COLUMN analytical_stem_view."Family_matched__@TNRS__@vegpath.org" IS 'http://TNRS.taxon_scrub.matchedFamily__@VegBIEN__.public@vegpath.org;
6584
COMMENT ON COLUMN analytical_stem."Family_matched__@TNRS__@vegpath.org" IS 'http://TNRS.taxon_scrub.matchedFamily__@VegBIEN__.public@vegpath.org;
6585 6585
"The closest matching family in the TNRS database to the family submitted"';
6586 6586

  
6587 6587

  
6588 6588
--
6589
-- Name: COLUMN analytical_stem_view."Name_matched__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6589
-- Name: COLUMN analytical_stem."Name_matched__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6590 6590
--
6591 6591

  
6592
COMMENT ON COLUMN analytical_stem_view."Name_matched__@TNRS__@vegpath.org" IS '"Scientific name with the highest match score. May be an exact match or a fuzzy match."';
6592
COMMENT ON COLUMN analytical_stem."Name_matched__@TNRS__@vegpath.org" IS '"Scientific name with the highest match score. May be an exact match or a fuzzy match."';
6593 6593

  
6594 6594

  
6595 6595
--
6596
-- Name: COLUMN analytical_stem_view."Name_matched_author__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6596
-- Name: COLUMN analytical_stem."Name_matched_author__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6597 6597
--
6598 6598

  
6599
COMMENT ON COLUMN analytical_stem_view."Name_matched_author__@TNRS__@vegpath.org" IS '"Standard authority for the matched name"';
6599
COMMENT ON COLUMN analytical_stem."Name_matched_author__@TNRS__@vegpath.org" IS '"Standard authority for the matched name"';
6600 6600

  
6601 6601

  
6602 6602
--
6603
-- Name: COLUMN analytical_stem_view."[higher_plant_group~]higherClassification__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6603
-- Name: COLUMN analytical_stem."[higher_plant_group~]higherClassification__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6604 6604
--
6605 6605

  
6606
COMMENT ON COLUMN analytical_stem_view."[higher_plant_group~]higherClassification__@DwC__@vegpath.org" IS 'closed list derived from higher taxa';
6606
COMMENT ON COLUMN analytical_stem."[higher_plant_group~]higherClassification__@DwC__@vegpath.org" IS 'closed list derived from higher taxa';
6607 6607

  
6608 6608

  
6609 6609
--
6610
-- Name: COLUMN analytical_stem_view."taxonomicStatus__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6610
-- Name: COLUMN analytical_stem."taxonomicStatus__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6611 6611
--
6612 6612

  
6613
COMMENT ON COLUMN analytical_stem_view."taxonomicStatus__@DwC__@vegpath.org" IS '"The status of the use of the scientificName as a label for a taxon. Requires taxonomic opinion to define the scope of a taxon. [...] Examples: "invalid", "misapplied", "homotypic synonym", "accepted"."';
6613
COMMENT ON COLUMN analytical_stem."taxonomicStatus__@DwC__@vegpath.org" IS '"The status of the use of the scientificName as a label for a taxon. Requires taxonomic opinion to define the scope of a taxon. [...] Examples: "invalid", "misapplied", "homotypic synonym", "accepted"."';
6614 6614

  
6615 6615

  
6616 6616
--
6617
-- Name: COLUMN analytical_stem_view.scrubbed_family; Type: COMMENT; Schema: public; Owner: -
6617
-- Name: COLUMN analytical_stem.scrubbed_family; Type: COMMENT; Schema: public; Owner: -
6618 6618
--
6619 6619

  
6620
COMMENT ON COLUMN analytical_stem_view.scrubbed_family IS 'the family of the TNRS accepted or matched name';
6620
COMMENT ON COLUMN analytical_stem.scrubbed_family IS 'the family of the TNRS accepted or matched name';
6621 6621

  
6622 6622

  
6623 6623
--
6624
-- Name: COLUMN analytical_stem_view.scrubbed_genus; Type: COMMENT; Schema: public; Owner: -
6624
-- Name: COLUMN analytical_stem.scrubbed_genus; Type: COMMENT; Schema: public; Owner: -
6625 6625
--
6626 6626

  
6627
COMMENT ON COLUMN analytical_stem_view.scrubbed_genus IS 'the genus of the TNRS accepted or matched name';
6627
COMMENT ON COLUMN analytical_stem.scrubbed_genus IS 'the genus of the TNRS accepted or matched name';
6628 6628

  
6629 6629

  
6630 6630
--
6631
-- Name: COLUMN analytical_stem_view.scrubbed_specific_epithet; Type: COMMENT; Schema: public; Owner: -
6631
-- Name: COLUMN analytical_stem.scrubbed_specific_epithet; Type: COMMENT; Schema: public; Owner: -
6632 6632
--
6633 6633

  
6634
COMMENT ON COLUMN analytical_stem_view.scrubbed_specific_epithet IS 'the specific epithet of the TNRS accepted or matched name';
6634
COMMENT ON COLUMN analytical_stem.scrubbed_specific_epithet IS 'the specific epithet of the TNRS accepted or matched name';
6635 6635

  
6636 6636

  
6637 6637
--
6638
-- Name: COLUMN analytical_stem_view.scrubbed_species_binomial; Type: COMMENT; Schema: public; Owner: -
6638
-- Name: COLUMN analytical_stem.scrubbed_species_binomial; Type: COMMENT; Schema: public; Owner: -
6639 6639
--
6640 6640

  
6641
COMMENT ON COLUMN analytical_stem_view.scrubbed_species_binomial IS 'the species binomial of the TNRS accepted or matched name';
6641
COMMENT ON COLUMN analytical_stem.scrubbed_species_binomial IS 'the species binomial of the TNRS accepted or matched name';
6642 6642

  
6643 6643

  
6644 6644
--
6645
-- Name: COLUMN analytical_stem_view.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: -
6645
-- Name: COLUMN analytical_stem.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: -
6646 6646
--
6647 6647

  
6648
COMMENT ON COLUMN analytical_stem_view.scrubbed_taxon_name_no_author IS 'the taxon name without author of the TNRS accepted or matched name';
6648
COMMENT ON COLUMN analytical_stem.scrubbed_taxon_name_no_author IS 'the taxon name without author of the TNRS accepted or matched name';
6649 6649

  
6650 6650

  
6651 6651
--
6652
-- Name: COLUMN analytical_stem_view.scrubbed_author; Type: COMMENT; Schema: public; Owner: -
6652
-- Name: COLUMN analytical_stem.scrubbed_author; Type: COMMENT; Schema: public; Owner: -
6653 6653
--
6654 6654

  
6655
COMMENT ON COLUMN analytical_stem_view.scrubbed_author IS 'the author of the TNRS accepted or matched name';
6655
COMMENT ON COLUMN analytical_stem.scrubbed_author IS 'the author of the TNRS accepted or matched name';
6656 6656

  
6657 6657

  
6658 6658
--
6659
-- Name: COLUMN analytical_stem_view.scrubbed_taxon_name_with_author; Type: COMMENT; Schema: public; Owner: -
6659
-- Name: COLUMN analytical_stem.scrubbed_taxon_name_with_author; Type: COMMENT; Schema: public; Owner: -
6660 6660
--
6661 6661

  
6662
COMMENT ON COLUMN analytical_stem_view.scrubbed_taxon_name_with_author IS 'the taxon name with author of the TNRS accepted or matched name';
6662
COMMENT ON COLUMN analytical_stem.scrubbed_taxon_name_with_author IS 'the taxon name with author of the TNRS accepted or matched name';
6663 6663

  
6664 6664

  
6665 6665
--
6666
-- Name: COLUMN analytical_stem_view."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6666
-- Name: COLUMN analytical_stem."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6667 6667
--
6668 6668

  
6669
COMMENT ON COLUMN analytical_stem_view."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org" IS 'http://TNRS.taxon_scrub.scrubbed_morphospecies_binomial__@VegBIEN__.public@vegpath.org;
6669
COMMENT ON COLUMN analytical_stem."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org" IS 'http://TNRS.taxon_scrub.scrubbed_morphospecies_binomial__@VegBIEN__.public@vegpath.org;
6670 6670
"combine the `taxon` plus `morphospecies` to produce a unique string, `taxonMorphospecies`";
6671 6671
a morphospecies is a custom species name assigned in the field by the collector (which does not validate to anything in TNRS)';
6672 6672

  
6673 6673

  
6674 6674
--
6675
-- Name: COLUMN analytical_stem_view."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6675
-- Name: COLUMN analytical_stem."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6676 6676
--
6677 6677

  
6678
COMMENT ON COLUMN analytical_stem_view."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org" IS '"Growth form"; "Closed pick list"';
6678
COMMENT ON COLUMN analytical_stem."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org" IS '"Growth form"; "Closed pick list"';
6679 6679

  
6680 6680

  
6681 6681
--
6682
-- Name: COLUMN analytical_stem_view."reproductiveCondition__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6682
-- Name: COLUMN analytical_stem."reproductiveCondition__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6683 6683
--
6684 6684

  
6685
COMMENT ON COLUMN analytical_stem_view."reproductiveCondition__@DwC__@vegpath.org" IS '"The reproductive condition of the biological individual(s) represented in the Occurrence. Recommended best practice is to use a controlled vocabulary."';
6685
COMMENT ON COLUMN analytical_stem."reproductiveCondition__@DwC__@vegpath.org" IS '"The reproductive condition of the biological individual(s) represented in the Occurrence. Recommended best practice is to use a controlled vocabulary."';
6686 6686

  
6687 6687

  
6688 6688
--
6689
-- Name: COLUMN analytical_stem_view.cultivated_bien; Type: COMMENT; Schema: public; Owner: -
6689
-- Name: COLUMN analytical_stem.cultivated_bien; Type: COMMENT; Schema: public; Owner: -
6690 6690
--
6691 6691

  
6692
COMMENT ON COLUMN analytical_stem_view.cultivated_bien IS 'whether the occurrence was flagged as cultivated';
6692
COMMENT ON COLUMN analytical_stem.cultivated_bien IS 'whether the occurrence was flagged as cultivated';
6693 6693

  
6694 6694

  
6695 6695
--
6696
-- Name: COLUMN analytical_stem_view."cultivatedBasis_bien"; Type: COMMENT; Schema: public; Owner: -
6696
-- Name: COLUMN analytical_stem."cultivatedBasis_bien"; Type: COMMENT; Schema: public; Owner: -
6697 6697
--
6698 6698

  
6699
COMMENT ON COLUMN analytical_stem_view."cultivatedBasis_bien" IS 'why the occurrence was flagged as cultivated';
6699
COMMENT ON COLUMN analytical_stem."cultivatedBasis_bien" IS 'why the occurrence was flagged as cultivated';
6700 6700

  
6701 6701

  
6702 6702
--
6703
-- Name: COLUMN analytical_stem_view."occurrenceRemarks__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6703
-- Name: COLUMN analytical_stem."occurrenceRemarks__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6704 6704
--
6705 6705

  
6706
COMMENT ON COLUMN analytical_stem_view."occurrenceRemarks__@DwC__@vegpath.org" IS '"Comments or notes about the Occurrence"';
6706
COMMENT ON COLUMN analytical_stem."occurrenceRemarks__@DwC__@vegpath.org" IS '"Comments or notes about the Occurrence"';
6707 6707

  
6708 6708

  
6709 6709
--
6710
-- Name: COLUMN analytical_stem_view."coverPercent__@VegX__.attribute.ordinal@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6710
-- Name: COLUMN analytical_stem."coverPercent__@VegX__.attribute.ordinal@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6711 6711
--
6712 6712

  
6713
COMMENT ON COLUMN analytical_stem_view."coverPercent__@VegX__.attribute.ordinal@vegpath.org" IS '"Average cover of the index in percent"';
6713
COMMENT ON COLUMN analytical_stem."coverPercent__@VegX__.attribute.ordinal@vegpath.org" IS '"Average cover of the index in percent"';
6714 6714

  
6715 6715

  
6716 6716
--
6717
-- Name: COLUMN analytical_stem_view."taxonObservation[.id]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6717
-- Name: COLUMN analytical_stem."taxonObservation[.id]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6718 6718
--
6719 6719

  
6720
COMMENT ON COLUMN analytical_stem_view."taxonObservation[.id]__@VegBank__@vegpath.org" IS '"identifier assigned [by the datasource] to each unique observation of a taxon in a plot"';
6720
COMMENT ON COLUMN analytical_stem."taxonObservation[.id]__@VegBank__@vegpath.org" IS '"identifier assigned [by the datasource] to each unique observation of a taxon in a plot"';
6721 6721

  
6722 6722

  
6723 6723
--
6724
-- Name: COLUMN analytical_stem_view."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6724
-- Name: COLUMN analytical_stem."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6725 6725
--
6726 6726

  
6727
COMMENT ON COLUMN analytical_stem_view."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org" IS '"Verbatum short code used by the author to signify the species at time of observation"';
6727
COMMENT ON COLUMN analytical_stem."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org" IS '"Verbatum short code used by the author to signify the species at time of observation"';
6728 6728

  
6729 6729

  
6730 6730
--
6731
-- Name: COLUMN analytical_stem_view."aggregateOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6731
-- Name: COLUMN analytical_stem."aggregateOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6732 6732
--
6733 6733

  
6734
COMMENT ON COLUMN analytical_stem_view."aggregateOrganismObservation.id__@VegX__@vegpath.org" IS 'the ID for "An observation applying to all occurrences of an organism based on an aggregation factor. It contains an AggregateValue, which is an assessment of the overall occurrence of an organism in a Plot (e.g. number of stems, percentage cover, total biomass, basal area)."';
6734
COMMENT ON COLUMN analytical_stem."aggregateOrganismObservation.id__@VegX__@vegpath.org" IS 'the ID for "An observation applying to all occurrences of an organism based on an aggregation factor. It contains an AggregateValue, which is an assessment of the overall occurrence of an organism in a Plot (e.g. number of stems, percentage cover, total biomass, basal area)."';
6735 6735

  
6736 6736

  
6737 6737
--
6738
-- Name: COLUMN analytical_stem_view."individualOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6738
-- Name: COLUMN analytical_stem."individualOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6739 6739
--
6740 6740

  
6741
COMMENT ON COLUMN analytical_stem_view."individualOrganismObservation.id__@VegX__@vegpath.org" IS 'the ID for "An observation applying to one occurrence of an organism (or part of an organism). It is a container for measurements made on the organism (e.g. diameter, height, crown dimensions, biomass, growth form, number of stems)."';
6741
COMMENT ON COLUMN analytical_stem."individualOrganismObservation.id__@VegX__@vegpath.org" IS 'the ID for "An observation applying to one occurrence of an organism (or part of an organism). It is a container for measurements made on the organism (e.g. diameter, height, crown dimensions, biomass, growth form, number of stems)."';
6742 6742

  
6743 6743

  
6744 6744
--
6745
-- Name: COLUMN analytical_stem_view."individualID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6745
-- Name: COLUMN analytical_stem."individualID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6746 6746
--
6747 6747

  
6748
COMMENT ON COLUMN analytical_stem_view."individualID__@DwC__@vegpath.org" IS '"An identifier for an individual or named group of individual organisms represented in the Occurrence"';
6748
COMMENT ON COLUMN analytical_stem."individualID__@DwC__@vegpath.org" IS '"An identifier for an individual or named group of individual organisms represented in the Occurrence"';
6749 6749

  
6750 6750

  
6751 6751
--
6752
-- Name: COLUMN analytical_stem_view."individualCount__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6752
-- Name: COLUMN analytical_stem."individualCount__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6753 6753
--
6754 6754

  
6755
COMMENT ON COLUMN analytical_stem_view."individualCount__@DwC__@vegpath.org" IS '"The number of individuals represented present at the time of the Occurrence"';
6755
COMMENT ON COLUMN analytical_stem."individualCount__@DwC__@vegpath.org" IS '"The number of individuals represented present at the time of the Occurrence"';
6756 6756

  
6757 6757

  
6758 6758
--
6759
-- Name: COLUMN analytical_stem_view."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6759
-- Name: COLUMN analytical_stem."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6760 6760
--
6761 6761

  
6762
COMMENT ON COLUMN analytical_stem_view."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org" IS '"Diameter at breast height of this stem (usually taken at 1.3 meters, but may vary)"';
6762
COMMENT ON COLUMN analytical_stem."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org" IS '"Diameter at breast height of this stem (usually taken at 1.3 meters, but may vary)"';
6763 6763

  
6764 6764

  
6765 6765
--
6766
-- Name: COLUMN analytical_stem_view."stemHeight[_m]__@VegBank__.stemCount@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6766
-- Name: COLUMN analytical_stem."stemHeight[_m]__@VegBank__.stemCount@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6767 6767
--
6768 6768

  
6769
COMMENT ON COLUMN analytical_stem_view."stemHeight[_m]__@VegBank__.stemCount@vegpath.org" IS '"The measured height of the stem in meters"';
6769
COMMENT ON COLUMN analytical_stem."stemHeight[_m]__@VegBank__.stemCount@vegpath.org" IS '"The measured height of the stem in meters"';
6770 6770

  
6771 6771

  
6772 6772
--
6773
-- Name: COLUMN analytical_stem_view."[tag=]identificationLabel__@VegX__.individual@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6773
-- Name: COLUMN analytical_stem."[tag=]identificationLabel__@VegX__.individual@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6774 6774
--
6775 6775

  
6776
COMMENT ON COLUMN analytical_stem_view."[tag=]identificationLabel__@VegX__.individual@vegpath.org" IS '"A label that is associated with an individual (e.g. a numerical tree tag)"';
6776
COMMENT ON COLUMN analytical_stem."[tag=]identificationLabel__@VegX__.individual@vegpath.org" IS '"A label that is associated with an individual (e.g. a numerical tree tag)"';
6777 6777

  
6778 6778

  
6779 6779
--
6780
-- Name: COLUMN analytical_stem_view."relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6780
-- Name: COLUMN analytical_stem."relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6781 6781
--
6782 6782

  
6783
COMMENT ON COLUMN analytical_stem_view."relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org" IS '"The X-coordinate of the related item position in m. The user will enter the relative position of related item with respect to the plot origin (in meters) with the x-axis defined by the plot azimuth."';
6783
COMMENT ON COLUMN analytical_stem."relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org" IS '"The X-coordinate of the related item position in m. The user will enter the relative position of related item with respect to the plot origin (in meters) with the x-axis defined by the plot azimuth."';
6784 6784

  
6785 6785

  
6786 6786
--
6787
-- Name: COLUMN analytical_stem_view."relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6787
-- Name: COLUMN analytical_stem."relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6788 6788
--
6789 6789

  
6790
COMMENT ON COLUMN analytical_stem_view."relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org" IS '"The Y-coordinate of the relatedSpatialItem position in m. The user will enter the relative position of relatedSpatialItems with respect to the plot origin (in meters) with the y-axis defined by the plot azimuth."';
6790
COMMENT ON COLUMN analytical_stem."relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org" IS '"The Y-coordinate of the relatedSpatialItem position in m. The user will enter the relative position of relatedSpatialItems with respect to the plot origin (in meters) with the y-axis defined by the plot azimuth."';
6791 6791

  
6792 6792

  
6793 6793
--
6794
-- Name: COLUMN analytical_stem_view."stemCode__@VegBank__.stemLocation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6794
-- Name: COLUMN analytical_stem."stemCode__@VegBank__.stemLocation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
6795 6795
--
6796 6796

  
6797
COMMENT ON COLUMN analytical_stem_view."stemCode__@VegBank__.stemLocation@vegpath.org" IS 'http://stemobservation.authorstemcode__@VegBIEN__.public@vegpath.org;
6797
COMMENT ON COLUMN analytical_stem."stemCode__@VegBank__.stemLocation@vegpath.org" IS 'http://stemobservation.authorstemcode__@VegBIEN__.public@vegpath.org;
6798 6798
"Name or code applied to a specific stem in the plot. This is generally a numeric label to associate a field data entry with a stem in the database."';
6799 6799

  
6800 6800

  
......
6803 6803
--
6804 6804

  
6805 6805
CREATE VIEW "2013-10-18.Brian_Enquist.Canadensys" AS
6806
 SELECT analytical_stem_view."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org" AS species,
6807
    analytical_stem_view."decimalLatitude__@DwC__@vegpath.org" AS latitude__deg,
6808
    analytical_stem_view."decimalLongitude__@DwC__@vegpath.org" AS longitude__deg,
6809
    analytical_stem_view."coordinateUncertaintyInMeters__@DwC__@vegpath.org" AS coords__uncertainty__m
6810
   FROM analytical_stem_view
6811
  WHERE (((((analytical_stem_view."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org" = ANY (ARRAY['Juniperus scopulorum'::text, 'Picea engelmannii'::text, 'Pinus contorta'::text, 'Pinus edulis'::text, 'Pinus ponderosa'::text, 'Populus tremuloides'::text, 'Pseudotsuga menziesii'::text, 'Quercus gambelii'::text])) AND (NOT COALESCE((analytical_stem_view.cultivated_bien)::boolean, false))) AND COALESCE((analytical_stem_view.geovalid_bien)::boolean, true)) AND (analytical_stem_view."decimalLatitude__@DwC__@vegpath.org" IS NOT NULL)) AND (analytical_stem_view."decimalLongitude__@DwC__@vegpath.org" IS NOT NULL))
6812
  ORDER BY analytical_stem_view."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org";
6806
 SELECT analytical_stem."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org" AS species,
6807
    analytical_stem."decimalLatitude__@DwC__@vegpath.org" AS latitude__deg,
6808
    analytical_stem."decimalLongitude__@DwC__@vegpath.org" AS longitude__deg,
6809
    analytical_stem."coordinateUncertaintyInMeters__@DwC__@vegpath.org" AS coords__uncertainty__m
6810
   FROM analytical_stem
6811
  WHERE (((((analytical_stem."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org" = ANY (ARRAY['Juniperus scopulorum'::text, 'Picea engelmannii'::text, 'Pinus contorta'::text, 'Pinus edulis'::text, 'Pinus ponderosa'::text, 'Populus tremuloides'::text, 'Pseudotsuga menziesii'::text, 'Quercus gambelii'::text])) AND (NOT COALESCE((analytical_stem.cultivated_bien)::boolean, false))) AND COALESCE((analytical_stem.geovalid_bien)::boolean, true)) AND (analytical_stem."decimalLatitude__@DwC__@vegpath.org" IS NOT NULL)) AND (analytical_stem."decimalLongitude__@DwC__@vegpath.org" IS NOT NULL))
6812
  ORDER BY analytical_stem."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org";
6813 6813

  
6814 6814

  
6815 6815
--
......
6817 6817
--
6818 6818

  
6819 6819
CREATE VIEW "2013-7-10.Naia.range_limiting_factors" AS
6820
 SELECT analytical_stem_view."TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org" AS occurrence_id,
6821
    analytical_stem_view."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org" AS species,
6822
    analytical_stem_view."decimalLatitude__@DwC__@vegpath.org" AS latitude__deg,
6823
    analytical_stem_view."decimalLongitude__@DwC__@vegpath.org" AS longitude__deg
6824
   FROM analytical_stem_view
6825
  WHERE ((((((NOT COALESCE((analytical_stem_view.cultivated_bien)::boolean, false)) AND COALESCE((analytical_stem_view.geovalid_bien)::boolean, true)) AND (analytical_stem_view."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org" IS NOT NULL)) AND (analytical_stem_view."decimalLatitude__@DwC__@vegpath.org" IS NOT NULL)) AND (analytical_stem_view."decimalLongitude__@DwC__@vegpath.org" IS NOT NULL)) AND COALESCE((analytical_stem_view."coordinateUncertaintyInMeters__@DwC__@vegpath.org" <= _km_to_m((10)::double precision)), true));
6820
 SELECT analytical_stem."TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org" AS occurrence_id,
6821
    analytical_stem."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org" AS species,
6822
    analytical_stem."decimalLatitude__@DwC__@vegpath.org" AS latitude__deg,
6823
    analytical_stem."decimalLongitude__@DwC__@vegpath.org" AS longitude__deg
6824
   FROM analytical_stem
6825
  WHERE ((((((NOT COALESCE((analytical_stem.cultivated_bien)::boolean, false)) AND COALESCE((analytical_stem.geovalid_bien)::boolean, true)) AND (analytical_stem."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org" IS NOT NULL)) AND (analytical_stem."decimalLatitude__@DwC__@vegpath.org" IS NOT NULL)) AND (analytical_stem."decimalLongitude__@DwC__@vegpath.org" IS NOT NULL)) AND COALESCE((analytical_stem."coordinateUncertaintyInMeters__@DwC__@vegpath.org" <= _km_to_m((10)::double precision)), true));
6826 6826

  
6827 6827

  
6828 6828
--
......
6830 6830
--
6831 6831

  
6832 6832
CREATE VIEW "2014-3-11.Jeff_Ott.climatic_range_determinants" AS
6833
 SELECT analytical_stem_view."datasource__@Brad__.identifier_examples@vegpath.org" AS datasource,
6834
    analytical_stem_view."decimalLatitude__@DwC__@vegpath.org" AS "decimalLatitude",
6835
    analytical_stem_view."decimalLongitude__@DwC__@vegpath.org" AS "decimalLongitude",
6836
    analytical_stem_view."[higher_plant_group~]higherClassification__@DwC__@vegpath.org" AS "higherPlantGroup",
6837
    analytical_stem_view.scrubbed_family AS family,
6838
    analytical_stem_view.scrubbed_genus AS genus,
6839
    analytical_stem_view.scrubbed_species_binomial AS "speciesBinomial",
6840
    analytical_stem_view.scrubbed_taxon_name_with_author AS "scientificName"
6841
   FROM analytical_stem_view
6842
  WHERE (((((COALESCE((analytical_stem_view.geovalid_bien)::boolean, true) AND COALESCE((analytical_stem_view."isNewWorld_bien")::boolean, false)) AND (NOT COALESCE((analytical_stem_view.cultivated_bien)::boolean, false))) AND (analytical_stem_view.scrubbed_taxon_name_with_author IS NOT NULL)) AND (analytical_stem_view."decimalLatitude__@DwC__@vegpath.org" IS NOT NULL)) AND (analytical_stem_view."decimalLongitude__@DwC__@vegpath.org" IS NOT NULL));
6833
 SELECT analytical_stem."datasource__@Brad__.identifier_examples@vegpath.org" AS datasource,
6834
    analytical_stem."decimalLatitude__@DwC__@vegpath.org" AS "decimalLatitude",
6835
    analytical_stem."decimalLongitude__@DwC__@vegpath.org" AS "decimalLongitude",
6836
    analytical_stem."[higher_plant_group~]higherClassification__@DwC__@vegpath.org" AS "higherPlantGroup",
6837
    analytical_stem.scrubbed_family AS family,
6838
    analytical_stem.scrubbed_genus AS genus,
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff