Location querying with Zing Data – visualize gSheets, Snowflake, and more based your phone's GPS
Google Sheets Appscript to convert an address to latitude and longitude: https://willgeary.github.io/data/2016/11/04/Geocoding-with-Google-Sheets.html
Zing Data: http://www.zingdata.com
Apple App Store: https://apps.apple.com/us/app/zing-data-collaborative-bi/id1563294091
Google Play Store: https://play.google.com/store/apps/details?id=com.getzingdata.android&hl=en_US&gl=US
Documentation: https://docs.getzingdata.com/docs/location-based-querying/
Location-based querying is a powerful way to display data on a map based on your phone’s GPS location, or any other location you specify. This can be useful for a variety of applications, such as tracking deliveries, monitoring inventory, or managing maintenance tasks all of which have location attributes. In this context, Zing Data is a platform for data analytics on iOS, Android, and the web that makes it easy to create location-based queries using data from Google Sheets, Postgres, mySQL, Snowflake, MS SQL, Databricks, Trino, Presto, Starburst, Excel, CSVs, and other data sources.
To get started with Zing Data, the first step is to prepare your data by adding location information. This can be done by converting addresses to latitudes and longitudes, which is easy to do using app scripts within Google Sheets. Once your data has location information, you can connect it to Zing data and start building queries.
To connect your data to Zing, you will need to log in to the Zing Data website or mobile app and set up a data source. Once you have connected your data source, you can start building queries.
One important thing to keep in mind when building location-based queries with Zing data is the naming convention for latitude and longitude fields. In order for Zing data to recognize these fields as location information, they must contain “lat” or “lon” in their field name. So, make sure that your latitude and longitude fields are appropriately named.
Once your data is connected to Zing data, you can start building queries using the Zing data interface. To do this, you will need to select the data source you want to query and then define your query parameters. For example, you might want to query only the data that corresponds to deliveries that have not yet occurred, or you might want to filter data based on the assigned delivery person.
Once you have defined your query parameters, you can view the data on a map by clicking the “View Map” button. This will display your data as pins on a map, which you can click on to see additional information about each data point.
Zing also offers a variety of customization options, such as grouping data by location or other attributes, or changing the colors or symbols used to display data on the map.
Apple App Store: https://apps.apple.com/us/app/zing-data-collaborative-bi/id1563294091
Google Play Store: https://play.google.com/store/apps/details?id=com.getzingdata.android&hl=en_US&gl=US
Documentation: https://docs.getzingdata.com/docs/location-based-querying/