My Feature dataset (residing inside a GDB) contains more than 30 feature classes and every month I like to extract features from this GDB based on one attribute, which is repeating in all the feature classes. For example Job_Month = "May".

Is there any tool available in ArcGIS which will extract all the features in a Geodatabase (or Feature dataset) at one time using an SQL statement? The extract data wizard does not have any filter/SQL for attributes.

Expected simple solutions, but seems not an easy one.

  • 2
    I think it only requires a couple of dozen lines of Python code wrapped around the Select tool and ListFeatureClasses to do this.
    – PolyGeo
    Jun 9, 2013 at 12:33
  • @ PolyGeo - The valid feature types for ListFeatureClass are mostly Geometry based..Will the code able to isolate features based on attribute, anyway thanks Annotation — Arc —. Dimension — Edge — Junction — Line —. Multipatch — Node — Point — Polygon — Polyline — Region — Route — Tic — Jun 9, 2013 at 13:07
  • You would use the Select tool to "isolate features based on attribute". Your use of terms like Tic, etc suggests that you may be used to using coverages and it sounds like you are wanting to archive data in a geodatabase so have you considered Geodatabase Archiving?
    – PolyGeo
    Jun 9, 2013 at 22:34

1 Answer 1


If I have understood you correctly you have a GeoDatabase with 30 FeatureClasses which may be of different geometry types but they all share a common field "Job_Month" which you want to use to select and extract data out by?

A very simple model would achieve this which you can build in model builder. You would have a FeatureClass Iterator feeding into a Select tool where you can set the expression. Have a look at this page.

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.