Filtering

Prompts for filtering and subsetting geospatial data

1. Filter by Attribute Value

Show only features matching a specific value.

Filter the layer to only show features where [field_name] equals [value].

2. Filter by Numeric Range

Display features within a numeric range.

Filter to show only features where [numeric_field] is between [min_value] and [max_value].

3. Filter by Multiple Values

Include features matching any of several values.

Show features where [field_name] is any of: [value_1], [value_2], [value_3].

4. Filter by Date Range

Show features within a time period.

Filter the data to show only features from [start_date] to [end_date]. Use the [date_field] column for this filter.

5. Compound Filter

Combine multiple filter conditions.

Filter features where [field_1] equals [value_1] AND [field_2] is greater than [value_2]. Both conditions must be true.

6. Filter with NULL Handling

Handle missing or null values in filters.

Show all features where [field_name] is not null or empty. Alternatively, show only features WITH missing values in [field_name].

7. Text Search Filter

Filter by partial text match.

Filter features where [text_field] contains the text "[search_term]". Make the search case-insensitive.