I am trying to create separate shapefile using Select analysis with ArcPy by doing an SQL query to create them based on a unique value from the field. I want to create a list of the unique values in the table from a specific field since there are some duplicates of the same value in the field. I want to do a search of the table and find all the unique values and then append them to the list and then do the Select analysis to create individual shapefiles and eventually individual KML files. Thanks in advance.

  • Welcome to the site! Do you have any basic code? It is much easier to assist if we have some starting point to use as reference.
    – Nathanus
    Nov 21, 2011 at 21:13

1 Answer 1


Split Layers by Attributes will allow you to get individual shapefiles using a query. Inputs are a shapefile, the destination is a folder for the output shapefiles to go. You can parse the code if you have some means to create kml files directly, otherwise, explore various options on the ESRI geoprocessing website.

  • Thank you so much. This tool helped out alot. I wish it was integrated into ArcPy as a standard feature especially given Select Analysis.
    – kencon06
    Dec 11, 2011 at 18:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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