Difference between revisions of "Location Table"
Jump to navigation
Jump to search
| Line 15: | Line 15: | ||
); | ); | ||
</source> | </source> | ||
| + | |||
| + | The <code>Altitude</code> is the number of meters above ground. | ||
Revision as of 06:34, 5 May 2023
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.
