3

I have a shapefile with a number of weed control blocks as polygons. They each have a unique block id number. I am trying to join a non spatial csv file which has multiple entries for each block over 10yr period. I have tried using Make a Query table but instead of coming up with 411 entries it comes up with over 19,000

I am using ArcGIS 10.1 for Desktop.

  • How many rows in the CSV? It sounds like you're joining the CSV to the weed control blocks and returning one row for each row in the CSV (possibly limited to only the records in the CSV that match the weed control blocks). What are you trying to do with the join? – Michael Stimson Dec 17 '14 at 4:35
  • Thanks for the reply, I have a feature class file which are weed control polygons. I am trying to enter historical weed control data which has been given to me in a spreadsheet. I have tidyed it up and turned it into a csv file. There are 313 lines rows in the csv file. The historical control records will then be entered into a corporate gdb – Toby Dec 17 '14 at 4:45
  • Import the CSV into a database as a table, text files can do silly things, if you have Access you can use that to import the CSV into a personal geodatabase (create in catalog first) as a table then you can see it in ArcCatalog. From the sounds of it you don't have enough records for each polygon; is there duplication in the CSV at all? – Michael Stimson Dec 17 '14 at 5:51
  • I have imported the csv file into a geodatabase through Catalog. In some cases there wont be any records for some of the polygons. There isnt any duplication that I can find in the csv file, they are multiple entries of record sheets for some of the polygons but they all differ either by date, species time etc. – Toby Dec 17 '14 at 22:40
  • Now try the join; It is an attribute join isn't it? Field in polygons matches field in table.. are you joining polygons to table or table to polygons? – Michael Stimson Dec 17 '14 at 23:13
1

Rather than a Join, try creating a Relationship.

This will allow you to select one or more weed control blocks, then use the relationship to select the associated records in the table.

Note that you may need to import your CSV file into a geodatabase in order to use the relationship, which relies on a unique Object ID for each record.

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.