What coordinate system does this skill use?

It utilizes SRID 4326 (WGS84), which is the global standard for GPS coordinates, and recommends the geography type for accurate distance calculations in meters.

Is this specific to laneweaverTMS?

While tailored for laneweaverTMS architecture, the PostGIS and SQL patterns are applicable to any PostgreSQL-based application requiring geospatial features.

Can I use this for real-time fleet tracking?

Yes, it includes specific logic and SQL functions for processing location updates and detecting geofence entry/exit events.

Does it support complex geofence shapes?

It provides patterns for both circular geofences using ST_Buffer and custom polygon geofences using ST_GeomFromText.

How does it optimize spatial query performance?

The skill includes migration patterns for creating GIST (Generalized Search Tree) indexes, which are essential for fast spatial lookups in PostgreSQL.

PostGIS Geospatial Architecture

Name: PostGIS Geospatial Architecture
Author: linehaul-ai

bylinehaul-ai

•

データベース管理

Implements advanced geospatial features including geofencing, spatial indexing, and real-time fleet tracking using PostGIS and PGRouting.

概要

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.

主な機能

Optimized geofence boundary design for circular and polygon regions
1 GitHub stars
High-accuracy geography-based distance and proximity calculations
Standardized SRID 4326 (WGS84) coordinate handling for GPS integration
Performance-tuned GIST spatial indexing for large location datasets
Automated geofence entry, exit, and dwell time event detection

ユースケース

Querying fleet distribution within specific radiuses for load matching
Automating arrival and departure alerts for logistics facilities and terminals
Calculating precise ETA predictions based on real-time truck GPS coordinates

概要

主な機能

Optimized geofence boundary design for circular and polygon regions
1 GitHub stars
High-accuracy geography-based distance and proximity calculations
Standardized SRID 4326 (WGS84) coordinate handling for GPS integration
Performance-tuned GIST spatial indexing for large location datasets
Automated geofence entry, exit, and dwell time event detection

ユースケース

Querying fleet distribution within specific radiuses for load matching
Automating arrival and departure alerts for logistics facilities and terminals
Calculating precise ETA predictions based on real-time truck GPS coordinates