Aharon Dayan Posted May 27, 2020 at 05:43 PM Posted May 27, 2020 at 05:43 PM Shalom and greetings all my pals, How do I find specific flight details of any or each of my Vatsim flights for past years? I want to look at flight details of my Vatsim flights in year 2015 and pick one flight to get waypoint routes, airport codes, and type of aircraft used for that flight that I flew on Vatsim in year 2015? Thanks, Aharon Link to comment Share on other sites More sharing options...
Dace Nicmane Posted May 27, 2020 at 06:01 PM Posted May 27, 2020 at 06:01 PM https://stats.vatsim.net/ Link to comment Share on other sites More sharing options...
Ryan Bentley Posted May 27, 2020 at 10:32 PM Posted May 27, 2020 at 10:32 PM Hi, You can also try using the API https://api.vatsim.net/api/ratings/1469468/flight_plans/ Ryan Bentley VATSIM Senior Developer [email protected] Link to comment Share on other sites More sharing options...
Aharon Dayan Posted May 28, 2020 at 02:54 PM Author Posted May 28, 2020 at 02:54 PM 20 hours ago, Dace Nicmane said: https://stats.vatsim.net/ @Dace Nicmane, That does not show waypoints and information on my Vatsim flights from year 2015 Regards, Aharon Link to comment Share on other sites More sharing options...
Aharon Dayan Posted May 28, 2020 at 02:56 PM Author Posted May 28, 2020 at 02:56 PM 16 hours ago, Ryan Bentley said: Hi, You can also try using the API https://api.vatsim.net/api/ratings/1469468/flight_plans/ @Ryan Bentley, Do not understand this hyperlink. It shows me some programming codes. I need to look at my Vatsim flights, their waypoint routes, airports, and type of aircrafts from year 2015. Regards, Aharn Link to comment Share on other sites More sharing options...
Dace Nicmane Posted May 28, 2020 at 06:04 PM Posted May 28, 2020 at 06:04 PM 2 hours ago, Aharon Dayan said: @Dace Nicmane, That does not show waypoints and information on my Vatsim flights from year 2015 Regards, Aharon I checked and it looks like we have data loss here. My own flight plans from 2016 and even 2019 are missing too. I don't know who to ping but this should come to the attention of our technical staff. 1 Link to comment Share on other sites More sharing options...
Dace Nicmane Posted May 28, 2020 at 06:13 PM Posted May 28, 2020 at 06:13 PM 1 Link to comment Share on other sites More sharing options...
Aharon Dayan Posted May 28, 2020 at 06:41 PM Author Posted May 28, 2020 at 06:41 PM @Dace Nicmane, Yeah That is exactly why I am asking here and around if there is any website that show all Vatsim flights, their waypoints, their airports, and their types of aircrafts using any year search Regards, Aharon Link to comment Share on other sites More sharing options...
Dace Nicmane Posted May 28, 2020 at 06:54 PM Posted May 28, 2020 at 06:54 PM There's no other website but let's hope this is a temporary error related to the infrastructure change we're having and they have a backup somewhere with all our data. Link to comment Share on other sites More sharing options...
Nick Harasym Posted May 28, 2020 at 09:16 PM Posted May 28, 2020 at 09:16 PM This change happened during our data migration to new systems a few months back. This data is rarely looked at eats up valuable resources. We took the data out of "hot storage" and now its stored cold. We still have the data, its just not in a form that can be consumed through stats.vatsim.net Nick Harasym VATSIM Senior Developer Team Lead, Infrastructure [email protected] Link to comment Share on other sites More sharing options...
Luke Kolin Posted May 28, 2020 at 10:37 PM Posted May 28, 2020 at 10:37 PM 7 hours ago, Aharon Dayan said: @Ryan Bentley, Do not understand this hyperlink. It shows me some programming codes. I need to look at my Vatsim flights, their waypoint routes, airports, and type of aircrafts from year 2015. It's showing you structured text, and has the data you want (maybe not all of it). Cheers! ... I spawn hundreds of children a day. They are daemons because they are easier to kill. The first four remain stubbornly alive despite my (and their) best efforts. ... Normal in my household makes you a member of a visible minority. Link to comment Share on other sites More sharing options...
Aharon Dayan Posted May 29, 2020 at 08:20 PM Author Posted May 29, 2020 at 08:20 PM (edited) 23 hours ago, Nick Harasym said: We took the data out of "hot storage" and now its stored cold. We still have the data, its just not in a form that can be consumed through stats.vatsim.net @Nick Harasym, It is not problem. Is there any way from any website that I can look up on history of each of my flights from past all years that will tell me waypoints, airports, and type of aircraft, please?? Regards, Aharon Edited May 29, 2020 at 08:21 PM by Aharon Dayan Link to comment Share on other sites More sharing options...
Aharon Dayan Posted May 29, 2020 at 08:22 PM Author Posted May 29, 2020 at 08:22 PM 21 hours ago, Luke Kolin said: It's showing you structured text, and has the data you want (maybe not all of it). Cheers! I still do not understand. It shows me Easyjet flights which are NOT my flights. I never flew for EasyJet Regards, Aharon Link to comment Share on other sites More sharing options...
Luke Kolin Posted May 30, 2020 at 01:51 AM Posted May 30, 2020 at 01:51 AM That's because it's not showing your flights - put your VATSIM ID into that URL. Cheers! ... I spawn hundreds of children a day. They are daemons because they are easier to kill. The first four remain stubbornly alive despite my (and their) best efforts. ... Normal in my household makes you a member of a visible minority. Link to comment Share on other sites More sharing options...
Aharon Dayan Posted May 30, 2020 at 03:14 PM Author Posted May 30, 2020 at 03:14 PM 13 hours ago, Luke Kolin said: put your VATSIM ID into that URL. Yeah, luke It is working BUT shows only flights dating back to Feb 25, 2020. I need flights from any year such as 2017 or 2015 Regards, Aharon Link to comment Share on other sites More sharing options...
Nick Harasym Posted May 31, 2020 at 04:11 AM Posted May 31, 2020 at 04:11 AM On 5/29/2020 at 1:20 PM, Aharon Dayan said: @Nick Harasym, It is not problem. Is there any way from any website that I can look up on history of each of my flights from past all years that will tell me waypoints, airports, and type of aircraft, please?? Regards, Aharon Currently this isn't possible. The data is stored in a way that isn't usable by a website. Nick Harasym VATSIM Senior Developer Team Lead, Infrastructure [email protected] Link to comment Share on other sites More sharing options...
Robert Shearman Jr Posted June 1, 2020 at 12:36 PM Posted June 1, 2020 at 12:36 PM I hate to say it, but, this is yet another example of how a change in the delivery of services to the userbase was made with no prior announcement, leaving many to find out only after the fact. Changes to the datafeeds affected many third-party stat and logging websites. The shutdown of the Sydney FSD server has made staying connected difficult for many. The retirement of X-Plane clients without low sim-rate detection was at least *generally* known to be coming *eventually*, but when it finally happened to XSB 1.3, it was without any announcement leaving its users to wonder why they suddenly couldn't connect. Now, much historical data was archived and cannot be accessed. I'm appreciative of all the behind-the-scenes work that the tech team does to keep the network running -- I just wish less of it was behind-the-scenes. 1 Cheers, -R. Link to comment Share on other sites More sharing options...
Nick Harasym Posted June 6, 2020 at 10:07 PM Posted June 6, 2020 at 10:07 PM Hey Robert, We do have plans to do some blog type posts with information regarding the changes we have been implementing. A decent part of the software stack running Vatsim is starting to be replace with software written recently. Some of our tooling does dates back to early vatsim days. When we work to implement changes that shouldn't cause impact they are tested ahead of time but we can't always test every edge case. Regarding older data, most people aren't looking at data older than a year. Storing this data becomes costly which is why we decided to archive a large chunk of the flight plans table in our database. Regarding keeping things "less ... behind-the-scenes", what format would you like to see for this kind of information? 1 Nick Harasym VATSIM Senior Developer Team Lead, Infrastructure [email protected] Link to comment Share on other sites More sharing options...
Andrew Ogden Posted June 7, 2020 at 05:07 AM Posted June 7, 2020 at 05:07 AM (edited) 7 hours ago, Nick Harasym said: Regarding keeping things "less ... behind-the-scenes", what format would you like to see for this kind of information? Removing my developer hat and replacing it with my consumer hat, transparency in some areas is lacking. It's less than pleasing when a change is made without notice, and whilst sometimes they seem minor enough to the developer, to the consumer they may mean a bit more than that. A clear announcement describing the change and when it'll occur would go a long way. It's a win/win for everyone, the consumer is happy (at least most of the time 😛) with the transparency and the developer isn't being hounded 🙂. The network status page is a step in the right direction, perhaps it could be complimented with a changelog page? Quote Regarding older data, most people aren't looking at data older than a year. Storing this data becomes costly which is why we decided to archive a large chunk of the flight plans table in our database Explaining something as simple as this would have been very appropriate before the change, rather than after the fact. Edited June 7, 2020 at 05:09 AM by Andrew Ogden Andrew Ogden Gander Oceanic OCA Chief Vancouver FIR Senior Instructor Visit us: https://ganderoceanic.ca Contact: [email protected] Link to comment Share on other sites More sharing options...
Aharon Dayan Posted June 7, 2020 at 02:57 PM Author Posted June 7, 2020 at 02:57 PM Quick question: is it possible to have a website function that will allow any Vatsim pilot to press a button to download logbook of all Vatsim flights of all years in spreadsheet format that will show airport codes, type of plane, waypoints, duration time, and call signs?? This can beat cost of storing chunks of data. Regards, Aharon Link to comment Share on other sites More sharing options...
Nick Harasym Posted June 7, 2020 at 05:42 PM Posted June 7, 2020 at 05:42 PM Hey Aharon, To handle a request like that we would have to have the data in a "hot" like state so that it can be queried. We might be able to make it available in the future in a less "reliable way". What I mean by reliable way is currently we replicate our main databases three times over three machines. Something like this would end up on only one machine. At this time I can't comment on a timeline for this. Nick Harasym VATSIM Senior Developer Team Lead, Infrastructure [email protected] Link to comment Share on other sites More sharing options...
Luke Kolin Posted June 7, 2020 at 11:44 PM Posted June 7, 2020 at 11:44 PM On 6/6/2020 at 6:07 PM, Nick Harasym said: Regarding older data, most people aren't looking at data older than a year. Storing this data becomes costly which is why we decided to archive a large chunk of the flight plans table in our database. Out of curiosity, how much data are we talking about? Cheers! Luke ... I spawn hundreds of children a day. They are daemons because they are easier to kill. The first four remain stubbornly alive despite my (and their) best efforts. ... Normal in my household makes you a member of a visible minority. Link to comment Share on other sites More sharing options...
Robert Shearman Jr Posted June 8, 2020 at 02:46 AM Posted June 8, 2020 at 02:46 AM On 6/6/2020 at 6:07 PM, Nick Harasym said: Regarding keeping things "less ... behind-the-scenes", what format would you like to see for this kind of information? There's a subforum on this very site called "Announcements and Important Notices." A post there entitled "SYD-1 server to be decommissioned" or "Past flightplan data to be archived," each with maybe a week's notice, would've been more than sufficient. Cheers, -R. Link to comment Share on other sites More sharing options...
Aharon Dayan Posted June 8, 2020 at 02:06 PM Author Posted June 8, 2020 at 02:06 PM @Nick Harasym, Thanks for interesting answer Regards, Aharon Link to comment Share on other sites More sharing options...
Recommended Posts