Latest Contributions by Tom_Laue

One option is to hard-code the desired field order into the script.     import arcpy import pandas as pd fc = r'https://services.arcgis.com/P3ePLMYs2RVChkJx/arcgis/rest/services/USA_States_Generalized_Boundaries/FeatureServer/0' fieldnames=[] fields = arcpy.ListFields(fc) # get list of field names from fc for field in fields: print(field.name) fieldnames.append(field.name) # convert FC to df data = [row for row in arcpy.da.SearchCursor(fc, fieldnames)] fc_dataframe = pd.DataFrame(data, columns=fieldnames) print(fc_dataframe) # remove specific fields ListOfFieldsToRemove = ['OBJECTID','Shape__Area','Shape__Length','Shape'] fc_dataframe.drop(ListOfFieldsToRemove , axis=1, inplace = True) print("printing dataframe...") print(fc_dataframe) # reorder fields df = fc_dataframe[['STATE_ABBR', 'STATE_FIPS', 'STATE_NAME', 'POPULATION', 'POP_SQMI', 'SQMI']] df_reordered = fc_dataframe[['STATE_ABBR', 'POP_SQMI', 'SQMI', 'STATE_FIPS', 'STATE_NAME','POPULATION']] print("printing dataframe (with fields re-ordered)...") print(df_reordered) # export to csv print("exporting to csv") df.to_csv(r'C:\Temp\CSV_export.csv', index=False)     Another option is to have a template .csv file and read the field order from that and then program your output to match the template. ... View more

This is what I use:   #note: this must be run in Python 3.x #This script will list all ArcGIS Online content, what it is, who owns it, the dates it was created & modified import arcgis, time import csv gis=GIS(url,username,password) print ("Organization Name: "+str(gis.properties.name)) print ("Portal Name: "+str(gis.properties.portalName)) #print ("URL: "+str(gis.properties.customBaseUrl)) print ("ArcGIS Online Credits Available: "+str("{:,}".format(gis.properties.availableCredits))) print("ELA Expiration Date: "+str(time.strftime('%m/%d/%Y %H:%M:%S', time.gmtime(gis.properties.subscriptionInfo.expDate/1000.0)))) print("Max Users per Level: ") for key,val in gis.properties.subscriptionInfo.maxUsersPerLevel.items(): print (key, "=", val) print ("\n") #set item_type if you only want to search for ex. "Feature Layer" search_result = gis.content.search(query="", item_type="",max_items=10000) #max number is set so it will return more than the default 10 results outCSVfile=r"L:\Scripts\ArcGISOnline\ArcGISOnline_ContentDetails.csv" csvfile = open(outCSVfile, 'w',newline='') writer = csv.writer(csvfile) writer.writerow(["Title","ItemType","Sharing","Description","Snippet","Tags","Categories","AccessInformation","Protected","Status","OwnedBy","DateCreated","DateLastModified","View Count","Item_ID"]) print("There are: "+str(len(search_result))+" total items in our ArcGIS Online.") recordNumber = 0 for i in search_result: recordNumber+=1 try: description = str(i.description.encode('unicode-escape').decode('utf-8')) #removes emojis except: description = str(i.description) #print(i.title+","+","+i.type+","+i.access+","+description+str(i.snippet)+","+str(i.tags)+","+str(i.categories)+","+str(i.accessInformation)+","+str(i.protected)+","+str(i.content_status)+i.owner+","+","+str(time.strftime('%m/%d/%Y %H:%M:%S', time.gmtime(i.created/1000.0))+","+str(time.strftime('%m/%d/%Y %H:%M:%S', time.gmtime(i.modified/1000.0))))+","+str(i.numViews)+","+(i.id)) #print (recordNumber) # so we know the script is doing something writer.writerow([i.title, i.type,i.access,description,str(i.snippet),str(i.tags),str(i.categories),str(i.accessInformation),str(i.protected),str(i.content_status),str(i.owner),str(time.strftime('%m/%d/%Y %H:%M:%S', time.gmtime(i.created/1000.0))),str(time.strftime('%m/%d/%Y %H:%M:%S', time.gmtime(i.modified/1000.0))),i.numViews,i.id]) csvfile.close() ... View more

This is what I've used to loop through a directory of MXDs to examine and/or edit them...     import os, arcpy # set a directory you're interested in workingDir = r'C:\Users\tlaue\Desktop\GISTutorial' arcpy.env.overwriteOutput = True # get a list of all the files in the directory maps = os.listdir(workingDir) for m in maps: if m[-4:] == ".mxd": mxd = arcpy.mapping.MapDocument(os.path.join(workingDir,m)) ## DO SOMETHING HERE ## mxd.save()     ... View more