# NHANES data in LibreEHR **URL:** \ **Category:** Education\ **Created:** [April 7, 2017, 10:27am UTC](https://forums.librehealth.io/t/nhanes-data-in-libreehr/735 "2017-04-07T10:27:22Z")\ **Posts on this page:** 20\ **Page:** 4
**Author:** ![rhoyt](https://forums.librehealth.io/user_avatar/forums.librehealth.io/rhoyt/32/93_2.png) [@rhoyt](https://forums.librehealth.io/u/rhoyt)\ **Post date:** [May 8, 2017, 10:02pm UTC](https://forums.librehealth.io/t/nhanes-data-in-libreehr/735/63 "2017-05-08T22:02:58Z")
I would be happy to give it a shot, but of course I would appreciate feedback from as many people as possible ---
**Author:** ![rhoyt](https://forums.librehealth.io/user_avatar/forums.librehealth.io/rhoyt/32/93_2.png) [@rhoyt](https://forums.librehealth.io/u/rhoyt)\ **Post date:** [May 9, 2017, 1:49pm UTC](https://forums.librehealth.io/t/nhanes-data-in-libreehr/735/64 "2017-05-09T13:49:26Z")
[Mission and Vision Statement for LibreHealth electronic health record.pdf](https://forums.librehealth.io/uploads/default/original/1X/872c44d795eae92f8fadeccdaadc2a871358b71f.pdf) (26.8 KB) Please take a look at this draft document ---
**Author:** ![yehster](https://forums.librehealth.io/user_avatar/forums.librehealth.io/yehster/32/400_2.png) [@yehster](https://forums.librehealth.io/u/yehster)\ **Post date:** [May 9, 2017, 5:32pm UTC](https://forums.librehealth.io/t/nhanes-data-in-libreehr/735/65 "2017-05-09T17:32:11Z")
The last major data import process is to handle the laboratory values. I’m less familiar with this portion of the EHR than I am with other sections, so it will take me a little longer. After that, there are some small things to tweak. (Demographics doesn’t handle race or income yet. The EHR uses monthly income, where as NHANES reports yearly, as well as the mapping issue I mentioned before.) At that point though, it will be much easier to add new data to the system. Having others use the SQL dumpfile should certainly be the primary way to disseminate the data, as that allows others to do the most with it. Robby, I would like to request access to a writable virtual directory on the server where I can copy the SQL dump(s) to make it available for download by others. Regarding the mission statement. Hosting for others to use is reasonable, but we can also guide others in how to setup the system for themselves as a docker image, a VMWare or other virtual machine image, or how to setup the whole system from scratch. ---
**Author:** ![r0bby](https://forums.librehealth.io/user_avatar/forums.librehealth.io/r0bby/32/1781_2.png) [@r0bby](https://forums.librehealth.io/u/r0bby)\ **Post date:** [May 9, 2017, 9:27pm UTC](https://forums.librehealth.io/t/nhanes-data-in-libreehr/735/66 "2017-05-09T21:27:55Z")
> [@yehster](#): > > Robby, I would like to request access to a writable virtual directory on the server where I can copy the SQL dump(s) to make it available for download by others. I’ll set that up for you. That needs to be managed by the Apache config which is not to be edited by hand. > [@yehster](#): > > Regarding the mission statement. Hosting for others to use is reasonable, but we can also guide others in how to setup the system for themselves as a docker image, a VMWare or other virtual machine image, or how to setup the whole system from scratch. LibreHealth has no issue hosting this, it doesn’t tax the system too much. ---
**Author:** ![r0bby](https://forums.librehealth.io/user_avatar/forums.librehealth.io/r0bby/32/1781_2.png) [@r0bby](https://forums.librehealth.io/u/r0bby)\ **Post date:** [May 9, 2017, 9:53pm UTC](https://forums.librehealth.io/t/nhanes-data-in-libreehr/735/67 "2017-05-09T21:53:23Z")
@yehster, Drop it in `/opt/nhanes/download/` – Directory listing is enabled - url is: [https://nhanes.librehealth.io/download/](https://nhanes.librehealth.io/download/) ---
**Author:** ![rhoyt](https://forums.librehealth.io/user_avatar/forums.librehealth.io/rhoyt/32/93_2.png) [@rhoyt](https://forums.librehealth.io/u/rhoyt)\ **Post date:** [May 10, 2017, 4:41pm UTC](https://forums.librehealth.io/t/nhanes-data-in-libreehr/735/68 "2017-05-10T16:41:07Z")
This is a good time to talk about how to make LibreHealth EHR for Education (LEE) available to as many universities as possible. We initially talked about hosting several universities so we could gain valuable input. I guess we can assume that the average university has an IT department capable of installing and maintaining instances on their servers if we provide good instruction. The idea of SQL dumpfiles sounds good but I will need to look into that a little further, to increase my understanding ---
**Author:** ![sunbiz](https://forums.librehealth.io/user_avatar/forums.librehealth.io/sunbiz/32/395_2.png) [@sunbiz](https://forums.librehealth.io/u/sunbiz)\ **Post date:** [May 10, 2017, 4:58pm UTC](https://forums.librehealth.io/t/nhanes-data-in-libreehr/735/69 "2017-05-10T16:58:06Z")
@rhoyt, I think this looks great. I think we should put this up on the Education team link on the [librehealth.io](http://librehealth.io) website and update it as each one of the objectives get done, with links to those objectives… We should make them as tickets in gitlab, so that they can tracked and updated, as they get done. What do others from the [@lsc](https://forums.librehealth.io/groups/lsc) think? ---
**Author:** ![sunbiz](https://forums.librehealth.io/user_avatar/forums.librehealth.io/sunbiz/32/395_2.png) [@sunbiz](https://forums.librehealth.io/u/sunbiz)\ **Post date:** [May 10, 2017, 5:00pm UTC](https://forums.librehealth.io/t/nhanes-data-in-libreehr/735/70 "2017-05-10T17:00:35Z")
Sorry, I havent found the time to test this out, but we should do this to get some preliminary data for the larger grant that we are targeting with NSF. We do have the resources to host test instance, but would be better if the IT departments can host it themselves. Although, we as a community are surely available for providing support to those IT and HI departments. ---
**Author:** ![rhoyt](https://forums.librehealth.io/user_avatar/forums.librehealth.io/rhoyt/32/93_2.png) [@rhoyt](https://forums.librehealth.io/u/rhoyt)\ **Post date:** [May 10, 2017, 6:47pm UTC](https://forums.librehealth.io/t/nhanes-data-in-libreehr/735/71 "2017-05-10T18:47:54Z")
In the Mission and Vision statement I added that we would make data available via e.g. SQL data dump. I mentioned that we would make software available on GitHub and another goal for the educational team would be gaining grants for platform enhancement. BTW, who are the members of the Education Team? ---
**Author:** ![r0bby](https://forums.librehealth.io/user_avatar/forums.librehealth.io/r0bby/32/1781_2.png) [@r0bby](https://forums.librehealth.io/u/r0bby)\ **Post date:** [May 10, 2017, 8:49pm UTC](https://forums.librehealth.io/t/nhanes-data-in-libreehr/735/72 "2017-05-10T20:49:14Z")
> [@sunbiz](#): > > We do have the resources to host test instance, but would be better if the IT departments can host it themselves. Although, we as a community are surely available for providing support to those IT and HI departments. I can host a few more instances probably on the EHR server – it’s not that much more work…PHP apps tend to not be that horrible to host multiple instances of the same app or even multiple apps on the same server… It’s just a matter of me setting up the vhost config…which is easy. We have resources, let’s use them…if we run out of resources, we have other options as well. ---
**Author:** ![judywawira](https://forums.librehealth.io/user_avatar/forums.librehealth.io/judywawira/32/264_2.png) [@judywawira](https://forums.librehealth.io/u/judywawira)\ **Post date:** [May 11, 2017, 11:04am UTC](https://forums.librehealth.io/t/nhanes-data-in-libreehr/735/73 "2017-05-11T11:04:17Z")
Didn’t we agree to use gitlab as the main repo ? ---
**Author:** ![rhoyt](https://forums.librehealth.io/user_avatar/forums.librehealth.io/rhoyt/32/93_2.png) [@rhoyt](https://forums.librehealth.io/u/rhoyt)\ **Post date:** [May 11, 2017, 11:53am UTC](https://forums.librehealth.io/t/nhanes-data-in-libreehr/735/74 "2017-05-11T11:53:32Z")
I changed it to GitLab in the Mission/Vision statement ---
**Author:** ![yehster](https://forums.librehealth.io/user_avatar/forums.librehealth.io/yehster/32/400_2.png) [@yehster](https://forums.librehealth.io/u/yehster)\ **Post date:** [May 11, 2017, 11:57am UTC](https://forums.librehealth.io/t/nhanes-data-in-libreehr/735/75 "2017-05-11T11:57:33Z")
> [@r0bby](#): > > Drop it in /opt/nhanes/download/ – Directory listing is enabled - url is: [https://nhanes.librehealth.io/download/](https://nhanes.librehealth.io/download/) My account doesn’t have write permissions for that directory to copy files. ---
**Author:** ![r0bby](https://forums.librehealth.io/user_avatar/forums.librehealth.io/r0bby/32/1781_2.png) [@r0bby](https://forums.librehealth.io/u/r0bby)\ **Post date:** [May 11, 2017, 4:59pm UTC](https://forums.librehealth.io/t/nhanes-data-in-libreehr/735/76 "2017-05-11T16:59:43Z")
`sudo -u www-data cp dump.sql /opt/nhanes/download` ---
**Author:** ![yehster](https://forums.librehealth.io/user_avatar/forums.librehealth.io/yehster/32/400_2.png) [@yehster](https://forums.librehealth.io/u/yehster)\ **Post date:** [May 11, 2017, 7:10pm UTC](https://forums.librehealth.io/t/nhanes-data-in-libreehr/735/77 "2017-05-11T19:10:37Z")
Thanks. Didn’t realize I had permissions to sudo like that. [https://nhanes.librehealth.io/download/](https://nhanes.librehealth.io/download/) gziped dumpfile is now available for download. ---
**Author:** ![judywawira](https://forums.librehealth.io/user_avatar/forums.librehealth.io/judywawira/32/264_2.png) [@judywawira](https://forums.librehealth.io/u/judywawira)\ **Post date:** [May 12, 2017, 12:42am UTC](https://forums.librehealth.io/t/nhanes-data-in-libreehr/735/78 "2017-05-12T00:42:02Z")
Re Members of the Education team – I have always thought of myself as one … cheering u from the sidelines Nonetheless , we should set up a way for folks to ‘join the education subproject of LH’ … Like a ‘How to get involved’… The page could start by listing some education partners like IU and early adopters to show partners… ---
**Author:** ![rhoyt](https://forums.librehealth.io/user_avatar/forums.librehealth.io/rhoyt/32/93_2.png) [@rhoyt](https://forums.librehealth.io/u/rhoyt)\ **Post date:** [May 12, 2017, 1:39am UTC](https://forums.librehealth.io/t/nhanes-data-in-libreehr/735/79 "2017-05-12T01:39:17Z")
Great. I believe the current web page gives a 404 error, so who had admin rights to create new content on [librehealth.io](http://librehealth.io)? ---
**Author:** ![r0bby](https://forums.librehealth.io/user_avatar/forums.librehealth.io/r0bby/32/1781_2.png) [@r0bby](https://forums.librehealth.io/u/r0bby)\ **Post date:** [May 12, 2017, 5:46pm UTC](https://forums.librehealth.io/t/nhanes-data-in-libreehr/735/80 "2017-05-12T17:46:14Z")
> [@yehster](#): > > Thanks. Didn’t realize I had permissions to sudo like that. Please be careful…if you mess up the server, it’d be a pain in the butt to fix it 🙂 – well not entirely – I just don’t want to do it 🙂 ---
**Author:** ![rhoyt](https://forums.librehealth.io/user_avatar/forums.librehealth.io/rhoyt/32/93_2.png) [@rhoyt](https://forums.librehealth.io/u/rhoyt)\ **Post date:** [May 12, 2017, 6:07pm UTC](https://forums.librehealth.io/t/nhanes-data-in-libreehr/735/81 "2017-05-12T18:07:34Z")
Robby, Any chance you would give me temporary shell access to [nhanes.librehealth.io](http://nhanes.librehealth.io)? My goal would be to demo the ability to run SQL, IBM Watson Analytics and WEKA queries Bob ---
**Author:** ![r0bby](https://forums.librehealth.io/user_avatar/forums.librehealth.io/r0bby/32/1781_2.png) [@r0bby](https://forums.librehealth.io/u/r0bby)\ **Post date:** [May 13, 2017, 2:03am UTC](https://forums.librehealth.io/t/nhanes-data-in-libreehr/735/82 "2017-05-13T02:03:27Z")
> [@rhoyt](#): > > Robby, > > Any chance you would give me temporary shell access to [nhanes.librehealth.io](http://nhanes.librehealth.io)? My goal would be to demo the ability to run SQL, IBM Watson Analytics and WEKA queries > > Bob PM me an ssh key – I will use `rhoyt` as the username. Do you need anything installed? Will this tax the resources of the server? Looks like I need to install java for you…will do that. Run weka from your home directory. [Previous page](https://forums.librehealth.io/t/nhanes-data-in-libreehr/735.md?page=3) [Next page](https://forums.librehealth.io/t/nhanes-data-in-libreehr/735.md?page=5)