DATA bookmark

As the initial data for building map of diagrams the map is used.

In case the current document contains some maps (a map - background and the user maps), it is necessary to choose, which of them should be processed.

The resulting map will be created with the name specified by you. At its creation the classifier on which the processed map is created will be used.

As a source of link for construction of a thematic map it can be databases, text files and actually a map. For databases the link with the selected objects of a map can be of two kinds: internal link (by the field of table LINKOBJECT) and conditional link (a field of the table <-> semantics of objects).

For text files the link- conditional link (a field of a table <-> semantics of objects), for a map - link of three kinds: no link (values from semantics), simple colouring (by a serial number), simple colouring (random).

Link of the selected map objects and records of an open database can be of three types:

1. No link (values from semantics).

Link of objects with the table is not implemented the information is taken from semantics of the selected objects.

2. Internal link (by LINKOBJECT table field).

Link of objects with the table is implemented by internal links of the table.For installation of the connection the table should contain LINKOBJECT field which contains numbers of map object.

Semantics of the selected objects does not participate in the link.

3. Conditional link (a field of the table <-> semantics of objects).

Link of objects with the table is implemented by way of identification of value of semantics, chosen from the list of semantics of selected objects, and a field of the table, chosen of the list of the link fields. The list of semantics of the selected objects is formed automatically according to type of a link field of the table. If the current link field of the table has numerical type - in the list of semantics only semantics with numerical type will be. If the current link field of the table has character type - in the list of semantics only character semantics will be.

For databases Dbase, specify the source of data - «dbf file». «DB Tables» field should contain a full path to a database file for which choice it is possible to use the button of calling the dialog for a file choice.

For databases of MS SQL Server, PostgreSQL, specify the source of data - "database".

For connection to database of MS SQL Server the dialog of "Property of a data link» is called:

Dialog box of Properties of a data link:

The bookmark «Data Provider» is used for a choice of OLE DB provider. The list contains all detected on disk OLE DB providers, we choose Microsoft OLE DB Provider for SQL Server. We press the button Next>> and we are switched to the bookmark "Connection" (there is an opportunity to immediately go to the bookmark "Connection" by double-clicking the provider name).

Dialog box of Properties of data link - Connection bookmark:

The bookmark «Connection» allows to customize connection parameters. Fill with values the fields containing the server name, the user name, the password, set the flag of permission to save the password and choose a database on the server.

By pressing the button Check connection, we check connection with the specified source. After successful check of connection we press the button Ok.

Further we choose the table from the drop-down list the DB Tables.

For connection to PostgreSQL database it is necessary to create preliminarily a data source by use of the ODBC-administrator. The executable file odbcad32.exe is located in the directory \Windows\System32\odbcad32.exe in 32-bit Windows operating system. In 64-bit operating system -\Windows\SysWOW64\odbcad32.exe.

To start the ODBC administrator (Control Panel -> Administrative tools-> ODBC Data Sources).

To activate the bookmark of System DSN, press button «Add».

The ODBC data source administrator:

To select the driver - PostgresSQL Unicode and press the «Finish»"button.

Creating new data source:

Setup of properties of a new data source:

Fill in the fields:

- Data Source - a name of data source (for example, ds_thematic_postgresql);

- Database - a database (for example, thematic_postgresql);

- Server - IP address of the server computer;

- Username - the user name;

- Password - the password which will be used to connect to the database (on the server with PostgreSQL the user with such name and the password should be preliminarily created).

To test the connection to the database by pressing the «Test» button. Upon successful testing to complete the creation of the data source by clicking the «Save» button.

Further in the dialog «Building thematic cartograms» for connection to database of MS SQL Server the dialog of "Properties of a data link» is called (the button located to the right of the field the DB Tables):

Dialog box of Properties of a data link:

The bookmark «Data Provider» is used for a choice of OLE DB provider. The list contains all detected on disk OLE DB providers, we choose Microsoft OLE DB Provider for ODBC Drivers. We press the button Next>> and we are switched to the bookmark "Connection" (there is an opportunity to immediately go to the bookmark "Connection" by double-clicking the provider name).

Dialog box of Properties of data link - Connection bookmark:

Fill with values the fields containing the data source name, the user name, the password, set the flag of the permission to save the password and specify the source catalog.

By pressing the button Check connection, we check connection with the specified source. After successful check of connection we press the button Ok.

Further we choose the table from the drop-down list the DB Tables.

To read information from text files you need:

- to set in Delimiter field a form of divider in a text string;

- enable Header option, if the first string of a text file contains names of fields;

- to set the coding.

If in a text file there is no header, then by the first line, according to the delimiter, fields will be numbered and the type is defined (S - symbolic, N- numeric).

4. Simple coloring (by serial number).

In this case the simple coloring will be made for the objects selected on a map according to order, in which they are written down in a map.

5. Simple coloring (random)

In this case simple coloring will be made for the objects selected on a map in the arbitrary order (the type of filling of concrete object at random is chosen from the list of intervals of values).

The characteristic, which will be used at construction of cartograms (except for simple coloring) it is necessary to specify in the «Value» list.

In case the type of connection 1 is specified (there is no connection, values from semantics), the list «Value» contains names of numerical semantics, found at the marked objects.

In case the type of connection 2 or 3 is specified, the list «Value» contains names of fields of the table having numerical type.