crossfeed-logger

[pedromorgan]

@geoffmcl + @theo-armour

Please watch https://github.com/freeflightsim/crossfeed-logger

BUT..arguing+debating stuff here also ;-).. Thingz r mov+=on

What we all want is tracks and callsigns and stuff..

So the DATABASE will have some stuff that appear for @theo-armour and @geoffmcl as just json or mapmtiles, or even csv.. alike and off we go.. ie data in and data out of a database..

Spatial

• We could record lat, lon, alt as floats in db,, which is kinda done.. instead
• POSTGIS we have a lat/lon type instead its a POINT(lat,lon)
• we can also have POINT3(lat, lon, alt)
• and we can go on from there.. into POINT_FFS(lat, lon, alt, spd) etc etc

So a flight, will actually be a line, taking off from some place, and
vars in time and space recorded for later..

Main thing is that we we have that "point spactially" in db..

[geoffmcl]

@pedromorgan watching with interest... where this goes, leads ;=))

[pedromorgan]

QGis showing tracks

@geoffmcl Note I'm only importing flight with more than 500 points, otherwise there is a lot of noise. Have you any views on that ?

[geoffmcl]

@pedromorgan yes, for sure we should have some filters on these records...

Yes, number of points is one way, but I use time and distance travelled...

The time can be got from the update timestamp record, and the distance a calculation between the lat,lon records...

One thing I did forget about here is that ATC records, ATC-ml or OpenRadar models, which do not move, were initially being ignored by me... but I have tried to correct this later...

And would again remind you of Theo's global view of the tracks - http://fgx.github.io/sandbox/globe-crossfeed-replay/ - he now adds a plackard with the callsign of the flight...

A cute daily global 3D perspective ;=)) but a 2D view is also fun...

[geoffmcl]

Not sure this is the best place, but really get confused with all these issues floating around ;=)) but...

Have now sync-ed this repo with the 2 truncated, and the 2 missing CSV files, and added another html summary - https://fgx.github.io/crossfeed-dailies/html/20160829.htm - From: 2016-07-07 18:14:41, To: 2016-08-28 22:59:58 - 52 days 4:45:17 hh:mm:ss - Sampled 32,417 flights, 410,036,588 nm., 814 models, 3,048 callsigns, est.time 943 days 23:31:01 hh:mm:ss... - from some 53 files CSV daily summaries... and growing...

Look forward to more 3D and/or 2D globes/maps showing this data, however it is done, stored, kept, displayed, collected, dissected, ... ;=))

And just noticed, file flights-2016-08-20.csv contains a new record of 61 active pilots on that day... and expect that to be exceeded again soon, with some Europeans returning from their summer vacation...

Have noted my - http://geoffair.org/fg/map-test2/map-test.html - another user of mp14/crossfeed/json data, has been quite sparse lately, at least when I looked at it...