Why Geospatial Distance Queries Go Wrong: Coordinate Order, SRIDs and Meter-Based Acceptance
Warehouse proximity filters, asset matching and service-radius reports can be wrong even when their SQL executes successfully. Using PostGIS, this article separates coordinate provenance, axis order, reference-system assignment and transformation. A constructed two-kilometer example, ingestion procedure and boundary tests explain reliable distance queries and their limits.
