Sponsor Message:
Aviation Hobby Forum
My Starred Topics | Profile | New Topic | Forum Index | Help | Search 
Spotting Database (Logbook)  
User currently offlineKetko2 From Slovakia, joined Sep 2006, 103 posts, RR: 0
Posted (5 years 11 months 1 week 6 days 3 hours ago) and read 17796 times:

Hi all!

I have one question for regspotters: What software do you use to log your sightings on PC?
If you create your custom DB in access, ... could you please post some screenshots?

I am trying to find the right solution for myself.

Thanks for reply.

Best regards, Keishi Nukina

9 replies: All unread, jump to last
 
User currently offlineEIDAA From Ireland, joined Oct 2006, 828 posts, RR: 16
Reply 1, posted (5 years 9 months 3 weeks 5 days 6 hours ago) and read 17317 times:
Support Airliners.net - become a First Class Member!

I would also like to know what other software people use.

I currently just use MS Excel, tracking the operator, type, registration, MSN, date, location and "comments". Unfortunately with around 4,000 entries at this point, auto-filters tend to drop certain data from searches, so I would be interested to know what others use.

Thanks
EIDAA



Most Flown:- G-BUVA (20 Flights), EI-DEB (12 Flights), EI-JFK (11 Flights)
User currently offlineKetko2 From Slovakia, joined Sep 2006, 103 posts, RR: 0
Reply 2, posted (5 years 9 months 3 weeks 5 days 3 hours ago) and read 17309 times:

Hi,

I started using Access recently. I have created a set of tables, one for airframes which includes ID, which is the CN with a prefix, so I can set it as a unique value (for eg. A32S.2143), then it has the CN itself, LN, Manufacturer, Type and Subtype. It also includes frame type (jet, prop,...) and the registration it was wearing when last seen.

The second table is called Sightings and it includes data about each sightings of a particular airframe - ID to relate it to the previous table, Registration, Operator, Location, Date, Remark and a * if it is first time seen.

Last main table is table Photos, which is unrelated to the other two, however I have an auto-fill on my form, so it automatically fills remaining data after entering registration of the plane on the photos. It also contains location of the photo on the disc, so it can display it.

Beside that, I have a couple of forms and reports, which help me organizing/browsing the data.

Firstly there is the main form, which just has buttons to go to the others.


Then there is the 'logging tool', which I use to input data about the sightings. The upper part contains detail about the frame selected in the bottom part. The default data for the new sightings can be set on the main page for the ease of inputting frames from one trip.
http://img359.imageshack.us/img359/4505/daloggingnp2.jpg

Finally, there are two forms for managing/browsing the photos table.
First is a form for adding them. And the second is for browsing. The browsing form isnt great, but Im working on making it better.
http://img391.imageshack.us/img391/9359/dbaddvl0.jpg
http://img114.imageshack.us/img114/4418/dbbrowseca7.jpg

I also have created some report, for the ease of browsing.

That's it. Firstly I wanted to buy ADU or some other commercial product, but then, I found iout, that I dont need tens of thousands of airframes already in, so I decided to craete my own one and Im happy with that decision to say.

Now I only have to input three years worth of frames/sightings/photos.

Best regards, Keishi


User currently offlineNWADC9 From United States of America, joined May 2004, 4896 posts, RR: 10
Reply 3, posted (5 years 9 months 3 weeks 4 days 18 hours ago) and read 17292 times:


The word "used" to describe the condition of my copy is an absolute understatement. Page after page of my markings on the reg numbers-sightings, aircraft I flew on, additions, retirements. It's WEEEEEEEEEEEEEEEEEEEELLLLLLLLLLLLLLLLLLLLLLLLLLLLLL used!!!



Flying an aeroplane with only a single propeller to keep you in the air. Can you imagine that? -Capt. Picard
User currently offlineMidEx216 From United States of America, joined Jun 2005, 651 posts, RR: 4
Reply 4, posted (5 years 8 months 4 weeks 1 day 16 hours ago) and read 16913 times:

