williamsburg-greenpoint-geojson.rb

  def self.wb_gp_geojson
    self.find_by_sql(
      "SELECT z.zonedist,ST_AsGeoJSON(z.the_geom) 
       FROM zones AS z JOIN districts AS d ON 
       ST_Contains(d.the_geom, z.the_geom) 
       OR ST_Overlaps(d.the_geom,z.the_geom) 
       WHERE d.cd = 301;"
      ).map {|r| 
        { :geojson => JSON.parse(r.st_asgeojson), :zonedist => r.zonedist }
    }.to_json
  end