OpenSeaMap-dev:IHO Hydographic Dictionary S-32: Unterschied zwischen den Versionen
Markus (Diskussion | Beiträge) (→Status) |
Markus (Diskussion | Beiträge) (→Web Interface) |
||
(15 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt) | |||
Zeile 5: | Zeile 5: | ||
For editing the database: | For editing the database: | ||
− | # In your Excel set in menu "Extra" in "Macro > Security" to "low" | + | # In your Excel set in menu "Extra" in "Macro > Security" the value to "low" |
# Start Excel with "IHO_Hydrographic_Dictionary_S-32.xls" | # Start Excel with "IHO_Hydrographic_Dictionary_S-32.xls" | ||
# In table "Start": click "Edit database by User form" | # In table "Start": click "Edit database by User form" | ||
− | You see: | + | You see: |
− | : an "Userform" with the "English | + | : 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. | : an "Excel sheet" (behind) with all "Terms" in English, Français and Español. | ||
+ | |||
+ | == User-form "Edit" == | ||
+ | In the User-form "Edit" 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 | ||
+ | * Exit without save | ||
+ | * Save your edits | ||
+ | * Check all data fields and confirm this all together by "Full check" | ||
== Excel sheet == | == Excel sheet == | ||
In the Excel sheet you can: | In the Excel sheet you can: | ||
− | * Compare al | + | * Compare al Terms in English and in a second language |
− | * Edit a dataset (by doubleclick into a term) | + | * Edit a dataset (by doubleclick into a term) --> User-form "Edit" |
Click exact into a therm (if you don't, you will jump to the end) | Click exact into a therm (if you don't, you will jump to the end) | ||
− | == User-form == | + | == User-form "View" (not implemented yet) == |
− | In the User-form you can: | + | In the User-form "View" you can: |
− | * | + | * Display the English Definiton (left) |
+ | * Display another language (right) | ||
* 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' " | * 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) | * Scroll between datasets (by arrow-button) | ||
− | * | + | * See: term, description, picture if ther is one, corresponding Wikipedia-article if ther is one. |
− | * | + | |
+ | == Print HD as PDF (not implemented yet) == | ||
+ | Select one language: | ||
+ | * Print all terms | ||
+ | * Print all terms and descriptions | ||
+ | Select two languages: | ||
+ | * Print a translating dictionary with all terms | ||
+ | * Print a translating dictionary with all terms and descriptions | ||
== Reqirements == | == Reqirements == | ||
Zeile 34: | Zeile 52: | ||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
− | | 3 || Languages || | + | | 3 || Languages || eng, fra, esp |
|- | |- | ||
− | | | + | | 14 || Attributes || ID, ID_en, old IHO-HD-No, term, description, type, sex, plural, deleted, SaveDat, LastCheck, BE/AE, WP_URL, Co_URL |
|- | |- | ||
− | | 7000 || Terms || max-length: 60 characters | + | | 7000 || Terms || max-length: 60 characters (250) |
|- | |- | ||
− | | 7000 || Descriptions || max-length: 1500 characters | + | | 7000 || Descriptions || max-length: 1500 characters (60'000) |
|- | |- | ||
| 20.000 || Records | | 20.000 || Records | ||
Zeile 46: | Zeile 64: | ||
= ToDo = | = ToDo = | ||
+ | == Offline-Editor == | ||
{| class="wikitable sortable" | {| class="wikitable sortable" | ||
− | ! OK || Task || Who || Until || Done || Remarks | + | ! OK || No || Task || Who || Start || Until || Done || Remarks |
|- | |- | ||
− | | {{ok}} || Investigate the source documents || OpenSeaMap || || | + | | {{ok}} || 1 || Investigate the source documents || OpenSeaMap || 2015-12-21 || || 2016-01-10 || |
|- | |- | ||
− | | {{ok}} || Transform the source into a database || OpenSeaMap || | + | | {{ok}} || 2 || Transform the source into a database || OpenSeaMap || 2015-12-21 || || 2016-01-20 || |
|- | |- | ||
− | | {{ok}} || Showcase Word.doc "Terms in English, Français, Español" || OpenSeaMap || || 2016-01-30 || | + | | {{ok}} || 3 || Showcase Word.doc "Terms in English, Français, Español" || OpenSeaMap || 2015-12-21 || || 2016-01-30 || |
|- | |- | ||
− | | {{ok}} || Develop a tool for editing datasets || OpenSeaMap || || | + | | {{ok}} || 4 || Develop a tool for editing datasets || OpenSeaMap || 2015-12-21 || || 2016-02-05 || |
|- | |- | ||
− | | || Approve tool for editing datasets || IHO/OpenSeaMap || || || | + | | || 5 || Approve tool for editing datasets || IHO/OpenSeaMap || 2016-02-05 || || || iterative |
|- | |- | ||
− | | || Decisions about design || IHB || | + | | || 6 || Decisions about DB design || IHB || 2016-02-08 || ASAP || || |
|- | |- | ||
− | | || Implement new design || OpenSeaMap || || || | + | | || 7 || Implement new DB design || OpenSeaMap || || || || iterative, depends on 6 |
|- | |- | ||
− | | || Decisions about rules || IHB || | + | | || 8 || Decisions about rules || IHB || 2016-02-08 || ASAP || || |
|- | |- | ||
− | | || Implement new rules || OpenSeamap || || || | + | | || 9 || Implement new rules || OpenSeamap || || || || iterative, depends on 8 |
+ | |- | ||
+ | | || 10 || Edit the "English Definition" || IHB || 2016-02-08 || ASAP || || depends on 6, 8 | ||
+ | |- | ||
+ | | || 11 || Edit the "French Definition" || IHB || 2016-02-08 || ASAP || || depends on 10 | ||
+ | |- | ||
+ | | || 12 || Edit the "Spanish Definition" || IHB || 2016-02-08 || ASAP || || depends on 10 | ||
+ | |- | ||
+ | | || 13 || Add 3 more languages || OpenSeaMap || 2016-09-04 || 2016-11 || || ger, zho, lzh | ||
+ | |- | ||
+ | | || 14 || Prepare for unlimited new languages || OpenSeaMap || 2016-09-04 || || || Wikipedia languages | ||
+ | |- | ||
+ | | || 15 || Define 50 Terms/Descriptions in 3 languages || IHO || 2016-09-04 || 2016-11 || || XLS for ger, zho, lzh | ||
+ | |- | ||
+ | | .. || || || || || || || | ||
+ | |} | ||
+ | |||
+ | == Web Interface == | ||
+ | {| class="wikitable sortable" | ||
+ | ! OK || No || Task || Who || Start || Until || Done || Remarks | ||
|- | |- | ||
− | | || | + | | || 1 || Prepare a concept || OpenSeaMap || 2016-11-30 || || || |
|- | |- | ||
− | | .. || || || || || | + | | .. || || || || || || || |
|} | |} | ||
− | = | + | = Data improvements already done = |
# Unique ID for each Term (in addition to the old number). | # Unique ID for each Term (in addition to the old number). | ||
Zeile 91: | Zeile 129: | ||
All texts in UTF-8. | All texts in UTF-8. | ||
− | * '''IHO | + | * '''IHO Definition''' is the English version of the database <br> (pragramatically "General English" is used, in case of doubt: British English). |
=== Attributes === | === Attributes === | ||
Zeile 98: | Zeile 136: | ||
! Attribute || Type || Length || Content || Description | ! Attribute || Type || Length || Content || Description | ||
|- | |- | ||
− | | ID || incremential || || || Unique ID for all languages | + | | ID || incremential || || key || Unique ID for all languages |
+ | |- | ||
+ | | ID_en || integer || || foreign key || Unique ID for all languages | ||
|- | |- | ||
| number || text || 6 || #### a || Old number for old terms (may be obsolete in future) | | number || text || 6 || #### a || Old number for old terms (may be obsolete in future) | ||
Zeile 119: | Zeile 159: | ||
|- | |- | ||
| lastcheck || datum || || || Datum of the last approved full check of a dataset | | lastcheck || datum || || || Datum of the last approved full check of a dataset | ||
+ | |- | ||
+ | | WP_URL || text || 255 || https://.. || URL of corresponding Wikipedia article | ||
+ | |- | ||
+ | | Co_URL || text || 255 || https://.. || URL of corresponding Commons picture | ||
|- | |- | ||
| .. || || || || | | .. || || || || | ||
Zeile 136: | Zeile 180: | ||
use speakable terms and link to the ordered term (or vice versa) | use speakable terms and link to the ordered term (or vice versa) | ||
− | ; 1. example | + | ; 1. example |
:{| class="wikitable" | :{| class="wikitable" | ||
Zeile 144: | Zeile 188: | ||
|} | |} | ||
− | ; 2. example | + | ; 2. example |
:{| class="wikitable" | :{| class="wikitable" | ||
Zeile 165: | Zeile 209: | ||
|} | |} | ||
− | + | May be we will need an attribute "sort"? for marking the key-word in a term and for sorting terms (abc). | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
== split Multi-Terms == | == split Multi-Terms == | ||
Zeile 306: | Zeile 299: | ||
|- | |- | ||
| 1424 b || dividers | | 1424 b || dividers | ||
+ | |} | ||
+ | |||
+ | == 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" | ||
|} | |} | ||
Zeile 379: | Zeile 425: | ||
== Other dictionaries == | == Other dictionaries == | ||
− | + | {| class="wikitable" | |
− | : [ S-100] | + | ! Dictionary || Terms |
− | : | + | |- |
+ | | [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 | ||
+ | |- | ||
+ | | [http://www.iho.int/iho_pubs/standard/S-100/S-100_Ed_2/S_100_V2.0.0_June-2015.pdf 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 | ||
+ | |} | ||
+ | |||
+ | == Languages and Writing == | ||
+ | : [https://de.wikipedia.org/wiki/ISO_15924 ISO 15924: Writing sytems] | ||
+ | : [https://meta.wikimedia.org/wiki/Table_of_Wikimedia_projects Wikimedia Language-Code] | ||
+ | : [https://de.wikipedia.org/wiki/Wikipedia:Sprachen Wikipedia-Sprachen] | ||
+ | : [http://www.chinese-tools.com/tools/converter-tradsimp.html Chinese: lzh <> zho] |
Aktuelle Version vom 13. Dezember 2016, 15:49 Uhr
Data base description...
Inhaltsverzeichnis
HowTo
Store the folder "S-32" (with the two files "IHO_Hydrographic_Dictionary_S-32.xls" and "IHO Hydrographic Dictionary S-32.mdb")
whereever you like.
For editing the database:
- In your Excel set in menu "Extra" in "Macro > Security" the value 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.
User-form "Edit"
In the User-form "Edit" you can:
- Set the language displayed in the right side for editing
- Search in "Term":
"xx" finds all Terms with "xx" somehere in it
"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
- Exit without save
- Save your edits
- Check all data fields and confirm this all together by "Full check"
Excel sheet
In the Excel sheet you can:
- Compare al Terms in English and in a second language
- Edit a dataset (by doubleclick into a term) --> User-form "Edit"
Click exact into a therm (if you don't, you will jump to the end)
User-form "View" (not implemented yet)
In the User-form "View" you can:
- Display the English Definiton (left)
- Display another language (right)
- Search in "Term":
"xx" finds all Terms with "xx" somehere in it
"x*y" finds all Terms with " 'x' and 'something_between x and y' and 'y' " - Scroll between datasets (by arrow-button)
- See: term, description, picture if ther is one, corresponding Wikipedia-article if ther is one.
Print HD as PDF (not implemented yet)
Select one language:
- Print all terms
- Print all terms and descriptions
Select two languages:
- Print a translating dictionary with all terms
- Print a translating dictionary with all terms and descriptions
Reqirements
- Excel 2003 or later
Menu: Extras > Macros > Security > low - Folder "S-32" with:
IHO Hydrographic Dictionary S-32.xls
IHO Hydrographic Dictionary S-32.mdb
Status
3 | Languages | eng, fra, esp |
14 | Attributes | ID, ID_en, old IHO-HD-No, term, description, type, sex, plural, deleted, SaveDat, LastCheck, BE/AE, WP_URL, Co_URL |
7000 | Terms | max-length: 60 characters (250) |
7000 | Descriptions | max-length: 1500 characters (60'000) |
20.000 | Records |
ToDo
Offline-Editor
Web Interface
OK | No | Task | Who | Start | Until | Done | Remarks |
---|---|---|---|---|---|---|---|
1 | Prepare a concept | OpenSeaMap | 2016-11-30 | ||||
.. |
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)
(~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 Definition is the English version of the database
(pragramatically "General English" is used, in case of doubt: British English).
Attributes
Attribute | Type | Length | Content | Description |
---|---|---|---|---|
ID | incremential | key | Unique ID for all languages | |
ID_en | integer | foreign key | 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, without special marks, without abbrevieations, optional one (1) colon (:) | |
description | memo | 65.535 | Description of the term | |
sex | text | 1 | f m n |
feminine masculine neutrum |
plural | text | 2 | pl <empty> |
term is commonly used in plural term in singular |
type | text | 5 | subst adj adv vi vt |
substantiv adjective adverb verb intransitive verb transitive |
deleted | boolean | yes/no | mark as deleted if not more used | |
en-AB | text | en-BE en-AE 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 | ||
WP_URL | text | 255 | https://.. | URL of corresponding Wikipedia article |
Co_URL | text | 255 | https://.. | URL of corresponding Commons picture |
.. |
IHO tasks/decisions ToDo
use only words in a term
old:
- 86 | alignment correction(tape)
new:
- 86 | alignment correction by tape
use speakable terms
use speakable terms and link to the ordered term (or vice versa)
- 1. example
86 Alignment correction by tape see "tape: alignment correction" 5292 tape: alignment correction (Description)
- 2. example
5 Absolute accuracy see "Accuracy: absolute" 22 Accuracy: absolute (Description)
- Best solution
Sort 5 Absolute accuracy Accuracy (Description) 22Accuracy: absolute!(Description)86 alignment correction by tape Tape (Description) 5292tape: alignment correction!(Description)
May be we will need an attribute "sort"? for marking the key-word in a term and for sorting terms (abc).
split Multi-Terms
old:
998 continental (or island) shelf
new:
998 a continental shelf 998 b island shelf
old:
398 base tape (or wire)
new:
398 a base tape 398 b base wire
old:
3104 marine nature reserve (U.S. marine sanctuary)
new en-BE:
3104 marine nature reserve
new en-AE:
3104 marine sanctuary
split Multi-Descriptions
This has to be discussed... (how to find/list identic terms?)
old:
1015 control point (Description 1)... (Description 2)...
new:
1015 control point (Description 1) #### control point (Description 2)
split Synonyms
Synonyms are possible in the form:
#### Term_1 (Description) #### Synonyme_1 of Term_1 see: Term_1
Aberrations needs an own term
old:
1276 deep scattering layer (DSL)
new:
1276 a deep scattering layer (description) 1276 b DSL see "deep scattering layer"
but how to deal with multiple meanings:
1276 c DSL see "Digital Subscriber Line"
use Singular
old:
1424 | divider(s) |
new:
1424 a | divider |
or split if necessary:
1424 a | divider |
1424 b | dividers |
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:
1756 fair chart (Brit) (Description) 1757 fair sheet see "fair chart" 4793 smooth sheet (US) see "fair chart"
new en-BE:
1756 fair chart (Description) 1757 fair sheet see "fair chart" 4793 (nothing) see "fair chart"
new en-AE:
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:
1756 fair chart (Brit) (Description) 1757 fair sheet see "fair chart" 4793 smooth sheet (US) see "fair chart"
new:
1756 fair chart (Description) 1757 fair sheet see "fair chart" 4793 smooth sheet (AE) see "fair chart"
Errors
English
Some small typos...
French
The system does not match to the English system...
Some terms have double numbers:
1408-1411 | Aberration radiale |
Some terms have no number:
... | 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
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
Dictionary | Terms |
---|---|
IALA-Dictionary | 2700 |
IALA Acronyms | 1000 |
S-100 | ?? |
INT-1 | 1200 |
WP: Glossary of nautical terms | 1600 |
Wiktionary: Category:en:Nautical | 2200 |