Location Table

From truxwiki.com
Revision as of 06:34, 5 May 2023 by Sam (talk | contribs)
Jump to navigation Jump to search

This is where Truxton stores geographic coordinates.

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.