knownasilya/README.md

Last active June 19, 2018 17:15

Star (1) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/knownasilya/b97e6c6810474355939351a9ce70da54.js"></script>
Save knownasilya/b97e6c6810474355939351a9ce70da54 to your computer and use it in GitHub Desktop.

Download ZIP

sql festival by Paul Ramsey

Raw

https://docs.google.com/presentation/d/1k3cyjTVLszJ1WMt_YdSJvTBeIC57WS4LeWyLj9x-w4g/edit#slide=id.g392f8bb753_0_0

groovy sql

nullif - convert empty string to null
concat_ws
FILTER

popular sql

window functions https://www.postgresql.org/docs/9.1/static/tutorial-window.html
tip: if you don't have global data, use local projections and don't use geography
MVT: mapnik vector tiles
case
intersection/intersects

far out spatial sql

st_subdivide for performance
< - > -- in order by via index (distance operator or knn)

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