Questions tagged [definition-query]

A request that examines feature or tabular attributes based on user-selected criteria and displays only those features or records that satisfy the criteria.

Filter by
Sorted by
Tagged with
0
votes
1answer
32 views

Setting up ArcPy SQL Query that allow for "one" or "both" selection

I am writing a code that will query two attributes, zoom to layer and output a map. The problem I am having is in some cases the user will likely only want to query one of the two attributes. How can ...
0
votes
0answers
41 views

How to efficiently filter and select attributes based on conditional formatting?

I am wishing to filter my attribute table to display only certain values that meet certain criteria based on multiple column values. For example, I want to show all locations on my map that are Lost ...
3
votes
1answer
60 views

Selecting and displaying all of items with same value in attribute table using ArcMap

One of the columns in my attribute table is entitled NAICS_1 and I'm supposed to display only the objects with an NAICS_1 of a specific value. How do I filter the attribute table using ArcMap to only ...
2
votes
0answers
137 views

QGIS Temporal Controller - last/most recent object within a temporal frame

i am working with temporal controller for just a cluple of days - before i've been using time manager. right now i am searching for a way to display the last/latest/most recent feature within a time ...
0
votes
0answers
34 views

When I export a layer with a definition query, it does not maintain coverage. Why is that and how can I find a way to make it do that?

I am trying to use the NHD waterbody layer in my map. As is, it is a really dense dataset, so I am narrowing it down to only show lakes (Ftype = 390). When I use the definition query, everything looks ...
1
vote
0answers
39 views

How to save a GeoJSON layer with the select option for the items in a field in QGIS

I have a GeoJSON layers with many items. If you open the attribute table you can select an option in one field clicking over the field and the choosing one of the displayed options. The problem is ...
3
votes
1answer
94 views

Several QGIS layers sharing single shapefile

Is it possible for several QGIS layers to share a single attribute file, but each layer containing a different set of features from that one shapefile based on the value of an attribute?
1
vote
2answers
115 views

Create dynamic layer for each unique value

I'm new to ArcPy. I'm trying to write a script that will loop through the unique values in a field in a FC and create dynamic layers, with definition queries, for each unique value. Each of the ...
0
votes
1answer
29 views

Filter layer by using symbology as a toggle

Is there a way to customize ArcGIS Desktop 10.7.1 so that users can filter layers by simply clicking the layer's symbology in the table of contents?   For example, is there a way to add a toggle/...
0
votes
1answer
97 views

ArcMap layer definition query invalid

I'm using ArcMap 10.6.1 and have 50 layers each with a validated definition query. A typical layer definition query is: autocad_layer = 'Week 25 - Program Element 147.01.23 - 01-06-18'. The data ...
2
votes
3answers
566 views

Creating definition query from selected features using ArcGIS Pro

I have a layer with 2000 or so points, and I selected 50 of them (with no attributes in common, they were randomly chosen). Now I want to make a definition query, so should I will only visualize these ...
0
votes
2answers
143 views

Definition queries in Python Toolbox tools

I'm trying to set a definition query within a Python Toolbox tool in ArcGIS Desktop. The code below works when I run it in the ArcGIS Python window, but does not perform the definition query or ...
1
vote
1answer
36 views

How can I select features with both multiple attributes and NULL values

I'm using ArcMap and am trying to filter a selection from my attribute table that contains both NULL and regular values but it is not working. The query should only select John values with NULL, ...
0
votes
1answer
43 views

Page definition based on name field

I'm a basic user of ArcMap and currently trying to figure out a solution for an issue i'm having with my data driven pages. The data frame layer that I'm using for the data driven page has a field ...
0
votes
1answer
64 views

Making definition query table not blue in ArcGIS Pro [closed]

I am new to ArcGIS Pro. I figured out a definition query but it's making the attribute table blue and it hurts my eyes. I would like definition query tables to be un-colored (white), but I want ...
1
vote
0answers
17 views

Linking Feature Classes between Two Different Map Frames so that Definition Queries in one Frame Apply to Another Frame

In ArcGIS Pro 2.4.1, would like to determine whether it is possible to link two identical feature classes, where feature class 1-1 is in map frame 1-1 and feature class 1-2 is in map frame 1-2. The ...
1
vote
0answers
237 views

