Project

General

Profile

bug #7786

Updated by Andreas Müller over 5 years ago

Some of them only have a trailing whitespace problem and can be found by  

 ~~~ 
 SELECT * 
 FROM emOccurrenceSource 
 WHERE SourceNumber    like '% %' 
 ~~~ 

 remove whitespaces 

 ==== 

 for others the sourceNumber can not be found in Referenc.IdInSource 



 ~~~ 
 bei den OccurrenceSources sind ein paar kaputt gegangen, vermutlich weil die Identifier hier nicht als Zahlen sondern als Text gespeichert werden, aus welchem Grund auch immer. 

 Ich versuche das gerade zu säubern. Gehe ich daher Recht in der Annahme, dass  

 • 	 Die 2. Quelle von Polygonum propinquum Ledeb.    In Rf(E)        „ Tzvelev, N. N. - Konspekt flory Vostochnoi Evropy 1 2012.“ ist, genauso wie für Rf(C), Rf(S)    und Uk(K) ? 
 • 	 Entsprechend von Persicaria lapathifolia subsp. brittingeri (Opiz) Soják    für Rf(C)    / SourceNumber = 22016 


 Außerdem: Welches ist die Quelle von 

 • 	 Bromus scoparius L.    in Ge – SourceNumber 132003 nicht gefunden  
 • 	 Fallopia dumetorum (L.) Holub in Rf(C)     - SourceNumber = 12231 nicht gefunden, 122311, 122312, 122315 für andere Common Names vorhanden 
 • 	 Von Solanum sinaicum in Ir -> SourceNumber = 13042 . Vielleicht    Danin, A. - Wild plants of Eretz Israel and their distribution 1998. ? / 130421, gibt aber auch andere 13042x 
 • 	 Turnera ulmifolia L. , alle Areas außer Ca(T), Ca(F);    / SourceNumber = 71575 
 • 	 Evtl. selbe Source für Consolida ajacis (L.) Schur    für Ca(P) , Ca(H) / SourceNumber=    71575 
 • 	 Rumex conglomeratus Murray für It    (2x)    / SourceNumber =     0087    und = 7   
 • 	 Ceratochloa cathartica (Vahl) Herter    für Cr / SourceNumber = 130017 
 • 	 Vitis rupestris Scheele und Vitis labrusca L. für Hu    / SourceNumber = 5 
 • 	 Juncus tingitanus Maire & Weiller für Ma / SourceNumber = 28024 
 • 	 Reynoutria japonica Houtt. für Lt    / SourceNumber = 12206 , evtl. Tzvelev, N. N. - Flora of Russia. The European part and bordering regions 9 2006. ?? / 122016 


 Nicht notwendig vermutlich 
 • 	 Ammannia pubiflora (Koehne) Sosn. In EM / SourceNumber = 130432 
 ~~~ 

 ~~~ 
 SELECT          n.FullNameCache, ar.EMCode, n.NameCache, oc.PTRefFk, ocs.Source, ocs.SourceNumber, ocs.OccurrenceSourceId, oc.OccurrenceId, oc.PTNameFk, oc.PTRefFk AS Expr1, oc.AreaFk, oc.StatusUnknown,  
                          oc.Native, oc.Introduced, oc.Cultivated, oc.WorldDistCompl, oc.SummaryStatus, oc.CalculatedFlag, oc.PTDesignationRefDetailFk, oc.PTDesignationRefFk, oc.Preferred, oc.UnresolvedPOSS, oc.As_Taxon,  
                          oc.Sources, oc.Created_When, oc.Created_Who, oc.Updated_When, oc.Updated_Who, oc.Notes, oc.Occurrence, oc.NativeStatus, oc.IntroducedStatus, oc.CultivatedStatus, oc._oldOccId 
 FROM              emOccurrence AS oc INNER JOIN 
                          emOccurrenceSource AS ocs ON ocs.OccurrenceFk = oc.OccurrenceId INNER JOIN 
                          Name AS n ON n.NameId = oc.PTNameFk LEFT OUTER JOIN 
                          emArea AS ar ON ar.AreaId = oc.AreaFk 
 WHERE          (ocs.SourceNumber LIKE '57610') OR 
                         
                          (oc.PTNameFk IN (0)) 
 ORDER BY ocs.SourceNumber 
 ~~~ 


 Dann gibt es noch: 

 ~~~ 

 Juncus acutiflorus Hoffm. 
 Juncus acutus L. 
 Juncus anceps Laharpe 
 Juncus articulatus L. 
 Juncus bufonius L. 
 Juncus bulbosus L. 
 Juncus compressus Jacq. 
 Juncus foliosus Desf. 
 Juncus gerardi Loisel. 
 Juncus heterophyllus Dufour 
 Juncus conglomeratus L. 
 Juncus effusus L. 
 Juncus maritimus Lam. 
 Juncus pygmaeus Thuill. 
 Juncus squarrosus L. 
 Juncus striatus E. Mey. 
 Juncus subulatus Forssk. 
 Juncus tenageia L. f. 
 Juncus tingitanus Maire & Weiller  

 Alle für Area Ma / SourceNumber = 57610 

 Und: 

 FullNameCache 	 EMCode 
 Arum creticum Boiss. & Heldr. 	 Cr         
 Arum elongatum Steven 	 Tu(A) 
 Arum elongatum Steven 	 Bu         
 Arum cyrenaicum Hruby 	 Li 
 Arum balansanum R. R. Mill 	 Tu(A) 
 Arum dioscoridis Sm. 	 Tu(A) 
 Arum dioscoridis Sm. 	 Cy 
 Arum creticum Boiss. & Heldr. 	 AE(G)      
 Arum cyrenaicum Hruby 	 Cr         
 Arum dioscoridis Sm. 	 AE(G)      
 Arum creticum Boiss. & Heldr. 	 Tu(A) 
 Arum apulum (Carano) P. C. Boyce 	 It         
 Arum concinnatum Schott 	 Gr         
 Arum concinnatum Schott 	 AE(G)      
 Arum concinnatum Schott 	 Cr         
 Arum elongatum Steven 	 Gr         
 Arum dioscoridis Sm. 	 Ir 
 Arum besserianum Schott 	 Uk(U)      
 Arum concinnatum Schott 	 Tu(A) 
 Arum dioscoridis Sm. 	 Le 
 Arum dioscoridis Sm. 	 Sy    

 Alle für SourceNumber = 71748 
 ~~~ 

 Diese IdInSource gibt es. => Zu SourceNumber2Ref hinzugefügt => Testen obs jetzt tut Vielleicht liegt es am publish flag? 



 Sources mit leerer SourceNumber: 76 

 ~~~ 
 SELECT          n.FullNameCache, ar.EMCode, n.NameCache, oc.PTRefFk, ocs.Source, ocs.SourceNumber, ocs.OccurrenceSourceId, oc.OccurrenceId, oc.PTNameFk, oc.PTRefFk AS Expr1, oc.AreaFk, oc.StatusUnknown,  
                          oc.Native, oc.Introduced, oc.Cultivated, oc.WorldDistCompl, oc.SummaryStatus, oc.CalculatedFlag, oc.PTDesignationRefDetailFk, oc.PTDesignationRefFk, oc.Preferred, oc.UnresolvedPOSS, oc.As_Taxon,  
                          oc.Sources, oc.Created_When, oc.Created_Who, oc.Updated_When, oc.Updated_Who, oc.Notes, oc.Occurrence, oc.NativeStatus, oc.IntroducedStatus, oc.CultivatedStatus, oc._oldOccId 
 FROM              emOccurrence AS oc INNER JOIN 
                          emOccurrenceSource AS ocs ON ocs.OccurrenceFk = oc.OccurrenceId INNER JOIN 
                          Name AS n ON n.NameId = oc.PTNameFk LEFT OUTER JOIN 
                          emArea AS ar ON ar.AreaId = oc.AreaFk 
 WHERE          (ocs.SourceNumber LIKE '') AND occurrenceFk IN ( SELECT occurrenceId FROM v_cdm_exp_occurrenceAll ) 
 ORDER BY PTRefFk, FullNameCache, ocs.SourceNumber 
 ~~~

Back