Connect to common EcoTaxa tables

tbl_ecotaxa(db)

Arguments

db	a connection to an EcoTaxa database (from `db_connect_ecotaxa()`).

Value

The function returns nothing but creates objects in the global environment that are connections to tables through the dplyr::tbl() function.

Examples

db <- db_connect_ecotaxa()
ls()
#> [1] "db"
tbl_ecotaxa(db)
ls()
#> [1] "db"
head(projects)
#> # Source:   lazy query [?? x 21]
#> # Database: postgres 11.0.10 [zoo@ecotaxa.obs-vlfr.fr:5432/ecotaxa]
#>   projid title visible status mappingobj mappingsample mappingacq mappingprocess
#>    <int> <chr> <lgl>   <chr>  <chr>      <chr>         <chr>      <chr>         
#> 1   2231 Z3_2… TRUE    Annot… "n01=area… "t01=profile… "t01=sn\n… "t01=software…
#> 2   3385 tera… TRUE    Annot… "n01=lat_… "t01=scan_op… "t01=min_… "t01=date\nt0…
#> 3     41 UVP5… TRUE    Annot… "n01=area… "t01=profile… "t01=sn\n… "t01=software…
#> 4   3447 uvp5… TRUE    Annot…  NA         NA            NA         NA           
#> 5   2151 MBA_… TRUE    Annot…  NA         NA            NA         NA           
#> 6   3608 Urba… TRUE    Annot… ""         ""            ""         ""            
#> # … with 13 more variables: objcount <dbl>, pctvalidated <dbl>,
#> #   pctclassified <dbl>, classifsettings <chr>, initclassiflist <chr>,
#> #   classiffieldlist <chr>, popoverfieldlist <chr>, comments <chr>,
#> #   projtype <chr>, fileloaded <chr>, cnn_network_id <chr>,
#> #   rf_models_used <chr>, license <chr>