Weighted Centroid seems to be not working correctly about camshaft HOT 10 CLOSED

retested. Seems like yesterday we fucked up the data or something. You guys win

from camshaft.

Looking in to it now thanks for the heads up @saleiva

from camshaft.

with that amount of points and randomly distributed '2' and '1' I think is correct. Test it with two points table

from camshaft.

but the centers are exactly the same, that's very weird, don't you think?

from camshaft.

Try it with something like:

with points as (
  select (s * s) as weight, st_makepoint(s,s) as the_geom from generate_series(1,2) s
)
--select st_astext(the_geom), weight
select st_astext(cdb_crankshaft.CDB_WeightedMean(the_geom, weight)) as the_geom
from points

And play with the weight value from the CTE.

IMO it's working OK.

from camshaft.

@saleiva visually can be misleading (since there is snapping), did you test it matematically?

from camshaft.

lat/long values where the same at a quick sight

2016-06-23 12:16 GMT+02:00 javi santana [email protected]:

@saleiva https://github.com/saleiva visually can be misleading (since
there is snapping), did you test it matematically?

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#79 (comment),
or mute the thread
https://github.com/notifications/unsubscribe/AAIENWBrXbKYujXSQxciBE9WGRCF0UKaks5qOlzggaJpZM4I8Kgf
.

Sergio Alvarez Leiva

from camshaft.

@saleiva When I try it they look different . Not by much but different

from camshaft.

With some more tests it seams to be working . 4 points 3 on the right 1 on the left with various weightings does what you would expect it to do.

I think one of the reasons your not seeing a big effect in the crimes data is the weights are essentially randomly assigned so they will tend to cancel out. If you give crimes where there was an arrest weight 200 and crimes where there wasn't a weight of 1 then the map looks like this:

Where the blue points are the unweighted centroids and the orange points are the weighted centroids.

So I think its working ok

from camshaft.

FAV

from camshaft.