System File Type

png

Image

Overview

A Portable Network Graphics raster image.

Characteristics

Lossless, chunk-based format supporting indexed or truecolor pixels, alpha transparency, metadata, and color management.

Common Uses

Web graphics, screenshots, UI assets, diagrams, logos, and images requiring transparency or lossless reproduction.

Compatible Programs

Windows Photos
Adobe Photoshop
GIMP
IrfanView

Sources

png Available by Year Taken/Created

png — Live from Microsoft

Secure, read-only view focused directly on the png file-type folder.

Camera Fields

These 78 columns in [AUROS].[DZFILESYSFILES].[FILETYPE PNG] preserve camera, device, lens, source, software, capture, location, and format-specific metadata embedded in PNG files. Values are copied from the file; they are not inferred.

PNG metadata: PNG can carry EXIF in an eXIf chunk, XMP in an iTXt chunk, ICC information, and textual software/source fields. PNG alone does not prove an image is a screenshot. A NULL value means the source file did not contain a readable value for that field.

Device Identity

SQL column	What it records
`Camera - Make`	Manufacturer recorded for the capture device.
`Camera - Model`	Model recorded for the capture device.
`Camera - Unique Model`	Globally unique camera-model name, primarily used by DNG.
`Camera - Localized Model`	Localized display name for the camera model.
`Camera - Serial Number`	Camera or device serial number.
`Camera - Owner Name`	Owner name written by the camera.
`Camera - Body Serial Number`	Serial number of the camera body.
`Camera - Internal Serial Number`	Manufacturer-specific internal camera serial number.
`Camera - Sensor Serial Number`	Manufacturer-specific image-sensor serial number.
`Camera - ID`	Manufacturer-specific camera identifier.
`Camera - Type`	Manufacturer-specific camera or device type.
`Camera - Firmware Version`	Firmware version recorded by the device.
`Camera - Shutter Count`	Camera shutter or image-actuation count when recorded.
`Camera - Maker Note`	Manufacturer-specific EXIF MakerNote payload or its recorded presence.

Lens

SQL column	What it records
`Camera - Lens - Specification`	Minimum/maximum focal length and aperture specification.
`Camera - Lens - Make`	Lens manufacturer.
`Camera - Lens - Model`	Lens model.
`Camera - Lens - Serial Number`	Lens serial number.
`Camera - Lens - Type`	Manufacturer-specific lens type.
`Camera - Lens - ID`	Manufacturer-specific lens identifier.

Source

SQL column	What it records
`Camera - Source - File Source`	EXIF source type, such as digital still camera.
`Camera - Source - Scene Type`	Whether the image was directly photographed.
`Camera - Source - Sensing Method`	Type and arrangement of the image sensor.
`Camera - Source - Device Setting Description`	Device configuration recorded for the capture.
`Camera - Source - Digital Source Type`	XMP/IPTC classification of camera, scan, composite, or generated source.
`Camera - Source - Composite Image`	Whether the image is a composite of multiple captures.
`Camera - Source - Composite Source Image Count`	Number of source images in a composite.
`Camera - Source - Composite Source Exposure Times`	Exposure times of images used in a composite.

Software

SQL column	What it records
`Camera - Software - Name`	Software recorded as writing or processing the image.
`Camera - Software - Processing Software`	Processing software recorded in TIFF/EXIF metadata.
`Camera - Software - Host Computer`	Computer recorded as writing or processing the image.
`Camera - Software - Creator Tool`	XMP tool that created or last authored the image.
`Camera - Software - History Software Agent`	Software agents recorded in XMP edit history.

Capture

