View gist:9352791
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Who we are: | |
We are building the easiest and most powerful data mapping engine ever. We have more than 40.000 | |
loving users (growing rapidly) and customers from all around the world. We have received awesome | |
reviews from all the key tech and startup media like Mashable today. And we have offices in | |
downtown Madrid and New York. | |
Our team of engineers and designers are changing the way maps are made. This is a big task, we | |
need to scale! Because of that we need to complement our strong technical arm with your | |
organizational expertise and results driven attitude. |
View gist:9368356
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CartoDB 2 Sales/Account manager position | |
Who we are: | |
We are building the easiest and most powerful data mapping engine ever. | |
We have more than 40.000 loving users (growing rapidly) and customers | |
from all around the world. We have received awesome reviews from all the | |
key tech and startup media like Mashable today. And we have offices in | |
downtown Madrid and New York. | |
Our team of engineers and designers are changing the way maps are made. |
View gist:11371647
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT *, | |
'http://maps.googleapis.com/maps/api/streetview?size=300x190&location='|| | |
ST_Y((the_geom))||','||ST_X((the_geom)) | |
||'&sensor=false&fov=110' as image | |
FROM table_2012_entire_tree_down_complaints_sandy |
View gist:f2d5801a7365dc4ab364
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
https://stagingfonmaps.cartodb.com/api/v2/sql?q=SELECT%20external_id,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lon,%20network_id,%20category_NAME,%20status,%20hotspots,%20metadata%20FROM%20pois%20WHERE%20the_geom%20%26%26%20ST_MakeEnvelope(0,%200,%20180,%2090,%204326) |
View gist:ff39d8e195fb286992ef
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
http://osmbuildings.cartodb.com/api/v2/sql?format=geojson&dp=6&q=SELECT%20cartodb_id%2CST_Intersection(CASE%20WHEN%20ST_Dimension(ST_Snap(ST_CollectionExtract(ST_SnapToGrid(ST_CollectionExtract(ST_Simplify(%22the_geom%22%2C%200.03055572509765625)%2C%20ST_Dimension(%22the_geom%22)%20%2B%201)%2C%200.0611114501953125)%2C%20ST_Dimension(%22the_geom%22)%20%2B%201)%2C%20ST_SnapToGrid(ST_Expand(ST_MakeEnvelope(-35.947265625%2C19.89072302399691%2C-20.302734375%2C33.797408767572485%2C%204326)%2C%207.3333740234375)%2C0.0611114501953125)%2C%200.0611114501953125))%20%3D%200%20OR%20GeometryType(ST_Snap(ST_CollectionExtract(ST_SnapToGrid(ST_CollectionExtract(ST_Simplify(%22the_geom%22%2C%200.03055572509765625)%2C%20ST_Dimension(%22the_geom%22)%20%2B%201)%2C%200.0611114501953125)%2C%20ST_Dimension(%22the_geom%22)%20%2B%201)%2C%20ST_SnapToGrid(ST_Expand(ST_MakeEnvelope(-35.947265625%2C19.89072302399691%2C-20.302734375%2C33.797408767572485%2C%204326)%2C%207.3333740234375)%2C0.0611114501953125)%2C%200.0611114501953125))%20%3D% |
View index.html
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!DOCTYPE html> | |
<html lang="en"> | |
<head> | |
<meta charset="utf-8"> | |
<!--Edit the title of the page--> | |
<title>CartoDB Point Clustering</title> | |
<meta name="description" content=""> | |
<meta name="author" content=""> | |
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1"> | |
<link rel="stylesheet" href="http://libs.cartocdn.com/cartodb.js/v3/themes/css/cartodb.css" /> |
View gist:1377437b4b80e0ab11f8
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<iframe width='100%' height='520' frameborder='0' src='http://osm2.cartodb.com/viz/9f8764fa-8eaf-11e4-ae69-0e9d821ea90d/embed_map' allowfullscreen webkitallowfullscreen mozallowfullscreen oallowfullscreen msallowfullscreen></iframe> |
View url.txt
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT *, 'http://maps.googleapis.com/maps/api/streetview?size=300x190&location='||urlencode (address)||'&sensor=false&fov=110' as image_with_address | |
FROM example_addresses |
View gist:ffc8dbae34d91f589ee6
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/** torque visualization */ | |
Map { | |
-torque-frame-count:107; | |
-torque-animation-duration:7; | |
-torque-time-attribute:"time"; | |
-torque-aggregation-function:"avg(value)"; | |
-torque-resolution:2; | |
-torque-data-aggregation:linear; | |
} |
View v_get_tile.plsql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE OR REPLACE FUNCTION v_get_tile(x integer,y integer,z integer) | |
RETURNS geometry AS | |
$BODY$ | |
DECLARE | |
origin_shift CONSTANT FLOAT := 20037508.342789244; | |
initial_resolution CONSTANT FLOAT := 156543.03392804062; | |
res float; | |
minx float; | |
miny float; | |
maxx float; |
OlderNewer