In The last 2 weeks a lot of new applications have been developed at #ecohacknyc, #nycbigapps and #sciencehackday using CartoDB, pretty excited. This demonstrates the power of CartoDB specially for fast development of location aware applications and mapping. We are gonna be highlighting different applications that make use of CartoDB on the next days.
Today we want to talk about DontFlush.me, in their own words:
During #ecohackNYC a group of talented people got together to develop an application that can show you where is your sewage going. They used CartoDB to host all the data and then with a simple SQL API call like this:
http://ecohack-nyc-03.cartodb.com/api/v1/sql?q=
SELECT DISTINCT(sheds.drainage_n), ST_AsGeoJSON(pol.the_geom) as polygon, ST_AsGeoJSON(poin.the_geom) as point_geom
FROM drain_areas_wgs84webmerc_nodupou as pol inner join cso_nyc_wgs84webmerc_latlon as poin on poin.item_id=pol.primary_ou, drainage_nyc_sewage_plant_sheds as sheds
WHERE ST_Intersects(pol.the_geom,ST_GeomFromText(‘POINT(-73.96212000000003 40.675573)’,4326)) AND (sheds.wpcp=poin.wpcp OR sheds.alt_name=poin.wpcp)
They get the polygon of your CSO are and where it ends up on the river. On top of that is all about bringing a nice UI and give contest to the issue.
Great job from Matt, Eric, Jeni, Liz, Jeff, Chris, Sheiva, Anna, Karen, Wendy and Carl. Congratulations!
While travel and commuting pick up speed once again across the world, investment in out-of-home advertising (OOH) is growing in tandem. With OOH ad spend projected to grow ...
Use CasesThroughout the course of history, the use of the term “equity” has ebbed and flowed in frequency. Recently, equity has become quite a buzzword. Why? Advancing equity across...
Use CasesHow does the city that never sleeps keep moving so fast? Coffee, of course! In this article, we investigate the spatial patterns of coffee shops across New York City and sh...
Use CasesPlease fill out the below form and we'll be in touch real soon.