Importing Points of Interest from a CSV file or Excel spreadsheet
If you have existing tabular point of interest data, you can import this into the viewer using either a CVS file or an Excel spreadsheet. You will need to ensure that you have the columns in the expected order as detailed below.
POI file format
The POI import process accepts the following columns (must be in the order listed):
name |
description |
column required |
Can by empty/blank |
id |
internal database ID of POI. This is only valid when re-importing exiting POIs. Leave empty for new POIs |
Y |
Y |
label |
Label to show on the poi |
Y |
N |
x |
x coordinate in native point cloud coordinate system |
Y |
N |
y |
y coordinate in native point cloud coordinate system |
Y |
N |
z |
z coordinate in native point cloud coordinate system |
Y |
N |
notes |
notes/description field to attach to POI |
Y |
Y |
link |
hyperlink to open - must be in the form http://xxx.yyy |
Y |
Y |
image |
link to a photo/image to attach. Must be empty if creating a new POI |
Y |
Y |
tags |
A list of tags to attach to the POI. Separate with a pipe (|) symbol |
Y |
Y |
color |
An rgb hex color string specifying the POI colour. Format is #rrggbb |
Y |
Y |
lat |
coordinate WGS84 latitude. Not used for POI creation |
N |
N |
lon |
coordinate WGS84 longitude. Not used for POI creation |
N |
N |
h |
coordinate WGS84 elevation. Not used for POI creation |
N |
N |
Note that the first 10 fields must be present. The last 3 fields (lat, lon, h) are generally only used when POIs are exported - these values are not required for creating new POIs.
You must at least provide a value for label, x, y, z, and color - the other fields can be left blank.
Example POI file
The file (CSV or Excel format) should have the first row as a header, followed by the data as shown below
id,label,x,y,z,notes,link,image,tags,color,POI_1,254220.135,6129382.942,200.694,This is a description,http://www.pointerra.com,,Asset|Safety,#ff0000
,POI_2,254225.90,6129385.123,201.457,"A description, with a comma embedded",,,Inspection|Safety,#ff6622
,"A poi with commas, in the label",254211.623,6129387.834,205.148,,,,Safety,#0000ff
...
Note in the above example, if fields have embedded commas, you should enclose them in double quotes as shown. It would be good practice to quote all text fields to ensure that their content does not cause parsing errors.
Importing POIs
To import A POI, use the properties "cog" on the Points of Interest panel (activate the POI tool if the panel is not visible), and select Import from Excel or CSV
After the file has been processed, a summary of the results will be displayed.