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

learn more… | top users | synonyms

0
votes
2answers
23 views

Transparency to unique value in ArcGIS 10.3

I have this polygon layer and i try to set the transparency to 52% only to the c value: but when i set to 52% transparency, all the values changed: I can copy\paste the polygon and remove a,...
1
vote
1answer
27 views

Querybuilder in QGIS-->select features in a shp-file, which touch others

I have a ESRI-shp-file called veg.shp and the field BYKP. Is it possible to make a query within the querybuilder and select all polygons with the beginning attriubte "F" and the second condition where ...
-4
votes
1answer
59 views

Help with definition query [closed]

I have a layer of 5ft contour lines, and it includes a field called "Elevation" that has the elevation of that particular line in feet, (ex: 1555, 1560, 1565 etc.). I want to only show lines for every ...
4
votes
1answer
45 views

Is it better to use a single layer with symbol classes or multiple layers with definition queries?

I use symbology classes to display my data most of the time. I think I have noticed a performance hit when using symbol classes on large datasets, although it might just be in my mind. That got me to ...
1
vote
2answers
50 views

How to specify two different and separate conditions in query builder?

For example, I have a table containing well log data for multiple operable units. I would like to make a query outputting a table where Operable unit=001 OR 002, AND Formation= Residuum. I would ...
4
votes
1answer
107 views

Using Not Equal to Wildcard in ArcMap Definition Query?

I'm attempting to use a definition query in order to display only a subset of data. I have a large CAD drawing that I have imported into my map. I do not need many of the lines from the .dwg file to ...
2
votes
1answer
74 views

Create Layer With Selected in QGIS

Came across this "Create layer with selected" button in the result for a Spatial Query in QGIS. And simply, this creates another layer from the same source with a query on the IDs. Does anyone know if ...
3
votes
1answer
59 views

SQL check if first value in line is number

In the layer definition query in ArcGIS 10.4 I want to only use objects that look like 1/12 Main Street 12-2 Side Street etc and not ones that have Main Street Side Street Is this possible? So ...
10
votes
3answers
150 views

Querying for underscore character in ArcMap?

For a standard LIKE query against an Oracle-based ArcSDE feature class, the underscore character represents a single character wildcard when used with a string. I'm trying to impose a definition ...
0
votes
1answer
65 views

Hardwire definition query on layers in mxd VB.net

I am creating a tool that applies definition query to certain layers of the mxd. The user clicks the button and it should hardwire the definition query into the layer. This is useful if there are many ...
8
votes
1answer
151 views

ArcObjects with Left Join

I'm expecting an ArcObjects code which is equivalent to SQL left join. For example: I have the below SQL code, it's simple join to fetch the records from the both tables based on the ChecklistId ...
2
votes
1answer
56 views

Creating definition query on layer excluding decimal values in ArcGIS for Desktop?

I am working on a layer of spot height in ArcGIS 10.3. The attribute table of this layer contains a field called 'Elevation' wich one provide the altitude of these spots height. These values can be ...
1
vote
1answer
80 views

Set up definition query with variable

I am writing a script which supposed to get a value for a field from user and use that value for a definition query. If I write it without variable, it works: my_Layer.definitionQuery = "...
2
votes
1answer
158 views

Updating ESRI mxd definition query variable via python?

we use definition queries to filter data to field users. We have up to 40-50 MXDs that are identical except for 1 variable in the definition query that allows the data for that MXD to be unique. ...
1
vote
0answers
44 views

if column name = this, then search for a row >0 and change symbol, in QGIS

Excuse me as I am new to GIS. I am using QGIS to do two things. Firstly, from a csv master file, I have plotted points on a map based on their geo-reference and graduated their colour based on the ...
1
vote
1answer
140 views

Only displaying polygons over certain size in ArcMap using Definition Query?

I have a polygon containing lots of bodies of water and only want to display the bodies of water over a certain size. Can I do this using a definition query?
1
vote
2answers
117 views

Definition Query on a Dynamic Mapping Service?

Will a definition query hinder performance of a dynamic mapping service or will it speed up performance? Using ArcDesktop 10.3.1 and ArcServer 10.3.1
0
votes
0answers
46 views

