We have developed a tool for semi-automatic GIS visualization based on OMOP-CDM, which is called AEGIS (Application for Epidemiological Geographic Information System).
AEGIS can visualize cohorts which are extracted from ATLAS (I presented and gave a demonstration of this tool on Eastern hemisphere working group meeting on 28th June).
For global application of GIS system, we used the geomatric information system database called GADM in this tool.
Database of Global Administrative Area (GADM) is spatial database of the location of the world’s administrative areas, which including 294,430 administrative areas in about 250 countries (virtually whole world). Administrative levels are divided into Level 1 - Nations(eg US), Level 2 - States(eg Texas), and Level 3 - Counties(eg Houston) in GADM (So AEGIS can visualize where the subjects in cohort live according to this level).
However, CDM and GADM have different regional classification system. Therefore, we had to create the mapping table as below to link two diffrent databases. If GADM vodabulary is adopted as a standard vocabulary in OMOP CDM, applying AEGIS could be much easier in any OMOP-CDM database in the world.
How about adopting GADM as standard vocabulary for geographical index in CDM?
We plan to present our work on OHDSI Collaborator Community meeting.
Figure 1, 2 - The AEGIS tool was used to compare the distribution of two typed of dialysis (HD : Hemodialysis, PD : Peritoneal dialysis) patients by level 2 and level 3.
Figure 3 - Example of U.S. medical map generated using the AEGIS tool with the cohort data which I just made up.