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

4
votes
1answer
71 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
43 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
65 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
21 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
48 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
44 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
40 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
151 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
135 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
45 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
47 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 ...
2
votes
1answer
124 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. ...
1
vote
1answer
59 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
128 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
40 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
92 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
69 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
64 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
272 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
229 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
526 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
135 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
214 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
324 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
280 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
194 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
215 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
59 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
210 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
2k 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
182 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
74 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
724 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
369 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
179 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
108 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
196 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
438 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
602 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
305 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
187 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
191 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
558 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 ...
2
votes
1answer
712 views

Passing Python List into Layer Definition Query

I am trying to cursor search through items in a field in a feature class. I then append them to a list called 'distList'. I want to pass the list into layers definition query as follows: "Field1" in ...
3
votes
1answer
2k views

Python Add in: Pass Selection from Combo Box into Definition Query

I am trying to pass the users selection into a definition query in an addin combo box python script. Basically, I have a feature class with a field called "SITE". I build a python list from that ...
2
votes
1answer
212 views

Using definition queries for scenario testing in ArcMap

I want to be able to run multiple scenarios in a typical ArcMap workflow. This will include making edits to feature classes, such as removing features, adding new features, or changing feature values ...
1
vote
1answer
3k views

add definition query to layers in a group

I'm trying to develop a python code that will apply the same definition query to all layers in a specified group. I currently have a working code that will apply a definition query to all layers in ...