Project

General

Profile

« Previous | Next » 

Revision 14431

Added by Aaron Marcuse-Kubitza over 10 years ago

inputs/.TNRS/schema.sql: removed no longer used view MatchedTaxon. use taxon_best_match instead.

View differences:

trunk/inputs/.TNRS/schema.sql
1419 1419 

  		




  1420
  1420
  
    

  		




  1421
  1421
  
    
--


  		




  1422
  
  
    
-- Name: MatchedTaxon; Type: VIEW; Schema: TNRS; Owner: -


  		




  1423
  
  
    
--


  		




  1424
  
  
    

  		




  1425
  
  
    
CREATE VIEW "MatchedTaxon" AS


  		




  1426
  
  
    
 SELECT taxon_best_match.batch,


  		




  1427
  
  
    
    taxon_best_match.match_num,


  		




  1428
  
  
    
    taxon_best_match."*Name_number",


  		




  1429
  
  
    
    taxon_best_match."*Name_submitted",


  		




  1430
  
  
    
    taxon_best_match."*Overall_score",


  		




  1431
  
  
    
    taxon_best_match."*Name_matched",


  		




  1432
  
  
    
    taxon_best_match."*Name_matched_rank",


  		




  1433
  
  
    
    taxon_best_match."*Name_score",


  		




  1434
  
  
    
    taxon_best_match."*Name_matched_author",


  		




  1435
  
  
    
    taxon_best_match."*Name_matched_url",


  		




  1436
  
  
    
    taxon_best_match."*Author_matched",


  		




  1437
  
  
    
    taxon_best_match."*Author_score",


  		




  1438
  
  
    
    taxon_best_match."*Family_matched",


  		




  1439
  
  
    
    taxon_best_match."*Family_score",


  		




  1440
  
  
    
    taxon_best_match."*Name_matched_accepted_family",


  		




  1441
  
  
    
    taxon_best_match."*Genus_matched",


  		




  1442
  
  
    
    taxon_best_match."*Genus_score",


  		




  1443
  
  
    
    taxon_best_match."*Specific_epithet_matched",


  		




  1444
  
  
    
    taxon_best_match."*Specific_epithet_score",


  		




  1445
  
  
    
    taxon_best_match."*Infraspecific_rank",


  		




  1446
  
  
    
    taxon_best_match."*Infraspecific_epithet_matched",


  		




  1447
  
  
    
    taxon_best_match."*Infraspecific_epithet_score",


  		




  1448
  
  
    
    taxon_best_match."*Infraspecific_rank_2",


  		




  1449
  
  
    
    taxon_best_match."*Infraspecific_epithet_2_matched",


  		




  1450
  
  
    
    taxon_best_match."*Infraspecific_epithet_2_score",


  		




  1451
  
  
    
    taxon_best_match."*Annotations",


  		




  1452
  
  
    
    taxon_best_match."*Unmatched_terms",


  		




  1453
  
  
    
    taxon_best_match."*Taxonomic_status",


  		




  1454
  
  
    
    taxon_best_match."*Accepted_name",


  		




  1455
  
  
    
    taxon_best_match."*Accepted_name_author",


  		




  1456
  
  
    
    taxon_best_match."*Accepted_name_rank",


  		




  1457
  
  
    
    taxon_best_match."*Accepted_name_url",


  		




  1458
  
  
    
    taxon_best_match."*Accepted_name_species",


  		




  1459
  
  
    
    taxon_best_match."*Accepted_name_family",


  		




  1460
  
  
    
    taxon_best_match."*Selected",


  		




  1461
  
  
    
    taxon_best_match."*Source",


  		




  1462
  
  
    
    taxon_best_match."*Warnings",


  		




  1463
  
  
    
    taxon_best_match."*Accepted_name_lsid",


  		




  1464
  
  
    
    taxon_best_match.is_valid_match,


  		




  1465
  
  
    
    taxon_best_match.scrubbed_unique_taxon_name,


  		




  1466
  
  
    
    taxon_best_match."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org",


  		




  1467
  
  
    
    taxon_best_match."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org",


  		




  1468
  
  
    
    taxon_best_match."matched~Name[_no_author]___@TNRS__@vegpath.org",


  		




  1469
  
  
    
    taxon_best_match."[matched_]scientificName[_with_author]__@DwC__@vegpath.org",


  		




  1470
  
  
    
    taxon_best_match.matched_has_accepted,


  		




  1471
  
  
    
    taxon_best_match."Accepted_family__@TNRS__@vegpath.org",


  		




  1472
  
  
    
    taxon_best_match."Accepted_species[_binomial]__@TNRS__@vegpath.org",


  		




  1473
  
  
    
    taxon_best_match."__accepted_{genus,specific_epithet,infra_{rank,epithet}}",


  		




  1474
  
  
    
    taxon_best_match."[accepted_]genus__@DwC__@vegpath.org",


  		




  1475
  
  
    
    taxon_best_match."[accepted_]specificEpithet__@DwC__@vegpath.org",


  		




  1476
  
  
    
    taxon_best_match."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",


  		




  1477
  
  
    
    taxon_best_match."__accepted_infraspecific_{rank,epithet}",


  		




  1478
  
  
    
    taxon_best_match."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",


  		




  1479
  
  
    
    taxon_best_match."[accepted_]infraspecificEpithet__@DwC__@vegpath.org",


  		




  1480
  
  
    
    taxon_best_match."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org",


  		




  1481
  
  
    
    taxon_best_match."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org",


  		




  1482
  
  
    
    taxon_best_match."[scrubbed_]taxonRank__@DwC__@vegpath.org",


  		




  1483
  
  
    
    taxon_best_match."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org",


  		




  1484
  
  
    
    taxon_best_match."[scrubbed_]genus__@DwC__@vegpath.org",


  		




  1485
  
  
    
    taxon_best_match."[scrubbed_]specificEpithet__@DwC__@vegpath.org",


  		




  1486
  
  
    
    taxon_best_match."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org",


  		




  1487
  
  
    
    taxon_best_match."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",


  		




  1488
  
  
    
    taxon_best_match."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",


  		




  1489
  
  
    
    taxon_best_match."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org",


  		




  1490
  
  
    
    taxon_best_match."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org",


  		




  1491
  
  
    
    taxon_best_match."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org",


  		




  1492
  
  
    
    taxon_best_match."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org"


  		




  1493
  
  
    
   FROM taxon_best_match;


  		




  1494
  
  
    

  		




  1495
  
  
    

  		




  1496
  
  
    
