Tagged Questions

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
22 views

Exclude Values in Query Builder [closed]

I'm looking to exclude any streams that have values of "NULL" or "NP" I've tried expressions like: WTR_NM NOT (NULL, NP) WTR_MN is the Field Name and I'm trying to remove the unnamed streams
10
votes
3answers
147 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
71 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
57 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
67 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
96 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
83 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
47 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
1answer
70 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
0answers
39 views

How can I correctly delete a join from featurelayer using arcobjects?

If I create a join using ArcMap dialog definition query can be changed if joined layer contains a definition query. For example, layer A has definition query "A", layer B has definition query "B", ...
0
votes
1answer
47 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
122 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 ...
0
votes
0answers
62 views

Combo Box selection to definition expression

Using ESRI JavaScript API I would like the pass the selection in a combo box to the setDefinitionExpression. I think this should be possible, but I am not sure of exactly what to do. The code that ...
2
votes
3answers
773 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
108 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
65 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
419 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
250 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
127 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
91 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
994 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
739 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
144 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
287 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
777 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
349 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
214 views

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

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
132 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
159 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
467 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
594 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 ...
2
votes
1answer
1k 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
200 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
2k 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 ...
6
votes
1answer
567 views

PostGIS query vs QGIS filter

I have a PostGIS dataset with around 3 million shapes. I only need to view about 1,500 of these shapes at any given time, but the shapes I need to see depends on which feature is selected in a ...
3
votes
1answer
1k views

ESRI File Geodatabase - Trying to use CURRENT TIME in Definition Query

Is it me, or are the date functions in the file geodatabase a total nightmare. Anyway, I am trying to set up a fairly simple definition query that contains a subquery with a date comparison. My ...
4
votes
2answers
2k views

How do you construct a definition query to return only those features in the current month without hard coding the date?

I have a feature class containing a date field within a 9.3.1 File Geodatabase. There are "duplicate" features contained within this layer, one feature for each month over the past few months. ...
8
votes
1answer
729 views

In ESRI ArcMap, how do I refer to NaN or ±∞ (special floating point values) in definition queries?

I have by chance discovered how ESRI ArcMap displays special floating point values to the user. +∞ (positive infinity) is displayed as 1.#INF –∞ (negative infinity) would supposedly be displayed as ...
2
votes
1answer
229 views

Is there a way to delete definition querys of multiple layers in ArcMap 9.3.1?

I'm searching for a way to freeze/delete definition queries of several layers at once (instead of doing it manually by opening the properties of each layer). I'm working on a SDE 9.3.1 Geodatabase.