As an anonymous user, you can only add new data. If you would like to also modify existing data, please create an account and indicate your languages on your user page.

Help:OmegaWiki's Development CSVs

From OmegaWiki
Jump to: navigation, search

Information[edit]

current version: 1.0

This is a zip file which contains text and CSV files which can be used to extract OmegaWiki's data.

Zip file Contents[edit]

  • owd_<languageCode>.ini - contains the compilation version number, content help and latest syntrans transaction id
  • owd_<languageCode>.csv - contains definitions
  • owd_syn_<languageCode>.csv - contains synonyms and translations with annotations
  • owd_att_<languageCode>.csv - contains list of annotations that can be linked to other language files annotations.
  • owd_<languageCode>.mia - contains attributes that were not included in this version

owd_<languageCode>.csv[edit]

The Definition csv.

This is a comma separated value file that contains 4 columns:

  • defined_meaning_id
  • language_id
  • definition
  • subject (an option attribute)

Possible SQL CREATE TABLE[edit]

SQlite format:

CREATE TABLE dm (
	dm_id integer,
	lang_id integer,
	"text" text,
	topic text DEFAULT NULL,
	primary key( dm_id, lang_id )
);

owd_syn_<languageCode>.csv[edit]

The Syntrans csv.

This is a comma separated value file that contains 15 columns:

  • defined_meaning_id
  • language_id
  • syntrans_id
  • expression
  • IPA (text attribute)
  • hyphenation (text attribute)
  • example (text attribute)
  • text usage (text attribute)
  • POS (option attribute)
  • option usage (option attribute)
  • area (option attribute)
  • grammatical Property (option attribute)
  • number (option attribute)
  • pinyin (text attribute)
  • gender (option attribute)

Possible SQL CREATE TABLE[edit]

SQlite format:

create table syntrans (
	dm_id integer,
	lang_id integer,
	syntrans_id integer,
	spelling text,
	IPA text DEFAULT NULL,
	hyphenation text DEFAULT NULL,
	example text DEFAULT NULL,
	usage_1 text DEFAULT NULL,
	POS text DEFAULT NULL,
	usage_2 text DEFAULT NULL,
	area text DEFAULT NULL,
	grammatical_property text DEFAULT NULL,
	"number" text DEFAULT NULL,
	pinyin text DEFAULT NULL,
	gender text DEFAULT NULL,
	primary key( dm_id, lang_id, syntrans_id )
);

owd_att_<languageCode>.csv[edit]

The Attributes csv.

  • syntrans_id
  • attribute id
  • attribute type currently either TEXT or OPTN
  • attribute name the attribute name example part of speech
  • attribute value the attribute value example noun

Possible SQL CREATE TABLE[edit]

SQlite format:

create table attributes (
	syntrans_id integer,
	attribute_id integer,
	value_id integer,
	attribute_type text,
	attribute_name DEFAULT NULL,
	attribute_value DEFAULT NULL,
	primary key( syntrans_id, attribute_id, value_id, attribute_type, attribute_value )
);

Usage[edit]

  • Basically, the Definition CSV's defined_meaning_id and language_id when paired to the syntrans CSV's defined_meaning_id and language_id would link both CSVs.

Example: owd_eng.csv's

3,85,"An entry in a thesaurus or dictionary that is associated with a theme",

links to owd_syn_eng.csv's

3,85,184742,"is part of theme",,,,,,,,,,,
3,85,464689,"part of theme",,,,,,,,,,,
  • The syntrans CSV's syntrans_id when paired with attribute CSV's syntrans_id links both CSVs.

Example: owd_syn_eng.csv's

4,85,464630,"hypernym",,,,,"noun",,,,,,

links to owd_att_eng.csv's

464630,358760,5612,"OPTN","part of speech","noun"
  • Each language can be linked using both language's Definition CSV's defined_meaning_id.

Example: owd_eng.csv's

3,85,"An entry in a thesaurus or dictionary that is associated with a theme",

links to owd_fra.csv's

3,86,"Entrée dans un thésaurus ou un dictionnaire qui est associée à un thème.",

See Also[edit]