Reformat Multi-gage File
Previous Topic  Next Topic 

This option converts a precipitation data file in NetSTORM yyyy mm dd format containing multiple gages into either a cross-tabbed file or individual files for each gage, or unravels a cross-tabbed file.

 

A multigage file might be created in order to perform IDF analysis for many gages at once. It would look like the example below for gages 120 and 666:

 

  120 1999 11 27  5  0 0.2000

  120 1999 11 27  7  0 0.1000

  120 1999 11 27  8  0 0.1000

  120 1999 11 27  9  0 0.2000

  666 1999 11 27  6  0 0.1500

  666 1999 11 27  7  0 0.0500

  666 1999 11 27  8  0 0.0500

  666 1999 11 27  9  0 0.2000

 

NetSTORM can reformat the multi-gage file into a cross-tab format as in the example below:

 

;Gage IDs                120   666

    2 1999 11 27  5  0  0.20  0.00

    2 1999 11 27  6  0  0.00  0.15

    2 1999 11 27  7  0  0.10  0.05

    2 1999 11 27  8  0  0.10  0.05

    2 1999 11 27  9  0  0.20  0.20

 

This format is used by NetSTORM's Analyze|NetSTORM module when multiple rain gages are used. It is also useful for auditing precipitation data, such as graphing it in a spreadsheet.

 

NetSTORM can also break the multi-gage file into one file for each gage. The output files are assigned the name GageXXX.dat (where XXX = each gage number) and put into the folder specified under Edit|Options|Output File Location.

 

To un-crosstab a file, the number of gages must be specified in the gage ID column. The unraveled data are assigned gage IDs based on their column number in the cross-tabbed file.