ODBC - PostgreSQL Database connection - Revit 2018 - external database use

[Anonymous]

Hello 🙂

I exported a project from Revit to PostgreSQL and I also tried the SQL server one. In the SQL Server database, I used the Revit DB link. Analysing the two databases' tables I found that the SQL Server one has more tables (more 30 tables). First I don't know why and in my little research about it no one knows it too.

Now, my big "problem".

The tables in the database have relationships between them. For example, the doors table and the doorTypes table have a relationship. (Attached is an image of the doors and doorType tables to a better understanding)

However, how I know which building do they belong to? I want to have a database with different infrastructures and access their information separately. For instance, a school and a regular house are in my database. How do I know which is the door of the school? Or any other element?

In other words, my doubt is how I know the id of the Revit object as a whole. I mean, I need an identifier that is related to all of its elements. (example: A house has an id, and each element such as doors, walls, has a relationship to the house id).

Thanks in advance.

[Secttor]

Hi @Anonymous

Trying to help with all that I've understood. 

If we discuss about system families (pipes, ducts etc) having access to their ID it's a matter of Dynamo I quess. If you need an identifier (any)..an easy way could be using Type Mark parameter which could be filled based on your preferences and sort it after in the schedule. Filling in manually is obviously, automatically could be also matter of Dynamo. 

Component families can have also the same (shared) parameter added with different values based on your wishes. 

So this way..you can organize really easy your objects inside the project. Sure, can be also dependent to phases but this is an additional and optional step.

System & Component families.

[Anonymous]

Thank you for answering me @Secttor.

I did a little research on the topic, but I did not find anything related to the database. Dynamo is mostly used to build a model of something or to apply specific commands that we cannot do using the keyboard and the mouse. 

I want to get a database of BIM models and then access the information through the id of the model. 

In the database exported from Revit software I always got tables with relationships, but not to the object model. I mean, the Doors table have a relationship with the DoorType table. However, how I know which is the model whom they belong? I don't find a relationship between this kind of tables to a main one with the ID, for instance, of a house.

Thereby, I cannot make queries to the database to know, for instance, how many doors has the school X and the Building Y too.

Maybe exist other ways of exporting the data from Revit to a database and as I am a beginner in this software I do not know them. I found two ways and I have the same results in the two different databases. ( File --> Export --> ODBC database ***** and **** Revit DB link 2018)

Again thanks in advance.

[fabiosato]

Hello,

This is a suggestion, I can’t test this idea.

Can you get the link name value from the database?

[Anonymous]

Hi @fabiosato 🙂

Thanks for answering me.

I didn't quite understand your clue. Can you be a little bit more specific, please?

Thanks in advance 🙂

[fabiosato]

Hello,

I meant if you can’t get the parameter Link Name from the database. This parameter is a property of every linked file.