Project

General

Profile

Actions
Copy link

task #7921

closed

Create database for Caucasus distribution editing

Added by Andreas Müller over 4 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Highest
Assignee:
Andreas Müller
Category:
cdmadapter
Target version:
-
Start date:
Due date:
% Done:

100%

Estimated time:
Severity:
blocker
Tags:
euro+med caucasus

Description

The following taxonomic groups should be included:

Caryophyllales: E9ADC31F-BF5B-4868-8D8E-D870DC848663 / 533921-548150-548158-548173-548182-533949-
Campanulaceae: A814DDBF-0181-45BD-8EF0-C504CA196BC0 / 533921-548150-548158-548173-548181-533970-312075-
Cyperaceae: 808B95C6-C361-45F4-97F1-39755CEB0B17 / 533921-548150-548158-548173-548176-533948-314231-

Existing distributions are not required.

Only new distributions will be reimported later. Possibility to create new taxa and synonyms should exist. Changing synonymy should not be possible.

Related issues

Related to EDIT - feature request #9197: Handle caucasus conspectus data in E+M and caucasus portalDiscussedAndreas Müller

Actions
Related to EDIT - task #10236: Import data from caucasus DB to E+MDiscussedAndreas Müller

Actions
Actions
Copy link
 #1

Updated by Andreas Müller over 4 years ago

Standard v_cdm_exp_taxaDirect

SELECT        RIdentifier, PTNameFk, PTRefFk, 0 AS MA
FROM            dbo.PTaxon AS pt
WHERE        (PTRefFk IN (7000000, 7100000, 7200000, 7300000, 7400000, 7500000, 7600000, 7700000, 8500000, 9000000)) AND (StatusFk IN (1, 5)) AND (DoubtfulFlag <> 'i') OR
                         (PTRefFk = 8000000) AND (StatusFk = 1) AND (PublishFlag = 1)

changed by

SELECT        RIdentifier, PTNameFk, PTRefFk, 0 AS MA
FROM            dbo.PTaxon AS pt
WHERE        (TreeIndex LIKE '533921-548150-548158-548173-548182-533949-%') OR
                         (TreeIndex LIKE '533921-548150-548158-548173-548181-533970-312075-%') OR
                         (TreeIndex LIKE '533921-548150-548158-548173-548176-533948-314231-%')
Actions
Copy link
 #2

Updated by Andreas Müller over 4 years ago

Standard v_cdm_exp_namesAll:

SELECT        NameId, NomRefFk, NomRefDetailFk
FROM            dbo.Name
WHERE        (NameId IN
                             (SELECT        PTNameFk AS NameId
                               FROM            dbo.v_cdm_exp_taxaAll)) OR
                         (NameId IN
                             (SELECT        NameId
                               FROM            dbo.v_cdm_exp_namesRelatedTo)) OR
                         (NameId IN
                             (SELECT        NameId
                               FROM            dbo.v_cdm_exp_namesRelatedFrom)) OR
                         (NameId IN
                             (SELECT        NameId
                               FROM            dbo.v_cdm_exp_namesCommonNameSource)) OR
                         (NameId IN
                             (SELECT        NameId
                               FROM            dbo.v_cdm_exp_namesOccurrenceSource)) OR
                         (NameId IN (7502960, 7709217, 7502034, 28349))

changed by

SELECT        NameId, NomRefFk, NomRefDetailFk
FROM            dbo.Name
WHERE        (NameId IN
                             (SELECT        PTNameFk AS NameId
                               FROM            dbo.v_cdm_exp_taxaAll)) OR
                         (NameId IN
                             (SELECT        NameId
                               FROM            dbo.v_cdm_exp_namesRelatedTo)) OR
                         (NameId IN
                             (SELECT        NameId
                               FROM            dbo.v_cdm_exp_namesRelatedFrom))
Actions
Copy link
 #3

Updated by Andreas Müller over 4 years ago

  • Tags changed from euro+med to euro+med, caucasus
  • Status changed from New to Resolved
Actions
Copy link
 #4

Updated by Andreas Müller over 4 years ago

Logfile:

