注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

阿弥陀佛

街树飘影未见尘 潭月潜水了无声 般若观照心空静...

 
 
 

日志

 
 
关于我

一直从事气象预报、服务建模实践应用。 注重气象物理场、实况场、地理信息、本体知识库、分布式气象内容管理系统建立。 对Barnes客观分析, 小波,计算神经网络、信任传播、贝叶斯推理、专家系统、网络本体语言有一定体会。 一直使用Java、Delphi、Prolog、SQL编程。

网易考拉推荐

初始尺度设定为1km时54000站点,云南+四川(232)县客观分析花费时间测试  

2014-06-13 09:38:37|  分类: DOC |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |
获取加密站+国家站测站字典....
       select V01000 as c0_sta,V01000 as c1_nm,V05001 as c2_lat,V06001 as c3_lon,V07001 as c4_hgh from OBSERVE.ELE_AWST_SERVICE where to_number(C_BJTIME)=20140613090000 order by V01000
    
53942
取最近24小时最高最低温度记录---
       select V01000 as sta,
              min(V12001) as tmin, max(V12001) as tmax, sum(V13019) as r24
       from OBSERVE.ELE_AWST_SERVICE
       where to_number(C_BJTIME)>20140612090000 and to_number(C_BJTIME)<=20140613090000 and
             V12001 < 999999.0 and V13019 < 999999.0
       group by V01000
    
39482
取最近1小时记录---
       select C_BJTIME,V01000 as sta,V12001 as c00_t,0 as c01_tmin,0 as c02_tmax,V13019 as c03_r1,V13021 as c04_r6,V13022 as c05_r12,V13023 as c06_r24 from OBSERVE.ELE_AWST_SERVICE
       where to_number(C_BJTIME)=20140613090000
       order by V01000
    
