Back to homepage

Search-indexed profile page

Technical Insights | Bikash Sapkota

Technical topics around H3 feature tables, GPS data quality, ClickHouse serving, and practical geospatial data-system design.

Designing H3 Feature Tables for Mobility Analytics: How to choose resolution, partitioning, and aggregation boundaries when GPS events need to become reusable spatial features. Topic: Spatial indexing

Data Quality Checks That Matter for GPS Pipelines: Practical validation patterns for timestamp consistency, coordinate sanity, duplicate trajectories, and downstream trust. Topic: Data reliability

ClickHouse for Geospatial Data Products: Where columnar serving fits after Spark transformations, and how to think about query shape, rollups, and product latency. Topic: Serving layer