Data Entry: Review videos, make video stills, and write down addresses

SUMMARY: I need someone to review 49 short videos (most are 3.5 minutes long), and make video stills with the addresses and license plates, and enter the addresses and license plates in a spreadsheet. I am filling out pollution complaints for trucks and vans with idling engines. In New York City it is against the law to idle for more than 3 minutes because it pollutes the air. I will provide a link to a Drive folder with the video files, and the spreadsheet. I have attached sample video stills, a screenshot of the spreadsheet showing the fields that need to be entered, and a text file with a URL for sample videos (they are too big to attach directly.) This will be a recurring task. I have been making about 50-100 videos a month. While I am, of course, looking for someone who is efficient, ACCURACY and COMMUNICATION are most important. Detailed Steps: 1. Review the videos and save up to three still JPG images that show license plate, address, and DOT number. This information is usually towards the start or the end of the video. You don't need to watch the whole video! Some videos will not have all the info but put everything you can find -- for example Amazon vans seem to not have an address or DOT. The three pieces of information: - license plate of the vehicle. If the vehicle is a truck with a separate trailer, the license plate of the truck (cab) is needed. Name this with FILENAME + 'lic" e.g. [login to view URL] - the company name and address. For Amazon Prime vans, just an image that shows the Amazon Prime logo. Name this with FILENAME + 'add" e.g. [login to view URL] - US DOT number. Name this with FILENAME + 'dot" e.g. [login to view URL] -- if there is no DOT, don't make an image for it. Just move on. Also, the DOT info is often next to the address, so may be in the same image. A few notes: - In many cases some of these will be present in the same image. In those cases, just add both names to the single file. e.g. [login to view URL] (it is not important what order they are in, just that they are noted.) - A few of the videos contain two vans/trucks next to each other, both of them are idling. In those instances, please make a set of stills for each vehicle. - In a few cases, I have taken photographs of the trucks to ensure I had the license plate/address. You can use these images, and don't need to make stills for to replace those. You want to download all the video files first. I have tested the Google Drive preview, and you can't scrub through the footage very easily, and it takes A LOT longer to find the info. REALLY IMPORTANT: The images need to be stills from the video, not screenshots of the screen. A screenshot produces a file that is smaller than the size of the actual video. Here is how to take a video still: Windows with Movies & TV app: [login to view URL] Mac with Quicktime/Preview: [login to view URL] Mac/Windows with VLC: [login to view URL] 2. Please input the license plate, company address, and DOT number for the van/truck into the Air Complaint Data sheet.- Only fill out Red and Yellow cells, leave the blue ones alone. - Some of the more common companies will autocomplete from a different tab: Amazon Logistics, Amazon Prime, Brinks, LABQ, etc. - CTS COVID rapid testing should be entered as "EZ RENTAL" per the name/address on the car door. It will auto-complete. - Don't worry about the location address. Only record the Company address, which is usually on the door of the truck cab - If the vehicle doesn't have an address, or parts of it are missing, just leave those cells blank. - No need to record permit tags, such as the waste conveyance permit on dump trucks. Pro Tip: If you are using a newer Mac, you can copy text directly from images. It is kind of astounding: [login to view URL]