Continuous simulation

[RJOCE]

I'm looking into running some continuous simulations in InfoSWMM using several years of historical precipitation data. I've found several sources stating that .dat data obtained from NOAA's National Climatic Data Center (NCDC) is recognized and used by InfoSWMM, yet when I try it I get errors. Has anyone been successful running continuous simulations with data from the NCDC and how did you get it to work? Are there other sources of precipitation data that InfoSWMM can recognize and use for a continuous simulation? Any comments and tips would be greatly appreciated. Thanks.

[Robert Dickinson]

Hello RJOCE,
Unfortunately, NOAA keeps changing the format of its NCDC format and the format we read is from a few years ago. If you send me the data set you are trying to read to support at support@innovye.com I can show you how to make this a user defined time series.

since April 2012 NCDChas abandoned the DSI3240 format for hourly rainfall

Regards,
Bob Dickinson

Here is the User Defined Format

Station, year, month, day, hour, minute, rainfall or precipitation

den 2002 12 01 0 00 00 0
den 2002 12 01 1 00 00 0
den 2002 12 01 2 00 00 0
den 2002 12 01 3 00 00 0.00005

[RJOCE]

Thanks Bob. I just emailed you the sample data set.

[Robert Dickinson]

Hello RJOCE,
Just closure I wanted to mention for others that a user defined rainfall did work for you and

the NCDC data line that looks like this needs to be edited

COOP:427598 20000101 01:00 0

so that it looks like this and then it can be used in InfoSWMM, SWMM 5 and H2OMap SWMM

427598 2000 01 02 01 00 .00
427598 2000 01 02 02 00 .01
427598 2000 01 02 03 00 .03

[RJOCE]

Hi again. On a related note, is there a script that exists that could help me quickly convert from the original format to the required format? I will have to convert 25 years worth of data and it might be a bit tedious to do it all manually. Or are there any easier ways?

[Robert Dickinson]

Hello RJOCE,
I will send you an Excel example to do this but essentially use use the MID function to parse the data and make a user defined format
=@MID(+A1,6,6)
which will take this
COOP:427598 20000101 01:00 0
and make 427598 2000 01 02 01 00 .00
Regards,
Bob Dickinson

[RJOCE]

That would be great. Thank you very much.