CartoDB 1.0: Dynamic map visualizations and analysis made easy

Slide 1

Slide 1 text

$BSUP%#%ZOBNJDNBQ WJTVBMJ[BUJPOTBOEBOBMZTJTNBEFFBTZ +BWJFSEFMB5PSSF!KBUPSSF -BGBZFUUF /:

Slide 2

Slide 2 text

"GUFSNPOUITJOCFUB

Slide 3

Slide 3 text

No content

Slide 4

Slide 4 text

No content

Slide 5

Slide 5 text

No content

Slide 6

Slide 6 text

No content

Slide 7

Slide 7 text

No content

Slide 8

Slide 8 text

No content

Slide 9

Slide 9 text

4DFOF/FBS.F

Slide 10

Slide 10 text

No content

Slide 11

Slide 11 text

No content

Slide 12

Slide 12 text

No content

Slide 13

Slide 13 text

No content

Slide 14

Slide 14 text

No content

Slide 15

Slide 15 text

No content

Slide 16

Slide 16 text

No content

Slide 17

Slide 17 text

No content

Slide 18

Slide 18 text

No content

Slide 19

Slide 19 text

No content

Slide 20

Slide 20 text

Demo 1 Parks and Wifi

Slide 21

Slide 21 text

1PTU(*4

Slide 22

Slide 22 text

1PTU(*4JOTJEF

Slide 23

Slide 23 text

1PTU(*4 /PEFKT .BQOJL 42-"1* 8JOETIBGU

Slide 24

Slide 24 text

No content

Slide 25

Slide 25 text

SELECT * FROM nyc_wifi WHERE ST_Intersects( the_geom, ST_Buffer( ST_SetSRID('POINT(-73.9967 40.7248)'::geometry , 4326), 0.001)) 5 http://examples.cartodb.com/tiles/ nyc_wifi/15/9648/12318.png?sql= SELECT * FROM nyc_wifi WHERE ST_Intersects( the_geom, ST_Buffer( ST_SetSRID('POINT(-73.9967 40.7248)'::geometry , 4326), 0.001)) http://examples.cartodb.com/api/v1/sql?q= SELECT * FROM nyc_wifi WHERE ST_Intersects( the_geom, ST_Buffer( ST_SetSRID('POINT(-73.9967 40.7248)'::geometry , 4326), 0.001))

Slide 26

Slide 26 text

.BQT"1* http://viz2.cartodb.com/tiles/style_demo/5/15/12.png ?sql=select * from style_demo where name='p1' &style=#style_demo{[name='p1']{polygon-fill:#000}} http://viz2.cartodb.com/tiles/style_demo/5/15/12.png ?style=#style_demo{polygon-fill:#ff9999; [name='p1'] {polygon-fill:#000} } $BSUP $44MBOHVBHF

Slide 27

Slide 27 text

.BQT"1* https://viz2.cartodb.com/tiles/madrid_osm_point_copy/13/4011/3087.png?sql=WITH%20f50m_atm%20AS %20(SELECT%2050%20as%20distance,st_transform(ST_Union(st_buffer(ST_transform(the_geom,954009), 50)),3857)%20as%20the_geom_webmercator%20FROM%20madrid_osm_point_copy),f100m_atm%20as%20(SELECT %20100%20as%20distance,st_transform(ST_Union(st_buffer(ST_transform(the_geom,954009),100)), 3857)%20as%20the_geom_webmercator%20FROM%20madrid_osm_point_copy),f200m_atm%20as%20(SELECT %20200%20as%20distance,st_transform(ST_Union(st_buffer(ST_transform(the_geom,954009),200)), 3857)%20as%20the_geom_webmercator%20FROM%20madrid_osm_point_copy),f300m_atm%20as%20(SELECT %20300%20as%20distance,st_transform(ST_Union(st_buffer(ST_transform(the_geom,954009),300)), 3857)%20as%20the_geom_webmercator%20FROM%20madrid_osm_point_copy)%20select%20*%20from%20(SELECT %20*%20FROM%20f50m_atm%20UNION%20SELECT%20*%20FROM%20f100m_atm%20UNION%20SELECT%20*%20FROM %20f200m_atm%20UNION%20SELECT%20*%20FROM%20f300m_atm)%20as%20tmp%20ORDER%20BY%20distance %20DESC&style=%23madrid_osm_point_copy%7b%0d%0a+++%5bdistance %3d50%5d%7b%0d%0a+++polygon-fill%3a%2347AC00%7d%0d%0a%5bdistance %3d100%5d%7b%0d%0a+++polygon-fill%3a%23EFF000%7d%0d%0a%5bdistance %3d200%5d%7b%0d%0a+++polygon-fill%3a%23EB8900%7d%0d%0a%5bdistance %3d300%5d%7b%0d%0a+++polygon-fill%3a%23F00D00%7d%0d%0apolygon- opacity%3a1%3b%0d%0a+++line-opacity%3a1%3b%0d%0a+++line-color%3a %23FFFFFF%3b%0d%0a+++%7d

Slide 28

Slide 28 text

42-"1* http://viz2.cartodb.com/api/v1/sql?q= SELECT cartodb_id,ST_distance(ST_GeomFromText('POINT(-73. 989418 40.7393)', 4326)::geography,the_geom::geography) as distance_to_office,st_x(the_geom) as lon,st_y(the_geom) as lat FROM wifi ORDER BY distance_to_office ASC LIMIT 10

Slide 29

Slide 29 text

No content

Slide 30

Slide 30 text

Demo 2 PostGIS 2 functions

Slide 31

Slide 31 text

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 "MNPTUBTSFTPMVUJPOBSZBTUIF*QBE http://blog.cartodb.com/

Slide 32

Slide 32 text

SFOEFSJOHTQFFECPPTU

Slide 33

Slide 33 text

0QFO4USFF.BQJTNVDINPSF UIBOKVTUCVSOJOHUJMFT /FX$BSUP%#TVQQPSUT04.JNQPSUT

Slide 34

Slide 34 text

No content

Slide 35

Slide 35 text

No content

Slide 36

Slide 36 text

"OBMZ[JOHEBUBPOUIFDMPVE

Slide 37

Slide 37 text

No content

Slide 38

Slide 38 text

*IBWFTFFOUIFGVUVSF BOEJTOPUNBEFPGUJMFT

Slide 39

Slide 39 text

42-"1*

Slide 40

Slide 40 text

No content

Slide 41

Slide 41 text

7&$/*, http://github.com/Vizzuality/VECNIK

Slide 42

Slide 42 text

Demo 2 V ecnik examples

Slide 43

Slide 43 text

#JUNBQ

Slide 44

Slide 44 text

#JDNBQ

Slide 45

Slide 45 text

No content

Slide 46

Slide 46 text

No content

Slide 47

Slide 47 text

No content

Slide 48

Slide 48 text

1PTU(*43BTUFSPO$BSUP%#GPS BOBMZUJDBMXFCNBQQJOH +BWJFSEFMB5PSSF!KBUPSSF 8FEOFTEBZ".

Slide 49

Slide 49 text

No content

Slide 50

Slide 50 text

No content

Slide 51

Slide 51 text

'VTJPO5BCMFTMJNJUBUJPOT .#TJ[FMJNJU WFSUJDFTQFSUJMFMJNJU 0OMZUIFGJSTU,TIBQFTXJMMCFSFOEFSFE 0OMZUIFGJSTU SPXTPGEBUBJOBUBCMFBSFNBQQFEPSJODMVEFEJORVFSZSFTVMUT"GUFSUIFGJSTU, UIFTFSPXTBSF OPUEJTQMBZFE .BYOVNCFSPGWFSUJDFTTVQQPSUFEQFSUBCMFJTNJMMJPO "DFMMPGEBUBJO'VTJPO5BCMFTTVQQPSUTBNBYJNVNPGNJMMJPODIBSBDUFST 8IFO[PPNFEGBSUIFSPVU UBCMFTXJUINPSFUIBOGFBUVSFTXJMMTIPXEPUT OPUMJOFTPSQPMZHPOT 42-BQJBMMPXTGPSSFRVFTUTTFDPOE VQUPGJWF'VTJPO5BCMFTMBZFSTUPBNBQ POFPGXIJDIDBOCFTUZMFEXJUIVQUPGJWFTUZMJOHSVMFT 4DBMF)PSJ[POUBMMZWT7FSUJDBMMZ

Slide 52

Slide 52 text

5IBOLT +BWJFSEFMB5PSSF!KBUPSSF DBSUPECDPN

Slide 53

Slide 53 text

8IJSMZ(MPCF $BSUP%# $BSUP% http://mousebirdconsulting.com/whirlyglobe Steve Gifford