~/talk

Location Analytics - Real-Time Geofencing using Kafka

Talkat Berlin Buzzwords 2019 · 2019-06-16..06-18· [data-engineering, databases]
speakerdeck:gschmutz
slides:none on file

Prototype implements real-time geofencing by ingesting GPS streams into Kafka, enriching with KSQL UDFs with GeoTools (Java), and emitting enter/exit events; naive cross-join fails, so a geohash sharding step reduces checks and raises scalability. Bulk-UDF returns lists (low latency, medium scale), while a Tile38 integration via Tile38 + Kafka Connect offloads spatial queries and can publish hooks back to Kafka. Proof-of-concept works; needs performance tuning and a source connector for full round-trip.

AI-written summary · about

  1. 0:00Intro
  2. 1:38Guido Schmutz
  3. 2:58Geofencing - What is it?
  4. 4:41Geo-Processing
  5. 6:34Apache Kafka - A Streaming Platform
  6. 8:02High Level Overview of Use Case
  7. 9:27KSQL - Overview
  8. 11:27KSQL - Streams and Tabless
  9. 13:05How to determine "inside" or "outside" geofence?
  10. 16:14Using Cross Join
  11. 16:58INNER Join
  12. 19:16Geofences aggregated in one group
  13. 24:30Geo Hash for a better distribution
  14. 25:52Geo Hash Custom UDF
  15. 30:154 Geofences aggregated by GeoHash
  16. 36:24Tile 38 - How does it work?
  17. 39:112 Using Custom Kafka Connector for Tile38
  18. 40:39Arcadia Data
  19. 41:56Outlook
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.