I have an existing polygon feature class with about 30 attribute fields. I would like to append another 20 fields from an existing table in the same file geodatabase. Can this be done using an out-of-the-box tool? This is not a problem when creating a new feature class; in this case I would use the Import button on the Feature Class Properties:Fields tab. Now that my feature class contains records (as well as a subtype field with subtypes, in case this makes a difference) the Import button is unavailable (dimmed).
[GIS] Appending field from file geodatabase table to polygon feature class
arcgis-10.0arcgis-desktopfile-geodatabase
Related Solutions
I did call ESRI support about this and their answer wasn't encouraging, but it did explain the problem. Paraphrasing ESRI: The problem is that ArcGIS Desktop, being 32-bit software, is limited to using 4GB of RAM at the most. The text file has to be processed in RAM before being stored as a table, so at some poing during processing ArcGIS was hitting the RAM limit and just stopping there. The file I was importing was around 6GB in size. Apparently the fact that it failed without giving an error message is unique to me, I tried having other people in my office do it and the import still failed, but it gave an error message (an unhelpful one, but at least something that let the user know something went wrong), and the ESRI rep said that it should give an error.
My solution was to split the file into two smaller CSVs using a text editor (I used EditPad Pro), import each of them into an FGDB as a separate table, then merge the two FGDB tables. For some reason this failed the first time I tried it but worked later on. I may get around to testing this a little more fully, I'm going to be dealing with files this size on an ongoing basis.
I'm using ArcGIS 10.0, but ArcGIS 10.1 service pack 1 was just released and adds the ability to use a 64-bit background geoprocessor, which will let the geoprocessor use more than 4GB RAM, that may fix this problem but I can't test that.
UPDATE: I am now using ArcGIS 10.1 SP1 (with the 64-bit background geoprocessing addon) and it does successfully import these giant .CSVs, at least the ones I've dealt with so far. On a machine with 14GB of RAM (yes, 14), a 6GB .CSV with about 10.5 million rows successfully imports to an FGDB table.
I had the same issue a while back when I transitioned into an Enterprise Level GDB.
The workaround is a bit convoluted but it gets what you need:
From your Geodatabase: Right Click
- select Properties
- Select Domains
- Enter Domain Name (use the FeatureClass name)
- Set Domain Properties (field type, domain type, etc)
- Enter Code (this is what will populate in your drop down menus) + Description
- Click OK
Go to the Feature Class
- Right Click
- select Properties
- Select Subtypes
- Select your new subtype from the dropdown menu
Best Answer
If you want both the fields and their values, you can use Join Field to accomplish this:
(source: arcgis.com)
If you just want the field definitions and no values to be added to an existing feature class, as far as I can tell no out-of-the-box tools will handle this.
However you might be interested in X-Ray for ArcCatalog. It might be able to do what you're looking for ("Merge two different designs in to a new consolidated geodatabase design"), but haven't used it enough myself to say for sure.