1. 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 547 Plays / / 0 Comments Watch in Couch Mode
  2. 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 1,183 Plays / / 0 Comments Watch in Couch Mode
  3. 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 388 Plays / / 0 Comments Watch in Couch Mode
  4. In this quick tutorial we will show you how to use embed a CartoDB map in your Tumblr blog.

    # vimeo.com/83344456 Uploaded 246 Plays / / 0 Comments Watch in Couch Mode
  5. A quick tutorial on adding basemaps to your account. In this video we will show you how to add MapBox, XYZ, and WMS basemaps to your CartoDB account. Once those basemaps are added to your account, you can use them in any visualization you create!

    Remember, when adding basemaps to add credit and attribution when necessary! Also, keep in mind that mapviews to your MapBox baselayers will be counted in your MapBox account and could lead to charges.

    # vimeo.com/79772252 Uploaded 1,326 Plays / / 0 Comments Watch in Couch Mode

Follow

CartoDB

vizzuality

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