This example visualizes building scores in Portland based on proximity to nearby amenities, assigning higher ranks to structures near supermarkets, rail stops, and parks. It shows a ranked map of buildings, with scores aggregated from overlapping amenity zones. The workflow uses PostGIS spatial SQL functions like `st_expand` and `st_intersects` to generate buffered zones, then sums scores per building via a `union` query and stores results in a new table. The rendering likely relies on a mapping library such as Leaflet or Mapbox, though the code excerpt focuses on the spatial data preparation rather than the front-end visualization.