Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
SQL For Everything
Search
wboykinm
May 08, 2013
Technology
1
320
SQL For Everything
Geoprocessing, Cartography and the Web with PostGIS and CartoDB
wboykinm
May 08, 2013
Tweet
Share
More Decks by wboykinm
See All by wboykinm
Printing to a 2'x3' (Arch D) Poster on the Jeffords Plotter
wboykinm
0
130
Segmenting Biodiversity
wboykinm
0
110
Curating the Storm: TS Irene in Vermont
wboykinm
1
1.5k
irene_foss4g1.pdf
wboykinm
0
71
Other Decks in Technology
See All in Technology
S3アクセス制御の設計ポイント
tommy0124
3
190
LLMを搭載したプロダクトの品質保証の模索と学び
qa
0
1k
RSCの時代にReactとフレームワークの境界を探る
uhyo
10
3.3k
大「個人開発サービス」時代に僕たちはどう生きるか
sotarok
20
9.8k
【実演版】カンファレンス登壇者・スタッフにこそ知ってほしいマイクの使い方 / 大吉祥寺.pm 2025
arthur1
1
760
La gouvernance territoriale des données grâce à la plateforme Terreze
bluehats
0
150
Flutterでキャッチしないエラーはどこに行く
taiju59
0
230
react-callを使ってダイヤログをいろんなとこで再利用しよう!
shinaps
1
230
Aurora DSQLはサーバーレスアーキテクチャの常識を変えるのか
iwatatomoya
1
790
Webアプリケーションにオブザーバビリティを実装するRust入門ガイド
nwiizo
6
760
AIエージェント開発用SDKとローカルLLMをLINE Botと組み合わせてみた / LINEを使ったLT大会 #14
you
PRO
0
100
自作JSエンジンに推しプロポーザルを実装したい!
sajikix
1
170
Featured
See All Featured
Performance Is Good for Brains [We Love Speed 2024]
tammyeverts
12
1.1k
How to Ace a Technical Interview
jacobian
279
23k
The Success of Rails: Ensuring Growth for the Next 100 Years
eileencodes
46
7.6k
The Illustrated Children's Guide to Kubernetes
chrisshort
48
50k
Exploring the Power of Turbo Streams & Action Cable | RailsConf2023
kevinliebholz
34
6k
Practical Orchestrator
shlominoach
190
11k
Music & Morning Musume
bryan
46
6.8k
XXLCSS - How to scale CSS and keep your sanity
sugarenia
248
1.3M
Automating Front-end Workflow
addyosmani
1370
200k
What’s in a name? Adding method to the madness
productmarketing
PRO
23
3.7k
KATA
mclloyd
32
14k
Design and Strategy: How to Deal with People Who Don’t "Get" Design
morganepeng
131
19k
Transcript
SQL For Everything Geoprocessing and Cartography With PostGIS Bill Morris
– Geosprocket LLC
Speedy Background • SQL = Structured Query Language • Beloved/BeHated
by Database Admins • Runs Behind Nearly Everything SQL For Everything - Bill Morris - Geosprocket LLC
Ever Fired Up a Computer? You’ve Used SQL. SQL For
Everything - Bill Morris - Geosprocket LLC
So What’s PostGIS? • A spatial extender for the PostgreSQL
database system • Free as in Speech, Free as in Beer SQL For Everything - Bill Morris - Geosprocket LLC
What’s Post-PostGIS? • A parody on Twitter. Pay no mind.
SQL For Everything - Bill Morris - Geosprocket LLC
What’s CartoDB? • A PostGIS environment built for the web
• “Open-Source Fusion Tables” • Build your own server: https://github.com/CartoDB/cartodb20 • Or get a hosted account: http://cartodb.com/ SQL For Everything - Bill Morris - Geosprocket LLC
SQL For Everything - Bill Morris - Geosprocket LLC
SQL For Everything - Bill Morris - Geosprocket LLC
Back to SQL. SQL For Everything - Bill Morris -
Geosprocket LLC
SQL as we know it SQL For Everything - Bill
Morris - Geosprocket LLC Source: Chicago Crime Commission & Openstreetmap Contributors
SELECT * FROM territory_all WHERE “NAME” LIKE ‘Latin%’ SQL For
Everything - Bill Morris - Geosprocket LLC Source: Chicago Crime Commission & Openstreetmap Contributors
SELECT * FROM territory_all WHERE name LIKE ‘Latin%’ SQL For
Everything - Bill Morris - Geosprocket LLC
Geoprocessing as we know it SQL For Everything - Bill
Morris - Geosprocket LLC
Geoprocessing in PostGIS SQL For Everything - Bill Morris -
Geosprocket LLC SELECT ST_Whatever( geoprocess! )
Geoprocessing in PostGIS SQL For Everything - Bill Morris -
Geosprocket LLC
Buffer 500m SQL For Everything - Bill Morris - Geosprocket
LLC
Buffer 500m from the points that fall on Ashland Ave
SQL For Everything - Bill Morris - Geosprocket LLC
Append two layers of different geometry types SQL For Everything
- Bill Morris - Geosprocket LLC
Geoprocessing Optimized SQL For Everything - Bill Morris - Geosprocket
LLC …png?sql=…
? SQL For Everything - Bill Morris - Geosprocket LLC
This is Familiar SQL For Everything - Bill Morris -
Geosprocket LLC google.com?q=GIS
SQL For Everything - Bill Morris - Geosprocket LLC …png?sql=…
http://2.tiles.cartocdn.com/geosprocket/tiles/vtparcels_burlington2002b/15/9714/11850.png SQL For Everything - Bill Morris - Geosprocket LLC
http://2.tiles.cartocdn.com/geosprocket/tiles/vtparcels_burlington2002b/15/9714/11850.png?sql =SELECT * FROM vtparcels_burlington2002b WHERE area>8000 SQL For Everything
- Bill Morris - Geosprocket LLC
http://2.tiles.cartocdn.com/geosprocket/tiles/vtparcels_burlington2002b/15/9714/11850.png?sql =SELECT 20 as distance, st_buffer(the_geom_webmercator,50) as the_geom_webmercator FROM vtparcels_burlington2002b
WHERE area>80000 SQL For Everything - Bill Morris - Geosprocket LLC
Going off the Rails a Bit . . . SQL
For Everything - Bill Morris - Geosprocket LLC https://gist.github.com/wboykinm/5533575
SQL For Everything - Bill Morris - Geosprocket LLC
A Query Turns This . . . SQL For Everything
- Bill Morris - Geosprocket LLC
Into This. SQL For Everything - Bill Morris - Geosprocket
LLC
I’m barely scratching the surface of SQL here. SQL For
Everything - Bill Morris - Geosprocket LLC https://gist.github.com/wboykinm/5533575
Because the web wants to see your data SQL For
Everything - Bill Morris - Geosprocket LLC Why Care?
SQL For Everything - Bill Morris - Geosprocket LLC
SQL For Everything - Bill Morris - Geosprocket LLC
SQL For Everything - Bill Morris - Geosprocket LLC
SQL For Everything - Bill Morris - Geosprocket LLC
SQL For Everything - Bill Morris - Geosprocket LLC PostGIS
Thanks! Accepting all questions: SQL For Everything - Bill Morris
- Geosprocket LLC
[email protected]
@vtcraghead