Sponsor Message:
Aviation Photography Forum
My Starred Topics | Profile | New Topic | Forum Index | Help | Search 
Personal Database, Photo Storage  
User currently offlineFutterman From United States of America, joined Sep 2003, 1301 posts, RR: 43
Posted (10 years 3 weeks 4 days 15 hours ago) and read 2678 times:

In the midst of the "Do You Keep All Your Pics?" and other archival-related threads, storing photos on CDs, DVDs, or multiple HDs seems to be nothing more than just that. Storage.

I'm interested in having an A.net-esq personal database that would make it easy to locate photos via a simple search function.

Want all shots of an Emirates A345 landing at JFK on March 3? How about all La Guardia departures from July 7? I'm not sure the default Windows search feature would be able to cope with that.


Do programs like BreezeBrowser have anything like this? I really don't want to have hundreds of folders by date/airline/aircraft/location, dozens of discs to load up just to see what's on it, or a gallery (PBase) on the web. Maybe, "OK, Brian, here are your photos of Qantas 747s from February 2."

Well, it doesn't have to talk, but an organized program where I can save all my images to one place, put in a search query, and come up with what I was trying to find would be nice.


If any of you know the Jetsons, that might help too.



Brian


What the FUTT?
18 replies: All unread, jump to last
 
User currently offlineKarlok From Netherlands, joined Mar 2002, 839 posts, RR: 1
Reply 1, posted (10 years 3 weeks 4 days 14 hours ago) and read 2631 times:

The same thing I searching for but I couldn't find anything. Thus I decided to create a program myself. Free for all.

You have to know, that in this program no photo's could be stored.
Only a database.

Still in early production stage. I will place a new topic these day, to ask what you boy/girls want in the program.

here are some shots:




[Edited 2004-08-30 21:11:22]

User currently offlineClickhappy From United States of America, joined Sep 2001, 9633 posts, RR: 68
Reply 2, posted (10 years 3 weeks 4 days 14 hours ago) and read 2627 times:
AIRLINERS.NET CREW
PHOTO SCREENER

check out Extensis

http://www.extensis.com/en/products/asset_management.jsp;jsessionid=


User currently offlineBenyhone From United States of America, joined Mar 2001, 206 posts, RR: 3
Reply 3, posted (10 years 3 weeks 4 days 14 hours ago) and read 2620 times:

Brian,

I don't know of an off-the-shelf solution. But, keep in mind, that whatever "program" you end up with, it will take time on your part to input all of the bits of data you want to record (like date, place, type of aircraft). I don't know how you could get around that time-consuming step.

I used to do this for every print & slide I photographed, first into Excel, later Access. In Access, there are wizards to help you set up a "query", which once properly set up, will return the type of answer you are looking for. My old database did exactly that (... All America West B737-200s shot in January 1992, etc).

Hope that helps...

Terry/PHX



Cactus Wings Photography, Phoenix
User currently offlineHenks From Sweden, joined Jan 2000, 632 posts, RR: 6
Reply 4, posted (10 years 3 weeks 4 days 14 hours ago) and read 2607 times:
AIRLINERS.NET CREW

Hmm... how about using http://www.MyAviation.net/?

Henrik


User currently offlineINNflight From Switzerland, joined Apr 2004, 3766 posts, RR: 60
Reply 5, posted (10 years 3 weeks 4 days 13 hours ago) and read 2591 times:

Karlok:

A friend of fellow photographer Wolfgang Hut had written a program for me, very similar to yours!

I like it a lot, very practical!

cheers,
Florian



Jet Visuals
User currently offlineClickhappy From United States of America, joined Sep 2001, 9633 posts, RR: 68
Reply 6, posted (10 years 3 weeks 4 days 13 hours ago) and read 2589 times:
AIRLINERS.NET CREW
PHOTO SCREENER

right now I am writing a .net app using sql as the back end, might make the code available for certain people to try. Its pretty fun actually.

User currently offlineLindy From , joined Dec 1969, posts, RR:
Reply 7, posted (10 years 3 weeks 4 days 13 hours ago) and read 2562 times:

I created Access database over 2.5 years ago. It takes a lot of time to enter the data. Right now I'm finishing just my prints, so far I've entered 6000 records. Also I have another 25 rolls of film waiting to be developed and aproximately 3000 digital pictures in line to be entered into database. Its time consuming but when you enter your data you can search anyway you like it. Here is the snapshot of the main form.



