Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Yale 2013 Workshop

Avatar for Andrew W Hill Andrew W Hill
December 10, 2013
Technology
95
1

Yale 2013 Workshop

Free workshop given in New Haven in December 2013

Avatar for Andrew W Hill

Andrew W Hill

December 10, 2013

More Decks by Andrew W Hill

See All by Andrew W Hill
Space Race 2 - Slingshot
Avatar for Andrew W Hill andrewxhill
0
100
Intro to Filecoin - Building apps with Powergate
Avatar for Andrew W Hill andrewxhill
0
440
Into the Powergate
Avatar for Andrew W Hill andrewxhill
0
320
Future of Pinning - storing Threads and Buckets at Textile
Avatar for Andrew W Hill andrewxhill
2
370
Maps of Today/Tomorrow
Avatar for Andrew W Hill andrewxhill
0
180
PopMaps - EcoViz Presentation
Avatar for Andrew W Hill andrewxhill
0
200
What is a Map
Avatar for Andrew W Hill andrewxhill
1
240
SCGIS Webinar
Avatar for Andrew W Hill andrewxhill
0
400
Harvard Workshop - 01-2015
Avatar for Andrew W Hill andrewxhill
0
160

Other Decks in Technology

See All in Technology
AI駆動開発は個人技からチーム戦へ：組織でAIを使いこなすための実践設計
Avatar for Atsushi Nakatsugawa moongift
PRO
0
430
【５分でわかる】セーフィー エンジニア向け会社紹介
Avatar for Safie safie_recruit
0
53k
名古屋の市バスGTFS-JPデータ×スガキヤ 最寄りバス停検索をAmazon ElastiCache Serverless for Valkeyで最適化する
Avatar for usanchuu usanchuu
1
220
AIは実装を速くする。では、私たちは何を今作るべきか？－立場を越えてリリースに向き合ったチーム開発の実践 / 20260801 Hiromi Nakaya and Naoki Takahashi
Avatar for SHIFT EVOLVE shift_evolve
PRO
3
360
AIがコードを書く時代、人間は何を保証するのか———馬場さんと考える、開発者に求められる新しい責任と価値 - TECH PLAY
Avatar for Toshiaki Baba netmarkjp
0
1.3k
Atlassian Cloudサポート業務でのAIエージェント活用事例
Avatar for Makky12 smt7174
0
370
ウォーターフォール開発案件のPMとしてAI活用を模索している話
Avatar for da-hatakeyama hatahata021
3
300
【CEDEC2026】『Relink』を拡張せよ - 『GRANBLUE FANTASY: Relink - Endless Ragnarok』の開発速度と品質を守るCI運用
Avatar for Cygames, Inc. cygames
PRO
0
110
サイバー捜査員研修（前半）
Avatar for Nomizo Nomizo nomizone
1
1.5k
【CEDEC2026】コードレビュー支援ツール開発から学ぶ：LLMを用いた業務システムの実践的な運用設計と誤出力対策
Avatar for Cygames, Inc. cygames
PRO
0
510
AIエージェントを前提としたプラットフォーム エンジニアリング：GKEで作るAgent-Ready Golden Path
Avatar for LegalOn Technologies, Inc legalontechnologies
PRO
1
150
NetBoxを利用した作業効率化の試み_NetDevNight4
Avatar for Takumi Nohara tnoha
0
460

Featured

See All Featured
Neural Spatial Audio Processing for Sound Field Analysis and Control
Avatar for NII S. Koyama's Lab skoyamalab
0
390
Product Roadmaps are Hard
Avatar for C. Todd Lombardo iamctodd
55
12k
Self-Hosted WebAssembly Runtime for Runtime-Neutral Checkpoint/Restore in Edge–Cloud Continuum
Avatar for Yuki Nakata chikuwait chikuwait
0
680
For a Future-Friendly Web
Avatar for Brad Frost brad_frost
183
10k
SEO in 2025: How to Prepare for the Future of Search
Avatar for Michael King ipullrank
3
3.7k
Building AI with AI
Avatar for Ines Montani inesmontani
PRO
1
1.1k
Information Architects: The Missing Link in Design Systems
Avatar for Michelle Chin soysaucechin
0
1k
ピンチをチャンスに：未来をつくるプロダクトロードマップ #pmconf2020
Avatar for Aki / @LoveIdahoBurger aki_iinuma
128
56k
How Software Deployment tools have changed in the past 20 years
Avatar for Geshan Manandhar geshan
1
34k
Faster Mobile Websites
Avatar for Dean Hume deanohume
310
32k
Context Engineering - Making Every Token Count
Avatar for Addy Osmani addyosmani
9
1k
Speed Design
Avatar for Sergey Chernyshev sergeychernyshev
33
2k

