Barcelona Cafes

Admin sign-in

Enter your email. We’ll send a one-time magic link. Only allowlisted addresses can open the admin panel.

Barcelona Cafes

Places collector

Pull cafes from Google Places API (New) into storage. Only places with cafe in types are saved.

API keys

Loaded from .env (see .env.example). Not stored in SQLite or editable here.

GOOGLE_PLACES_API_KEY

PARALLEL_API_KEY

OPENAI_API_KEY

Collect data

Uses locationRestriction viewports per neighborhood — not address text filters. Dedupes on Places ID. 


        


        

          
Coffee content

          

            Uses Parallel Extract on cafe websites for the selected neighborhood
            (or all cafes when All Barcelona is selected). Skips rows that
            already have coffee_content.
          

          

            

              
              
            

            

              

                
Processing

                
—

              

              

                
Completed

                
—

              

              

                
Skipped (filled)

                
—

              

            

            

            

          

        


        

          
RAG search

          

            Location-aware hybrid search: if the query mentions a street,
            landmark, or neighborhood, cafes are first filtered to a 1 km
            radius (Google Geocoding + local coordinates), then ranked with
            ChromaDB + BM25. Answers use only local cafe data.
          

          

            

              
              
            

            

            

              
              
              

                
              

            

            

            

              

            

          

        


        

          

            
Summary

            
          

          
Stats for the neighborhood selected above.

          

            

              
Total cafes

              
—

            

            

              
Average rating

              
—

            

            

              
With website

              
—

            

            

              
With reviews

              
—

            

            

              
With coordinates

              
—

            

          

          

            Export CSV