Skip to main content
Solved

Join without losing geometry

  • Jun 13, 2019 7:47 PM UTC
  • 6 replies
  • 400 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

View original
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
Evangelist
Forum|alt.badge.img+54
  • Evangelist
  • Best Answer
  • Jun 13, 2019 7:52 PM UTC

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
  • Jun 13, 2019 8:02 PM UTC

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
Evangelist
Forum|alt.badge.img+54
  • Evangelist
  • Jun 13, 2019 8:06 PM UTC

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
  • Jun 13, 2019 8:10 PM UTC

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
  • Jun 14, 2019 6:33 AM UTC

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
  • Jun 14, 2019 10:17 AM UTC

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