CartoDB: How Working With Geospatial Data Can Be A Joy and Not A Pain

CartoDB is a new Open Source Geospatial Database in the cloud. It leverages the full power of PostGIS and Mapnik to effortlessly stand up the services needed to create maps and develop location aware applications. It has been built with a love for design and interaction so that playing with geospatial data is a joy and not a pain.

The software has been developed by Vizzuality, a data visualization company focus on geospatial analysis and visualization. CartoDB is offered as a free service, on dedicated cloud instances or as an elastic service enabling users to process large amounts of data and only pay for what they use.

Importing geospatial data is as simple as dragging files into it, editing the data is just the way it is supposed to be, the maps are fast and responsive, it just works! Plus set the tables to real time and you will be able to have real time visualizations on your data changes.

Participants on this workshop will learn how to do beautiful and speedy maps using CartoDB. We’ll start with a file of 600,000 “stop and frisks” carried out by the NYPD, and make sense of the data using CartoDB’s analysis and mapping tools, including thematic mapping by block.

Transcript

1. )PX
   XPSLJOH
   XJUI
   HFPTQBUJBM
   EBUB
   DBO
   CF
   B
   +PZ
   BOE
   OPU
   B
   QBJO +BWJFS
   EF
   MB
   5PSSF
   
   !KBUPSSF
5. http://eol.org/pages/922241/maps House Sparrow
14. May 1911
17. 8F
    MPWF
    NBQT
18. 8F
    MPWF
    EZOBNJD
    NBQT
19. #VU
20. $VSSFOU
    UPPMT
    UP
    DSFBUF
    POMJOF
    NBQT
    BSF
    UFSSJCMF *NQPSUJOH
    
    USBOTGPSNJOH
    EBUB
    JT
    IBSE "OBMZ[JOH
    EBUB
    MPUT
    PG
    EBUB
    JT
    EJGGJDVMU 
    QPJOUT
    PO
    B
    NBQ
    FBTZ
    .
    QPJOUT
    EJGGJDVMU $PNNFSDJBM
    5PPMT
    BSF
    OPU
    GMFYJCMF
    FOPVHI
21. 0QFO
    4PVSDF
22. *U
    JT
    IBSE
    UP
    DPOGJHVSF *U
    JT
    IBSE
    UP
    VTF *U
    JT
    VHMZ 5IF
    NPTU
    GMFYJCMF
