The Metadata details information about your images. This information can be time consuming to generate therefore will be proteced the same ways the images are proteced.

This information is stored in the Metadata table and is stored along side the images in the Master repository. In the Master repository it is stored as a xml formated file one file per image. This is also is replicated in the Master backups. This enables redundancy. If the archive is demaged the Master can be regenerated from one of the backups and if the working Metadata table is demaged then this can be regenerated.

The Metadata table

This Metadata table is located in:

pi - csvdb

The table is structured in date order in a file structure of year/year-month-day.csv.

The year-month-day.csv contains one row per image metadata.

The Master Repositry Metadata

The Metadata files are stored in a parallel folder to the image folder called metadata. The xml file is named the same as the image file the Metadata is associated. The exetention xml is added to the Metadata file.

As the Metadata information is important the xml metadata files are fingerprinted and are part of the Archive validation process.

The Metadata Information

The contained metadata information is split into sections:

Database Information

SequenceID - This is used as a unique number within the file Metadata.

File Details

These details are related to the image file with the exception of the UUID,

  • Filename

  • OrginalName

  • FilePath

  • UUID

  • MediaType

  • SHA

  • CRC

  • FileSize

  • DateCreate

  • DateModified

  • DateAdded

General Description

This is used by you the user mainly in locating the image or images.

  • Description

  • Label

  • Title

  • Subject

  • Rating

  • RatingPercent

  • Tags

  • Keywords

  • Version

  • Origin

Origin Information

  • Comment

  • Author

  • CaptureDate

  • SubsetimeOriginal

  • Copyright

Image Information

These detail

  • Width

  • Height

  • ViewRotation

  • BitsPerSample

  • XResolution

  • YResolution

  • ResolutionUnit

  • Compression

Camera Information

  • Maker

  • Model

  • ExposureTime

  • Aperture

  • ISOSpeedRating

  • ExposureBias

  • ExposureProgram

  • SubjectDistance

  • FocalLength

  • FocalLengthIn35mm

  • Flash

  • MeteringMode

  • DigitalZoom


Advanced photo Information

  • LightSource

  • ColorSpace

  • WhiteBalance

  • SceneCaptureType

  • Contrast

  • Saturation

  • Sharpness

  • BrightnessValue

  • SubjectDistanceRange

  • MAXAperture

  • CompressedBitSPerPixel

  • FlashEnergy

  • EXIFVersion

  • Software

  • PhotometricInterpretation

  • GPSTimestamp

Location Information

  • Latitude

  • Longitude

  • Location

  • Scen

IPTC Information

  • SourceURL

  • Usagerights

  • CopyrightURL

  • Headline

  • Category

  • SourceInstructions

  • Creator

  • JobTitle

  • Address

  • City

  • State

  • PostalCode

  • Country

  • Phone

  • Email

  • Website