Project

General

Profile

Actions

task #10326

open

EuroMed mosses remaining issues

Added by Andreas Müller 11 months ago. Updated 10 months ago.

Status:
In Progress
Priority:
New
Category:
data
Target version:
Start date:
Due date:
% Done:

20%

Estimated time:
Severity:
normal
Tags:

Description

copied from #10229

  • Dataportal:
    • Condensed Distribution String handling EUR area
    • maps (or comment) for the separate mosses areas, shapefile needed for Russian areas (urgent) and Gr+Ae(Gr) (not urgent) => #10349
    • Condensed Distribution String for IUCN data #10327
    • Advanced search does not look nice anymore #10366
  • Data:
    • synonyms (still unclear were to take from)
    • Mediterranean data (still unclear were to take from)
    • Nomencl. authors for higher taxa
    • Ireland: Discuss with authors if mapping to Hb(E) is correct
    • move endemisim data to E+M Areal once possible
    • decision by ERS, if IUCN status NA should map to a distribution status native or introduced, currently it is mapped to native but probably introduced is correct (mail sent)
    • Check with ERS if Status Notes and/or Taxon Details tables were considered (in the same Excel files), see #10229#note-11, also author comparison (Tropicos - import file)
  • TaxEditor
    • see how the mosses areas can be handled best in TaxEditor (don't show them usually, but allow the possibility to edit them in case a change is needed)
    • Handling of IUCN status in TaxEditor - preference needed #10323
    • Maybe move It subareas to main vocabulary
  • Handle EUR as alternative root as long as mediterranean data is missing
  • Correct handling of Tu and its childs in hierarchy and cond. distr. (see also #9502)
  • Discuss: should EUR be shown in condensed distribution for status "not endemic" for mosses?
    • Pro: being not endemic in EUR does not mean being not endemic in E+M. So showing EUR explicitly clearifies that endemism is about EUR not E+M here
    • The area of scope is shown in the long representation as Europe. This at least indicates that the data is about EUR, not E+M

Related issues

Related to EDIT - feature request #10327: IUCN condensed distribution configurationClosedAndreas Müller

Actions
Related to EDIT - feature request #10323: Preference for IUCN status list statesIn ProgressKatja Luther

Actions
Related to EDIT - bug #10346: Bugs in E+M dataportal 5.38ClosedAndreas Müller

Actions
Related to EDIT - feature request #10349: Add Gr+AE(G) und Russian aereas for mosses to the E+M shapefileNewAndreas Müller

Actions
Related to EDIT - bug #10366: Adapt advanced search to use area tree NewKatja Luther

Actions
Actions #2

Updated by Andreas Müller 11 months ago

  • Description updated (diff)
Actions #3

Updated by Andreas Müller 11 months ago

Actions #4

Updated by Andreas Müller 11 months ago

  • Description updated (diff)
Actions #5

Updated by Andreas Müller 11 months ago

  • Description updated (diff)
Actions #6

Updated by Andreas Müller 11 months ago

Actions #7

Updated by Andreas Müller 11 months ago

  • Description updated (diff)
Actions #8

Updated by Andreas Müller 11 months ago

  • Description updated (diff)
Actions #9

Updated by Andreas Müller 11 months ago

  • Description updated (diff)
Actions #10

Updated by Andreas Müller 10 months ago

  • Related to bug #10346: Bugs in E+M dataportal 5.38 added
Actions #11

Updated by Andreas Müller 10 months ago

  • Description updated (diff)
  • % Done changed from 0 to 10
Actions #12

Updated by Andreas Müller 10 months ago

  • Description updated (diff)
Actions #13

Updated by Andreas Müller 10 months ago

  • Description updated (diff)
Actions #14

Updated by Andreas Müller 10 months ago

  • Description updated (diff)
Actions #15

Updated by Andreas Müller 10 months ago

  • Description updated (diff)
Actions #16

Updated by Andreas Müller 10 months ago

  • Description updated (diff)
Actions #17

Updated by Andreas Müller 10 months ago

  • Status changed from New to In Progress
  • % Done changed from 10 to 20

Update areas:

SELECT deb.id, deb.area_id, deb.createdBy_id, deb.created, deb.feature_id, deb.DTYPE, deb.inDescription_id, dtb.id,  dtb.titleCache, dtb.idInVocabulary, dtb.vocabulary_id, tc.titleCache
FROM DescriptionElementBase deb INNER JOIN DefinedTermBase dtb ON deb.area_id = dtb.id
INNER JOIN TermCollection tc ON tc.id = dtb.vocabulary_id
WHERE deb.area_id = 2335  AND deb.DTYPE = 'Distribution' AND (deb.feature_id = 999 || deb.feature_id = 2702)
AND deb.created > '2023-04-21' AND deb.created < '2023-04-23' AND deb.createdBy_id IS NULL;
UPDATE DescriptionElementBase
SET area_id = 2336 
WHERE id IN (SELECT deb.id
FROM DescriptionElementBase deb INNER JOIN DefinedTermBase dtb ON deb.area_id = dtb.id
INNER JOIN TermCollection tc ON tc.id = dtb.vocabulary_id
WHERE deb.area_id = 2335  AND deb.DTYPE = 'Distribution' AND (deb.feature_id = 999 || deb.feature_id = 2702)
AND deb.created > '2023-04-21' AND deb.created < '2023-04-23' AND deb.createdBy_id IS NULL
);
Actions #18

Updated by Andreas Müller 10 months ago

  • Description updated (diff)
Actions #19

Updated by Andreas Müller 10 months ago

Actions #20

Updated by Andreas Müller 10 months ago

  • Description updated (diff)
Actions #21

Updated by Andreas Müller 10 months ago

  • Description updated (diff)
Actions #22

Updated by Andreas Müller 10 months ago

  • Related to bug #10366: Adapt advanced search to use area tree added
Actions #23

Updated by Andreas Müller 10 months ago

  • Description updated (diff)
Actions

Also available in: Atom PDF