Creating KML files and store them in the related folders

MaryamPanji — Fri, 11 Feb 2022 07:52:32 GMT

Hi everyone,

I have a properties feature class and want to use this to create a kml file for each property and store it in the related region folder. I created a python script, but it put all the kml files in one folder and the rest are empty.

Could you please help me fix my script?

Maryam

import arcpy import os arcpy.env.overwriteOutput = True # settings inputFC = r"\\D\Asset.sde\DBO.asset" field_name=["Property_code","Property_Name","Region"] output_location = r"\\D\Country\KML" print "Starting" # create list of unique properties codes and regions lst_property = [] lst_regions= [] cursor = arcpy.SearchCursor(inputFC) for row in cursor: lst_property.append(row.getValue(field_name[0])) lst_regions.append(row.getValue(field_name[2])) del cursor del row lst_property = list(set(lst_property)) lst_regions = list(set(lst_regions)) for regions in lst_regions: field1 = arcpy.AddFieldDelimiters(inputFC, field_name[2]) where ="\"{0}\" = '{1}'".format(field1, regions) folder=os.path.join(output_location,regions) if not os.path.exists(folder): os.makedirs(folder) folder=r"{}\{}".format(output_location,regions) #loop through properties for Properties in lst_property: field = arcpy.AddFieldDelimiters(inputFC, field_name[0]) where ="\"{0}\" = '{1}'".format(field, Properties) arcpy.MakeFeatureLayer_management(inputFC, "lyr", where) kmz_file = os.path.join(folder,"{0}.kmz".format(Properties)) arcpy.LayerToKML_conversion("lyr", kmz_file)

Re: Creating KML files and store them in the related folders

DanPatterson — Fri, 11 Feb 2022 11:54:31 GMT

it is using your last folder I presume. how are you supposed to know which folder to put the files in in order to change the "folder" name? You will have to maintain an index number referencing the folder or more simply, combine the folder creation with the kml export if they are synced

topic Re: Creating KML files and store them in the related folders in Python Questions

Creating KML files and store them in the related folders

Re: Creating KML files and store them in the related folders