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; } } }

foto hernoemen naar datum waarop de foto is gemaakt (exif)

G_A_Venhorst

Op Arcgis online worden foto's gemaakt via de collector bij diverse objecten.

Men wil nu de mogelijkheid hebben om de foto's via ArcgisPro te hernoemen naar de datum(en tijd) waarop de foto's zijn gemaakt (info staat in Exif bij de foto)

Is dit via Python te doen?

Find more posts tagged with

Accepted answers

All comments

G_A_Venhorst

Hi,

Thanks for all comments and info.

It turned out that about 25% of the photos do not contain exif info.

Finally, I used the "Geosetter" program to modify file names in bulk.

CorMelse

Hi Gerard,

without addressing the issues with keeping the photos online, here is a tip for the best and versatile exif tool i know: ExifTool ExifTool by Phil Harvey

With his commandline (perl) tool you can really do anything with the exif information you want.

Hope this helps, Cor

RandyBurton

If there is date information in the parent record, it can be used to rename the photo. Is this what you were thinking? Perhaps you can attach a screen shot of a popup so I understand what you want to do. Also, can an individual feature have multiple photos over several years attached to it?

I have experimented with Collector and found that the current version allows you to rename attached photos: Work with attachments. This seems to work by downloading the photo to Collector, renaming the photo, and then uploading it to the same spot in the attachment file.

I found the Update Attachment page in the REST API reference. When used with the Query Attachments (Feature Service/Layer), it should be possible to develop a script to rename the photos. The workflow would be something like:

Log into your account and get a token
Verify that the feature is set up for attachments
Use query attachments to get a list of all the photos in the feature
Working through the list, download each photo, examine the exif data and extract the date
If a date is found, use it to rename the photo file and use update attachment to upload the renamed file to AGOL (the attachment name should pick up the new name)
If no date is found in the exif data, use data from the parent table if possible to date and rename the photo.

G_A_Venhorst

Hoi Randy,

Is it possible to use the exif data in the popup info screen of the object?

If the name of the photo is shown in the popup, followed by the year on which it was made, I would have been very helped.

Renaming would then be less important.

Unfortunately, there is no create date in the attachment table.

G_A_Venhorst

Hi Randy,

Thanks for all info.

The problem is that the data and the photos must remain online, the inspection continues.

The idea I have now is to edit the data via a replica and put it back online.

I thought about creating an extra field in the Foto_ATTACH table. (Date, txt field).

Then to be filled via field calculator from the exif info.

If that would work I would have been very helped, so this field could be used to rename the photo.

Then I could put the data back online.

RandyBurton

You can see most of (perhaps all of) the information in your attachment table Foto__ATTACH. I have yet to find a way to edit the attachment table.

To view the information, log into your AGOL account. At the top of the page select "Content". On the next page, under "Layers", select the layer that has your attachments.

This will take you to the REST Services Directory page for your layer. At the bottom of the page, click the link "Query Attachments". (This link is only available if the layer has attachments.)

The form will look like the following image. In the box "Definition Expression" enter "OBJECTID > 0". This will basically create a where clause: "where the OBJECTID of the parent table is greater than zero" and select all attachments. You can limit the attachment types to "image/jpeg" if there are other types of attachments you

do not need.

Query Attachments

You should get links for the selected images which you can click and save the target. It appears that all photos are renamed to "attachment##" when Collector attaches them to the parent table. I do not know if this field can be edited. You should see the information in the attachment table for each photo, but it will not be in a table format. ID is the number of each row in the table; and there is a global ID for the attachment. You can also see the parent's ObjectID and GlobalID.

The above process can be scripted in Python, although I have not done it yet. For additional information see this section in the REST API: Query Attachments (Feature Service/Layer).

If you are wanting to export all photos and rename them, it may be easier to click "Export Data" option on the feature's page that shows the layers. You can save it as a file geodatabase (zipped) and work with it in

desktop. This way you can work with the Foto_ATTACH table directly. I have used the following script to export and rename jpeg's from the related attachment table.

<SPAN class="keyword token">import</SPAN> arcpy<SPAN class="punctuation token">,</SPAN> os<SPAN class="punctuation token">,</SPAN> exifread

