Vjylku

PTIJ: Should I kill my computer after installing software?

Vocabulary for giving just numbers, not a full answer

Contract Factories

Are babies of evil humanoid species inherently evil?

How are showroom/display vehicles prepared?

Word for a person who has no opinion about whether god exists

How to write ı (i without dot) character in pgf-pie

Was Luke Skywalker the leader of the Rebel forces on Hoth?

What problems would a superhuman have whose skin is constantly hot?

How is the wildcard * interpreted as a command?

Does a warlock using the Darkness/Devil's Sight combo still have advantage on ranged attacks against a target outside the Darkness?

Do items de-spawn in Diablo?

Can you reject a postdoc offer after the PI has paid a large sum for flights/accommodation for your visit?

They call me Inspector Morse

How do I express some one as a black person?

weren't playing vs didn't play

What Happens when Passenger Refuses to Fly Boeing 737 Max?

NASA's RS-25 Engines shut down time

Plausibility of Mushroom Buildings

Find longest word in a string: are any of these algorithms good?

Should I take out a loan for a friend to invest on my behalf?

Does the nature of the Apocalypse in The Umbrella Academy change from the first to the last episode?

List elements digit difference sort

What's the "normal" opposite of flautando?

Using ST_DWithin to remove duplicates

Fastest way to remove matched pointsIdentifying Intersections of Geology using PostGISWhat is the MS SQL Spatial syntax for counting points within polygons?Finding points along a pathHow to ensure that Tilemill interprets my postgis query as intended?Neighbors within distance from every rowSelect points near polygon in PostgisDifference between PostGIS ST_Intersects vs '=', QGIS and ArcGIS 'select by location'Using ST_DWithin()Is it ok to group by geometry in PostGIS?

0

I tried it this way but I think using DWithin might be better for this situation. What would be the correct order to find duplicates which exist within 10km from each other?

SELECT n, ST_ClusterDBSCAN(geog::geometry, eps := .08, minpoints := 2) over () AS cid

from (

select *

from cities as t

inner join

    (select n dn

     from cities as t

     group by n

     having count(*) >= 2) dups 

  on dups.dn = t.n

order by t.n

) d

postgis

share

asked 5 mins ago

jakscojaksco

83

add a comment | 

0

I tried it this way but I think using DWithin might be better for this situation. What would be the correct order to find duplicates which exist within 10km from each other?

SELECT n, ST_ClusterDBSCAN(geog::geometry, eps := .08, minpoints := 2) over () AS cid

from (

select *

from cities as t

inner join

    (select n dn

     from cities as t

     group by n

     having count(*) >= 2) dups 

  on dups.dn = t.n

order by t.n

) d

postgis

share

asked 5 mins ago

jakscojaksco

83

add a comment | 

I tried it this way but I think using DWithin might be better for this situation. What would be the correct order to find duplicates which exist within 10km from each other?

SELECT n, ST_ClusterDBSCAN(geog::geometry, eps := .08, minpoints := 2) over () AS cid

from (

select *

from cities as t

inner join

    (select n dn

     from cities as t

     group by n

     having count(*) >= 2) dups 

  on dups.dn = t.n

order by t.n

) d

postgis

share

asked 5 mins ago

jakscojaksco

83

SELECT n, ST_ClusterDBSCAN(geog::geometry, eps := .08, minpoints := 2) over () AS cid

from (

select *

from cities as t

inner join

    (select n dn

     from cities as t

     group by n

     having count(*) >= 2) dups 

  on dups.dn = t.n

order by t.n

) d

share

asked 5 mins ago

jakscojaksco

83

share

asked 5 mins ago

jakscojaksco

83

asked 5 mins ago

jakscojaksco

83

asked 5 mins ago

jakscojaksco

83