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 2,015 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 2,206 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 979 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 4,846 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 946 Plays / / 0 Comments Watch in Couch Mode

CartoDB

cartodb

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