So I am currently working with two separate files. One is a polygon feature class detailing a specific countries' subdistricts. These subdistricts are identified using a specific alpha-numeric code. The other file is a .csv file containing information on humanitarian programs currently in place within this country. Each program is identified by its location, down to the subdistrict (using the same code). There are numerous subdistricts with multiple programs.

My end goal is to assign each individual program the polygon of the subdistrict where it is located. To this end, I have created a relationship class between the two (one-to-many). However, it seems this will not help me accomplish my goal.

Is there any way I can accomplish this? One idea would be to export the polygon spatial data to .csv format, allowing a join, but I'm not sure if that is possible.

  • 2
    What is your goal? You only have two choices with that one (region) to many (program) relationship - a relate (which you say won't work), or duplicate region polygons. See gis.stackexchange.com/questions/134052 or gis.stackexchange.com/questions/123064 or gis.stackexchange.com/questions/110907 – Chris W Jul 19 '15 at 19:15
  • perhaps a join might be more appropriate but from the sounds of it you want to join the table to the polygons which will not generate geometries in your output. It might be better to separate your programs into individual tables then for each program join the polygons to the table (1 to 1) and select 'matching only' which will not show any polygons that don't have a matching program. Are you trying to do this interactively or would you like to build an arcpy script to do this? – Michael Stimson Jul 19 '15 at 21:16
  • Agree with Chris and Michael. The easiest way would probably be to Join or Relate the data. Joins = one-to-one or many-to-one. Relates = one-to-many or many-to-many. – John Jul 20 '15 at 1:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.