Comments (5)
Example cohort definition:
SQL (MS)
from gis.
It appears everything in the cohort definition boils down to smaller data sets that are joined. One approach would be to have the spatial queries run before the SQL and populate tables, most likely temporary, that are then included in the SQL joins.
Using example 1 from above (patients who lived in area x). An R function would find all people that lived in area x and populate a temporary table with 'person_id'. That table is then referenced and joined in the SQL statement, then deleted after execution.
How that would be completed functionally, specifically with staggered execution and consistent naming, and how these functions could be represented in the JSON object is unclear. Perhaps a conversation with someone from the WebAPI WG?
from gis.
@rtmill : Are you getting any input on these?
from gis.
@cgreich I had a great call with @anthonysena and I believe the plan is to discuss with this the ATLAS/WebAPI WG and then involve the folks from Circe
from gis.
@rtmill - Updating this issue after the 2020 OHDSI Symposium where I had the opportunity to demo work done on a geospatial Atlas component. This version does allow cohorts to be built off of geospatial concepts and uses the new geospatial vocabularies in Athena: Open Street Map and US Census. This architecture is database agnostic and all relationships between locations and regions are pre-computed in the concept relationship table. Custom regions would be added to the concept table and location-region relationships would be pre-computed during ETL. It won't fit every use case but does provide a starting point.
Requirements for what was implemented:
OHDSI/WebAPI#649
Code for the new features:
https://github.com/OHDSI/webapi-component-geospatial
https://github.com/OHDSI/atlas-component-geospatial
Video demo:
https://youtu.be/6OebK5CfYo0
After listening to the discussion in the GIS WG I think the future of this work would align well with the work to modularize Atlas and integrate R components into Atlas. Arachne Execution Engine is a start at this concept and provides an R execution environment as an Atlas component.
from gis.
Related Issues (20)
- Identify Datasets for testing SDoH and Exposome vocabularies HOT 4
- [Use Case]: Evaluating fitness of WorldFAIR for OHDSI/GIS HOT 10
- Form-based Entry for JSON-LD HOT 2
- Create a proof of concept knowledge graph for a catalog that includes both SDoHs and climate data HOT 3
- Put together and demonstrate a toolset that can search the JSON-LD catalog knowledge graph HOT 2
- Infuse Gaia with metadata from the knowledge graph at both the dataset and variable levels
- Get test data set suitable for social justice index component of SDOHO HOT 1
- Identify input requirements for initial geocoders for address push - UW, PostGIS, Degauss, Nominatim HOT 3
- [Use Case]: SDoH and Environmental database and related toolkits HOT 1
- Extract small deidentified dataset for evaluating SDoH and Exposome vocabularies HOT 2
- Prepare for CDM Workgroup exposure_occurence
- [Use Case]: Geocode EHR database: Application to anaphylaxis cohort
- Feature Ideas for Ares
- Feature Ideas for Atlas
- [Use Case]: Ares
- [Use Case]: opioid use disorder
- [Use Case]: common data model extension tables for `COST` and `PRICE` to assess spatial autocorrelation
- 404 on READEME
- Map some vocabularies for SDoH and geometries to variable level metadata
- Connect Jimmy Phuong & Tim Norris to Robespierre Pita (professor in Brazil)
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from gis.