- Posts: 1
- Thank you received: 1
Using the downloadable aircraft database
5 years 8 months ago - 5 years 8 months ago #715
by hanswoerzt
Using the downloadable aircraft database was created by hanswoerzt
The downloadable aircraftDatabase.csv file is of poor quality. 
Out of 460058 lines in the file version downloaded March 14, only 413370 (89.85 %) contained aircraft with legal ICAO addresses, tail codes, and 27 data fields.
Of the remaining 46688 (10.15 %) lines, 26795 (5.82 %) contained no tailcode, 10510 (2.28 %) showed illegal ICAO addresses, and 9383 (2.04 %) were corrupted or incomplete (with missing fields).
Some fields contain control characters, HTML tags, and HTML character entities.
Before this file can be used to create an alternative to basestation.sqb as used in Plane Plotter, it needs to be cleaned-up. Why not clean this before it is publicly available here?
Out of 460058 lines in the file version downloaded March 14, only 413370 (89.85 %) contained aircraft with legal ICAO addresses, tail codes, and 27 data fields.
Of the remaining 46688 (10.15 %) lines, 26795 (5.82 %) contained no tailcode, 10510 (2.28 %) showed illegal ICAO addresses, and 9383 (2.04 %) were corrupted or incomplete (with missing fields).
Some fields contain control characters, HTML tags, and HTML character entities.
Before this file can be used to create an alternative to basestation.sqb as used in Plane Plotter, it needs to be cleaned-up. Why not clean this before it is publicly available here?
