联合国数据库操作介绍

联合国关于国际贸易商品数据库操作的详细介绍

UNSD - OECD Joint System

Web Browser Client - UN Comtrade Version User Manual Page 1

1.1. Data Query & Extraction

Several functions provide the User with commodity-related results once selection parameters (commodity, country, year…) are set. The data query functions are activated through the links below:

Figure 1: Data Query & Extraction links

1.1.1. Quick Search

INFO³/OECD Ref: Comtrade Manual - Data Query & Extraction.doc Although not in the Data Query & Extraction group, the Quick Search processor makes it possible to retrieve data according to pre-defined reporter countries that can be selected from a list:

Figure 2: Quick Search entries for first letter F

A subset of the Quick Search list is displayed as soon as a letter is typed. Extra letters refine the selection, like in the example below:

Figure 3: two-letter selection from the Quick Search list

联合国关于国际贸易商品数据库操作的详细介绍

To filter the

selection

Selection

summary Field displays its caption

when pointed to by the mouse

Processor name

On-line Help

联合国关于国际贸易商品数据库操作的详细介绍

UNSD - OECD Joint System

Web Browser Client - UN Comtrade Version User Manual

Page 3

Notes: 1. The Query Processor name, Comtrade Explorer, appears at the top left of the form. The functions

described in section 2.2 are in fact links to a small number of common query processors :

? Shortcut Query

? Comtrade Explorer

? Basic Query

? Express Selection

These four processors can be directly accessed from the Data Query & Selection links and each of them has its own section in this document. Refer to the Table of Contents .

2. An empty filter field means that no filtering takes place: the whole data set is selected. This is true all

over this document.

3. The Classification field defines the international codes that represent commodity descriptions. This point

is discussed later.

4. The Quick Filter combo makes it possible to filter the selection by selecting an extra criterion that

relates to partner country, year or commodity:

INFO³/OECD Ref: Comtrade Manual - Data Query & Extraction.doc

Figure 5: Extra selection by commodity (first three letters are ‘pet’)

(Continued on the next page )

联合国关于国际贸易商品数据库操作的详细介绍

UNSD - OECD Joint System

Web Browser Client - UN Comtrade Version User Manual

Page 4

INFO³/OECD Ref: Comtrade Manual - Data Query & Extraction.doc Selecting the first entry in the list above and clicking Apply produces the following report:

Figure 6: results of selection by country (France) and commodity (gases except from petroleum)

Finally, the Further Research combo allows Users to change the selection criteria without returning to the original interface. For instance, we can select other reporting countries:

Figure 7: changing selection criteria in the Comtrade Explorer report

联合国关于国际贸易商品数据库操作的详细介绍

List of currently selected countries

List

management

buttons

联合国关于国际贸易商品数据库操作的详细介绍

New country selection

联合国关于国际贸易商品数据库操作的详细介绍

Commodity code in the classification

联合国关于国际贸易商品数据库操作的详细介绍

List of classification codes

联合国关于国际贸易商品数据库操作的详细介绍

Query processor

name

List of actions

联合国关于国际贸易商品数据库操作的详细介绍

Quick filter

combo Selection summary

List of actions

联合国关于国际贸易商品数据库操作的详细介绍

Processor name

联合国关于国际贸易商品数据库操作的详细介绍

UNSD - OECD Joint System

Web Browser Client - UN Comtrade Version User Manual

Page 12

1.1.

2.

3. View Graph

Clicking View Graph in the list of actions brings up a pie chart that reflects the current selection:

Figure 21: detailed information on two commodities – graphical form

This is the Comtrade Explorer Processor interface we already met in fig. 5; also see Note 1 below this figure. The pie chart shows the two selected items trade values compared to all the other commodities.

Again, a “tooltip” text pops up when moving the mouse cursor over the pie chart.

Back to fig. 5, we notice the already described Quick Filter and Further Research combos.

1.1.

2.4. Printable Forma t

INFO³/OECD Ref: Comtrade Manual - Data Query & Extraction.doc This action simply displays the trade information in fig. 19 using the whole screen width, so as to get a full- page report. Also notice the included commodity labels:

Figure 22: Printable Format display – may need enlargement

联合国关于国际贸易商品数据库操作的详细介绍

联合国关于国际贸易商品数据库操作的详细介绍

UNSD - OECD Joint System

Web Browser Client - UN Comtrade Version User Manual

Page 14

1.1.

2.6. SDMX Download The results of a query can be downloaded to the User’s station in SDMX format, provided the User doesn’t download more than 1,000 records the same day.

The SDMX format is introduced in the Data Transfer Mechanism Manual; it is based on the XML 1 format and adapted to statistical data description and transfer.

To illustrate this download operation, we can start from the following query results:

Figure 25: Basic Query results

Clicking ‘SDMX Download’ brings up the following warning message box:

Figure 26: file download warning message

Notice the constant filename. Clicking Save displays the usual ‘Save As’ interface that allows the User to select the destination file (path and name)

INFO³/OECD Ref: Comtrade Manual - Data Query & Extraction.doc 1 Extensible Markup Language: a standard for designing and creating HTML documents

联合国关于国际贸易商品数据库操作的详细介绍

UNSD - OECD Joint System

Web Browser Client - UN Comtrade Version User Manual

Page 15

INFO³/OECD Ref: Comtrade Manual - Data Query & Extraction.doc Finally, the downloaded file is visible through Windows Explorer:

Figure 27: the downloaded SDMX file (highlighted) – the name was left unchanged

As stated before, this file has a XML-like structure; it can be read by Internet Explorer:

Figure 28: SDMX file contents (partial view)

联合国关于国际贸易商品数据库操作的详细介绍

UNSD - OECD Joint System

Web Browser Client - UN Comtrade Version User Manual

Page 16

1.1.

2.7. View Not Available Data INFO³/OECD Ref: Comtrade Manual - Data Query & Extraction.doc This function points out the data items that are not available (i.e., that haven’t been provided by the selected country, or that have been rejected by UNSD…), for the selected year, classification and commodity. Most of the time, the data will be available, and the following form will pop up:

Figure 29: not available data: none for this example

Another selection can show unavailable data for a specific year:

Figure 30: data from Albania unavailable in 2002 for the selected commodities

联合国关于国际贸易商品数据库操作的详细介绍

Tab selection List of filter values (empty for the moment)

Filter list management

联合国关于国际贸易商品数据库操作的详细介绍

UNSD - OECD Joint System

Web Browser Client - UN Comtrade Version User Manual

Page 18

1.1.3.

2. Commodities

INFO³/OECD Ref: Comtrade Manual - Data Query & Extraction.doc The Commodities tab interface is reproduced below:

Figure 32: selection of commodity “cars”

The Source combo makes it possible to select the data source from which records will be selected:

Figure 33: selecting the data selection source

These data selection sources are discussed in this paragraph, tagged with a ‘’ sign.

(Continued on the next page )

联合国关于国际贸易商品数据库操作的详细介绍

Selection-resulting tree symbol.

联合国关于国际贸易商品数据库操作的详细介绍

Items finally selected – this is a ‘OR’ list

联合国关于国际贸易商品数据库操作的详细介绍

Node and its descendants selected

Notice the signs

Selected

Excluded

本文来源：https://www.bwwdw.com/article/e0k4.html