Project

General

Profile

« Previous | Next » 

Revision 13843

schemas/public_.sql: analytical_stem_view and related views: updated COMMENTs from data dictionary spreadsheet, using the steps at wiki.vegpath.org/VegBIEN_schema_refactoring#copy-data-dictionary-definitions-to-database

View differences:

vegbien.my.sql
3772 3772

  
3773 3773

  
3774 3774
--
3775
-- Name: COLUMN analytical_stem.`TAXONOBSERVATION_ID__@VegBank__.taxonObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3776
--
3777

  
3778

  
3779

  
3780

  
3781
--
3775 3782
-- Name: 2013-10-18.Brian_Enquist.Canadensys; Type: VIEW; Schema: public; Owner: -
3776 3783
--
3777 3784

  
......
3908 3915

  
3909 3916

  
3910 3917
--
3918
-- Name: COLUMN analytical_plot.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3919
--
3920

  
3921

  
3922

  
3923

  
3924
--
3925
-- Name: COLUMN analytical_plot.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3926
--
3927

  
3928

  
3929

  
3930

  
3931
--
3932
-- Name: COLUMN analytical_plot.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3933
--
3934

  
3935

  
3936

  
3937

  
3938
--
3939
-- Name: COLUMN analytical_plot.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3940
--
3941

  
3942

  
3943

  
3944

  
3945
--
3946
-- Name: COLUMN analytical_plot.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3947
--
3948

  
3949

  
3950

  
3951

  
3952
--
3953
-- Name: COLUMN analytical_plot.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3954
--
3955

  
3956

  
3957

  
3958

  
3959
--
3960
-- Name: COLUMN analytical_plot.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3961
--
3962

  
3963

  
3964

  
3965

  
3966
--
3967
-- Name: COLUMN analytical_plot.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3968
--
3969

  
3970

  
3971

  
3972

  
3973
--
3974
-- Name: COLUMN analytical_plot.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3975
--
3976

  
3977

  
3978

  
3979

  
3980
--
3981
-- Name: COLUMN analytical_plot.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
3982
--
3983

  
3984

  
3985

  
3986

  
3987
--
3988
-- Name: COLUMN analytical_plot.geovalid_bien; Type: COMMENT; Schema: public; Owner: -
3989
--
3990

  
3991

  
3992

  
3993

  
3994
--
3995
-- Name: COLUMN analytical_plot.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: -
3996
--
3997

  
3998

  
3999

  
4000

  
4001
--
4002
-- Name: COLUMN analytical_plot.`projectID__@VegX__.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4003
--
4004

  
4005

  
4006

  
4007

  
4008
--
4009
-- Name: COLUMN analytical_plot.`projectContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4010
--
4011

  
4012

  
4013

  
4014

  
4015
--
4016
-- Name: COLUMN analytical_plot.`locationID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4017
--
4018

  
4019

  
4020

  
4021

  
4022
--
4023
-- Name: COLUMN analytical_plot.`plotName__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4024
--
4025

  
4026

  
4027

  
4028

  
4029
--
4030
-- Name: COLUMN analytical_plot.`subplot__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4031
--
4032

  
4033

  
4034

  
4035

  
4036
--
4037
-- Name: COLUMN analytical_plot.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -
4038
--
4039

  
4040

  
4041

  
4042

  
4043
--
4044
-- Name: COLUMN analytical_plot.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4045
--
4046

  
4047

  
4048

  
4049

  
4050
--
4051
-- Name: COLUMN analytical_plot.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4052
--
4053

  
4054

  
4055

  
4056

  
4057
--
4058
-- Name: COLUMN analytical_plot.`slopeAspect[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4059
--
4060

  
4061

  
4062

  
4063

  
4064
--
4065
-- Name: COLUMN analytical_plot.`slopeGradient[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4066
--
4067

  
4068

  
4069

  
4070

  
4071
--
4072
-- Name: COLUMN analytical_plot.`plot.area[_ha]__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4073
--
4074

  
4075

  
4076

  
4077

  
4078
--
4079
-- Name: COLUMN analytical_plot.`samplingProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4080
--
4081

  
4082

  
4083

  
4084

  
4085
--
4086
-- Name: COLUMN analytical_plot.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4087
--
4088

  
4089

  
4090

  
4091

  
4092
--
4093
-- Name: COLUMN analytical_plot.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4094
--
4095

  
4096

  
4097

  
4098

  
4099
--
4100
-- Name: COLUMN analytical_plot.`stratumName__@VegX__.stratum@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4101
--
4102

  
4103

  
4104

  
4105

  
4106
--
4107
-- Name: COLUMN analytical_plot.`communityConcept.name__@VegX__.communityDet@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4108
--
4109

  
4110

  
4111

  
4112

  
4113
--
4114
-- Name: COLUMN analytical_plot.`observationContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4115
--
4116

  
4117

  
4118

  
4119

  
4120
--
4121
-- Name: COLUMN analytical_plot.`recordedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4122
--
4123

  
4124

  
4125

  
4126

  
4127
--
4128
-- Name: COLUMN analytical_plot.`recordNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4129
--
4130

  
4131

  
4132

  
4133

  
4134
--
4135
-- Name: COLUMN analytical_plot.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4136
--
4137

  
4138

  
4139

  
4140

  
4141
--
4142
-- Name: COLUMN analytical_plot.`[verbatim_]family__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4143
--
4144

  
4145

  
4146

  
4147

  
4148
--
4149
-- Name: COLUMN analytical_plot.`[verbatim_]scientificName__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4150
--
4151

  
4152

  
4153

  
4154

  
4155
--
4156
-- Name: COLUMN analytical_plot.`identifiedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4157
--
4158

  
4159

  
4160

  
4161

  
4162
--
4163
-- Name: COLUMN analytical_plot.`dateIdentified__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4164
--
4165

  
4166

  
4167

  
4168

  
4169
--
4170
-- Name: COLUMN analytical_plot.`identificationRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4171
--
4172

  
4173

  
4174

  
4175

  
4176
--
4177
-- Name: COLUMN analytical_plot.`Family_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4178
--
4179

  
4180

  
4181

  
4182

  
4183
--
4184
-- Name: COLUMN analytical_plot.`Name_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4185
--
4186

  
4187

  
4188

  
4189

  
4190
--
4191
-- Name: COLUMN analytical_plot.`Name_matched_author__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4192
--
4193

  
4194

  
4195

  
4196

  
4197
--
4198
-- Name: COLUMN analytical_plot.scrubbed_family; Type: COMMENT; Schema: public; Owner: -
4199
--
4200

  
4201

  
4202

  
4203

  
4204
--
4205
-- Name: COLUMN analytical_plot.scrubbed_genus; Type: COMMENT; Schema: public; Owner: -
4206
--
4207

  
4208

  
4209

  
4210

  
4211
--
4212
-- Name: COLUMN analytical_plot.`speciesBinomialWithMorphospecies__@VegCore__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4213
--
4214

  
4215

  
4216

  
4217

  
4218
--
4219
-- Name: COLUMN analytical_plot.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: -
4220
--
4221

  
4222

  
4223

  
4224

  
4225
--
4226
-- Name: COLUMN analytical_plot.scrubbed_author; Type: COMMENT; Schema: public; Owner: -
4227
--
4228

  
4229

  
4230

  
4231

  
4232
--
4233
-- Name: COLUMN analytical_plot.`[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4234
--
4235

  
4236

  
4237

  
4238

  
4239
--
4240
-- Name: COLUMN analytical_plot.`reproductiveCondition__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4241
--
4242

  
4243

  
4244

  
4245

  
4246
--
4247
-- Name: COLUMN analytical_plot.cultivated_bien; Type: COMMENT; Schema: public; Owner: -
4248
--
4249

  
4250

  
4251

  
4252

  
4253
--
4254
-- Name: COLUMN analytical_plot.`cultivatedBasis_bien`; Type: COMMENT; Schema: public; Owner: -
4255
--
4256

  
4257

  
4258

  
4259

  
4260
--
4261
-- Name: COLUMN analytical_plot.`occurrenceRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4262
--
4263

  
4264

  
4265

  
4266

  
4267
--
4268
-- Name: COLUMN analytical_plot.`coverPercent__@VegX__.attribute.ordinal@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4269
--
4270

  
4271

  
4272

  
4273

  
4274
--
4275
-- Name: COLUMN analytical_plot.`stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4276
--
4277

  
4278

  
4279

  
4280

  
4281
--
4282
-- Name: COLUMN analytical_plot.`stemHeight[_m]__@VegBank__.stemCount@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4283
--
4284

  
4285

  
4286

  
4287

  
4288
--
4289
-- Name: COLUMN analytical_plot.`[tag=]identificationLabel__@VegX__.individual@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4290
--
4291

  
4292

  
4293

  
4294

  
4295
--
4296
-- Name: COLUMN analytical_plot.`relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4297
--
4298

  
4299

  
4300

  
4301

  
4302
--
4303
-- Name: COLUMN analytical_plot.`relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4304
--
4305

  
4306

  
4307

  
4308

  
4309
--
4310
-- Name: COLUMN analytical_plot.`taxonObservation[.id]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4311
--
4312

  
4313

  
4314

  
4315

  
4316
--
4317
-- Name: COLUMN analytical_plot.`taxonNameUsageConcept.authorCode__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4318
--
4319

  
4320

  
4321

  
4322

  
4323
--
4324
-- Name: COLUMN analytical_plot.`aggregateOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4325
--
4326

  
4327

  
4328

  
4329

  
4330
--
4331
-- Name: COLUMN analytical_plot.`individualOrganismObservation.id__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4332
--
4333

  
4334

  
4335

  
4336

  
4337
--
4338
-- Name: COLUMN analytical_plot.`individualID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4339
--
4340

  
4341

  
4342

  
4343

  
4344
--
4345
-- Name: COLUMN analytical_plot.`individualCount__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4346
--
4347

  
4348

  
4349

  
4350

  
4351
--
4352
-- Name: COLUMN analytical_plot.`stemCode__@VegBank__.stemLocation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4353
--
4354

  
4355

  
4356

  
4357

  
4358
--
3911 4359
-- Name: analytical_specimen; Type: VIEW; Schema: public; Owner: -
3912 4360
--
3913 4361

  
......
3915 4363

  
3916 4364

  
3917 4365
--
4366
-- Name: COLUMN analytical_specimen.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4367
--
4368

  
4369

  
4370

  
4371

  
4372
--
4373
-- Name: COLUMN analytical_specimen.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4374
--
4375

  
4376

  
4377

  
4378

  
4379
--
4380
-- Name: COLUMN analytical_specimen.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4381
--
4382

  
4383

  
4384

  
4385

  
4386
--
4387
-- Name: COLUMN analytical_specimen.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4388
--
4389

  
4390

  
4391

  
4392

  
4393
--
4394
-- Name: COLUMN analytical_specimen.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4395
--
4396

  
4397

  
4398

  
4399

  
4400
--
4401
-- Name: COLUMN analytical_specimen.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4402
--
4403

  
4404

  
4405

  
4406

  
4407
--
4408
-- Name: COLUMN analytical_specimen.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4409
--
4410

  
4411

  
4412

  
4413

  
4414
--
4415
-- Name: COLUMN analytical_specimen.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4416
--
4417

  
4418

  
4419

  
4420

  
4421
--
4422
-- Name: COLUMN analytical_specimen.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4423
--
4424

  
4425

  
4426

  
4427

  
4428
--
4429
-- Name: COLUMN analytical_specimen.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4430
--
4431

  
4432

  
4433

  
4434

  
4435
--
4436
-- Name: COLUMN analytical_specimen.geovalid_bien; Type: COMMENT; Schema: public; Owner: -
4437
--
4438

  
4439

  
4440

  
4441

  
4442
--
4443
-- Name: COLUMN analytical_specimen.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: -
4444
--
4445

  
4446

  
4447

  
4448

  
4449
--
4450
-- Name: COLUMN analytical_specimen.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -
4451
--
4452

  
4453

  
4454

  
4455

  
4456
--
4457
-- Name: COLUMN analytical_specimen.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4458
--
4459

  
4460

  
4461

  
4462

  
4463
--
4464
-- Name: COLUMN analytical_specimen.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4465
--
4466

  
4467

  
4468

  
4469

  
4470
--
4471
-- Name: COLUMN analytical_specimen.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4472
--
4473

  
4474

  
4475

  
4476

  
4477
--
4478
-- Name: COLUMN analytical_specimen.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4479
--
4480

  
4481

  
4482

  
4483

  
4484
--
4485
-- Name: COLUMN analytical_specimen.`[custodial_]institutionCode[s]__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4486
--
4487

  
4488

  
4489

  
4490

  
4491
--
4492
-- Name: COLUMN analytical_specimen.`collectionCode__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4493
--
4494

  
4495

  
4496

  
4497

  
4498
--
4499
-- Name: COLUMN analytical_specimen.`catalogNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4500
--
4501

  
4502

  
4503

  
4504

  
4505
--
4506
-- Name: COLUMN analytical_specimen.`occurrenceID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4507
--
4508

  
4509

  
4510

  
4511

  
4512
--
4513
-- Name: COLUMN analytical_specimen.`recordedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4514
--
4515

  
4516

  
4517

  
4518

  
4519
--
4520
-- Name: COLUMN analytical_specimen.`recordNumber__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4521
--
4522

  
4523

  
4524

  
4525

  
4526
--
4527
-- Name: COLUMN analytical_specimen.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4528
--
4529

  
4530

  
4531

  
4532

  
4533
--
4534
-- Name: COLUMN analytical_specimen.`[verbatim_]family__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4535
--
4536

  
4537

  
4538

  
4539

  
4540
--
4541
-- Name: COLUMN analytical_specimen.`[verbatim_]scientificName__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4542
--
4543

  
4544

  
4545

  
4546

  
4547
--
4548
-- Name: COLUMN analytical_specimen.`identifiedBy__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4549
--
4550

  
4551

  
4552

  
4553

  
4554
--
4555
-- Name: COLUMN analytical_specimen.`dateIdentified__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4556
--
4557

  
4558

  
4559

  
4560

  
4561
--
4562
-- Name: COLUMN analytical_specimen.`identificationRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4563
--
4564

  
4565

  
4566

  
4567

  
4568
--
4569
-- Name: COLUMN analytical_specimen.`Family_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4570
--
4571

  
4572

  
4573

  
4574

  
4575
--
4576
-- Name: COLUMN analytical_specimen.`Name_matched__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4577
--
4578

  
4579

  
4580

  
4581

  
4582
--
4583
-- Name: COLUMN analytical_specimen.`Name_matched_author__@TNRS__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4584
--
4585

  
4586

  
4587

  
4588

  
4589
--
4590
-- Name: COLUMN analytical_specimen.scrubbed_family; Type: COMMENT; Schema: public; Owner: -
4591
--
4592

  
4593

  
4594

  
4595

  
4596
--
4597
-- Name: COLUMN analytical_specimen.scrubbed_genus; Type: COMMENT; Schema: public; Owner: -
4598
--
4599

  
4600

  
4601

  
4602

  
4603
--
4604
-- Name: COLUMN analytical_specimen.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: -
4605
--
4606

  
4607

  
4608

  
4609

  
4610
--
4611
-- Name: COLUMN analytical_specimen.scrubbed_author; Type: COMMENT; Schema: public; Owner: -
4612
--
4613

  
4614

  
4615

  
4616

  
4617
--
4618
-- Name: COLUMN analytical_specimen.`[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4619
--
4620

  
4621

  
4622

  
4623

  
4624
--
4625
-- Name: COLUMN analytical_specimen.`reproductiveCondition__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4626
--
4627

  
4628

  
4629

  
4630

  
4631
--
4632
-- Name: COLUMN analytical_specimen.cultivated_bien; Type: COMMENT; Schema: public; Owner: -
4633
--
4634

  
4635

  
4636

  
4637

  
4638
--
4639
-- Name: COLUMN analytical_specimen.`cultivatedBasis_bien`; Type: COMMENT; Schema: public; Owner: -
4640
--
4641

  
4642

  
4643

  
4644

  
4645
--
4646
-- Name: COLUMN analytical_specimen.`occurrenceRemarks__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4647
--
4648

  
4649

  
4650

  
4651

  
4652
--
4653
-- Name: COLUMN analytical_specimen.`stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4654
--
4655

  
4656

  
4657

  
4658

  
4659
--
4660
-- Name: COLUMN analytical_specimen.`stemHeight[_m]__@VegBank__.stemCount@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4661
--
4662

  
4663

  
4664

  
4665

  
4666
--
4667
-- Name: COLUMN analytical_specimen.`[tag=]identificationLabel__@VegX__.individual@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
4668
--
4669

  
4670

  
4671

  
4672

  
4673
--
3918 4674
-- Name: analytical_stem_TAXONOBSERVATION_ID__@VegBank__.taxonObserv_seq; Type: SEQUENCE; Schema: public; Owner: -
3919 4675
--
3920 4676

  
......
4464 5220

  
4465 5221

  
4466 5222
--
5223
-- Name: COLUMN `plot.**`.`datasource__@Brad__.identifier_examples@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5224
--
5225

  
5226

  
5227

  
5228

  
5229
--
5230
-- Name: COLUMN `plot.**`.`country__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5231
--
5232

  
5233

  
5234

  
5235

  
5236
--
5237
-- Name: COLUMN `plot.**`.`stateProvince__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5238
--
5239

  
5240

  
5241

  
5242

  
5243
--
5244
-- Name: COLUMN `plot.**`.`county__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5245
--
5246

  
5247

  
5248

  
5249

  
5250
--
5251
-- Name: COLUMN `plot.**`.`locality__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5252
--
5253

  
5254

  
5255

  
5256

  
5257
--
5258
-- Name: COLUMN `plot.**`.`decimalLatitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5259
--
5260

  
5261

  
5262

  
5263

  
5264
--
5265
-- Name: COLUMN `plot.**`.`decimalLongitude__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5266
--
5267

  
5268

  
5269

  
5270

  
5271
--
5272
-- Name: COLUMN `plot.**`.`coordinateUncertaintyInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5273
--
5274

  
5275

  
5276

  
5277

  
5278
--
5279
-- Name: COLUMN `plot.**`.`georeferenceSources__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5280
--
5281

  
5282

  
5283

  
5284

  
5285
--
5286
-- Name: COLUMN `plot.**`.`georeferenceProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5287
--
5288

  
5289

  
5290

  
5291

  
5292
--
5293
-- Name: COLUMN `plot.**`.geovalid_bien; Type: COMMENT; Schema: public; Owner: -
5294
--
5295

  
5296

  
5297

  
5298

  
5299
--
5300
-- Name: COLUMN `plot.**`.`isNewWorld_bien`; Type: COMMENT; Schema: public; Owner: -
5301
--
5302

  
5303

  
5304

  
5305

  
5306
--
5307
-- Name: COLUMN `plot.**`.`projectID__@VegX__.plotObservation@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5308
--
5309

  
5310

  
5311

  
5312

  
5313
--
5314
-- Name: COLUMN `plot.**`.`projectContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5315
--
5316

  
5317

  
5318

  
5319

  
5320
--
5321
-- Name: COLUMN `plot.**`.`locationID__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5322
--
5323

  
5324

  
5325

  
5326

  
5327
--
5328
-- Name: COLUMN `plot.**`.`plotName__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5329
--
5330

  
5331

  
5332

  
5333

  
5334
--
5335
-- Name: COLUMN `plot.**`.`subplot__@SALVIAS__.Plot_data@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5336
--
5337

  
5338

  
5339

  
5340

  
5341
--
5342
-- Name: COLUMN `plot.**`.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -
5343
--
5344

  
5345

  
5346

  
5347

  
5348
--
5349
-- Name: COLUMN `plot.**`.`locationevent.locationevent_id__@VegBIEN__.public@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5350
--
5351

  
5352

  
5353

  
5354

  
5355
--
5356
-- Name: COLUMN `plot.**`.`eventDate__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5357
--
5358

  
5359

  
5360

  
5361

  
5362
--
5363
-- Name: COLUMN `plot.**`.`(-minimum-)ElevationInMeters__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5364
--
5365

  
5366

  
5367

  
5368

  
5369
--
5370
-- Name: COLUMN `plot.**`.`slopeAspect[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5371
--
5372

  
5373

  
5374

  
5375

  
5376
--
5377
-- Name: COLUMN `plot.**`.`slopeGradient[_deg]__@VegX__.plot@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5378
--
5379

  
5380

  
5381

  
5382

  
5383
--
5384
-- Name: COLUMN `plot.**`.`plot.area[_ha]__@VegX__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5385
--
5386

  
5387

  
5388

  
5389

  
5390
--
5391
-- Name: COLUMN `plot.**`.`samplingProtocol__@DwC__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5392
--
5393

  
5394

  
5395

  
5396

  
5397
--
5398
-- Name: COLUMN `plot.**`.`temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5399
--
5400

  
5401

  
5402

  
5403

  
5404
--
5405
-- Name: COLUMN `plot.**`.`precip_mm__@SALVIAS__.Plot_metadata@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5406
--
5407

  
5408

  
5409

  
5410

  
5411
--
5412
-- Name: COLUMN `plot.**`.`stratumName__@VegX__.stratum@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5413
--
5414

  
5415

  
5416

  
5417

  
5418
--
5419
-- Name: COLUMN `plot.**`.`communityConcept.name__@VegX__.communityDet@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5420
--
5421

  
5422

  
5423

  
5424

  
5425
--
5426
-- Name: COLUMN `plot.**`.`observationContributor[s]__@VegBank__@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
5427
--
5428

  
5429

  
5430

  
5431

  
5432
--
4467 5433
-- Name: sourcelist; Type: TABLE; Schema: public; Owner: -; Tablespace: 
4468 5434
--
4469 5435

  
......
5291 6257

  
5292 6258

  
5293 6259
--
6260
-- Name: COLUMN collected_dates.`(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org`; Type: COMMENT; Schema: public; Owner: -
6261
--
6262

  
6263

  
6264

  
6265

  
6266
--
5294 6267
-- Name: commclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 
5295 6268
--
5296 6269

  

Also available in: Unified diff