Extraction attribute values from FRAMME in FME?

Hi @lazarlubomir from my experience with FRAMME the information you need is split across different components so you will need to join with a reference table to get the main attributes for your feature. Maybe you could provide a bit more info about your source?

I'm not sure what data you are trying to work with but an example is use a joiner to join with reference table to get the rb_prmry and class from Design table.

Then Join with reference table and get the main segment's rb_prmry and rb_scndry

I hope this gives you some guidance based on my own experience!

@ciarab Wow, thank You so much for great advice and manual how to figure out my problem. Anywam, my problem is following: I have data from FRAMME - DGN files with geometry and MDB files with attribute values. Just imagine - I have one line feature in DGN and I want to get attribute values fot this line from MDB. In my DGN dataset, there is not any rb_prmry class and so on. There is only UFID attribute and many linkage atributes (pic below). My source data contains water and wastewater topology. How could I continue to get attribute values? As You typed above?

@lazarlubomir yes in my case I am merging the attribute information from SQL tables but if your data is contained in MDB it should be the same scenario, the UFID should be the key you can join the geom to the attribute values you should be able to replicate the same scenario, doesn't sound like the linkage of your tables will be as complex as the above scenario you should be able to link just using one joiner, let me know how you get on trying that.

@ciarab I quite understand the principle how to join table, but Im still quite lost which attribute is "joiner". In total, I have 16 DGN files and 1 MDB, which is related to DGN files. I attach pics below, where is list of my attributes, which are related to line feature in DGN. I cant find any UFID attribute in MDB file, so via which attribute I can merge table with features please?

Thank You so much! (I apologize, I forgot to attach the pic yesterday).

Well from my example above and looking at your screenshot for your dgn this is how my join attributes relate to yours-

RB_FSC- Relates to your attribute feat_num

RB_SCNDRY-Relates to the attribute ufid

RB_PRMRY- Not sure about this one potentially igds_linkage.long(1)

In order for me to link these I had to join across 3 different tables to get them so its difficult for me to say what you need to join to in your single MDB. If it doesn't have any of the above attributes then I am not sure. Can you provide a screenshot of the MDB so I can see what is available to you?

Thanks

@ciarab Its not necessary rigt rigt to upload screenshot of the MDB. I finally understand, how FRAMME works, so I am able to get all of required attributes :-) Thank You so much for Your advices!

Oh good! Glad you managed to join them. What did you use in the end?

@ciarab At first, I used joiner to attribute igds_basename (with suffix *.dgn via stringconcatenator) with attribute DGN_FILENAME from DGN_SHAPE table - I got RB_PRMRY. Then I use another joiner to attributes UFID, igds_linkage.feature_num with attributes RB_SCNDRY, RB_FSC from CON_ALLNW table. After there, I can sort out features according to value of RB_FSC. Can I use this progress? Maybe I have another question - should I use CON_ALLNW table or REF_TABLE table? I attach pic with list of tables from MDB.

Yes that sounds more like my process, I wasn't sure what you had contained in the MDB but now I see the screenshot it looks similar to what I had worked with. I think what we did was link to the ref table to get attributes rb_refscndry rb_refprmry and then that allowed us to merge the data from the table that contained the information on the feature itself hydrant, pipe and so on. Sounds like you are nearly there, good job FRAMME is quite complex!

Yes, I was inspired by Your process, thank you so much! I checked attribute values in REF_TABLE table and values in RB_PRMRY, RB_SCNDRY are same as in RB_REFPRMRY, RB_REFSCNDRY, so I suppose that I can use RB_PRMRY and RB_SCNDRY, right? FRAMME is really complex and it takes a time to understand whole mechanism.