The Prestwick Logs

by | Jul 15, 2022 | Database, Spotting

I have decided to move the Prestwick Logs to their own page, currently I have completed the 2021 visitors log and I am working on the 2022 logs. The plan is to display the logs on a concertina format, this will be monthly for the current year, annually for the previous five years then as a single log for the preceding years. I am open to suggestions on changing that though, so any feedback is welcome.

The data in the logs comes from a number of sites, with a reasonable degree of automation – although they still have to be manually checked and in some cases corrected. I’d like to go back as far as possible with the data, possibly making the whole archive searchable as a single data set. This is a kind of pet project that follows on from my own database, so I will probably just keep nibbling away at it when I can.

Prestwick and the C17

by | Jul 11, 2022 | Airport News, Aviation News, Database, Online Logging, Spotting, Spotting Locations

Prestwick, long used as the jumping off point or arrival point for transports crossing the Pond. The main recognition started during the second world war, when it’s excellent fog free record was pointed out by Captain Duncan Macintosh. During the war years, there were huge numbers of Lend Lease aircraft transiting through Prestwick.

Still used as a stopover location for trans-atlantic traffic, now experiencing a revival for military traffic especially given the situation in Ukraine. It is unlikely to see the kinds of volumes of visitors it attracted in the 1960’s and 70’s, but there has been more traffic about that is obvious.

Conveniently placed, Prestwick has over the years seen it’s fair share of traffic – both East and West bound. The table below is the C17 traffic for the past few years and is an extract from my Prestwick historical log going back to 2016, there have been a lot through over that time. As to searching the table, by default any search string will be automatically search any field, however there is a drop down at the right side of the search box – this can be used to filter searches.

 

The C-17 at Prestwick

Smart Phone Spotting.

by | Jun 30, 2022 | Application, Camera, Equipment Reviews., Online Logging, Optical Enhancement, Software Reviews, Spotting

In this post, where I talk about a smartphone – you can substitue deviced like the iPhone, iPad or and Android tablet. Most people will have one of these devices that they can use, so lets get to what you can do with them in the spotting world.

The primary use for a smartphone is communication, but they are capable of so much more. Sit in a cafe or on public transport and you will see people using them to consume digital media in some format, or they will be creating content of some sort.

So how does this relate to plane spotting, well there are a number of ways of using such a device to assist if you have Mobile Data or WiFi access.. Using free App’s like flightradar24 gives access to aircraft ID’s on a continuos basis, an aircraft flying overhead can be in most cases positively identified and would allow you to capture quite a lot of information.

Typically this App will show things like the registration of the aircraft, owner or operator, flight origin and destination. There are a number of dynamic physical reports, altitude, course, speed along with elapsed time and remaining time for the flight. All available for free. There are a number of other Apps that do the same thing, the main difference between them all is the display – and again most of them can be downloaded free.

Recording Information.

As I’ve already said, a pencil and notebook is all that you need to get started. But with a smartphone there are many more options, simply download one of the free Apps, I use Google Keep this allows you to quickly add notes, voice memo’s, check lists and pictures – they are all kept in one App. This makes accessing the information very easy, but you should note that there are many Apps that have similar functionallity. As most of them are free to try I’d suggest that you try a few.

Using the Camera.

In general the cameras on these devices are good quality, I have used mine to take some very good shots over the years – but generally when I’m very close to the aircraft. The photograph above was taken on a smartphone camera, around six years ago. So if you can be within a few meters of an aircraft, the results will be more than adequate using your phone camera.

Some cameras come with multiple sensors and lens configuration, these provide optical zoom sometimes allowing you to zoom into your area of interest. I have found the digital zoom on a number of phone cameras to produce images that to me were not good enough, you may have more luck – experiment.

Addon Smartphone Lenses.

I have not experimented with the addon lenses for phone cameras , I actually still use a dedicated camera for my photography most of the time. But I have seen some excellent results, although in most cases a tripod was used – don’t let this deter you if you feel that that is the way to go.

Online Logs.

It is possible to log directly into some of the online logging apps, however a word of caution here – even the paid for sites tend to severely restrict what you can download from the site once you get home. But effectively you can use your smartphone to log directly into one of these, which does mean that you have your personal log available wherever you have mobile data or WiFi.

Anyway, Happy Spotting!

Prestwick – 2021 Log

by | Jun 28, 2022 | Airport News, Aviation News, Book Reviews, Online Logging, Spotting

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.

Visitor Log Prestwick (EGPK) 2021

Testing a bigger Log

by | Jun 17, 2022 | Airport News, Database, Spotting, Spotting Locations

So again some testing of a log file, this one is for Prestwick, for January and February 2021. This doesn’t include based stuff, that would make the file pretty large and to be honest a registration search would return 365 hits – so not practical.

The data has been sourced from a number of places, it is somewhat limited and would be the type of data that a spotter with a radio and a pen and notebook would typically collect on a visit to the Airport – so does kind of reflect a personal log.

 

Putting the data together was a little time consuming, however I will automate that as much as I can and should be able to speed the process up significantly. The sample data set was created manually, so there may be some typo’s in it – anyway here is the first largeish table with a little guidance as well.

The table can be sorted on a column, by clicking on the heading – obviously the usual constraints apply for date formats. You can sort by date, but the first of January will be followed by the first of February – so please bear that in mind.

There is a free text search, this will return matching values as a guide – searching for “135” will return all matching rows and as an example 12-135(Serial), KC135(Model), AFR1135(Callsign) and ERJ135(Model) would all be returned. It is possible to combine search terms, these should be separated by a space as an example “Boeing 747” without the quote marks.

Prestwick Log January and February 2021