Flow Map Data Inputguide > Flow Map eXplorer > Flow Map Data Input
- Flow Data
- Regional Data
The main data input of the flow map application is a flow data file which can be stored in one of the following formats.
Format 1 -Interaction table formatIn this format, flow data is stored as a matrix. Data of one time step is stored in one work sheet of an excel file. The first cell in the first column stores flow type name and unit if needed (e.g. "Migration (persons)" or "Migration (persons)"). The first column stores the DBF-codes (values in ID field in DBF file) of source region and the first row stores the DBF-codes of destination regions. The figure below shows an example of flow data which are stored in interaction table format.
Format 2 - eXplorer Unicode format.This format is the same format used in eXplorer. The second column stores the DBF-codes of source regions and the third column stores the DBF-codes of destination regions. Next columns store values of flows from source regions to destination regions. With this format, the user can store more than one flow data type in one file. For example the user can store commuting data of men and women in one file, which we cannot do it with the interaction table format. Figure 10 shows an example of flow data stored in eXplorer Unicode format.
Important note: Flow data in this format can be saved as an Excel file (.xls or .xlsx) or a Unicode text file (.txt) through Microsoft Excel.
Format 3 - Csv formatThis format stored flow data in a way which supports fast data reading of large datasets. Flow data in this format is saved as csv files. To be able to use this format, the user can use our online conversion tool to convert Excel flow data files in interaction table format as mentioned above or in three-column list format (as described below) to Csv format.Three-column list format is a format in which we stores flow data in three columns. The first column stores DBF-codes of source regions, the second column stores DBF-codes of destination regions and the third column stores values of flows from source regions to destination regions. Data of one time step is stored in one work sheet of an excel file.
To support the user in analysis of flow data, the application allows the user to read in a regional data file. This file is optional and should be in eXplorer Unicode format.