CulturedCheese / thesis-project

4 stars 4 forks source link

create Places table #28

Closed ClimbsRocks closed 9 years ago

ClimbsRocks commented 9 years ago

this is just the unique list of places from our raw_data_import table.

we should have a count of each place too, so we're only making requests to Unlock Places for places with more than 5 users.

steps:

  1. write query to group by place
  2. create a Places table
  3. figure out how to save data from the query into the Places table
  4. figure out how to add a count to the Places table.
ClimbsRocks commented 9 years ago

did it! and documented in the mysql wiki.