Gettysburg Battlefield Photos for $5

Visit my Fiverr page to order pictures of the Gettyburg Battlefield, monuments or other places of interest.

http://www.fiverr.com/mykmyrs/take-a-digital-photo-at-gettysburg-battlefield?gig_id=3096616&utm_campaign=base_gig_show_share&utm_content=&utm_medium=shared&utm_source=get_url&utm_term=&view=gig

 

Google Panoramio and GPS for Grave Sites

2014/04/30 1 comment

Recently I found the site http://www.panramio.com while looking for a way to map grave photos I had captured with my cell phone with embedded GPS.  I wanted to map the exact location of the headstones so that my ancestors were documented well and to make it easier for others to find the grave sites.

As you may know, consumer GPS is not completely accurate in its ability to provide locational data, and it is proners.   I had heard this claim, but it wasn’t until I got home and started to work with panoramio that I noticed how much it could be off.  One of my cemetery photos had embedded GPS coordinates that were almost a half of a mile away from the actual location!  I was not off to a good start.

In Panoramio, when you upload a photo, it automatically looks for GPS information stored within the photo’s EXIF data.  If found, it attempts to automatically map the location from the discovered data.  A few brief web searches told me that the problem probably lies within the date and time of the photo and how it relates to a GPS tool’s interpretation of rotational data of the Earth.  More than I wanted to know, but I can understand that somehow things didn’t mesh correctly, leading the site to tell me that I was in the general area on that date and time.  Fair enough.

Here’s what I like about Panoramio:  You manually can fix the GPS location information for your photo.  To the right of the uploaded photo is a handy little Google map feature.  Use it to find the location of the photo, drop the little camera icon on it and save.  Now when you browse a photo you’ve saved, the map widget displays the location you supplied.

Panoramio does many, many things that I haven’t really reviewed personally at this time.  It goes through your photos once per month to see if any can be included in Google Maps and Google Earth.  Since these are grave stones I am working with, on public property, I really don’t mind if Google uses them.  It also enhances your images automatically when you upload them, and trust me when I say uploading photos to the site is a time-consuming effort.

Lastly, you can assign tags to photos when you upload them, or edit them to include tags afterwards.  The tags allow you to filter which pictures show on the screen which can be very helpful.  For example, I may only want to look at stones I photographed in 2013 in a certain cemetery.  Selecting my two tags (“2013” and “Cemetery Name”) , the view is filtered and reduces my need to scroll through pages of photos to try to locate them.  Very helpful.

If you have a chance and you’d like to document a location in a photo, give Panoramio a try.  It’s free and if you already have a Google account you can log in with that.

Let me know if you found this post helpful.  I’d like to know of other sites folks use to add GPS information to their photos.

Categories: Genealogy Tags: , ,

How To Replace Ice Door Flap on GE GSH25KGMC CC

Recently, I noticed that my water dispenser on my GE refrigerator was freezing up, preventing water from being released into a drinking glass.  When looking at the ice chute from inside the door, the flapper was not sealing tightly, causing the freezer air to fall onto the water line and causing it to freeze.  Seeing as how the fridge is 12 years old, it seemed reasonable to replace the flapper.

The replacement flap, GE item number WR17x11653, is available from many places on the web.  I ordered mine at AppliancePartsPros.com.  I ordered on their site on a Thursday evening and it was at my front door in 2 days.  Excellent service and the part cost me around $12 with shipping.

I found an excellent video on YouTube showing how to replace the flapper part.  The video was extremely helpful and within a few minutes of watching my flapper was replaced properly.  Here’s the link to the video.

The only issue I had was after the new flapper was installed is it doesn’t always close after dispensing ice.  For now, we can live with that but I would like to find out why the flapper does not close properly.

Photo of George Blessing

I am really looking forward to Tuesday, August 20, 2013.  After months and months of trying to locate any existing photographs of my great-great grandfather George Blessing, I’ve gotten a break-through!

I met a distant relative with the help of several distant relatives and we exchanged e-mails over the course of the last year or so.  Turns out she works for the school district I live in, and my wife was good friends with one of this lady’s direct relatives.  It’s truly a small world.  Back in June, she invited me to her home to meet her in person, and to meet her mother and her mother’s sister.  We had a nice afternoon and we ended up with me seeing a photo of George’s wife, Anna Burg, from the early 1900s that is framed and hanging on a wall.  I had only seen the “older” Anna in the photos I have, so I was blown-away to finally see her as a young lady.

But the big problem still remained at that point:  Were there any photos to be found of Anna’s husband George?  The family members believed there was a matching photo of George to young Anna’s, but no one had seen it in years.  While it was amazing to hear of the photo, it was even more frustrating that it couldn’t be easily located.  I told myself to be patient and I said out loud, “You are not going to elude me forever, George Blessing!”

