So the testing of the tables and the search facility continues, this data set now comprises a full year of visitors to Prestwick. The based aircraft are not incorporated in the log, mainly due to the fact that each one would add 365 rows to the table – and a search would likely return 365 rows of data.
In order that the table is displayed properly it is at the bottom of the post, where it should be out the way of the rest of the post. The next test will be to break the year down into individual months, I’m going to experiment with various layouts and content to see what works best.
Some additional search and filtering tips, there is now a dropdown at the right hand side if the search bar. This allows the fields searched to be toggled on or off, this will allow more controlled searching and should make life a little easier.
It is possible to order the data by any of the column headings, simply click on the heading to order by alphanumeric ascending or decending – this will work on search results if required.
The data comes from a number of public sources, I have automated some of the data collection and hope to improve it over time.
Additionally I have started on the automation of the building of the logs but there is still some manual intervention required, it is still a manual proces to put it in the database – but eventually I may be able to automate some of the steps.