network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 10 months |
| seen | Dec 20 '12 at 2:24 | |
| stats | profile views | 20 |
|
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? |