--


  		




  1497
  
  
    
-- Name: VIEW "MatchedTaxon"; Type: COMMENT; Schema: TNRS; Owner: -


  		




  1498
  
  
    
--


  		




  1499
  
  
    

  		




  1500
  
  
    
COMMENT ON VIEW "MatchedTaxon" IS '


  		




  1501
  
  
    
to modify:


  		




  1502
  
  
    
SELECT util.recreate_view(''"TNRS"."MatchedTaxon"'', $$


  		




  1503
  
  
    
SELECT __


  		




  1504
  
  
    
$$);


  		




  1505
  
  
    
';


  		




  1506
  
  
    

  		




  1507
  
  
    

  		




  1508
  
  
    
--


  		




  1509
  1422
  
    
-- Name: ValidMatchedTaxon; Type: VIEW; Schema: TNRS; Owner: -


  		




  1510
  1423
  
    
--


  		




  1511
  1424
  
    

  		




  ......




  2063
  1976
  
    

  		




  2064
  1977
  
    

  		




  2065
  1978
  
    
--


  		




  2066
  
  
    
-- Name: MatchedTaxon; Type: ACL; Schema: TNRS; Owner: -


  		




  2067
  
  
    
--


  		




  2068
  
  
    

  		




  2069
  
  
    
REVOKE ALL ON TABLE "MatchedTaxon" FROM PUBLIC;


  		




  2070
  
  
    
REVOKE ALL ON TABLE "MatchedTaxon" FROM bien;


  		




  2071
  
  
    
GRANT ALL ON TABLE "MatchedTaxon" TO bien;


  		




  2072
  
  
    
GRANT SELECT ON TABLE "MatchedTaxon" TO bien_read;


  		




  2073
  
  
    

  		




  2074
  
  
    

  		




  2075
  
  
    
--


  		




  2076
  1979
  
    
-- Name: ValidMatchedTaxon; Type: ACL; Schema: TNRS; Owner: -


  		




  2077
  1980
  
    
--


  		




  2078
  1981
  
    

  		












  

    
      trunk/schemas/vegbien.my.sql
    
  





  16302
  16302
  
    

  		




  16303
  16303
  
    

  		




  16304
  16304
  
    
--


  		




  16305
  
  
    
-- Name: MatchedTaxon; Type: VIEW; Schema: TNRS; Owner: -


  		




  16306
  
  
    
--


  		




  16307
  
  
    

  		




  16308
  
  
    

  		




  16309
  
  
    

  		




  16310
  
  
    

  		




  16311
  
  
    
--


  		




  16312
  
  
    
-- Name: VIEW `MatchedTaxon`; Type: COMMENT; Schema: TNRS; Owner: -


  		




  16313
  
  
    
--


  		




  16314
  
  
    

  		




  16315
  
  
    

  		




  16316
  
  
    

  		




  16317
  
  
    

  		




  16318
  
  
    