Setting up definition query to run through ModelBuilder on ArcMap?

I am trying to make a model that will symbolize data quickly, but wanted to see if a model could perform a definition query or multiple definition queries on a large data set. If this is possible, ...
0
votes
1answer
72 views

Filter layer by pasting in WHERE clause?

I have a web map in Portal that has the Web AppBuilder Filter widget. The map has a point layer in it called Work Orders. I would like to filter the work orders by pasting in a WHERE clause. The ...
4
votes
1answer
82 views

Not able to update the "ACTION" field

Currently I am working on a GIS project where I have to update a field in a layer with some values to get my work done. Because the manual efforts are time consuming hence I added a custom addin to my ...
0
votes
1answer
194 views

Definition Queries for most recent date in ArcGIS Pro

I have a feature class containing sample results for locations that includes thousands of records. Many of these are overlapping and have the same location ID. I need to label each sample based on the ...
0
votes
0answers
100 views

Query returning multiple vehicle_ids when it should only return the top 1

Using ArcGIS Desktop 10.5.1 I have a point featureclass in an Microsoft SQL Server 2012 Enterprise Geodatabase (ArcGIS Server 10.5) that holds MDS (mobility ride share scooter) data. The feature ...
0
votes
1answer
483 views

Updating layer definition query using ArcPy? [closed]

I'm using ArcPy for some automation and I need to update the layer definition query multiple times while running the same script. I've only been able to find ways to update the layer definition ...
0
votes
0answers
64 views

How can I create a layer for each unique field item in a shapefile using Arcpy

#Introduction and imports import arcpy, string from arcpy import env #User Inputs: layer, field name, output workspace (optional) strTargetLayer = arcpy.GetParameterAsText(0) strFieldName = arcpy....
1
vote
1answer
153 views

Definition query not updating [closed]

I have an ArcMap 10.3 MXD in which which I am trying to update the definition query of an enterprise geodatabase layer using Python: import arcpy, os, re from arcpy import env inmxd = r'C:\Temp\...
3
votes
1answer
114 views

Applying Definition Query for multiple features using ArcPy?

I'm trying to apply the following code to extract features that contain these letters 'MW' within the field called 'CODE' for multiple layers. But I'm getting a SyntaxError for line 5 (defintion query)...
0
votes
1answer
151 views

Page definition query not turning layer on and off when driven by Definition Querried duplicate layer of index layer?

I am trying to have some labels turn on and off dynamically with the data driven page being displayed, but it is not working. First, I have a data driven index layer moving from map to map, called "...
2
votes
0answers
72 views

Create filter expression by selected elements?

Is it possible to automatically create a filter expression for the Query Builder by selected elements?
0
votes
1answer
418 views

Using Page Definition Query?

I'm looking to use data driven pages to automate some of my workflow, and I'm almost there for the most part. I have a layer (Chainage - 200m markers along a watercourse) that I'm trying to perform a ...
1
vote
1answer
38 views

Using ArcMap to Query and Display Data? [closed]

I have a large amount of data in Excel spreadsheets. I have been converting that data into Attribute tables to use in ArcMap. The data includes: names of locations geo-location descriptions of each ...
2
votes
1answer
720 views

Adding Not Operator in Definition Query of ArcGIS Pro?

I am using ArcGIS Pro 2.2 I want to apply a definition query saying NOT (name contains 'road%') apparently there is no option to add Not Operator in query neither there seem to be any option ...
0
votes
2answers
190 views

Attribute table in QGIS showing a subset of desired features after query builder

I'm working with some OSM data in QGIS and I want to show only those points that are schools. So I go into query builder and enter "other_tags" LIKE '%"amenity"=>"school"%'. This narrows down my ...
1
vote
1answer
730 views

Selecting multiple values from a string in ArcMap?

I have a text field containing values like "1A,2P,13,17,22,34". I want to select the values that I need by a definition query of a layer. For a single value worked using LIKE and % but I need to ...
2
votes
2answers
409 views

Definition Query - Length of Field