It is with great joy that I tell you the missing photo has been located, and I get to pick it up on 20 Aug.  I cannot wait to see what Mr. George looked like as a young man.

What’s Your Account Number, Sir?

Recently, I purchased a car and had to finance the sale.  The lender who financed it, a large Pennsylvania Credit Union, happened to be close to my work and to my primary lending institution, so everything appeared to have worked out for me to save time, postage and for me to be able to pay my new payments in cash, in person.

Today I walked into the new credit union to pay my loan payment, with cash, in person.  I removed the first payment slip from the loan payment book before leaving for work, so I had it in-hand.  I went to my credit union over my lunch break and withdrew the cash I needed to pay the loan payment, cash in-hand.  As I was coming from work, I still was wearing my work photo identification, which was easily viewable, with my name and photo-likeness.  So far so good, right?  Not so much!

When I got to the window, where I intended to make my first loan payment, the teller asked me for an account number.  I told her I had no idea what my account number was, but I did have the loan payment slip which had my name and address on it (not to mention that photo ID hanging around my neck…).  She told me that loan payment slip wasn’t acceptable because my account number was only partially listed on it.  Now, again, this is the same slip I am supposed to include with a check when I mail the payment to their office.  I was a little confused to say the least.  I was supposed to have received a letter with my account number, and another letter with my PIN, and for argument’s sake I did.  I guess I was supposed to sit and memorize them before my first visit.  Silly me.

Then she decided, since I was just another idiot who didn’t know his account number, to look me up in her system (What a concept!).  She found me in her search results and then asked me what my pin number was.  Again, I said I had no idea.  Would my check be able to tell someone my account number and pin number if I had mailed it?  I doubt it, but then again I am the idiot here.  After some light huffing and eye-rolling, we continued towards trying to make my loan payment, with cash in- person.

She went about her business and processed the payment.  She grumbled something about needing a PIN to give me an updated balance.  I reminded her that this was payment number 1 of many to follow and that an updated balance was the least of my concerns at this point.  After a piercing look of stupidity, in my direction, she gave me a receipt and told me to have a nice day.  Although I heard those words, I think she may have been meaning something entirely different.

Is life so difficult now that when someone doesn’t follow the scripted behavior that we somehow are harder to help?  I did my transaction as about as old-school as one could get.  Payment slip, issued by lender, cash in-hand and photo ID around my neck.  Was that so difficult to process?  Was it difficult to query the customer base, find my loan and drill into it on her system?

Most days I just scratch my head in confusion, but today I am missing a spot on my head for sure.  And the good news….only 59 payments to go!!

Sites Family Reunion

Updated 08 Aug 2013 – Changed Date and added time.

If you are part of the Sites family, primarily originating from south-central Pennsylvania, this information may help you find and attend the annual Sites Reunion.

The Sites family had a large basis in the Gettysburg, PA area during the 1800s and early 1900s.  There are 3 individuals that most of us will have descended from:  Andrew Jackson Sites, George Frederick Sites or John Calvin Sites.  All three brothers served in some capacity in the American Civil War.  I am a descendent of George F., who had about 18 children with two different spouses.  Little to nothing is known about Andrew as it appears from my research that he left Gettysburg after the war and moved to the mid-west and lived the remainder of his life there.  I have met a John Calvin descendent with the help of the internet (Hey Andy W.!) but I do not know much about him.

The fortunate thing for descendents of the big three listed above is that the lines are well-documented, and if you join ancestry.com, you will easily find information for your Sites line.  You can probably even meet a distant relative while there too.  The unfortunate part is that many of the younger Sites descendents do not have their genealogy documented and many will not know from whom they descend unless they spoken to their grandparents or great-parents to gather the information.

If you would like to come to a Sites reunion, they are held the third Sunday each September in the Taneytown Memorial Park, located in Taneytown, Maryland.  It’s not far from Gettysburg, and the park is huge with plenty to do for the kids.

For 2013, the reunion is scheduled for Sunday, September 22 at 1:00 PM.

For more information, or to get on the mailing list, please contact Michele Sites at  msites1@verizon.net.  I encourage you to contact Michele, attend and share any genealogy and photos you may have.

Hope to see you there!

Michael R. Myers in Dover, PA

SQL Server – Re-seed Identity Value

To reset the auto-number value in an identity field, run this command.

DBCC CHECKIDENT (‘Table_Name’, RESEED, New_Numeric_Value)

To see what the next value is, run the command with just the table name.

DBCC CHECKIDENT (‘Table_Name’)

You can also use sp_help(‘Table_Name’) to view information about your table.  One of the items returned is the autonumbered field and what its seed is.

Categories: SQL Server Tags: , , ,
%d bloggers like this: