Programmatically determine intersection of flight paths and countries

• pietlinden

  SSC Guru

  Points: 62715

  More actions

  December 4, 2019 at 12:38 am

  #3704077

  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)

  Thanks!

• Site Owners

  SSC Guru

  Points: 80378

  More actions

  December 5, 2019 at 1:10 am

  #3704602

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• CGSJohnson

  SSCertifiable

  Points: 7047

  More actions

  December 6, 2019 at 2:54 pm

  #3705406

  Hope that this helps...

  https://stackoverflow.com/questions/5285674/sql-server-2008-using-stintersects-from-a-table-that-defines-a-country

  https://gisgeography.com/gis-applications-uses/ -- non-programmatic approach (just visualizing using Flight Radar 24)

  Thanks...Chris