1

Is a table with 20 000 rows and 5 columns too large for arc map 10.2.1?

I have tried several things without success to dissolve this table based on one feature.

The table was obtained from the union of a shapefile table with a .xls table.

I can't even export the table to .dbf. When I do this, the resulting table only shows the first line.

Is this a size problem?

closed as off-topic by PolyGeo Feb 4 '17 at 5:38

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "This problem cannot or can no longer be reproduced. Changes to the system or to the asker's circumstances may have rendered the question obsolete, or the question does not include a procedure to enable potential answerers to reproduce the same symptoms. Such questions are off-topic as they are unlikely to help future readers, but editing them to include more details can lead to re-opening." – PolyGeo
If this question can be reworded to fit the rules in the help center, please edit the question.

  • 4
    20,000 features shouldn't be a problem to dissolve unless the features are very complex and therefore have a lot of vertices (this blog post about so-called Godzilla features explores that). If an export results in only one line, verify that there are no features currently selected (I've made that mistake frequently). – Erica Sep 26 '14 at 14:21
  • 5
    How exactly did you "union" a shapefile with a Excel file? Did you change the row count or order while modifying the dBase file? Did the original shapefile draw correctly? How many vertices are in the average feature in the shapefile? Of what topology class (point/line/polygon) is the table? Do you have a spatial index constructed? Please update the question with this information (vice answering in comments). – Vince Sep 26 '14 at 15:03
  • 1
    In principle this is not a large number of features. The bottleneck is usually the data format. I'll suggest that you first upload both your shapefile and excel data to a database. Even a filegeodatabase will give you a much needed boost in the performance. – Devdatta Tengshe Sep 26 '14 at 20:53