Sandro Santilli strk

GIS Hacker

strk / index.html

Last active August 29, 2015 13:56 — 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" />

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 / 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 / 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 / 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 / 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