Skip to main content
Solved

Join by attribute by only when two features intersects

  • October 16, 2017
  • 5 replies
  • 127 views
pinkopo
Contributor
Forum|alt.badge.img+5

Hi guys,

I have two feature classes here one is points and another is polygon. The rule i want to apply is to only let them join by attribute when the point intersects with polygons.

Both feature classes are land ownership data hence both of them would have features with same geometry but different attribute (lot number, unit number and etcs)

I am thinking to use database joiner to join the table but does anyone knows how i can apply the rule to only let intersected feataures to be joined?

Thanks!

Best answer by takashi

Hi @sangli, if you need to merge attributes of a feature from one feature class to other feature(s) from another feature class based on their spatial relationships, you can use the SpatialRelator transformer in general. If you want to merge attributes of a polygon to points within the polygon, the Clipper could also be used efficiently.

View original
Did this help you find an answer to your question?

5 replies

takashi
Influencer
  • takashiInfluencer
  • Best Answer
  • October 16, 2017

Hi @sangli, if you need to merge attributes of a feature from one feature class to other feature(s) from another feature class based on their spatial relationships, you can use the SpatialRelator transformer in general. If you want to merge attributes of a polygon to points within the polygon, the Clipper could also be used efficiently.

pinkopo
Contributor
Forum|alt.badge.img+5
  • pinkopoContributor
  • Author
  • Contributor
  • October 16, 2017
takashi wrote:

Hi @sangli, if you need to merge attributes of a feature from one feature class to other feature(s) from another feature class based on their spatial relationships, you can use the SpatialRelator transformer in general. If you want to merge attributes of a polygon to points within the polygon, the Clipper could also be used efficiently.

Thanks @takashi :)

 

What I want to do is not merging the attribute but join two feature classes by attribute based on one field, when they intersects each other.. (for both feature classes there are often more than one features has the same location)..
pinkopo
Contributor
Forum|alt.badge.img+5
  • pinkopoContributor
  • Author
  • Contributor
  • October 16, 2017

Sorry not sure if i explained clear enough or not.

The two datasets that I am working on are:

feature class A: Point, has spatially duplicated records with different attribute

feature class B: Polygon, has spatially duplicated records with different attribute

the rules I want to apply is:

When feature class A intersect feature class B, join the table from B to A based on common feature attribute.

This common feature attribute is unique for each location but not for the whole dataset.

takashi
Influencer
  • takashiInfluencer
  • October 16, 2017
pinkopo wrote:

Sorry not sure if i explained clear enough or not.

The two datasets that I am working on are:

feature class A: Point, has spatially duplicated records with different attribute

feature class B: Polygon, has spatially duplicated records with different attribute

the rules I want to apply is:

When feature class A intersect feature class B, join the table from B to A based on common feature attribute.

This common feature attribute is unique for each location but not for the whole dataset.

So, the Clipper doesn't help you?

 

  • Send the polygons (B) to the Clipper port, send the points (A) to the Clippee port.
  • Set the common attribute to the Group By parameter.
  • Check the Merge Attributes checkbox.
The point from the Inside port will have the attributes of a polygon that has the same common attribute as the point and also spatially contains the point. Isn't it your required result?

 

pinkopo
Contributor
Forum|alt.badge.img+5
  • pinkopoContributor
  • Author
  • Contributor
  • October 17, 2017
takashi wrote:
So, the Clipper doesn't help you?

 

  • Send the polygons (B) to the Clipper port, send the points (A) to the Clippee port.
  • Set the common attribute to the Group By parameter.
  • Check the Merge Attributes checkbox.
The point from the Inside port will have the attributes of a polygon that has the same common attribute as the point and also spatially contains the point. Isn't it your required result?

 

Thank you again Takashi I didn't thought about using the group by parameter option.. yes that's perfectly sovled my problem!

 

Reply


Helpful Members This Week

Community Stats

31,298
Posts
118,686
Replies
38,878
Members

Latest FME

Terms & ConditionsCookie settings

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.