I am new to Shiny and R (with database background) and would appreciate your help. I am trying to create a search tool on a map (with no Nominatim) to zoom the map to it - I have a list of streets and their lat/lon in a csv file (1800 entries).
i call them
streets <-read.csv(file = "Q:/R/streets.csv")
and then in the ui.r I use the input
selectizeInput('st', 'Street to center the map', choices = streets)
But the control retus a list of IDs - they are just generated by the system, not in the file, so instead of let's say 'High Street' it displays '23'. The csv structure is StreetName/Lat/Lon
How can I make it displaying the streetname column? And can i make the output lat/lon (based on the street selection) or do I need to get this piece again out of the file on the server side (requerying the file)? All I need from the input is to readjust the map's central point