Sandro Santilli strk

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

## 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]>

## kmeans.sql

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

## kmeans.sql

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

## cartodb_test.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                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

Test 1


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&amp;sql=SELECT+%27my+really+long+name+here


## query.sql
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
	<!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" />

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