概要
This skill provides standardized patterns and implementation guides for integrating high-performance geospatial capabilities into logistics and transportation management systems. It covers essential PostGIS workflows ranging from table schema design and GIST indexing to complex spatial queries like geofence entry/exit detection, ETA predictions, and distance calculations using the WGS84 coordinate system. By following these patterns, developers can ensure their applications handle GPS data accurately while maintaining the query performance required for real-time fleet visualization and monitoring.