topic Definition Queries and exporting to shapefile in Python Questions

Definition Queries and exporting to shapefile

MarcosMendez — Thu, 16 Feb 2017 15:48:33 GMT

Hi, I'm fairly new to python and was able to figure out how to do an export from our organization's SDE feature class to a shapefile through python. I'm trying to figure out how to do a an EQUAL TO definition from my SDE feature class and then have it export it to a shapefile with the definition query. For example, I have a feature class in SDE of sewer manholes and within that feature class I'm trying to pull out just the abandoned manholes and have be its own shapefile.

Any tips, suggestions, or sample codes would be helpful.

I've also attached a screen shot of the code I'm using to the feature class into a shapefile. I just need to add into that for the definition query portion of my task.

Thanks

Re: Definition Queries and exporting to shapefile

IanMurray — Thu, 16 Feb 2017 16:09:00 GMT

I would suggest making a Feature Layer, which would allow you to use a query to subset your data down to what you want prior to converting it to a shapefile. Then use that Feature Layer as your input for feature class to shapefile.

http://pro.arcgis.com/en/pro-app/tool-reference/data-management/make-feature-layer.htm

Conversely you can do a select by attribute and do something similar to this post.

https://community.esri.com/thread/121098

Either way take a look at Josh Bixby's post in that link above about properly formatting SQL queries in Python, will help you get the syntax right.

Re: Definition Queries and exporting to shapefile

MarcosMendez — Thu, 16 Feb 2017 17:11:58 GMT

Making the feature class into a Feature Layer worked!

Thanks for your suggestion

Re: Definition Queries and exporting to shapefile

DarrenWiens2 — Thu, 16 Feb 2017 17:17:38 GMT

You can use the Select geoprocessing tool to do this in a single step.