On the fly size sort of polygons in CartoDB
✓ Published0🌍 Public
Aandrewxhill
Last edited Jan 16, 2014
Created on May 15, 2013
A CartoDB map displays building polygons from OpenStreetMap, sorted and repositioned by size. The polygons are ordered by height and laid out in rows using a recursive SQL query that translates each geometry into a packed grid. The visualization uses CartoDB.js with Leaflet to render the map and tiles, while the query employs `ST_Area`, `ST_Translate`, and `ST_Transform` to compute offsets and project the geometries. Red polygons with white outlines appear over a Mapbox basemap.
AI-generated description