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. 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
~~~