How can I “filter” annotations when another layer has a definition query applied?

I have an ArcPy script that runs on a map, looping through a list of asset IDs, to create a definition query for layers and outputting a PDF map for each ID. Thus, each PDF shows only the assets ...
2
votes
2answers
198 views

Graphic clipping of Data Driven Pages to index feature that defines each page?

I wonder if there is a way to cut all the data in each polygon separately when using data driven pages?
0
votes
1answer
1k views

Applying a definition query to date field for feature in file geodatabase

Is it possible to apply a definition query to show data for today, yesterday and two days ago for a field where the data type is 'Date'? I have a script that downloads MODIS fire data and wish to ...
1
vote
0answers
96 views

Definition query to extract last updated record

I am struggling to build a definition query using ArcGIS to select last updated record in relation to unique CADID (core data example below). CADID is unique, updates recorded additional record in ...
1
vote
1answer
177 views

Using definition queries in GeoMedia Professional?

Does anyone know if GeoMedia 6.1 Professional has a selection feature that is equivalent to ESRI's ArcMap Definition Query function or anything similar to it?
2
votes
1answer
437 views

How to make SQL definition query in ArcGIS to show only unique values (hide duplicates)?

I have a vector file with field of type LONG. Some values of this field are duplicates. Is it possible to make such SQL definition query in ArcGIS 10.3 to show only unique values without duplicates? ...
4
votes
1answer
151 views

Automatically create new layers from a single dataset using definiton query for unique values in a field

I would like to automatically display a featureclass as different layers based on a specific field. I've seen a few tools online and on XToolsPro under the category of Split by Attributes, but they ...
0
votes
1answer
109 views

Definition Query to find next date value in ArcSDE attribute table?