I use Notebook v1.0. It was going well, but then I decided to get the pencil / eraser addon, so I could fix mistakes more easily Big grin


"Cue the Circus Music!"
User currently offlineMidEx216 From United States of America, joined Jun 2005, 651 posts, RR: 4
Reply 5, posted (5 years 6 months 1 week 5 days 16 hours ago) and read 16082 times:



Quoting Ketko2 (Reply 2):
I started using Access recently

So...how do you get it to look like what you have? I would love to use that, but from what I've seen, it's completely different...



"Cue the Circus Music!"
User currently offlineKetko2 From Slovakia, joined Sep 2006, 103 posts, RR: 0
Reply 6, posted (5 years 6 months 1 week 2 days 5 hours ago) and read 15967 times:

Hi.

What do you mean by "its completely different'?

Regards, Keishi


User currently offlineMidEx216 From United States of America, joined Jun 2005, 651 posts, RR: 4
Reply 7, posted (5 years 6 months 1 week 1 day 19 hours ago) and read 15949 times:



Quoting Ketko2 (Reply 6):
"its completely different'

I mean, it does not look like that. Unless I saw a different version... I would love to use the program that he posted pictures of. What is it, and how do I make it like that?



"Cue the Circus Music!"
User currently offlinebrumgav From UK - England, joined Jul 2012, 5 posts, RR: 0
Reply 8, posted (11 months 2 weeks 2 days ago) and read 6421 times:

Hi,

I know this thread is old now but I guess there are still some people looking for this. What about this website, http://spottedplanes.co.uk

Really good website for logging planes you see and its free too. Filter and search on logged aircraft is really useful.

Check it out!


User currently offlinenighthawk From UK - Scotland, joined Sep 2001, 5126 posts, RR: 34
Reply 9, posted (11 months 1 week 4 days ago) and read 6247 times:

There's also www.planelogger.com

They have their own database so you don't need to enter the information yourself - just enter the reg and it will look it up for you.

It's also a great site just for looking up registrations, they have one of the largest databases of regs on the net - pretty much every aircraft that's ever been built since the end of WWII. They've got everything from Comets to 787's. Even the Space Shuttle and Spruce Goose are in there!



That'll teach you
Top Of Page
Forum Index

Reply To This Topic Spotting Database (Logbook)
Username:
No username? Sign up now!
Password: 


Forgot Password? Be reminded.
Remember me on this computer (uses cookies)
  • Aviation hobby related posts only.
  • Back all your opinions with facts.
  • No adverts of any kind. This includes web pages.
  • No hostile language or criticizing of others.
  • Do not post copyright protected material.
  • Use relevant and describing topics.
  • Check if your post already been discussed.
  • Check your spelling!
  • DETAILED RULES
Add Images Add SmiliesPosting Help

Please check your spelling (press "Check Spelling" above)


Similar topics:More similar topics...
Registration/spotting Database posted Sun Aug 29 2004 04:16:48 by Canberra
Spotting Deck @ FRA posted Tue Jul 8 2008 18:31:50 by FlyAA757
Spotting tips for LHR? posted Sun Jun 29 2008 06:40:02 by FEDEX35
UK A380 Spotting! posted Thu Jun 19 2008 04:00:27 by Kris
Spotting Guide? posted Sat Jun 7 2008 11:19:57 by Phileet92
Help: Need Good Aviation Spotting Book! posted Sun Apr 27 2008 10:50:00 by Vinniewinnie
Acars Tracking, Logbook And Dispatch Tool posted Fri Apr 11 2008 21:16:03 by ReguPilot
Scopes/Monoculars Good For Spotting Regs? posted Fri Apr 4 2008 16:14:40 by DFW13L
Interested In IND Spotting? posted Mon Jan 28 2008 12:54:50 by ATAIndy

Sponsor Message:
Printer friendly format