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 (TXT и CSV) 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 the map, the connection with the table is not carried out, information is extracted from the semantics of the selected objects or calculated. When building on the map, six modes are available:

 — coloring by semantics values;

 — coloring by ordinal number;

 — random coloring;

 — coloring by number of objects;

 — coloring by distance from selected objects;

 — coloring by unique values of semantics.

Link of the selected map objects and records of an open database (construction modes) can be of eight types:

1. Coloring by semantics values

The coloring of the objects selected on the map by semantics values ​​is performed. The characteristic that will be used in the construction of cartograms should be specified in the «Values field» list. The «Values field» list contains the names of semantics found for the selected objects. This mode allows you to carry out construction for semantics of the types: numerical value and value in the form of a numerical code from the classifier of values.

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.

6. Coloring by number of objects

In this case, the coloring of objects (areas) is performed in accordance with the number of selected objects in this territory. Areas usually are objects of administrative-territorial division (districts, cities, countries, etc.). As the researched data it can be objects of a layer "Public objects" (pharmacies, banks, hospitals and others).

For this type of connection, the objects for research should be selected on a map. Objects can be of any type.

By clicking the Filter button, it is necessary to select the administrative territories for which the cartograms will be built. After completion of customizing the composition of administrative territories, a statistical analysis is performed, as a result of which the values of the range boundaries are automatically calculated, according to the scale of irregular ranges. The scale of irregular ranges contains a series of "40" round numbers (from -10 million to 10 million).

For OpenStreetMap maps, a List of topics has been generated that allow to speed up the construction of typical thematic maps. Theme parameters are formed on the basis of the objects of the open map in accordance with the map classifier. For the map5000m.rsc classifier, the list of topics is contained in the file c:\Users\Public\Documents\Panorama\Thematic\map5000m.theme.

The map5000m.theme file contains three topics for customizing the "Creation of thematic map" dialog:

- public objects in area territory;

- public objects on the territory of the administrative region;

- public objects in territory of city area.

Public objects are the selected map objects for which statistics are calculated. Each theme has a filter for administrative territories, a palette, a list of ranges, and legend settings.

7.  Coloring by distance from selected objects

In this case the coloring of areal objects (polygons) is carried out in accordance with the distance from the selected objects.

Polygons for coloring are set by the Filter button. The objects for coloring can be forests, forest and urban areas. The distance to objects specified in the filter from all selected map objects is measured. Graphic images are built according to the minimum distances between objects. For this mode, the range limits are set according to the scale of irregular ranges.

8. Coloring by unique values ​​of semantics

In this mode a coloring of the areal objects with identical value of chosen semantics into one color is carried out. Unlike other modes of construction, this mode allows you to carry out construction for any type of semantics, including for symbolical semantics.

After procedure execution in a dialog window on the "Data" bookmark, the real minimum and maximum values ​​are displayed. It is possible to change settings for the fields "Gradation", "Minimum" and "Interval" on the "Image" bookmark and to repeat the procedure