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.
Composite site location data and NYC building data from:
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);
Use CARTO API and Google Tiles API to render photorealistic tiles on deck.gl for a 3D map visualization.
Color-coded the buildings according to their proximity to compost bins.