Latest Contributions by JoshuaBixby

‎11-17-2022

You were close with your original code, just a couple issues: with arcpy.da.SearchCursor(data, fieldName, sql_clause=(None,'ORDER BY IDA DESC')) as cursor: for i in range(5): print("IDA value: ", next(cursor)[0])

‎11-16-2022

You don't, you just re-license the already installed ArcGIS Server software to add the Image Server role to it.

‎11-11-2022

It seems to me you are in the market for ArcGIS Data Appliance | Documentation ArcGIS Data Appliance is a content solution with much of the same data that is available through ArcGIS Online services You could install ArcGIS Enterprise with portal, but that doesn't give you all of the data and services you describe wanting from ArcGIS Online.

‎11-01-2022

@KoryKramer, with standard SQL the following expression does not select NULL: FIRE_NAME <> 'ZWINGE' I just fired up Pro 3.0.2 and tested Select By Attributes on a feature class in a file geodatabase, and results were as expected, which is not to select NULL.

‎11-01-2022

@Jon-PaulMcCool, @RandyCasey is absolutely correct. The use of NULL introduces 3-value logic into SQL comparison operators. Since NULL cannot be equal or unequal to any other value, including NULL itself, one cannot select NULL records based on equality comparisons.

‎11-01-2022

Have you tested it outside of an enterprise geodatabase? Is the code your running and the changes to the data working on the same version of the data? If I have users modifying data in version X and they don't reconcile and post, I won't see them in version Y.

‎10-26-2022

The syntax is: Resistance(!feature!, !type!)

‎10-26-2022

"They," the licenses, are not cancelled. What is cancelled is the license file. Once a license file is cancelled, it won't work to authorize any additional licenses, but that is because the license file itself has been cancelled and not because the licenses have been deauthorized or obsoleted. Personally, I liked it better when they were called Provisioning files because that is exactly what they are, and changing the name to Licensing files leads to confusion, especially for people newer to Esri licensing in My Esri. If you are interested in actual license information, I suggest looking at the Authorizations or Authorizations Activity reports because those contain information on licenses.

‎10-26-2022

Can you elaborate on what you mean by "reinstating these license?" Cancelling a license file does not deauthorize already-deployed licenses, so the licenses are still active and valid if you look under Authorizations.

‎10-20-2022

Posting pictures of code isn't much better than giving someone a picture of money, i.e., you aren't going to get much of anything for it. See Posting code with Syntax Highlighting on GeoNet and Code Formatting... the basics++ . Also, elaborate a bit more on what specifically isn't working. If you are getting errors, share the specific error and tracebacks.

‎10-20-2022

To both improve your own troubleshooting and get better feedback from Community members, focus on creating and sharing a Minimal, Reproducible Example (MRE): How to create a Minimal, Reproducible Example - Help Center - Stack Overflow. Having an MRE is also most helpful when opening cases with Esri Support.

‎10-12-2022

Here is another approach besides using elif blocks: update(!pci2016!, !pci2017!, !pci2018!, !pci2019!, !pci2020!) # and code block def update(pci2016, pci2017, pci2018, pci2019, pci2020): for newValue in (pci2020, pci2019, pci2018, pci2017, pci2016): if newValue != 0: break return newValue

‎10-07-2022

If you are using ArcGIS Pro, I suggest you use literal strings or f-strings: expression = f"{str(Num)[4:7]} not between {dateStart} and {dateEnd}"

‎10-07-2022

When I try just building your expression I get an error before I even get to the arcpy tool: (The specific values I used don't matter for test building expression, just the data types matter, and I had to change !Num! to just Num for testing) >>> Num = 123456 >>> dateStart = 1 >>> dateEnd = 2 >>> expression = "str(Num)[4:7] not between '" + dateStart + "' and '" + dateEnd + "'" Traceback (most recent call last): File "<stdin>", line 1, in <module> TypeError: can only concatenate str (not "int") to str >>> Are you sure you are pasting your exact code?

‎10-07-2022

Python slicing is start to stop, not start through stop, so [5:8] returns only 3 characters and not 4 characters.

Online Status	Offline
Date Last Visited	Wednesday

My Ideas

Latest Contributions by JoshuaBixby

Re: How to extract top 5 records in search cursor, not in SQL server

Re: Installing ArcGIS Server multiple roles (GIS, Image) in a single machine for testing

Re: Host Arc Services On-Prem

Re: Attribute Query "Is not equal to" doesn't recognize Null

Re: Attribute Query "Is not equal to" doesn't recognize Null

Re: Forcing da.SearchCursor to retrieve new data?

Re: Field Calculation: trying to define a value with the information of 2 columns

Re: Cancelled license files are still in use

Re: Cancelled license files are still in use

Re: Using two workspaces in one script?

Re: Python Script in ArcGIS Pro runs correctly, but outside of Pro does not?

Re: Field Calculator - find latest PCI

Re: Port Old Python to python 3 expression help

Re: Port Old Python to python 3 expression help

Re: Port Old Python to python 3 expression help

Re: Regedit values to start up ArcGIS Pro as named...

Re: azure, arcgis enterprise 11.5 and poor browser...

Re: New ParameterArray container

Re: New ParameterArray container

Re: What is the fastest way to add a new machine t...

Esri Forestry Group (EFG)

Python Snippets