[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    [postgis-users] repeating points filtering
From:       Nicholas I <nicholas.domnic.i () gmail ! com>
Date:       2010-09-23 11:22:19
Message-ID: AANLkTims7+ZVCjiiuuzfhAkUAD6XxzGTgLHY+5Svfncz () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


Hi,

I have a table called locations, which contains the city name's and
landmarks.

>> some of the location name get's repeated but they all have a different
lat,lon.
>> some of the locations are very near by like within 2km.

I want to eliminate the locations that are very close by having the same
name. (only those have the same name).
distinct give's me unique record's.

does buffer help me to solve the problem. i am not able to understand... i
am confused which one to use. whether to use, buffer, distance or dwitin.

-Nicholas I

[Attachment #5 (text/html)]

Hi, <br><br>I have a table called locations, which contains the city name&#=
39;s and landmarks.<br><br>&gt;&gt; some of the location name get&#39;s rep=
eated but they all have a different lat,lon.<br>&gt;&gt; some of the locati=
ons are very near by like within 2km.<br>
<br>I want to eliminate the locations that are very close by having the sam=
e name. (only those have the same name).<br>distinct give&#39;s me unique r=
ecord&#39;s.<br><br>does buffer help me to solve the problem. i am not able=
 to understand... i am confused which one to use. whether to use, buffer, d=
istance or dwitin.<br>
<br>-Nicholas I<br>


_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


[prev in list] [next in list] [prev in thread] [next in thread]