Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
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 '11 at 21:13
up vote 6 down vote accepted

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.

share|improve this answer
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 '11 at 18:00

Your Answer


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.