Skip to main content
Question

Polygon Overlaps from two datasets with Percentages

  • September 22, 2020
  • 4 replies
  • 387 views
B

I need to generate a list of polygons from Dataset Y that overlap with Dataset Z and the percentages each polygon overlaps the polygons in the other dataset.

I’ve currently used a spatial relator > list concatenator to find overlapping polygons but it then requires a lot of additional work in excel to get it into a usable table so I am not getting results in the format I need.

The data essentially looks like the follow example and I need something similar to the Ideal Resulting Dataset or in a format that is easy to follow or easy to turn into that dataset.

Example 

Dataset Y

1

2

3

4

 

Dataset Z

A

B

C

D

 

Spatially Datasets Y and Z:

Picture1

Ideal Resulting Dataset:

Picture2

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

4 replies

takashi
Celebrity
  • takashiCelebrity
  • September 22, 2020

Hi @bek​ , hopefully this workflow works for you. Assuming that polygons belonging to Dataset Z don't overlap each other.

workflow

Result (sorted and rounded)

result

Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
B
  • bek
  • Author
  • September 22, 2020
takashi wrote:

Hi @bek​ , hopefully this workflow works for you. Assuming that polygons belonging to Dataset Z don't overlap each other.

workflow

Result (sorted and rounded)

result

Thanks so much @Takashi Iijima​ ! I have tried to run it overnight but ran out of memory so am trying again with feature caching off to see if that helps. It takes a really long time to run even though the data isn't that big (starts with 244 and 607 features with the list exploder creating 145,205 features from the dataset with 244 features). If there is overlaps in Dataset Z what would happen? Generally they don't overlap but it is likely overlaps will exist.

takashi
Celebrity
  • takashiCelebrity
  • September 23, 2020
takashi wrote:

Hi @bek​ , hopefully this workflow works for you. Assuming that polygons belonging to Dataset Z don't overlap each other.

workflow

Result (sorted and rounded)

result

Another approach.

workflow-2-1

workflow-2-2

Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
topotoma
Contributor
Forum|alt.badge.img+3
  • topotomaContributor
  • Contributor
  • December 18, 2023
takashi wrote:

Another approach.

workflow-2-1

workflow-2-2

Thanks Takashi, it's been very useful. Clean !

Helpful Members This Week

Community Stats

32,055
Posts
121,717
Replies
39,681
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.