Variable Name | Source | Collected By | Type | Example Data |
Favorite Spot Name | Member | Survey 1 | Short Answer | “Palace of Fine Arts” |
Favorite Spot Location | Member | Survey 1 | Location | 3601 Lyon St, San Francisco, CA 94123 |
Favorite Spot Description | Member | Survey 1 | Long Answer | “amazing looking and has incredible architecture” |
Restaurant Name | Member | Survey 1 | Short Answer | “Home Plate” |
Restaurant Location | Member | Survey 1 | Location | 2150 Lombard St, San Francisco, CA 94123 |
Restaurant Description | Member | Survey 1 | Long Answer | “great waffles” |
Survey | Variable Name | Type |
Survey 1 | Favorite Spot Name | Short Answer |
Survey 1 | Favorite Spot Location | Location |
Survey 1 | Favorite Spot Description | Long Answer |
Survey 1 | Restaurant Name | Short Answer |
Survey 1 | Restaurant Location | Location |
Survey 1 | Restaurant Description | Long Answer |
flowchart LR subgraph Member subgraph Input Highlight Restaurant end end subgraph Survey subgraph Fields Highlight_location[Highlight Location] Restaurant_location[Restaurant Location] end end Member-->Survey; Survey-->Database[(Google Sheets Database)]; Database-->Map((Google Maps));