I have an ArcSDE feature class that contains a date field called "SALE_DATE". This sale date represents the bid date for ALberta crown mineral rights sales. A sale occurs about twice per month (one ...
2
votes
2answers
179 views

definition query with 3 plus variables to loop with python and save layer files

I have a script that takes an input feature class and uses a field within this class to create a definition query for each unique field. A question on how to do this is listed below saving layers for ...
0
votes
1answer
29 views

Will replacing workspace path affect definition queries in Maps or Layer Files?

I am doing a cleaning up project for some of my data. This requires a data structure. That means I will have to replace the workspace path in the MXDS. The old structure of the data will be ...
2
votes
1answer
162 views

Setting Two Definition Queries as Parameters in Python Script tool causes: RuntimeError: LayerObject: Set attribute definitionQuery does not exist

I created a script that adds definition queries to every layer in an mxd depending on the layer name. This worked fine as a stand alone script, but when I try to use it as a script tool with arcpy....
0
votes
0answers
64 views

how to get the features of a definition expression without having to project them on the map

I want to perform a definiton expression on a feature layer and get the graphics/features. If I set the visibility of the layer to false, the features cannot be retrieved. Is there any way to get the ...
2
votes
4answers
620 views

Definition Query expression limits in ArcGIS 10.2.2

I have a large database in ArcGIS 10.2.2, with over 2 500 000 point vectors. Each point has a unique number code. I want to spatially subset my data, so that I can extract only points with a specific ...
1
vote
2answers
485 views

Definition Query to hide attribute data

SQL help please! I've tried searching, but can't find the help I need. This is for ArcGIS Advanced 10.2. I have a parcel layer with all kinds of info that the general public shouldn't be able to ...
0
votes
1answer
101 views

Autopopulated combobox value passed to definition query - results won't display on map

I have a dojo combobox that is populated with unique values. The user chooses a value, and the value is passed to a definition query, and the results displayed on the map. I can't get the results to ...
0
votes
1answer
98 views

Page definition query not updating graph in layout

I have three graphs in my layout created from feature classes which have Page Definitions set to reference a data driven page. The table of each feature class shows the correct number of features as ...
4
votes
1answer
712 views

Definition Query Current Date SQL Server Native Syntax Error 10.2?

I have this definition query that worked for a layer from a file geodatabase. Now the same query will not work from the same layer in an SDE. I am getting a 'SQL Server Native Client Syntax' error. ...
2
votes
2answers
296 views

Definition Query with Current_Date?

I have a date field called ExprDate and I want to set a definition query to select all records from today's date plus the next 7 days. This is what I have: ExprDate >= CURRENT_DATE +7 The ...
1
vote
1answer
318 views

Creating layers using definition query for each field in ArcPy?

I have a shapefile that contains a text field "Company" that i would like to use to run a definition query to create a layer file. I want to be able to create a layer for each company. I had a look ...
1
vote
1answer
75 views

Using MOD within a GROUP BY subquery on point dataset

I have a dataset of 200 points (in shp/f gdb/p gdb format) in ArcGIS. I am trying to use the MOD() function within a GROUP BY subquery as a definition query on the layer to thin out the data. What ...
1
vote
1answer
165 views

set definition expression based on slider values

Using the Esri JavaScript API I want to control the set.DefinitionExpression values based on a user controlled range slider. The data is loaded from REST as ondemand using: var POP_Total = new ...
1
vote
1answer
103 views

Why does my modulo expression return no results?

I have a big set of contour lines with 5 m and 10 m stepping from an ArcGIS File Geodatabase (wasn't a shapefile, as previously stated). From time to time I need to modulo out the 5 m lines in the ...
3
votes
0answers
79 views

Definition queries deleting themselves in ArcMap? [closed]

After switching to ArcMap 10.2 I've noticed that my definiton queries will seemingly randomly remove themselves. I have no idea what triggers the deletion since I have noticed it after reordering ...
0
votes
1answer
1k views

Exclude Values, including null, using Query Builder

I'm looking to exclude any streams that have values of "NULL" or "NP" using an SQL query in ArcGIS 10.2. I've tried expressions like: WTR_NM NOT (NULL, NP) WTR_MN is the Field Name and I'm trying ...
10
votes
3answers
506 views

Using Label classes vs Definition queries - which performs the best?

Which would provide the best performance for working within ArcMap with very large datasets stored in an ArcSDE geodatabase? Multiple label classes using complex SQL queries to label specific features,...
2
votes
1answer
4k views

Definition Query to exclude certain values and return remaining values

I have been trying to create a Definition query to symbolize a set of water features. I cannot edit the .shp file and I want to exclude a multiple values. I have tried using NOT but have had no luck. ...
2
votes
1answer
272 views

Model Builder Query by date

I've created a model that does several spatial joins based off of a lat/long in a table. In the table, I have a "Modified_date" which gives year, month, date, time. This model is set to run ...
0
votes
0answers
375 views

Layer Definition Query - Subqueries

Background: I want to track the movement of icebergs in ArcGIS. In my FileGeodatabase I have a single Iceberg layer. What I have thought of is to create an ID field for each object; each ArcGIS ...
2
votes
2answers
728 views

Definition Query / SQL problem in ArcGIS

I have been working on some Definition Queries for layers in ArcGIS (10.2.0.3348). The layers connect to data in a File Geodatabase. Now I have attempted to implement the following query (1), that ...
2
votes
2answers
474 views

Create a web application with ArcGIS Server

I have a question about ArcGIS server: I want to make an application for users who can search for proper houses, like a house-finding engine, and I published my map to ArcGIS Server but how can I ...
0
votes
0answers
327 views

How to highlight and zoom to features after applying a definition query programmatically in Arcgis silverlight api

A definition query is applied to a bunch of layers after a user queries for a feature( with an ID). The def query is applied but I'm looking for a way to highlight those features that are a result of ...
1
vote
2answers
404 views

Creating new layers using ArcPy to define Definition Query for each field value?

I am trying to set multiple definition queries for one layer based on one field using python. ie. I have a City layer with a field that holds the city name. I want a copy of the layer in an MXD ...
0
votes
1answer
61 views

Def Query to not display feature if it isn't attributed

I have a bunch of features that I don't want to keep checking if something is attributed. I I want to query it out to not show the geometry if a column has the default string 'NOT ATTRIBUTED' to it. ...