topic Re: Many to Many Relationships in Implementing ArcGIS Questions

Many to Many Relationships

Anonymous User — Mon, 01 Jul 2019 18:11:57 GMT

I am working through a design where there is one geospatial layer (counties), and a project table. Both contain unique identifiers 1) County = GEOID and 2) Project = Proj_ID.

A county may have multiple projects associated with it, and a project may have multiple counties associated with it. This would seem ideal for the many to many relationship. What would be the most optimal approach to creating this relationship?

#optimizing geodatabase #manytomanyrelationships‌

Re: Many to Many Relationships

GurunathanGanesarethinam — Fri, 05 Jul 2019 21:35:26 GMT

Hello Mark,

Yes, you can create Many to Many relationship class for this. Follow the ArcGIS help link here to create this relationship class. You can pick Simple relationship class option and then select Many to Many.

http://desktop.arcgis.com/en/arcmap/10.6/extensions/production-mapping-guide/admin-pl-sql-server/creating-and-configuring-the-geodatabase-in-sql-server.htm

Regards,

Guru