News for hackers. Stuff that matters.

Show HN: Location based querying on your phone with almost any dataset

https://getzingdata.com/blog/location-based-querying-data-where-you-are/

For any data source with latitude / longitude info, you can now run queries in a few taps and visualize results based on where your phone's current location (or another location you choose)

For instance: * Logistics: Which warehouses near me are sold out of a product and need to be restocked?

* Food Delivery: Which orders out for delivery are more than one hour since order time?

* Maintenance: What locations near me have high-priority maintenance tickets open?

It works with Google Sheets, bigquery, Snowflake, Presto, Trino Software Foundation, Starburst, Oracle MySQL, Postgres, Amazon Redshift, and Databricks.

If you create a location-based query and share it with colleagues, Zing will show the data closest to them dynamically.

Free tier.

If you want to get a bit weirded out next time you go out to eat, here's a good starter dataset to import as a google sheet: https://www.kaggle.com/datasets/datasf/sf-restaurant-inspect...

( 3 comments | 3 points | on HN )
Re:Show HN: Location based querying on your phone with almos... by zX41ZdbW on Wednesday March 08, 2023 @03:31PM (#35074340)
Re:Show HN: Location based querying on your phone with almos... by zhendlin on Wednesday March 08, 2023 @04:41PM (#35075138)
We're adding Clickhouse support over the next couple weeks - but you can already query Clickhouse using Trino with Zing: https://docs.getzingdata.com/docs/setting-up-a-data-source/t...
Re:Show HN: Location based querying on your phone with almos... by tylerhannan on Wednesday March 08, 2023 @04:55PM (#35075278)
Super interesting. Excited to see where it gets.

Also I’m at ClickHouse. ;)