--


  		




  16319
  16305
  
    
-- Name: ValidMatchedTaxon; Type: VIEW; Schema: TNRS; Owner: -


  		




  16320
  16306
  
    
--


  		




  16321
  16307
  
    

  		




  ......




  16717
  16703
  
    

  		




  16718
  16704
  
    

  		




  16719
  16705
  
    
--


  		




  16720
  
  
    
-- Name: MatchedTaxon; Type: ACL; Schema: TNRS; Owner: -


  		




  16721
  
  
    
--


  		




  16722
  
  
    

  		




  16723
  
  
    

  		




  16724
  
  
    

  		




  16725
  
  
    

  		




  16726
  
  
    

  		




  16727
  
  
    

  		




  16728
  
  
    

  		




  16729
  
  
    
--


  		




  16730
  16706
  
    
-- Name: ValidMatchedTaxon; Type: ACL; Schema: TNRS; Owner: -


  		




  16731
  16707
  
    
--


  		




  16732
  16708
  
    

  		












  

    
      trunk/schemas/vegbien.sql
    
  





  21341
  21341
  
    

  		




  21342
  21342
  
    

  		




  21343
  21343
  
    
--


  		




  21344
  
  
    
-- Name: MatchedTaxon; Type: VIEW; Schema: TNRS; Owner: -


  		




  21345
  
  
    
--


  		




  21346
  
  
    

  		




  21347
  
  
    
CREATE VIEW "MatchedTaxon" AS


  		




  21348
  
  
    
 SELECT taxon_best_match.batch,


  		




  21349
  
  
    
    taxon_best_match.match_num,


  		




  21350
  
  
    
    taxon_best_match."*Name_number",


  		




  21351
  
  
    
    taxon_best_match."*Name_submitted",


  		




  21352
  
  
    
    taxon_best_match."*Overall_score",


  		




  21353
  
  
    
    taxon_best_match."*Name_matched",


  		




  21354
  
  
    
    taxon_best_match."*Name_matched_rank",


  		




  21355
  
  
    
    taxon_best_match."*Name_score",


  		




  21356
  
  
    
    taxon_best_match."*Name_matched_author",


  		




  21357
  
  
    
    taxon_best_match."*Name_matched_url",


  		




  21358
  
  
    
    taxon_best_match."*Author_matched",


  		




  21359
  
  
    
    taxon_best_match."*Author_score",


  		




  21360
  
  
    
    taxon_best_match."*Family_matched",


  		




  21361
  
  
    
    taxon_best_match."*Family_score",


  		




  21362
  
  
    
    taxon_best_match."*Name_matched_accepted_family",


  		




  21363
  
  
    
    taxon_best_match."*Genus_matched",


  		




  21364
  
  
    
    taxon_best_match."*Genus_score",


  		




  21365
  
  
    
    taxon_best_match."*Specific_epithet_matched",


  		




  21366
  
  
    
    taxon_best_match."*Specific_epithet_score",


  		




  21367
  
  
    
    taxon_best_match."*Infraspecific_rank",


  		




  21368
  
  
    
    taxon_best_match."*Infraspecific_epithet_matched",


  		




  21369
  
  
    
    taxon_best_match."*Infraspecific_epithet_score",


  		




  21370
  
  
    
    taxon_best_match."*Infraspecific_rank_2",


  		




  21371
  
  
    
    taxon_best_match."*Infraspecific_epithet_2_matched",


  		




  21372
  
  
    
    taxon_best_match."*Infraspecific_epithet_2_score",


  		




  21373
  
  
    
    taxon_best_match."*Annotations",


  		




  21374
  
  
    
    taxon_best_match."*Unmatched_terms",


  		




  21375
  
  
    
    taxon_best_match."*Taxonomic_status",


  		




  21376
  
  
    
    taxon_best_match."*Accepted_name",


  		




  21377
  
  
    
    taxon_best_match."*Accepted_name_author",


  		




  21378
  
  
    
    taxon_best_match."*Accepted_name_rank",


  		




  21379
  
  
    
    taxon_best_match."*Accepted_name_url",


  		




  21380
  
  
    
    taxon_best_match."*Accepted_name_species",


  		




  21381
  
  
    
    taxon_best_match."*Accepted_name_family",


  		




  21382
  
  
    
    taxon_best_match."*Selected",


  		




  21383
  
  
    
    taxon_best_match."*Source",


  		




  21384
  
  
    
    taxon_best_match."*Warnings",


  		




  21385
  
  
    
    taxon_best_match."*Accepted_name_lsid",


  		




  21386
  
  
    
    taxon_best_match.is_valid_match,


  		




  21387
  
  
    
    taxon_best_match.scrubbed_unique_taxon_name,


  		




  21388
  
  
    
    taxon_best_match."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org",


  		




  21389
  
  
    
    taxon_best_match."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org",


  		




  21390
  
  
    
    taxon_best_match."matched~Name[_no_author]___@TNRS__@vegpath.org",


  		




  21391
  
  
    
    taxon_best_match."[matched_]scientificName[_with_author]__@DwC__@vegpath.org",


  		




  21392
  
  
    
    taxon_best_match.matched_has_accepted,


  		




  21393
  
  
    
    taxon_best_match."Accepted_family__@TNRS__@vegpath.org",


  		




  21394
  
  
    
    taxon_best_match."Accepted_species[_binomial]__@TNRS__@vegpath.org",


  		




  21395
  
  
    
    taxon_best_match."__accepted_{genus,specific_epithet,infra_{rank,epithet}}",


  		




  21396
  
  
    
    taxon_best_match."[accepted_]genus__@DwC__@vegpath.org",


  		




  21397
  
  
    
    taxon_best_match."[accepted_]specificEpithet__@DwC__@vegpath.org",


  		




  21398
  
  
    
    taxon_best_match."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",


  		




  21399
  
  
    
    taxon_best_match."__accepted_infraspecific_{rank,epithet}",


  		




  21400
  
  
    
    taxon_best_match."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",


  		




  21401
  
  
    
    taxon_best_match."[accepted_]infraspecificEpithet__@DwC__@vegpath.org",


  		




  21402
  
  
    
    taxon_best_match."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org",


  		




  21403
  
  
    
    taxon_best_match."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org",


  		




  21404
  
  
    
    taxon_best_match."[scrubbed_]taxonRank__@DwC__@vegpath.org",


  		




  21405
  
  
    
    taxon_best_match."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org",


  		




  21406
  
  
    
    taxon_best_match."[scrubbed_]genus__@DwC__@vegpath.org",


  		




  21407
  
  
    
    taxon_best_match."[scrubbed_]specificEpithet__@DwC__@vegpath.org",


  		




  21408
  
  
    
    taxon_best_match."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org",


  		




  21409
  
  
    
    taxon_best_match."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",


  		




  21410
  
  
    
    taxon_best_match."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",


  		




  21411
  
  
    
    taxon_best_match."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org",


  		




  21412
  
  
    
    taxon_best_match."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org",


  		




  21413
  
  
    
    taxon_best_match."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org",


  		




  21414
  
  
    
    taxon_best_match."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org"


  		




  21415
  
  
    
   FROM taxon_best_match;


  		




  21416
  
  
    

  		




  21417
  
  
    

  		




  21418
  
  
    
