CODEWITHSUNDEEP
autodesk-forgeautodesk-model-derivative
WoWeh
WoWeh

Reputation: 106

Sqlite properties DB - any documentation about the data types and unit symbols in the _objects_attr table?

Good Day,

is there any documentation about the data types and unit symbols in the sqlite properties database (_objects_attr table)?

Having looked at different files, the data types seem to map as follows:

The units (data_type_context) seem to vary per source file format. Only floats have unit definitions.

For Revit, units are defined in a Revit specific way:

For other formats, SI and imperial unit symbols are used (mm, m, m^2, m^3, ft, ft^2, ft^3, radian, deg, ...)

Is this correct? Any documentation would help.

Many thanks

Wolfgang

Upvotes: 0

Views: 107

Answers (1)

WoWeh
WoWeh

Reputation: 106

The related questions show part of the answer and confirm the data types:

Didn't find it when I searched 🤔❓

¯\(ツ)/¯

Here are the type values from the C++ code that performs properties extraction:

enum AttributeType {

  /* Numeric types */
  Unknown                 = 0,
    Boolean,
    Integer,
    Double,

    /* Special types */
    BLOB                    = 10,
    DbKey, /* reprensets a link to another object in the database, using database internal ID */

    /* String types */
    String                  = 20,
    LocalizableString,
    DateTime,       /* ISO 8601 date */
    GeoLocation,    /* LatLonHeight - ISO6709 Annex H string, e.g: "+27.5916+086.5640+8850/" for Mount Everest */
    Position        /* "x y z w" space separated string representing vector with 2,3 or 4 elements*/
};

Upvotes: 0

Related Questions