It looks like you're using an Ad Blocker.
Please white-list or disable AboveTopSecret.com in your ad-blocking tool.
Thank you.
Some features of ATS will be disabled while you continue to use an ad-blocker.
Do it programmatically yourself, using your own application to parse a CSV file and create KML out of it. For an example, check out Converting CSV files to KML.
Use an online spreadsheet. For instance, the Google Earth Outreach team has created a Spreadsheet Mapper based on Google Spreadsheets.
Use one of the Excel to KML creation tools, such as [link to tek's thread]this one
Use Google Earth Plus or Pro to load the files and then save them as KML or KMZ files
originally posted by: WeAre0ne
I followed the "do it programmatically yourself" route, since I am a software systems engineer and everything. If you need help or have questions let me know. I was going to make a tool and share it with you all.
What kind of Google Earth KML were you looking to create? A "FlyBy" that will simulate the camera view of the video? Or just place markers and LineStrings that will draw the paths of the aircraft and hopefully the UFO?
By the way, did you ever read my U2U. Its outdated now, but just wondering.
originally posted by: WeAre0ne
I only extracted every 35 frames.
I don't need to scroll through a PDF, I wrote a program that flips through each frame image and attempts to OCR the data... I've seen the data.
originally posted by: Ektar
Hey Isaac is there any more boring & easy stuff to be done?
I will be back late afternoon & I will help if there's something I can do.
Basically:
(1) Download the current (incomplete) Excel spreadsheet:
prrr.isaackoi.com...
(2) Pick an incomplete column and post here that you will complete that column. The columns that remain to be done or are currently incomplete are I, R, U, V, W, Z, AD, AH, AJ, AK, AL, AM, AN, AU and AY.
(3) Scroll through the frames and fill in the values. Using the PDF versions of the frames in Abobe Reader is probably the easiest way to quickly scroll through the frames. The values do not change in every frame so you can generally cut and paste (or use the Excel "fill" menu and the down option) to cut and paste a relevant value down a column until the frame where the value changes. The PDF versions of the frames are in two files, at:
prrr.isaackoi.com...
prrr.isaackoi.com...
I should warn you, having done quite a few of the columns myself already, that it is pretty boring work.
originally posted by: Excallibacca
I'll knock out another few thousand tonight and hopefully will be done tomorrow night. ... I'll mail out the first batch in around 2 hours when I'm off work.
originally posted by: IsaacKoi
While work on manual entry by a few people (including me) slowed following your post, that manual entry of data was not completely stopped while awaiting sight of the data you mentioned and the significant columns of the spreadsheet should be completed soon.
originally posted by: WeAre0ne
Sorry about that!
Since you said that, I developed another technique / program that allowed me to manually get the values much faster than OCR. Here I completed column AD and AH in about an hour.
originally posted by: Ektar
I'm up to Frame 693...I will be back later this afternoon to continue.
Ektar