Prototype one data type

[jomey]

Select one of the products to prototype an improved schema (database structure)

[aaarendt]

• set up two separate instances of the points database, to ensure the prototype test times are not impacted by other participant queries: one is for performance testing, the other is for playing with a new relational schema (@micah-prime )
• decide on which specific data stream will work best for the performance test and generate a query. Do this both as a straight SQL query and then using the snowexsql API (@jtmaze, @micahjohnson150 )

[micah-prime]

Noting steps for myself on spitting up a new instance for testing (status quo test)

• Start new instance
• Make public to UW ip for db queries
• Run install on ubuntu script
• Start db
• Upload datasets

datasets to upload (focussing on point data)

• GPR [add_unm_gpr.py, add_bsu_gpr.py, add_csu_gpr.py]