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
1answer
56 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
49 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
28 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
145 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
75 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
49 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
78 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
0answers
25 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
56 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 ...
0
votes
0answers
46 views

ArcGIS creating individual layers for unique attribute in a given feild. Limitations of Where Clause

I am putting together some code that makes a layer for each unique attribute within a given field. So if I had a shapefile that contained point data for locations of say postboxes in every city , for ...
0
votes
0answers
41 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
168 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
154 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
51 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
51 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 ...
3
votes
1answer
157 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
1answer
67 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
143 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
45 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
98 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
72 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
65 views

Definition queries deleting themselves in ArcMap10.2

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
317 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
240 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 ...
1
vote
1answer
611 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
141 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
229 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
366 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
304 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
205 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 ...
0
votes
2answers
229 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
60 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. ...
2
votes
1answer
216 views

Using PostGIS functions in ArcGIS Desktop for Layer Definition Query?

I am connecting ArcGIS Desktop 10.2 to Postgis 2.0.3 with PostgreSQL 9.2.4. No SDE. I can load data with no problems and access the data in ArcMap. However I can't seem to use PostGIS functions within ...
2
votes
3answers
3k views

How to set Definition Query on ArcPy layer from shapefile?

I'm trying to determine options to set a layer definition query using ArcPy. I know that it is possible when using arcpy.mapping.ListLayers(). However, in this scenario I am loading in ...
2
votes
1answer
194 views

Area of polygon split by a line

I need a query that return the area of two polygons that have been split by a line. This is what I did so far: SELECT ST_Area(ST_Split(surface.geom, limite_a.geom)) from surface, limite_a where ...
1
vote
0answers
76 views

How to create a startup prompt that populates definition queries on multiple feature classes

I would like to create an ArcGIS start up prompt or custom button that asks for a user's initials and then populates multiple feature class & layer definition queries. More specifically, I would ...
1
vote
1answer
764 views

Change Defination query of a layer in ArcGISDynamicMapServiceLayer

Is there any solid example to change the definition query at run time of the ArcGISDynamicMapServiceLayer using javascript API 3.5 or higher version and ArcGIS server 10.1. I found API documentation ...
5
votes
3answers
383 views

How can I parse hundreds of *.lyr files for their Definition Queries?

I have ~600 lyr files that reference a table on an SDE database that has about 20,000,000 records. Some of these *lyr files have an incorrect definition query applied or is missing the query ...
0
votes
1answer
190 views

How to filter shapefile using definition query?

I have a point shapefile which I want to interpolate using IDW interpolation. However, I want to interpolate only those points which satisfies a certain condition. I need to do it in python and I ...
1
vote
0answers
109 views

“Definition Query on a versioned Geodatabase”

I would like to implement Specific views to the SDE users, based on Definition Queries of common attributes , like Date created > = October 1. But on first look, the definition queries are for ...
1
vote
3answers
2k views

How to create Definition Query tool in ModelBuilder that uses in-line variable?

I'm having trouble using an in line variable derived from the Parse Path tool in ArcGIS ModelBuilder to create a definition query for a layer file. I'm importing an xyz file to a feature class, and ...
1
vote
1answer
1k views

What is ArcGIS 10 definition query to select max value from table? [duplicate]

I want to select max date from may layer by below query in my Web GIS but I cannot. (SELECT MAX( GregorianDate ) FROM DrillingProgress WHERE Crew = 'c-Chabock')
1
vote
0answers
202 views

Can ModelBuilder be used to export different versions of the same mxd with various constraints?

I am currently trying to use modelbuilder to go through each row in an attribute table, select the streets that intersect the polygon (which is the row in the attribute table), zoom to the selected ...
1
vote
1answer
444 views

Migration from .gdb to .mdb - how to change automaticly all querys at MXD from “ ” to [ ]?

after migration from File Geodatabase (.gdb) to Personal Geodatabase (.mdb) - how to change automatically all field names at query definitions at the MXD from " " to [ ] What's else is important ...
2
votes
1answer
1k views

Can ArcGIS 10.1 use SQL on Definition Query to select minimum value?

In ArcGIS 10.1 I am trying to do a Definition Query that will select the records that are the min values from a table. I try a lot of type of query like and it still not working. Name table is ...
0
votes
2answers
637 views

How do I filter unique values using a definition query on a File Geodatabase?

Is there a way to filter unique values only from a column in ArcMap using definition query? i.e to use a Definition Query to filter out just those values which occur only once. In a Personal ...
5
votes
1answer
314 views

Can I edit shapefile while using a definition query in QGIS? [duplicate]

Is it possible to edit shapes while using a "definition query" or "query builder" in QGIS? I'm trying to do this in the same way I used to in ArcGIS. Thanks!
2
votes
1answer
196 views

Is it possible to perform a definition query against a Polyline shape field?

I have joined two polyline shapefiles together that represent two months worth of data. I'm now trying to find any changes to the shape of the records between the two months (added vertices, deleted ...
3
votes
1answer
193 views

definition query and mosaic dataset from gdb ArcMap 10.1 SP1

I have a Python AddIn Combobox to select a value from the drop-down list. This value changes the definition query of the layers in mxd. This works fine for "normal" feature classes, not for a mosaic ...
5
votes
1answer
570 views

Why does updating Definition Query on layer in ArcGIS 10.1 SP1 no longer allow access to all unique values in dataset?

In ArcMap 10, setting a definition query on a layer would display only the subset of features: To add more features to the query would simply involve clicking Get Unique Values to list all the ...