Data Entry, Import and Export > Importing NCDC Data


Recognized NCDC Formats

The plug-in has been tested with NCDC 3200, 3210, 3220, 3240 and 3260 formats in all forms.  It has also been tested with LCD, GSOD and 3505 delimited formats.  It will not import data from non-delimited LCD, GSOD and 3505 formats.  If you have a choice for your format, we recommend comma delimited with station names. Many of the parameter types in 3200, 3220, LCD, GSOD and 3505 formats do not have the units or type assigned by the importer and they may need to be edited in later, if needed.

Examples of these formats are:

  1. 3240 Comma Delimited:
    COOPID,CD,ELEM,UN,YEAR,MO,DA,TIME,HOUR01,F,F,TIME,HOUR02…
    ------,--,----,--,----,--,--,----,------,-,-,----,------
    041112,00,HPCP,HI,1970,09,01,0100, 00000,g, ,0200, 00000,…
    041112,00,HPCP,HI,1970,09,04,0100, 00000, , ,0200, 00000,… 041112,00,HPCP,HI,1970,10,01,0100, 00000,g, ,0200, 00000,…
    …
      
  2. 3240 Space Delimited with Station Name:
    COOPID STATION NAME                   CD ELEM UN YEAR MO DA TIME HOUR01
    ------ ------------------------------ -- ---- -- ---- -- -- ---- ------041112 BROOKS FARNHAM RANCH           00 HPCP HI 1970 09 01 0100  00000
    041112 BROOKS FARNHAM RANCH           00 HPCP HI 1970 09 04 0100  00000 041112 BROOKS FARNHAM RANCH           00 HPCP HI 1970 10 01 0100  00000
    …
       
  3. 3240 fixed:
    HPD04111200HPCPHI19700900010010100 00000g
    HPD04111200HPCPHI19700900010012500 00000 
    HPD04111200HPCPHI19700900040011900 00005 
    HPD04111200HPCPHI19700900040012500 00005 
    HPD04111200HPCPHI19701000010010100 00000g32
     
  4. 40 variable:HPD
    04111200HPCPHI19701000010020100 00000g 2500 00000 HPD04111200HPCPHI19701000180080400 00003  0500 00010  0600 00012  HPD04111200HPCPHI19701000200030100 99999[ 1200 99999] 2500 00000I
    …
       
  5. 3260 Comma Delimited with Station Name and html headings:
    <META http-equiv=Content-Type content="text/html; charset=utf-8"></HEAD>
    <BODY><PRE>COOPID,STATION NAME                  ,CD,ELEM,UN,YEAR,MO,DA,TIME, VALUE,F,F
    ------,------------------------------,--,----,--,----,--,--,----,------,-,-
    040897,BLUE CANYON                   ,00,QPCP,HI,1985,08,01,0015, 00000,g,
    040897,BLUE CANYON                   ,00,QPCP,HI,1985,08,01,2500, 00000, ,
    040897,BLUE CANYON                   ,00,QPCP,HI,1985,08,17,1500, 00003, ,
    040897,BLUE CANYON                   ,00,QPCP,HI,1985,08,17,1600, 00008, ,
      
  6. 3260 Variable with html headings:
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
    <HTML><HEAD>
    <META http-equiv=Content-Type content="text/html; charset=utf-8"></HEAD>
    <BODY><PRE>15M04089700QPCPHI19850800010020015 00000g 2500 00000 
    15M04089700QPCPHI19850800170041500 00003  1600 00008  1700 00002  2500 00013 
    15M04089700QPCPHI19850800290051700 00004  1800 00011  1900 00003  2000 00002  2500 00020 
    15M04089700QPCPHI19850800300021200 00001  2500 00001 
    15M04089700QPCPHI19850900010020015 00000g 2500 00000 
         
  7. 3260 Fixed with html headings:
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
    <HTML><HEAD>
    <META http-equiv=Content-Type content="text/html; charset=utf-8"></HEAD>
    <BODY><PRE>15M04089700QPCPHI19850800010020015 00000g
    15M04089700QPCPHI19850800010022500 00000 
    15M04089700QPCPHI19850800170041500 00003 
    15M04089700QPCPHI19850800170041600 00008 
    15M04089700QPCPHI19850800170041700 00002
        
  8. 3200 Delimited:
    COOPID,WBANID,Prelim,year,month,day,Tmax,Tmin,Tobs,Tmean,Cdd,Hdd,Prcp,Flag
    042294,99999, ,1989,12,29,56,37,46,47,0,18,0, ,0, ,0
    042294,99999, ,1989,12,30,65,33,37,49,0,16,0, ,0, ,0
    042294,99999, ,1989,12,31,52,30,32,41,0,24,0, ,0, ,0,42.8,53.0,32.6,65,25,0,636,0.03,0 
       
  9. 3200 Fixed:
    DLY29002201SNWD I19480399990310118 00005 10218 00005 10318 00012 10418 00016 10518 00016
    DLY29002201DYSWNA19480499990310199-99999M 0218 01100 10318 01100 10499-99999M 0518 01100   DLY29002201PRCPHI19480499990310118 00000 10218 00000 10318 00000 10418 00000 10518 00000 
        
  10. 3210 Fixed:
    DLY00003017F2MNMD200401A1990310124 21018 00224 04020 00324 13023 00424 31018 00524 DLY00003017F5SCMD200401A1990310124 21023 00224 05022 00324 13025 00424 31022 00524   DLY00003017FMTMHR200401A1990310124 01810 00224 01258 00324 01341 00424 01551 00524 
       
  11. 3220 Fixed:
    MLY04111202CLDD D19859999990060100 00000  0200 00003  0300 00000  0400 00032B MLY04111202DP01NA19859999990060100 00002  0200 00002  0300 00008  0400 00000  MLY04111202DP05NA19859999990060100 00000  0200 00001  0300 00001  0400 00000 
      
  12. 3220 Delimited:
    COOPID,WBNID,CD,ELEM,UN,YEAR,A,S,MO,DA,  JAN ,F,F,MO,DA,  FEB ,F,F,MO,DA,  MAR
    ------,-----,--,----,--,----,-,-,--,--,------,-,-,--,--,------,-,-,--,--,------041112,99999,02,CLDD, D,1985,9,9,01,00, 00000, , ,02,00, 00003, , ,03,00, 00000
    041112,99999,02,DP01,NA,1985,9,9,01,00, 00002, , ,02,00, 00002, , ,03,00, 00008
      
  13. LCD Delimited:
    Month:, 12/2004
    Station Name:, "LOS ANGELES INTERNATIONAL AIRPORT" Call Sign:, LAX
    Day,Time,StationType,Maint Indic,SkyConditions,Visibility,Weather Type,Dry Bulb 01,0050,AO2 ,-,CLR ,10SM   ,-,46   ,   7.8,40   ,   4.3,31   ,   -.6, 56 , 3   ,VRB,-, 01,0150,AO2 ,-,CLR ,10SM   ,-,46   ,   7.8,38   ,   3.5,27   ,  -2.8, 47 , 0   ,000,-, 01,0250,AO2 ,-,CLR ,10SM   ,-,45   ,   7.2,36   ,   2.3,22   ,  -5.6, 40 , 5   ,010,-,
          
  14. LCD Delimited:
    Month:,09/2002
    Station Name:, ASHEVILLE REGIONAL AIRPORT (AVL)
    DT,Hr1, Hr2, Hr3, Hr4, Hr5, Hr6, Hr7, Hr8, Hr9, Hr10, Hr11, Hr12, Hr13, Hr14, Hr15,
    1,----,----,T   ,----,----,----,----,----,----,----,----,----,----,----,----,----,----
    15,.05,.02,.03,.06,.01,.02,.02,T   ,.01,T   ,.02,.09,.06,.02,.04,.05,.01,T   ,.01,T 
    ---,----,----,----,----,----,----,----,----,----,----,----,----,----,----,----,----
             
  15. GSOD Delimited
    STN---  YEARMODA    TEMP       DEWP      SLP        STP       VISIB      WDSP     MXSPD   010010  20000501    33.2  8    29.9  8  1013.4  8  1012.3  8    8.6  6    4.5  8   13.0  010010  20000502    29.4  8    26.5  8  1015.0  8  1013.8  8    4.1  6    5.7  8   12.0  010010  20000503    31.3  8    28.7  8  1015.0  8  1013.8  8    6.0  6    2.2  8    5.1  010010  20000504    32.3  8    29.8  8  1000.4  8   999.2  8    2.4  5    8.3  8           
  16. 3505 Delimited:
    AWS  WBAN YR--MODAHRMN DIR SPD GUS CLG SKC L M H  VSB WW WW WW W TEMP DEWP    SLP   722280 13876 200301010053 140  11 ***  49 OVC * * * 10.1 00 ** ** *   59   54 1003.8 722280 13876 200301010153 140  13 ***  25 OVC * * *  2.5 63 10 ** *   57   54 1003.7 722280 13876 200301010253 170  14  21  14 OVC * * *  3.0 63 10 ** *   57   55 1003.7