Basic Query Using Filters
The “Spatial Engineer 11” tutorial video introduces users to basic querying with filters, a crucial skill for efficiently managing and accessing specific data within the software’s system. This lesson builds upon previous tutorials, focusing on how to refine searches by applying filters to query results. Here’s a breakdown of the key steps and concepts covered in the video:
- Accessing Query Options: The presenter begins by showing how to access the query function through the feature pullout menu or by right-clicking in the screen drawing area. It’s essential to select “new” to clear any old queries that might interfere with the current search.
- Setting Filters: The tutorial demonstrates two ways to set a filter for a query: either by right-clicking and choosing “set a filter” or by double-clicking on the header to open the filter dialogue. The purpose of setting filters is to narrow down the search criteria to find specific items within the database.
- Example – Querying a Service Area Hub: In the example provided, the filter applied is based on the “boundary description” property to find a specific service area hub named “Cadel demo area.” This showcases how to use filters to locate an item by its attributes.
- Executing the Query: Unlike the first lesson where a geographic search area needed to be defined, in this instance, because a specific filter is set, the query can be executed directly. The result is a precise return of the item(s) fitting the set criteria.
- Querying Central Office by Filter: Another example given is how to query a central office using a filter. The process involves selecting the central office from the copper plant category and applying a filter based on the central office name. This illustrates how to use filters for different types of queries within the system.
- Important Reminder: A critical tip shared is always to remember to hit the “add” button after selecting your criteria in the filter dialogue. This ensures that the filter is applied to the query.
This lesson is valuable for Spatial Engineer 11 users who need to perform targeted searches within the system, offering a straightforward guide to utilizing filters for efficient data retrieval.
Keywords: Spatial Engineer 11, querying with filters, basic queries, service area hub, central office, feature pullout menu, filter dialogue, execute query, tutorial.