You are here: > ESRI Forums > arcgis desktop discussion forums > Thread Replies

ArcGIS Desktop Discussion Forums

ArcGIS Desktop - Attribute Tables forum

What is the maximum number of fields and re...   Jamal NUMAN Apr 01, 2010
Re: What is the maximum number of fields an...   Tony Contreras Apr 06, 2010
Re: What is the maximum number of fields an...   William Huber Apr 09, 2010
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject What is the maximum number of fields and records in the attribute table of the shape file? 
Author Jamal NUMAN 
Date Apr 01, 2010 
Message What is the maximum number of fields and records in the attribute table of the shape file?

 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: What is the maximum number of fields and records in the attribute table of the shape file? 
Author Tony Contreras 
Date Apr 06, 2010 
Message 255 is the maximum number of fields. The rest of the dbase (which shapefile is based on) limitations are listed here.

dBase IV limitations:
http://jabrown.customer.netspace.net.au/approach/webfaq04040210.html

one or many of these might apply to number of records. 
  Tony C. 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: What is the maximum number of fields and records in the attribute table of the shape file? 
Author William Huber 
Date Apr 09, 2010 
Message The field limitation is easily overcome by using a single identifier field and then joining as many additional tables as you like. (Using this method I have worked with shapefiles having many thousands of fields.) By using a width-10 numeric field for the identifier, for example, the sole remaining dBase limitation is that of file size on disk (of 2 GB), which limits you to about 200 million records. That's actually not a limitation due to the bound on the number of vertices in the _shape_ part of the shapefile (not its attribute table): that part, too, is limited to a file size of 2 GB. Because each vertex requires a pair of doubles, therefore totaling 16 bytes, the shape part of a shapefile cannot hold more than about 128 million vertices (and therefore will not exceed the dBase record limitation unless there are many null records). 
  --Bill Huber
Quantitative Decisions (http://www.quantdec.com )
More GIS Q&A at http://gis.stackexchange.com/q/3083/664