Why not make each location just a link?
When the link is accessed, it contains the information for what location to get tide information.
Maybe something like:
<a href="tides/9414290">San Francisco, CA</a>
Each URL context/tides/nnnnnnn will get the tide information for the location number as specified by 'nnnnnnn'.