Geographic Queries on Druid

Hello All,

I am very new Druid user and I am trying to get familiarized with its concepts and usage.

I would like to request for any leads/documents that will help me replicate SQL Geographic Queries on Druid.

Case:

I have LAT-LON data being received at a frequency of 15 minutes and I want to check if a particular LAT-LON coordinate pair lies within a demarcated polygon or not and extract the ID to a column.

Any help is appreciated.

Thanks,
Amit

Have you seen this part of the docs?

https://druid.apache.org/docs/latest/development/geo.html

I've done this by integrating Druid with Lucene, and presented that on Apache Confeference 2018 (https://www.slideshare.net/navis94/building-gis-on-druid).

It's quite old but still in use by services like http://tmap.co.kr