D-MFRM is Indeed in the A-D Database

DougRobertson

When I enter a search for D-MFRM the screen comes up that it is not in the database and would I like to add it?

D-MFRM is a Magni Gyroplane (autogyro) with pusher engine. It is in fact in the A-D data base with a manned pilot action photo.

Why the discrepancy? Just wondering.

stantonite

Doug

My understanding is that there are TWO Databases

1. is the Master database of aircraft details (Most of which is automatically updated)

2. is a database of photos by Registration / Tail Number

It is possible to put a photo on the Photo Database WITHOUT the aircraft details being on BUT when you do a search - they do not show

- because the SEARCH facility only appears to search the aircraft details database

Terry

MalcolmClarke

We have two current forum postings, this one of Doug's and one from 'Tigherland' both of which relate to the same subject.

Having uploaded quite a few images recently, creating each time a new database entry for those having a new airframe registration to the site, I have been surprised at the number of times that other images have joined mine on these occasions.

Clearly these were what I would describe as unconnected images, not accessible to members and visitors but only to the uploader in his own member section because he/she failed to create a database entry at the time of uploading. If I am right in my assumptions, and I may be labouring under a misconception, what is the point in uploading images which are not available to be viewed generally?

Perhaps this should be explained in the HELP section?

Would it be possible to isolate/identify these images in order that others may help the site by creating the related database entry?

Malcolm.

L-5jockey

Malcolm

Yes there are a lot of "disconnected" photo on the site. I presume most are uploaded because, the photographers do not have all or some of the Identification data (mfg c/n etc) to properly ID the bird.

As to D-MFRM, I've just added some data, so the photos are not so "disconnected".

Unfortunately the c/n is unknown to me, and I cannot link it at this time to a UK registry, if it ever had one. A partial (incomplete) c/n was added to help with DB searches.

Maybe someone can update the c/n, when the data becomes known. (C/n's would have to be updated via email with Ken (site admin).

http://www.airport-data.com/aircraft/D-MFRM.html

John

Ken Wang

Clearly these were what I would describe as unconnected images, not accessible to members and visitors but only to the uploader in his own member section because he/she failed to create a database entry at the time of uploading. If I am right in my assumptions, and I may be labouring under a misconception, what is the point in uploading images which are not available to be viewed generally?

Those photos can be searched for, also are linked to from the photographer's gallery.

Perhaps this should be explained in the HELP section?

A help section is indeed needed. I had an idea for long time but never found enough time to do it.

Ken

Ken Wang

1. is the Master database of aircraft details (Most of which is automatically updated)

2. is a database of photos by Registration / Tail Number

Clearify on the database structure:

First we have airframe table (database), which record manufacturer,model, c/n, year, etc. This table is indexed on a unique number.

Then comes the aircraft table, which record registry number, airworthy info, etc as well as linking them to an airframe. This table is indexed on the registry numbers.

As an airframe can bear multiple registry numbers over time, it's possible there're multiple records in aircraft table linking to the same airframe. This behaviour can be observed from the aircraft profile pages in "Also Registered As" line. Example here: http://www.airport-data.com/aircraft/TC-JMD.html.

Also a registry number can be used on multiple airframes over time, so it's possible to have multip records with same registry in the aircraft table. This behaviour is shown as "x aircraft records found." in the left side of aircraft profile page. Example here: http://www.airport-data.com/aircraft/N2029Z.html

Aircraft photos are stored in a separate table, with links to aircraft table. If the aircraft for a photo does not exist in aircraft table, then the photo can only be found by search or browse through photographer's gallery.

Ken

MalcolmClarke

John.

I do so hope that I'm not becoming a pain in the butt Limey.

I chose the word 'unconnected' quite deliberately as these images have no relationship with the database.

In which case I would suggest that it is preferable to raise such an entry even if the uploader is not in possession of all the relevant information. The image is then not 'left out in the cold' as it were!

Ken.

I do understand your careful explanation, but any image for which there is no database entry cannot be found unless the enquirer knows who the photographer is - probably an unlikely situation.

An example.

TC-APY does not have a database entry but I know that there is an uploaded photo as I saw it in the random photo section. Someone catches this reg at their airport but could not identify the aircraft. How would they find the photo which may help them with the ident?

Clearly they don't know who the photographer is.

I won't labour the point any further except to repeat that it would be beneficial to have a process for bringing such images into the main database.

Malcolm..