CompostNYC

A Proximity-Based 3D Visualization to Help New Yorkers Find Compost Bins 🗽🌱

Introduction

Welcome to an exciting new way to explore composting in New York City! CompostNYC helps NYers visualizare far their location is from the nearest composting location.

Method

Step 1: Source Data

Composite site location data and NYC building data from:

Step 2: Spatial Analyses

SQL to measure the nearest compost bin from a given location.


        SELECT
            b.* -- Select all columns from building_locations
        FROM
            carto-demo-data.demo_tables.manhattan_pluto_data b,
            carto-dw-ac-zp3r15zi.shared.CompostNYC c
        WHERE
            ST_DWithin(b.geom, c.geom, 400);
        

Step 3: Add a CARTO Layer and 3D Map

Use CARTO API and Google Tiles API to render photorealistic tiles on deck.gl for a 3D map visualization.

Step 4: Style

Color-coded the buildings according to their proximity to compost bins.

👉 Check it out: Live link here