181 reputation
17
bio website
location
age
visits member for 2 years, 9 months
seen Dec 20 '12 at 2:24

Mar
12
awarded  Notable Question
Dec
12
awarded  Popular Question
Sep
9
comment What is the best way to do reverse geocoding with PostGIS?
Of course: CREATE OR REPLACE FUNCTION reverse_geocode(lat double precision, lon double precision) RETURNS text AS $BODY$ declare point geometry; rec record; geocode text; begin point := geomfromtext('POINT('||lat||' '||lon||')', 4326); select name, distance(way, point) as dist into rec from mapserverdb_point order by dist asc limit 1; geocode := rec.name; return geocode; end; $BODY$ LANGUAGE plpgsql;
Aug
24
awarded  Self-Learner
Aug
24
awarded  Teacher
Aug
24
awarded  Scholar
Aug
24
accepted What is the best way to do reverse geocoding with PostGIS?
Aug
24
answered What is the best way to do reverse geocoding with PostGIS?
Aug
24
comment What is the best way to do reverse geocoding with PostGIS?
Thanks. I didn't need US information for reverse geocode. Now I have understand the way reverse geocode works with PostGIS databases. Thanks a lot.
Aug
24
awarded  Supporter
Aug
12
comment What is the best way to do reverse geocoding with PostGIS?
I've already tried using Nominatim, but I had issues using "gazetteer" output. It throws a "Segmentation fault" each time I import the osm data.
Aug
12
awarded  Student
Aug
12
awarded  Editor
Aug
12
revised What is the best way to do reverse geocoding with PostGIS?
added 368 characters in body
Aug
12
comment What is the best way to do reverse geocoding with PostGIS?
Thanks. I'll edit it now, to make it more specific.
Aug
11
asked What is the best way to do reverse geocoding with PostGIS?