I pushed another update to the Geocoding API to support search by first ascensionist. For example, get all climbs that Joanne Urioste was a part of the FA team:
curl https://climb-api.openbeta.io/geocode/v1/climbs?fa=joanne%20urioste
Click to see data in your browser
I have learned a lot about various ways to do text search with PostgreSQL. Behind the scene, the query uses a combination of tsvector and trigram search on the FA text field. I'm hoping to share this in another blog post.
Check out the live demo:
API documentation
https://climb-api.openbeta.io/docs