Skip to content

Instantly share code, notes, and snippets.

View jatorre's full-sized avatar

Javier de la Torre jatorre

93 followers · 7 following
View GitHub Profile
@jatorre
jatorre / gist:9352791
Last active August 29, 2015 13:57
Vizzuality is looking for an awesome Office Manager in Madrid
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.
@jatorre
jatorre / gist:9368356
Last active August 29, 2015 13:57
CartoDB 2 Sales/Account manager position
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.
@jatorre
jatorre / gist:11371647
Created April 28, 2014 13:13
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
@jatorre
jatorre / gist:f2d5801a7365dc4ab364
Created July 10, 2014 14:16
Exampel SQL
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)
@jatorre
jatorre / gist:ff39d8e195fb286992ef
Created August 4, 2014 22:18
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%
@jatorre
jatorre / index.html
Last active August 29, 2015 14:11 — forked from andrewxhill/index.html
<!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" />
@jatorre
jatorre / gist:1377437b4b80e0ab11f8
Created December 28, 2014 17:19
Embed this interactive visualization
<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>
@jatorre
jatorre / url.txt
Created February 1, 2015 16:48
SELECT *, 'http://maps.googleapis.com/maps/api/streetview?size=300x190&location='||urlencode (address)||'&sensor=false&fov=110' as image_with_address
FROM example_addresses
@jatorre
jatorre / gist:ffc8dbae34d91f589ee6
Created March 23, 2015 20:55
/** 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;
}
@jatorre
jatorre / v_get_tile.plsql
Created December 8, 2010 22:17
a plsql function to get a PostGIS geom out of a tile defined by X,Y,Z. Returns on SRS 900913
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;