Latest Contributions by RandyBurton

I think this also works for python3, put the "f" before the triple quotes ( not inside 😞 ts = '2020-03-04 12:21:00' query = f"""SELECT idProject, idController, siteAddress, siteApn,projectName, projectType,dateCreated, datePermitIssued, permitNumber,applicationApprovedBy FROM master_db.saltlakecountybuildingpermits where datePermitIssued > '{ts}' and siteAddress is not null;""" print(query)‍‍‍‍‍‍‍‍‍‍ ... View more

Are the values in "Field1" and "Field2" unique identifiers and can only appear once in each feature?  If so, you could read the value of fc2's Field2 into a list/dictionary.  Then use an update cursor to mark the Copy field if Field1 is not in the Field2 list. ... View more

Perhaps this ZIP Code to ZCTA Crosswalk may be of help. And this page explains a bit about zip codes vs ZCTA. ... View more

Regarding your question about using the GlobalID, the documentation says: The attributes property of the feature should include the object ID (and the global ID, if available) of the feature along with the other attributes. I have used just the OBJECTID field without the global ID (it is a bit to complex to type easily) to update features on AGOL. If you want to use the FACILITYID, one way would be to use it to query the feature to obtain the OBJECTID and/or GlobalID.  Then use the OBJECTID to make the update. ... View more

I have used the  Update Definition (Feature Layer) of the REST API to modify domains (see example 6).  I think adding to the domain list works best, as deleting a domain value may leave some invalid values in the field.  Instead of deleting a domain, I would recommend changing the name/description to indicate it is out of date.  If the field needing the domain update is used for symbology, you will also need to edit and update the "types" section of the JSON file. I have not used the ArcGIS API for Python for this purpose.  For this, I would explore the  update_definition section of the API documentation. ... View more

Did you try something like indicating that total_rows was a global in the "execute" function (line 3) below: def execute(self, parameters, messages): """The source code of the tool.""" global total_rows # indicate that total_rows is a global inputdataset = parameters[0].valueAsText #getting the parameters count_rows = arcpy.GetCount_management(inputdataset) total_rows = int(count_rows.getOutput(0)) expression = ''' def getCitation(p_dataset_id): global total_rows if(total_rows == 5): ds=PanDataSet(p_dataset_id) return ds.citation '''‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ I'm also puzzled by the indentation in the code snippet you posted.  Is the "expression" section (lines 9 -17) part of the "execute" function?  It may not be indented properly. ... View more

Using globals in a Python toolbox or script tool is a bit tricky.  The toolbox/script creates a number of instances during function calls.  It is best to declare a global in getParameterInfo as this function appears to be called only once.  An example of a toolbox script that uses "junk" as a global variable is: import arcpy class Toolbox(object): def __init__(self): self.label = "Toolbox" self.alias = "" self.tools = [Tool] class Tool(object): def __init__(self): self.label = "Tool" self.description = "" self.canRunInBackground = False def getParameterInfo(self): global junk junk = None param0 = arcpy.Parameter( displayName="Something", name="something", datatype="GPString", parameterType="Required", direction="Input" ) params = [param0] return params def isLicensed(self): return True def updateParameters(self, parameters): global junk junk = "XYZ" return def updateMessages(self, parameters): return def execute(self, parameters, messages): global junk arcpy.AddMessage("The value junk is: " + junk) return‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ For more discussion see the following: Using Global Variables in Python Toolbox? Python toolbox tool objects do not remember instance variables between function calls? ... View more

Since you are interested in file creation/modification dates,  I was experimenting with the following: from datetime import datetime import dateutil.tz as tz # to convert utc to local time import dateutil.parser as parser # will parse a variety of datetime formats import requests import os.path import xml.etree.ElementTree as ET # for parsing xml file import zipfile # to open zip file (excel uses this format) directory = r'C:\Path\To\Save\Directory' # directory for saved file file = 'Grid_Support_Inverter_List_Full_Data.xlsm' # name of saved file # file to download url = "https://www.gosolarcalifornia.ca.gov/equipment/documents/Grid_Support_Inverter_List_Full_Data.xlsm" content = requests.get(url) # print content.headers # for debugging # get Last-Modified date from header and print as a local time webModDate = parser.parse(content.headers['Last-Modified']).astimezone(tz.tzlocal()) print "Web Last-Modified: {}".format(webModDate.strftime('%Y-%m-%d %H:%M:%S')) # save downloaded excel file to local drive with open(os.path.join(directory, file), 'wb') as f: f.write(content.content) f.close() # excel file format is a type of zip file # read an xml file inside the excel file to get file modified date # and convert to local date timetime zip = zipfile.ZipFile(os.path.join(directory, file)) props = zip.open('docProps/core.xml') # core document properties xmlText = props.read() zip.close() # print xmlText # for debugging ns = { 'cp' : 'http://schemas.openxmlformats.org/package/2006/metadata/core-properties', 'dc' : 'http://purl.org/dc/elements/1.1/', 'dcterms' : 'http://purl.org/dc/terms/' } tree = ET.fromstring(xmlText) creator = tree.find('dc:creator', ns).text lastModBy = tree.find('cp:lastModifiedBy', ns).text created = tree.find('dcterms:created', ns).text modified = tree.find('dcterms:modified', ns).text # print creator, lastModBy, created, modified # for debugging # convert excel modified date to local datetime xlModDate = parser.parse(modified).astimezone(tz.tzlocal()) print "Excel file modified: {}".format(xlModDate.strftime('%Y-%m-%d %H:%M:%S')) # get the saved file's create and modified date from operating system # datetime will be timestamp in local time, when file was saved # (basically the time when this script was run) osCreateDate = datetime.fromtimestamp(os.path.getctime(os.path.join(directory, file))) print "OS file created: {}".format(osCreateDate.strftime('%Y-%m-%d %H:%M:%S')) osModDate = datetime.fromtimestamp(os.path.getmtime(os.path.join(directory, file))) print "OS file modified: {}".format(osModDate.strftime('%Y-%m-%d %H:%M:%S'))‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ The results: Web Last-Modified: 2020-01-02 10:48:55 Excel file modified: 2020-01-02 09:32:50 OS file created: 2020-01-03 18:12:12 OS file modified: 2020-01-03 18:12:12‍‍‍‍ From this, you can see that the Excel file was modified a bit over an hour before it was put on the web server.  The modified date/time came directly from xml inside the Excel file. The operating system gave the file the same create and modified date indicating when the file was downloaded and saved to the local system (and not the actual time the Excel file was last modified). You should be able to use requests.head(url) to retrieve just the header to examine the modified date and then determine if you want to actually download the file. ... View more