--


  		




  21419
  
  
    
-- Name: VIEW "MatchedTaxon"; Type: COMMENT; Schema: TNRS; Owner: -


  		




  21420
  
  
    
--


  		




  21421
  
  
    

  		




  21422
  
  
    
COMMENT ON VIEW "MatchedTaxon" IS '


  		




  21423
  
  
    
to modify:


  		




  21424
  
  
    
SELECT util.recreate_view(''"TNRS"."MatchedTaxon"'', $$


  		




  21425
  
  
    
SELECT __


  		




  21426
  
  
    
$$);


  		




  21427
  
  
    
';


  		




  21428
  
  
    

  		




  21429
  
  
    

  		




  21430
  
  
    
--


  		




  21431
  21344
  
    
-- Name: ValidMatchedTaxon; Type: VIEW; Schema: TNRS; Owner: -


  		




  21432
  21345
  
    
--


  		




  21433
  21346
  
    

  		




  ......




  22062
  21975
  
    

  		




  22063
  21976
  
    

  		




  22064
  21977
  
    
--


  		




  22065
  
  
    
-- Name: MatchedTaxon; Type: ACL; Schema: TNRS; Owner: -


  		




  22066
  
  
    
--


  		




  22067
  
  
    

  		




  22068
  
  
    
REVOKE ALL ON TABLE "MatchedTaxon" FROM PUBLIC;


  		




  22069
  
  
    
REVOKE ALL ON TABLE "MatchedTaxon" FROM bien;


  		




  22070
  
  
    
GRANT ALL ON TABLE "MatchedTaxon" TO bien;


  		




  22071
  
  
    
GRANT SELECT ON TABLE "MatchedTaxon" TO bien_read;


  		




  22072
  
  
    

  		




  22073
  
  
    

  		




  22074
  
  
    
--


  		




  22075
  21978
  
    
-- Name: ValidMatchedTaxon; Type: ACL; Schema: TNRS; Owner: -


  		




  22076
  21979
  
    
--


  		




  22077
  21980
  
    

  		












Also available in:  Unified diff