Question

How do I create a summary table of all points inside specific polygon geometries?

  • 27 June 2013
  • 5 replies
  • 0 views
G
Hi All,

 

 

What I am trying to achieve is a Spatial Join of all points which fall inside a specific polygon and then summarise these like a cross tab against each electoral ward area. So far, I have found the SpatialRelator and Statistics Calculator to try and achieve this.

 

 

Can anyone suggest a better method of point me in the right direction?

 

 

Thanks,

 

 

Gary

5 replies

takashi
Rank
Userlevel 2
Badge +17
Hi Gary,

 

 

I think the SpatialRelator is a good choice. If polygons are not overlapped each other, the SpatialFilter generates the same result and might be more efficient.

 

 

Takashi
david_r
Rank
Userlevel 4
Hi Gary,

 

 

how about something like
  • PointOnAreaOverlyer to give each point the ID of their respective polygons
  • Send the points to an Aggregator with a Group By on the polygon ID. Also specify a list name.
  • Run a ListHistogrammer on the list specified in the Aggregator to get the number of occurances in each category, per polygon.
Hopefully this gives you some ideas.

 

 

David
G
Hi David/Takashi,

 

 

Thanks for the replies.

 

 

So there are at least 'two ways to skin a cat!', so to speak.

 

 

Gary
fmelizard
Rank
Userlevel 4
Badge +13
There are probably more ways for the cat to die :)

 

 

You could also use the clipper for that, but the underlaying story is getting the relationships between the objects built. once that is done then there are plenty of ways (too) to analize and visualise it.
G
Hi Itay,

 

 

According to Schrödinger, that is very true.

 

 

Thanks all for your help!

 

 

Gary

Reply


Community Stats

28,654
Posts
109,286
Replies
36,528
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.