Look Mom, No Data! (… or … “creating maps without data”)

One of the amazing capabilities of the brand new CartoDB’s Data Observatory  is that you can create and analyze information even without data.  For the following example we are going to create the “Median Age Map” for Las Vegas Strip.

Firstly, you need the boundaries for “Las Vegas Strip”. You can create a new table using a sql like this:

create table vegas_census_tracts as
SELECT *
FROM OBS_GetBoundariesByGeometry(
ST_MakeEnvelope(-115.145958,36.143978, -115.18087,36.07098, 4326),
‘us.census.tiger.census_tract’);

Then, you must cartodbfy your table:

select cdb_cartodbfytable(‘your_user’, ‘vegas_census_tracts’);

Add a new column to store the median age values:

alter table vegas_census_tracts add column median_age numeric;

And update the new column using data from “Data Observatory“:

UPDATE vegas_census_tracts
SET median_age =
OBS_GetMeasure( st_centroid(the_geom), ‘us.census.acs.B01002001’);

And voila!. Now you can create a new map using Cartodb’s Editor:

Make up? Easy with the new  “Color Test Bed“.

 

It is time for some basketmaps!

Quoting @gmapsmania :

Interactive mapping platforms can be a very simple but effective way to visualize sports data. They are particularly effective for creating shot-maps for ball based team sports, e.g. football, soccer, baseball and basketball.

So, let’s take a look to some basketmaps:

The Golden State Warriors Map shot map for the entire 2015-16 record breaking season

xnba_gsw_73-9.png.pagespeed.ic.DE8FMWsTtU.png

 

Every shot Kobe Bryant ever took. All 30,699 of them

proxy

 

2014-15 NBA Regular Season – Field Goal Shooting Patterns

nba_post

 

Visualizing NBA Finals tweets

d3nohar

 

Tracking NBA Player Movements

FireShot Capture 58 - Displaying NBA Data with Carto_ - http___blog.cartodb.com_displaying-NBA-data_

And last but not least:

20 Maps that explain the NBA

champions-map-0