pluto_reverse_geocode.sql

CREATE TYPE pluto_reverse_geocode_result AS (address text, ownername text,distance float);
CREATE OR REPLACE FUNCTION pluto_reverse_geocode(float,float,int) RETURNS SETOF pluto_reverse_geocode_result
  AS ' 
      WITH subq as (SELECT address,the_geom,ownername
      FROM nyc_mappluto_13v1
      ORDER BY the_geom <-> CDB_LatLng($1,$2) LIMIT 20)
      SELECT address,ownername,
      ST_Distance(the_geom::geography, CDB_LatLng($1,$2)::geography) as distance
      FROM subq 
      WHERE ST_Distance(the_geom::geography, CDB_LatLng($1,$2)::geography) < $3
      ORDER BY ST_Distance(the_geom::geography, CDB_LatLng($1,$2)::geography) ASC LIMIT 3
    '
LANGUAGE SQL
IMMUTABLE
RETURNS NULL ON NULL INPUT;