Difference between revisions of "EXIF Table"
Jump to navigation
Jump to search
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | The <code>EXIF</code> table holds camera information gleaned from [[Type_JPEGWithExif | JPGs,]] [[Type_TIFFWithExif | TIFFs,]] [[Type_MPEG2Video | MP2s]] and [[Type_MPEG4Video | MP4s.]] | + | The <code>[EXIF]</code> table holds camera information gleaned from [[Type_JPEGWithExif|JPGs,]] [[Type_TIFFWithExif|TIFFs,]] [[Type_MPEG2Video|MP2s]] and [[Type_MPEG4Video|MP4s.]] |
Originally, this information only came from [https://en.wikipedia.org/wiki/Exif Exchangeable image file format] data sections. | Originally, this information only came from [https://en.wikipedia.org/wiki/Exif Exchangeable image file format] data sections. | ||
As Truxton has progressed, camera information is exploited from other formats of meta data. | As Truxton has progressed, camera information is exploited from other formats of meta data. | ||
| − | < | + | =SQL= |
| − | CREATE TABLE "EXIF" ( | + | <source lang="SQL"> |
| − | + | CREATE TABLE "EXIF" | |
| − | + | ( | |
| − | + | "ID" uuid NOT NULL, | |
| − | + | "FileID" uuid NOT NULL, | |
| − | + | "MediaID" uuid NOT NULL, | |
| − | + | "HashID" uuid NOT NULL, | |
| − | + | "Make" text DEFAULT ''::text NOT NULL, | |
| − | + | "Model" text DEFAULT ''::text NOT NULL, | |
| − | + | "SerialNumber" text DEFAULT ''::text NOT NULL, | |
| − | + | "Latitude" double precision DEFAULT 0 NOT NULL, | |
| − | + | "Longitude" double precision DEFAULT 0 NOT NULL, | |
| − | + | "Altitude" double precision DEFAULT 0 NOT NULL, | |
| − | + | "Heading" double precision DEFAULT 0 NOT NULL, | |
| − | + | "FocalLength" double precision DEFAULT 0 NOT NULL, | |
| − | + | "ShutterCount" integer DEFAULT 0 NOT NULL, | |
| − | + | "GPSTime" timestamp without time zone NOT NULL, | |
| + | "CameraTime" timestamp without time zone NOT NULL, | ||
| + | "Offset" bigint DEFAULT (-1) NOT NULL | ||
); | ); | ||
| − | </ | + | </source> |
| + | |||
| + | =Columns= | ||
| + | ==<code>ID</code>== | ||
| + | The globally unique identifier for this record. | ||
| + | |||
| + | ==<code>FileID</code>== | ||
| + | The ID of the file from which this information came. | ||
| + | This corresponds to the <code>[ID]</code> column of the <code><nowiki>[</nowiki>[[File Table|File]]<nowiki>]</nowiki></code> table. | ||
| + | |||
| + | ==<code>MediaID</code>== | ||
| + | The ID of the media this data comes from. | ||
| + | This corresponds to the <code>[ID]</code> column of the <code><nowiki>[</nowiki>[[Media Table|Media]]<nowiki>]</nowiki></code> table. | ||
| + | |||
| + | ==<code>HashID</code>== | ||
| + | The hash of the contents of the file this EXIF data came from. | ||
| + | This corresponds to the <code>[ID]</code> column of the <code>[MD5Hash]</code> table. | ||
| + | |||
| + | ==<code>Make</code>== | ||
| + | The maker of the imager/camera. | ||
| + | |||
| + | ==<code>Model</code>== | ||
| + | The model of the imager/camera. | ||
| + | |||
| + | ==<code>SerialNumber</code>== | ||
| + | The serial number of the imager. | ||
| + | |||
| + | ==<code>Latitude</code>== | ||
| + | The latitude portion of the [https://en.wikipedia.org/wiki/World_Geodetic_System#WGS84 WGS84] coordinate. | ||
| + | |||
| + | ==<code>Longitude</code>== | ||
| + | The longitude portion of the [https://en.wikipedia.org/wiki/World_Geodetic_System#WGS84 WGS84] coordinate. | ||
| + | |||
| + | ==<code>Altitude</code>== | ||
| + | The altitude of the coordinate in meters. | ||
| + | |||
| + | ==<code>Heading</code>== | ||
| + | The compass heading. | ||
| + | |||
| + | ==<code>FocalLength</code>== | ||
| + | The 35mm focal length of the image. | ||
| + | |||
| + | ==<code>ShutterCount</code>== | ||
| + | The number of shutter releases on the camera. | ||
| + | |||
| + | ==<code>GPSTime</code>== | ||
| + | The timestamp from the GPS in the imaging device. | ||
| + | |||
| + | ==<code>CameraTime</code>== | ||
| + | The timestamp from the clock in the imager/camera. | ||
| + | |||
| + | ==<code>Offset</code>== | ||
| + | The byte offset into the file where the EXIF data block began. | ||
Latest revision as of 07:21, 3 February 2024
The [EXIF] table holds camera information gleaned from JPGs, TIFFs, MP2s and MP4s.
Originally, this information only came from Exchangeable image file format data sections.
As Truxton has progressed, camera information is exploited from other formats of meta data.
Contents
SQL
CREATE TABLE "EXIF"
(
"ID" uuid NOT NULL,
"FileID" uuid NOT NULL,
"MediaID" uuid NOT NULL,
"HashID" uuid NOT NULL,
"Make" text DEFAULT ''::text NOT NULL,
"Model" text DEFAULT ''::text NOT NULL,
"SerialNumber" text DEFAULT ''::text NOT NULL,
"Latitude" double precision DEFAULT 0 NOT NULL,
"Longitude" double precision DEFAULT 0 NOT NULL,
"Altitude" double precision DEFAULT 0 NOT NULL,
"Heading" double precision DEFAULT 0 NOT NULL,
"FocalLength" double precision DEFAULT 0 NOT NULL,
"ShutterCount" integer DEFAULT 0 NOT NULL,
"GPSTime" timestamp without time zone NOT NULL,
"CameraTime" timestamp without time zone NOT NULL,
"Offset" bigint DEFAULT (-1) NOT NULL
);
Columns
ID
The globally unique identifier for this record.
FileID
The ID of the file from which this information came.
This corresponds to the [ID] column of the [File] table.
MediaID
The ID of the media this data comes from.
This corresponds to the [ID] column of the [Media] table.
HashID
The hash of the contents of the file this EXIF data came from.
This corresponds to the [ID] column of the [MD5Hash] table.
Make
The maker of the imager/camera.
Model
The model of the imager/camera.
SerialNumber
The serial number of the imager.
Latitude
The latitude portion of the WGS84 coordinate.
Longitude
The longitude portion of the WGS84 coordinate.
Altitude
The altitude of the coordinate in meters.
Heading
The compass heading.
FocalLength
The 35mm focal length of the image.
ShutterCount
The number of shutter releases on the camera.
GPSTime
The timestamp from the GPS in the imaging device.
CameraTime
The timestamp from the clock in the imager/camera.
Offset
The byte offset into the file where the EXIF data block began.
