Create SQL View for grabbing neighbourhoods as points

Question

Create SQL View for grabbing neighbourhoods as points

Closed this issue 10 years ago · 1 comments

Represent neighbourhoods as points, located at the centroid (center of mass) for the incidents contained within. In addition, return the total weight of the neighbourhood.

This will be later used for rendering the graph between the neighbourhood nodes.

Answer 1 · 2015-05-20T17:03:15.000Z

Done, layer neighbourhoods-centroids returns visible neighbourhoods as a set of points with an additional "weight" attribute that is the sum of the incident weights within.