$30 off During Our Annual Pro Sale. View Details »

LocationTech / AvidGeo Conference

Andrew W Hill
December 09, 2014

LocationTech / AvidGeo Conference

brief introduction before the hands-on workshop

Andrew W Hill

December 09, 2014
Tweet

More Decks by Andrew W Hill

Other Decks in Technology

Transcript

  1. MAKING MAPS FOR THE WEB:
    INTRODUCTION TO
    CARTODB
    @ANDREWXHILL

    View Slide

  2. bit.ly/avid-cartodb

    View Slide

  3. View Slide

  4. View Slide

  5. bit.ly/1BtfiBw

    View Slide

  6. bit.ly/1w62DkO

    View Slide

  7. http://bit.ly/1EVwboO

    View Slide

  8. http://bit.ly/1ts3TPQ

    View Slide

  9. View Slide

  10. View Slide

  11. View Slide

  12. WITH  hgrid    
             AS  (SELECT  Cdb_rectanglegrid(Cdb_xyz_extent(8,  12,  5),    
                                   Cdb_xyz_resolution(5)  *  4,    
                                                         Cdb_xyz_resolution(5)  *  4)  AS  cell)    
    SELECT  x,    
                 y,    
                 Array_agg(c)  vals,    
                 Array_agg(d)  dates    
    FROM      (SELECT  St_xmax(hgrid.cell)                                                                                        x,    
                                 St_ymax(hgrid.cell)                                                                                        y,    
                                 Count(i.cartodb_id)                                                                                        c,    
                                 Floor((  Date_part('epoch',  built)  -­‐  -­‐10418716800  )  /  32837875)  d    
                   FROM      hgrid,    
                                 us_po_offices  i    
                   WHERE    St_intersects(i.the_geom_webmercator,  hgrid.cell)    
                   GROUP    BY  hgrid.cell,    
                                       Floor((  Date_part('epoch',  built)  -­‐  -­‐10418716800  )  /  32837875)    
                 )  f    
    GROUP    BY  x,    
                       y

    View Slide

  13. View Slide

  14. 1
    10
    100
    1000
    3mb 70mb 300mb
    1.5
    2
    1.2
    300
    70
    3
    Raw Datacube

    View Slide

  15. View Slide

  16. View Slide

  17. View Slide

  18. View Slide

  19. http://bit.ly/downeymap

    View Slide

  20. View Slide

  21. View Slide

  22. HOW DID THEY
    DO THAT?

    View Slide

  23. FREE, SIMPLE, WEB-
    BASED MAP EDITOR

    View Slide

  24. View Slide

  25. Live data, import API, and remote sync

    View Slide

  26. View Slide

  27. POWERFUL AND
    SECURE PLATFORM &
    APIS

    View Slide

  28. SQL API

    View Slide

  29. View Slide

  30. FLEXIBLE AND FULLY
    FEATURED JAVASCRIPT
    LIBRARY

    View Slide

  31. View Slide

  32. View Slide

  33. WHY IS IT DIFFERENT?

    View Slide

  34. Simple

    View Slide

  35. Fast

    View Slide

  36. Flexible

    View Slide

  37. View Slide

  38. Dynamic

    View Slide

  39. WANT TO GET
    MORE?

    View Slide

  40. http://blog.cartodb.com/

    View Slide

  41. http://academy.cartodb.com/

    View Slide

  42. View Slide

  43. View Slide

  44. http://bit.ly/11lc43V

    View Slide

  45. bit.ly/avid-cartodb

    View Slide