Thanks Max,
I was afraid that someone changed the database on me, but the icaoId is still the primary key.
I have a description of the database, plus the "expected"/correct results, followed by the HQL
query results below.
Database table description:
========================
Code:
mysql> desc Metars\G
*************************** 1. row ***************************
Field: icaoId
Type: varchar(4)
Null:
Key: PRI
Default:
Extra:
*************************** 2. row ***************************
Field: obsTime
Type: int(10) unsigned
Null:
Key: PRI
Default: 0
Extra:
*************************** 3. row ***************************
Field: reportTime
Type: datetime
Null:
Key:
Default: 0000-00-00 00:00:00
Extra:
*************************** 4. row ***************************
Field: temp
Type: smallint(6)
Null: YES
Key:
Default: NULL
Extra:
*************************** 5. row ***************************
Field: dewp
Type: smallint(6)
Null: YES
Key:
Default: NULL
Extra:
*************************** 6. row ***************************
Field: wdir
Type: smallint(5) unsigned
Null: YES
Key:
Default: NULL
Extra:
*************************** 7. row ***************************
Field: wspd
Type: tinyint(3) unsigned
Null: YES
Key:
Default: NULL
Extra:
*************************** 8. row ***************************
Field: wgst
Type: tinyint(3) unsigned
Null: YES
Key:
Default: NULL
Extra:
*************************** 9. row ***************************
Field: visib
Type: smallint(5) unsigned
Null: YES
Key:
Default: NULL
Extra:
*************************** 10. row ***************************
Field: altim
Type: smallint(5) unsigned
Null: YES
Key:
Default: NULL
Extra:
*************************** 11. row ***************************
Field: slp
Type: smallint(5) unsigned
Null: YES
Key:
Default: NULL
Extra:
*************************** 12. row ***************************
Field: qcField
Type: tinyint(3) unsigned
Null: YES
Key:
Default: 0
Extra:
*************************** 13. row ***************************
Field: wxString
Type: varchar(16)
Null: YES
Key:
Default: NULL
Extra:
*************************** 14. row ***************************
Field: cldCvg1
Type: enum('SKC','CLR','CAVOK','FEW','SCT','BKN','OVC','OVX')
Null: YES
Key:
Default: NULL
Extra:
*************************** 15. row ***************************
Field: cldCvg2
Type: enum('SKC','CLR','CAVOK','FEW','SCT','BKN','OVC','OVX')
Null: YES
Key:
Default: NULL
Extra:
*************************** 16. row ***************************
Field: cldCvg3
Type: enum('SKC','CLR','CAVOK','FEW','SCT','BKN','OVC','OVX')
Null: YES
Key:
Default: NULL
Extra:
*************************** 17. row ***************************
Field: cldCvg4
Type: enum('SKC','CLR','CAVOK','FEW','SCT','BKN','OVC','OVX')
Null: YES
Key:
Default: NULL
Extra:
*************************** 18. row ***************************
Field: cldBas1
Type: smallint(5) unsigned
Null: YES
Key:
Default: NULL
Extra:
*************************** 19. row ***************************
Field: cldBas2
Type: smallint(5) unsigned
Null: YES
Key:
Default: NULL
Extra:
*************************** 20. row ***************************
Field: cldBas3
Type: smallint(5) unsigned
Null: YES
Key:
Default: NULL
Extra:
*************************** 21. row ***************************
Field: cldBas4
Type: smallint(5) unsigned
Null: YES
Key:
Default: NULL
Extra:
*************************** 22. row ***************************
Field: presTend
Type: tinyint(4)
Null: YES
Key:
Default: NULL
Extra:
*************************** 23. row ***************************
Field: maxT
Type: smallint(6)
Null: YES
Key:
Default: NULL
Extra:
*************************** 24. row ***************************
Field: minT
Type: smallint(6)
Null: YES
Key:
Default: NULL
Extra:
*************************** 25. row ***************************
Field: maxT24
Type: smallint(6)
Null: YES
Key:
Default: NULL
Extra:
*************************** 26. row ***************************
Field: minT24
Type: smallint(6)
Null: YES
Key:
Default: NULL
Extra:
*************************** 27. row ***************************
Field: precip
Type: smallint(5) unsigned
Null: YES
Key:
Default: NULL
Extra:
*************************** 28. row ***************************
Field: pcp3hr
Type: smallint(5) unsigned
Null: YES
Key:
Default: NULL
Extra:
*************************** 29. row ***************************
Field: pcp6hr
Type: smallint(5) unsigned
Null: YES
Key:
Default: NULL
Extra:
*************************** 30. row ***************************
Field: pcp24hr
Type: smallint(5) unsigned
Null: YES
Key:
Default: NULL
Extra:
*************************** 31. row ***************************
Field: snow
Type: smallint(5) unsigned
Null: YES
Key:
Default: NULL
Extra:
*************************** 32. row ***************************
Field: vertVis
Type: smallint(5) unsigned
Null: YES
Key:
Default: NULL
Extra:
*************************** 33. row ***************************
Field: metarType
Type: enum('METAR','SPECI','TESTM','TESTS')
Null: YES
Key:
Default: METAR
Extra:
*************************** 34. row ***************************
Field: rawOb
Type: varchar(255)
Null:
Key:
Default:
Extra:
34 rows in set (0.00 sec)
"Expected"/ correct results of query
==========================
[code]:
mysql> select * from Metars where icaoId='KSFO';
+--------+------------+---------------------+------+------+------+------+------+-------+-------+-------+---------+----------+---------+---------+---------+---------+---------+---------+---------+---------+----------+------+------+--------+--------+--------+--------+--------+---------+------+---------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| icaoId | obsTime | reportTime | temp | dewp | wdir | wspd | wgst | visib | altim | slp | qcField | wxString | cldCvg1 | cldCvg2 | cldCvg3 | cldCvg4 | cldBas1 | cldBas2 | cldBas3 | cldBas4 | presTend | maxT | minT | maxT24 | minT24 | precip | pcp3hr | pcp6hr | pcp24hr | snow | vertVis | metarType | rawOb
|
+--------+------------+---------------------+------+------+------+------+------+-------+-------+-------+---------+----------+---------+---------+---------+---------+---------+---------+---------+---------+----------+------+------+--------+--------+--------+--------+--------+---------+------+---------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| KSFO | 1112589960 | 2005-04-04 05:00:00 | 100 | 90 | 280 | 28 | 35 | 700 | 10140 | NULL | 4 | -TSRA SQ | FEW | BKN | OVC | | 26 | 55 | 95 | NULL | NULL | NULL | NULL | NULL | NULL | 5 | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 040446Z 28028G35KT 7SM -TSRA SQ FEW026 BKN055 OVC095 10/09 A2994 RMK AO2 PK WND 27035/0445 TSB43RAB33 CIG 030 RWY L10 OCNL LTG NW P0000 |
| KSFO | 1112399760 | 2005-04-02 00:00:00 | 167 | 106 | 270 | 17 | NULL | 1000 | 10214 | 10211 | 4 | NULL | BKN | | | | 250 | NULL | NULL | NULL | -14 | 200 | 144 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 012356Z 27017KT 10SM BKN250 17/11 A3016 RMK AO2 SLP211 T01670106 10200 20144 56014 |
| KSFO | 1112403360 | 2005-04-02 01:00:00 | 167 | 83 | 270 | 17 | NULL | 1000 | 10207 | 10206 | 4 | NULL | BKN | | | | 250 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 020056Z 27017KT 10SM BKN250 17/08 A3014 RMK AO2 SLP206 T01670083 |
| KSFO | 1112406960 | 2005-04-02 02:00:00 | 156 | 94 | 270 | 15 | NULL | 1000 | 10204 | 10204 | 4 | NULL | SCT | | | | 250 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 020156Z 27015KT 10SM SCT250 16/09 A3013 RMK AO2 SLP204 T01560094 |
| KSFO | 1112410560 | 2005-04-02 03:00:00 | 139 | 117 | 270 | 17 | NULL | 1000 | 10201 | 10200 | 4 | NULL | FEW | SCT | SCT | | 20 | 150 | 250 | NULL | -11 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 020256Z 27017KT 10SM FEW020 SCT150 SCT250 14/12 A3012 RMK AO2 SLP200 T01390117 56011 |
| KSFO | 1112417760 | 2005-04-02 04:56:00 | 122 | 122 | 280 | 14 | NULL | 1000 | 10204 | 10203 | 4 | NULL | FEW | | | | 200 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SPECI | KSFO 020456Z 28014KT 10SM FEW200 12/12 A3013 RMK AO2 SLP203 T01220122 |
| KSFO | 1112421360 | 2005-04-02 05:56:00 | 122 | 117 | 270 | 15 | NULL | 1000 | 10204 | 10203 | 4 | NULL | FEW | | | | 18 | NULL | NULL | NULL | 2 | 172 | 122 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SPECI | KSFO 020556Z 27015KT 10SM FEW018 12/12 A3013 RMK AO2 SLP203 T01220117 10172 20122 51002 |
| KSFO | 1112424960 | 2005-04-02 07:00:00 | 122 | 117 | 290 | 9 | NULL | 1000 | 10204 | 10201 | 4 | NULL | FEW | | | | 13 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 020656Z 29009KT 10SM FEW013 12/12 A3013 RMK AO2 SLP201 T01220117 |
| KSFO | 1112428560 | 2005-04-02 08:00:00 | 122 | 122 | 270 | 11 | NULL | 1000 | 10201 | 10200 | 4 | NULL | FEW | | | | 11 | NULL | NULL | NULL | NULL | NULL | NULL | 200 | 89 | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 020756Z 27011KT 10SM FEW011 12/12 A3012 RMK AO2 SLP200 T01220122 402000089 |
| KSFO | 1112432160 | 2005-04-02 09:00:00 | 117 | 111 | 250 | 9 | NULL | 1000 | 10197 | 10195 | 4 | NULL | FEW | | | | 11 | NULL | NULL | NULL | -8 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 020856Z 25009KT 10SM FEW011 12/11 A3011 RMK AO2 SLP195 T01170111 58008 |
| KSFO | 1112435760 | 2005-04-02 10:00:00 | 117 | 111 | 270 | 11 | NULL | 1000 | 10190 | 10187 | 4 | NULL | FEW | | | | 11 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 020956Z 27011KT 10SM FEW011 12/11 A3009 RMK AO2 SLP187 T01170111 |
| KSFO | 1112439360 | 2005-04-02 11:00:00 | 117 | 111 | 260 | 10 | NULL | 1000 | 10187 | 10184 | 4 | NULL | SCT | | | | 11 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 021056Z 26010KT 10SM SCT011 12/11 A3008 RMK AO2 SLP184 T01170111 |
| KSFO | 1112442960 | 2005-04-02 11:56:00 | 117 | 111 | 280 | 14 | NULL | 1000 | 10184 | 10181 | 4 | NULL | SCT | | | | 13 | NULL | NULL | NULL | -14 | 122 | 111 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SPECI | KSFO 021156Z 28014KT 10SM SCT013 12/11 A3007 RMK AO2 SLP181 T01170111 10122 20111 56014 |
| KSFO | 1112446560 | 2005-04-02 12:56:00 | 111 | 111 | 270 | 11 | NULL | 1000 | 10180 | 10180 | 4 | NULL | SCT | | | | 13 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SPECI | KSFO 021256Z 27011KT 10SM SCT013 11/11 A3006 RMK AO2 SLP180 T01110111 |
| KSFO | 1112447460 | 2005-04-02 13:11:00 | 110 | 110 | 280 | 8 | NULL | 1000 | 10180 | NULL | 4 | NULL | BKN | | | | 13 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SPECI | KSFO 021311Z 28008KT 10SM BKN013 11/11 A3006 RMK AO2 |
| KSFO | 1112450160 | 2005-04-02 14:00:00 | 111 | 106 | 270 | 10 | NULL | 1000 | 10180 | 10179 | 4 | NULL | BKN | | | | 13 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 021356Z 27010KT 10SM BKN013 11/11 A3006 RMK AO2 SLP179 T01110106 |
| KSFO | 1112453760 | 2005-04-02 15:00:00 | 117 | 106 | 280 | 11 | NULL | 1000 | 10180 | 10179 | 4 | NULL | BKN | | | | 13 | NULL | NULL | NULL | -1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 021456Z 28011KT 10SM BKN013 12/11 A3006 RMK AO2 SLP179 T01170106 55001 |
| KSFO | 1112455200 | 2005-04-02 15:20:00 | 120 | 110 | 280 | 13 | NULL | 1000 | 10180 | NULL | 4 | NULL | BKN | | | | 15 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SPECI | KSFO 021520Z 28013KT 10SM BKN015 12/11 A3006 RMK AO2 |
| KSFO | 1112457360 | 2005-04-02 16:00:00 | 122 | 106 | 280 | 14 | NULL | 1000 | 10180 | 10179 | 4 | NULL | BKN | BKN | | | 15 | 200 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 021556Z 28014KT 10SM BKN015 BKN200 12/11 A3006 RMK AO2 SLP179 T01220106 |
| KSFO | 1112459340 | 2005-04-02 16:29:00 | 130 | 110 | 270 | 18 | NULL | 1000 | 10180 | NULL | 4 | NULL | SCT | BKN | | | 15 | 200 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 021629Z 27018KT 10SM SCT015 BKN200 13/11 A3006 RMK AO2 |
| KSFO | 1112460960 | 2005-04-02 17:00:00 | 128 | 100 | 280 | 15 | NULL | 1000 | 10180 | 10178 | 4 | NULL | SCT | BKN | | | 15 | 200 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 021656Z 28015KT 10SM SCT015 BKN200 13/10 A3006 RMK AO2 SLP178 T01280100 |
| KSFO | 1112464560 | 2005-04-02 18:00:00 | 139 | 100 | 280 | 14 | 19 | 1000 | 10180 | 10180 | 4 | NULL | SCT | BKN | | | 18 | 200 | NULL | NULL | 1 | 139 | 111 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 021756Z 28014G19KT 10SM SCT018 BKN200 14/10 A3006 RMK AO2 SLP180 T01390100 10139 20111 53001 |
| KSFO | 1112468160 | 2005-04-02 19:00:00 | 144 | 100 | 280 | 14 | NULL | 1000 | 10180 | 10177 | 4 | NULL | SCT | BKN | | | 20 | 200 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 021856Z 28014KT 10SM SCT020 BKN200 14/10 A3006 RMK AO2 SLP177 T01440100 |
| KSFO | 1112471760 | 2005-04-02 20:00:00 | 144 | 100 | 270 | 15 | NULL | 1000 | 10174 | 10173 | 4 | NULL | SCT | BKN | | | 22 | 200 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 021956Z 27015KT 10SM SCT022 BKN200 14/10 A3004 RMK AO2 SLP173 T01440100 |
| KSFO | 1112475360 | 2005-04-02 21:00:00 | 150 | 94 | 280 | 17 | 26 | 1000 | 10174 | 10172 | 4 | NULL | SCT | SCT | | | 22 | 200 | NULL | NULL | -7 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 022056Z 28017G26KT 10SM SCT022 SCT200 15/09 A3004 RMK AO2 PK WND 27026/2052 SLP172 T01500094 56007 |
| KSFO | 1112478960 | 2005-04-02 21:56:00 | 144 | 89 | 280 | 17 | 26 | 1000 | 10167 | 10166 | 4 | NULL | SCT | SCT | | | 27 | 200 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SPECI | KSFO 022156Z 28017G26KT 10SM SCT027 SCT200 14/09 A3002 RMK AO2 PK WND 28026/2151 SLP166 T01440089 |
| KSFO | 1112482560 | 2005-04-02 23:00:00 | 144 | 83 | 270 | 18 | 27 | 1000 | 10167 | 10164 | 4 | NULL | SCT | SCT | | | 30 | 200 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 022256Z 27018G27KT 10SM SCT030 SCT200 14/08 A3002 RMK AO2 PK WND 28028/2241 SLP164 T01440083 |
| KSFO | 1112486160 | 2005-04-03 00:00:00 | 139 | 72 | 270 | 19 | 25 | 1000 | 10160 | 10160 | 4 | NULL | FEW | SCT | | | 30 | 200 | NULL | NULL | -12 | 156 | 133 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 022356Z 27019G25KT 10SM FEW030 SCT200 14/07 A3000 RMK AO2 PK WND 26030/2335 SLP160 T01390072 10156 20133 56012 |
| KSFO | 1112489760 | 2005-04-03 01:00:00 | 133 | 61 | 280 | 18 | 25 | 1000 | 10160 | 10159 | 4 | NULL | FEW | BKN | | | 35 | 250 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 030056Z 28018G25KT 10SM FEW035 BKN250 13/06 A3000 RMK AO2 PK WND 28026/0027 SLP159 T01330061 |
| KSFO | 1112493360 | 2005-04-03 02:00:00 | 122 | 61 | 260 | 14 | 21 | 1000 | 10153 | 10152 | 4 | NULL | FEW | SCT | | | 50 | 250 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 030156Z 26014G21KT 10SM FEW050 SCT250 12/06 A2998 RMK AO2 SLP152 T01220061 |
| KSFO | 1112496960 | 2005-04-03 03:00:00 | 117 | 67 | 270 | 12 | 20 | 1000 | 10153 | 10152 | 4 | NULL | FEW | BKN | | | 29 | 250 | NULL | NULL | -8 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 030256Z 27012G20KT 10SM FEW029 BKN250 12/07 A2998 RMK AO2 SLP152 T01170067 56008 |
| KSFO | 1112500560 | 2005-04-03 04:00:00 | 117 | 67 | 270 | 13 | NULL | 1000 | 10153 | 10151 | 4 | NULL | SCT | BKN | | | 32 | 250 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 030356Z 27013KT 10SM SCT032 BKN250 12/07 A2998 RMK AO2 SLP151 T01170067 |
| KSFO | 1112504160 | 2005-04-03 05:00:00 | 117 | 67 | 280 | 17 | 25 | 1000 | 10157 | 10157 | 4 | NULL | FEW | SCT | | | 27 | 32 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 030456Z 28017G25KT 10SM FEW027 SCT032 12/07 A2999 RMK AO2 SLP157 T01170067 |
| KSFO | 1112507760 | 2005-04-03 06:00:00 | 117 | 72 | 280 | 13 | NULL | 1000 | 10157 | 10154 | 4 | NULL | FEW | BKN | | | 25 | 30 | NULL | NULL | 2 | 139 | 117 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 030556Z 28013KT 10SM FEW025 BKN030 12/07 A2999 RMK AO2 SLP154 T01170072 10139 20117 50002 |
| KSFO | 1112511360 | 2005-04-03 07:00:00 | 117 | 78 | 280 | 7 | NULL | 1000 | 10153 | 10153 | 4 | NULL | SCT | | | | 27 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 030656Z 28007KT 10SM SCT027 12/08 A2998 RMK AO2 SLP153 T01170078 |
| KSFO | 1112514960 | 2005-04-03 08:00:00 | 117 | 83 | 290 | 11 | NULL | 1000 | 10157 | 10155 | 4 | NULL | SCT | BKN | | | 24 | 32 | NULL | NULL | NULL | NULL | NULL | 156 | 111 | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 030756Z 29011KT 10SM SCT024 BKN032 12/08 A2999 RMK AO2 SLP155 T01170083 401560111 |
| KSFO | 1112518560 | 2005-04-03 08:56:00 | 117 | 83 | 290 | 9 | NULL | 1000 | 10153 | 10152 | 4 | NULL | SCT | BKN | | | 26 | 32 | NULL | NULL | -2 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SPECI | KSFO 030856Z 29009KT 10SM SCT026 BKN032 12/08 A2998 RMK AO2 SLP152 T01170083 58002 |
| KSFO | 1112522160 | 2005-04-03 09:56:00 | 117 | 83 | 300 | 5 | NULL | 1000 | 10150 | 10149 | 4 | NULL | SCT | BKN | | | 26 | 34 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SPECI | KSFO 030956Z 30005KT 10SM SCT026 BKN034 12/08 A2997 RMK AO2 SLP149 T01170083 |
| KSFO | 1112525760 | 2005-04-03 11:00:00 | 111 | 78 | 280 | 4 | NULL | 1000 | 10143 | 10143 | 4 | NULL | SCT | BKN | | | 26 | 36 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 031056Z 28004KT 10SM SCT026 BKN036 11/08 A2995 RMK AO2 SLP143 T01110078 |
| KSFO | 1112528460 | 2005-04-03 11:41:00 | 110 | 80 | 210 | 3 | NULL | 1000 | 10143 | NULL | 4 | NULL | BKN | BKN | OVC | | 23 | 30 | 36 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 031141Z 21003KT 10SM BKN023 BKN030 OVC036 11/08 A2995 RMK AO2 |
| KSFO | 1112529360 | 2005-04-03 11:56:00 | 111 | 83 | 0 | 0 | NULL | 1000 | 10140 | 10140 | 4 | NULL | SCT | OVC | | | 25 | 32 | NULL | NULL | -13 | 117 | 111 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SPECI | KSFO 031156Z 00000KT 10SM SCT025 OVC032 11/08 A2994 RMK AO2 SLP140 T01110083 10117 20111 57013 |
| KSFO | 1112532960 | 2005-04-03 13:00:00 | 111 | 83 | 170 | 3 | NULL | 1000 | 10143 | 10143 | 4 | NULL | SCT | BKN | | | 25 | 32 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 031256Z 17003KT 10SM SCT025 BKN032 11/08 A2995 RMK AO2 SLP143 T01110083 |
| KSFO | 1112536560 | 2005-04-03 13:56:00 | 111 | 83 | 180 | 3 | NULL | 1000 | 10146 | 10144 | 4 | NULL | SCT | BKN | | | 25 | 36 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SPECI | KSFO 031356Z 18003KT 10SM SCT025 BKN036 11/08 A2996 RMK AO2 SLP144 T01110083 |
| KSFO | 1112540160 | 2005-04-03 15:00:00 | 111 | 89 | 210 | 3 | NULL | 1000 | 10150 | 10148 | 4 | NULL | FEW | BKN | BKN | | 25 | 36 | 110 | NULL | 8 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 031456Z 21003KT 10SM FEW025 BKN036 BKN110 11/09 A2997 RMK AO2 SLP148 T01110089 53008 |
| KSFO | 1112543760 | 2005-04-03 16:00:00 | 117 | 89 | 180 | 6 | NULL | 1000 | 10153 | 10151 | 4 | NULL | FEW | SCT | BKN | | 25 | 36 | 110 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 031556Z 18006KT 10SM FEW025 SCT036 BKN110 12/09 A2998 RMK AO2 SLP151 T01170089 |
| KSFO | 1112547360 | 2005-04-03 17:00:00 | 128 | 89 | 230 | 7 | NULL | 1000 | 10153 | 10153 | 4 | NULL | FEW | SCT | BKN | | 25 | 36 | 150 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 031656Z 23007KT 10SM FEW025 SCT036 BKN150 13/09 A2998 RMK AO2 SLP153 T01280089 |
| KSFO | 1112550960 | 2005-04-03 18:00:00 | 133 | 83 | 190 | 9 | NULL | 1000 | 10153 | 10151 | 4 | NULL | SCT | BKN | BKN | | 33 | 44 | 200 | NULL | 3 | 133 | 106 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 031756Z 19009KT 10SM SCT033 BKN044 BKN200 13/08 A2998 RMK AO2 SLP151 T01330083 10133 20106 50003 |
| KSFO | 1112554560 | 2005-04-03 19:00:00 | 144 | 83 | 190 | 14 | NULL | 1000 | 10150 | 10149 | 4 | NULL | SCT | BKN | | | 32 | 110 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 031856Z 19014KT 10SM SCT032 BKN110 14/08 A2997 RMK AO2 SLP149 T01440083 |
| KSFO | 1112558160 | 2005-04-03 20:00:00 | 144 | 83 | 180 | 9 | NULL | 1000 | 10143 | 10142 | 4 | NULL | SCT | BKN | | | 36 | 110 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 031956Z 18009KT 10SM SCT036 BKN110 14/08 A2995 RMK AO2 SLP142 T01440083 |
| KSFO | 1112561760 | 2005-04-03 21:00:00 | 144 | 83 | 180 | 17 | 22 | 1000 | 10140 | 10138 | 4 | NULL | SCT | OVC | | | 36 | 110 | NULL | NULL | -13 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 032056Z 18017G22KT 10SM SCT036 OVC110 14/08 A2994 RMK AO2 SLP138 T01440083 58013 |
| KSFO | 1112565360 | 2005-04-03 22:00:00 | 144 | 78 | 200 | 18 | 26 | 1000 | 10133 | 10131 | 4 | NULL | BKN | BKN | | | 34 | 110 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 032156Z 20018G26KT 10SM BKN034 BKN110 14/08 A2992 RMK AO2 PK WND 20026/2156 SLP131 T01440078 |
| KSFO | 1112568960 | 2005-04-03 23:00:00 | 150 | 94 | 190 | 21 | 32 | 1000 | 10119 | 10118 | 4 | NULL | SCT | BKN | OVC | | 29 | 34 | 110 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 032256Z 19021G32KT 10SM SCT029 BKN034 OVC110 15/09 A2988 RMK AO2 PK WND 19032/2250 SLP118 T01500094 |
| KSFO | 1112572560 | 2005-04-04 00:00:00 | 133 | 111 | 190 | 13 | 24 | 700 | 10113 | 10113 | 4 | -RA | SCT | OVC | | | 29 | 37 | NULL | NULL | -25 | 156 | 133 | NULL | NULL | 10 | NULL | 10 | NULL | NULL | NULL | METAR | KSFO 032356Z 19013G24KT 7SM -RA SCT029 OVC037 13/11 A2986 RMK AO2 PK WND 20030/2257 RAB25 SLP113 P0001 60001 T01330111 10156 20133 56025 |
| KSFO | 1112576160 | 2005-04-04 01:00:00 | 100 | 94 | 240 | 17 | 33 | 300 | 10126 | 10124 | 4 | +RA BR | SCT | BKN | OVC | | 27 | 32 | 37 | NULL | NULL | NULL | NULL | NULL | NULL | 120 | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 040056Z 24017G33KT 3SM R28R/5000VP6000FT +RA BR SCT027 BKN032 OVC037 10/09 A2990 RMK AO2 PK WND 28033/0051 WSHFT 0042 SLP124 P0012 T01000094 |
| KSFO | 1112576400 | 2005-04-04 01:00:00 | 100 | 90 | 230 | 15 | 33 | 200 | 10126 | NULL | 4 | +RA BR | BKN | BKN | OVC | | 21 | 28 | 45 | NULL | NULL | NULL | NULL | NULL | NULL | 40 | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 040100Z 23015G33KT 2SM R28R/5000VP6000FT +RA BR BKN021 BKN028 OVC045 10/09 A2990 RMK AO2 WSHFT 0043 P0004 |
| KSFO | 1112577660 | 2005-04-04 01:21:00 | 110 | 90 | 240 | 11 | 18 | 400 | 10123 | NULL | 4 | RA BR | FEW | BKN | OVC | | 7 | 27 | 38 | NULL | NULL | NULL | NULL | NULL | NULL | 130 | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 040121Z 24011G18KT 4SM RA BR FEW007 BKN027 OVC038 11/09 A2989 RMK AO2 WSHFT 0043 P0013 |
| KSFO | 1112579760 | 2005-04-04 02:00:00 | 100 | 89 | 220 | 7 | NULL | 700 | 10123 | 10120 | 4 | -RA | FEW | BKN | OVC | | 3 | 29 | 40 | NULL | NULL | NULL | NULL | NULL | NULL | 210 | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 040156Z 22007KT 7SM -RA FEW003 BKN029 OVC040 10/09 A2989 RMK AO2 WSHFT 0043 SLP120 P0021 T01000089 |
| KSFO | 1112581020 | 2005-04-04 02:17:00 | 100 | 90 | 220 | 6 | NULL | 500 | 10126 | NULL | 4 | RA BR | FEW | SCT | OVC | | 2 | 31 | 42 | NULL | NULL | NULL | NULL | NULL | NULL | 30 | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 040217Z 22006KT 5SM RA BR FEW002 SCT031 OVC042 10/09 A2990 RMK AO2 P0003 |
| KSFO | 1112583360 | 2005-04-04 02:56:00 | 100 | 94 | 220 | 4 | NULL | 700 | 10123 | 10122 | 4 | -RA | FEW | SCT | BKN | | 1 | 32 | 42 | NULL | 9 | NULL | NULL | NULL | NULL | 70 | NULL | NULL | NULL | NULL | NULL | SPECI | KSFO 040256Z 22004KT 7SM -RA FEW001 SCT032 BKN042 10/09 A2989 RMK AO2 SLP122 P0007 60040 T01000094 51009 |
| KSFO | 1112586960 | 2005-04-04 04:00:00 | 100 | 89 | 200 | 4 | NULL | 1000 | 10130 | 10127 | 4 | NULL | FEW | SCT | | | 29 | 37 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5 | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 040356Z 20004KT 10SM FEW029 SCT037 10/09 A2991 RMK AO2 RAE05 SLP127 P0000 T01000089 |
| KSFO | 1112590560 | 2005-04-04 05:00:00 | 89 | 89 | 280 | 14 | 32 | 400 | 10140 | 10139 | 4 | -TSRA BR | FEW | BKN | OVC | | 26 | 39 | 55 | NULL | NULL | NULL | NULL | NULL | NULL | 20 | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 040456Z 28014G32KT 4SM -TSRA BR FEW026 BKN039 OVC055 09/09 A2994 RMK AO2 PK WND 27035/0445 TSB43B54RAB33 SLP139 OCNL LTG NW P0002 T00890089 |
| KSFO | 1112590740 | 2005-04-04 05:00:00 | 90 | 80 | 280 | 13 | NULL | 600 | 10140 | NULL | 4 | -RA BR | FEW | BKN | OVC | | 26 | 39 | 50 | NULL | NULL | NULL | NULL | NULL | NULL | 5 | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 040459Z 28013KT 6SM -RA BR FEW026 BKN039 OVC050 09/08 A2994 RMK AO2 WSHFT 0444 TSE59 P0000 |
| KSFO | 1112594160 | 2005-04-04 06:00:00 | 94 | 94 | 290 | 5 | NULL | 1000 | 10143 | 10142 | 4 | NULL | FEW | SCT | | | 20 | 60 | NULL | NULL | 20 | 133 | 89 | NULL | NULL | 5 | NULL | 420 | NULL | NULL | NULL | METAR | KSFO 040556Z 29005KT 10SM FEW020 SCT060 09/09 A2995 RMK AO2 WSHFT 0444 TSE0459RAE07 SLP142 P0000 60042 T00940094 10133 20089 51020 |
| KSFO | 1112597760 | 2005-04-04 07:00:00 | 94 | 89 | 300 | 3 | NULL | 1000 | 10150 | 10149 | 4 | NULL | FEW | SCT | BKN | | 28 | 35 | 47 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 040656Z 30003KT 10SM FEW028 SCT035 BKN047 09/09 A2997 RMK AO2 SLP149 T00940089 |
| KSFO | 1112601360 | 2005-04-04 07:56:00 | 83 | 78 | 260 | 3 | NULL | 1000 | 10157 | 10154 | 4 | NULL | FEW | SCT | BKN | | 21 | 32 | 44 | NULL | NULL | NULL | NULL | 156 | 83 | 10 | NULL | NULL | NULL | NULL | NULL | SPECI | KSFO 040756Z 26003KT 10SM FEW021 SCT032 BKN044 08/08 A2999 RMK AO2 RAB23E36 SLP154 P0001 T00830078 401560083 |
| KSFO | 1112604960 | 2005-04-04 09:00:00 | 89 | 78 | 270 | 16 | 24 | 1000 | 10163 | 10161 | 4 | NULL | FEW | SCT | SCT | | 36 | 48 | 60 | NULL | 19 | NULL | NULL | NULL | NULL | 5 | 10 | NULL | NULL | NULL | NULL | METAR | KSFO 040856Z 27016G24KT 10SM FEW036 SCT048 SCT060 09/08 A3001 RMK AO2 RAB06E43 SLP161 P0000 60001 T00890078 53019 |
| KSFO | 1112608560 | 2005-04-04 10:00:00 | 78 | 72 | 0 | 0 | NULL | 1000 | 10170 | 10167 | 4 | NULL | FEW | SCT | | | 34 | 50 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 10 | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 040956Z 00000KT 10SM FEW034 SCT050 08/07 A3003 RMK AO2 RAB01E14 SLP167 P0001 T00780072 |
| KSFO | 1112612160 | 2005-04-04 11:00:00 | 89 | 78 | 310 | 3 | NULL | 1000 | 10177 | 10174 | 4 | NULL | FEW | SCT | BKN | | 30 | 36 | 44 | NULL | NULL | NULL | NULL | NULL | NULL | 5 | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 041056Z 31003KT 10SM FEW030 SCT036 BKN044 09/08 A3005 RMK AO2 RAB30E43 SLP174 P0000 T00890078 |
| KSFO | 1112615760 | 2005-04-04 12:00:00 | 89 | 78 | 330 | 6 | NULL | 1000 | 10180 | 10180 | 4 | NULL | FEW | SCT | | | 31 | 46 | NULL | NULL | 19 | 100 | 78 | NULL | NULL | NULL | NULL | 20 | 450 | NULL | NULL | METAR | KSFO 041156Z 33006KT 10SM FEW031 SCT046 09/08 A3006 RMK AO2 SLP180 60002 70045 T00890078 10100 20078 53019 |
| KSFO | 1112619360 | 2005-04-04 13:00:00 | 78 | 72 | 290 | 6 | NULL | 1000 | 10190 | 10188 | 4 | NULL | FEW | | | | 34 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 041256Z 29006KT 10SM FEW034 08/07 A3009 RMK AO2 SLP188 T00780072 |
| KSFO | 1112622960 | 2005-04-04 13:56:00 | 89 | 72 | 300 | 5 | NULL | 1000 | 10197 | 10197 | 4 | NULL | FEW | | | | 30 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SPECI | KSFO 041356Z 30005KT 10SM FEW030 09/07 A3011 RMK AO2 SLP197 T00890072 |
| KSFO | 1112626560 | 2005-04-04 15:00:00 | 94 | 72 | 290 | 6 | NULL | 1000 | 10204 | 10204 | 4 | NULL | FEW | | | | 30 | NULL | NULL | NULL | 24 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 041456Z 29006KT 10SM FEW030 09/07 A3013 RMK AO2 SLP204 T00940072 52024 |
| KSFO | 1112630160 | 2005-04-04 15:56:00 | 106 | 78 | 280 | 10 | NULL | 1000 | 10214 | 10213 | 4 | NULL | FEW | | | | 30 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SPECI | KSFO 041556Z 28010KT 10SM FEW030 11/08 A3016 RMK AO2 SLP213 T01060078 |
| KSFO | 1112633760 | 2005-04-04 17:00:00 | 117 | 72 | 280 | 7 | NULL | 1000 | 10218 | 10215 | 4 | NULL | FEW | | | | 30 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 041656Z 28007KT 10SM FEW030 12/07 A3017 RMK AO2 SLP215 T01170072 |
| KSFO | 1112637360 | 2005-04-04 18:00:00 | 122 | 72 | 20 | 9 | NULL | 1000 | 10221 | 10219 | 4 | NULL | FEW | | | | 30 | NULL | NULL | NULL | 16 | 122 | 78 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 041756Z 02009KT 10SM FEW030 12/07 A3018 RMK AO2 SLP219 T01220072 10122 20078 51016 |
| KSFO | 1112640960 | 2005-04-04 18:56:00 | 122 | 72 | 40 | 5 | NULL | 1000 | 10228 | 10227 | 4 | NULL | FEW | | | | 34 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SPECI | KSFO 041856Z 04005KT 10SM FEW034 12/07 A3020 RMK AO2 SLP227 T01220072 |
| KSFO | 1112644560 | 2005-04-04 20:00:00 | 128 | 72 | 60 | 4 | NULL | 1000 | 10231 | 10229 | 4 | NULL | FEW | | | | 35 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 041956Z 06004KT 10SM FEW035 13/07 A3021 RMK AO2 SLP229 T01280072 |
| KSFO | 1112648160 | 2005-04-04 20:56:00 | 139 | 78 | 40 | 4 | NULL | 1000 | 10231 | 10230 | 4 | NULL | FEW | | | | 35 | NULL | NULL | NULL | 10 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SPECI | KSFO 042056Z 04004KT 10SM FEW035 14/08 A3021 RMK AO2 SLP230 T01390078 51010 |
| KSFO | 1112651760 | 2005-04-04 22:00:00 | 150 | 78 | 290 | 8 | NULL | 1000 | 10231 | 10228 | 4 | NULL | SCT | | | | 40 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 042156Z 29008KT 10SM SCT040 15/08 A3021 RMK AO2 SLP228 T01500078 |
| KSFO | 1112655360 | 2005-04-04 23:00:00 | 150 | 78 | 0 | 5 | NULL | 1000 | 10228 | 10228 | 4 | NULL | SCT | SCT | | | 40 | 250 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 042256Z VRB05KT 10SM SCT040 SCT250 15/08 A3020 RMK AO2 SLP228 T01500078 |
| KSFO | 1112658960 | 2005-04-04 23:56:00 | 144 | 78 | 280 | 12 | NULL | 1000 | 10231 | 10228 | 4 | NULL | SCT | SCT | | | 40 | 250 | NULL | NULL | -2 | 156 | 122 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SPECI | KSFO 042356Z 28012KT 10SM SCT040 SCT250 14/08 A3021 RMK AO2 SLP228 T01440078 10156 20122 55002 |
| KSFO | 1112662560 | 2005-04-05 01:00:00 | 144 | 78 | 260 | 12 | NULL | 1000 | 10231 | 10228 | 4 | NULL | FEW | | | | 35 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 050056Z 26012KT 10SM FEW035 14/08 A3021 RMK AO2 SLP228 T01440078 |
| KSFO | 1112666160 | 2005-04-05 02:00:00 | 133 | 78 | 280 | 14 | NULL | 1000 | 10235 | 10232 | 4 | NULL | FEW | | | | 35 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 050156Z 28014KT 10SM FEW035 13/08 A3022 RMK AO2 SLP232 T01330078 |
| KSFO | 1112669760 | 2005-04-05 03:00:00 | 122 | 83 | 280 | 13 | NULL | 1000 | 10238 | 10235 | 4 | NULL | FEW | | | | 250 | NULL | NULL | NULL | 7 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 050256Z 28013KT 10SM FEW250 12/08 A3023 RMK AO2 SLP235 T01220083 53007 |
| KSFO | 1112673360 | 2005-04-05 03:56:00 | 117 | 83 | 270 | 10 | NULL | 1000 | 10245 | 10242 | 4 | NULL | CLR | | | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SPECI | KSFO 050356Z 27010KT 10SM CLR 12/08 A3025 RMK AO2 SLP242 T01170083 |
| KSFO | 1112676960 | 2005-04-05 04:56:00 | 117 | 78 | 270 | 9 | NULL | 1000 | 10248 | 10248 | 4 | NULL | CLR | | | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SPECI | KSFO 050456Z 27009KT 10SM CLR 12/08 A3026 RMK AO2 SLP248 T01170078 |
| KSFO | 1112680560 | 2005-04-05 06:00:00 | 111 | 72 | 280 | 5 | NULL | 1000 | 10248 | 10247 | 4 | NULL | CLR | | | | NULL | NULL | NULL | NULL | 12 | 150 | 106 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 050556Z 28005KT 10SM CLR 11/07 A3026 RMK AO2 SLP247 T01110072 10150 20106 50012 |
| KSFO | 1112684160 | 2005-04-05 07:00:00 | 106 | 67 | 270 | 4 | NULL | 1000 | 10245 | 10243 | 4 | NULL | CLR | | | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 050656Z 27004KT 10SM CLR 11/07 A3025 RMK AO2 SLP243 T01060067 |
| KSFO | 1112687760 | 2005-04-05 08:00:00 | 94 | 67 | 270 | 4 | NULL | 1000 | 10245 | 10244 | 4 | NULL | CLR | | | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 156 | 78 | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 050756Z 27004KT 10SM CLR 09/07 A3025 RMK AO2 SLP244 T00940067 401560078 |
| KSFO | 1112691360 | 2005-04-05 09:00:00 | 94 | 67 | 280 | 4 | NULL | 1000 | 10245 | 10244 | 4 | NULL | CLR | | | | NULL | NULL | NULL | NULL | -2 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 050856Z 28004KT 10SM CLR 09/07 A3025 RMK AO2 SLP244 T00940067 56002 |
| KSFO | 1112694960 | 2005-04-05 10:00:00 | 83 | 67 | 240 | 4 | NULL | 1000 | 10245 | 10244 | 4 | NULL | CLR | | | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 050956Z 24004KT 10SM CLR 08/07 A3025 RMK AO2 SLP244 T00830067 |
| KSFO | 1112698560 | 2005-04-05 11:00:00 | 83 | 72 | 230 | 3 | NULL | 1000 | 10245 | 10243 | 4 | NULL | CLR | | | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 051056Z 23003KT 10SM CLR 08/07 A3025 RMK AO2 SLP243 T00830072 |
| KSFO | 1112702160 | 2005-04-05 12:00:00 | 78 | 72 | 200 | 4 | NULL | 1000 | 10241 | 10241 | 4 | NULL | CLR | | | | NULL | NULL | NULL | NULL | -3 | 111 | 72 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 051156Z 20004KT 10SM CLR 08/07 A3024 RMK AO2 SLP241 T00780072 10111 20072 58003 |
| KSFO | 1112705760 | 2005-04-05 13:00:00 | 72 | 61 | 0 | 0 | NULL | 1000 | 10245 | 10243 | 4 | NULL | CLR | | | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 051256Z 00000KT 10SM CLR 07/06 A3025 RMK AO2 SLP243 T00720061 |
| KSFO | 1112709360 | 2005-04-05 13:56:00 | 78 | 72 | 160 | 4 | NULL | 1000 | 10241 | 10241 | 4 | NULL | FEW | | | | 30 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SPECI | KSFO 051356Z 16004KT 10SM FEW030 08/07 A3024 RMK AO2 SLP241 T00780072 |
| KSFO | 1112712960 | 2005-04-05 14:56:00 | 94 | 72 | 150 | 5 | NULL | 1000 | 10245 | 10243 | 4 | NULL | FEW | | | | 250 | NULL | NULL | NULL | 2 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SPECI | KSFO 051456Z 15005KT 10SM FEW250 09/07 A3025 RMK AO2 SLP243 T00940072 51002 |
| KSFO | 1112716560 | 2005-04-05 15:56:00 | 106 | 83 | 120 | 4 | NULL | 1000 | 10245 | 10243 | 4 | NULL | FEW | | | | 250 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SPECI | KSFO 051556Z 12004KT 10SM FEW250 11/08 A3025 RMK AO2 SLP243 T01060083 |
| KSFO | 1112720160 | 2005-04-05 16:56:00 | 117 | 89 | 70 | 4 | NULL | 1000 | 10248 | 10245 | 4 | NULL | FEW | | | | 250 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SPECI | KSFO 051656Z 07004KT 10SM FEW250 12/09 A3026 RMK AO2 SLP245 T01170089 |
| KSFO | 1112723760 | 2005-04-05 18:00:00 | 133 | 111 | 40 | 4 | NULL | 1000 | 10248 | 10246 | 4 | NULL | CLR | | | | NULL | NULL | NULL | NULL | 3 | 133 | 72 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 051756Z 04004KT 10SM CLR 13/11 A3026 RMK AO2 SLP246 T01330111 10133 20072 53003 |
| KSFO | 1112727360 | 2005-04-05 18:56:00 | 139 | 111 | 10 | 4 | NULL | 1000 | 10245 | 10244 | 4 | NULL | CLR | | | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SPECI | KSFO 051856Z 01004KT 10SM CLR 14/11 A3025 RMK AO2 SLP244 T01390111 |
| KSFO | 1112730960 | 2005-04-05 20:00:00 | 150 | 117 | 0 | 0 | NULL | 1000 | 10238 | 10236 | 4 | NULL | CLR | | | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 051956Z 00000KT 10SM CLR 15/12 A3023 RMK AO2 SLP236 T01500117 |
| KSFO | 1112734560 | 2005-04-05 21:00:00 | 161 | 117 | 30 | 3 | NULL | 1000 | 10228 | 10227 | 4 | NULL | CLR | | | | NULL | NULL | NULL | NULL | -19 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 052056Z 03003KT 10SM CLR 16/12 A3020 RMK AO2 SLP227 T01610117 58019 |
| KSFO | 1112738160 | 2005-04-05 22:00:00 | 172 | 117 | 0 | 0 | NULL | 1000 | 10218 | 10216 | 4 | NULL | CLR | | | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 052156Z 00000KT 10SM CLR 17/12 A3017 RMK AO2 SLP216 T01720117 |
| KSFO | 1112741760 | 2005-04-05 23:00:00 | 189 | 128 | 20 | 3 | NULL | 1000 | 10207 | 10207 | 4 | NULL | CLR | | | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 052256Z 02003KT 10SM CLR 19/13 A3014 RMK AO2 SLP207 T01890128 |
| KSFO | 1112745360 | 2005-04-06 00:00:00 | 211 | 94 | 0 | 0 | NULL | 1000 | 10204 | 10203 | 4 | NULL | CLR | | | | NULL | NULL | NULL | NULL | -25 | 211 | 128 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 052356Z 00000KT 10SM CLR 21/09 A3013 RMK AO2 SLP203 T02110094 10211 20128 56025 |
| KSFO | 1112748960 | 2005-04-06 01:00:00 | 178 | 122 | 280 | 16 | NULL | 1000 | 10204 | 10201 | 4 | NULL | CLR | | | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 060056Z 28016KT 10SM CLR 18/12 A3013 RMK AO2 WSHFT 0036 SLP201 T01780122 |
| KSFO | 1112752560 | 2005-04-06 01:56:00 | 156 | 94 | 280 | 15 | NULL | 1000 | 10204 | 10201 | 4 | NULL | CLR | | | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SPECI | KSFO 060156Z 28015KT 10SM CLR 16/09 A3013 RMK AO2 SLP201 T01560094 |
| KSFO | 1112756160 | 2005-04-06 03:00:00 | 144 | 94 | 280 | 14 | NULL | 1000 | 10204 | 10203 | 4 | NULL | FEW | | | | 300 | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 060256Z 28014KT 10SM FEW300 14/09 A3013 RMK AO2 SLP203 T01440094 53001 |
| KSFO | 1112759760 | 2005-04-06 03:56:00 | 139 | 100 | 280 | 11 | NULL | 1000 | 10207 | 10207 | 4 | NULL | CLR | | | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SPECI | KSFO 060356Z 28011KT 10SM CLR 14/10 A3014 RMK AO2 SLP207 T01390100 |
| KSFO | 1112763360 | 2005-04-06 04:56:00 | 139 | 100 | 290 | 10 | NULL | 1000 | 10214 | 10212 | 4 | NULL | CLR | | | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SPECI | KSFO 060456Z 29010KT 10SM CLR 14/10 A3016 RMK AO2 SLP212 T01390100 |
| KSFO | 1112766960 | 2005-04-06 06:00:00 | 133 | 94 | 280 | 10 | NULL | 1000 | 10211 | 10209 | 4 | NULL | CLR | | | | NULL | NULL | NULL | NULL | 6 | 217 | 133 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 060556Z 28010KT 10SM CLR 13/09 A3015 RMK AO2 SLP209 T01330094 10217 20133 50006 |
| KSFO | 1112770560 | 2005-04-06 07:00:00 | 133 | 83 | 290 | 5 | NULL | 1000 | 10211 | 10209 | 4 | NULL | CLR | | | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 060656Z 29005KT 10SM CLR 13/08 A3015 RMK AO2 SLP209 T01330083 |
| KSFO | 1112774160 | 2005-04-06 08:00:00 | 117 | 89 | 220 | 3 | NULL | 1000 | 10207 | 10207 | 4 | NULL | CLR | | | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 217 | 72 | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 060756Z 22003KT 10SM CLR 12/09 A3014 RMK AO2 SLP207 T01170089 402170072 |
| KSFO | 1112777760 | 2005-04-06 09:00:00 | 122 | 89 | 0 | 0 | NULL | 1000 | 10204 | 10203 | 4 | NULL | CLR | | | | NULL | NULL | NULL | NULL | -7 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 060856Z 00000KT 10SM CLR 12/09 A3013 RMK AO2 SLP203 T01220089 58007 |
| KSFO | 1112781360 | 2005-04-06 10:00:00 | 111 | 78 | 290 | 4 | NULL | 1000 | 10197 | 10197 | 4 | NULL | CLR | | | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | METAR | KSFO 060956Z 29004KT 10SM CLR 11/08 A3011 RMK AO2 SLP197 T01110078 |
| KSFO | 1112784960 | 2005-04-06 10:56:00 | 106 | 72 | 280 | 3 | NULL | 1000 | 10194 | 10192 | 4 | NULL | CLR | | | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | SPECI | KSFO 061056Z 28003KT 10SM CLR 11/07 A3010 RMK AO2 SLP192 T01060072