1. A brief introduction to adding and customizing infowindows on your CartoDB maps. This tutorial will teach you how to add beautiful infowindows to your maps in two minutes with zero coding.

    # vimeo.com/83811741 Uploaded 584 Plays / / 0 Comments Watch in Couch Mode

  2. A brief tutorial that will show you how to add, arrange, and edit multiple layers on your maps at the same time.

    # vimeo.com/83811740 Uploaded 632 Plays / / 0 Comments Watch in Couch Mode

  3. Use basic spatial SQL to count the number of points that are inside polygons. The tutorial uses two tables, one containing polygons and the second containing points.

    SQL Statement

    UPDATE polygon_table SET point_count = (SELECT count(*) FROM points_table WHERE ST_Intersects(points_table.the_geom, polygon_table.the_geom))

    PostGIS ST_Intersects Documentation

    postgis.refractions.net/docs/ST_Buffer.html

    # vimeo.com/83694844 Uploaded 325 Plays / / 0 Comments Watch in Couch Mode

  4. In this tutorial you can see how to quickly add and edit geometries in CartoDB. You can add points or draw new linestrings and polygons directly from map view.

    # vimeo.com/83693441 Uploaded 343 Plays / / 0 Comments Watch in Couch Mode

  5. Use a small bit of SQL to turn points into circles of specific center and radius.

    First SQL used

    UPDATE table_name SET the_geom = ST_Buffer(the_geom::geography, 100000)::geometry

    Second SQL used

    UPDATE table_name SET the_geom = ST_Buffer(the_geom::geography, 100000)::geometry WHERE name = 'Frankfurt'

    PostgreSQL UPDATE documentation

    postgresql.org/docs/9.1/static/sql-update.html

    PostGIS ST_Buffer documentation

    postgis.refractions.net/docs/ST_Buffer.html

    # vimeo.com/83693317 Uploaded 185 Plays / / 0 Comments Watch in Couch Mode

Follow

CartoDB

vizzuality Plus

This channel is all about how to use CartoDB and example applications making use of it.

Browse This Channel

Shout Box

Channels are a simple, beautiful way to showcase and watch videos. Browse more Channels. Channels