The International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences
Publications Copernicus
Download
Citation
Articles | Volume XLVIII-4-2024
https://doi.org/10.5194/isprs-archives-XLVIII-4-2024-125-2024
https://doi.org/10.5194/isprs-archives-XLVIII-4-2024-125-2024
21 Oct 2024
 | 21 Oct 2024

Research on the Method of Managing Personal Massive Photos Using Geodatabase

Tao Cheng, Xuchao Xing, Xinyan Zheng, and Yang Gao

Keywords: Photo, Geodatabase, Exif, Geographic Information

Abstract. In view of the limitations of the existing methods for personal massive photos management and browsing, a method of using geodatabase to manage and browse massive personal photos is proposed. Firstly, vector geodatabase is created and defined based on geographic information technology. Then, attribute information including the file name, photo date and time, photo point longitude, photo point latitude, location name, photo storage path and so on of each photo in the file system are extracted. Finally, based on the longitude and latitude of the photo point, the geospatial location data of each photo is generated, and written into the vector geodatabase together with the attribute information. Based on the storage path of photos in the file system, the links between the geospatial database and photos are established. Furtherly realize the attribute information and geographical space location management of massive photos, as well as the browsing and viewing of photos. Take personal photos as an example to introduce the data processing and verify the practicability of the method. The result shows that this method uses the idea of geodatabase to manage massive personal photos, which is conducive to reflect the geographical spatial distribution and density characteristics of the photos, and can use the time axis to connect the track of personal history, which is convenient for browsing and analyzing the experience.