Opened 5 years ago

Last modified 12 hours ago

#2189 new enhancement

[raster] Ability to import EXIF data as part of raster2pgsql load

Reported by: robe Owned by: dustymugs
Priority: low Milestone: PostGIS Fund Me
Component: raster Version: trunk
Keywords: Cc:

Description

GDAL outputs this already as an xml file when I run something like gdal_translate. I think rasterlite reads exif data directly via its remote registration something or other. Well at least their cute little GUI suggested that.

So I'm hoping it wouldn't be too hard for PostGIS to do it too. So proposition is to have an extra switch in raster2pgsql that creates an extra column exif or something like that that is of type xml to hold this information. I think it has some useful infor for georeference rasters as well that is not necessarily converted to coordinate boundaries or spatial ref.

This is really useful especially for things like surveying since the longitude latitude and picture timestamp is encoded in the exif data. I use it currrently for synchronizing a picture with the survey data posted back when people come back from the field and dump their files in a folder. They don't always post the picture back since it takes too much bandwidth.

I'm also thinking it might be useful for building walk thrus where you can almost stitch together a space orientation of the pictures utilizing the laser measuring stick readings someone carries.

Change History (4)

comment:1 Changed 5 years ago by dustymugs

Summary: Ability to import EXIF data as part of raster2pgsql load[raster] Ability to import EXIF data as part of raster2pgsql load

Would it be better to have all metadata extracted instead of just EXIF? And just shove the metadata (probably as XML) into a column?

comment:2 Changed 5 years ago by robe

Yap that would be better.

comment:3 Changed 4 years ago by dustymugs

Milestone: PostGIS 2.1.0PostGIS Future

comment:4 Changed 12 hours ago by robe

Milestone: PostGIS FuturePostGIS Fund Me

Milestone renamed

Note: See TracTickets for help on using tickets.