<div class='quotetop'>QUOTE (Irro @ Jan 5 2010, 08:55 PM) <{POST_SNAPBACK}></div>Yep, probably a PHP/MySQL combination. I also know some Java/JSP stuff, but PHP is my first programming language and I feel a lot more comfortable with it. Plus, the software running this forum uses the same thing, so integration is a lot simpler.How would you handle the data? sql?[/b]
Spongebue - NonRev Correspondent - U.S./Midwest Region
Awesome. Im working on a program that handles basic information for airports.. kinda like a wiki travel, but more suited to Non revs and helps people find ways into and out of the cities
<div class='quotetop'>QUOTE (Irro @ Jan 6 2010, 09:02 PM) <{POST_SNAPBACK}></div>That'd be cool, how would you integrate the timetables and destinations with that? Seems like it could reasonably be made if you have the information loaded, but I don't know how you'd get that information (and the best sources can probably do the same things).Awesome. Im working on a program that handles basic information for airports.. kinda like a wiki travel, but more suited to Non revs and helps people find ways into and out of the cities[/b]
Edit: forgot to mention a problem I've already run into. I found a list of all cities and their country, state/province/region, population, and latitude/longitude. Thing is, the list ended up being about a 250MB text file which not only slows my computer way down when working with it (I need a RAM upgrade, 2GB is kinda low by today's standards), but I don't have a good way to load it into my MySQL test server on my computer. Plus, I'm on a Mac, so my program options are sorta limited.
Edit 2: Finally got that running. I now have a database with 2,699,354 cities from 231 countries. Wish I thought to use vi earlier when editing that monster file.
Spongebue - NonRev Correspondent - U.S./Midwest Region
I think that there are way too many sites out there with the ability to add information about places, but no actual content. Im taking the other route and not adding cities airlines or routes inless I have information about them already. So I didnt use those airport lists.
And I working with XML and SQL. I have it where it does an airline does a certain route under its name.. which airline actually flies it, and if its seasonal.. then it can take you to a different site to show the loads. And right now I just have an local based C# program that allows me to input and view data intill I get more in it, then ill move it over to a website and make it pretty
Hmmm, a lot of airlines have their timetables somewhere on their website if you do some searching. Maybe you could write some things to parse the file and load it? Assuming they use the same format between updates, you could re-parse the file to update things. Kinda like the airport list for my project: I had this list http://www.atlarge.com/misc/allairports.htm and copied it into a text file. If it had the header of a country, I'd pull the country name and set it to a variable I had. If it was an airport, I'd pull the airport code and airport from that line and turn it into an SQL query, using the country from that variable. Took some time to make it, but sure beat putting 2400 airports in manually.
Spongebue - NonRev Correspondent - U.S./Midwest Region
Yeah, but im starting with the US, and United destinations first. Things I know about. Once thats useful Ill put it up and add more. I have to keep the scope manageable you know.
Yeah, that's understandable. Think you could also separate UA's regional carriers, like SkyWest and Shuttle America? I might be working for Skywest soon, and it sounds like I'd have to pay a little for taking the mainline or regional carriers other than my own, so it'd be nice to know who flies what
Spongebue - NonRev Correspondent - U.S./Midwest Region
Yeah, I'm working on it, but I haven't found an acceptable way of dealing with data yet.
I want to have a data file, like XML, that has all the information about each airport. And one that has everything to do with the Airlines themselves, and when I put in route information you have to select the information from those two data files.. so all the data is tied together, and I wont have to input data twice, and everything is always updated.
But I havent found an acceptable way yet
Got it. I have worked with XML before, but only when things are already set up (just some "put this information in with this format" grunt work) so I can't help much there, sadly.
Spongebue - NonRev Correspondent - U.S./Midwest Region
Ill figure out the data issues soon hopefully. Im about to bored IAD-NRT-BKK so that should give me some time ti check it out
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks