strk’s gists

strk / gist:2037594

Created March 14, 2012 16:17

	ERROR: Error running python shp_normalizer script: /usr/bin/python -Wignore /home/src/cartodb/cartodb/lib/importer/misc/shp_normalizer.py "/tmp/20120314-24180-kf8q8i.com2011.shp" importing_1331741285_com2011
	ERROR:
	ERROR: Error running python shp_normalizer script: /usr/bin/python -Wignore /home/src/cartodb/cartodb/lib/importer/misc/shp_normalizer.py "/tmp/20120314-24180-kf8q8i.com2011.shp" importing_1331741285_com2011
	ERROR: Table error, #<RuntimeError: Error running python shp_normalizer script: /usr/bin/python -Wignore /home/src/cartodb/cartodb/lib/importer/misc/shp_normalizer.py "/tmp/20120314-24180-kf8q8i.com2011.shp" importing_1331741285_com2011>
	', "updated_at" = '2012-03-14 17:08:04.571844+0100', "created_at" = '2012-03-13 17:48:10.934778+0100' WHERE ("id" = 1)

strk / query.sql

Created September 4, 2012 11:10 — forked from javisantana/query.sql

grid postgis query

	WITH

	hgrid AS (
	SELECT CDB_HexagonGrid(
	ST_Transform(ST_MakeEnvelope(-180, -89, 180, 89, 4326), 3857), -- extent of the grid
	CDB_XYZ_Resolution({z}) * 15 -- size of each cell
	) as cell
	)

	SELECT count(i.<%=prop%>) as points_count

strk / cartodb_test.md

Created October 29, 2012 12:06 — forked from anonymous/cartodb_test.md

cartodb_test.md

Carto Failures - 2012-10-29 12:29

production	staging
	![staging](http://luisico-prod15.cartodb.com/tiles/carto_tests/0/0/0.png?style=%23carto_tests+%7Bline-cap%3Around%3B+line-color%3A%23FF6600%3B+line-gamma%3A0.7%3B+line-join%3Around%3B+line-dasharray%3A33%2C23%3B+line-opacity%3A0.7%3B+line-width%3A5%3B+%7D&sql=SELECT+%27my+really+long+name+here

strk / kmeans.sql

Created December 3, 2012 08:26 — forked from andrewxhill/kmeans.sql

kmeans function and examples


	--DROP FUNCTION axh_kmeans_geom_sort(geometry[], integer, integer);


	CREATE OR REPLACE FUNCTION axh_kmeans_geom_sort(the_geom geometry[], clusters integer DEFAULT NULL, iterations integer DEFAULT NULL)
	RETURNS SETOF GEOMETRY
	AS $$
	DECLARE
	h GEOMETRY; -- rectangle cell
	c INTEGER; --

strk / kmeans.sql

Created December 4, 2012 08:31 — forked from andrewxhill/kmeans.sql

kmeans function and examples


	--DROP FUNCTION axh_kmeans_geom_sort(geometry[], integer, integer);


	CREATE OR REPLACE FUNCTION axh_kmeans_geom_sort(the_geom geometry[], clusters integer DEFAULT NULL, iterations integer DEFAULT NULL)
	RETURNS SETOF GEOMETRY
	AS $$
	DECLARE
	h GEOMETRY; -- rectangle cell
	c INTEGER; --

strk / gist:4995973

Created February 20, 2013 14:40

Attempt to profile http request times

	var start_time = Date.now();
	http.get(url, function(res) {
	res.body = '';
	if ( res.statusCode != 200 ) {
	res.on('data', function(chunk) {
	// Save only first chunk, to reduce cost of the operation
	if ( res.body.length == 0 ) res.body += chunk;
	});
	}
	res.on('end', function() {

strk / gist:6608224

Created September 18, 2013 12:05

https://strk.cartodb.com/tiles/layergroup/662381ebb78b01d284a9bf18bcb74324:0/{z}/{x}/{y}.png?cache_policy=persist

strk / index.html

Created January 29, 2014 17:16 — forked from javierarce/index.html

	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="utf-8">
	<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" />
	<!--[if lte IE 8]>

strk / gist:8693074

Last active August 29, 2015 13:55

	WITH clusters AS (
	SELECT
	ST_Collect(the_geom_webmercator) as g,
	count(*) as count
	FROM the_tornados WHERE the_geom_webmercator && !bbox!
	GROUP BY ST_SnapToGrid(the_geom_webmercator, greatest(!pixel_width!,!pixel_height!)*48)
	)
	SELECT row_number() over () as cartodb_id,
	count,
	least(100, greatest(count,10)) as size,

strk / gist:8704942

Last active August 29, 2015 13:55

	WITH trip AS (
	SELECT ST_MakeLine(the_geom_webmercator ORDER BY cartodb_id ASC) as g
	FROM jackerouak
	),
	params AS (
	SELECT
	greatest(st_xmax(g)-st_xmin(g), st_ymax(g)-st_ymin(g))/20 as maxlen_old,
	CDB_XYZ_Resolution(4)*10 as maxlen
	FROM trip
	),