Dump DICOM tags to Postgree

[joaoma...@gmail.com]

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,

[Alain Mazy]

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

--

Alain Mazy / CTO 
a...@osimis.io / +32 494 31 67 27

	OSIMIS S.A.  Rue bois Saint-Jean 15/1BE-4102 Seraing  www.osimis.io

[João Marcos Ferreira Gonçalves]

Thanks a lot, Alain!

Livre de vírus. www.avast.com.

--

João Marcos Ferreira Gonçalves