Great Circle Calculations Are Not Your Friend

Making your computer do math like this, even with a good spatial index, can make things very slow. Stupid me!

I couldn’t figure out for the longest time why the PostGIS database I was using was so slow, after inserting a proper GIST index on it. But then when I saw the projection was EPSG: 4326, I said, that’s why. All that trigonometry even with a math-coprocessor and spatial index is going to be slow as a dog!

WV 55

Just a quick stop along West Virigina Route 55 as I headed down to Seneca Rocks then back across the Allegheny Front and ultimately back to camp.

Taken on Friday October 11, 2019 at West Virginia.