[Woc-notify] [CM Request for Change - AWS 0010443]: Local Forecast Search form

[Mantis Bug Tracker]

The following issue has been CLOSED 
====================================================================== 
https://bugs.awids/view.php?id=10443 
====================================================================== 
Reported By:                Rob Sallee
Assigned To:                Rob Sallee
====================================================================== 
Project:                    CM Request for Change - AWS
Issue ID:                   10443
Category:                   32) CAWS
Reproducibility:            have not tried
Severity:                   minor
Priority:                   normal
Status:                     closed
TIN Required?         (If "YES" please upload):  
Deadline:                    
Disposition:                 
Configuration Change Authority:  
Disposition Date:            
Level of Change:             
Change Notification:         
Resolution:                 fixed
Fixed in Version:           
====================================================================== 
Date Submitted:             12-27-2011 13:56 UTC
Last Modified:              07-05-2012 19:26 UTC
====================================================================== 
Summary:                    Local Forecast Search form
Description: 
Lee Becker lbecker at hartmancox.com
	
Dec 23 (4 days ago)
		
to ncep.awc.adds
HAPPY HOLIDAYS:

On the "Local forecast by "City, St" or Zip Code" menu, the Warrenton
Fauquier Airport, the ICAO ID is KHWY. The menu still responds to W66,
which was the identifier years ago, but it does not have KHWY in the data
base. Please update the data base for the current identifier.

Thanks and have a great holiday,

Lee Becker
HARTMAN-COX ARCHITECTS
1074 Thomas Jefferson Street, N. W.
Washington, D.C. 20007

202-333-6446
======================================================================
Relationships       ID      Summary
----------------------------------------------------------------------
child of            0011494 6/26/2012 CAWS Release ticket
====================================================================== 

---------------------------------------------------------------------- 
 (0030073) John Sereno (manager) - 06-07-12 14:11
 https://bugs.awids/view.php?id=10443#c30073 
---------------------------------------------------------------------- 
Rob,
Trying to clean up some tickets, not sure if this has been done or not?
John 

---------------------------------------------------------------------- 
 (0030078) Rob Sallee (administrator) - 06-07-12 14:33
 https://bugs.awids/view.php?id=10443#c30078 
---------------------------------------------------------------------- 
No It has not.  But looking at the script that runs it, I think we have
some work to do.  It is only using the NavAids Table.  I think it should
be using the stationinfo table since it is more up to date.

31 	$sqlStr = sprintf( "SELECT lat,lon FROM NavAids WHERE ( icaoId like
'%s') or ( iata like '%s' )",
32 	mysql_real_escape_string($lookfor),
33 	mysql_real_escape_string($lookfor)
34 	) ;

Will need to look into this further. 

---------------------------------------------------------------------- 
 (0030182) Rob Sallee (administrator) - 06-19-12 13:08
 https://bugs.awids/view.php?id=10443#c30182 
---------------------------------------------------------------------- 
Set up query to use StationInfo table since it is more up to date. 

---------------------------------------------------------------------- 
 (0030262) Rob Sallee (administrator) - 06-25-12 17:55
 https://bugs.awids/view.php?id=10443#c30262 
---------------------------------------------------------------------- 
File affected
application/modules/adds/views/scripts/phputils/airportweather.phtml

system impact: none
User impact:  low Station table contains more information and more up to
date.  So local forecast request will work more locations.  

Test plan:
go to www.aviationweather.gov
on left hand menu, go to the local forecast form and type in an airport
identifier and verify your request is forwarded to the proper
forecast.weather.gov page.