"name": "backendChoropleth",
"sql": "WITH colors AS (SELECT pickup_building as key0, avg(tip_amount/fare_amount) as color
FROM taxi_factual_closestbuilding WHERE (fare_amount > 0 AND tip_amount >= 0 AND tip_amount/fare_amount<1)
GROUP BY key0) SELECT nyc_buildings.heavyai_geo as heavyai_geo, colors.key0 as key0, colors.color as color
FROM colors, nyc_buildings WHERE (colors.key0 = nyc_buildings.bld_id) AND
(ST_XMax(nyc_buildings.heavyai_geo) >= -74.06993970987278 AND
ST_XMin(nyc_buildings.heavyai_geo) <= -73.87446838332451 AND
ST_YMax(nyc_buildings.heavyai_geo) >= 40.64111330399987 AND
ST_YMin(nyc_buildings.heavyai_geo) <= 40.87934187208219)"