Photo Processing & Mapping Tools

Convert SKHighway Locator photos into professional CSV and KML outputs for Excel, GIS workflows, and Google Earth visualization.

Download PowerShell Script

Overview

This Windows PowerShell utility scans a selected photo folder and all subfolders to automatically generate:

  • photo_metadata.csv containing GPS coordinates, photo dates, parsed title fields, and Excel hyperlinks.
  • photo_map.kml for Google Earth with georeferenced image previews.
Portable by Design: All generated links use relative paths, allowing folders to be moved or archived without breaking references.
Download Script (.ps1)

Workflow

1
Take photos using SKHighway Locator.
2
Transfer photos to Windows without compression.
3
Verify photos are JPG or JPEG format.
4
Place all photos in a root folder. Subfolders are supported.
5
Run the PowerShell script and select the folder.
6
Open the CSV in Excel and the KML in Google Earth.

Running the Script

PowerShell Console

Download the script, unblock the file, and execute it using: 

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 folder when prompted
If the folder-selection dialog does not appear, ensure PowerShell ISE is the active window and press F5 again.