topic Re: Exporting a very large File Geodatabase Feature Class after an Add Join in Geoprocessing Questions

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

NataliaGutierrez1 — Tue, 13 Nov 2018 18:04:01 GMT

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.

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

JakeSkinner — Tue, 13 Nov 2018 18:31:54 GMT

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.

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

NataliaGutierrez1 — Tue, 13 Nov 2018 19:17:45 GMT

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?

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

JakeSkinner — Tue, 13 Nov 2018 19:36:30 GMT

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?

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

NataliaGutierrez1 — Tue, 13 Nov 2018 20:03:10 GMT

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.

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

JakeSkinner — Tue, 13 Nov 2018 20:05:55 GMT

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.

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

NataliaGutierrez1 — Tue, 13 Nov 2018 20:30:54 GMT

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!

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

JakeSkinner — Tue, 13 Nov 2018 20:46:13 GMT

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.

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

NataliaGutierrez1 — Tue, 13 Nov 2018 20:56:57 GMT

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?

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

JakeSkinner — Tue, 13 Nov 2018 20:59:33 GMT

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

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

NataliaGutierrez1 — Tue, 13 Nov 2018 21:01:49 GMT

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

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

NataliaGutierrez1 — Wed, 14 Nov 2018 19:42:39 GMT

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?

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

JakeSkinner — Wed, 14 Nov 2018 19:48:23 GMT

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.

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

NataliaGutierrez1 — Wed, 14 Nov 2018 20:22:08 GMT

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!