We will showcase how CrateDB enables:
- Identifying emergency calls near wildfire locations using geospatial distance functions
- Mapping wildfire incidents within specific areas using polygon-based queries
- Analyzing emergency calls related to wildfires with full-text search and match clauses
- Extracting the most common emergency call topics for trend analysis
- Measuring average response times between call receipt and incident discovery
- Understanding the distribution of fires across different states and cities