CIAT-DAPA / cwr_gap-analysis-cwr

Automatically exported from code.google.com/p/gap-analysis-cwr
1 stars 0 forks source link

add 1 to data_public_access for FSU and GBIF #103

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
We missed this column in the original upload.  Please add a "1" to 
data_public_access for all records from FSU.  
please also query database for any blank records in this column and send 
summary of sources to CK/NP

Original issue reported on code.google.com by colin.kh...@gmail.com on 18 Oct 2012 at 7:24

GoogleCodeExporter commented 9 years ago
Please also add a "1" to this column for all data that came from GBIF!!!!  

Original comment by colin.kh...@gmail.com on 18 Oct 2012 at 7:26

GoogleCodeExporter commented 9 years ago

Original comment by htobon on 18 Oct 2012 at 1:25

GoogleCodeExporter commented 9 years ago
After previous steps, confirm all data has either a 0 or 1. send any null data 
(name of sources) to CK for correction

Original comment by colin.kh...@gmail.com on 19 Oct 2012 at 1:43

GoogleCodeExporter commented 9 years ago
data_public_access = 1 for all records from FSU.
all data from GBIF data_public_access = 1.
I sent a email with null data information

Original comment by alexgcv@gmail.com on 19 Oct 2012 at 6:18

GoogleCodeExporter commented 9 years ago
GBIF and "data_public_access"-  assign all GBIF records to "1" in 
"data_public_access".

Original comment by colin.kh...@gmail.com on 25 Oct 2012 at 4:40

GoogleCodeExporter commented 9 years ago
-----------------------------+--------------------+----------+
| provider_institute_id                                                         
                             | data_public_access | count(*) |
+-------------------------------------------------------------------------------
-----------------------------+--------------------+----------+
| ABCIC                                                                         
                             |                  1 |      592 |
| ASAU Armenia                                                                  
                             |                  1 |       11 |
| ATGGC                                                                         
                             |                  1 |    41860 |
| AVH                                                                           
                             |                  1 |   104839 |
| AVRDC                                                                         
                             |                  1 |    52296 |
| BHAM_Maxted                                                                   
                             |               NULL |      431 |
| BHAM_Maxted                                                                   
                             |                  0 |   159821 |
| BHAM_Maxted                                                                   
                             |                  1 |    60187 |
| Bioversity                                                                    
                             |                  0 |      231 |
| Bioversity                                                                    
                             |                  1 |  1248927 |
| BM                                                                            
                             |                  0 |     2323 |
| BM                                                                            
                             |                  1 |     2191 |
| Brehm                                                                         
                             |                  1 |      463 |
| BRLU                                                                          
                             |                  1 |      262 |
| CAL                                                                           
                             |                  1 |        5 |
| CAS                                                                           
                             |                  0 |       33 |
| CAS                                                                           
                             |                  1 |    11505 |
| CIAT                                                                          
                             |                  1 |    43531 |
| CIAT_Hijmans                                                                  
                             |                  1 |     9822 |
| CIP                                                                           
                             |                  1 |      336 |
| COI                                                                           
                             |                  1 |      236 |
| COL                                                                           
                             |                  1 |      229 |
| CONABIO                                                                       
                             |                  1 |     1126 |
| CPNWH                                                                         
                             |                  1 |   133668 |
| CRIA                                                                          
                             |                  1 |     8723 |
| CTES                                                                          
                             |                  1 |        1 |
| CUVC                                                                          
                             |                  1 |      414 |
| DAFF                                                                          
                             |                  1 |       24 |
| E                                                                             
                             |                  1 |    15322 |
| F                                                                             
                             |                  1 |    13272 |
| FSU                                                                           
                             |                  1 |     4611 |
| GBIF                                                                          
                             |                  1 |  1690038 |
| GUA                                                                           
                             |                  1 |     2930 |
| Herbathome                                                                    
                             |                  1 |     5732 |
| HUH                                                                           
                             |                  1 |    18737 |
| ICCI                                                                          
                             |                  0 |    20102 |
| ICCI                                                                          
                             |                  1 |        6 |
| IITA                                                                          
                             |                  1 |     5780 |
| ILRI                                                                          
                             |                  1 |    16383 |
| IRRI                                                                          
                             |                  1 |     4144 |
| JABOT                                                                         
                             |                  1 |    18749 |
| K                                                                             
                             |                  0 |      764 |
| K                                                                             
                             |                  1 |    24194 |
| Kew_MSB                                                                       
                             |                  0 |     1664 |
