Search neighborhoods

Demonstrating simple like search

Custom SQL query returning 1 row (hide)

select neighborhood, facet_cities.name, state
from facetable
    join facet_cities
        on facetable.city_id = facet_cities.id
where neighborhood like '%' || :text || '%'
order by neighborhood;

Query parameters

Edit SQL

This data as json, CSV

neighborhoodnamestate
Bernal Heights San Francisco CA