Latest Contributions by JaredPilbeam2

Tried both options, and also tried '%Y%m%d'. Still throwing the PermissionError. Here's what I have: import arcpy, sys import exifread from exifread import exif import os import time from datetime import datetime im = "path\to\DOT_SignInventory" for root, dirnames, filenames in os.walk(im): #iterate directory for fname in filenames: if fname.endswith('.JPG'): with open(os.path.join(root, fname), 'rb') as image: #file path and name exif = exifread.process_file(image) dt = str(exif['EXIF DateTimeOriginal']) #get 'Date Taken' from JPG ds = time.strptime(dt, '%Y:%m:%d %H:%M:%S') nt = time.strftime("%Y-%m-%d",ds) newname = fname[0:7] + "_" + nt + ".jpg" os.rename(os.path.join(root,fname), newname)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Randy, I tried: newname = fname[0:7] + "_" + nt + ".jpg" os.rename(os.path.join(root,fname), os.path.join(root,newname))‍‍ Even within the with loop it's throwing a Permission Error: PermissionError: [WinError 32] The process cannot access the file because it is being used by another process: 'path\\to\\DOT_SignInventory\\CH01\\0100010.JPG' -> 'path\\to\\DOT_SignInventory\\CH01\\0100010_04/27/2018.jpg'‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Randy, Thanks, that helped. As it stands, it only reads the first JPG, which has the date 04/27/2018. It isn't printing the dates of the numerous other files?  im = r"path\to\DOT_SignInventory" for root, dirnames, filenames in os.walk(im): for fname in filenames: if fname.endswith('.JPG'): with open(os.path.join(root, fname), 'rb') as image: #file path and name exif = exifread.process_file(image) dt = str(exif['EXIF DateTimeOriginal'])#get JPG 'Date taken' st = '2018:04:27 09:30:59' date = time.strptime(st, '%Y:%m:%d %H:%M:%S') print(time.strftime("%m/%d/%Y",date))‍‍‍‍‍‍‍‍‍‍‍ 04/27/2018 04/27/2018 04/27/2018 04/27/2018 04/27/2018 04/27/2018‍‍‍‍‍‍ etc...‍‍‍‍‍‍‍ It seems the first part of the code involving exif (up to line 😎 works fine. If I put a print statement after line 8: print(dt)‍ it gives me: 2018:04:27 09:30:59 2018:04:27 09:36:30 2018:04:27 09:40:00 2018:04:27 09:41:03 2018:04:27 09:42:03 2018:04:27 09:47:00‍‍‍‍‍‍ etc...‍‍‍‍‍‍‍ ... View more

For what it's worth, it looks like I can convert the rasters to a FGDB.  arcpy.env.workspace = r'\pathTo\jpgs' #Convert Multiple Raster Dataset to FGDB arcpy.RasterToGeodatabase_conversion("0100030.jpg;0100040.jpg", r"\pathTo\Data.gdb")‍‍‍‍‍‍‍‍ Of course, this is just a sample. I'll have to set the script up to iterate through the directory and convert thousands of jpgs to the FGDB. But, after I do that I'm still stuck wondering how to get the raster into the Raster Field via Python.  ... View more

Any intent I did with code to load the raster resulted in an error. Since I could not find any documentation on doing this in Python I assume it is not supported. Xander, Is this supported in arcpy for ArcGIS Pro? I'm currently looking for a way to update raster fields in FC table with Python. I have a script that uses the updatecursor to populate a text field with a path to the directory where the rasters are stored. But, what I really need is to update the raster field with the image itself. And apparently you can't use cursors for this. I started a thread the other day:  https://community.esri.com/thread/231019-raster-fields-not-supported-using-cursors ... View more

Dan, Adding raster datasets as attributes is exactly what I need. But is there a way to automate this? I'm dealing with 1000s of rasters. I started out on this page and because there was no mention of Arcpy I moved on to looking into cursors. ... View more

So creating a separate table (using an insertcursor) for joining isn't a possibility? How to use an insertcursor on a Raster Field is pretty much my question. There's a Raster Field in a FC that I want populated with rasters. But, as I was reading how to access that type of field with a cursor it says it's not possible: ... View more

I couldn't get the os.walk portion of the code you provided to get to the jpgs. If I ran that portion of the script to test it (left out the cursor portion) it would iterate a folder in that same directory that had a jpg, but then stop there. It didn't find any other jpgs. So I changed those lines to this: ws = r'C:\path\to\jpegs\root' jpgs = {} # empty dictionary for dirName, subdirList, fileList in os.walk(ws): for fname in fileList: jpgs[fname[:-4]] = os.path.join(dirName,fname)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Anyway, thanks to all of your help this does what I want: import arcpy, os ws = r'C:\path\to\jpegs\root' jpgs = {} # empty dictionary for dirName, subdirList, fileList in os.walk(ws): for fname in fileList: jpgs[fname[:-4]] = os.path.join(dirName,fname) fc = r'pathto\Projects\DOT_SignInventory\Data.gdb\WCDOT_Signs' fields = ['OID@', 'Post_Number', 'Photo'] with arcpy.da.UpdateCursor(fc, fields) as cursor: for row in cursor: try: row[2] = jpgs[row[1]] cursor.updateRow(row) except KeyError: print("No photo for: {}".format(row[1])) del cursor‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Randy, Thanks for that. To answer your assumptions, yes, the 'Post_Number' field is text and the 'Photo' field length is 150--so, plenty long. If I try your code word for word it runs with no error, but in the 'Photo' field it doesn't give the path. Here's an example of what it puts there: Thumbs.db\0110030.jpg‍ Not sure why it does this? There's no 'Thumbs' file in the directory.  ... View more

Curtis, Thanks, that almost got me there. But, for the jpg_dir variable, however this string looks is how it's updated in the table. For example, if it's like this in the variable:  jpg_dir = r'P:\GIS_Highway_Dept\Applications\Sign Inventory\Photos\CH01'‍ then it's updated like this in the table: P:\GIS_Highway_Dept\Applications\Sign Inventory\Photos\CH01\2410765.jpg‍‍‍‍ The problem is 2410765.jpg is County Highway 24, as the first two digits in the ID is the highway number. So, that jpg isn't linked correctly, and neither will any be unless they begin with 01 (in the CH01 folder). Do I have to iterate the Photos directory first and create a list or library, as Randy pointed out? ... View more

Randy, That's correct. The first two digits of the 7 digit unique ID are based on the highway number and it's respective directory. For example: P:\GIS_Highway_Dept\Applications\Sign Inventory\Photos\CH01\0110930.jpg P:\GIS_Highway_Dept\Applications\Sign Inventory\Photos\CH19\1910930.jpg P:\GIS_Highway_Dept\Applications\Sign Inventory\Photos\CH84\8410930.jpg Etc...  A dictionary is something I have to get to know how to utilize better. So, thanks, that gives me something to chew on. ... View more