nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Create Time Field in Raster Mosaic

JonathanMulder

Greeting,

I have a Raster Mosaic in a geodatabase of daily groundwater surfaces. I've come across a web page that explains how to insert a time field in the Raster Mosaic in ArcMap. But, I'd really like to do the process automatically in Arcpy.

Does anyone know the Arcpy steps for doing this?

Thanks!

Jon Mulder
California Department of Water Resources

Vind meer berichten getagd met

Accepted answers

JamesCrandall

    #set the mosaic dataset   ws_mosaic = r'C:\MyFolder\MyGDB.gdb\MosaicDS'       # add the date field   arcpy.AddField_management (ws_mosaic, "_calcDate", "DATE")   print "Date field added"        # calcuate the date field   ras = str(ws_mosaic)   fld = "_calcDate"   cursor = arcpy.UpdateCursor(ras, '', '', '', 'Name')     # in this case, the actual date to start from was not important   startDate = datetime.datetime(1901,1,1)   step = datetime.timedelta(days=1)   d = startDate       # now populate the date field   for row in cursor:        retVal = datetime.datetime.strptime(str(d), '%Y-%m-%d %H:%M:%S')       row.setValue(fld, retVal)       cursor.updateRow(row)          d += step

All comments

JonathanMulder

Thanks very much for showing me how to do this!

I have a Raster Mosaic Dataset within a geodatabase of groundwater surfaces. They are named as follows:
GWSurface_20130701
GWSurface_20130702
...
GWSurface_20130731

So, I modified my code to add a field name (called "SurfaceDate") to my Raster Mosaic Dataset table, then looped through the table and updated the SurfaceDate field with the last 8 characters of the surface name. Works great!

Jon Mulder
California Department of Water Resources

##Create Raster Mosaic Dataset to contain Surfaces.
print "Creating Surfaces Raster Dataset."
FeatureDatasetName = "Surfaces"
arcpy.CreateMosaicDataset_management(OutDatasetPath,FeatureDatasetName,Spatial_Reference)
##Add an 8 character Text field to hold Date as YYYYMMDD.
RasterDatasetLocation = os.path.join(OutFolderPath,GeoDatabaseName,"Surfaces")
arcpy.AddField_management(RasterDatasetLocation, "SurfaceDate","Text","","",8)

DateStart = date(2013,7,1)
DateEnd = date(2013,7,31)
for dt in rrule(DAILY, dtstart=DateStart, until=DateEnd):

    ##Do lots of processing in this loop.

##Populate Raster Mosaic Table with Dates.
arcpy.env.workspace = os.path.join(OutFolderPath,GeoDatabaseName,"Surfaces")
ras = str(os.path.join(OutFolderPath,GeoDatabaseName,"Surfaces"))
flds = ["Name","SurfaceDate"]
cursor = arcpy.da.UpdateCursor(ras,flds)
for row in cursor:
    RasterName = row[0]
    DateString = RasterName[-8:]
    row[1] = DateString
    cursor.updateRow(row)
print "Contours Completed."

JamesCrandall

    #set the mosaic dataset   ws_mosaic = r'C:\MyFolder\MyGDB.gdb\MosaicDS'       # add the date field   arcpy.AddField_management (ws_mosaic, "_calcDate", "DATE")   print "Date field added"        # calcuate the date field   ras = str(ws_mosaic)   fld = "_calcDate"   cursor = arcpy.UpdateCursor(ras, '', '', '', 'Name')     # in this case, the actual date to start from was not important   startDate = datetime.datetime(1901,1,1)   step = datetime.timedelta(days=1)   d = startDate       # now populate the date field   for row in cursor:        retVal = datetime.datetime.strptime(str(d), '%Y-%m-%d %H:%M:%S')       row.setValue(fld, retVal)       cursor.updateRow(row)          d += step

JakeSkinner

Hi Jonathan,

Essentially all you will need to do is add a field to your mosaic dataset and calcualte the desired date. Is your mosaic dataset updated on a daily basis with new raster imagery? Can you describe was steps you would like to automate?

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.