topic Re: Convert features with the same code to a KML file in Python Questions

Convert features with the same code to a KML file

DanutaHodgson — Wed, 07 Feb 2018 09:13:21 GMT

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.

Re: Convert features with the same code to a KML file

XanderBakker — Wed, 07 Feb 2018 11:32:33 GMT

Hi Danuta Hodgson ,

What you will need to do is:

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

    fc_in = r'C:\Folder\SubFolder\myShapeFileName.shp'‍‍

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

    fld_trail = 'AA_area'‍‍

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

    out_folder = r'C:\Folder\SubFolder\ResultingKMZfolder'‍‍

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

        where ="\"{0}\" = '{1}'".format(fld, trail_name)‍

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

Re: Convert features with the same code to a KML file

DanutaHodgson — Wed, 07 Feb 2018 11:50:14 GMT

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)

Re: Convert features with the same code to a KML file

XanderBakker — Wed, 07 Feb 2018 12:01:18 GMT

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?

Re: Convert features with the same code to a KML file

XanderBakker — Fri, 10 Dec 2021 23:01:02 GMT

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:

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 trail_name 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)

if __name__ == '__main__':
    main()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Convert features with the same code to a KML file

DanutaHodgson — Wed, 07 Feb 2018 12:34:21 GMT

Hi,

I have copied the above text into python in arc and I got a runtime error.

I am using ArcGIS 10.0

>>> 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 trail_name 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)
...
... if __name__ == '__main__':
... main()
...
Runtime error <type 'exceptions.AttributeError'>: 'module' object has no attribute 'da'

Re: Convert features with the same code to a KML file

XanderBakker — Wed, 07 Feb 2018 12:37:15 GMT

OK, I see. At 10.1 the arcpy.da cursors were introduced, so the old cursor object should be used. I will post back a revised script.

Re: Convert features with the same code to a KML file

XanderBakker — Fri, 10 Dec 2021 23:01:05 GMT

Try this:

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 = []
    cursor = arcpy.SearchCursor(fc_in)
    for row in cursor:
        lst_trails.append(row.getValue(fld_trail))
    del cursor
    del row
    lst_trails = list(set(lst_trails))

    # loop through trails
    for trail_name 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)

if __name__ == '__main__':
    main()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Convert features with the same code to a KML file

DanutaHodgson — Wed, 07 Feb 2018 14:10:55 GMT

Hi, thank you for helping me out. I really suck at scripts.

I ran the script and and and ArcMap Drawing Error saying one or more layers failed to draw:

lyr: An invalid SQL statement was used.

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.

Should there be changes in the script. Could you tell me what and I can change them?

Really appreciate the help

Re: Convert features with the same code to a KML file

XanderBakker — Wed, 07 Feb 2018 14:16:54 GMT

Possibly, something related to the data is happening here. To avoid guessing, I really would need to have a look at the data. Can you share it?

Re: Convert features with the same code to a KML file

DanutaHodgson — Wed, 07 Feb 2018 14:25:36 GMT

Sure

Re: Convert features with the same code to a KML file

XanderBakker — Wed, 07 Feb 2018 14:43:58 GMT

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:

        where ="{0} = '{1}'".format(fld, trail_name)‍

It will generate 48 KMZ files:

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

Re: Convert features with the same code to a KML file

DanutaHodgson — Wed, 07 Feb 2018 14:52:25 GMT

Hi,

Could you post the script again please.

Thank you so much for your help

Re: Convert features with the same code to a KML file

XanderBakker — Fri, 10 Dec 2021 23:01:08 GMT

Sure:

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'

##    fc_in = r'C:\GeoNet\ExportKMZ\Agri_EC_working_data.shp'
##    fld_trail = 'AA_area'
##    out_folder = r'C:\GeoNet\ExportKMZ\KMZ'

    # create list of unique trail names
    lst_trails = []
    cursor = arcpy.SearchCursor(fc_in)
    for row in cursor:
        lst_trails.append(row.getValue(fld_trail))
    del cursor
    del row
    lst_trails = list(set(lst_trails))

    # loop through trails
    for trail_name in lst_trails:
        fld = arcpy.AddFieldDelimiters(fc_in, fld_trail)
        where ="{0} = '{1}'".format(fld, trail_name)
        print where
        arcpy.MakeFeatureLayer_management(fc_in, "lyr", where)
        kmz_file = os.path.join(out_folder, "{0}.kmz".format(trail_name))
        print kmz_file
        arcpy.LayerToKML_conversion("lyr", kmz_file)

if __name__ == '__main__':
    main()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

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

Re: Convert features with the same code to a KML file

XanderBakker — Wed, 07 Feb 2018 18:05:21 GMT

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

Re: Convert features with the same code to a KML file

DanutaHodgson — Thu, 08 Feb 2018 05:57:42 GMT

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

Re: Convert features with the same code to a KML file

XanderBakker — Thu, 08 Feb 2018 11:57:41 GMT

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 )

Re: Convert features with the same code to a KML file

mapdonalds — Tue, 14 Aug 2018 20:11:46 GMT

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