Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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 class : Eg : 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 .

The extract data wizard does not have any filter/Sql for the attributes.

Expected simple solutions, but seems not an easy one..

share|improve this question
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 '13 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 — –  Adarsh Madhavan Jun 9 '13 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 '13 at 22:34

1 Answer 1

up vote 3 down vote accepted

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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