Latest Contributions by RandyBurton

My thoughts on your code is to replace lines 14 and 15 jData = json.dumps(output)    json.dump(output, jsonfile, indent=2, sort_keys=True)‍‍ with this: # create a dictionary of features jData = { "features" : None } # output is a list of dictionaries, in this case features # insert the list into the jData dictionary jData["features"] = output # save the jData dictionary to a json file json.dump(jData, jsonfile, indent=2, sort_keys=True)‍‍‍‍‍‍‍‍‍‍‍ You could combine the scripts, basically starting with the first 12 lines of your script (with the includes, etc.), then the six lines above, and finally including my script starting with line 12.  You would end up with something like this: import csv import json csvfile = open('MyFile.csv', 'r') reader = csv.DictReader(csvfile) fieldnames = ('Name', 'Flow', 'Arrow Size', 'Date', 'Lat', 'Long', 'Heading', 'Color', 'Desciption', 'table') output = [] for each in reader:   row = {}   for field in fieldnames:     if not field == 'Coords':         row[field] = each[field]      output.append(row) jData = { "features" : None } jData["features"] = output # start the geojson file geo = {     "type" : "FeatureCollection",     "crs" : { "type" : "name",               "properties" : {                   "name" : "EPSG:4326"                   }               },     "features" : None     } feature_list = [] # loop through json fCount = 0 for feature in jData['features']:     fCount +=1     features = {         "type" : "Feature",         "id" : fCount,         "geometry" : { "type" : "Point",                        "coordinates" : [                            float(feature["Lat"]), float(feature["Long"]) ]                        },         "properties" : { "OBJECTID" : fCount,                          "Name" : feature["Name"],                          "Lat" : float(feature["Lat"]),                          "Long" : float(feature["Long"]),                          "Heading" : int(feature["Heading"])                          }         }         feature_list.append(features)     # this part would be exported to tab/csv file     # for k, v in feature['table']:     #   print str(fCount)+ '\t' + k + '\t' + v         geo["features"] = feature_list # to write to a file with open('result2.json', 'w') as fp:      json.dump(geo, fp) ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

I've used this code in the Python window inside ArcMap.  You may need to adjust around lines 40-41 if the VB code from the label expression isn't well formatted. mxd = arcpy.mapping.MapDocument("CURRENT") # reference document open in ArcMap for lyr in arcpy.mapping.ListLayers(mxd):     if lyr.supports("LABELCLASSES"):         print "\n\nProcessing Layer: " + lyr.name         # check for label class expression         lblExp = ""         lblType = "Other"         for lblClass in lyr.labelClasses:             lblExp = lblClass.expression             if len(lblExp):                 if "Function FindLabel" in lblExp:                     lblType = "VB"                     print "VB expression found"                 elif "def FindLabel" in lblExp:                     lblType = "PYTHON_9.3" # assuming later version of ArcMap                     print "Python expression found"                 elif "function FindLabel" in lblExp:                     lblType = "JScript" # Field Calculator does not use JScript                     print "JScript expression found"         if lblType == "VB": # just working with VB for now             add_field = True # plan to add field for TextLabel             layerFields = arcpy.ListFields(lyr)             for fld in layerFields:                 if fld.name in ['TextLabel']:                     add_field = False  # no need to add field             if add_field:                 print "Adding field: TextLabel"                 arcpy.AddField_management(in_table=lyr,                                           field_name="TextLabel",                                           field_type="TEXT",                                           field_length="50",                                           field_alias="Text Label",                                           field_is_nullable="NULLABLE",                                           field_is_required="NON_REQUIRED")             # delete first and last line of VB code block             lblExp = lblExp.strip()             calcExp = lblExp[lblExp.find('\n')+1:lblExp.rfind('\n')].strip()             print calcExp             arcpy.CalculateField_management(in_table=lyr,                                 field="TextLabel",                                 expression="FindLabel",                                 expression_type="VB",                                 code_block=calcExp) ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more