EXIF Table - Revision history

Sam: /* Columns */

2024-02-03T11:21:10Z

Columns

Sam at 11:46, 26 January 2024

2024-01-26T11:46:47Z

Sam at 12:52, 8 December 2020

2020-12-08T12:52:25Z

Sam at 18:52, 25 May 2020

2020-05-25T18:52:22Z

Sam: Created page with "The `EXIF` table holds camera information gleaned from JPGs, TIFFs, MP2s and Type_MPEG4Video..."

2020-05-21T17:41:35Z

Created page with "The <code>EXIF</code> table holds camera information gleaned from JPGs, TIFFs, MP2s and Type_MPEG4Video..."

New page

The <code>EXIF</code> table holds camera information gleaned from [[Type_JPEGWithExif | JPGs,]] [[Type_TIFFWithExif | TIFFs,]] [[Type_MPEG2Video | MP2s]] and [[Type_MPEG4Video | MP4s.]]

<syntaxhighlight 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
);
</syntaxhighlight>

@@ Line 32: / Line 32: @@
 ==<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.
+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>[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>==
-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.
 ==<code>Make</code>==
@@ Line 51: / Line 52: @@
 ==<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>==
-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>==

@@ Line 3: / Line 3: @@
 As Truxton has progressed, camera information is exploited from other formats of meta data.
 <source lang="SQL">
 CREATE TABLE "EXIF"
@@ Line 24: / Line 25: @@
 );
 </source>

← Older revision		Revision as of 18:52, 25 May 2020
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.
		+	As Truxton has progressed, camera information is exploited from other formats of meta data.

	<syntaxhighlight lang="SQL">		<syntaxhighlight lang="SQL">