# Analysis of propertySets in bSDD

**URL:** <https://forums.buildingsmart.org/t/analysis-of-propertysets-in-bsdd/4671>\
**Category:** bSDD\
**Tags:** bsdd, psets\
**Created:** [March 23, 2023, 9:28am UTC](https://forums.buildingsmart.org/t/analysis-of-propertysets-in-bsdd/4671 "2023-03-23T09:28:05Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![VladimirAlexiev](https://sea2.discourse-cdn.com/flex016/user_avatar/forums.buildingsmart.org/vladimiralexiev/32/2065_2.png) [@VladimirAlexiev](https://forums.buildingsmart.org/u/VladimirAlexiev)\
**Post date:** [March 23, 2023, 9:28am UTC](https://forums.buildingsmart.org/t/analysis-of-propertysets-in-bsdd/4671/1 "2023-03-23T09:28:05Z")

</div>

Related to [Bsdd access for products and classification standard / bsdd guid vs ifc guid - #23 by VladimirAlexiev](https://forums.buildingsmart.org/t/bsdd-access-for-products-and-classification-standard-bsdd-guid-vs-ifc-guid/1726/23), I made some SPARQL queries to analyze propSets in the bSDD test instance.

You should be able to run them at [https://bsdd.ontotext.com/graphdb/sparql](https://bsdd.ontotext.com/graphdb/sparql). I put them as Saved Queries (the “folder” icon on top right), and below are direct links to run them:

- [propSets](https://bsdd.ontotext.com/graphdb/sparql?name=propSets&infer=true&sameAs=true&query=%23%20count%20of%20props%20(ClassificationProperty)%20by%20propSet%0A%0APREFIX%20bsdd%3A%20%3Chttp%3A%2F%2Fbsdd.buildingsmart.org%2Fdef%23%3E%0Aselect%20(count(*)%20as%20%3Fproperties)%20%3Fpset%20%7B%0A%20%20%3Fprop%20bsdd%3ApropertySet%20%3Fpset%3B%0A%20%20%20%20%20%20%23%20a%20bsdd%3AClassificationProperty%3B%20%23%20always%0A%7D%20group%20by%20%3Fpset%20order%20by%20%3Fpset%20%3Ftype): count of props (ClassificationProperty) by propSet. There are over 1000 propsets. The largest is “CPset\_SBB” (3522 props), but the empty pset `""` is also big (2341props), and there are 91625 props with no propSet at all
- [propSet-prefix](https://bsdd.ontotext.com/graphdb/sparql?name=propSet-prefix&infer=true&sameAs=true&query=%23%20count%20of%20props%20and%20propSets%20by%20propSet%20prefix%0A%0APREFIX%20bsdd%3A%20%3Chttp%3A%2F%2Fbsdd.buildingsmart.org%2Fdef%23%3E%0Aselect%20(count(*)%20as%20%3Fproperties)%20(count(distinct%20%3Fpset)%20as%20%3FpropSets)%20%3Fprefix%20%7B%0A%20%20%3Fprop%20bsdd%3ApropertySet%20%3Fpset%3B%0A%20%20bind(if(regex(%3Fpset%2C%22_%22)%2Creplace(%3Fpset%2C%22%5E(.*%3F)_.*%22%2C%22%241%22)%2C%22%22)%20as%20%3Fprefix)%0A%7D%20group%20by%20%3Fprefix%20order%20by%20desc(%3Fproperties)): count of props and propSets by propSet prefix. The biggest prefixes are `Pset`, empty, `CPset, NVDB, Qto, SGPset`. There is also a prefix `PSet`(spelled differently).

I know `Pset` and `Qto`, but can someone describe what the others are?

- `NVDB` includes propSets like `NVDB_Bygning_65, NVDB_Busker_511, NVDB_BremsekjeglerSnøskred_846, NVDB_Branndetektor_478`

---

<div class="post-metadata">

**Author:** ![artur\_tomczak](https://sea2.discourse-cdn.com/flex016/user_avatar/forums.buildingsmart.org/artur_tomczak/32/2632_2.png) [@artur\_tomczak](https://forums.buildingsmart.org/u/artur_tomczak)\
**Post date:** [March 23, 2023, 1:15pm UTC](https://forums.buildingsmart.org/t/analysis-of-propertysets-in-bsdd/4671/2 "2023-03-23T13:15:32Z")

</div>

First of all, nice work!

Properties in bSDD can be independent beings without property set. They can also be grouped using class(ification) of type “GroupOfProperties”. The PropertySet attribute can only be added to ClassificationProperty, so when a Property is linked to a particular Classification. With that you indicated where you want that property to be stored in an IFC model, and you might want to store a “Height” under different property set for a wall and for a window.

“Pset\_” and “Qto\_” are reserved for IFC schema property sets. Users can define custom property sets such as “CPset\_” or “NVDB\_”.

NVDB is the domain of Norwegian Road DataBase and they went for such prefix and propertyset to their properties.

Hope that explains it.