Skip to main content
Solved

Join without losing geometry

  • June 13, 2019
  • 6 replies
  • 277 views

I have geometric data that I want to join with non-geometric data. From what I read and noticed, a FeatureJoiner won't keep the geometry during a join. I would use a FeatureMerger, but the cardinality of my features won't make it work. I tried aggregating one of my feature to make it possible for me to use the FeatureMerger, but the aggregations are not supported by ArcGisOnline (that's where I want to write). I ran out of ideas to solve this problem, do you have any solutions?

 

Thank you

Best answer by ebygomm

I'm not sure I follow as to why the featuremerger is not an option, but you could always extract the geometry into an attribute with a geometryextractor then rebuild after using the featurejoiner with a geometry replacer

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.

6 replies

ebygomm
Influencer
Forum|alt.badge.img+44
  • Influencer
  • 3427 replies
  • Best Answer
  • June 13, 2019

I'm not sure I follow as to why the featuremerger is not an option, but you could always extract the geometry into an attribute with a geometryextractor then rebuild after using the featurejoiner with a geometry replacer


  • Author
  • 6 replies
  • June 13, 2019

I'm not sure I follow as to why the featuremerger is not an option, but you could always extract the geometry into an attribute with a geometryextractor then rebuild after using the featurejoiner with a geometry replacer

FeatureMerger will give the EXTRA_REFFERENCE error. But I am definetely going to try your idea thank you a lot!


ebygomm
Influencer
Forum|alt.badge.img+44
  • Influencer
  • 3427 replies
  • June 13, 2019

FeatureMerger will give the EXTRA_REFFERENCE error. But I am definetely going to try your idea thank you a lot!

You could switch the suppliers and requestor features around to get round that, or process duplicate suppliers in the feature merger, build a list and then explode the list


  • Author
  • 6 replies
  • June 13, 2019

You could switch the suppliers and requestor features around to get round that, or process duplicate suppliers in the feature merger, build a list and then explode the list

One of the thing is that the cardinality is many-to-many and I believe I tried your last idea but it caused me to lose some information, I'll give it a second go and see


david_r
Celebrity
  • 8392 replies
  • June 14, 2019

FeatureMerger will give the EXTRA_REFFERENCE error. But I am definetely going to try your idea thank you a lot!

If you get an EXTRA_REFERENCE error, try turning on "Process duplicate suppliers" in the FeatureMerger:

 


gio
Contributor
Forum|alt.badge.img+15
  • Contributor
  • 2252 replies
  • June 14, 2019

@nademmy

EXTRA_REFERENCE measn dat the supplier key is offered more than once.

You can have them processe as @david_r says by setting "process duplicates".

If you enter a list and then explode it you get the data merged.

But be aware that 1:M can lead to as many duplicate geometries as there are suppliers

 

If you are going to use it in arcmap you might wanbt to keep the data separated, as in arcmap you can use the table join on the fly.

 

btw, you don't need to switch suppliers and requestors as you can have the feature merger set to merge mode= "attributes and geometry" if you want the supplier geometry rather than the requestor geometry.