3

What would be the most efficient way to export attribute tables from multiple feature class files stored in a file geodatabase? Export to .txt or .csv. Is there any sort of batch process? Or python script?

I have hundreds of files within this geodatabase and really need to automate this process.

4

With Python, you can use arcpy.ListDatasets to create an object to loop through all the features in your file geodatabase, setting the workspace to the geodatabase first. Then, for each feature use arcpy.MakeTableView_management to create a table view that can then be used by arcpy.TableToExcel_conversion to export the tables to Excel. All of these documentation pages should provide you with enough code snippets to get you there.

3

I just came across CopyRows_management() to convert shapefile attribute tables to csv. For example:

import arcpy
my_shp = 'lat_lon.shp'
out_csv = 'points.csv'

arcpy.CopyRows_management(my_shp, out_csv)

We're looking for long answers that provide some explanation and context. Don't just give a one-line answer; explain why your answer is right, ideally with citations. Answers that don't include explanations may be removed.

  • 1
    Please, could you elaborate this answer? It could help other users in the future. – mgri May 22 '17 at 15:04
  • 1
    A good answer should include not only what to use, but also how to use it. Please edit your answer to expand on how to use the copyrows_management(). – Midavalo May 22 '17 at 15:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.