A friend of mine asked me an interesting question... Given a flight path (a linestring of sorts), can one determine which countries the flight overflew? My guess was to define the path as a linestring (maybe with a width, if that's possible), and then use STIntersect to determine the countries overflown.
Is there an example of something like that anywhere? (I haven't found one yet)