SQL: Stacking Chips

query.sql

WITH 
 data as (
   SELECT 
   	cartodb_id, 
   	ST_SnapToGrid(the_geom,.5) as the_geom
   FROM team
  ),
  m AS (
    SELECT array_agg(cartodb_id) id_list, the_geom, ST_Y(the_geom) y 
    FROM data 
    GROUP BY the_geom
    ORDER BY y DESC
  ),
  f AS (
    SELECT  generate_series(1, array_length(id_list,1)) p, unnest(id_list) cartodb_id, the_geom 
    FROM m
  )
SELECT  	
	ST_Transform(ST_Translate(
      f.the_geom,
      0,
      f.p*.22
    ),3857) the_geom_webmercator, 
    f.cartodb_id, 
	q.emp_id,
	q.workemail,
	q.displayname,
	q.gender,
	q.jobtitle,
	q.department,
	q.location,
	q.division,
	q.photourl
FROM f, team q
WHERE f.cartodb_id = q.cartodb_id