Difference between revisions of "Kyran Adams (Work Log)"
| Line 3: | Line 3: | ||
[[Kyran Adams]] [[Work Logs]] [[Kyran Adams (Work Log)|(log page)]] | [[Kyran Adams]] [[Work Logs]] [[Kyran Adams (Work Log)|(log page)]] | ||
| − | 2018-01-18: Started work on running R functions from PostgreSQL queries following [https://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tut01 this tutorial.] First installed R 3.4.3, then realized we needed R 3.3.0 for PL/R to work with PostgreSQL 9.5. Installed R 3.3.0. Link from tutorial for PL/R doesn't work, I used [http://www.joeconway.com/plr.html this instead.] To use R from pgAdmin III, follow the instructions in the tutorial: choose the database, click SQL, and run "CREATE EXTENSION plr;". You should be able to run the given examples. | + | 2018-01-18: Started work on running R functions from PostgreSQL queries following [https://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tut01 this tutorial.] First installed R 3.4.3, then realized we needed R 3.3.0 for PL/R to work with PostgreSQL 9.5. Installed R 3.3.0. Link from tutorial for PL/R doesn't work, I used [http://www.joeconway.com/plr.html this instead.] To use R from pgAdmin III, follow the instructions in the tutorial: choose the database, click SQL, and run "CREATE EXTENSION plr;". You should be able to run the given examples. [https://www.joeconway.com/presentations/plr-DWDC-2015.05.pdf Another possibly useful presentation on PL/R.] |
</onlyinclude> | </onlyinclude> | ||
Revision as of 16:09, 18 January 2018
Spring 2018
Kyran Adams Work Logs (log page)
2018-01-18: Started work on running R functions from PostgreSQL queries following this tutorial. First installed R 3.4.3, then realized we needed R 3.3.0 for PL/R to work with PostgreSQL 9.5. Installed R 3.3.0. Link from tutorial for PL/R doesn't work, I used this instead. To use R from pgAdmin III, follow the instructions in the tutorial: choose the database, click SQL, and run "CREATE EXTENSION plr;". You should be able to run the given examples. Another possibly useful presentation on PL/R.
Fall 2017
2017-11-22: Fixed outjoiner.py python 3 compatibility bugs, color coded plot so errors are easier to see
2017-11-20: Continued debugging circles.py and changed outjoiner.py so it generates an error file, which contains all files with errors.
2017-11-17: Finished duplicated points code, but it still gives errors... Wrote a plotter so that I can debug it more.
2017-11-15: Worked on making duplicated points work with circles.py.
2017-11-13: Put some examples of nonworking files into OliverLovesCircles/problemdata. The files are not just St. Louis, but a lot of different files, meaning the bug is pretty widespread. Found possible solution; removing duplicate points before running program fixes it?
2017-11-10:
- Wrote some docs for ecircalg.py. Narrowed the St. Louis problem to the algorithm itself; it's returning circles with a radius of 0.0 for some reason. Wrote some testing code that prints errors if there are unenclosed points or circles with too few points.
- Also created a new parts list for the GPU build using server parts. Did some research on NVLink.
2017-11-08: Commented and wrote documentation for vc_cirlces, circles, and outjoiner.
2017-11-03: Fixed bug in circles.py that output place names in files as lists instead of strings (['S','t','L','o','u','i','s'] instead of "St. Louis"). Changed vc_circles.py to call outjoiner.py automatically. Refactored vc_circles.py, circles.py, and outjoiner.py to put all of the configuration in vc_circles.py. Wrote out method to plot circles using ArcMap in here.
2017-11-01: Familiarized with Enclosing Circle Algorithm to find St. Louis bug
2017-10-30: Rechecked parts compatibility, switched PSU and case
2017-10-27: Decided on dual GPU system, switched motherboard and CPU
2017-10-25: Worked on the partpicker for the dual GPU build.
2017-10-23: Started researching GPU Build. Researched the practical differences between single vs. multiple GPUs.
2017-10-20: Set up a wiki page
