Location Table

This table holds geographic coordinates gleaned from loaded media.

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.