Difference between revisions of "Location Table"
| (One intermediate revision by the same user not shown) | |||
| Line 25: | Line 25: | ||
==<code>FileID</code>== | ==<code>FileID</code>== | ||
The globally unique identifier of the file from whence this information came. | 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>== | ==<code>MediaID</code>== | ||
The identifier of the media from whence this data came. | 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>== | ==<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:26, 3 February 2024
This table holds geographic coordinates gleaned from loaded media.
Contents
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
);
The Altitude is the number of meters above ground.
Columns
ID
A globally unique identifier for this record.
FileID
The globally unique identifier of the file from whence this information came.
This corresponds to the [ID] column of the [File] table.
MediaID
The identifier of the media from whence this data came.
This corresponds to the [ID] column of the [Media] table.
Latitude
The latitude portion of the WGS84 coordinate.
Longitude
The longitude portion of the WGS84 coordinate.
Altitude
The altitude portion of the coordinate in meters.
LocationTypeID
The type of coordinate.
This links to the [ID] column of the [LocationType] table.
It should contains one of these values.
When
The date/time associated with this location.
Label
The name of the location.