SQL column	What it records
`Camera - Capture - Date Time Original`	Original capture date and time.
`Camera - Capture - Offset Time Original`	Time-zone offset for the original capture time.
`Camera - Capture - Subsecond Time Original`	Subsecond component of the original capture time.
`Camera - Capture - Exposure Time`	Exposure duration.
`Camera - Capture - Shutter Speed`	APEX or calculated shutter speed.
`Camera - Capture - F Number`	Lens f-number used for the exposure.
`Camera - Capture - Aperture`	APEX or calculated aperture value.
`Camera - Capture - ISO`	ISO or photographic sensitivity.
`Camera - Capture - Sensitivity Type`	EXIF interpretation of recorded sensitivity values.
`Camera - Capture - Standard Output Sensitivity`	Standard output sensitivity reported by the device.
`Camera - Capture - Recommended Exposure Index`	Recommended exposure index reported by the device.
`Camera - Capture - Exposure Program`	Automatic or manual exposure program.
`Camera - Capture - Exposure Mode`	Automatic, manual, or bracketed exposure mode.
`Camera - Capture - Metering Mode`	Camera light-metering mode.
`Camera - Capture - Light Source`	Recorded light source or illumination type.
`Camera - Capture - Flash`	Flash status and mode.
`Camera - Capture - Focal Length`	Lens focal length used for the capture.
`Camera - Capture - Focal Length 35mm`	35mm-equivalent focal length.
`Camera - Capture - Digital Zoom Ratio`	Digital zoom ratio.
`Camera - Capture - Subject Distance`	Recorded subject distance.
`Camera - Capture - White Balance`	Automatic or manual white-balance mode.
`Camera - Capture - Scene Capture Type`	Standard, landscape, portrait, night, or another scene mode.
`Camera - Capture - Gain Control`	Camera gain adjustment.
`Camera - Capture - Contrast`	Camera contrast-processing setting.
`Camera - Capture - Saturation`	Camera saturation-processing setting.
`Camera - Capture - Sharpness`	Camera sharpness-processing setting.
`Camera - Capture - Subject Distance Range`	Macro, close, or distant subject range.
`Camera - Capture - Orientation`	Recorded sensor/image orientation.

GPS and Location

SQL column	What it records
`Camera - GPS - Latitude`	Capture latitude.
`Camera - GPS - Longitude`	Capture longitude.
`Camera - GPS - Altitude`	Capture altitude.
`Camera - GPS - Time Stamp`	GPS capture time.
`Camera - GPS - Date Stamp`	GPS capture date.

Color Profile

SQL column	What it records
`Camera - Color Profile - Class`	ICC profile class, such as input, display, or output device.
`Camera - Color Profile - Device Manufacturer`	Manufacturer identifier in the embedded ICC profile.
`Camera - Color Profile - Device Model`	Device-model identifier in the embedded ICC profile.
`Camera - Color Profile - Device Attributes`	ICC device attributes.
`Camera - Color Profile - Device Technology`	ICC device-technology classification.
`Camera - Color Profile - Description`	Human-readable embedded color-profile description.

PNG Text Metadata

SQL column	What it records
`Camera - PNG Text - Software`	Software value in a PNG text chunk.
`Camera - PNG Text - Source`	Source value in a PNG text chunk.
`Camera - PNG Text - Creation Time`	Creation-time value in a PNG text chunk.
`Camera - PNG Text - Author`	Author value in a PNG text chunk.
`Camera - PNG Text - Comment`	Comment value in a PNG text chunk.
`Camera - PNG Text - Description`	Description value in a PNG text chunk.

Location Fields

These 68 columns in [AUROS].[DZFILESYSFILES].[FILETYPE PNG] preserve location metadata embedded in PNG files. Values are copied from the file and are not inferred from its folder or filename.

PNG location metadata: PNG can retain EXIF GPS in an eXIf chunk, XMP/IPTC metadata in iTXt, and location-related text in tEXt, zTXt, or iTXt chunks. A NULL value means the source file did not contain a readable value for that field.

GPS

