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