This might be of use to application developers....

[trevelyan]

A simplified version of the Adso database. It comes as a single SQL table that lets one select on five fields for over 120,000 entries:

english, chinese, pinyin, flag, source

http://www.adsotrans.com/adso_english.zip

To get it working:

(1) install MySQL or a comparable database

(2) connect to it and create an empty database

mysql> CREATE DATABASE english

(3) feed the files into your new database (order is important):

mysql -u [user] -p english < adso.sql

mysql -u [user] -p english < ldc.sql

You can now search and select on any of the five categories. Part of speech information is coded in the "flag" field, and includes ADJT, ADVB, ADDRESS, AUXV, CHINESEPLACE, CITY, COUNTRY, NAME, NOUN, PERSON, PHONETIC, ORG, MW, PLACE, VERB, and more. The full list is available here: http://www.adsotrans.com/class_hierarchy.txt.

For instance:

(1) Returning the english names of Organizations

SELECT english from adso where FLAG REGEXP "ORG" and FLAG REGEXP "NOUN";

(2) Returning Measure Words

SELECT chinese from adso where FLAG REGEXP "MW";

(3) Returning Measure Words found in Roddy's HSK lists

SELECT chinese from adso where FLAG REGEXP "MW" and FLAG REGEXP "HSK";

(4) Returning Verbs found in Roddy's list for HSK level four

SELECT chinese from adso where FLAG REGEXP "VERB" and FLAG REGEXP "HSK4";

etc. etc. etc.