November 2011 Summaries

The ST_GeomFromGeoJSON function in PostGIS allows web developers to easily work with GeoJSON data, making it a valuable addition for applications that need to handle geospatial data. The development of this functionality was made possible by OpenGeo and Vizzuality, and it is now available on the CartoDB platform. With this new feature, users can import and write GeoJSON data directly into PostGIS without relying on third-party libraries, making it easier to work with geospatial data in their applications.

DontFlush.me` is an application developed during `ecohackNYC` using CartoDB to help users visualize where their sewage is going, with the goal of reducing combined sewer overflows (CSOs) into New York City's Harbor. The app uses a simple SQL API call to retrieve data from CartoDB and displays the drainage areas and point locations of CSOs, providing users with an interactive tool to raise awareness about this environmental issue. By bringing a user-friendly interface and encouraging contest participation, `DontFlush.me` aims to educate users about the impact of CSOs on the harbor and promote sustainable practices during storms.