in order to obtain a lot of photos with georreferenced position a query displays all the photos resulting from the query, but when you export any photo, the coded name (number) appears as name, and there are no information in the photo than can showme where or when was the photo taken. I can figure out the information by opening the patrol info (source patrol), where I find the information needed. Is there any way to extract the image information even as a CSV file related to the photo name?
Have you looked in the image metadata tags? If the original phone settings had geo-location tagging turned on for taking images, that geo-tag and the date/time etc should all be in the image metadata tags. On windows, right-click the image and select properties. Then see the “details” tab for image meta-data.
There was an idea of modifying the images upon export and adding text onto of the image itself of something like Date and Location properties, which is maybe more of what you want. But that was only an idea so far, it isn’t implemented in the software anywhere. Feel free to make a request for that sort of feature if that is what you need, either with your SMART partnership contact or through the asana website: SMART Master Project (Internal Form) - Form by Asana
1 Like
JSON files containing information about patrols have a well-known structure. In the Cusco region of Peru, we manage 5 Conservation Areas and the park rangers report their patrols by regularly sending the JSON files of their patrols (via the internet, usually WhatsApp). When receiving patrols from 5 different Conservation Areas, it is difficult to organize and systematize photos and other files, being approximately 100 patrols per week. I need to choose the best photos for the reports, therefore the need to have the georeference of some photo, it is complicated to choose between hundreds of photos and look for the patrol to which it belongs and establish its coordinates. For this reason, I have created a macro in Excel that, supported by a JsonConverter subroutine, searches for and extracts ALL the photos from a JSON file (or from many JSON files) sorting them by folders and including the Georeference in each photo. It will seem that the PC is slowing down but only while it is doing the extraction. I am attaching the Excel file in case it is useful to anyone else.
NOTE: The georeferencing places all locations with SOUTH latitude and WEST longitude, the macro can be modified to match the region of preference.
MacroExcel