View Single Post
  #10  
Old March 6th 12, 07:20 AM posted to rec.aviation.soaring
Tibor
external usenet poster
 
Posts: 2
Default "datamining" thousands of IGC files

Thanks everyone for suggestions, please keep them coming . For now we need to answer simple question or two. e.g. how many "flights/hours have reached 7500ft MSL."?

We'll probably get only competition flights (no online competitions), as we luckily have quite enough competitions in Slovakia and it's easy to approach the organizers.

For longer term, of course we would like to have more sophisticated collection, filtering and ad hoc queries. That's why I mentioned importing flights into relational+spatial database. I think it's the propper groundwork for anybody doing statistics or visualizations. If we create something along this lines I'll let you know.

Thanks,
Tibor

On Monday, March 5, 2012 6:26:07 PM UTC+1, Tibor wrote:
Hi,

are there any open/free tools to datamine on database of many IGC files?

There is a threat that the free airspace for gliding in Slovakia is going to be significantly restricted. We need tools which help prepare arguments about airspace usage and frequency of our flights.

If I was starting from scratch I would probably try to import all the flights into a GIS database (PostGIS) and do the data cleaning and queries there. Does anybody have experience with this?

Thanks for you help,
Tibor Arpas




On Monday, March 5, 2012 6:26:07 PM UTC+1, Tibor wrote:
Hi,

are there any open/free tools to datamine on database of many IGC files?

There is a threat that the free airspace for gliding in Slovakia is going to be significantly restricted. We need tools which help prepare arguments about airspace usage and frequency of our flights.

If I was starting from scratch I would probably try to import all the flights into a GIS database (PostGIS) and do the data cleaning and queries there. Does anybody have experience with this?

Thanks for you help,
Tibor Arpas