Latest Contributions by LanceCole

Per your question on how to run this on multiple file extensions, the simplest solution is just to call the locate function multiple times.  Such as: for ext in ('*.txt', '*.thn', '*.csv'): # This will run three times first returning all # the TXT files, then THN,and finally CSV files filelist = locate(ext, r'D:\path') for fp in filelist: # Do what you need to with this file # You can also use the variable 'ext' here to # process files differently base upon the 'ext' ... View more

Sorry, I left the "with" out of the statement when I cut and pasted.  I have corrected my previous post. ... View more

Mick, if you are referencing the filelist from Dave or my examples you iterate through the list using:   for fp in filelist: # fp is the full path and filename for each item in the filelist with open(fp,"r") as f: # do what you need here with the file data   ... View more

No fair David, you can type faster than I can. One other note.  Make sure you use a Python raw string for your path.  This will treat the backslash (\) as a literal character and not as an escape character.  David has included this in is example by using the lower case (r) in front of his path "myfolder" string. myfolder = r'D:\Downloads'   ... View more

Still thinking about this one and I still think it is a path or permissions issue.  Does this occur if you just open the mosaic and not the image service? Try the following: 1) Use the Identify tool, set the "Identify from:" to the imagery and click on the checkerboard. 2) In the dialog select the image, right click on the raster and select "View Raster" Does it display on the Preview tab? Go to the Functions Tab, right click on the image and select Properties... You may get an Error message.  Check the path and permissions for the error location. If you do not get an error review the properties data.  If you are able post the data.     ... View more

I would recommend putting a ticket in with ESRI. ... View more

Todd,  Typically when you see a checkerboard from a image service it is the system cannot resolve the path to the overview or imagery files.  The concerning part is you state this issue occurs periodically.  For clarification, does it occur on some systems or for some users and not others?  Does it occur sometimes on the same system with the same user? Since you recently changed your enterprise storage, did paths or permissions change as well?  I would check to: Make sure any path changes were fully updated.  Make sure a UNC path was utilized and not a mapped drive that could be different per user/system. Make sure the problem user/system has appropriate permissions to the enterprise storage share or shares using the UNC path. I would also make sure the image service is not timing-out You are referencing overview tiles which would be indicative of a mosaic dataset, which you also tagged. However, unless you are running an ArcGIS Image Server you cannot publish mosaic datasets as an image service.  ArcGIS Image Server is typically not part of an ArcGIS Enterprise single stack deployment.  Are you referencing cache tiles that are optionally stored as part of a image service?  If so, you may want to update the cache for the problem images.  Some systems may have a local cache of the tiles and be why they are working. ArcGIS Image Server is a licensing role of ArcGIS Server that extends the capability of serving raster data. Specifically, it allows you to serve a mosaic dataset or a raster layer containing a mosaic function. When you are serving an image service, there are two license scenarios: Without ArcGIS Image Server, you can still serve a raster dataset or raster dataset layer. With ArcGIS Image Server, you can serve a mosaic dataset or mosaic dataset layer. https://enterprise.arcgis.com/en/server/latest/publish-services/windows/key-concepts-for-image-services.htm If you are running a ArcGIS Image Server as part of your deployment with a mosaic dataset.  Have you checked the paths in the mosaic dataset to make sure any changes to your storage paths were updated?  You can use  Repair Mosaic Dataset Paths Tool in desktop or Repair Mosaic Dataset Paths (Data Management) in Pro to inspect and make changes to the paths.  Again, make sure you are using UNC paths. One last option and depending upon the size of the imagery, you may want to consider deleting the image service and republishing. ... View more

Vera,  Just a guess but I have seen similar before from the following: From the system you are having the issue with, open File Explorer to the external drive, right-click the mxd, gdb or folder containing the information and select Properties.  Look at the bottom of the dialog box under the General Tab to see if there is a security warning the files or folder is blocked because it is from another computer.  Just check the "Unblock" check-box and click Apply to clear.  See screen shot below.   ... View more

Since you are on SDE you have available a large range of SQL commands.   Try the following for the WHERE clause in your Select by Attribute.  This is not mine and is available from the blog Extracting numbers with SQL Server. The 50 in the statement is just to limit the length of the string being processed.  If your field is larger than 50 characters, set it to the max size of the field you are checking against or you can replace it with LEN(TESTNAME). However, the statement is cumbersome already.  Please replace "TESTNAME" in all four (4) locations with the field you are using.  The "BETWEEN 1 AND 4000" is from your example of "< 4000" and can be changed to what ever you need.  Setting it to "= 0" will return records without numbers.   (SELECT LEFT(SUBSTRING(TESTNAME, PATINDEX('%[0-9]%', TESTNAME), 50), PATINDEX('%[^0-9]%', SUBSTRING(TESTNAME, PATINDEX('%[0-9]%', TESTNAME), 50) + 'X') -1)) BETWEEN 1 AND 4000   One of the reasons it is so complex is is looks for a number anywhere in the string.  Also, It will only find the first number in a string.  "500-ADAM-600" will only be selected for 500 and not 600.  Tested on a MS_SQL SDE database using ArcGIS 10.8.1 Select by Attribute. ... View more

I had the feeling you did not want to add additional fields.  What version of ArcGIS are you using and what level of licensing?  What is the data source, i.e. shapefile, GDB, Enterprise DB, etc.?  Select by Attribute only has a limited subset of SQL functions but there are other tools that may work or there is the option to script a select.  Are these acceptable options? ... View more