LocationTech / AvidGeo Conference

brief introduction before the hands-on workshop

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