Re: [gpc-informatics] #595: collect i2b2 datamarts for GROUSE

#595: collect i2b2 datamarts for GROUSE --+ Reporter: dconnolly | Owner: gkowalski Type: task | Status: assigned Priority: major | Milestone: gpc-phase2-h4 Component: data-sharing | Resolution: Ke

Re: [gpc-informatics] #595: collect i2b2 datamarts for GROUSE

#595: collect i2b2 datamarts for GROUSE --+ Reporter: dconnolly | Owner: dconnolly Type: task | Status: assigned Priority: major | Milestone: gpc-phase2-h4 Component: data-sharing | Resolution: Ke

Re: [gpc-informatics] #595: collect i2b2 datamarts for GROUSE

#595: collect i2b2 datamarts for GROUSE --+ Reporter: dconnolly | Owner: lpatel Type: task | Status: assigned Priority: major | Milestone: gpc-phase2-h4 Component: data-sharing | Resolution: Keywo

Re: [gpc-informatics] #595: collect i2b2 datamarts for GROUSE

#595: collect i2b2 datamarts for GROUSE --+ Reporter: dconnolly | Owner: lpatel Type: task | Status: assigned Priority: major | Milestone: gpc-phase2-h4 Component: data-sharing | Resolution: Keywo

Re: [gpc-informatics] #595: collect i2b2 datamarts for GROUSE

#595: collect i2b2 datamarts for GROUSE --+ Reporter: dconnolly | Owner: lpatel Type: task | Status: assigned Priority: major | Milestone: gpc-phase2-h4 Component: data-sharing | Resolution: Keywo

getting gpc-dev work done (vs. asking for agenda items)

Periodic public service announcement, prompted by several recent messages putting me in the critical path unnecessarily... The sources for gpc-dev weekly agenda items are: 1. stuff from last week (#12

Linking Geocoding data with i2b2

#1) Now that we have the geocoding data, is there a document somewhere that summarizes what the next steps are? For example, which census files should we load? Is there a standard process for loading that data into Oracle? Any helpful tips for working with the data? #2) Has there been any add

Re: Linking Geocoding data with i2b2

Phil, I just created the table in oracle , shooting from the hip : CREATE TABLE MCW_GEOCODING ( OID INTEGER, JOIN_COUNT INTEGER, TARGET_FID INTEGER, LOC_NAME VARCHAR2(200), STATUS VARCHAR2(200), SCORE INTEGER, MATCH_TYPE VARCHAR2(2

RE: Linking Geocoding data (for ht/wt #570)

The near-term scheduled work involving geocoding is income for ht/wt #570, which doesn't (necessarily, directly) involve integration with i2b2. Slide 15 Visual summary of linking Obs Pat List to Geocode Income

RE: Linking Geocoding data with i2b2

At KUMC, reproducing MU's work on i2b2 integration remains largely on our TODO list. But as for tips for working with the data, we've done enough to be able to do ad-hoc queries such as "count HERON patients by income group": select 'Over' || to_char(hi.dollar_group, '$999,999') income_group, s

combining notes

All , Per yesterday’s call: Not much to the code to combine text notes . Our main query is : SELECT pm.date_off, hnt.* FROM hno_note_text hnt LEFT OUTER JOIN patient_mapping pm ON hnt.pat_id = pm.pat_id WHERE hnt.note_id IS NOT NULL AND hnt.pat_id IS NOT NULL ORDER BY

Re: [gpc-informatics] #595: collect i2b2 datamarts for GROUSE

#595: collect i2b2 datamarts for GROUSE --+ Reporter: dconnolly | Owner: lpatel Type: task | Status: assigned Priority: major | Milestone: gpc-phase2-h4 Component: data-sharing | Resolution: Keywo

RE: combining notes

Do you use SQL to do the iterating and concatenating? Or something else like python or Java? That is: can this query be used as the input query to the deid software? Or is there a separate prep step to put the concatenation results back in the DB? -- Dan __

Re: Gpc-dev Digest, Vol 39, Issue 47

ke to see what that looks like. Thanks, Phillip UT Southwestern Medical Center The future of medicine, today. -- next part -- An HTML attachment was scrubbed... URL: <http://listserv.kumc.edu/pipermail/gpc-dev/attachments/20170524/a801

Re: Gpc-dev Digest, Vol 39, Issue 48

everal people in my group that would like to see what that looks like. Thanks, Phillip UT Southwestern Medical Center The future of medicine, today. -- next part -- An HTML attachment was scrubbed... URL: <http://listserv.ku

Re: Gpc-dev Digest, Vol 39, Issue 49

b2 and the geocoding data? The last I see is from almost a year ago. Would it be possible to get a short presentation of the current state of that process? There are several people in my group that would like to see what that looks like. Thanks, Phillip UT Southw