Rafal


User currently offlineFutterman From United States of America, joined Sep 2003, 1301 posts, RR: 43
Reply 8, posted (10 years 3 weeks 4 days 13 hours ago) and read 2544 times:

Thanks for all the suggestions. I think Terry and Rafal have me bent on something with Access, so I'll see what it's all about when I get home in a few hours.

I gather it's a comprehensive, searchable database (but not photo storage). Entering the information and the time associated with it is no huge problem--it'll save me lots of frustration as well as the cash for hair-restoration procedures.

In the mean time, can anyone break down the 'development' stage of creating a database via Access for me? How do I start this off? You can post here or email me privately at futterman@gmail.com.


Thanks guys,

Brian



What the FUTT?
User currently offlineCkw From UK - England, joined Aug 2010, 742 posts, RR: 16
Reply 9, posted (10 years 3 weeks 4 days 10 hours ago) and read 2515 times:

Try Imatch http://www.photools.com/

After spending time with dBase, Excel, Access this was the answer for me - unlike other systems which are essentially text based with links to images, Imatch uses the image as the core of the database with textual annotations.

Advantages for the photographer include ability to access EXIF info, handle most file formats (including RAW), span volumes (including CDs) and pattern match within the image database. Its shareware (free demo), reliable and amazingly fast - even with 10s of thousands of images.

Cheers,

Colin




Colin K. Work, Pixstel
User currently offlineGerardo From Spain, joined May 2000, 3481 posts, RR: 31
Reply 10, posted (10 years 3 weeks 4 days 2 hours ago) and read 2464 times:

After having tried many database software packages, I decided to go with ThumbsPlus. It allows me to creat and manage an archive of all my CD's. I can now look for example for all "SWISS A332 at ZRH on take off" or "all SQ B744 on touch down in July 2002" and so on.

More: http://www.thumbsplus.com

Cheers
Gerardo



dominguez(dash)online(dot)ch ... Pushing the limits of my equipment
User currently offlineLindy From , joined Dec 1969, posts, RR:
Reply 11, posted (10 years 3 weeks 3 days 19 hours ago) and read 2418 times:

Brian,

Creating this particular database was very time consuming. If you want I can send you my blank dbase so you can try it.
I've send it before to other people from this forum. Here is Read Me First text. From this text you can get idea how does it work:

READ MEA Middle East Airlines (Lebanon)">ME FIRST!!!


************************************************************************

When you double click on AVIATIONDB.MDB icon SWITCHBOX will appear.
You will have 3 options:

1.Forms
2.Reports
3.Exit

************************************************************************

FORMS

When you click on FORMS another 5 options will be displayed

1.Add Photo Info
2.Add Aircraft Maker
3.Add Airline Info
4.Add Location Info
5.Back

Option #1 - Add Photo Info.
This is main table where you will enter all your data. But before you enter any info you
should go and add AIRLINE INFO. I left some airline names in that field so they will show in the pull down menu when you go to main ADD PHOTO INFO table.

Option #3 - Add Airline Info.
Here you will add names of your airlines. Remember - Airline Code ID is your UNIQUE KEY. If you have pictures of United Airlines then Airline Code ID can be UA or UAL. You will have to enter it only once for each airline.

TIP - To make your life easier entering data to this database follow one rule. In Add
Airline Info enter name of (egz.) United Express with Code ID UAX, then when you are ready to enter United Express pictures, just pull down from the menu UNITED EXPRESS, and in Operated By field enter (egz.) Air Wisconsin or Atlantic Coast Airlines. Always try to minimize you AIRLINE LIST because it can take you some time to look it up in the pull down menu. (Like US Airways Express - I'm using CODE ID USX, which is universal, and in Operated By I'm typing PSA or Piedmont).

Option #2 - Add Aircraft Maker
If you have pictures of different type of aircrafts that are not in the database then just
add it there.

Option #4 - Add Location Information
I'm using 3-letter code for the airports. You can use either one, 3 or 4 letter codes.
3 letter codes will save you some space in your reports.

Option #5 - Back
Will take you back to previous main screen.


************************************************************************


ADD PHOTO INFO

