nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Exporting a very large File Geodatabase Feature Class after an Add Join

NataliaGutierrez1

Hello!

I have 40 separate File Geodatabase Feature Classes inside a File Geodatabase each with about 1,000,000 polygons each with around 5 fields and 10 new ones I joined using the Add Join tool. So far no problem. However, as far as I know the only way to make this a permanent one is to use the Export Features Tool. Exporting it without the join is done after a few minutes, however exporting it with the join is taking as long as 2 days per File Geodatabase Feature Class.

Is there anything I could do differently to speed up the process??

I would really appreciate somebody's help even if it is to let me know that there is nothing else I can do.

Just want to be sure I am doing it correctly and not wasting a month of work.

Najděte více příspěvků označených jako

Accepted answers

All comments

JakeSkinner

Hi Natalia,

Instead of performing a join and exporting, try executing the Join Field tool. This tool joins the fields directly to the feature class.

NataliaGutierrez1

Thank you Jake for your response. I already tried this as well and it also takes a fair amount of time.

Is there anything else I could do?

JakeSkinner

I would have is to make sure you have the join fields indexed.

Also, where does the join table reside? Is it a CSV, a File Geodatabase table? If it's a File Geodatabase table, does it exist in the same File Geodatabase as the feature class?

NataliaGutierrez1

Jake I am not sure if I have the join fields indexed. I don't really know what that is.How could I do it?

The join table resides in a folder in the form of a shapefile. In reality I am joining the table from a shapefile to a file geodatagase feature class.

JakeSkinner

Try importing the shapefile into the same File Geodatabase as the feature class. Then, add an index to the fields that you are using to create a join.

NataliaGutierrez1

Should I remove the join and add the join again after having moved the shapefile into the Geodatabase? Or moving the shapefile to the geodatabase with the join already done works? I am asking before I remove the joins of over 50 shapefiles 😕

thanks!

JakeSkinner

You will need to re-apply the join once the shapefile is imported into the File Geodatabase. Test one of the layers first before removing all of the joins.

NataliaGutierrez1

Alright will try:

1. Removing the join for one File Geodatabase feature class

2. Then moving the shapefile inside the Geodatabase

3. Add Attribute Indexes to the two fields I am using to create the join. (The common field between the shapefile and the file geodatabase I using to create the join?)

Does that sound correct?

JakeSkinner

Yes, then you can recreate the join and try the export. Or, execute the Join Field tool.

NataliaGutierrez1

ok perfect thank you so much! I really appreciate your help!

NataliaGutierrez1

I am using the Feature Class to Geodatabase tool to move the shapefile into the Geodatabase as a File Geodatabase Feature Class and it is taking too long.

Is there another faster way to do this?

JakeSkinner

Is the shapefile on the same machine as the File Geodatabase? If it is not, try copying the shapefile to the same server the File Geodatabase is on using Window's File Explorer. This could be a network issue.

NataliaGutierrez1

It is actually on the same server and it ended up finishing sooner than the percentage was telling me.

It stayed on 2% and then it was completed after 5 minutes.

I also wanted to let you know that I tried the steps you told me yesterday and the time it is taking to export the file has reduced dramatically!

Thank you so much!

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.