masterFC <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\path\to\file.gdb\parent'</SPAN>
masterFlds <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'GlobalID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'OBJECTID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Note'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"># can grab a short text field for use if needed</SPAN>
<SPAN class="comment token"># Use list comprehension to build a dictionary from a da SearchCursor&nbsp; </SPAN>
masterDict <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>r<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">(</SPAN>r<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">for</SPAN> r <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>masterFC<SPAN class="punctuation token">,</SPAN> masterFlds<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">}</SPAN>

<SPAN class="comment token"># print masterDict</SPAN>

relatedTbl <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\path\to\file.gdb\photo__ATTACH'</SPAN> <SPAN class="comment token"># note 2 underscores in table name</SPAN>
relatedFlds <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'REL_GLOBALID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ATTACHMENTID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'DATA'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'CONTENT_TYPE'</SPAN><SPAN class="punctuation token">]</SPAN>

fileLocation <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\path\to\attachments\folder'</SPAN>

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>relatedTbl<SPAN class="punctuation token">,</SPAN> relatedFlds<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> item <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> item<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="string token">'image/jpeg'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># process only images</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># item[0] is related GlobalID; take first item in masterDict tuple with that key</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f1 <SPAN class="operator token">=</SPAN> masterDict<SPAN class="punctuation token">[</SPAN>item<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"># this is the ObjectID of parent record</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f2 <SPAN class="operator token">=</SPAN> item<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"># this is the Attachment ID</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># make new filename </SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; filename <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ATT_{}_{}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>f1<SPAN class="punctuation token">,</SPAN> f2<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># print filename</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># we need to write to temporary file for exifread to work</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tempname <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>fileLocation<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'{}.jpg'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>filename<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f <SPAN class="operator token">=</SPAN> open<SPAN class="punctuation token">(</SPAN>tempname<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'wb'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN>item<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>tobytes<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f <SPAN class="operator token">=</SPAN> open<SPAN class="punctuation token">(</SPAN>tempname<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'rb'</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tags <SPAN class="operator token">=</SPAN> exifread<SPAN class="punctuation token">.</SPAN>process_file<SPAN class="punctuation token">(</SPAN>f<SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># has to be a file to process</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f<SPAN class="punctuation token">.</SPAN>close<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> tags<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Image DateTime'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">is</SPAN> <SPAN class="operator token">not</SPAN> None<SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># may need to also check length in case of error</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; theDate <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>tags<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Image DateTime'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">' '</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN><SPAN class="string token">':'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">''</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; newname <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>fileLocation<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"{}_{}.jpg"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>filename<SPAN class="punctuation token">,</SPAN> theDate<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"ObjectID: {} \tNotes: {}&nbsp; \tFile: {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>f1<SPAN class="punctuation token">,</SPAN> masterDict<SPAN class="punctuation token">[</SPAN>item<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> newname<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; os<SPAN class="punctuation token">.</SPAN>rename<SPAN class="punctuation token">(</SPAN>tempname<SPAN class="punctuation token">,</SPAN> newname<SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># should have unique name by using IDs from both parent and child table</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># keep the temporary name</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"ObjectID: {} \tNotes: {}&nbsp; \tFile: {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>f1<SPAN class="punctuation token">,</SPAN> masterDict<SPAN class="punctuation token">[</SPAN>item<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> tempname<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">del</SPAN>&nbsp; cursor
<SPAN class="keyword token">del</SPAN> item‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

For my test, the results were:

ObjectID: 263&nbsp;&nbsp; Notes: attachment test&nbsp;&nbsp; File: C:\attachments\ATT_263_1_20170910.jpg
ObjectID: 263&nbsp;&nbsp; Notes: attachment test&nbsp;&nbsp; File: C:\attachments\ATT_263_2_20170910.jpg
ObjectID: 264&nbsp;&nbsp; Notes: attach test&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; File: C:\attachments\ATT_264_3_20170627.jpg
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Please note that I have not worked with missing exif information so I don't know how exifread will respond. It should be possible to include a few lines of code to use the attachment's ID to change the filename in the attachment table.

G_A_Venhorst

Hi,

Yes the photo are online in AGOL.

We do not have a server.

RandyBurton

You might try the exifread module at https://pypi.org/project/ExifRead/. Sample code would be like:

