Prototype 1 Crack Hot! 🆕 No Survey

: Users frequently report stuttering or "cracking" audio which can be fixed by lowering the audio sample rate to 24-bit, 48000Hz or less in sound settings.

CREATE TABLE CrackObservations ( id UUID PRIMARY KEY, project_id UUID NOT NULL, site_name VARCHAR(128) NOT NULL, inspector_id UUID NOT NULL, captured_at TIMESTAMP NOT NULL, gps_latitude DOUBLE PRECISION, gps_longitude DOUBLE PRECISION, image_url VARCHAR(512) NOT NULL, overlay_geojson JSONB, -- polygon of detection length_mm NUMERIC(8,2), width_mm NUMERIC(8,2), severity VARCHAR(10) CHECK (severity IN ('Low','Medium','High')), confidence NUMERIC(4,2), -- 0.00‑1.00 model_version VARCHAR(20) NOT NULL, notes TEXT, tags VARCHAR(256)[], -- array of strings extra_images VARCHAR(512)[], -- additional photo URLs synced BOOLEAN DEFAULT FALSE, created_at TIMESTAMP DEFAULT now(), updated_at TIMESTAMP DEFAULT now() ); prototype 1 crack

| Stakeholder | Value | |-------------|-------| | | Faster, more objective crack assessments; less reliance on paper notes. | | Quality Assurance / Engineering | Consistent data for trend analysis, predictive maintenance, and compliance reporting. | | Management | Quantifiable KPIs (crack count, severity distribution) that can be visualised in dashboards. | | Regulators | Exportable audit trail (photos + timestamps + algorithm confidence). | : Users frequently report stuttering or "cracking" audio