Location Table
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.