[Met_help] [rt.rap.ucar.edu #65985] History for Question about Point-Stat

[John Halley Gotway via RT]

----------------------------------------------------------------
  Initial Request
----------------------------------------------------------------

I'm importing the Point-Stat MPR output file into MS Access and find that it would be nice to understand the way that Point-Stat writes the MPR file. Can you provide me the formatted write statements which produce the MPR file output or point me to the location in the software distribution (V4.1) where I can find the write statements?

Thanks.

R/
John


Mr John W. Raby, Meteorologist

U.S. Army Research Laboratory

White Sands Missile Range, NM 88002

(575) 678-2004 DSN 258-2004

FAX (575) 678-1230 DSN 258-1230

Email: john.w.raby2.civ at mail.mil<mailto:john.raby at us.army.mil>


----------------------------------------------------------------
  Complete Ticket History
----------------------------------------------------------------

Subject: Re: [rt.rap.ucar.edu #65985] Question about Point-Stat
From: John Halley Gotway
Time: Wed Mar 26 10:15:35 2014

John,

We use a class in the MET source code called "AsciiTable" which is
defined in METv4.1/src/basic/vx_util/ascii_table.h (and .cc).  However
I really don't think that's what you need, and it likely won't
be much help to you.  Point-Stat loads up its output statistics into
the AsciiTable class, it calls some formatting operations for that
class(like setting significant digits, column justification, and
inter-row and inter-column spacing), and then that class writes the
output file.  The main point of it is to get the output columns to
line up nicely.  For example, if your model name is very long,
it'll adjust the spacing of the output columns to keep everything
lined up.  That makes it more readable.

I'm guessing you were hoping to see a single print statement that
prescribes the width of each output column.  We don't do that, the
width of each column depends on the number of characters in the
column.  So the output columns are delimited by one or more spaces.
What sort of formatting is required for reading data in MS Access?

If MS Access can't handle the current output files delimited by one or
more spaces, my suggestion would be to run a simple reformatting step
before loading data.  For example, if it expects a single
space between each column, the following 'sed' command would do it:

   cat point_stat_360000L_20070331_120000V_cnt.txt | sed -r 's/ +/ /g'

That just replaces one or more spaces with a single space.  Or you
could substitute in a comma (sed -r 's/ +/,/g') to make it a csv file.

Hope that helps.

Thanks,
John

On 03/25/2014 03:52 PM, Raby, John W USA CIV via RT wrote:
>
> Tue Mar 25 15:52:20 2014: Request 65985 was acted upon.
> Transaction: Ticket created by john.w.raby2.civ at mail.mil
>         Queue: met_help
>       Subject: Question about Point-Stat
>         Owner: Nobody
>    Requestors: john.w.raby2.civ at mail.mil
>        Status: new
>   Ticket <URL:
https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=65985 >
>
>
> I'm importing the Point-Stat MPR output file into MS Access and find
that it would be nice to understand the way that Point-Stat writes the
MPR file. Can you provide me the formatted write statements which
produce the MPR file output or point me to the location in the
software distribution (V4.1) where I can find the write statements?
>
> Thanks.
>
> R/
> John
>
>
> Mr John W. Raby, Meteorologist
>
> U.S. Army Research Laboratory
>
> White Sands Missile Range, NM 88002
>
> (575) 678-2004 DSN 258-2004
>
> FAX (575) 678-1230 DSN 258-1230
>
> Email: john.w.raby2.civ at mail.mil<mailto:john.raby at us.army.mil>
>

------------------------------------------------