map2col
Converts from PCRaster map format to column file format
map2col [options] PCRmap1 PCRmap2....PCRmapN columnfile
--unittrue or --unitcell
coordinate positions:
columnnumbers
-m nodatavalue
nodatavalue is the value in columnfile which is converted to a missing value on PCRresult. It can be one ascii character (letters, figures, symbols) or a string of ascii charaters. For instance: -m -99.98 or -m ! or -m j5w. Default, if this option is not set, 1e31 is recognized as a missing value.
| -M | Default, if PCRmap1 has a missing value in a cell, the cell is not saved in columnfile. If the option -M is set these cells are saved in columnfile. They are assigned the nodatavalue. |
-s seperator
By default, whitespace (one or more tabs, spaces) is recognized as separator between the values of a row in the columnfile. If the values are separated by a different separator, you can specify it with the option. The separator can be one of the ascii characters (always one). In that case, col2map recognizes the specified separator with or without whitespace as separator. For instance, if the values in columnfile are separated by a ; character followed by 5 spaces, specify -s ; in the command line (you do not need to specify the whitespace characters).
specifying format of columnfile
| -p | columnfile is in plain format without header (default) |
| -g | columnfile is in simplified Geo-EAS format. |
row wise or column wise output
| -r | row wise output (default). The cell values in the first row onnPCRmap1, PCRmap2,...PCRmapn will be at the top of the columnfile, underneath the cells in the second row, etc. |
| -c | column wise output. The cell values in the first column onnPCRmap1, PCRmap2,...PCRmapn will be at the top of the columnfile, underneath the cells in the second column, etc. |
-a inputcolumnfile
append mode. The inputcolumnfile is the name of the column file to which the data are appended. The file with the appended data is saved as columnfile. See operation in append mode below.
Maps of scalar and directional data type are always printed in the C-type format 11.6g, also used in the C programming language: the precision the data are saved on columnfile corresponds with the precision they are available on PCRmap, with the restriction that the maximal number of significant figures which can be saved on columnfile is six per cell value. The maximum and minimum value which can be saved is 1099 and -1099 respectively; a notation with base10 exponents is used if the value is larger than 106 or smaller than -106.
Examples:
PCRmap columnfile
-894.41000 -894.41
-5674935 -5.67494e+06
453628190.6 4.53628e+08
0.000000000031 3.1e-11
-0.02000012 -0.0200001
-1.0200001 -1.02
If you want to prevent the usage of base 10 exponents for scalar or directional data use the C-type format f and specify -f a.df, where a and d must be whole numbers equal to or larger than 0. The value d is the number of decimal figures which will be used for each cell value, the value a is the minimal total number of positions used for each value; if more positions are needed (large values), more positions are used.
Examples:
C-typeformat PCRmap columnfile
5.6f 1234.1981 1234.198100
5.3f 1234.1981 1234.198
5.0f 1234.1981 1234
3.1f 1234.1981 1234.2
15.6f 1234.1981 1234.1981
2.1f 1289128932.75 1289128932.7
You can also specify other C-type formats, see for description of these formats a C programming language standard work.
Operation if PCRmap1, PCRmap2,...PCRmapn have corresponding location attributes:
In most cases only one PCRmap1 is given in the command line or several maps PCRmap1, PCRmap2,...PCRmapn are given which have the same location attributes. In these cases, the operation is performed as follows. The PCRaster expression(s) PCRmap1, PCRmap2,...PCRmapn are converted to columnfile, which is an ascii file in column format. Each line in this columnfile represents one cell on PCRmap1, PCRmanp2,...PCRmapn. The x and y coordinates of the cells will be in the column numbers specified by the options -x columnumberx and -y columnnumbery. The cell values of PCRmap1 will be in the first ‘empty’ column, the values of PCRmap2 in the next column etc. For instance if you set -x 2 -y 3, values of PCRmap1 are written in the first column, values of PCRmap2 in the fourth, values of PCRmap3 in the fifth etc.
Operation if PCRmap1, PCRmap2,...PCRmapn have different location attributes:
If more than one PCRmap is given in the command line and the given maps have different location attributes (with the exception of the projection which must be the same) the operation is performed in a somewhat different way. Only the x, y coordinates of the first map PCRmap1 are printed in columnfile. Real world coordinates or cell coordinates are printed, as specified by the option --unittrue, --unitcell; the coordinate position that is printed is specified by the option --coorul, --coorlr, --coorcentre. The cell values are printed as follows: first, each x, y coordinate pair is supplemented with its cell value of PCRmap1. Than, each line in columnfile is supplemented with the cell values of the remaining maps PCRmap2,...PCRmapn. No new lines are appended for these maps. For each of these maps and each line, the cell value is printed of the cell which has a real world location that corresponds with the real world location of the PCRmap1 cell that is already printed on that line. The real world location corresponds if the real world x,y coordinate of the PCRmap1 cell comes into the cell of the PCRmap2,...PCRmapn under consideration (the x,y coordinate of upper left corner, lower right corner or centre of each PCRmap1 cell is used, as specified by the --coorcentre, --coorlr, --coorcentre option). A line on the columnfile that represents a PCRmap1 cell with a real world x,y coordinate that does not come into a cell on the PCRmap2,...PCRmapn under consideration is assigned a missing value in the appended field.
Data can also be appended to an existing column file inputcolumnfile. This columnfile may be a plain column file without a header or a column file in simplified Geo-EAS format. These formats don’t need to be specified, the map2col operator will detect the format of inputcolumnfile itself. For the append mode, the option -a inputcolumnfile is used. The inputcolumnfile is the name of the column file to which the data are appended. The file with the appended data is saved as columnfile. The data are appended as follows: each line (record) of the inputcolumnfile is supplemented with the PCRmap1, PCRmap2,...PCRmapn values of the cell in which the x,y coordinates of the line (record) are. On each line, the values of PCRmap1, PCRmap2,...PCRmapn will be typed in the order they are specified in the command line (i.e. PCRmap1 values are printed in the first column after the columns in the inputfile, PCRmap2 in the second column, etc.).
The append mode results in the appending of columns only, no lines will be appended: a cell on PCRmap1, PCRmap2,...PCRmapn without a x,y coordinate in the inputcolumnfile that comes into the cell will not be saved in a new line (record). A line (record) on inputcolumnfile with a x,y coordinate that does not come into a cell on PCRmap1, PCRmap2,...PCRmapn is assigned a missing value in the appended column(s).
In append mode the options -M, -r, -c, -p and -g must not be used. The other options can be used as normal, but the default values will be appropriate in almost any case; the flags -m, -f and -s will only affect the columns which are appended. The options --coorcentre, --coorul and --coorlr have the following meaning when used in append mode:
This operation belongs to the group of Creation of PCRaster maps