SQL column	What it records
`Location - GPS - Version ID`	Version of the EXIF GPS information block.
`Location - GPS - Latitude Reference`	North or south latitude reference.
`Location - GPS - Latitude`	Latitude recorded for the image.
`Location - GPS - Longitude Reference`	East or west longitude reference.
`Location - GPS - Longitude`	Longitude recorded for the image.
`Location - GPS - Altitude Reference`	Whether altitude is above or below the reference level.
`Location - GPS - Altitude`	Altitude recorded for the image.
`Location - GPS - Time Stamp`	UTC time reported by the GPS receiver.
`Location - GPS - Satellites`	GPS satellites used for the measurement.
`Location - GPS - Status`	Status of the GPS receiver measurement.
`Location - GPS - Measure Mode`	Two-dimensional or three-dimensional GPS measurement mode.
`Location - GPS - DOP`	GPS dilution of precision.
`Location - GPS - Speed Reference`	Unit used for GPS speed.
`Location - GPS - Speed`	Speed recorded by the GPS receiver.
`Location - GPS - Track Reference`	True or magnetic reference for movement direction.
`Location - GPS - Track`	Direction of movement recorded by GPS.
`Location - GPS - Image Direction Reference`	True or magnetic reference for camera direction.
`Location - GPS - Image Direction`	Direction in which the camera was pointing.
`Location - GPS - Map Datum`	Geodetic survey datum used for the coordinates.
`Location - GPS - Destination Latitude Reference`	North or south reference for destination latitude.
`Location - GPS - Destination Latitude`	Latitude of the recorded destination.
`Location - GPS - Destination Longitude Reference`	East or west reference for destination longitude.
`Location - GPS - Destination Longitude`	Longitude of the recorded destination.
`Location - GPS - Destination Bearing Reference`	True or magnetic reference for destination bearing.
`Location - GPS - Destination Bearing`	Bearing to the recorded destination.
`Location - GPS - Destination Distance Reference`	Unit used for destination distance.
`Location - GPS - Destination Distance`	Distance to the recorded destination.
`Location - GPS - Processing Method`	Method used to determine the GPS position.
`Location - GPS - Area Information`	Name or description of the GPS area.
`Location - GPS - Date Stamp`	UTC date reported by the GPS receiver.
`Location - GPS - Differential`	Whether differential GPS correction was applied.
`Location - GPS - Horizontal Positioning Error`	Estimated horizontal positioning error.

IPTC Legacy

SQL column	What it records
`Location - IPTC Legacy - Sublocation`	Legacy IPTC location or sublocation shown in the image.
`Location - IPTC Legacy - City`	Legacy IPTC city shown in the image.
`Location - IPTC Legacy - Province or State`	Legacy IPTC province or state shown in the image.
`Location - IPTC Legacy - Country Name`	Legacy IPTC country name shown in the image.
`Location - IPTC Legacy - Country Code`	Legacy IPTC ISO country code shown in the image.

Created

SQL column	What it records
`Location - Created - Structure`	Complete IPTC structured location describing where the image was created.
`Location - Created - City`	City of the location. This structure describes where the image was created.
`Location - Created - Country Code`	ISO country code of the location. This structure describes where the image was created.
`Location - Created - Country Name`	Country name of the location. This structure describes where the image was created.
`Location - Created - GPS Altitude`	Altitude of the location. This structure describes where the image was created.
`Location - Created - GPS Altitude Reference`	Reference indicating whether the altitude is above or below WGS84. This structure describes where the image was created.
`Location - Created - GPS Latitude`	Latitude of the location. This structure describes where the image was created.
`Location - Created - GPS Longitude`	Longitude of the location. This structure describes where the image was created.
`Location - Created - Identifier`	Identifier recorded for the location structure. This structure describes where the image was created.
`Location - Created - Location ID`	Globally unique identifier for the location. This structure describes where the image was created.
`Location - Created - Location Name`	Full human-readable name of the location. This structure describes where the image was created.
`Location - Created - Province or State`	Province or state of the location. This structure describes where the image was created.
`Location - Created - Sublocation`	Sublocation or named site within the location. This structure describes where the image was created.
`Location - Created - World Region`	World region containing the location. This structure describes where the image was created.

Shown

