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

•

Database Management

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.

Key Features

01Optimized geofence boundary design for circular and polygon regions

021 GitHub stars

03High-accuracy geography-based distance and proximity calculations

04Standardized SRID 4326 (WGS84) coordinate handling for GPS integration

05Performance-tuned GIST spatial indexing for large location datasets

06Automated geofence entry, exit, and dwell time event detection

Use Cases

01Querying fleet distribution within specific radiuses for load matching

02Automating arrival and departure alerts for logistics facilities and terminals

03Calculating precise ETA predictions based on real-time truck GPS coordinates

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add linehaul-ai/linehaulai-claude-marketplace architecture

For use in Claude.ai and ChatGPT

Download Skill