bvh2sql.md

warning	DO NOT CHANGE THIS MANUALLY, THIS IS GENERATED BY https://github/duckdb/community-extensions repository, check README there
title	bvh2sql
excerpt	DuckDB Community Extensions BVH (BioVision Hierarchy) motion capture file parser for DuckDB
extension	name description version language build license maintainers bvh2sql BVH (BioVision Hierarchy) motion capture file parser for DuckDB 1.0.0 C++ cmake MIT nkwork9999
repo	github ref nkwork9999/bvh2sql 774970f749ccab7a6e37271363882549e6d0e2f3
docs	hello_world extended_description -- Load the extension LOAD bvh2sql; -- Read BVH file and get absolute joint positions SELECT frame_id, time, joint_name, world_x, world_y, world_z FROM bvh_absolute_positions('motion.bvh') WHERE joint_name = 'Hips' LIMIT 10; -- Analyze joint movement over time SELECT joint_name, AVG(world_y) as avg_height, MAX(world_y) - MIN(world_y) as height_range FROM bvh_absolute_positions('motion.bvh') GROUP BY joint_name ORDER BY avg_height DESC; The BVH2SQL extension allows you to read BioVision Hierarchy (BVH) motion capture files directly into DuckDB for analysis and processing. **Features:** - Parse BVH hierarchy structure with joint offsets - Calculate absolute world positions for all joints using matrix transformations - Support for position channels (Xposition, Yposition, Zposition) - Support for rotation channels (Xrotation, Yrotation, Zrotation) - Efficient frame-by-frame processing - Returns data as a standard SQL table with columns: frame_id, time, joint_name, world_x, world_y, world_z, rot_x, rot_y, rot_z **Use Cases:** - Motion capture data analysis - Animation retargeting preparation - Character movement statistics - Biomechanics research - Game development data pipeline
extension_star_count	0
extension_star_count_pretty	0
extension_download_count	704
extension_download_count_pretty	704
image	/images/community_extensions/social_preview/preview_community_extension_bvh2sql.png
layout	community_extension_doc

Installing and Loading

INSTALL {{ page.extension.name }} FROM community;
LOAD {{ page.extension.name }};

{% if page.docs.hello_world %}

Example

{{ page.docs.hello_world }}```
{% endif %}

{% if page.docs.extended_description %}
### About {{ page.extension.name }}
{{ page.docs.extended_description }}
{% endif %}

### Added Functions

<div class="extension_functions_table"></div>

|     function_name      | function_type | description | comment | examples |
|------------------------|---------------|-------------|---------|----------|
| bvh_absolute_positions | table         | NULL        | NULL    |          |

### Overloaded Functions

<div class="extension_functions_table"></div>

This extension does not add any function overloads.

### Added Types

<div class="extension_types_table"></div>

This extension does not add any types.

### Added Settings

<div class="extension_settings_table"></div>

This extension does not add any settings.