-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathtable_create.sql
More file actions
240 lines (240 loc) · 9.81 KB
/
table_create.sql
File metadata and controls
240 lines (240 loc) · 9.81 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
CREATE TABLE ghcnh (
Station_ID VARCHAR(255),
Station_Name VARCHAR(255),
YEAR INTEGER,
MONTH INTEGER,
DAY INTEGER,
HOUR INTEGER,
MINUTE INTEGER,
Latitude float,
Longitude float,
Elevation float,
temperature float,
temperature_Measurement_Code VARCHAR(255),
temperature_Quality_Code VARCHAR(255),
temperature_Report_Type VARCHAR(255),
temperature_Source_Code VARCHAR(255),
temperature_Source_Station_ID VARCHAR(255),
dew_point_temperature float,
dew_point_temperature_Measurement_Code VARCHAR(255),
dew_point_temperature_Quality_Code VARCHAR(255),
dew_point_temperature_Report_Type VARCHAR(255),
dew_point_temperature_Source_Code VARCHAR(255),
dew_point_temperature_Source_Station_ID VARCHAR(255),
station_level_pressure float,
station_level_pressure_Measurement_Code VARCHAR(255),
station_level_pressure_Quality_Code VARCHAR(255),
station_level_pressure_Report_Type VARCHAR(255),
station_level_pressure_Source_Code VARCHAR(255),
station_level_pressure_Source_Station_ID VARCHAR(255),
sea_level_pressure float,
sea_level_pressure_Measurement_Code VARCHAR(255),
sea_level_pressure_Quality_Code VARCHAR(255),
sea_level_pressure_Report_Type VARCHAR(255),
sea_level_pressure_Source_Code VARCHAR(255),
sea_level_pressure_Source_Station_ID VARCHAR(255),
wind_direction float,
wind_direction_Measurement_Code VARCHAR(255),
wind_direction_Quality_Code VARCHAR(255),
wind_direction_Report_Type VARCHAR(255),
wind_direction_Source_Code VARCHAR(255),
wind_direction_Source_Station_ID VARCHAR(255),
wind_speed float,
wind_speed_Measurement_Code VARCHAR(255),
wind_speed_Quality_Code VARCHAR(255),
wind_speed_Report_Type VARCHAR(255),
wind_speed_Source_Code VARCHAR(255),
wind_speed_Source_Station_ID VARCHAR(255),
wind_gust float,
wind_gust_Measurement_Code VARCHAR(255),
wind_gust_Quality_Code VARCHAR(255),
wind_gust_Report_Type VARCHAR(255),
wind_gust_Source_Code VARCHAR(255),
wind_gust_Source_Station_ID VARCHAR(255),
precipitation float,
precipitation_Measurement_Code VARCHAR(255),
precipitation_Quality_Code VARCHAR(255),
precipitation_Report_Type VARCHAR(255),
precipitation_Source_Code VARCHAR(255),
precipitation_Source_Station_ID VARCHAR(255),
relative_humidity float,
relative_humidity_Measurement_Code VARCHAR(255),
relative_humidity_Quality_Code VARCHAR(255),
relative_humidity_Report_Type VARCHAR(255),
relative_humidity_Source_Code VARCHAR(255),
relative_humidity_Source_Station_ID VARCHAR(255),
wet_bulb_temperature float,
wet_bulb_temperature_Measurement_Code VARCHAR(255),
wet_bulb_temperature_Quality_Code VARCHAR(255),
wet_bulb_temperature_Report_Type VARCHAR(255),
wet_bulb_temperature_Source_Code VARCHAR(255),
wet_bulb_temperature_Source_Station_ID VARCHAR(255),
pres_wx_MW1 VARCHAR(255),
pres_wx_MW1_Measurement_Code VARCHAR(255),
pres_wx_MW1_Quality_Code VARCHAR(255),
pres_wx_MW1_Report_Type VARCHAR(255),
pres_wx_MW1_Source_Code VARCHAR(255),
pres_wx_MW1_Source_Station_ID VARCHAR(255),
pres_wx_MW2 VARCHAR(255),
pres_wx_MW2_Measurement_Code VARCHAR(255),
pres_wx_MW2_Quality_Code VARCHAR(255),
pres_wx_MW2_Report_Type VARCHAR(255),
pres_wx_MW2_Source_Code VARCHAR(255),
pres_wx_MW2_Source_Station_ID VARCHAR(255),
pres_wx_MW3 VARCHAR(255),
pres_wx_MW3_Measurement_Code VARCHAR(255),
pres_wx_MW3_Quality_Code VARCHAR(255),
pres_wx_MW3_Report_Type VARCHAR(255),
pres_wx_MW3_Source_Code VARCHAR(255),
pres_wx_MW3_Source_Station_ID VARCHAR(255),
pres_wx_AU1 VARCHAR(255),
pres_wx_AU1_Measurement_Code VARCHAR(255),
pres_wx_AU1_Quality_Code VARCHAR(255),
pres_wx_AU1_Report_Type VARCHAR(255),
pres_wx_AU1_Source_Code VARCHAR(255),
pres_wx_AU1_Source_Station_ID VARCHAR(255),
pres_wx_AU2 VARCHAR(255),
pres_wx_AU2_Measurement_Code VARCHAR(255),
pres_wx_AU2_Quality_Code VARCHAR(255),
pres_wx_AU2_Report_Type VARCHAR(255),
pres_wx_AU2_Source_Code VARCHAR(255),
pres_wx_AU2_Source_Station_ID VARCHAR(255),
pres_wx_AU3 VARCHAR(255),
pres_wx_AU3_Measurement_Code VARCHAR(255),
pres_wx_AU3_Quality_Code VARCHAR(255),
pres_wx_AU3_Report_Type VARCHAR(255),
pres_wx_AU3_Source_Code VARCHAR(255),
pres_wx_AU3_Source_Station_ID VARCHAR(255),
pres_wx_AW1 VARCHAR(255),
pres_wx_AW1_Measurement_Code VARCHAR(255),
pres_wx_AW1_Quality_Code VARCHAR(255),
pres_wx_AW1_Report_Type VARCHAR(255),
pres_wx_AW1_Source_Code VARCHAR(255),
pres_wx_AW1_Source_Station_ID VARCHAR(255),
pres_wx_AW2 VARCHAR(255),
pres_wx_AW2_Measurement_Code VARCHAR(255),
pres_wx_AW2_Quality_Code VARCHAR(255),
pres_wx_AW2_Report_Type VARCHAR(255),
pres_wx_AW2_Source_Code VARCHAR(255),
pres_wx_AW2_Source_Station_ID VARCHAR(255),
pres_wx_AW3 VARCHAR(255),
pres_wx_AW3_Measurement_Code VARCHAR(255),
pres_wx_AW3_Quality_Code VARCHAR(255),
pres_wx_AW3_Report_Type VARCHAR(255),
pres_wx_AW3_Source_Code VARCHAR(255),
pres_wx_AW3_Source_Station_ID VARCHAR(255),
snow_depth float,
snow_depth_Measurement_Code VARCHAR(255),
snow_depth_Quality_Code VARCHAR(255),
snow_depth_Report_Type VARCHAR(255),
snow_depth_Source_Code VARCHAR(255),
snow_depth_Source_Station_ID VARCHAR(255),
visibility float,
visibility_Measurement_Code VARCHAR(255),
visibility_Quality_Code VARCHAR(255),
visibility_Report_Type VARCHAR(255),
visibility_Source_Code VARCHAR(255),
visibility_Source_Station_ID VARCHAR(255),
altimeter float,
altimeter_Measurement_Code VARCHAR(255),
altimeter_Quality_Code VARCHAR(255),
altimeter_Report_Type VARCHAR(255),
altimeter_Source_Code VARCHAR(255),
altimeter_Source_Station_ID VARCHAR(255),
pressure_3hr_change float,
pressure_3hr_change_Measurement_Code VARCHAR(255),
pressure_3hr_change_Quality_Code VARCHAR(255),
pressure_3hr_change_Report_Type VARCHAR(255),
pressure_3hr_change_Source_Code VARCHAR(255),
pressure_3hr_change_Source_Station_ID VARCHAR(255),
sky_cover_1 VARCHAR(255),
sky_cover_1_Measurement_Code VARCHAR(255),
sky_cover_1_Quality_Code VARCHAR(255),
sky_cover_1_Report_Type VARCHAR(255),
sky_cover_1_Source_Code VARCHAR(255),
sky_cover_1_Source_Station_ID VARCHAR(255),
sky_cover_baseht_1 VARCHAR(255),
sky_cover_baseht_1_Measurement_Code VARCHAR(255),
sky_cover_baseht_1_Quality_Code VARCHAR(255),
sky_cover_baseht_1_Report_Type VARCHAR(255),
sky_cover_baseht_1_Source_Code VARCHAR(255),
sky_cover_baseht_1_Source_Station_ID VARCHAR(255),
sky_cover_2 VARCHAR(255),
sky_cover_2_Measurement_Code VARCHAR(255),
sky_cover_2_Quality_Code VARCHAR(255),
sky_cover_2_Report_Type VARCHAR(255),
sky_cover_2_Source_Code VARCHAR(255),
sky_cover_2_Source_Station_ID VARCHAR(255),
sky_cover_baseht_2 VARCHAR(255),
sky_cover_baseht_2_Measurement_Code VARCHAR(255),
sky_cover_baseht_2_Quality_Code VARCHAR(255),
sky_cover_baseht_2_Report_Type VARCHAR(255),
sky_cover_baseht_2_Source_Code VARCHAR(255),
sky_cover_baseht_2_Source_Station_ID VARCHAR(255),
sky_cover_3 VARCHAR(255),
sky_cover_3_Measurement_Code VARCHAR(255),
sky_cover_3_Quality_Code VARCHAR(255),
sky_cover_3_Report_Type VARCHAR(255),
sky_cover_3_Source_Code VARCHAR(255),
sky_cover_3_Source_Station_ID VARCHAR(255),
sky_cover_baseht_3 VARCHAR(255),
sky_cover_baseht_3_Measurement_Code VARCHAR(255),
sky_cover_baseht_3_Quality_Code VARCHAR(255),
sky_cover_baseht_3_Report_Type VARCHAR(255),
sky_cover_baseht_3_Source_Code VARCHAR(255),
sky_cover_baseht_3_Source_Station_ID VARCHAR(255),
precipitation_3_hour float,
precipitation_3_hour_Measurement_Code VARCHAR(255),
precipitation_3_hour_Quality_Code VARCHAR(255),
precipitation_3_hour_Report_Type VARCHAR(255),
precipitation_3_hour_Source_Code VARCHAR(255),
precipitation_3_hour_Source_Station_ID VARCHAR(255),
precipitation_6_hour float,
precipitation_6_hour_Measurement_Code VARCHAR(255),
precipitation_6_hour_Quality_Code VARCHAR(255),
precipitation_6_hour_Report_Type VARCHAR(255),
precipitation_6_hour_Source_Code VARCHAR(255),
precipitation_6_hour_Source_Station_ID VARCHAR(255),
precipitation_9_hour float,
precipitation_9_hour_Measurement_Code VARCHAR(255),
precipitation_9_hour_Quality_Code VARCHAR(255),
precipitation_9_hour_Report_Type VARCHAR(255),
precipitation_9_hour_Source_Code VARCHAR(255),
precipitation_9_hour_Source_Station_ID VARCHAR(255),
precipitation_12_hour float,
precipitation_12_hour_Measurement_Code VARCHAR(255),
precipitation_12_hour_Quality_Code VARCHAR(255),
precipitation_12_hour_Report_Type VARCHAR(255),
precipitation_12_hour_Source_Code VARCHAR(255),
precipitation_12_hour_Source_Station_ID VARCHAR(255),
precipitation_15_hour float,
precipitation_15_hour_Measurement_Code VARCHAR(255),
precipitation_15_hour_Quality_Code VARCHAR(255),
precipitation_15_hour_Report_Type VARCHAR(255),
precipitation_15_hour_Source_Code VARCHAR(255),
precipitation_15_hour_Source_Station_ID VARCHAR(255),
precipitation_18_hour float,
precipitation_18_hour_Measurement_Code VARCHAR(255),
precipitation_18_hour_Quality_Code VARCHAR(255),
precipitation_18_hour_Report_Type VARCHAR(255),
precipitation_18_hour_Source_Code VARCHAR(255),
precipitation_18_hour_Source_Station_ID VARCHAR(255),
precipitation_21_hour float,
precipitation_21_hour_Measurement_Code VARCHAR(255),
precipitation_21_hour_Quality_Code VARCHAR(255),
precipitation_21_hour_Report_Type VARCHAR(255),
precipitation_21_hour_Source_Code VARCHAR(255),
precipitation_21_hour_Source_Station_ID VARCHAR(255),
precipitation_24_hour float,
precipitation_24_hour_Measurement_Code VARCHAR(255),
precipitation_24_hour_Quality_Code VARCHAR(255),
precipitation_24_hour_Report_Type VARCHAR(255),
precipitation_24_hour_Source_Code VARCHAR(255),
precipitation_24_hour_Source_Station_ID VARCHAR(255),
remarks VARCHAR(10485760),
remarks_Measurement_Code VARCHAR(255),
remarks_Quality_Code VARCHAR(255),
remarks_Report_Type VARCHAR(255),
remarks_Source_Code VARCHAR(255),
remarks_Source_Station_ID VARCHAR(255)
);