nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Convert features with the same code to a KML file

DanutaHodgson

branched from https://community.esri.com/thread/207867-how-to-automate-selection-and-kml-conversion

Hi,

I need to do something similar but for areas.

However I have arcmap10.0 and I cannot get this script to work.

Could you please assist me.

I need to select multiple attributes that have the same name in the AA_area field and export them as a Kmz. I then need it to choose the next area and repeat.

EG. Alexandia is in the attribute table 10 times under AA_area and I would like it to export all 10 polygons into one kmz (this is a shapefile in need to convert from). I need to do this for all the different areas in the AA_area field.

Thank you for your help.

Encontre mais publicações marcadas com

Accepted answers

All comments

mapdonalds

Hi,

I'm trying to use this script to do a similar task and I am creating KMZs that have ALL files in the original feature class, even though I have the where clause in my script.

I want to create a KMZ for each individual landowner on a set of properties, some landowners having multiple properties. Any suggestions?

Thank you

XanderBakker

Hi Danuta Hodgson , I assume you can't update to a newer version of ArcGIS, right?

Since the code works on my computer using 10,6, there may have been a change in the arrangement of the parameters over versions. What I would like you to do, is to manually set a definition query, like this:

Go to your ArcToolbox and locate the Layer To KML tool and open it.

Select the layer you want to export, define the output file, leave all the other settings untouched and hit "OK":

After the tool has successfully finished the process, open the Results window:

In the Results windows find the process you just executed, right click on it and copy the python snippet:

In my case it looks something like this:

# Replace a layer/table view name with a path to a dataset (which can be a layer file) or create the layer/table view within the script
# The following inputs are layers or table views: "Agri_EC_working_data", "test_pol"
arcpy.LayerToKML_conversion(layer="Agri_EC_working_data", out_kmz_file="C:/GeoNet/ExportKMZ/Alexandria.kmz", layer_output_scale="0", is_composite="NO_COMPOSITE", boundary_box_extent="test_pol", image_size="1024", dpi_of_client="96", ignore_zvalue="CLAMPED_TO_GROUND")

Can you copy this in the thread, so I can see if there is something different with the definition of the parameters? If so, I can adapt the code correspondingly.

If not, then you should try again in a new session of ArcMap without any environment settings set to see if that works. If not, then there will be little I can do, then to urge you to upgrade, since 10.0 is no longer supported.(it was retired on Jan 1, 2016 see Esri Support 10.0 )

DanutaHodgson

Morning,

Thanks for the help.

I ran the code, just copy and pasted.

Still got an error.

Runtime error <class 'arcgisscripting.ExecuteError'>: ERROR 000622: Failed to execute (Layer To KML). Parameters are not valid. ERROR 000625: layer_output_scale parameter has no default value.

Thanks for sending the kmz. The reason I need it to work is that I need to do this quite often with different files

Regards

Danuta

XanderBakker

Hi danusha16@gmail.com , did the code work for you?

XanderBakker

Sure:

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">main</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">import</SPAN> arcpy
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">import</SPAN> os
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># settings: edit these</SPAN>
&nbsp;&nbsp;&nbsp; fc_in <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\Users\Danuta\Desktop\CSS 2016-17\TEST\Agri\Agri_EC_working_data.shp'</SPAN>
&nbsp;&nbsp;&nbsp; fld_trail <SPAN class="operator token">=</SPAN> <SPAN class="string token">'AA_area'</SPAN>
&nbsp;&nbsp;&nbsp; out_folder <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\Users\Danuta\Desktop\CSS 2016-17\TEST'</SPAN>

