Pointerra Support Center

Contact Us
  1. Support
  2. Managing Project Datasets
  3. 360/Panoramic Photos
  4. Uploading panoramic images with a CSV metadata file

Uploading panoramic images with a CSV metadata file

You can use a CSV file to provide the metadata for panoramic images (i.e. epirectangular jpegs, typically captured as part of a mobile scan).

We currently support three formatted metadata types:

Note that you may not have data for all columns (if you are converting from another format), but we still expect to find following columns. Just leave the field empty (but include it) if you don't have a value for it.

Ladybug via RiProcess Metadata fields

Timestamp, Filename, Origin Easting, Origin Northing, Origin Height, Direction East, Direction North, Direction Height, Up East, Up North, Up Height, Roll[deg], Pitch[deg], Yaw[deg], Omega[deg], Phi[deg], Kappa[deg]

A CSV file that has the following 17 columns (this should match what is output by RiProcess for ladybug camera systems). We currently only read the values from the following columns (but still require the others to be present with empty values) -

* Timestamp

* Filename - must match the name of the jpg image plus the file extension

* Origin Easting

* Origin Northing

* Origin Height

* Roll (degrees)

* Pitch (degrees)

* Yaw (degrees)

All other columns are ignored and can have dummy values if you are generating them yourself.

Leica Spheres via Leica Pegasus Metadata fields

Note: This is for the non-extended version that is exported from Leica Pegasus.

Filename; Time; X1; Y1; Z1; Omega [deg]; Phi [deg]; Kappa [deg]; M11; M21; M31; M12; M22; M32; M13; M23; M33

File structure Columns : Semicolon separated (char59), no headers, with exact order as the example above.

NavVis Panorama Image Poses file

This is normally called pano-poses.csv and is located in the panos folder in a NavVis project.

# pano poses v1.0: ID; filename; timestamp; pano_pos_x; pano_pos_y; pano_pos_z; pano_ori_w; pano_ori_x; pano_ori_y; pano_ori_z

This is a standard NavVIs format and the file structure is a semicolon separated. See this NavVis help file for further information on the contents.

Extra information

NOTE: If your coordinates are geographic (e.g. WGS84), then values should be in decimal degrees, and the photo center columns should be ordered as Longitude, Latitude, Height (replacing the Easting, Northing, Height columns)

NOTE: Yaw is assumed to be the rotation counter-clockwise from East (i.e. a Yaw of 0 indicates the direction of East, and 90 indicates North). This is the opposite of the more commonly used heading value, where heading is rotation clockwise from North (East = 90).

If you don't have valid information about the Roll, Pitch, and Yaw, put 0 values in these columns, and choose the "Hide heading indicator" option when creating the dataset to avoid showing an incorrect heading indication on the map view.