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
Yale 2013 Workshop
Search
Andrew W Hill
December 10, 2013
Technology
1
80
Yale 2013 Workshop
Free workshop given in New Haven in December 2013
Andrew W Hill
December 10, 2013
Tweet
Share
More Decks by Andrew W Hill
See All by Andrew W Hill
Space Race 2 - Slingshot
andrewxhill
0
37
Intro to Filecoin - Building apps with Powergate
andrewxhill
0
270
Into the Powergate
andrewxhill
0
150
Future of Pinning - storing Threads and Buckets at Textile
andrewxhill
2
280
Maps of Today/Tomorrow
andrewxhill
0
120
PopMaps - EcoViz Presentation
andrewxhill
0
110
What is a Map
andrewxhill
1
150
SCGIS Webinar
andrewxhill
0
260
Harvard Workshop - 01-2015
andrewxhill
0
100
Other Decks in Technology
See All in Technology
技術広報として2023年度に頑張ったこと / What we did well in FY2023 as a DevRel
pauli
5
490
Autopsy of a Cascading Outage from a MySQL Crashing Bug
jfg956
0
200
CI/CDがあたりまえの今の時代にAPIテスティングツールに求められていること / CI/CD Test Night #7
k1low
12
3.1k
生成AIサービスPanorama AIご説明資料
sdt
0
300
GitHub最新情報キャッチアップ 2024年3月
dzeyelid
17
3.2k
業務で使えるかもしれない…!?GitHub Actions の Tips 集 / CI/CD Test Night #7
ponkio_o
PRO
24
7.2k
オブジェクト指向宗教史
tanakahisateru
14
12k
Code Smells @Voxxed Bucharest 24
victorrentea
2
220
20240321_生成AI時代のDevOps
kzkmaeda
2
610
SREsのためのSRE定着ガイド
netmarkjp
10
1.7k
「XX試験の環境作ってよ」と言われた時によく使うAWSのソリューションについて
bun913
0
120
LLMプロダクト事業の立ち上げにおける挑戦
layerx
PRO
7
1.5k
Featured
See All Featured
JazzCon 2018 Closing Keynote - Leadership for the Reluctant Leader
reverentgeek
178
11k
Designing the Hi-DPI Web
ddemaree
275
33k
Become a Pro
speakerdeck
PRO
8
4.4k
How GitHub (no longer) Works
holman
301
140k
Teambox: Starting and Learning
jrom
126
8.4k
For a Future-Friendly Web
brad_frost
170
8.9k
Imperfection Machines: The Place of Print at Facebook
scottboms
257
12k
Creatively Recalculating Your Daily Design Routine
revolveconf
209
11k
Facilitating Awesome Meetings
lara
39
5.5k
Distributed Sagas: A Protocol for Coordinating Microservices
caitiem20
319
20k
Helping Users Find Their Own Way: Creating Modern Search Experiences
danielanewman
19
1.9k
Design by the Numbers
sachag
274
18k
Transcript
@ANDREWXHILL INTRODUCTION TO CARTODB
BACKGROUND
None
None
None
None
None
None
MAYBE AN OPEN SOURCE TOOL THAT MAKES MAPS EASY AND
BEAUTIFUL WOULD BE USEFUL… COMMON NEED?
2.5 YEARS AGO
None
None
WITHOUT THE TOP IN SIGHT THE RELEVANCE OF MAPS IS
AT AN ALL TIME HIGH
None
FAST FORWARD 5 YEARS
None
None
None
None
None
None
AN IMPORTANT GOAL FOR ANY MAP MAKER LET’S THINK ABOUT
STORYTELLING
None
you most ! people
None
http://bit.ly/1cZSry2
NO BIAS HERE :) MAPS ARE A POWERFUL STORYTELLING TOOL
MAP LITERACY
MAP LITERACY
None
None
A LOT WRITTEN ON OBJECTIVES
None
CONSIDERING ALL THAT FOUR TYPES OF MAPS TO USE TO
TELL A STORY
THE DATA OR THE DESIGN IS THE WHOLE STORY TYPE
1: DATA SHOWCASE
http://aitor.is/iceland-contour/
None
None
None
None
HIGHLIGHT SOMETHING ABOUT THE VIEWERS WORLD TYPE 2: YOUR WORLD
None
None
HOW ABOUT MORE EXCITING ONES?
OPENSTREETMAP
None
None
None
None
http://nychenge.com/
http://nychenge.com/
http://bit.ly/1dT2wSj FULL STORY
http://bit.ly/1aDGM5g
TO THEMATIC MAPS AND BEYOND TYPE 3: TRENDS & CHANGE
None
None
http://bit.ly/16SQXk5
None
None
http://bit.ly/18G7YWH
None
blog.cartodb.com
TAKE THE VIEWER THROUGH A STORY BY THE HAND TYPE
4: NARRATIVE MAPS
http://bit.ly/12edGe2
bit.ly/19fjB6R
http://bit.ly/1kgcw5K
None
BETTER MAPS & BETTER DATA VISUALIZATION WILL MAKE FOR BETTER
STORYTELLING
http://bit.ly/1cZSry2
SOME GOOD WAYS TO MAKE MAPS GETTING FROM HERE TO
THERE?
None
None
None
cartodb.com/ academy 4500+ Students | 1.5 Hour Lessons | Free
OVERVIEW
LIBRARIES
http://bit.ly/16SQXk5
http://bit.ly/16SQXk5
http://bit.ly/16SQXk5
BASEMAPS
None
None
None
None
DATA
None
INTERACTION
None
None
INTEGRATION
None
None
None
THIS ALL TAKES TIME
None
THAT’S WHY WE’RE GOING TO USE CARTODB
None
FIRST MAP IN ABOUT 5 MINUTES
CARTODB WHAT’S IN THE BOX
None
None
None
None
Tile API
SQL API
simple
None
Data in
GO!
PART ONE CARTODB BASICS
http://cartodb.com/ academy
None
None
None
PART TWO BASIC SQL http://bit.ly/1cuqyji
a. SELECT BASIC SQL
b. LIMIT,ORDER,ETC BASIC SQL
c. FILTER BASIC SQL
d. MATH BASIC SQL http://www.postgresql.org/docs/8.0/static/functions-math.html
PART THREE GEOMETRY http://bit.ly/1cuqyji
POINTS
POLYGONS
LINESTRINGS
PROJECTIONS https://github.com/mbostock/d3/wiki/Geo-Projections
None
CARTODB CONVENTIONS
POINTS MULTILINESTRINGS MULTIPOLYGONS
the_geom PROJECTION WGS 84 SRID 4326
the_geom_webmercator PROJECTION WEB MERCATOR SRID 3857
the_geom ALL EDITS SHOULD HAPPEN ON: the_geom_webmercator ALL MAPS COME
FROM
ST_GeometryType
ST_SRID
ST_AsText
ST_XMax
CDB_LatLng
GEOMETRY CALCULATIONS
ST_Area
ST_Length
ST_NumGeometries
ST_Distance
::geography
PART FOUR MORE SQL http://bit.ly/1cuqyji
KANSAS CITY ST_DWithin
Bedford city ST_Intersects()
UPDATE ST_Intersects()
PART FIVE OTHER SQL
ST_Buffer
ST_MakeLine
ST_Centroid
ST_Simplify
ST_Union
PART SIX WHATEVER YOU WANT