[Woc-notify] [AWS 0011603]: Pirep navaid table update

[Mantis Bug Tracker]

The following issue has been ASSIGNED. 
====================================================================== 
https://mantis.awids/view.php?id=11603 
====================================================================== 
Reported By:                Rob Sallee
Assigned To:                Dan Vietor
====================================================================== 
Project:                    AWS
Issue ID:                   11603
Category:                   22.1.2) AviationWeather.gov
Reproducibility:            have not tried
Severity:                   minor
Priority:                   normal
Status:                     assigned
====================================================================== 
Date Submitted:             06-22-2012 18:28 UTC
Last Modified:              07-25-2012 15:36 UTC
====================================================================== 
Summary:                    Pirep navaid table update
Description: 
The PIREP that plotted in ADDS today should have plotted in MT.  Thank you
for your time regarding this matter.

Liam
 


PIREP 16:00Z 06/22/12
  3DU UA /OV M26-HLN270030 /TM 1600 /FL095 /TP C182 /SK BKN-OVC125 /TA 11
/TB LGT-MOD /RM WINDS 060V140 6-20KTS VIRGA
====================================================================== 

---------------------------------------------------------------------- 
 (0030228) Rob Sallee (administrator) - 06-22-12 19:47
 https://mantis.awids/view.php?id=11603#c30228 
---------------------------------------------------------------------- 
Need to update the M96 navaid to 

mysql> select * from NavAids where iata='M26';
+----------+--------+------+----------+---------+-----------+------+---------------------+
| navAidId | icaoId | iata | siteType | lat     | lon       | elev | site 
              |
+----------+--------+------+----------+---------+-----------+------+---------------------+
|    23797 |        | M26  |          | 46.6208 | -113.2051 |    0 |
Drummond : Drummond |
+----------+--------+------+----------+---------+-----------+------+---------------------+
1 row in set (0.01 sec) 

---------------------------------------------------------------------- 
 (0030266) Rob Sallee (administrator) - 06-25-12 18:37
 https://mantis.awids/view.php?id=11603#c30266 
---------------------------------------------------------------------- 
Issue this mysql command on each db instance
update NavAids set lat=46.6208, lon=-113.2051,site="Drummond, MT" where
iata = "M26" ;