Transcript

  1. @ANDREWXHILL INTRODUCTION TO CARTODB

  2. BACKGROUND

  3. None
  4. None
  5. None
  6. None
  7. None
  8. None

  9. MAYBE AN OPEN SOURCE TOOL THAT MAKES MAPS EASY AND

    BEAUTIFUL WOULD BE USEFUL… COMMON NEED?

  10. 2.5 YEARS AGO

  11. None
  12. None

  13. WITHOUT THE TOP IN SIGHT THE RELEVANCE OF MAPS IS

    AT AN ALL TIME HIGH
  14. None

  15. FAST FORWARD 5 YEARS

  16. None
  17. None
  18. None
  19. None
  20. None
  21. None

  22. AN IMPORTANT GOAL FOR ANY MAP MAKER LET’S THINK ABOUT

    STORYTELLING
  23. None

  24. you most ! people

  25. None

  26. http://bit.ly/1cZSry2

  27. NO BIAS HERE :) MAPS ARE A POWERFUL STORYTELLING TOOL

  28. MAP LITERACY

  29. MAP LITERACY

  30. None
  31. None

  32. A LOT WRITTEN ON OBJECTIVES

  33. None

  34. CONSIDERING ALL THAT FOUR TYPES OF MAPS TO USE TO

    TELL A STORY

  35. THE DATA OR THE DESIGN IS THE WHOLE STORY TYPE

    1: DATA SHOWCASE

  36. http://aitor.is/iceland-contour/

  37. None
  38. None
  39. None
  40. None

  41. HIGHLIGHT SOMETHING ABOUT THE VIEWERS WORLD TYPE 2: YOUR WORLD

  42. None
  43. None

  44. HOW ABOUT MORE EXCITING ONES?

  45. OPENSTREETMAP

  46. None
  47. None
  48. None
  49. None

  50. http://nychenge.com/

  51. http://nychenge.com/

  52. http://bit.ly/1dT2wSj FULL STORY

  53. http://bit.ly/1aDGM5g

  54. TO THEMATIC MAPS AND BEYOND TYPE 3: TRENDS & CHANGE

  55. None
  56. None

  57. http://bit.ly/16SQXk5

  58. None
  59. None

  60. http://bit.ly/18G7YWH

  61. None

  62. blog.cartodb.com

  63. TAKE THE VIEWER THROUGH A STORY BY THE HAND TYPE

    4: NARRATIVE MAPS

  64. http://bit.ly/12edGe2

  65. bit.ly/19fjB6R

  66. http://bit.ly/1kgcw5K

  67. None

  68. BETTER MAPS & BETTER DATA VISUALIZATION WILL MAKE FOR BETTER

    STORYTELLING

  69. http://bit.ly/1cZSry2

  70. SOME GOOD WAYS TO MAKE MAPS GETTING FROM HERE TO

    THERE?
  71. None
  72. None
  73. None

  74. cartodb.com/ academy 4500+ Students | 1.5 Hour Lessons | Free

  75. OVERVIEW

  76. LIBRARIES

  77. http://bit.ly/16SQXk5

  78. http://bit.ly/16SQXk5

  79. http://bit.ly/16SQXk5

  80. BASEMAPS

  81. None
  82. None
  83. None
  84. None

  85. DATA

  86. None

  87. INTERACTION

  88. None
  89. None

  90. INTEGRATION

  91. None
  92. None
  93. None

  94. THIS ALL TAKES TIME

  95. None

  96. THAT’S WHY WE’RE GOING TO USE CARTODB

  97. None

  98. FIRST MAP IN ABOUT 5 MINUTES

  99. CARTODB WHAT’S IN THE BOX

  100. None
  101. None
  102. None
  103. None

  104. Tile API

  105. SQL API

  106. simple

  107. None

  108. Data in

  109. GO!

  110. PART ONE CARTODB BASICS

  111. http://cartodb.com/ academy

  112. None
  113. None
  114. None

  115. PART TWO BASIC SQL http://bit.ly/1cuqyji

  116. a. SELECT BASIC SQL

  117. b. LIMIT,ORDER,ETC BASIC SQL

  118. c. FILTER BASIC SQL

  119. d. MATH BASIC SQL http://www.postgresql.org/docs/8.0/static/functions-math.html

  120. PART THREE GEOMETRY http://bit.ly/1cuqyji

  121. POINTS

  122. POLYGONS

  123. LINESTRINGS

  124. PROJECTIONS https://github.com/mbostock/d3/wiki/Geo-Projections

  125. None

  126. CARTODB CONVENTIONS

  127. POINTS MULTILINESTRINGS MULTIPOLYGONS

  128. the_geom PROJECTION WGS 84 SRID 4326

  129. the_geom_webmercator PROJECTION WEB MERCATOR SRID 3857

  130. the_geom ALL EDITS SHOULD HAPPEN ON: the_geom_webmercator ALL MAPS COME

    FROM

  131. ST_GeometryType

  132. ST_SRID

  133. ST_AsText

  134. ST_XMax

  135. CDB_LatLng

  136. GEOMETRY CALCULATIONS

  137. ST_Area

  138. ST_Length

  139. ST_NumGeometries

  140. ST_Distance

  141. ::geography

  142. PART FOUR MORE SQL http://bit.ly/1cuqyji

  143. KANSAS CITY ST_DWithin

  144. Bedford city ST_Intersects()

  145. UPDATE ST_Intersects()

  146. PART FIVE OTHER SQL

  147. ST_Buffer

  148. ST_MakeLine

  149. ST_Centroid

  150. ST_Simplify

  151. ST_Union

  152. PART SIX WHATEVER YOU WANT