SQL column	What it records
`Location - Shown - Structure`	Complete IPTC structured location describing a place depicted in the image.
`Location - Shown - City`	City of the location. This structure describes a place depicted in the image.
`Location - Shown - Country Code`	ISO country code of the location. This structure describes a place depicted in the image.
`Location - Shown - Country Name`	Country name of the location. This structure describes a place depicted in the image.
`Location - Shown - GPS Altitude`	Altitude of the location. This structure describes a place depicted in the image.
`Location - Shown - GPS Altitude Reference`	Reference indicating whether the altitude is above or below WGS84. This structure describes a place depicted in the image.
`Location - Shown - GPS Latitude`	Latitude of the location. This structure describes a place depicted in the image.
`Location - Shown - GPS Longitude`	Longitude of the location. This structure describes a place depicted in the image.
`Location - Shown - Identifier`	Identifier recorded for the location structure. This structure describes a place depicted in the image.
`Location - Shown - Location ID`	Globally unique identifier for the location. This structure describes a place depicted in the image.
`Location - Shown - Location Name`	Full human-readable name of the location. This structure describes a place depicted in the image.
`Location - Shown - Province or State`	Province or state of the location. This structure describes a place depicted in the image.
`Location - Shown - Sublocation`	Sublocation or named site within the location. This structure describes a place depicted in the image.
`Location - Shown - World Region`	World region containing the location. This structure describes a place depicted in the image.

PNG Text

SQL column	What it records
`Location - PNG Text - tEXt`	Location-related uncompressed PNG text chunks.
`Location - PNG Text - zTXt`	Location-related compressed PNG text chunks.
`Location - PNG Text - iTXt`	Location-related international PNG text chunks, including XMP when present.

Time and Date Fields

These 58 columns in [AUROS].[DZFILESYSFILES].[FILETYPE PNG] preserve date, time, duration, time-code, and animation-timing values available in PNG files. Values are copied from the source file and are not inferred from its filename or folder.

PNG time and date metadata: PNG can store a tIME modification value, textual creation timestamps, EXIF/XMP/ICC metadata, and APNG per-frame timing. A NULL value means the source file did not contain a readable value for that field.

File

SQL column	What it records
`Time - File - Access Date`	Filesystem date and time when the file was last accessed.
`Time - File - Create Date`	Filesystem date and time when the file was created.
`Time - File - Inode Change Date`	Filesystem date and time when the file record or metadata last changed, when the filesystem exposes it.
`Time - File - Modify Date`	Filesystem date and time when the file content was last modified.

PNG

SQL column	What it records
`Time - PNG - Modify Date`	PNG tIME modification date and time.
`Time - PNG - Creation Time`	Creation time stored in a PNG text or metadata chunk.
`Time - PNG - Create Date`	Creation date and time stored in PNG metadata.
`Time - PNG - Modification Date`	Modification date and time stored in PNG metadata.
`Time - PNG - Time Stamp`	Timestamp stored in PNG metadata.

EXIF

SQL column	What it records
`Time - EXIF - Modify Date`	EXIF date and time when the image metadata or image was modified.
`Time - EXIF - Date Time Original`	EXIF date and time when the original image data was generated.
`Time - EXIF - Create Date`	EXIF date and time when the digital image data was created.
`Time - EXIF - Offset Time`	UTC offset associated with EXIF Modify Date.
`Time - EXIF - Offset Time Original`	UTC offset associated with EXIF Date Time Original.
`Time - EXIF - Offset Time Digitized`	UTC offset associated with EXIF Create Date.
`Time - EXIF - Sub Second Time`	Fractional seconds associated with EXIF Modify Date.
`Time - EXIF - Sub Second Time Original`	Fractional seconds associated with EXIF Date Time Original.
`Time - EXIF - Sub Second Time Digitized`	Fractional seconds associated with EXIF Create Date.
`Time - EXIF - GPS Date Stamp`	UTC calendar date reported by the GPS receiver.
`Time - EXIF - GPS Time Stamp`	UTC time of day reported by the GPS receiver.
`Time - EXIF - Preview Date Time`	Date and time stored for an embedded preview image.
`Time - EXIF - Thumbnail Date Time`	Date and time stored for an embedded thumbnail image.
`Time - EXIF - Time Zone Offset`	Legacy EXIF time-zone offset associated with image timestamps.
`Time - EXIF - Exposure Time`	Length of time the camera sensor was exposed.