In the first field number will be assigned automatically.
Photo date - field is set for USA format (egz. 10/29/99 - Month/Day/Year)
Location - Select desired location
Airline Name - Whatever you have entered in Add Airline Info box, this will be displayed in that pull down menu.
Aircraft Maker - if something is missing here just add aircraft in Add Aircraft Maker box.
Aircraft Type - Purposely I didn't make it Pull down because your list would be endless.
After selecting Aircraft Maker (egz. Boeing) type 757-223, or just type 757-200. I'm typing 757 or 757-200 because it takes less time and after you enter 100+ pictures you can do batch update which saves you lots of time.

Rest in this table is pretty easy and you can figure it out by itself.

************************************************************************
* REMEMBER!!!!!! PHOTOID IS YOUR UNIQUE/UNIVERSAL PICTURE * *NUMBER. DON'T *
* CHANGE IT IN DATABASE WHILE OPENING WITH THE SHIFT KEY. * * *
************************************************************************


On the very bottom of your ADD PHOTO INFO Table you have 3 icons.
1.Diskette with pencil - it saves your record
2.Two Tables - Registration Number Search option (good for batch updates)
3.Door - Exit to Switchbox



************************************************************************
REPORTS


Here you will find 7 custom reports. I created them for my needs (I am fleet collector)
Of course you can add more reports, you can customize those anyway you like it.



************************************************************************

Have fun!!! If you have more questions you can email me at tipekusair@yahoo.com

(c) Rafal Szczypek 2002


User currently offlineBDLGUY From United States of America, joined Dec 2000, 194 posts, RR: 4
Reply 12, posted (10 years 3 weeks 3 days 10 hours ago) and read 2383 times:

As a tail numbers collector, I use an Excel for my aviation logs database but in the future, I am planning to create my new "Aviation Logs" in the Access database. Does anyone use the Access database for logging the registration numbers? I am interested in seeing the sample Access database like Lindy posted his cool "Aviation Photo Database" in this forum which would help me some ideas what I want to create the Access database for my registration number logs.

Thanks a lot!  Smile/happy/getting dizzy
John Perrotta



John A. Perrotta (KBDL/BDL) - Canon 300D/400D & EF 75-300mm f/4-5.6 IS USM
User currently offlineBruce From United States of America, joined May 1999, 5057 posts, RR: 15
Reply 13, posted (10 years 3 weeks 3 days 8 hours ago) and read 2352 times:

I use an Excel database which I created. it holds all of the info about the airplane and/or the shot but it doesnt actually have a link to the photo on my h/d, I supppose i cold put a link in one of the colums but i am not an excel expert. The "finished" aviation photos are saved on my h/d with the filename being the photo id number so i can cross reference a picture from my excel db.

Also, Excel has a function called auto Filter for each column so I can with a couple of clicks sort thru my 1,359 a.net uploads and see that of Comair I have 22 shots of CRJ-100, 6 shots of CRJ-700, 9 shots of CRJ-200. I just have not figured out how to sort by unique reg #s since i might have 2 shots of one plane.

I looked at Lindy's Access database but for some reason Access seems quite complex for me.

Breezebrowser doesn't do what you are looking for, Brian. If you'd like a sample copy of my excel database to see what it looks like just write me.

Karlok, what program do you use for that? Excel or Access or ?

bruce



Bruce Leibowitz - Jackson, MS (KJAN) - Canon 50D/100-400L IS lens
User currently offlineFutterman From United States of America, joined Sep 2003, 1301 posts, RR: 43
Reply 14, posted (10 years 3 weeks 3 days 7 hours ago) and read 2348 times:

Wow. Lots to cover...
______

Although not SO expensive, I don't want to buy a program right now. Elaborate file conversion and filing formats are nifty, but basically all I'm after is a database with complete photo information and where to find it--not necessarily something that'll fetch the image...I just want it to tell me where it is. If it saves me $50+, I'm not complaining.

