Location Table - Revision history

Sam: /* Columns */

2024-02-03T11:26:47Z

Columns

Sam at 10:05, 29 January 2024

2024-01-29T10:05:39Z

Sam: /* LocationTypeID */

2024-01-29T10:05:11Z

LocationTypeID

Sam at 09:29, 27 January 2024

2024-01-27T09:29:50Z

Sam at 10:34, 5 May 2023

2023-05-05T10:34:24Z

Sam at 12:53, 8 December 2020

2020-12-08T12:53:38Z

Sam: Created page with "This is where Truxton stores geographic coordinates. CREATE TABLE "Location" ( "ID" uuid NOT NULL, "FileID" uuid NOT NULL, "MediaID"..."

2020-05-21T18:48:26Z

Created page with "This is where Truxton stores geographic coordinates. <syntaxhighlight lang="SQL"> CREATE TABLE "Location" ( "ID" uuid NOT NULL, "FileID" uuid NOT NULL, "MediaID"..."

New page

This is where Truxton stores geographic coordinates.

<syntaxhighlight lang="SQL">
CREATE TABLE "Location" (
"ID" uuid NOT NULL,
"FileID" uuid NOT NULL,
"MediaID" uuid NOT NULL,
"Latitude" double precision DEFAULT 0 NOT NULL,
"Longitude" double precision DEFAULT 0 NOT NULL,
"Altitude" double precision DEFAULT 0 NOT NULL,
"LocationTypeID" smallint DEFAULT 0 NOT NULL,
"When" timestamp without time zone NOT NULL,
"Label" text DEFAULT ''::text NOT NULL
);
</syntaxhighlight>

@@ Line 29: / Line 29: @@
 ==<code>MediaID</code>==
 The identifier of the media from whence this data came.
-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>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 25: / Line 25: @@
 ==<code>FileID</code>==
 The globally unique identifier of the file from whence 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 identifier of the media from whence this data came.
-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>[Media]</code> table.
 ==<code>Latitude</code>==

@@ Line 41: / Line 41: @@
 ==<code>LocationTypeID</code>==
-The type of coordinate. This links to the <code>ID</code> column of the <code>[LocationType]</code> table.
+The type of coordinate.
 ==<code>When</code>==

@@ Line 1: / Line 1: @@
-This is where Truxton stores geographic coordinates.
+This table holds geographic coordinates gleaned from loaded media.
 <source lang="SQL">
 CREATE TABLE "Location"
@@ Line 17: / Line 18: @@
 The <code>Altitude</code> is the number of meters above ground.

← Older revision		Revision as of 10:34, 5 May 2023
Line 15:		Line 15:
	);		);
	</source>		</source>
		+
		+	The <code>Altitude</code> is the number of meters above ground.

@@ Line 1: / Line 1: @@
 This is where Truxton stores geographic coordinates.
-<syntaxhighlight lang="SQL">
+<source lang="SQL">
-CREATE TABLE "Location" (
+CREATE TABLE "Location"
-    "ID" uuid NOT NULL,
-    "FileID" uuid NOT NULL,
+  "ID" uuid NOT NULL,
-    "MediaID" uuid NOT NULL,
+  "FileID" uuid NOT NULL,
-    "Latitude" double precision DEFAULT 0 NOT NULL,
+  "MediaID" uuid NOT NULL,
-    "Longitude" double precision DEFAULT 0 NOT NULL,
+  "Latitude" double precision DEFAULT 0 NOT NULL,
-    "Altitude" double precision DEFAULT 0 NOT NULL,
+  "Longitude" double precision DEFAULT 0 NOT NULL,
-    "LocationTypeID" smallint DEFAULT 0 NOT NULL,
+  "Altitude" double precision DEFAULT 0 NOT NULL,
-    "When" timestamp without time zone NOT NULL,
+  "LocationTypeID" smallint DEFAULT 0 NOT NULL,
-    "Label" text DEFAULT ''::text NOT NULL
+  "When" timestamp without time zone NOT NULL,
 );
-</syntaxhighlight>
+</source>