{"id":240,"date":"2017-10-20T18:58:21","date_gmt":"2017-10-20T18:58:21","guid":{"rendered":"https:\/\/learn.hydrologystudio.com\/stormwater-studio\/?post_type=ht_kb&#038;p=240"},"modified":"2026-04-04T14:14:22","modified_gmt":"2026-04-04T14:14:22","slug":"importing-idf-data","status":"publish","type":"ht_kb","link":"https:\/\/learn.hydrologystudio.com\/stormwater-studio\/knowledge-base\/importing-idf-data\/","title":{"rendered":"Importing IDF Data From NOAA"},"content":{"rendered":"\n<p>Provided your state is one which is listed on NOAA Atlas 14, you can quickly import this data by first exporting it from NOAA&#8217;s Precipitation Frequency Data Server. To start, click the [NOAA] button on the Ribbon Toolbar to open the web server.<\/p>\n\n\n\n<figure class=\"wp-block-image is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"61\" height=\"60\" src=\"https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/NOAABut.png\" alt=\"\" class=\"wp-image-242\" srcset=\"https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/NOAABut.png 61w, https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/NOAABut-50x50.png 50w, https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/NOAABut-60x59.png 60w\" sizes=\"auto, (max-width: 61px) 100vw, 61px\" \/><\/figure>\n\n\n\n<p>Then select your state and then move the red cross hair to your exact location.<\/p>\n\n\n    \t\t<div class=\"hts-messages hts-messages--alert   hts-messages--withicon \"   >\r\n    \t\t\t    \t\t\t    \t\t\t\t<p>\r\n    \t\t\t\t\t\u00a0Be sure to set the Data type to &#8220;precipitation intensity&#8221; as shown below.\u00a0    \t\t\t\t<\/p>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div><!-- \/.ht-shortcodes-messages -->\r\n    \t\t\n\n\n\n<figure class=\"wp-block-image is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"563\" height=\"61\" src=\"https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/NOAA2.png\" alt=\"\" class=\"wp-image-228\" srcset=\"https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/NOAA2.png 563w, https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/NOAA2-300x33.png 300w, https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/NOAA2-50x5.png 50w, https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/NOAA2-60x7.png 60w, https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/NOAA2-100x11.png 100w\" sizes=\"auto, (max-width: 563px) 100vw, 563px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"635\" height=\"562\" src=\"https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/NOAAMap.png\" alt=\"\" class=\"wp-image-1657\" srcset=\"https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/NOAAMap.png 635w, https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/NOAAMap-300x266.png 300w, https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/NOAAMap-50x44.png 50w, https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/NOAAMap-60x53.png 60w, https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/NOAAMap-100x89.png 100w\" sizes=\"auto, (max-width: 635px) 100vw, 635px\" \/><\/figure>\n\n\n\n<p>At the bottom of the screen will be a table populated with your IDF data. You&#8217;ll see an option to export as a .csv file.<\/p>\n\n\n\n<figure class=\"wp-block-image is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"549\" height=\"46\" src=\"https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/NOAA3.png\" alt=\"\" class=\"wp-image-241\" srcset=\"https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/NOAA3.png 549w, https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/NOAA3-300x25.png 300w, https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/NOAA3-50x4.png 50w, https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/NOAA3-60x5.png 60w, https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/NOAA3-100x8.png 100w\" sizes=\"auto, (max-width: 549px) 100vw, 549px\" \/><\/figure>\n\n\n\n<p>Click [Submit]. Then choose &#8220;Save As&#8221; from the dialog box and save this file as a .txt or .csv file, preferably in your Stormwater Studio &gt; Rainfall folder.<\/p>\n\n\n\n<figure class=\"wp-block-image is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"963\" height=\"82\" src=\"https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/SaveNOAAIntensity.png\" alt=\"\" class=\"wp-image-980\" srcset=\"https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/SaveNOAAIntensity.png 963w, https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/SaveNOAAIntensity-300x26.png 300w, https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/SaveNOAAIntensity-768x65.png 768w, https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/SaveNOAAIntensity-50x4.png 50w, https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/SaveNOAAIntensity-60x5.png 60w, https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/SaveNOAAIntensity-100x9.png 100w\" sizes=\"auto, (max-width: 963px) 100vw, 963px\" \/><\/figure>\n\n\n    \t\t<div class=\"hts-messages hts-messages--alert   hts-messages--withicon \"   >\r\n    \t\t\t    \t\t\t    \t\t\t\t<p>\r\n    \t\t\t\t\tDo not open in a spreadsheet and resave as this may modify the file format.    \t\t\t\t<\/p>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div><!-- \/.ht-shortcodes-messages -->\r\n    \t\t\n\n\n\n<p>Next, click the [Import] button on the Stormwater Studio IDF Curves Wizard screen.<\/p>\n\n\n\n<figure class=\"wp-block-image is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"779\" height=\"394\" src=\"https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/RainfallExist.png\" alt=\"\" class=\"wp-image-232\" srcset=\"https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/RainfallExist.png 779w, https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/RainfallExist-300x152.png 300w, https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/RainfallExist-768x388.png 768w, https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/RainfallExist-50x25.png 50w, https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/RainfallExist-60x30.png 60w, https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/RainfallExist-100x51.png 100w\" sizes=\"auto, (max-width: 779px) 100vw, 779px\" \/><\/figure>\n\n\n\n<p>Select the file you just saved and click [Open]. Then Click [Apply].&nbsp;Then click [Finish]. You&#8217;ll be taken back to the initial IDF Wizard screen where you&#8217;ll see your new IDF curves.<\/p>\n\n\n\n<figure class=\"wp-block-image is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"1008\" height=\"682\" src=\"https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/RainfallIDFGraph.png\" alt=\"\" class=\"wp-image-1881\" srcset=\"https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/RainfallIDFGraph.png 1008w, https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/RainfallIDFGraph-300x203.png 300w, https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/RainfallIDFGraph-768x520.png 768w, https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/RainfallIDFGraph-50x34.png 50w, https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/RainfallIDFGraph-60x41.png 60w, https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-content\/uploads\/sites\/3\/2017\/10\/RainfallIDFGraph-100x68.png 100w\" sizes=\"auto, (max-width: 1008px) 100vw, 1008px\" \/><\/figure>\n\n\n\n<p><strong>Save your curves<\/strong> by clicking the [Save] button and specifying a name for your file. An IDF extension will be applied. This file will automatically open each time you launch Stormwater Studio. You can, of course, change this file any time afterwards.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"troubleshooting-idf-curves\">Troubleshooting IDF Curves<\/h2>\n\n\n\n<p>If the import fails and you receive the message, &#8220;This file is in the wrong format&#8221;, it may indicate that you have selected Precipitation <strong>depth<\/strong> instead of Precipitation <strong>intensity <\/strong>as the data type in NOAA. This can also be the result of opening and resaving the csv file in Excel, which will modify the file contents.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">NOAA Atlas 14 Data May Require Smoothing<\/h3>\n\n\n\n<p>There may be occasions when the resulting curves do not exactly match the imported data. The software&nbsp;manipulates your input data to generate coefficients B, D &amp; E, for use in an Intensity vs. Tc equation. In other words the data must plot straight on log\/log scale. If it does not, the software will make adjustments to the data so that the data fits the equation.<\/p>\n\n\n\n<p>These adjustments are always within the lower and upper bounds of the 90% confidence interval as shown on the NOAA data tables. Keep in mind that NOAA generates this data from interpolating data points on a GIS grid and this will produce some irregularity as described below.<\/p>\n\n\n\n<p>Each duration in NOAA Atlas 14 was analyzed separately. For example, the 30-minute value for each frequency was extracted and analyzed for precipitation-frequency. Then the 60-minute value for each frequency was extracted and analyzed for precipitation-frequency. And so-on. Each value has a calculated mean, standard deviation, and skew.&nbsp; No attempt was made to smooth these data across the series of durations for each return period. Thus the NOAA data will exhibit some irregularities.<\/p>\n\n\n\n<p>You can make adjustments to the derived coefficients yourself in order to sway the curve in one direction or the other. For example, if the fitted curve is higher than the original data, adjust the D coefficient upwards until you are satisfied with the results. Do this by following the procedures&nbsp;<a href=\"https:\/\/learn.hydrologystudio.com\/stormwater-studio\/knowledge-base\/using-known-equation-coefficients\/\">here<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Creating Your Own Rainfall Equation Coeficients<\/h3>\n\n\n\n<p>If it is crucial for your data to exactly align with the original data points, you can employ the charting capabilities in Microsoft Excel. By doing so, you can generate your own coefficients for use in Stormwater Studio\u2019s Third-degree Polynomial equation. <a href=\"https:\/\/learn.hydrologystudio.com\/stormwater-studio\/knowledge-base\/create-idf-equation-coefficients\/\">Please see this article for instructions<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">File Contents<\/h2>\n\n\n\n<p>If you open this file in your web browser, or other text viewer, it will look similar to the following:<\/p>\n\n\n\n<p>Point precipitation frequency estimates (inches\/hour)<br>NOAA Atlas 14, Volume 2, Version 3<br>Data type: Precipitation intensity<br>Time series type: Partial duration<br>Project area: Ohio River Basin<br>Latitude (decimal degrees): 33.8000<br>Longitude (decimal degrees): -81.0000<\/p>\n\n\n\n<p>PRECIPITATION FREQUENCY ESTIMATES<br>by duration for ARI:, 1,2,5,10,25,50,100,200,500,1000 years<br>5-min:, 5.51,6.37,7.26,8.17,9.19,10.04,10.86,11.65,12.62,13.51<br>10-min:, 4.40,5.09,5.81,6.54,7.32,8.00,8.63,9.23,9.98,10.64<br>15-min:, 3.66,4.27,4.90,5.52,6.18,6.76,7.27,7.77,8.38,8.90<br>30-min:, 2.51,2.95,3.48,4.00,4.58,5.09,5.57,6.05,6.66,7.21<br>60-min:, 1.57,1.85,2.23,2.60,3.05,3.45,3.83,4.24,4.78,5.26<br>2-hr:, 0.90,1.07,1.30,1.54,1.83,2.10,2.37,2.67,3.06,3.43<br>3-hr:, 0.63,0.75,0.92,1.10,1.32,1.53,1.75,1.98,2.32,2.63<br>6-hr:, 0.38,0.45,0.55,0.65,0.79,0.91,1.05,1.19,1.40,1.60<br>12-hr:, 0.22,0.26,0.32,0.38,0.46,0.54,0.62,0.72,0.85,0.97<br>24-hr:, 0.12,0.15,0.19,0.22,0.27,0.32,0.36,0.42,0.50,0.57<br>2-day:, 0.07,0.09,0.11,0.13,0.16,0.18,0.21,0.24,0.28,0.32<br>3-day:, 0.05,0.06,0.08,0.09,0.11,0.13,0.14,0.16,0.19,0.22<br>4-day:, 0.04,0.05,0.06,0.07,0.09,0.10,0.11,0.13,0.15,0.17<br>7-day:, 0.03,0.03,0.04,0.05,0.06,0.06,0.07,0.08,0.09,0.10<br>10-day:, 0.02,0.03,0.03,0.04,0.04,0.05,0.05,0.06,0.07,0.08<br>20-day:, 0.01,0.02,0.02,0.02,0.03,0.03,0.03,0.04,0.04,0.04<br>30-day:, 0.01,0.01,0.02,0.02,0.02,0.02,0.03,0.03,0.03,0.03<br>45-day:, 0.01,0.01,0.01,0.02,0.02,0.02,0.02,0.02,0.02,0.02<br>60-day:, 0.01,0.01,0.01,0.01,0.01,0.02,0.02,0.02,0.02,0.02<\/p>\n\n\n\n<p>Date\/time (GMT): Tue OCT 20 20:02:01 2017<br>pyRunTime: 0.0222988128662<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Describes how to import IDF data from the latest NOAA Atlas 14.<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[25],"ht-kb-tag":[54],"class_list":["post-240","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-rainfall-idf-curves","ht_kb_tag-this-file-is-in-the-wrong-format"],"_links":{"self":[{"href":"https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-json\/wp\/v2\/ht-kb\/240","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-json\/wp\/v2\/comments?post=240"}],"version-history":[{"count":17,"href":"https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-json\/wp\/v2\/ht-kb\/240\/revisions"}],"predecessor-version":[{"id":2915,"href":"https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-json\/wp\/v2\/ht-kb\/240\/revisions\/2915"}],"wp:attachment":[{"href":"https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-json\/wp\/v2\/media?parent=240"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-json\/wp\/v2\/ht-kb-category?post=240"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/learn.hydrologystudio.com\/stormwater-studio\/wp-json\/wp\/v2\/ht-kb-tag?post=240"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}