Location based querying
Query any database containing geospatial fields in Zing using location-based querying. This lets you:
- Query based on your current location, a radius, or a specific location
- Visualize locations on an interactive map
- Overlay relevant aggregations, calculated fields, and metadata on each data point
To do use location-based querying, your data source must contain:
- A numeric field containing ‘lat’ somewhere in the field name (indicating latitude)
- A numeric field containing ‘lon’ somewhere in the field name (indicating longitude)
To create a location-based query:
Tap on a table or view containing latitude and longitude fields
Tap and hold a latitude field, and then ‘set as latitude’. If you have a latitude field and longitude field with a similar name structure ( e.g. store_latitude and store_longitude )
Zing will automatically select the corresponding latitude or longitude field.
Optionally, you can select other fields and aggregations, whose values will appear on the map
From here, you can tap ‘run question’ and all points returned from the query will be shown
Select ‘Filter by location’ and give Zing permission to use your phone’s location:
Then select the radius relative your current location, or type an alternate address to filter your query.
Your query results are shown on a map (with up to 50 grouped data points).
You can tap ‘full results’ to see all points for your query, or ‘Always show full results’ to always see full results for that question when saved.
Zoom in or out an Zing will aggregate points for better usability.
Tap on a data point to see all the values and metadata for each point. If you selected other fields than latitude / longitude in your query, or aggregations those will appear when you tap a point.
If multiple points are on top of each other (e.g. multiple inspection dates on a given property and you’ve grouped by inspection_date, you’ll see arrows at the bottom of the screen to swipe through the values.
Save the question.
Each time you or anybody you’ve shared the question with opens the question, the results will be show relative to that person’s location if you specified ‘current location’ when constructing the query, if they have location services turned on.
Location queries can be run on iOS, Android, or the web.