Posts: 9150
Joined: Wed Aug 18, 1999 5:49 am

My Own Aviation Photo Database!

Fri Mar 10, 2000 2:43 am

Instead of spending hundreds on a programme for your photos and reggies, why not build one yourself using Microsoft Excel (assuming that 90% of those who access the internet have access to Microsoft Excel).

You can find this when you select "programs" from the drop down/up box where you have "Start". On Excel, you can set up boxes in such a way that you can have the info you want.

If (like me) you have your photos in albums, you can separate them like this:

Aircraft reg
Aircraft type
Where photographed
Date (roughly)
Which album
Which page

That way, if you need to find a photo, you can go to Excel and ask, by aircraft reg, where it is, and it should,hopefully, bring up the entry for the aircraft,

EI-CPD A321 Aer Lingus LHR August 1998 Album 2, Page 10

You can also sort the registrations in alphabetical order, or in any particular
order you wish - e.g. start with Airbus and working in numerical order, e.g. A319 up for Airbus, the 707, 717, 727 etc. for Boeing.
Posts: 193
Joined: Sun Jan 09, 2000 7:09 am

RE: My Own Aviation Photo Database!

Fri Mar 10, 2000 5:10 am

Good idea! It sounds like a winner, however I have my pictures grouped into books of airlines, not the aircarft. I guess you can do it anyway you like. I am currently writing down N numbers on the bottom of photos in the books inorder to present them at trade shows.

Posts: 4722
Joined: Wed May 19, 1999 10:42 pm

RE: My Own Aviation Photo Database!

Fri Mar 10, 2000 12:03 pm

Yes, but tell me what I should do if I dont keep pictures in albums. Albums only destroy pictures. I would like to make some kind of data base of my pic collection. I have over 5000 pictures, but I keep them in the shoe boxes.

BWIADCA - Nikon D100
Posts: 2
Joined: Fri May 06, 2005 8:38 pm

RE: My Own Aviation Photo Database!

Fri Mar 10, 2000 6:35 pm

have you tried Microsoft Access for your database. Its the way to go. Store your own pictures and data on each shot.
Very simple to add pictures and update your shots.
Posts: 6633
Joined: Tue May 18, 1999 11:10 am

RE: My Own Aviation Photo Database!

Sat Mar 11, 2000 7:45 am

I have all mine cataloged in Borland Quattro Pro. Each photo has a serial number. The info I store is:

Serial Number
Special Flight info
Negative serial number (yes, I have all of them cataloged too)
Posts: 3141
Joined: Tue May 18, 1999 2:46 am

RE: My Own Aviation Photo Database!

Tue Mar 14, 2000 6:17 am

A database program like FileMaker or Access is better suited to this task than a spreadsheet like Excel. Personally, I built a HyperCard program to function as my database, and included the functionality to generate the pages for my web site as well. Windows users could probably do something similar with Visual Basic.
Posts: 9150
Joined: Wed Aug 18, 1999 5:49 am

RE: My Own Aviation Photo Database!

Wed Mar 15, 2000 3:23 am

I've now got up to No.1000, although I'm only getting about 50-60% logged, as I'm sticking to ones where the aircraft reg. is clearly legible.

As for Excel, I find it quite alright. It does what I want it to do, which is fine. For example, if you want to find a particular acft, scroll down from EDIT to LOOK FOR (with binoculars beside it), select "By columns" and "values",enter your reg in the box and press "Look Next" and it'll take you right to it. I don't know about the other ones, but Excel does I all I want.
Posts: 4971
Joined: Tue May 18, 1999 11:55 am

RE: My Own Aviation Photo Database!

Mon Mar 20, 2000 2:58 pm

I actually do that, with flights I've been on. Airline, Aircraft, Depart, Arrive, Reg# etc.

Who is online

Users browsing this forum: No registered users and 1 guest

Popular Searches On Airliners.net

Top Photos of Last:   24 Hours  •  48 Hours  •  7 Days  •  30 Days  •  180 Days  •  365 Days  •  All Time

Military Aircraft Every type from fighters to helicopters from air forces around the globe

Classic Airliners Props and jets from the good old days

Flight Decks Views from inside the cockpit

Aircraft Cabins Passenger cabin shots showing seat arrangements as well as cargo aircraft interior

Cargo Aircraft Pictures of great freighter aircraft

Government Aircraft Aircraft flying government officials

Helicopters Our large helicopter section. Both military and civil versions

Blimps / Airships Everything from the Goodyear blimp to the Zeppelin

Night Photos Beautiful shots taken while the sun is below the horizon

Accidents Accident, incident and crash related photos

Air to Air Photos taken by airborne photographers of airborne aircraft

Special Paint Schemes Aircraft painted in beautiful and original liveries

Airport Overviews Airport overviews from the air or ground

Tails and Winglets Tail and Winglet closeups with beautiful airline logos