53942
20140613090000,记录数53942
numRecords:53942
0,bs_cn,nrow:601,nCol:479,scale:0.1751153285554149,take:2749ms,
1,bs_ll,nrow:574,nCol:601,scale:0.16619723526290153,take:1900ms,
2,bs_ly,nrow:601,nCol:559,scale:0.15689759950173796,take:3628ms,
3,bs_sd,nrow:601,nCol:408,scale:0.13814457943876263,take:1739ms,
4,bs_tc,nrow:601,nCol:334,scale:0.2030803353210889,take:1524ms,
5,cx_cx,nrow:479,nCol:601,scale:0.14226775197385172,take:2706ms,
6,cx_dy,nrow:601,nCol:547,scale:0.1660324518363716,take:3284ms,
7,cx_lf,nrow:505,nCol:601,scale:0.14861142278337933,take:3577ms,
8,cx_md,nrow:595,nCol:601,scale:0.0,take:155ms,
9,cx_nh,nrow:601,nCol:597,scale:0.132706061758044,take:3082ms,
10,cx_sb,nrow:428,nCol:601,scale:0.16086736459115922,take:2437ms,
11,cx_wd,nrow:601,nCol:396,scale:0.12824823830515483,take:2496ms,
12,cx_ya,nrow:412,nCol:601,scale:0.12295393947842823,take:2283ms,
13,cx_ym,nrow:601,nCol:411,scale:0.14060451721212783,take:2128ms,
14,cx_yr,nrow:601,nCol:472,scale:0.17048423568232604,take:2830ms,
15,dh_lc,nrow:494,nCol:601,scale:0.11781430833999261,take:1484ms,
16,dh_lh,nrow:586,nCol:601,scale:0.0,take:151ms,
17,dh_ms,nrow:499,nCol:601,scale:0.16911770602856213,take:2151ms,
18,dh_rl,nrow:395,nCol:601,scale:0.0,take:125ms,
19,dh_yj,nrow:601,nCol:476,scale:0.19082640472770354,take:1502ms,
20,dl_bc,nrow:584,nCol:601,scale:0.13535721307828344,take:3104ms,
21,dl_dl,nrow:601,nCol:508,scale:0.0,take:140ms,
22,dl_ey,nrow:462,nCol:601,scale:0.14360489683604472,take:2695ms,
23,dl_hq,nrow:601,nCol:370,scale:0.1639696147677574,take:2159ms,
24,dl_jc,nrow:503,nCol:601,scale:0.0,take:139ms,
25,dl_md,nrow:601,nCol:365,scale:0.1396164849610505,take:1655ms,
26,dl_nj,nrow:525,nCol:601,scale:0.0,take:143ms,
27,dl_ws,nrow:601,nCol:490,scale:0.1279896529316958,take:3327ms,
28,dl_xy,nrow:601,nCol:543,scale:0.15143699894766152,take:3048ms,
29,dl_yb,nrow:601,nCol:447,scale:0.0944141522085095,take:2637ms,
30,dl_yl,nrow:601,nCol:591,scale:0.15598561741456524,take:2945ms,
31,dl_yp,nrow:601,nCol:562,scale:0.2096928552381088,take:3623ms,
32,dq_dq,nrow:601,nCol:331,scale:0.21224699780766404,take:685ms,
33,dq_wx,nrow:601,nCol:417,scale:0.180936643422847,take:1329ms,
34,dq_xg,nrow:601,nCol:287,scale:0.3666976888875454,take:1095ms,
35,hh_gj,nrow:601,nCol:539,scale:0.12384586650250787,take:2290ms,
36,hh_hh,nrow:260,nCol:601,scale:0.11389859971944868,take:1775ms,
37,hh_hk,nrow:355,nCol:601,scale:0.09374856838920301,take:668ms,
38,hh_jp,nrow:350,nCol:601,scale:0.17132687759348858,take:1520ms,
39,hh_js,nrow:601,nCol:369,scale:0.15413465700420118,take:3039ms,
40,hh_ky,nrow:435,nCol:601,scale:0.15635481128546164,take:3183ms,
41,hh_lc,nrow:402,nCol:601,scale:0.1456555467948381,take:1844ms,
42,hh_lx,nrow:571,nCol:601,scale:0.0,take:149ms,
43,hh_ml,nrow:601,nCol:549,scale:0.1579405732072212,take:3490ms,
44,hh_mz,nrow:539,nCol:601,scale:0.10715750607130063,take:2954ms,
45,hh_pb,nrow:601,nCol:583,scale:0.0,take:151ms,
46,hh_sp,nrow:601,nCol:434,scale:0.144534419124526,take:3655ms,
47,hh_yy,nrow:376,nCol:601,scale:0.12735685009710454,take:2051ms,
48,km_an,nrow:601,nCol:469,scale:0.0,take:133ms,
49,km_cg,nrow:544,nCol:601,scale:0.0,take:144ms,
50,km_dc,nrow:601,nCol:420,scale:0.13404210178236553,take:1992ms,
51,km_fm,nrow:601,nCol:576,scale:0.0,take:148ms,
52,km_jn,nrow:382,nCol:601,scale:0.09452673335728533,take:2126ms,
53,km_lq,nrow:601,nCol:442,scale:0.1438024140140044,take:2934ms,
54,km_sl,nrow:601,nCol:567,scale:0.0,take:149ms,
55,km_sm,nrow:352,nCol:601,scale:0.11090492349824929,take:2126ms,
56,km_sxq,nrow:601,nCol:568,scale:0.0,take:154ms,
57,km_xd,nrow:480,nCol:601,scale:0.20008513333769853,take:3031ms,
58,km_yl,nrow:601,nCol:389,scale:0.10985122127376994,take:1939ms,
59,ab_mx,nrow:414,nCol:601,scale:0.23300972878906023,take:2991ms,
60,ab_reg,nrow:528,nCol:601,scale:0.4649504600587156,take:1275ms,
61,ab_rt,nrow:601,nCol:474,scale:0.4084069127860435,take:884ms,
62,ab_sp,nrow:387,nCol:601,scale:0.5017097090082999,take:1887ms,
63,ab_wc,nrow:601,nCol:552,scale:0.28124694065368017,take:6194ms,
64,ab_xj,nrow:601,nCol:509,scale:0.2244782279823316,take:3043ms,
65,bz_bz,nrow:438,nCol:601,scale:0.08238815597741471,take:7385ms,
66,bz_nj,nrow:601,nCol:470,scale:0.10746874875805057,take:6340ms,
67,bz_pc,nrow:504,nCol:601,scale:0.09221662969979091,take:7838ms,
68,bz_tj,nrow:601,nCol:519,scale:0.09745187293547472,take:8107ms,
69,cd_ch,nrow:480,nCol:601,scale:0.0,take:138ms,
70,cd_cz,nrow:327,nCol:601,scale:0.15180210435077837,take:4774ms,
71,cd_djy,nrow:601,nCol:344,scale:0.15074847941799502,take:6209ms,
72,cd_dy,nrow:316,nCol:601,scale:0.17806162484799168,take:4806ms,
73,cd_jn,nrow:445,nCol:601,scale:0.0,take:135ms,
74,cd_jt,nrow:509,nCol:601,scale:0.0,take:144ms,
75,cd_lqy,nrow:504,nCol:601,scale:0.0,take:140ms,
76,cd_pj,nrow:384,nCol:601,scale:0.0,take:121ms,
77,cd_px,nrow:437,nCol:601,scale:0.0,take:129ms,
78,cd_pz,nrow:601,nCol:564,scale:0.0,take:152ms,
79,cd_qbj,nrow:460,nCol:601,scale:0.0,take:135ms,
80,cd_ql,nrow:296,nCol:601,scale:0.08929656714723155,take:6804ms,
81,cd_qy,nrow:238,nCol:601,scale:0.0,take:101ms,
82,cd_sl,nrow:554,nCol:601,scale:0.0,take:154ms,
83,cd_wh,nrow:483,nCol:601,scale:0.0,take:137ms,
84,cd_wj,nrow:601,nCol:567,scale:0.0,take:148ms,
85,cd_xd,nrow:459,nCol:601,scale:0.0,take:133ms,
86,cd_xj,nrow:522,nCol:601,scale:0.0,take:141ms,
87,dy_gh,nrow:393,nCol:601,scale:0.0,take:125ms,
88,dy_jy,nrow:592,nCol:601,scale:0.0,take:155ms,
89,dy_lj,nrow:378,nCol:601,scale:0.0,take:122ms,
90,dy_mz,nrow:601,nCol:481,scale:0.0,take:139ms,
91,dy_sf,nrow:601,nCol:495,scale:0.0,take:137ms,
92,dy_zj,nrow:601,nCol:579,scale:0.06871322740300415,take:9377ms,
93,dz_dx,nrow:525,nCol:601,scale:0.0728778659267311,take:8252ms,
94,dz_dz,nrow:601,nCol:494,scale:0.08022924127265493,take:6705ms,
95,dz_kj,nrow:601,nCol:497,scale:0.0,take:140ms,
96,dz_qx,nrow:601,nCol:575,scale:0.08089194565963767,take:12833ms,
97,dz_tc,nrow:588,nCol:601,scale:0.0,take:152ms,
98,dz_wy,nrow:404,nCol:601,scale:0.10796232076412357,take:5601ms,
99,dz_xh,nrow:366,nCol:601,scale:0.10603137071805444,take:5404ms,
100,ga_ga,nrow:594,nCol:601,scale:0.0,take:156ms,
101,ga_hy,nrow:601,nCol:514,scale:0.0,take:149ms,
102,ga_ls,nrow:513,nCol:601,scale:0.08068902355645406,take:13840ms,
103,ga_ws,nrow:427,nCol:601,scale:0.0,take:128ms,
104,ga_yc,nrow:534,nCol:601,scale:0.06948561625039941,take:10832ms,
105,gy_ct,nrow:369,nCol:601,scale:0.07991998569464973,take:4685ms,
106,gy_cx,nrow:450,nCol:601,scale:0.08216656982110765,take:7281ms,
107,gy_jg,nrow:601,nCol:471,scale:0.09695782260046516,take:8337ms,
108,gy_lz,nrow:292,nCol:601,scale:0.09149708252004535,take:3336ms,
109,gy_qc,nrow:470,nCol:601,scale:0.13639792020564073,take:4445ms,
110,gy_wc,nrow:543,nCol:601,scale:0.0993159880799315,take:7819ms,
111,gy_yb,nrow:560,nCol:601,scale:0.0,take:146ms,
112,gz_bt,nrow:601,nCol:292,scale:0.40106885849003865,take:452ms,
113,gz_by,nrow:578,nCol:601,scale:0.4260650439015076,take:780ms,
114,gz_db,nrow:601,nCol:557,scale:0.23462516455822155,take:2241ms,
115,gz_dc,nrow:601,nCol:263,scale:0.4842703492392512,take:568ms,
116,gz_df,nrow:601,nCol:587,scale:0.37570318526837965,take:1781ms,
117,gz_dg,nrow:550,nCol:601,scale:0.41904909860574596,take:594ms,
118,gz_dr,nrow:601,nCol:274,scale:0.19114317097055966,take:657ms,
119,gz_gz,nrow:601,nCol:498,scale:0.5949420091303097,take:589ms,
120,gz_jl,nrow:575,nCol:601,scale:0.30579843781607663,take:3373ms,
121,gz_kd,nrow:601,nCol:547,scale:0.4164447718930621,take:3061ms,
122,gz_ld,nrow:601,nCol:500,scale:0.23598023654549108,take:5642ms,
123,gz_lh,nrow:576,nCol:601,scale:0.36403407404282634,take:1119ms,
124,gz_lt,nrow:601,nCol:546,scale:0.5235267303472763,take:794ms,
125,gz_sd,nrow:495,nCol:601,scale:0.777668741855434,take:575ms,
126,gz_sq,nrow:531,nCol:601,scale:0.7716295687218853,take:561ms,
127,gz_xc,nrow:601,nCol:389,scale:0.39530103064799726,take:954ms,
128,gz_xl,nrow:535,nCol:601,scale:0.37396390845900057,take:973ms,
129,gz_yj,nrow:601,nCol:457,scale:0.4567353784289483,take:896ms,
130,les_eb,nrow:587,nCol:601,scale:0.14421106227974653,take:9473ms,
131,les_ems,nrow:601,nCol:596,scale:0.0,take:157ms,
132,les_jj,nrow:396,nCol:601,scale:0.0,take:123ms,
133,les_jkh,nrow:601,nCol:483,scale:0.0,take:136ms,
134,les_jw,nrow:536,nCol:601,scale:0.0,take:144ms,
135,les_jy,nrow:601,nCol:510,scale:0.0,take:140ms,
136,les_mb,nrow:601,nCol:558,scale:0.13588993024178803,take:7791ms,
137,les_mc,nrow:511,nCol:601,scale:0.0,take:139ms,
138,les_sw,nrow:601,nCol:578,scale:0.0,take:149ms,
139,les_szq,nrow:393,nCol:601,scale:0.0,take:126ms,
140,les_wtq,nrow:505,nCol:601,scale:0.0,take:140ms,
141,ls_bt,nrow:601,nCol:322,scale:0.12145424708285774,take:3364ms,
142,ls_dc,nrow:530,nCol:601,scale:0.0,take:152ms,
143,ls_gl,nrow:601,nCol:515,scale:0.14642452779900775,take:6487ms,
144,ls_hd,nrow:601,nCol:595,scale:0.16585798400173177,take:4303ms,
145,ls_hl,nrow:601,nCol:421,scale:0.17603003374060644,take:2287ms,
146,ls_jy,nrow:601,nCol:572,scale:0.0,take:150ms,
147,ls_lb,nrow:601,nCol:533,scale:0.1858975867614719,take:4409ms,
148,ls_mg,nrow:601,nCol:352,scale:0.16044637000709505,take:4560ms,
149,ls_ml,nrow:560,nCol:601,scale:0.46017651975763874,take:1646ms,
150,ls_mn,nrow:601,nCol:497,scale:0.2935477559334054,take:3572ms,
151,ls_nn,nrow:601,nCol:579,scale:0.0,take:151ms,
152,ls_pg,nrow:601,nCol:404,scale:0.12909318416369284,take:3985ms,
153,ls_xc,nrow:594,nCol:601,scale:0.25660320706564754,take:4806ms,
154,ls_xd,nrow:601,nCol:490,scale:0.18818985846806072,take:4488ms,
155,ls_yx,nrow:601,nCol:595,scale:0.0,take:153ms,
156,ls_yy,nrow:515,nCol:601,scale:0.32089837989696174,take:2723ms,
157,ls_zj,nrow:375,nCol:601,scale:0.22903185159163342,take:2746ms,
158,lz_gl,nrow:507,nCol:601,scale:0.11111438941108176,take:8470ms,
159,lz_hj,nrow:393,nCol:601,scale:0.11992868976451947,take:7961ms,
160,lz_jy,nrow:273,nCol:601,scale:0.0,take:105ms,
161,lz_lmt,nrow:412,nCol:601,scale:0.0,take:126ms,
162,lz_lx,nrow:438,nCol:601,scale:0.0,take:132ms,
163,lz_nx,nrow:522,nCol:601,scale:0.0,take:142ms,
164,lz_xy,nrow:601,nCol:390,scale:0.1145996568112902,take:6765ms,
165,ms_dl,nrow:458,nCol:601,scale:0.0,take:136ms,
166,ms_dp,nrow:495,nCol:601,scale:0.0,take:138ms,
167,ms_hy,nrow:514,nCol:601,scale:0.1481676511795444,take:7704ms,
168,ms_ps,nrow:523,nCol:601,scale:0.0,take:141ms,
169,ms_qs,nrow:424,nCol:601,scale:0.0,take:127ms,
170,ms_rs,nrow:601,nCol:502,scale:0.0787426919176873,take:14287ms,
171,my_ax,nrow:467,nCol:601,scale:0.0,take:134ms,
172,my_bc,nrow:326,nCol:601,scale:0.16569067068678553,take:4696ms,
173,my_fc,nrow:555,nCol:601,scale:0.0,take:149ms,
174,my_jy,nrow:601,nCol:595,scale:0.12928245282001954,take:7306ms,
175,my_pw,nrow:552,nCol:601,scale:0.20891089073137337,take:5379ms,
176,my_st,nrow:601,nCol:479,scale:0.09259495084261503,take:10768ms,
177,my_yt,nrow:592,nCol:601,scale:0.0,take:152ms,
178,my_yx,nrow:505,nCol:601,scale:0.0,take:147ms,
179,my_zt,nrow:571,nCol:601,scale:0.0,take:149ms,
180,nc_gp,nrow:555,nCol:601,scale:0.0,take:146ms,
181,nc_jl,nrow:601,nCol:530,scale:0.0,take:143ms,
182,nc_lz,nrow:400,nCol:601,scale:0.08997315762741648,take:6517ms,
183,nc_nb,nrow:343,nCol:601,scale:0.09759708016822492,take:5901ms,
184,nc_pa,nrow:601,nCol:569,scale:0.0,take:157ms,
185,nc_sq,nrow:601,nCol:560,scale:0.0,take:147ms,
186,nc_xc,nrow:496,nCol:601,scale:0.0,take:137ms,
187,nc_yl,nrow:436,nCol:601,scale:0.092442444398291,take:8068ms,
188,nc_ys,nrow:557,nCol:601,scale:0.0,take:148ms,
189,nj_dx,nrow:435,nCol:601,scale:0.0,take:133ms,
190,nj_lc,nrow:523,nCol:601,scale:0.0,take:143ms,
191,nj_szq,nrow:601,nCol:544,scale:0.0,take:145ms,
192,nj_wy,nrow:432,nCol:601,scale:0.07634058209945907,take:8619ms,
193,nj_zz,nrow:427,nCol:601,scale:0.07333380702961398,take:10688ms,
194,pzh_dq,nrow:553,nCol:601,scale:0.0,take:150ms,
195,pzh_my,nrow:601,nCol:522,scale:0.10604590898507002,take:3813ms,
196,pzh_rh,nrow:601,nCol:467,scale:0.09795983896733206,take:1987ms,
197,pzh_xq,nrow:369,nCol:601,scale:0.0,take:119ms,
198,pzh_yb,nrow:601,nCol:596,scale:0.16348125011654852,take:2354ms,
199,sn_aj,nrow:360,nCol:601,scale:0.07860405117456051,take:7367ms,
200,sn_cs,nrow:540,nCol:601,scale:0.0,take:154ms,
201,sn_dy,nrow:423,nCol:601,scale:0.0,take:127ms,
202,sn_px,nrow:598,nCol:601,scale:0.0,take:152ms,
203,sn_sh,nrow:601,nCol:554,scale:0.0,take:234ms,
204,ya_bx,nrow:601,nCol:479,scale:0.21322535505805834,take:6896ms,
205,ya_hy,nrow:520,nCol:601,scale:0.13871345004300298,take:5790ms,
206,ya_ls,nrow:601,nCol:258,scale:0.21320690117993235,take:3865ms,
207,ya_ms,nrow:507,nCol:601,scale:0.0,take:140ms,
208,ya_sm,nrow:601,nCol:558,scale:0.15262136473952365,take:5910ms,
209,ya_tq,nrow:495,nCol:601,scale:0.19530151032627432,take:8758ms,
210,ya_yc,nrow:601,nCol:370,scale:0.0,take:121ms,
211,ya_yj,nrow:458,nCol:601,scale:0.15246753169756916,take:6768ms,
212,yb_cn,nrow:601,nCol:367,scale:0.0,take:119ms,
213,yb_cp,nrow:576,nCol:601,scale:0.0,take:150ms,
214,yb_gaox,nrow:601,nCol:503,scale:0.0,take:139ms,
215,yb_gx,nrow:601,nCol:416,scale:0.08469528578462672,take:4910ms,
216,yb_ja,nrow:601,nCol:289,scale:0.0,take:111ms,
217,yb_jl,nrow:479,nCol:601,scale:0.0,take:135ms,
218,yb_nx,nrow:601,nCol:589,scale:0.0,take:151ms,
219,yb_ps,nrow:295,nCol:601,scale:0.1098826468396836,take:3805ms,
220,yb_xw,nrow:484,nCol:601,scale:0.0,take:137ms,
221,yb_yb,nrow:601,nCol:451,scale:0.12453187224176797,take:6536ms,
222,zg_da,nrow:332,nCol:601,scale:0.0,take:114ms,
223,zg_fs,nrow:572,nCol:601,scale:0.0,take:149ms,
224,zg_gj,nrow:601,nCol:559,scale:0.0,take:158ms,
225,zg_rx,nrow:482,nCol:601,scale:0.08659135804029136,take:11453ms,
226,zg_yt,nrow:401,nCol:601,scale:0.0,take:124ms,
227,zg_zlj,nrow:358,nCol:601,scale:0.0,take:117ms,
228,zy_ay,nrow:477,nCol:601,scale:0.09976076506224404,take:13017ms,
229,zy_jy,nrow:473,nCol:601,scale:0.07369123931667507,take:13030ms,
230,zy_lz,nrow:601,nCol:495,scale:0.0,take:137ms,
231,zy_yj,nrow:445,nCol:601,scale:0.07176135788899032,take:12529ms,
sum time:625083.0 mean :2694.323275862069
  评论这张
 
阅读(454)| 评论(0)
推荐 转载

历史上的今天

在LOFTER的更多文章

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2017