RINEX to Tabular Output

Standard Output

The tabular observations output allows to output a RINEX observations input file into a data table that can be used for simple visualization or for an easier introduction into third-party applications like EXCEL, Matlab, etc... All main options like satellite system selection (-satsys) and/or satellites selection (-prn) and/or observation types selection (-obs_types) and others are supported. It can be used for all RINEX data types (OBS, MET, NAV).

The tabular observation output can be initiated via the -tab command line parameter. Here is an example for a single satellite and selected observation types:

Tabular OBS data

gfzrnx -finp POTS00DEU_R_20150070000_01D_30S_MO.rnx -tab -fout POTS00DEU_2015007_G03.tab
gfzrnx -finp POTS00DEU_R_20150070000_01D_30S_MO.rnx -tab -fout POTS00DEU_2015007_G03.tab -prn G03 -obs_types L1,L2  

The last command leads to the following default tabular output, extracting phase observations for the PRN G03:

#HD G DATE          TIME          PRN        L1C            L1W            L2W            L2X
OBS G 2015-01-07 07:25:00.0000000 G03  134798128.476  134798125.823  105037501.328  105037506.181
OBS G 2015-01-07 07:25:30.0000000 G03  134629777.213  134629774.487  104906318.473  104906323.263
OBS G 2015-01-07 07:26:00.0000000 G03  134461452.299  134461449.545  104775156.193  104775160.914
OBS G 2015-01-07 07:26:30.0000000 G03  134293160.630  134293157.877  104644019.757  104644024.465
...

Every line begins with a line descriptor (#HD,OBS):

Line type	Description
#HD	header line with column description
OBS	observation line
NAV	navigation line
MET	meteo line

The first columns are fixed, showing the: + Line Type, + Satellite System, + Date, + Time, + PRN.

This is followed by the list of wished or given observation types as provided in the satellite system-specific header line order.

Tabular NAV Data

gfzrnx -finp *.rnx -fout RNX_C_CNV1.tab -f -vo 4 -tab -nt C::EPH:CNV1

The last command leads to the following tabular output, extracting only BDS EPH-records of message type CNV1

#HD S DATE          TIME          NAV PRN MTYP DATA ---------------
NAV C 2021-03-17    00:00:00      EPH C19 CNV1  7.642341079190e-04  1.389732773305e-11  0.000000000000e+00  2.871513366699e-03 ...
NAV C 2021-03-17    01:00:00      EPH C19 CNV1  7.642844575457e-04  1.394262483245e-11  0.000000000000e+00  2.720832824707e-03 ...
NAV C 2021-03-17    02:00:00      EPH C19 CNV1  7.643348653801e-04  1.396838200662e-11  0.000000000000e+00  2.270221710205e-03 ...
...

Here the same with a different column separator ';'.

gfzrnx -finp *.rnx -fout RNX_C_CNV1.tab -f -vo 4 -tab -tab_sep \; -nt C::EPH:CNV1

#HD;S;DATE;TIME;NAV;PRN;MTYP;DATA ---------------
NAV;C;2021-03-17;00:00:00;EPH;C19;CNV1; 7.642341079190e-04;1.389732773305e-11;0.000000000000e+00;2.871513366699e-03; ...
NAV;C;2021-03-17;01:00:00;EPH;C19;CNV1; 7.642844575457e-04;1.394262483245e-11;0.000000000000e+00;2.720832824707e-03; ...
NAV;C;2021-03-17;02:00:00;EPH;C19;CNV1; 7.643348653801e-04;1.396838200662e-11;0.000000000000e+00;2.270221710205e-03; ...
...

Tabular MET Data

This works similarly to OBS data.

Date/Time Formats

The Date/Time format can be controlled via the -tab_date , -tab_time command line parameters. The following pattern describes selected Date/Time formats:

Date Pattern	Example	Description
mjd	57029	Modified Julian Date (MJD)
ddd	007	day of year
wwwwd	18263	gps-week,weekday
wwww-d	1826-3	gps-week,weekday
yyyyddd	2015007	year, day of year
yyyy-ddd	2015-007	year, day of year
yyyymmdd	20150107	year, month, day of month
yyyy-mm-dd	2015-01-07	year, month, day of month
yymmdd	150107	2-digit year, month, day of month
yy-mm-dd	15-01-07	2-digit year, month, day of month

Time Pattern	Example	Description
hhmmss	013516.0000000	hour, minutes, seconds
hh:mm:ss	01:35:16.0000000	hour, minutes, seconds
sod	5716.0000000	seconds of day
fod	0.066157407407407	fractions of day

gfzrnx ... -tab_out -tab_date ddd -tab_time sod 

The Date/Time patterns ddd and sod used above, result in the output below.

#HD G DATE    TIME      PRN        L1C            L1W            L2W            L2X
OBS G 007 26700.0000000 G03  134798128.476  134798125.823  105037501.328 9999999999.999
OBS G 007 26730.0000000 G03  134629777.213  134629774.487  104906318.473  104906323.263
OBS G 007 26760.0000000 G03  134461452.299  134461449.545  104775156.193  104775160.914
OBS G 007 26790.0000000 G03  134293160.630  134293157.877  104644019.757  104644024.465
...

Column Separator

By default the column separator is the blank character. Using the -tab_sep command line parameter you can choose any character or even string for column separation. In case of the blank column separator all missing/empty data values are replaced by 9999999999.999, otherwise, they are just empty.

gfzrnx ... -tab_out -tab_date ddd -tab_time sod -tab_sep ','

The above command gives you a simple CSV output:

#HD,G,DATE,TIME,PRN,L1C,L1W,L2W,L2X
OBS,G,007,26700.0000000,G03,134798128.476,134798125.823,105037501.328,105037506.181
OBS,G,007,26730.0000000,G03,134629777.213,134629774.487,104906318.473,104906323.263
OBS,G,007,26760.0000000,G03,134461452.299,134461449.545,104775156.193,104775160.914
OBS,G,007,26790.0000000,G03,134293160.630,134293157.877,104644019.757,104644024.465
OBS,G,007,26820.0000000,G03,134124902.769,134124900.043,104512909.644,104512914.387