Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Tristate airports
11-14-2012, 03:28 PM,
#1
Tristate airports
A couple months back I posted links to the forum of a site I found the lists airports by state. As a reminder, the links are:

http://www.aviationacres.com/ohioairports.asp
http://www.aviationacres.com/indianaairports.asp
http://www.aviationacres.com/kentuckyairports.asp

I've finally written a program to extract the airport information into an Excel file (attached...I hope) for analysis to find potential new towing sites. For each site, I've pull the following information if it was available:
.zip   Airports.zip (Size: 173.77 KB / Downloads: 4)
- Manager name and phone number
- Runway length, surface and direction
- Public/private and whether it's under tower control
- Lat/Long and a link to Bing maps to show the site

I've found, for example, that there are 150 airports with runways 4000' or longer in Indiana/Ohio/Kentucky that are not under tower control. For those of us near Louisville, there is a 4000' grass strip in Laconia, IN, which is particularly interesting.

Note that this list is obviously not complete, but it is still quite extensive. WesMar is not listed as far as I can tell. Lee Bottom outside Madison, is.
Reply
11-14-2012, 03:31 PM,
#2
Tristate airports
It's not obvious, but in the middle of the previous post, right before the list of fields, there is a link "Attachment 269" which downloads a zip containing an Excel file containing the list of airports.
Reply
11-14-2012, 04:47 PM,
#3
Tristate airports
Thanks!!! I'm attaching the "attachment" here to my post using the conventional method.

We need to talk! If you're able to "extract" info from other websites, perhaps you can write a little snippet that will place to-us-pertinent weather info on our front page? All those weather widgets either show current conditions, or temp/precip forecast, but not wind velocity/direction forecast. Can it be done?


Attached Files
.zip   Airports.zip (Size: 173.77 KB / Downloads: 2)
"I saw on this nature show how male elk douses himself with urine to smell sweeter to the opposite sex. What a coincidence!!" ~Deep thought by Jack Handey
Reply
11-14-2012, 08:08 PM,
#4
Tristate airports
Hmm...I don't see an attachment to your post.

What weather data source would you like to use for wind?
Reply
11-14-2012, 09:05 PM,
#5
Tristate airports
It's bellow the text of my reply, above my signature. See the picture: [ATTACH=CONFIG]271[/ATTACH] Does it now show up for you guys?



FlyingGMan Wrote:Hmm...I don't see an attachment to your post.

What weather data source would you like to use for wind?

Any website that gives degrees and velocity, those are my favorites:

windmapper.com (if set correctly in your preferences it shows degrees rather compass) .... http://windmapper.com/forecast/madison%2C_in

wunderground.com .... http://www.wunderground.com/cgi-bin/find...y=Thursday

usairnet.com ... http://www.usairnet.com/cgi-bin/launch/c...F&state=KY


Attached Files
.jpg   attachment.jpg (Size: 180.62 KB / Downloads: 4)
"I saw on this nature show how male elk douses himself with urine to smell sweeter to the opposite sex. What a coincidence!!" ~Deep thought by Jack Handey
Reply
11-16-2012, 01:17 PM,
#6
Tristate airports
Michal,
I like your idea of adding weather info to the Kentuckiana website. I agree that windmapper is a good site, I also like:

NOAA

http://forecast.weather.gov/MapClick.php...Y%2C%20USA

Windmapper
http://windmapper.com/forecast/madison%2C_indiana

Windfinder
http://www.windfinder.com/windreports/

University of Wyoming
for upper air readings (choose type of plot raw data, or GIF:SkewT):
http://weather.uwyo.edu/upperair/sounding.html

Dixon's Airplay
has a good educational primer and list of weather websites to check out:
http://www.paraglide.com/Weather.html

After all that calculating and figuring, sometimes you just need to go stand at launch.
Reply


Forum Jump:


Users browsing this thread: 11 Guest(s)