<SPAN class="comment token">##&nbsp;&nbsp;&nbsp; fc_in = r'C:\GeoNet\ExportKMZ\Agri_EC_working_data.shp'</SPAN>
<SPAN class="comment token">##&nbsp;&nbsp;&nbsp; fld_trail = 'AA_area'</SPAN>
<SPAN class="comment token">##&nbsp;&nbsp;&nbsp; out_folder = r'C:\GeoNet\ExportKMZ\KMZ'</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># create list of unique trail names</SPAN>
&nbsp;&nbsp;&nbsp; lst_trails <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; cursor <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fc_in<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lst_trails<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">.</SPAN>getValue<SPAN class="punctuation token">(</SPAN>fld_trail<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">del</SPAN> cursor
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">del</SPAN> row
&nbsp;&nbsp;&nbsp; lst_trails <SPAN class="operator token">=</SPAN> list<SPAN class="punctuation token">(</SPAN>set<SPAN class="punctuation token">(</SPAN>lst_trails<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># loop through trails</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> trail_name <SPAN class="keyword token">in</SPAN> lst_trails<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fld <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>AddFieldDelimiters<SPAN class="punctuation token">(</SPAN>fc_in<SPAN class="punctuation token">,</SPAN> fld_trail<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where <SPAN class="operator token">=</SPAN><SPAN class="string token">"{0} = '{1}'"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>fld<SPAN class="punctuation token">,</SPAN> trail_name<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> where
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>fc_in<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"lyr"</SPAN><SPAN class="punctuation token">,</SPAN> where<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; kmz_file <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>out_folder<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"{0}.kmz"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>trail_name<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> kmz_file
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>LayerToKML_conversion<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"lyr"</SPAN><SPAN class="punctuation token">,</SPAN> kmz_file<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">if</SPAN> __name__ <SPAN class="operator token">==</SPAN> <SPAN class="string token">'__main__'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; main<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

... and I have attached the resulting KMZ files too.

kmz.zip

DanutaHodgson

Hi,

Could you post the script again please.

Thank you so much for your help

XanderBakker

I just did a test run and it returned an error on the where clause and I noticed that I already had accounted for different types of input featureclasses. So the original where clause is the correct one:

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where <SPAN class="operator token">=</SPAN><SPAN class="string token">"{0} = '{1}'"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>fld<SPAN class="punctuation token">,</SPAN> trail_name<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

It will generate 48 KMZ files:

If for some reason the problems persist, I can upload the generated KMZ files.

DanutaHodgson

Sure

Agri_EC_working_data.zip

XanderBakker

I notice that you didn't copy the entire code. The part that starts the code was not included. You should copy and paste the entire code below:

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">main</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">import</SPAN> arcpy
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">import</SPAN> os
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># settings: edit these</SPAN>
&nbsp;&nbsp;&nbsp; fc_in <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\Users\Danuta\Desktop\CSS 2016-17\TEST\Agri\Agri_EC_working_data.shp'</SPAN>
&nbsp;&nbsp;&nbsp; fld_trail <SPAN class="operator token">=</SPAN> <SPAN class="string token">'AA_area'</SPAN>
&nbsp;&nbsp;&nbsp; out_folder <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\Users\Danuta\Desktop\CSS 2016-17\TEST'</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># create list of unique trail names</SPAN>
&nbsp;&nbsp;&nbsp; lst_trails <SPAN class="operator token">=</SPAN> list<SPAN class="punctuation token">(</SPAN>set<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>r<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">for</SPAN> r <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fc_in<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN>fld_trail<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># loop through trails</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> trail_name <SPAN class="keyword token">in</SPAN> lst_trails<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fld <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>AddFieldDelimiters<SPAN class="punctuation token">(</SPAN>fc_in<SPAN class="punctuation token">,</SPAN> fld_trail<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where <SPAN class="operator token">=</SPAN><SPAN class="string token">"\"{0}\" = '{1}'"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>fld<SPAN class="punctuation token">,</SPAN> trail_name<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>fc_in<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"lyr"</SPAN><SPAN class="punctuation token">,</SPAN> where<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; kmz_file <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>out_folder<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"{0}.kmz"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>trail_name<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>LayerToKML_conversion<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"lyr"</SPAN><SPAN class="punctuation token">,</SPAN> kmz_file<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">if</SPAN> __name__ <SPAN class="operator token">==</SPAN> <SPAN class="string token">'__main__'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; main<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

XanderBakker

I'm going to branch your question to a new thread. It would be better if I have access to (a subset) of the data you want to use. Can you attach the shapefile (zipped) to this thread?

DanutaHodgson

Thank you for coming back to me.

I tried what you said, but absolutely nothing happened.

Please could you double check

Also should train name not be changed to AA_area?

def main():
... import arcpy
... import os
... arcpy.env.overwriteOutput = True
...
... # settings: edit these
... fc_in = r'C:\Users\Danuta\Desktop\CSS 2016-17\TEST\Agri\Agri_EC_working_data.shp'
... fld_trail = 'AA_area'
... out_folder = r'C:\Users\Danuta\Desktop\CSS 2016-17\TEST'
...
... # create list of unique trail names
... lst_trails = list(set([r[0] for r in arcpy.da.SearchCursor(fc_in, (fld_trail))]))
...
... # loop through trails
... for AA_area in lst_trails:
... fld = arcpy.AddFieldDelimiters(fc_in, fld_trail)
... where ="\"{0}\" = '{1}'".format(fld, trail_name)
... arcpy.MakeFeatureLayer_management(fc_in, "lyr", where)
... kmz_file = os.path.join(out_folder, "{0}.kmz".format(trail_name))
... arcpy.LayerToKML_conversion("lyr", kmz_file)

XanderBakker

Hi Danuta Hodgson ,

What you will need to do is:

On line 7 locate the path to your input shapefile like this:

&nbsp;&nbsp;&nbsp; fc_in <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\Folder\SubFolder\myShapeFileName.shp'</SPAN>‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

On line 8 you will have to specify the field with the names. For each name a KMZ will be created:

&nbsp;&nbsp;&nbsp; fld_trail <SPAN class="operator token">=</SPAN> <SPAN class="string token">'AA_area'</SPAN>‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

On line 9 you will need to specify the output folder location where the KMZ files will be stored:

&nbsp;&nbsp;&nbsp; out_folder <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\Folder\SubFolder\ResultingKMZfolder'</SPAN>‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Since you are using a shapefile your where clause will be different. So change line 17 to this:

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where <SPAN class="operator token">=</SPAN><SPAN class="string token">"\"{0}\" = '{1}'"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>fld<SPAN class="punctuation token">,</SPAN> trail_name<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

It is important that the indentation remains the same. Changing it will make the code invalid.

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.