Revision c436b453
Added by Andreas Müller over 5 years ago
| app-import/src/main/java/eu/etaxonomy/cdm/io/berlinModel/in/BerlinModelOccurrenceImport.java | ||
|---|---|---|
| 81 | 81 |
String emCode = config.isIncludesAreaEmCode()? ", ar.EMCode" : ""; |
| 82 | 82 |
String strQuery = //DISTINCT because otherwise emOccurrenceSource creates multiple records for a single distribution |
| 83 | 83 |
" SELECT DISTINCT pt.RIdentifier AS taxonId, occ.OccurrenceId, occ.Native, occ.Introduced, " + |
| 84 |
" occ.Cultivated, occ.WorldDistCompl, occ.Notes occNotes, " + |
|
| 84 |
" occ.Cultivated, occ.StatusUnknown, occ.WorldDistCompl, occ.Notes occNotes, " +
|
|
| 85 | 85 |
" sumcat.emOccurSumCatId, sumcat.Short, sumcat.Description, " + |
| 86 | 86 |
" sumcat.OutputCode, ar.AreaId, ar.TDWGCode " + emCode + |
| 87 | 87 |
" FROM emOccurrence occ " + |
Also available in: Unified diff
ref #2764 ref #4822 add WolrdDistCompl to query