Skip to content

Instantly share code, notes, and snippets.

@talaj

talaj/fix_kappa.sql

Created February 9, 2015 09:23
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save talaj/a14427e4a436dc4e9b36 to your computer and use it in GitHub Desktop.
Save talaj/a14427e4a436dc4e9b36 to your computer and use it in GitHub Desktop.
Download ZIP
fix kappa
Raw
fix_kappa.sql
update panorama p1 set kappa=(180.0 / pi()) * st_azimuth(p1.the_geom, (select p2.the_geom from panorama p2 where p2.timestamp > p1.timestamp order by timestamp limit 1)) where filepath like '/topgis/Vltava20112012%';
@talaj
Copy link
Author

talaj commented Feb 9, 2015

Je potřeba vytvořit index nad timestamp.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment