Dump DICOM tags to Postgree

Google Groups archive
1

Hello,

Is there any whay to dump all the dicom tags in to the database automaticaly? I'm looking for a solution to query the database to find all the info for the dicom files like studies, patients and series, instead of using the REST API.

Is there anywhey to achieve this? I tried DCM4CHE once and it have installed a database called "pacsdb" tha handled all this data. Is it possible to do the same with Orthanc?

Thanks for all the help.

Best Regards,

2

The database actually contains only a part of the Dicom Tags, not all of them (the one we call Main Dicom Tags). All other tags are stored in .json files and they are retrieved only when you request the tags of an instance via the /instances/{id}/tags route (or /studies/{id}/shared-tags}

So, I don’t think you’ll be able to do what you expect.
What You can probably do is use the API to retrieve the instance tags and then, push them i.e, in a NoSQL DB so you’ll be able to do all the complex searches that you’ll need.

FYI: here is the schema of the PostgreSQL DB:
https://bitbucket.org/sjodogne/orthanc-postgresql/src/default/IndexPlugin/PostgreSQLPrepare.sql?fileviewer=file-view-default

3

Thanks a lot, Alain!

image.png