Read-Only Information

Database Overview

Explorinder is powered by a comprehensive PostgreSQL database with global travel data. This page explains our data infrastructure.

147K+
Cities Worldwide
249K+
Tourist Attractions
7.7K+
Airports
Global
Transportation Routes

What Powers Explorinder

City Database

147,043 cities globally with population data, coordinates, and administrative information. Enhanced with PostGIS for fast geospatial queries.

GPS coordinates for every city
Population & capital status
Multi-language support
Points of Interest

249,226 tourist attractions ranked by popularity using Wikipedia pageviews. Includes castles, museums, parks, monuments, and more.

Fame scoring algorithm
Wikipedia integration
Associated images
Flight Network

7,698 airports worldwide with comprehensive flight route data from OpenFlights. IATA codes, airline information, and connection details.

Global airport coverage
Flight routes & airlines
Timezone information
Ground Transportation

Intercity routes covering buses, trains, ferries, and more. Distance calculations and transport operator information for comprehensive planning.

Bus & rail networks
Ferry connections
Route optimization
How It Works
From your chat message to optimized routes
1

AI City Extraction

Your natural language request is processed by our AI to extract cities and travel preferences.

2

Database Lookup

Cities are matched against our 147K+ city database with multi-language support and alternate names.

3

Route Optimization

Our algorithm queries transportation data to find optimal connections (flight, rail, bus, ferry).

4

Visual Display

Routes are rendered on the interactive map with transport icons, distances, and durations.

Technical Specifications

Database

  • • PostgreSQL with PostGIS extensions
  • • Geospatial indexing for fast queries
  • • Full-text search capabilities
  • • Connection pooling for performance

AI Integration

  • • Gemini AI for natural language processing
  • • Context-aware conversation handling
  • • Structured JSON output validation
  • • Multi-turn dialogue support

Data Sources

  • • GeoNames for city data
  • • OpenFlights for airport information
  • • Wikipedia for POI popularity metrics
  • • OpenStreetMap for base maps

Routing Logic

  • • Distance-based transport selection
  • • Multi-modal route planning
  • • Duration estimation algorithms
  • • Real-time route optimization

This data infrastructure enables intelligent, conversation-driven trip planning.