| Kew_MSB                                                                       
                             |                  1 |     2164 |
| KHD                                                                           
                             |                  1 |     2139 |
| L                                                                             
                             |                  0 |       61 |
| L                                                                             
                             |                  1 |      378 |
| LAC-biosafety                                                                 
                             |                  1 |     3222 |
| LE                                                                            
                             |                  1 |      963 |
| LISC                                                                          
                             |                  1 |      869 |
| LISI                                                                          
                             |                  1 |     4494 |
| LISU                                                                          
                             |                  1 |     1563 |
| MA                                                                            
                             |                  1 |    41034 |
| MANCH                                                                         
                             |                  1 |     8716 |
| MHA                                                                           
                             |                  1 |     1237 |
| MO                                                                            
                             |                  1 |     1322 |
| MW                                                                            
                             |                  1 |      444 |
| NHN_L                                                                         
                             |                  1 |    68030 |
| NY                                                                            
                             |                  1 |    68336 |
| P                                                                             
                             |                  1 |    13681 |
| PBI_NHM                                                                       
                             |                  0 |     8867 |
| PBI_NHM                                                                       
                             |                  1 |        2 |
| PGRC                                                                          
                             |                  1 |    24829 |
| PH                                                                            
                             |                  1 |     4994 |
| PH ANSP                                                                       
                             |                  1 |      282 |
| PlantsofTaiwan                                                                
                             |                  1 |    10241 |
| Röpert, D. (Ed.) 2000 - (continuously updated): Digital specimen images at 
the Herbarium Berolinense (B).  |               NULL |       93 |
| U                                                                             
                             |                  1 |       39 |
| UBC                                                                           
                             |                  1 |      506 |
| UC                                                                            
                             |                  1 |      283 |
| UCR                                                                           
                             |                  1 |    21047 |
| UC_JEPS                                                                       
                             |                  1 |   125497 |
| UniCur_IPK                                                                    
                             |                  0 |     4890 |
| UniCur_IPK                                                                    
                             |                  1 |        2 |
| UNL_Neves                                                                     
                             |                  1 |       33 |
| US                                                                            
                             |                  1 |    27084 |
| USDA                                                                          
                             |                  1 |      380 |
| USDA_NPGS                                                                     
                             |                  0 |       24 |
| USDA_NPGS                                                                     
                             |                  1 |    85386 |
| USDA_NPGS_GRIN                                                                
                             |                  1 |   398331 |
| USDA_Spooner                                                                  
                             |                  0 |     9682 |
| USDA_SPOONER                                                                  
                             |                  1 |     3485 |
| UW_Tewksbury                                                                  
                             |                  1 |       45 |
| WAG                                                                           
                             |                  1 |     1020 |
| Wang2012                                                                      
                             |                  1 |       91 |
| WBDC                                                                          
                             |                  1 |      313 |
| WVU                                                                           
                             |                  1 |     6348 |
+-------------------------------------------------------------------------------

Original comment by alexgcv@gmail.com on 25 Oct 2012 at 8:09

GoogleCodeExporter commented 9 years ago
Röpert, D. (Ed.) 2000 - (continuously updated): Digital specimen images at 
the Herbarium Berolinense (B).   should be reassigned to GBIF (some process as 
others Alex did yesterday)

Original comment by colin.kh...@gmail.com on 26 Oct 2012 at 3:01

GoogleCodeExporter commented 9 years ago

Original comment by colin.kh...@gmail.com on 26 Oct 2012 at 3:01

GoogleCodeExporter commented 9 years ago
favor mandar a CK unos records (todos campos) de provider_institute_id = USDA, 
UC, U, CAL, CTES, CIO, y COL    (tengo la duda que estos tambien son de GBIF 
pero no puedo saber sin ver los datos). 

Original comment by colin.kh...@gmail.com on 26 Oct 2012 at 4:02

GoogleCodeExporter commented 9 years ago
Please remember also in the separate GBIF_non priority data to make 
provider_institute_id = GBIF and whatever is in that field place in 
institute_name.  And make all data_public_access = "1"

Original comment by colin.kh...@gmail.com on 26 Oct 2012 at 6:38

GoogleCodeExporter commented 9 years ago
done,

provider_institute_id   institute_name  data_public_access  count(*)
GBIF                null            1                       1090000

Original comment by alexgcv@gmail.com on 2 Nov 2012 at 1:54

GoogleCodeExporter commented 9 years ago

Original comment by colin.kh...@gmail.com on 5 Nov 2012 at 8:20