From Questions to Queries: An AI-powered Multi-Agent Framework for Spatial Text-to-SQL