14:08:44,013  INFO ResultSetPartitioner:153 - Saved 85 Authors
14:10:03,343  WARN BerlinModelAuthorTeamImport:263 - AuthorTeamCache and fullAuthorTeamCache have not the same team size: Greuter & al. <-> W. R. Greuter, U. Matthäs, H. Risse : 3395
14:10:03,718  WARN BerlinModelAuthorTeamImport:263 - AuthorTeamCache and fullAuthorTeamCache have not the same team size: Andreev & al. <-> Andreev, N. , Ančev, M. , Kožuharov, S. I. , Markova, M. , Peev, D. & Petrova, A. : 8341
14:10:31,422  INFO ResultSetPartitioner:153 - Saved 2147 AuthorTeams
14:11:30,096 ERROR CdmPermissionClass:97 - Permission class support for class eu.etaxonomy.cdm.model.common.DefinedTerm not implemented
14:11:32,158  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: P. Di Marzio, P. Fortini & G. S. Scippa <-> Di Marzio, P., Fortini, P. & Scippa, G.S.; RefId: 7003002
14:11:32,299  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Lamarck <-> J. B. A. P. de M. de Lamarck; RefId: 7700686
14:11:32,299  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Lamarck <-> J. B. A. P. de M. de Lamarck; RefId: 7700747
14:11:32,299  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Lamarck <-> J. B. A. P. de M. de Lamarck; RefId: 7700801
14:11:32,314  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Lamarck <-> J. B. A. P. de M. de Lamarck; RefId: 7700971
14:11:32,314  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Sell, P. D. & Murrell, G. <-> Sell & Murrell; RefId: 7706974
14:11:32,471  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Lamarck <-> J. B. A. P. de M. de Lamarck; RefId: 7711799
14:11:32,814  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Lamarck <-> J. B. A. P. de M. de Lamarck; RefId: 9003333
14:11:32,814  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Lamarck <-> J. B. A. P. de M. de Lamarck; RefId: 9003455
14:11:32,893  WARN BerlinModelReferenceImport:326 - Save references (2470/30)
14:12:06,550  INFO ResultSetPartitioner:153 - Saved 2500 references
14:12:10,019  WARN BerlinModelReferenceImport:1366 - Unexpected short nom author name part: fr.; 5803
14:12:10,019  WARN BerlinModelReferenceImport:1366 - Unexpected short nom author name part: fr.; 5803
14:12:10,112  WARN BerlinModelReferenceImport:1366 - Unexpected short nom author name part: fr.; 7026
14:12:10,831  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Sukhorukov, A. P. <-> Sukhorukov; RefId: 25882
14:12:10,909  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Bunge, A. <-> Bunge, A. A. von; RefId: 26643
14:12:10,909  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Fennane, M., Ibn Tattou, M. & El Oualidi, J. <-> Fennane & al.; RefId: 26701
14:12:11,409  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Sibthorp & Smith <-> Smith, J. E.; RefId: 7002402
14:12:11,409  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Kubát, K., Hrouda, L., Chrtek, J. jun., Kaplan, Z., Kirschner, J. & Štěpánek, J. (ed.) <-> Kubát & al.; RefId: 7004566
14:12:11,409  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Greuter, W. & Raab-Straube, E. von (ed.) <-> Greuter & Raab-Straube; RefId: 7004576
14:12:11,441  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Castroviejo, S. & al. <-> Castroviejo & al.; RefId: 7005571
14:12:11,441  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Domac, R. <-> Domac; RefId: 7005879
14:12:11,441  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Gagnidze, R. <-> Gagnidze; RefId: 7005905
14:12:11,441  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Fedorov, A. A. <-> Fedorov; RefId: 7009536
14:12:11,456  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Coste, H. <-> Coste; RefId: 7600126
14:12:11,456  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Rouy, G. <-> Rouy, G. C. C.; RefId: 7601775
14:12:11,784  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Lamarck <-> J. B. A. P. de M. de Lamarck; RefId: 7701269
14:12:12,941  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Maire, R. <-> Maire, R. C. J. E.; RefId: 7709576
14:12:13,081  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Portal, R. <-> Portal; RefId: 7711831
14:12:14,597  WARN BerlinModelReferenceImport:326 - Save references (2466/34)
14:13:01,598  INFO ResultSetPartitioner:153 - Saved 5000 references
14:13:07,692  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Portal, R. <-> Portal; RefId: 7002975
14:13:07,708  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Doweld, A. <-> Doweld; RefId: 7007387
14:13:09,489  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Baumel, A., Auda, P. & Médail, F. <-> Baumel & al.; RefId: 7003500
14:13:09,489  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: G. Nieto Fel., J. Fuertes Aguilar, J. Antoni Rosselló <-> Nieto Fel. & al.; RefId: 7003339
14:13:09,567  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: S. Brullo, C. Marcenò & S. Romano <-> Brullo & al.; RefId: 7003009
14:13:09,598  WARN BerlinModelReferenceImport:326 - Save references (1962/538)
14:13:49,334  INFO ResultSetPartitioner:153 - Saved 7500 references
14:13:56,818  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Brullo, Guglielmo & Terrasi <-> Brullo & al.; RefId: 7003000
14:13:56,928  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: G. Nieto Fel. <-> Nieto Fel.; RefId: 7003361
14:13:58,022  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Schütt, B. <-> Schütt; RefId: 7611400
14:13:58,022  WARN BerlinModelReferenceImport:326 - Save references (1703/797)
14:14:29,991  INFO ResultSetPartitioner:153 - Saved 10000 references
14:14:39,054  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Salvatore Brullo & Gianpietro Giusso del Galdo <-> Brullo & Giusso; RefId: 7003355
14:14:39,054  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Bartolo, Brullo & Giusso <-> Bartolo & al.; RefId: 7003358
14:14:40,320  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Crespo, M. B. & Mateo, G. <-> M. B. Crespo & Mateo; RefId: 7003499
14:14:40,320  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: D. Pavon & E. Buisson <-> Pavon, D. & Buisson, E.; RefId: 7007517
14:14:40,648  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Ančev, M. & Polatschek, A. <-> Ančev & Polatschek; RefId: 7005657
14:14:41,117  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Erben, M. & Arán, V. J. <-> Erben, M. & Arán Redó, V.J.; RefId: 7003449
14:14:41,117  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Erben, M. & Arán, V. J. <-> Erben, M. & Arán Redó, V.J.; RefId: 7003450
14:14:41,242  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Brullo, S. & Guarino, R. <-> Brullo & Guarino; RefId: 7003443
14:14:41,320  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Dinç, M., Bağcı, Y. & Yildirimli, Ş. <-> Dinç & al.; RefId: 26679
14:14:41,320  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Dinç, M. & Yildirimli, Ş. <-> Dinç & Yildirimli; RefId: 26680
14:14:41,320  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Marcussen, Th. <-> Marcussen; RefId: 26681
14:14:41,335  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Brullo, Scelsi & Spampinato <-> Brullo & al.; RefId: 7003354
14:14:41,351  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: J. Pusch <-> Pusch; RefId: 7002861
14:14:41,429  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Volz, S. M. & Renner, S. S. <-> Volz & Renner; RefId: 26675
14:14:41,882  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Moraldo, B., Ricceri, C., Fiorini, G. & Demaria, G. <-> Moraldo & al.; RefId: 26686
14:14:42,038  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Ančev, M. & Tomšovic, P. <-> Ančev & Tomšovic; RefId: 7005897
14:14:42,038  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: M. B. Crespo & M. D. Lledó <-> Crespo, M. B. & Lledó, M.D.; RefId: 7003496
14:14:42,460  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: R. Jardim, M. Seq., Capelo, J. C. Costa & Rivas Mart. <-> R. Jardim & al.; RefId: 7003446
14:14:42,585  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Demoly, J.-P. <-> Demoly; RefId: 7009092
14:14:42,726  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Cosson, M. E. <-> Cosson, E. S.-C.; RefId: 26638
14:14:42,773  WARN BerlinModelReferenceImport:326 - Save references (2304/196)
14:15:35,837  INFO ResultSetPartitioner:153 - Saved 12500 references
14:15:47,697  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Piwowarczyk, R., Kwolek, D., Denysenko, M., Cygan, M., Góralski, G., Ślesak, H., Tuleja, M., Joachimiak, A. J. <-> Piwow. & al.; RefId: 7005915
14:15:47,743  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Mateo, G. <-> Mateo; RefId: 7003503
14:15:47,790  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Tomović, G., Niketić, M., Lazarević, M. & Melovski, L. <-> Tomović & al.; RefId: 7006573
14:15:47,790  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Vašut, R. J. & Majeský, L. <-> Vašut & Majeský; RefId: 7006651
14:15:47,790  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: C. Brullo, Brullo, Cambria, Giusso & Ilardi <-> C. Brullo & al.; RefId: 7006705
14:15:47,790  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Brullo & Erben <-> Erben, M. & Brullo, S.; RefId: 7006707
14:15:48,040  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Pavlova <-> Pavlova, D.; RefId: 7005615
14:15:48,040  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Beck-Mannagetta, G. <-> G. von M. und L. Beck; RefId: 7005875
14:15:48,134  WARN BerlinModelReferenceImport:1142 - refAuthorString differs from nomAuthor.titleCache: Orlova, I. N. <-> Orlova; RefId: 7007311
14:15:48,884  WARN BerlinModelReferenceImport:326 - Save references (1235/19)
14:16:04,150  INFO ResultSetPartitioner:153 - Saved 13754 references
14:16:04,150  WARN BerlinModelReferenceImport:257 - Parsed book volumes: 276
14:17:21,449  INFO ResultSetPartitioner:153 - Saved 2500 TaxonNames
14:18:27,826  INFO ResultSetPartitioner:153 - Saved 5000 TaxonNames
14:19:29,812  INFO ResultSetPartitioner:153 - Saved 7500 TaxonNames
14:20:27,095  INFO ResultSetPartitioner:153 - Saved 10000 TaxonNames
14:21:24,550  INFO ResultSetPartitioner:153 - Saved 12500 TaxonNames
14:21:31,300  INFO ResultSetPartitioner:153 - Saved 12862 TaxonNames
14:23:37,384  INFO ResultSetPartitioner:153 - Saved 2500 name relations
14:24:01,744  INFO ResultSetPartitioner:153 - Saved 3132 name relations
14:24:14,041  INFO ResultSetPartitioner:153 - Saved 422 nomenclatural status
14:24:14,682  INFO ResultSetPartitioner:153 - Saved 9 name facts
14:25:03,714  INFO ResultSetPartitioner:153 - Saved 2500 Taxa
14:25:51,841  INFO ResultSetPartitioner:153 - Saved 5000 Taxa
14:26:39,514  INFO ResultSetPartitioner:153 - Saved 7500 Taxa
14:27:27,000  INFO ResultSetPartitioner:153 - Saved 10000 Taxa
14:28:15,470  INFO ResultSetPartitioner:153 - Saved 12500 Taxa
14:28:23,142  INFO ResultSetPartitioner:153 - Saved 12871 Taxa
14:29:13,206  INFO ResultSetPartitioner:153 - Saved 2500 taxon relations
14:30:19,176  INFO ResultSetPartitioner:153 - Saved 5000 taxon relations
14:31:35,335  INFO ResultSetPartitioner:153 - Saved 7500 taxon relations
14:32:52,759  INFO ResultSetPartitioner:153 - Saved 10000 taxon relations
14:34:25,199  INFO ResultSetPartitioner:153 - Saved 12500 taxon relations
14:34:43,902  INFO ResultSetPartitioner:153 - Saved 12895 taxon relations
14:34:43,918  WARN BerlinModelAreaImport:109 - Start creating E+M areas
14:35:54,983  WARN BerlinModelAreaImport:167 - Created E+M areas
14:35:58,795  INFO ResultSetPartitioner:153 - Saved 141 areas
14:36:03,233  WARN CaucasusEuroMedActivator:566 - Cichorieae node could not be found for cichorieae-editor role
Actions
Copy link
 #5

Updated by Andreas Müller over 4 years ago

  • Status changed from Resolved to Closed
  • % Done changed from 0 to 100
Actions
Copy link
 #6

Updated by Andreas Müller over 4 years ago

  • Target version deleted (Release 5.5)
Actions
Copy link
 #7

Updated by Andreas Müller almost 3 years ago

Actions
Copy link
 #8

Updated by Andreas Müller 4 months ago

  • Related to task #10236: Import data from caucasus DB to E+M added
Actions
Copy link

Also available in: Atom PDF