Dataset de todas las bibliotecas de EEUU
Dataset de citibike NYC
OpenPaths
Antennas
Colored by operator (Movistar/Vodafone/Orange/Yoigo = Blue/Red/Orange/Purple). Includes the band the antenna (DCS/GSM/UMTS).
| #citibike { | |
| [layer='links'] { | |
| line-color: #FFFFFF; | |
| line-width: 1.5; | |
| line-opacity: 0.4; | |
| } | |
| [layer='dock']{ | |
| marker-fill: #FFFFFF; | |
| marker-opacity:1; | |
| marker-width: 7; | |
| marker-line-color: #333; | |
| marker-line-width: 1.5; | |
| marker-line-opacity: 1; | |
| marker-placement: point; | |
| marker-type: ellipse; | |
| marker-allow-overlap: true; | |
| } | |
| [layer='library']{ | |
| marker-fill: #FF7373; | |
| marker-opacity: 1; | |
| marker-width: 9; | |
| marker-line-color: #333; | |
| marker-line-width: 1.5; | |
| marker-line-opacity: 0.9; | |
| marker-placement: point; | |
| marker-type: ellipse; | |
| marker-allow-overlap: true; | |
| } | |
| } |
| SELECT | |
| cartodb_id, the_geom_webmercator, 'library' AS layer | |
| FROM libraries --all libraries | |
| UNION ALL | |
| SELECT | |
| cartodb_id, the_geom_webmercator, 'dock' AS layer | |
| FROM | |
| citibike --all op checkins | |
| UNION ALL | |
| SELECT cartodb_id, ST_MakeLine(the_geom_webmercator, | |
| (SELECT the_geom_webmercator | |
| FROM libraries | |
| ORDER BY the_geom <-> op.the_geom LIMIT 1) | |
| ) the_geom_webmercator, 'links' AS layer | |
| FROM citibike op |