I have a point feature data sets with attribute tables. The feature layers are up to 40 but I have managed to merge them up as 1 feature class. The nutty part is that the ‘merged’ feature class now has more than 120 fields and about 2500 records. Meanwhile, the fields and rows are expected to grow as more data pour in in the feature. I was wondering if there is a smarter way of managing this kind of data rather than the way I am currently doing it.
Note that some fields/columns contains just a few rows of data given the fact that some records may just need about 50 columns to represent them as against about 1000 fields already existing in the feature attribute table, thereby having a lot of ‘null’ or empty fields for some records/rows.
Actually, the intent is to have a database that can be immediately queried by field or any other parameter to retrieve information quickly. But for now, the number of fields has even become complex to scroll through and the database looks a little cluttered…… What could be the way out here?
I am using ArcGIS Desktop and the Data sets are being managed in a File Geodatabase.
I will appreciate your thoughts in this matter.