PowerShell Photo CSV + KML Generator

Overview

This Windows PowerShell script scans a selected folder and all subfolders for JPEG photos and generates:

• photo_metadata.csv with GPS, date taken, parsed Title fields, and Excel hyperlinks
• photo_map.kml for Google Earth with embedded images

General Workflow

1. Take photos using the SKHighway Locator app
2. Transfer photos to Windows without compression
3. Ensure photos are .jpg / .jpeg
4. Place all photos into one root folder (subfolders allowed)
5. Run the PowerShell script and select the root folder
6. Open the CSV in Excel and the KML in Google Earth

Running the Script

PowerShell Console

1. Download the script
2. Right-click → Properties → Unblock
3. Run the following:

Set-ExecutionPolicy -Scope CurrentUser -ExecutionPolicy RemoteSigned
Unblock-File "C:\Path\To\SKHighway Locator Powershell Script.ps1"
powershell -ExecutionPolicy Bypass -File "C:\Path\To\SKHighway Locator Powershell Script.ps1"

PowerShell ISE

1. Open PowerShell ISE
2. File → Open → select the script
3. Press F5
4. Select your photo root folder