CSV columns

The CSV has one row per signed-off finding. A column that does not apply to a finding — a volume column on a point finding, for example — is empty. The same descriptions are in the glossary file that ? beside CSV downloads.

The finding

Column	Meaning
id	The finding’s number, as printed in the report — for example OBS-031
observation_id	The finding’s permanent identifier
kind	point, measurement or bookmark
title	The finding’s title
notes	The Engineering assessment
severity	The severity recorded by the engineer
status	open, monitoring, resolved or closed
category	The category
component	The Dam component / location
recommended_action	What the engineer recommends should happen next
target_date	The date for that action, if one was set
tags	The tags, separated by semicolons

Position and shape

Column	Unit	Meaning
x_m, y_m, z_m	m	The finding’s first point, in the project’s coordinates. z_m is the elevation
geometry	—	polygon or line, for a measurement
vertices	—	How many points the outline is made of
outline_check	—	Empty when the outline is sound. Otherwise why its shape is in doubt, which puts its area and perimeter in doubt with it
geometry_wkt	m	The outline as well-known text (POLYGON Z or LINESTRING Z), for GIS and CAD
has_viewpoint	—	yes or no: whether a view was saved with the finding

Lengths, areas, elevations, slopes

Column	Unit	Meaning
length_m, perimeter_m	m	Length of a line; perimeter of an outline
perimeter_2d_m	m	Perimeter seen from directly above
area_m2, area_2d_m2	m²	Area following the slope; area seen from directly above
elev_min_m, elev_max_m	m	Lowest and highest point
slope_min_deg, slope_max_deg	°	Flattest and steepest part inside the outline

Volume against a base surface

Column	Unit	Meaning
volume_cut_m3, volume_fill_m3, volume_net_m3	m³	Material above the base; space below it; cut minus fill
volume_base	—	Which base surface was chosen
volume_cell_size_m	m	How finely the surface was read. About 2 cm is the limit of the capture
volume_cells_no_surface	—	Grid squares that found no surface. That material is not in the volume

Missing concrete (3D defect)

Column	Unit	Meaning
defect_volume	—	Missing concrete, written as the report writes it
defect_confidence	—	good, fair, indicative or none. None means no number was printed
defect_volume_cm3	cm³	Missing concrete
defect_uncertainty_cm3	cm³	How far the missing figure could be out. It chose the quality word and rounded the figure
defect_extra, defect_extra_cm3	—, cm³	Material standing proud of the sound face
defect_max_depth_cm	cm	Deepest single spot in the damage
defect_area_cm2	cm²	The damaged area only, not the outline you drew
defect_reference_roughness_cm	cm	How bumpy the sound concrete round the damage is
defect_reference_normal_source	—	How the tool learned which way the surface faces: read from the model, or assumed upward. Assumed is weaker

Depth profile

Column	Unit	Meaning
profile_surface_length_m	m	Distance measured over the concrete between the two points
profile_max_proud_cm, profile_max_recess_cm	cm	Furthest in front of and behind the straight line. Never netted
profile_max_deviation_cm	cm	The larger of the two — the worst point on the line
profile_rms_deviation_cm	cm	How far the concrete sits from the line typically
profile_step_cm	cm	How far apart the readings were taken
profile_facet_cm	cm	The smallest thing the capture can tell apart along the line
profile_samples, profile_section_points	—	How many readings were taken; how many points make up the cross-section
profile_bridges, profile_bridged_cm	—, cm	Stretches the traces could not reach, and their total length. In none of the figures
profile_normal_spread_deg	°	How far the two points disagree about which way the surface faces. Above about 20° the slice fits neither end squarely
measured_at	—	When the figures were measured

Record and review

Column	Meaning
created_at, updated_at, created_by	When the finding was created and last changed, and by whom
reviewed_by, reviewed_at	The engineer who signed off this version, and when
content_revision	The version of the finding’s content in this row
reviewed_revision	The version the sign-off covers
second_reviewed_by, second_reviewed_at, second_reviewed_revision	The independent second review, if one was made

AI proposals

These columns have a value only on a finding that the AI proposed. Empty means a person found it.

Column	Meaning
detected_by, detector_version	Which detector proposed the finding, and which version
detector_confidence	How sure the detector was, 0 to 1. Not a confidence in the measurement
detector_run	Which import brought the finding in
source_photo	The photograph the outline was traced on
source_gsd_mm_px	How much concrete one pixel of that photograph covers, in mm
corroborating_views	How many photographs put the defect in this place
view_spread_m	How far apart those photographs put it, in m
outline_tolerance_mm	How much the outline was smoothed when it was imported, in mm