ctl data mining

Lots of SQL. Refactored users table, splitting out ‘organization’ and ‘college’ into a separate table to account for multiple values. With help of Jonathon Trigeux, came up with table to map colleges to organizations. after much ¬†fiddling, arrived at this summary table:

https://www.uvm.edu/~waw/php/ctl_events_reports.php

Had to seriously modify calendar coed to account for new table structure.

 

Profile photo of Wesley Wright

About Wesley Wright

Born on a mountain top near New York City, Craziest state in the land of the pretty. Raised in the woods so's he knew every tree, Killed him a bear when he was only three.
This entry was posted in Wes and tagged , . Bookmark the permalink.