dbrippinglayout

cities -> places
cityname
data_resolution
location_distribution
no polygon yet

save place_ids in an array and a dictionary<cityid,placeid>

studies -> questions
study_question
study_name
study_public
places_id array

save studyids in a list and a dictionary<question_number,studyid>

places -> locations
location
heading
pitch
type
places_id -> query dictionary for the city

votes -> votes

study_id -> query dictionary for the question number
left
right
left_city = left_place
right_city = right_place
choice
timestamp


QS table ->
for every question and every place and every location -> insert the corresponding votes into a QS table