Difference between revisions of "EXIF Table"
Jump to navigation
Jump to search
(Created page with "The <code>EXIF</code> table holds camera information gleaned from JPGs, TIFFs, MP2s and Type_MPEG4Video...") |
|||
| 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"> | ||
Revision as of 14:52, 25 May 2020
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.
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
);