(Actually, disregarding what I just said, I'll keep www.photools.com in mind. If it's good enough for Colin, well, it's good.  Big grin)
______

Rafal, the readme looks interesting and I think it's worth a shot. It seems as if Access isn't on my home PC, so I'll try and get the copy of MS Office from my dad's office to download it.

He (dad) did tell me, though, that creating a database with Access is as thorough and complicated as the new inventory management system that the distribution company he works for just implemented.

You have mail.
______

Bruce, I think Excel is a little too basic for archival purposes like these--an 'automated' system like the ones Karlok and Rafal have created (and to which Royal and Colin have linked) practically ensure a consistent, even display of information where formatting grids and messing around with information isn't necessary.
______


Thanks. I MAY buy a program, I may not, but something about the elbow grease associated with Access appeals to me.

Elbow grease...yeah, and if my flexing self-portrait comes to mind...go figure, right? lol


Brian



What the FUTT?
User currently offlineClickhappy From United States of America, joined Sep 2001, 9633 posts, RR: 68
Reply 15, posted (10 years 3 weeks 3 days 5 hours ago) and read 2315 times:
AIRLINERS.NET CREW
PHOTO SCREENER

Brian, the challenge to developing any data-driven system is how you tackle the data model, you want it normalized, but not over-normalized.

My system breaks down as follows:

tblAircraft, tblAirline, tblAirport, tblImage, tblManufacturer

Basically each table except tblImage contains a unique key (auto generated int) and the description. tblImage contains the image info, plus the look up info for each of the four info tables.

So the query would look something like:

Select tblImage.ImagID, tblImage.ImagDesc, tblImage.AircID, tblImage.AirlID, tblImage.AirpID, tblImage.ManuID, tblAircraft.Aircraft, tblAirport.Airline, tblAirport.Airport, tblManufacturer.Manufacturer
FROM tblImage
LEFT JOIN tblAircraft on tblImage.AircID = tblAircraft.ID
LEFT JOIN tblAirline on tblImage.AirlID = tblAirline.ID
LEFT JOIN tblAirport on tblImage.AirpID = tblAirport.ID
LEFT JOIN tblManufacturer on tblImage.ManuID = tblManufacturer.ID

or something like that, im watching Major League now, great movie  Big thumbs up


User currently offlineBronko From United States of America, joined Jul 2001, 810 posts, RR: 11
Reply 16, posted (10 years 3 weeks 3 days 5 hours ago) and read 2306 times:

Royal, I would be happy to help test your app, being in the software testing biz and all.

I just setup a server for home that has a 750 GB RAID 5 array, and I want to get serious about setting up a database. I have lost a few sales because I could not efficiently find the photo(s) of the plane in question.



Jet City Aviation Photography
User currently offlineClickhappy From United States of America, joined Sep 2001, 9633 posts, RR: 68
Reply 17, posted (10 years 3 weeks 3 days 4 hours ago) and read 2305 times:
AIRLINERS.NET CREW
PHOTO SCREENER

Sure Big grin

The front end takes the query results, and outputs a thumbnail gallery. From there you can click thru to a larger version of the file. I don't store the image as a BLOB, rather the path of the image is stored in tblImage.

Still trying to work out the directory structure for storing the photos. Am open to suggestions on that. Im storing the actual RAW file name, so it would look like something like:

/Images/A-F/DSC8008.nef


User currently offlineKarlok From Netherlands, joined Mar 2002, 839 posts, RR: 1
Reply 18, posted (10 years 3 weeks 14 hours ago) and read 2201 times:

If my application reach the state of near finished.
The application is open for a beta test.

But no Beta release date so far.


Top Of Page
Forum Index

This topic is archived and can not be replied to any more.

Printer friendly format

Similar topics:More similar topics...
Portable Hard Drive For Photo Storage posted Sat Aug 27 2005 16:51:26 by DLX737200
Changing Data In A Database Photo posted Wed Nov 3 2004 00:33:48 by Sleekjet
Anyone Actually Using An IPod For Photo Storage? posted Fri Jul 23 2004 00:11:57 by Saxdiva
Photo Storage?....many Many Rolls! posted Mon Oct 14 2002 04:53:16 by Davus
How Long It Take Into Database Photo? posted Sat Nov 4 2000 23:40:50 by Big777jet
Eurocontrol Photo Database Update To Photographers posted Thu Sep 7 2006 11:19:53 by FlyAUA
My First Photo In The Database! posted Mon Feb 13 2006 04:34:27 by Thetford569
Photo Database Program - Macintosh posted Sun Dec 25 2005 04:23:22 by Daren3006
Photo Request For "Personal Collection" posted Mon Aug 8 2005 12:17:05 by FlyingZacko
Removing A Photo From The Database posted Fri May 20 2005 23:47:47 by Hpr7