23. 1PTU(*4 'BTUFTU
    HFPTQBUJBM
    EBUBCBTF 3PDL
    TPMJE "MM
    GVODUJPOBMJUJFT
    ZPV
    DBO
    UIJOL
    PG #BTFE
    PO
    1PTUHSF42-
25.  "GUFS
    
    NPOUIT
    JO
    CFUB
27. Demo 1 Amalyze & Visualize
35. Demo 2 Building applications
40. Demo 3 Using the SQL API
41. 4DFOF/FBS.F
44. 8IJSMZ(MPCF
    
    $BSUP%# 
    $BSUP% http://mousebirdconsulting.com/whirlyglobe Steve Gifford
46. 8IBU
    JT
    OFX
    JO
    
47. 1PTU(*4
     3BTUFS 5PQPMPHZ /FBSFTU
    OFJHICPST
     (FP+40/ 1PTUHSF42-
     45@.BLF7BMJE
    45@4OBQ UZQNPE +VTU
    SFMFBTFE
48. 
    SFOEFSJOH
    TQFFE
    CPPTU
49. level0 (full extent on 24x30 pixel) avg: 10070.ms <— SimpTP 46390 v 8094/8094 g avg: 3190.5ms <— vanilla 4845240 v 8094/8094 g avg: 645.24ms <— Snap 4164 v 697/8094 g avg: 640.53ms <— Simp 27279 v 8094/8094 g level1 (full extent on 295x400 pixels) avg: 10185.ms <— SimpTP 47498 v 8094/8094 g avg: 3233.2ms <— vanilla 4845240 v 8094/8094 g avg: 741.77ms <— Snap 106232 v 7889/8094 g [crowded] avg: 707.78ms <— Simp 34438 v 8094/8094 g *** level2 (1/3 of extent on 600x400 pixels) avg: 3335.9ms <— SimpTP,Snap 14004 v 2183/2183 g avg: 945.04ms <— vanilla 1462892 v 2183/2183 g avg: 476.34ms <— Snap,SimpTP 18282 v 2179/2183 g *** avg: 230.86ms <— Snap 60761 v 2179/2183 g [crowded] avg: 216.49ms <— Simp 13299 v 2183/2183 g *** level4 (1/10 of extent on 600x400 pixels) avg: 853.96ms <— SimpTP 10476 v 547/547 g avg: 218.95ms <— vanilla 327660 v 547/547 g avg: 195.80ms <— Snap,SimpTP 14094 v 547/547 g avg: 74.150ms <— Simp 10287 v 547/547 g *** avg: 70.242ms <— Snap 67041 v 547/547 g [spiky] level4 (1/10 of extent on 600x400 pixels - PRESIMPLIFIED!) avg: 54.777ms <— Simp 13459 v 545/545 g avg: 53.419ms <— Snap 13459 v 545/545 g avg: 52.430ms <— vanilla 13459 v 545/545 g avg: 49.978ms <— SimpNCD 13459 v 545/545 g "MNPTU
    BT
    SFTPMVUJPOBSZ
    BT
    UIF
    *QBE http://blog.cartodb.com/
50. 0QFO4USFF.BQ
    JNQPSUT
51. 0QFO4USFF.BQ
    JT
    NVDI
    CFUUFS
    UIBO
    KVTU
    CVSOJOH
    UJMFT
56. 3BTUFS
    TVQQPSU
59. (FP1SPDFTTJOH
    PO
    +BWBTDSJQU
60. Demo 4 Querying Rasters
62. Demo 5 HTML5 lab
64. 5IBOLT +BWJFS
    EF
    MB
    5PSSF
    
    !KBUPSSF DBSUPECDPN
65. $PNQBSF
    JU
    UP
    'VTJPO
    5BCMFT 
    .#
    TJ[F
    MJNJU 
    WFSUJDFT
    QFS
    UJMF
    MJNJU 0OMZ
    UIF
    GJSTU
    ,
    TIBQFT
    XJMM
    CF
    SFOEFSFE 0OMZ
    UIF
    GJSTU
     
    SPXT
    PG
    EBUB
    JO
    B
    UBCMF
    BSF
    NBQQFE
    PS
    JODMVEFE
    JO
    RVFSZ
    SFTVMUT
    
    "GUFS
    UIF
    GJSTU
    ,
    UIFTF
    SPXT
    BSF
    OPU
    EJTQMBZFE .BY
    OVNCFS
    PG
    WFSUJDFT
    TVQQPSUFE
    QFS
    UBCMF
    JT
    
    NJMMJPO "
    DFMM
    PG
    EBUB
    JO
    'VTJPO
    5BCMFT
    TVQQPSUT
    B
    NBYJNVN
    PG
    
    NJMMJPO
    DIBSBDUFST 8IFO
    [PPNFE
    GBSUIFS
    PVU
    UBCMFT
    XJUI
    NPSF
    UIBO
    
    GFBUVSFT
    XJMM
    TIPX
    EPUT
    OPU
    MJOFT
    PS
    QPMZHPOT  42-
    BQJ
    BMMPXT
    GPS
    
    SFRVFTUTTFDPOE VQ
    UP
    GJWF
    'VTJPO
    5BCMFT
    MBZFST
    UP
    B
    NBQ
    POF
    PG
    XIJDI
    DBO
    CF
    TUZMFE
    XJUI
    VQ
    UP
    GJWF
    TUZMJOH
    SVMFT 4DBMF
    )PSJ[POUBMMZ
    WT
    7FSUJDBMMZ