Difference between revisions of "EXIF Table"
| Line 32: | Line 32: | ||
==<code>FileID</code>== | ==<code>FileID</code>== | ||
The ID of the file from which this information came. | 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. | + | This corresponds to the <code>[ID]</code> column of the <code><nowiki>[</nowiki>[[File Table|File]]<nowiki>]</nowiki></code> table. |
==<code>MediaID</code>== | ==<code>MediaID</code>== | ||
The ID of the media this data comes from. | The ID of the media this data comes from. | ||
| − | This corresponds to the <code>ID</code> column of the <code>[Media]</code> table. | + | This corresponds to the <code>[ID]</code> column of the <code><nowiki>[</nowiki>[[Media Table|Media]]<nowiki>]</nowiki></code> table. |
==<code>HashID</code>== | ==<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. | + | 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>== | ==<code>Make</code>== | ||
| Line 51: | Line 52: | ||
==<code>Latitude</code>== | ==<code>Latitude</code>== | ||
| − | The latitude portion of the WGS84 coordinate. | + | The latitude portion of the [https://en.wikipedia.org/wiki/World_Geodetic_System#WGS84 WGS84] coordinate. |
==<code>Longitude</code>== | ==<code>Longitude</code>== | ||
| − | The longitude portion of the WGS84 coordinate. | + | The longitude portion of the [https://en.wikipedia.org/wiki/World_Geodetic_System#WGS84 WGS84] coordinate. |
==<code>Altitude</code>== | ==<code>Altitude</code>== | ||
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.
