Quelltext der Seite OpenSeaMap-dev:IHO Hydographic Dictionary S-32

Data base description...

= HowTo =
Store the folder "S-32" (with the two files "IHO_Hydrographic_Dictionary_S-32.xls" and "IHO Hydrographic Dictionary S-32.mdb") <br> whereever you like.

For editing the database:
# In your Excel set in menu "Extra" in "Macro > Security" to "low"
# Start Excel with "IHO_Hydrographic_Dictionary_S-32.xls"
# In table "Start": click "Edit database by User form"

You see:
: an "Userform" with the "IHO Definition" (English) (left), and "National Language" (editable) (right)
: an "Excel sheet" (behind) with all "Terms" in English, Français and Español.

== Excel sheet ==
In the Excel sheet you can:
* Compare al terms in English, Français and Español
* Edit a dataset (by doubleclick into a term)
Click exact into a therm (if you don't, you will jump to the end)

== User-form ==
In the User-form you can:
* Set the language displayed in the right side for editing
* Search in "Term": <br>"xx" finds all Terms with "xx" somehere in it <br>"x*y" finds all Terms with " 'x' and 'something_between x and y' and 'y' "
* Scroll between datasets (by arrow-button)
* Edit each data field
* Check each data field and confirm this "Full check"

== Reqirements ==
* Excel 2003 or later <br> Menu: Extras > Macros > Security > low
* Folder "S-32" with: <br> IHO Hydrographic Dictionary S-32.xls <br> IHO Hydrographic Dictionary S-32.mdb

== Status ==
{| class="wikitable"
|-
| 3 || Languages || eng, fra, esp
|-
| 11 || Attributes || ID, old IHO-HD-No, term, description, type, sex, plural, deleted, SaveDat, LastCheck, BE/AE
|-
| 7000 || Terms || max-length: 60 characters
|-
| 7000 || Descriptions || max-length: 1500 characters
|-
| 20.000 || Records
|}

= ToDo =
{| class="wikitable sortable"
! OK || Task || Who || Until || Done || Remarks
|-
| {{ok}} || Investigate the source documents || OpenSeaMap ||  || 2015-12- || 
|-
| {{ok}} || Transform the source into a database || OpenSeaMap || 2016-01-10 || 2015-01-20 || 
|-
| {{ok}} || Showcase Word.doc "Terms in English, Français, Español" || OpenSeaMap ||  || 2016-01-30 || 
|-
| {{ok}} || Develop a tool for editing datasets || OpenSeaMap ||  || 1016-01-05 || 
|-
|  || Approve tool for editing datasets || IHO/OpenSeaMap ||  ||  || 
|-
|  || Decisions about DB design || IHB || ASAP ||  || 
|-
|  || Implement new design || OpenSeaMap ||  ||  || 
|-
|  || Decisions about rules || IHB || ASAP ||  || 
|-
|  || Implement new rules || OpenSeamap ||  ||  || 
|-
|  || Edit the "English master" || IHB || ASAP ||  || 
|-
|  || Add 3 more languages || OpenSeaMap || 2016-11 ||  || ger, zho, lzh
|-
|  || Prepare for unlimited new languages || OpenSeaMap ||  ||  || Wikipedia languages
|-
|  || Define 50 Terms/Descriptions in 3 languages || IHO || 2016-10 ||  || XLS for ger, zho, lzh
|-
| .. ||  ||  ||  ||  || 
|}

= Data improvements already done =

# Unique ID for each Term (in addition to the old number).
# Split Term and Description.
# Extract semantic data from text (Type of word, Sex of word, Plural, en-UK/en-US) <br>(~90% of all, some errors included)
# Add meta data about the datasets (Safe datum, LastCheck datum, Deleted)
# Delete nonbreaking hyphens.
# ? First letter of each Term as capital letter.
# ? Dot at the end of each Description.

= Rules =

== clear structure ==
Use only:
* Term
* Description
* Attributes
All texts in UTF-8.

* '''IHO Master''' is the English version of the database <br> (pragramatically "General English" is used, in case of doubt: British English).

=== Attributes ===

{| class="wikitable"
! Attribute || Type || Length || Content || Description
|-
| ID || incremential ||  ||  || Unique ID for all languages
|-
| number || text || 6 || #### a || Old number for old terms (may be obsolete in future)
|-
| term || text || 255 ||  || Term with one or more words, <br> without special marks, without abbrevieations, <br> optional one (1) colon (:)
|-
| description || memo || 65.535 ||  || Description of the term
|-
| sex || text || 1 || f <br> m <br> n|| feminine <br> masculine <br> neutrum
|-
| plural || text || 2 || pl <br> <empty> || term is commonly used in plural <br> term in singular
|-
| type || text || 5 || subst <br> adj <br> adv <br> vi <br> vt || substantiv <br> adjective <br> adverb <br> verb intransitive <br> verb transitive
|-
| deleted || boolean ||  || yes/no || mark as deleted if not more used
|-
| en-AB || text ||  || en-BE <br> en-AE <br> en-both || if a term is only British or only American or both
|-
| savedat || datum ||  ||  || Datum of the last save
|-
| lastcheck || datum ||  ||  || Datum of the last approved full check of a dataset
|-
| .. ||  ||  ||  || 
|}

= IHO tasks/decisions ToDo =

== use only words in a term ==
old:
: 86 <nowiki> | </nowiki> alignment correction(tape)

new:
: 86 <nowiki> | </nowiki> alignment correction by tape


== use speakable terms ==
use speakable terms and link to the ordered term (or vice versa)

; 1. example

:{| class="wikitable"
| 86 || Alignment correction by tape || see "tape: alignment correction"
|-
| 5292 || tape: alignment correction || (Description)
|}

; 2. example:

:{| class="wikitable"
| 5 || Absolute accuracy || see "Accuracy: absolute"
|-
| 22 || Accuracy: absolute || (Description)
|}

; Best solution
:{| class="wikitable"
! ||  || Sort || 
|- 
| 5 || Absolute accuracy || Accuracy || (Description)
|-
| <s>22</s> || <s>Accuracy: absolute</s>! ||  || <s>(Description)</s>
|-
| 86 || alignment correction by tape || Tape || (Description)
|-
| <s>5292</s> || <s>tape: alignment correction</s>! ||  || <s>(Description)</s>
|}

== split Sub-Languages ==
(but be sure it is not only a dialect)
: en into en-BE and en-AE
: es into es-ESP and es-ARG

old:
:{| class="wikitable"
| 1756 || fair chart (Brit) || (Description)
|-
| 1757 || fair sheet || see "fair chart"
|-
| 4793 || smooth sheet (US)  || see "fair chart"
|}

new en-BE:
:{| class="wikitable"
| 1756 || fair chart || (Description)
|-
| 1757 || fair sheet || see "fair chart"
|-
| 4793 || (nothing) || see "fair chart"
|} 
new en-AE:
:{| class="wikitable"
| 1756 || smooth sheet || (Description)
|-
| 1757 || (nothing) || see "smooth sheet"
|-
| 4793 || (nothing) || see "smooth sheet"
|}

If you don't like to split Sub-Languages:
=== decide which is the Master Language ===
Suggestion: en-BE (which may be a political issue)

old:
:{| class="wikitable"
| 1756 || fair chart (Brit) || (Description)
|-
| 1757 || fair sheet || see "fair chart"
|-
| 4793 || smooth sheet (US) || see "fair chart"
|}

new:
:{| class="wikitable"
| 1756 || fair chart || (Description)
|-
| 1757 || fair sheet || see "fair chart"
|-
| 4793 || smooth sheet (AE) || see "fair chart"
|}

== split Multi-Terms ==
old:
:{| class="wikitable"
| 998 || continental (or island) shelf
|}
new:
:{| class="wikitable"
| 998 a || continental shelf
|-
| 998 b || island shelf
|}
old:
:{| class="wikitable"
| 398 || base tape (or wire)
|}
new:
:{| class="wikitable"
| 398 a || base tape
|-
| 398 b || base wire
|}


old:
:{| class="wikitable"
| 3104 || marine nature reserve (U.S. marine sanctuary)
|}
new en-BE:
:{| class="wikitable"
| 3104 || marine nature reserve
|}
new en-AE:
:{| class="wikitable"
| 3104 || marine sanctuary
|}

== split Multi-Descriptions ==
This has to be discussed... (how to find/list identic terms?)

old:
:{| class="wikitable"
| 1015 || control point || (Description 1)... (Description 2)...
|}
new:
:{| class="wikitable"
| 1015 || control point || (Description 1)
|-
| #### || control point || (Description 2)
|}

== split Synonyms ==
Synonyms are possible in the form:
:{| class="wikitable"
| #### || Term_1 || (Description)
|-
| #### || Synonyme_1 of Term_1 || see: Term_1
|}

== Aberrations needs an own term ==
old:
:{| class="wikitable"
| 1276 || deep scattering layer (DSL)
|}
new:
:{| class="wikitable"
| 1276 a || deep scattering layer || (description)
|-
| 1276 b || DSL || see "deep scattering layer"
|}
but how to deal with multiple meanings:
:{| class="wikitable"
| 1276 c || DSL || see "Digital Subscriber Line"
|}

== use Singular ==
old:
{| class="wikitable"
| 1424 || divider(s)
|}
new:
{| class="wikitable"
| 1424 a || divider
|}
or split if necessary:
{| class="wikitable"
| 1424 a || divider
|-
| 1424 b || dividers
|}

= Errors =
== English ==
Some small typos...

== French ==
The system does not match to the English system...

Some terms have double numbers:
{| class="wikitable"
| 1408-1411 || Aberration radiale
|}

Some terms have no number:
{| class="wikitable"
| ... || Abaque d’échelle
|}

== Spanish ==
: Terms marked with "(Esp)" this is split between Term and Declaration.
: Terms marked with "(Arg)" this is split between Term and Declaration.

= Use of the database =

== as dictionary ==
; Read-only user-form 
: with "Search in Term-text" 
: left: Language-1, right: Language-2

; Read-only Excel-sheet 
: left: Language-1, right: Language-2

; Read-only Word-document 
: left: Language-1, right: Language-2

; Read-only PDF 
: left: Language-1, right: Language-2

== Append database ==
; User-form with "Search in Term-text" 
: left: Language-en, right: Language-2 
: append a new term, marked as new suggestion to the IHB

=== Missed terms ===
{| class="wikitable"
! ID || OK || Term:en || Term:de || Remarks
|-
|  ||  || nautical light || Leuchtfeuer || 
|-
| 3486 ||  || Nominal range || Tragweite || see: Range
|-
|  ||  ||  || Feuerhöhe || 
|-
|  ||  ||  || Turmhöhe ||
|-
| 3771 ||  || Period (of nautical light) || Wiederkehr || ()
|}

== Mantain database ==
: Search and list all last FullCheck
: Search and list all last FullCheck before <datum>
: search all Deleted
: search all Combobox attributes
: do Statistic
: Export

Frank Richter 
http://dict.tu-chemnitz.de 
Telefon: +49 (0)371 531-31879
Frank.Richter@hrz.tu-chemnitz.de

== Other dictionaries ==
: [http://www.iala-aism.org/wiki/dictionary/index.php IALA-Dictionary] (2700)
: [http://www.iala-aism.org/wiki/dictionary/index.php/Acronyms IALA Acronyms] (1000)
: [ S-100]
: [http://www.nauticalcharts.noaa.gov/mcd/chart1/ChartNo1.pdf INT-1] (~1200)
: [https://en.wikipedia.org/wiki/Glossary_of_nautical_terms WP: Glossary of nautical terms] (~1600)
: [https://en.wiktionary.org/wiki/Category:en:Nautical Wiktionary: Category:en:Nautical] (2200)