ERM — Wikibase Mapping Diagram

Entity-Relationship Model for the ClimateKG Wikibase data model

This diagram maps the IPCC AR6 XML/DTD entities to their corresponding Wikibase properties (PIDs) and class items (QIDs) on the local ClimateKG Wikibase instance.

Source file: er-diagram-wikibase.mmd — regenerate by running generate-erm.ps1 whenever erm-wikibase-mapping.xml changes.

erDiagram

    WORK {
        WikibaseItem instance_of "P1 Instance of: P1=Q2"
    }
    REPORT_SERIES {
        WikibaseItem instance_of "P1 Instance of: P1=Q3"
        String title "rdfs:label item label"
        String description "rdfs:description item description"
        WikibaseItem part_of "P3 Part of: parent Work"
        WikibaseItem parts "P4 Parts: child Series or Books"
    }
    REPORT {
        WikibaseItem instance_of "P1 Instance of: P1=Q4"
        String title "rdfs:label item label"
        String doi "P10 DOI"
        String isbn_elec "P30 ISBN Electronic (DOI)"
        String isbn_print "P31 ISBN Print (DOI)"
        String license "P11 LICENSE"
        WikibaseItem tags "P12 Has TAG"
        String date "P8 Date"
        Url pdf "P7 PDF"
        String openalex "P9 OPENALEX"
        WikibaseItem part_of "P3 Part of: parent Report Series"
        WikibaseItem parts "P4 Parts: child Books and Chapters"
    }
    TEXT_DIVISION {
        WikibaseItem instance_of "P1 Instance of: P1=Q5"
        String title "rdfs:label item label"
        String doi "P10 DOI"
        String isbn_elec "P30 ISBN Electronic (DOI)"
        String isbn_print "P31 ISBN Print (DOI)"
        String license "P11 LICENSE"
        WikibaseItem tags "P12 Has TAG"
        String date "P8 Date"
        Url pdf "P7 PDF"
        String openalex "P9 OPENALEX"
        WikibaseItem part_of "P3 Part of: parent Series"
        WikibaseItem parts "P4 Parts: child Chapters"
    }
    CHAPTER {
        WikibaseItem instance_of "P1 Instance of: P1=Q6"
        String title "rdfs:label item label"
        String doi "P10 DOI"
        String openalex "P9 OPENALEX"
        Url wiki "P5 Wiki"
        Url source "P6 Source"
        Url pdf "P7 PDF"
        WikibaseItem tags "P12 Has TAG"
        WikibaseItem part_of "P3 Part of: parent Book"
    }

    AUTHOR {
        WikibaseItem instance_of "P1 Instance of: P1=Q3998"
        String climatkg_author_id "P20 ClimateKG Author ID: e.g. AU0001"
        String last_name "P21 last name"
        String first_name "P22 first name"
        String gender "P23 gender: M or F"
        String citizenship "P24 citizenship"
        String country_of_residence "P25 country of residence"
        String affiliation "P26 affiliation"
        WikibaseItem contributed_to "P27 contributed to chapter: FK to Q6 Chapter"
    }

    GLOSSARY_TERM {
        WikibaseItem instance_of "P1 Instance of: P1=Q1 Category"
        String name "rdfs:label item label"
        String also_known_as "skos:altLabel item alias"
        Monolingualtext definition "P13 Definition"
        WikibaseItem part_of_series "P3 Part of: FK to Q4 Series via series_ref"
    }

    ACRONYM {
        WikibaseItem instance_of "P1 Instance of: P1=Q2087"
        String code "rdfs:label acronym code as item label"
        Monolingualtext description "P13 Definition: multiple; source as qualifier"
        WikibaseItem report "P3 Part of: FK to Q4 Series (report)"
    }

    WORK ||--|{ REPORT_SERIES : "contains"
    REPORT_SERIES ||--|{ REPORT : "contains"
    REPORT ||--|{ TEXT_DIVISION : "contains"
    TEXT_DIVISION ||--|{ CHAPTER : "contains"
    AUTHOR ||--|{ CHAPTER : "contributes to"
    REPORT ||--|{ GLOSSARY_TERM : "has"
    REPORT ||--|{ ACRONYM : "has"

Corpus hierarchy (QID reference)

Entity	QID	Wikibase label	Also known as
`WORK`	Q2	Work
`REPORT_SERIES`	Q3	Report Series	Monographic Series
`REPORT`	Q4	Report	Book; Monograph; Volume
`TEXT_DIVISION`	Q5	Text Division	Division
`CHAPTER`	Q6	Chapter
`AUTHOR`	Q3998	Author
`GLOSSARY_TERM`	Q1	Category	Glossary Terms
`ACRONYM`	Q2087	Acronym

See the ERM documentation for the full property reference (P1–P33) and workflow for updating the mapping.

--- title: "ERM — Wikibase Mapping Diagram" subtitle: "Entity-Relationship Model for the ClimateKG Wikibase data model" --- This diagram maps the IPCC AR6 XML/DTD entities to their corresponding Wikibase properties (PIDs) and class items (QIDs) on the local ClimateKG Wikibase instance. Source file: [`er-diagram-wikibase.mmd`](er-diagram-wikibase.mmd) — regenerate by running `generate-erm.ps1` whenever [`erm-wikibase-mapping.xml`](erm-wikibase-mapping.xml) changes. ::: {#erm-diagram-wrapper} ```{mermaid} %%| file: er-diagram-wikibase.mmd ``` ::: ```{=html} <div class="erm-toolbar"> <button class="erm-btn" id="erm-fullscreen-btn">⛶ Fullscreen</button> <a class="erm-btn erm-link" href="https://mermaidviewer.com/share/vM7HKbpLsxMF44EMalvNI" target="_blank" rel="noopener noreferrer">🔗 View on Mermaid Viewer</a> </div>  <div id="erm-modal" role="dialog" aria-modal="true" aria-label="ERM diagram fullscreen"> <div id="erm-modal-backdrop"></div> <div id="erm-modal-inner"> <div id="erm-modal-toolbar"> <span id="erm-modal-hint">Scroll to zoom · Drag to pan · Esc to close</span> <div id="erm-modal-controls"> <button class="erm-btn" id="erm-zoom-in" title="Zoom in">+</button> <button class="erm-btn" id="erm-zoom-out" title="Zoom out">−</button> <button class="erm-btn" id="erm-zoom-reset" title="Reset view">Reset</button> <button class="erm-btn" id="erm-modal-close" title="Close">✕ Close</button> </div> </div> <div id="erm-modal-viewport"> <div id="erm-modal-canvas"></div> </div> </div> </div> <style> .erm-toolbar { display: flex; gap: .6rem; align-items: center; margin: .4rem 0 1.4rem; } .erm-btn { display: inline-flex; align-items: center; padding: .35rem .8rem; border: 1px solid #6c757d; border-radius: 4px; background: #f8f9fa; cursor: pointer; font-size: .85rem; text-decoration: none; color: #212529; line-height: 1.4; font-family: inherit; } .erm-btn:hover { background: #e2e6ea; border-color: #495057; } /* Modal */ #erm-modal { display: none; position: fixed; inset: 0; z-index: 9000; } #erm-modal-backdrop { position: absolute; inset: 0; background: rgba(0,0,0,.78); } #erm-modal-inner { position: absolute; inset: 2vh 2vw; background: #fff; border-radius: 6px; display: flex; flex-direction: column; overflow: hidden; box-shadow: 0 12px 48px rgba(0,0,0,.5); } #erm-modal-toolbar { display: flex; justify-content: space-between; align-items: center; padding: .45rem .75rem; border-bottom: 1px solid #dee2e6; background: #f8f9fa; flex-shrink: 0; flex-wrap: wrap; gap: .4rem; } #erm-modal-hint { color: #6c757d; font-size: .78rem; } #erm-modal-controls { display: flex; gap: .35rem; } #erm-modal-viewport { flex: 1; overflow: hidden; cursor: grab; position: relative; background: #fafafa; } #erm-modal-viewport.dragging { cursor: grabbing; user-select: none; } #erm-modal-canvas { position: absolute; top: 50%; left: 50%; transform-origin: 0 0; } #erm-modal-canvas svg { display: block; max-width: none !important; } </style> <script> (function () { var scale = 1, tx = 0, ty = 0; var dragging = false, startX, startY, startTx, startTy; function canvas() { return document.getElementById('erm-modal-canvas'); } function viewport() { return document.getElementById('erm-modal-viewport'); } function applyTransform() { var c = canvas(); if (!c) return; c.style.transform = 'translate(calc(-50% + ' + tx + 'px), calc(-50% + ' + ty + 'px)) scale(' + scale + ')'; } function zoom(factor, pivotX, pivotY) { var prev = scale; scale = Math.min(10, Math.max(0.15, scale * factor)); var r = scale / prev; tx = pivotX + (tx - pivotX) * r; ty = pivotY + (ty - pivotY) * r; applyTransform(); } function openModal() { var src = document.querySelector('#erm-diagram-wrapper svg'); if (!src) { alert('Diagram not yet rendered — please wait a moment and try again.'); return; } var c = canvas(); c.innerHTML = ''; var clone = src.cloneNode(true); clone.removeAttribute('style'); var r = src.getBoundingClientRect(); clone.style.width = (r.width || 900) + 'px'; clone.style.height = (r.height || 600) + 'px'; c.appendChild(clone); scale = 1; tx = 0; ty = 0; applyTransform(); document.getElementById('erm-modal').style.display = 'block'; document.body.style.overflow = 'hidden'; } function closeModal() { document.getElementById('erm-modal').style.display = 'none'; document.body.style.overflow = ''; } document.addEventListener('DOMContentLoaded', function () { document.getElementById('erm-fullscreen-btn').addEventListener('click', openModal); document.getElementById('erm-modal-close').addEventListener('click', closeModal); document.getElementById('erm-modal-backdrop').addEventListener('click', closeModal); document.addEventListener('keydown', function (e) { if (e.key === 'Escape') closeModal(); }); document.getElementById('erm-zoom-in').addEventListener('click', function () { zoom(1.3, 0, 0); }); document.getElementById('erm-zoom-out').addEventListener('click', function () { zoom(1/1.3, 0, 0); }); document.getElementById('erm-zoom-reset').addEventListener('click', function () { scale = 1; tx = 0; ty = 0; applyTransform(); }); var vp = viewport(); vp.addEventListener('wheel', function (e) { e.preventDefault(); var rect = vp.getBoundingClientRect(); zoom(e.deltaY < 0 ? 1.12 : 1/1.12, e.clientX - rect.left - rect.width / 2, e.clientY - rect.top - rect.height / 2); }, { passive: false }); vp.addEventListener('mousedown', function (e) { if (e.button !== 0) return; dragging = true; startX = e.clientX; startY = e.clientY; startTx = tx; startTy = ty; vp.classList.add('dragging'); }); document.addEventListener('mousemove', function (e) { if (!dragging) return; tx = startTx + (e.clientX - startX); ty = startTy + (e.clientY - startY); applyTransform(); }); document.addEventListener('mouseup', function () { if (!dragging) return; dragging = false; var v = viewport(); if (v) v.classList.remove('dragging'); }); }); })(); </script> ``` ## Corpus hierarchy (QID reference) | Entity | QID | Wikibase label | Also known as | |--------|-----|----------------|---------------| | `WORK` | Q2 | Work | | | `REPORT_SERIES` | Q3 | Report Series | Monographic Series | | `REPORT` | Q4 | Report | Book; Monograph; Volume | | `TEXT_DIVISION` | Q5 | Text Division | Division | | `CHAPTER` | Q6 | Chapter | | | `AUTHOR` | Q3998 | Author | | | `GLOSSARY_TERM` | Q1 | Category | Glossary Terms | | `ACRONYM` | Q2087 | Acronym | | See the [ERM documentation](README.md) for the full property reference (P1–P33) and workflow for updating the mapping.