Is it possible to create a definition query that will return a subset of values based on a specific field length? I only want string values where length is less than or equal to 2 characters.
4
votes
1answer
3k views

Using output statistics in ArcGIS REST API query?

I am using an API to pull in some Web Mapping Service Layer data to my script. The API query has a max count limit of 1000 on returned features per request. There are 2 attributes I am trying to use ...
0
votes
2answers
57 views

Data Driven Pages Optimization for the same FC referenced twice

I have a feature class that I am referencing twice in my map, for "active" features that are "the subject" of the map page as a Feature Layer second Feature Layer that is grayed out/"inactive" on ...
2
votes
3answers
452 views

ArcGIS Desktop 10.3 - definition query to exclude integers starting with certain values

I have an integer field in a polygon shapefile that I want to definition query out everything number that beings with 18. These numbers aren't sequential and are of any length, ie I want to exclude ...
2
votes
0answers
46 views

setFilterExpression not giving results because of space?

I am trying to select data based on QgsVectorLayer() getting it's features from layer.getFeatures().next() method. When I pass expression in that using QgsFeatureRequest().setFilterExpression(...
1
vote
2answers
4k views

Using ArcGIS definition query for dates?

My attribute table contains a Start date in m/dd/yyyy format. I would like to build a query that only shows data from current month forward. Does anyone know how to build a query or expression for ...
0
votes
0answers
245 views

Creating script tool for definition query using user input

I have a map document with about 10 layers that I would like to create a query definition script tool to use that takes a user input as a parameter and then executes the tool. The script looks like ...
0
votes
1answer
447 views

Definition query to display only part of layer that overlaps with specific polygon using ArcGIS Desktop

I have a very large roads data set and I would like to write a definition query that displays only the roads that are inside of a polygon. This would make my export to pdf a much smaller file size. I ...
2
votes
0answers
284 views

Current date in query builder Qgis

I'm trying to put a query on a vectorlayer with the current date. The following code works, but I want the current date to be dynamic: cast ("Starttijdstip" as character) < '2018/03/01' AND '...
2
votes
1answer
274 views

Using min-max functions in definition queries of feature services

Using a feature service from ArcGIS Online, I would like to display a record wherein one of its attributes is the max of the entire records, but is unable to do so. If I am using a Feature Class from ...
1
vote
1answer
45 views

Removing select rows from display without removing from layer?

I have a layer with a field of image_quality that is marked either good, fine or poor. I also have 4 fields for sediment type: mud, gravel, boulder, outcrop. I want to display the sediment types ...
0
votes
1answer
92 views

Joining a queried table to a feature class

I have a table in a geodatabase that I would like to join to a feature class. The table contains well locations with multiple sample dates and associated data, however, I am only interested in sample ...
-1
votes
1answer
204 views

In ArcMap my Definition Query is removing all records but categorizing on symbology works properly

I have a definition query to filter an attribute in a feature class, the Attribute is joined to the dataset being queried from an Access MDB and is data type SHORT, the values it contains are 1,0, &...
0
votes
1answer
428 views

ArcMap definition query for a string contained in a longer string not working

I am trying to query records that contain a specific string within a longer string of an attribute table but it is not working. There are a few extra details to the situation. DQ is going onto a ...
0
votes
1answer
1k views

Setting simple definition query using ArcPy?

I am trying to set a definition query on a Application Lands layer in my project.mxd using arcpy. But it's not working for me. When I launch the project the query is in there but it doesn't get ...
0
votes
0answers
149 views

Customizing complex layout with data driven page?

Main Conditions: It should be in one MXD document. What i have: 1 line feature (with definition queries), 1 polygon feature (with definition queries) this is one as example in fact number of layers ...
0
votes
1answer
39 views

Definition query on GDB annotation file- ArcGIS 10.3.1

I convert Cad annotation from Autocad, into GDB annotation using "import cad annotation" tool and this part of a big attribute table: The "TextString" is the field i need to present on my map, but ...
-1
votes
1answer
1k views

Apply Definition Query to multiple feature classes using python [closed]

I'm trying to create a python script that'll apply a definition query to all 5 feature classes. Each feature class is a condominium floor footprint called "Condo_1st_level", "Condo_2nd_level", etc. ...