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'.