<SPAN class="keyword token">import</SPAN> os<SPAN class="punctuation token">,</SPAN> glob

<SPAN class="keyword token">import</SPAN> exifread
<SPAN class="comment token"><SPAN># info on exifread at </SPAN><A class="jive-link-external-small" href="https://community.esri.com/external-link.jspa?url=https%3A%2F%2Fpypi.org%2Fproject%2FExifRead%2F" target="_blank">https://pypi.org/project/ExifRead/</A></SPAN>

path <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\Path\to\photo\folder'</SPAN>

<SPAN class="keyword token">for</SPAN> filename <SPAN class="keyword token">in</SPAN> glob<SPAN class="punctuation token">.</SPAN>glob<SPAN class="punctuation token">(</SPAN>os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>path<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'*.jpg'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> filename
&nbsp;&nbsp;&nbsp; f <SPAN class="operator token">=</SPAN> open<SPAN class="punctuation token">(</SPAN>filename<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'rb'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># open read only, binary</SPAN>
&nbsp;&nbsp;&nbsp; tags <SPAN class="operator token">=</SPAN> exifread<SPAN class="punctuation token">.</SPAN>process_file<SPAN class="punctuation token">(</SPAN>f<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; f<SPAN class="punctuation token">.</SPAN>close<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> tags<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Image DateTime'</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; newname <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>path<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'{}.jpg'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>str<SPAN class="punctuation token">(</SPAN>tags<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Image DateTime'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN><SPAN class="string token">':'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'-'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN><SPAN class="string token">' '</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'_'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; os<SPAN class="punctuation token">.</SPAN>rename<SPAN class="punctuation token">(</SPAN>filename<SPAN class="punctuation token">,</SPAN> newname<SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># assumes that all date/times are different, otherwise an error will occur‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

You would need to add some code to deal with errors such as missing exif tags and possible duplicate dates. You may also want to adjust the date/time format in your file name, perhaps appending it to the original filename.

Another option to read exif is with the pillow module; information at https://github.com/python-pillow/Pillow.

You may also want to look at two arcpy tools at An overview of the Photos toolset. These tools can assist in matching photos to points or place them on a map using exif data.

I will try to answer your questions about working with photos that are still online. Are you using your own server portal or are you using AGOL?

G_A_Venhorst

Ongeveer 80% van de foto's hebben hun exif data nog beschikbaar.

Kan je de Foto_ATTACH tabel ook bekijken als de data nog online staat?

Of kan je ook een batch edit doen op een selectie objecten waarvan je de foto's wil aanpassen.

Er zijn meer dan 300 objecten, de meesten hebben 6 of meer foto's. Het is een inspectie over meer dan 3 jaar.

Bij elke incpectieronde moeten er nieuwe foto's worden gemaakt.

Echter is er nu niet meer te zien wanneer deze foto's zijn gemaakt.

De database is te groot om eerst locaal te zetten, dan aanpassen en vervolgens weer online te zetten vermoed ik.

Approximately 80% of the photos still have their exif data available.

Can you also view the Foto_ATTACH table if the data is still online?

Or you can also do a batch edit on a selection of objects for which you want to adjust the photos.

There are more than 300 objects, most of them have 6 or more photos. It is an inspection over more than 3 years.

New photographs have to be taken at each round of incidence.

However, it is now no longer possible to see when these photos were taken.

The database is too large to first set up locally, then modify and then put online again I suspect.

RandyBurton

I have read some comments about the removal of exif data by Collector, but that was a while ago. Can you check whether the exif data is intact when you work with the photo in Pro? If that is the case, there must be a way to rename the file using python and exif data.

Via google:

Ik heb wat opmerkingen gelezen over het verwijderen van exif-gegevens door Collector, maar dat was een tijdje geleden. Kun je controleren of de exif-gegevens intact zijn als je met de foto in Pro werkt? Als dat het geval is, moet er een manier zijn om het bestand te hernoemen met behulp van python- en exif-gegevens.

RandyBurton

Approximate translation via google:

rename the photo to the date the photo was taken (exif)

On Arcgis online photos are taken via the collector at various objects. They now want to be able to rename the photos via ArcgisPro to the date (and time) on which the photos were taken (info is in Exif on the photo) Is this possible via Python?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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