Sorry if I'm late to the party here. I attached a file that shows how we staged WHO data for the heron NAACCR load at UTHSCSA. It's a sql file, but it has some manual instructions in the comments.
-Angela -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Lenon Patrick Sent: Monday, January 05, 2015 3:34 PM To: 'Dan Connolly'; '[email protected]' Cc: Mish Thomas F Subject: RE: [gpc-informatics] #44: portable HERON ETL for NAACCR Thx again guys, very helpful, many blind alleys avoided. ;) -----Original Message----- From: Dan Connolly [mailto:[email protected]] Sent: Monday, January 05, 2015 3:28 PM To: Lenon Patrick; '[email protected]' Cc: Nathan Graham; Mish Thomas F Subject: RE: [gpc-informatics] #44: portable HERON ETL for NAACCR 1) I don't remember any waiting period, but it was 2 years ago, so who knows. 2) yes 3) No; ICD-10 isn't relevant to NAACCR ETL. -- Dan ________________________________________ From: Lenon Patrick [[email protected]] Sent: Monday, January 05, 2015 2:17 PM To: '[email protected]'; Dan Connolly Cc: Nathan Graham; Lenon Patrick; Mish Thomas F Subject: RE: [gpc-informatics] #44: portable HERON ETL for NAACCR Thx, some additional questions: 1) I have not heard back from the WHO person, and my membership seems to be pending or something, so no downloads show as available for now. Did you have to go through some waiting period like this? (Maybe I mistakenly got in the "commercial license" queue instead of the "research license" queue?) 2) In your naaccr_concepts_load.sql, you refer to tables who.topo, who.morph2, and who.morph3. Do those correspond to the ICD-O-3_CSV-metadata.zip and ICD-O-2_CSV.zip you refer to below? 3) Did you not download ICD-10? Thanks as always for your assistance. -----Original Message----- From: GPC Informatics [mailto:[email protected]] Sent: Monday, January 05, 2015 12:59 PM To: [email protected]; Lenon Patrick Cc: [email protected] Subject: Re: [gpc-informatics] #44: portable HERON ETL for NAACCR #44: portable HERON ETL for NAACCR ----------------------------------+----------------------------------- Reporter: dconnolly | Owner: lenonpat Type: enhancement | Status: assigned Priority: major | Milestone: bc-survey-cohort-def Component: etl-dev | Resolution: Keywords: breast-cancer-cohort | Blocked By: Blocking: 119 | ----------------------------------+----------------------------------- Changes (by dconnolly): * owner: dconnolly => lenonpat Comment: Patrick, I found my (30 Jan 2013) notes on downloading materials from WHO... The pointer in my notes is http://www.who.int/classifications/icd/adaptations/oncology/en/index.html (along with http://apps.who.int/classifications/apps/icd/ClassificationDownloadNR/license.htm ) and I recorded the md5sums of what I downloaded - `b088c4e4bd2d685c9dd04e3b3c14c98b` ICD-O-3_CSV-metadata.zip - `1308ce6f4ef93c67137154cc6a723fc6` ICD-O-2_CSV.zip -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/44#comment:8> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics _______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
NAACR_WHO_staging.sql
Description: NAACR_WHO_staging.sql
_______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
