I have a CSV file containing around 10,000 rows and 25 columns of data related to bus routes and stops. I am looking to create a functionality where users can select a specific route from a dropdown menu and then click on individual stops to view them on a map. I need advice on how best to parse and structure this data for efficient querying, potentially using a database, and how to store the query results - whether in an array, JSON object, dictionary, or data table. Since not all columns will be needed every time, I plan to optimize the query by selecting only relevant columns.
For each new route selection, I will perform a query to retrieve all stops and other necessary information, then loop through the data to display it on the map (considering storing results from previous queries). I'm also wondering about the most effective way to store these results, especially since displaying specific stop information should not pose a significant challenge as it will be a smaller subset of the queried data.
Feel free to ask for any additional details that could help provide more accurate suggestions.