XMP Core

SQL column	What it records
`Time - XMP Core - Create Date`	XMP date and time when the resource was created.
`Time - XMP Core - Modify Date`	XMP date and time when the resource was last modified.
`Time - XMP Core - Metadata Date`	XMP date and time when the metadata was last changed.

XMP EXIF

SQL column	What it records
`Time - XMP EXIF - Date Time Original`	XMP EXIF date and time when the original image was captured.
`Time - XMP EXIF - Date Time Digitized`	XMP EXIF date and time when the image was digitized.
`Time - XMP EXIF - GPS Date Time`	Combined UTC GPS date and time stored in XMP EXIF metadata.

XMP Photoshop

SQL column	What it records
`Time - XMP Photoshop - Date Created`	XMP Photoshop date and time when the intellectual content was created.

XMP Dublin Core

SQL column	What it records
`Time - XMP Dublin Core - Date`	Dublin Core date or dates associated with the resource.

XMP IPTC

SQL column	What it records
`Time - XMP IPTC - Time Created`	IPTC Core time associated with creation of the image content.
`Time - XMP IPTC - IPTC Last Edited`	Date and time when IPTC metadata was last edited.
`Time - XMP IPTC - Metadata Last Edited`	Date and time when the extended IPTC metadata was last edited.
`Time - XMP IPTC - Metadata Modification Date`	Date and time when the metadata record was modified.
`Time - XMP IPTC - Modification Date`	Modification date and time stored in IPTC Extension metadata.
`Time - XMP IPTC - Original Create Date Time`	Original creation date and time recorded in IPTC Extension metadata.
`Time - XMP IPTC - Publication Event Date`	Date or dates associated with a publication event.
`Time - XMP IPTC - Temporal Coverage From`	Beginning of the time period covered by the image.
`Time - XMP IPTC - Temporal Coverage To`	End of the time period covered by the image.

XMP History

SQL column	What it records
`Time - XMP History - History When`	Date and time of each recorded XMP history event.
`Time - XMP History - Versions Event When`	Date and time of a version event.
`Time - XMP History - Versions Modify Date`	Modification date and time recorded for a version.

XMP Lineage

SQL column	What it records
`Time - XMP Lineage - Derived From Last Modify Date`	Last modification date of the source from which this image was derived.
`Time - XMP Lineage - Ingredients Last Modify Date`	Last modification date of an ingredient used to create the image.
`Time - XMP Lineage - Managed From Last Modify Date`	Last modification date of the managed source resource.
`Time - XMP Lineage - Manifest Reference Last Modify Date`	Last modification date of a resource referenced by a manifest.
`Time - XMP Lineage - Rendition Of Last Modify Date`	Last modification date of the resource of which this is a rendition.

XMP Rights

SQL column	What it records
`Time - XMP Rights - License Start Date`	Beginning of the licensed-use period.
`Time - XMP Rights - License End Date`	End of the licensed-use period.
`Time - XMP Rights - License Transaction Date`	Date and time of the licensing transaction.

ICC

SQL column	What it records
`Time - ICC - Profile Date Time`	Date and time when the embedded ICC color profile was created.
`Time - ICC - Calibration Date Time`	Date and time of the calibration described by the embedded color profile.

APNG

SQL column	What it records
`Time - APNG - Delay Numerators`	Per-frame APNG delay numerators, stored as a JSON array.
`Time - APNG - Delay Denominators`	Per-frame APNG delay denominators, stored as a JSON array; zero means 100.
`Time - APNG - Frame Durations`	Calculated duration of each APNG frame in seconds, stored as a JSON array.
`Time - APNG - Total Duration`	Sum of all APNG frame durations in seconds.

System File Type – png