TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

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

6 pointsby zhendlinabout 2 years ago
For any data source with latitude &#x2F; longitude info, you can now run queries in a few taps and visualize results based on where your phone&#x27;s current location (or another location you choose)<p>For instance: * Logistics: Which warehouses near me are sold out of a product and need to be restocked?<p>* Food Delivery: Which orders out for delivery are more than one hour since order time?<p>* Maintenance: What locations near me have high-priority maintenance tickets open?<p>It works with Google Sheets, bigquery, Snowflake, Presto, Trino Software Foundation, Starburst, Oracle MySQL, Postgres, Amazon Redshift, and Databricks.<p>If you create a location-based query and share it with colleagues, Zing will show the data closest to them dynamically.<p>Free tier.<p>If you want to get a bit weirded out next time you go out to eat, here&#x27;s a good starter dataset to import as a google sheet: <a href="https:&#x2F;&#x2F;www.kaggle.com&#x2F;datasets&#x2F;datasf&#x2F;sf-restaurant-inspection-scores" rel="nofollow">https:&#x2F;&#x2F;www.kaggle.com&#x2F;datasets&#x2F;datasf&#x2F;sf-restaurant-inspect...</a>

1 comment

zX41ZdbWabout 2 years ago
Let&#x27;s check it with the OpenCellID dataset in ClickHouse: <a href="https:&#x2F;&#x2F;clickhouse.com&#x2F;docs&#x2F;en&#x2F;getting-started&#x2F;example-datasets&#x2F;cell-towers&#x2F;" rel="nofollow">https:&#x2F;&#x2F;clickhouse.com&#x2F;docs&#x2F;en&#x2F;getting-started&#x2F;example-datas...</a><p>Example: <a href="https:&#x2F;&#x2F;twitter.com&#x2F;ClickHouseDB&#x2F;status&#x2F;1608961906794172416" rel="nofollow">https:&#x2F;&#x2F;twitter.com&#x2F;ClickHouseDB&#x2F;status&#x2F;1608961906794172416</a>
评论 #35075138 未加载