The selection of data from a database based on some criteria.

learn more… | top users | synonyms

14
votes
3answers
11k views

Including variable in where clause of arcpy.Select_analysis()?

I am trying to loop through a shapefile, selecting each feature in turn and copying it to a temporary shapefile to by included in a union analysis. I'm using a cursor to find the ID name for each ...
16
votes
2answers
10k views

Getting list of selected features in ArcGIS for Desktop using Python code?

I have a question regarding selections in ArcGIS for Desktop. Assumed I have one layer in ArcMap and I have selected two of five features. Is it possible to get a list of all selected features by ...
15
votes
7answers
29k views

Select distinct values from a single column of an attribute table (or layer)

Is there a way to select distinct values from a column in ArcMap? I have the data in both GDB and SHP formats. I have searched for ways to select using SQL, QueryLayers, ModelBuilder and individual ...
15
votes
3answers
5k views

Quickest way to select ArcSDE polygon by point in ArcGIS Desktop using ArcPy?

I keep thinking that I must be missing something, but there does not seem to be a tool in ArcGIS 10 to select features (in particular polygons) from a layer at a point (X,Y) location via ArcPy. The ...
10
votes
1answer
3k views

When iterating over a vector layer with pyqgis, how do I check whether a feature is selected?

While iterating over a vector layer using the following code (summerized from the example in the pyqgis cookbook), is there a way to check whether a feature is selected? provider = ...
2
votes
1answer
810 views

Select top 5 most items in a geodatabase

I'd like to know what is the best way to select the 5 most expensive items (in terms of actual monetary value) in my geodatabase where i have a price field. Prices are not necessarily ordered but can ...
0
votes
1answer
83 views

Creating Layer for Selected Features, then Moving it using ArcGIS for Desktop?

I have a frustrating problem with ArcGis 10.1. I rarely use this so don't really understand what is wrong. In an edit session I select a polygon. I would like to 'Create Layer for Selected Features'. ...
3
votes
3answers
2k views

Missing tools (icons) QGIS

I lost selection and navigation tools from the GGIS 1.8 toolbar when I tried drag then to different place. I can't get them back anymore. Where they disappear? All these tools are checked but are ...
12
votes
2answers
6k views

How to display only selected features on map?

Not sure if this option ever existed, but the new QGIS version hides a lot of things somewhere else and this seems so simple that I'm kind of convinced it was possible to do this before. I have quite ...
3
votes
2answers
416 views

Listing features in the order they were selected

This is an ArcObjects-specific version of this question: Create Array From Selected Features Based on the Order in Which They Were Selected Is there a way to get the selected FIDs of a feature layer, ...
3
votes
3answers
1k views

How to select features with NULL Geometry from Shapefiles?

I have been given a Shapefile that contains records with NULL geometry, along with records with non-NULL geometry. This situation appears to cause problems in QGIS (1.8 and 2.0) when editing the ...
1
vote
2answers
7k views

OpenLayers Select a feature from attribute or id

Using Openlayers.....Is it possible to select a feature on a map by an attribute? eg: Select a feature from a dropdown menu populated with the feature "id" or a table field attribute values.
1
vote
1answer
309 views

Why does this SQL syntax produce empty feature class with ArcGIS Select_analysis?

I'm working on a script that involves an arcpy.select_analysis function. The problem I have is that when I run the script it produces an empty file. I've verified that the whole thing works when in ...
0
votes
1answer
117 views

How to select landlocked countries in Africa using Select By Location?

I wish to select the landlocked countries in Africa using just Select by Location. I have already dissolved the boarders to get one big polygon and I thought I might combine these two telling ArcGIS ...
28
votes
3answers
2k views

Is there a “Select by Attributes” plugin/widget for ArcGIS Server JS API?

I'm hoping to find some existing code which emulates the "Select by Attributes" dialog in ArcMap, within the ArcGIS Server JavaScript API. Writing a hard-coded QueryTask is easy - I'm looking for ...
5
votes
2answers
1k views

How to detect duplicates and keep only one?

I've got a table with lots of points (200.000). Some of them are duplicates (not exactly but e.g. a metro station has eight entrances) and I want to keep only one of these metro entrances. I am able ...
4
votes
1answer
373 views

Set selection color transparent and border color red in QGis using python

I have a layer with different informations. I want to change the selected polygon color to "Transparent". I am able to achieve that using: iface.mapCanvas().setSelectionColor( QColor("Transparent") ) ...
3
votes
1answer
1k views

How to select features using an expression with pyqgis?

How can I select features with pyqgis using an expression? I tried to use an QgsExpression but the select method doesn't take it: exp = QgsExpression("'ogc_fid' = 482") cLayer = ...
3
votes
3answers
800 views

Select “interior” lines of a polygon-to-line layer

I have a polygon featureclass that has adjacent features. Using Arc10, I am turning those polygons into lines using the "Featureclass to Lines" tool. Now I would like to select ONLY THE INTERIOR ...
1
vote
1answer
1k views

replacing dijit.ComboBox with dijit.Select results in error (ArcGIS Javascript API)

I am currently populating a Dojo ItemFileReadStore with the results of an ArcGIS query (Javascript 3.4 API), which is then passed to a Dijit COmboBox. I am now having problems with the ComboBox in iOS ...
7
votes
2answers
8k views

How can I unselect a feature in Openlayers?

I am able to identify the selected features on my map using the following line: vector_layer.selectedFeatures I would like to be able to deselect this feature using a standalone function (not an ...
3
votes
1answer
209 views

Selecting limited TOP n from specific column in ArcGIS query builder?

I'd like to know what is the best way to select a limited top 'n' of rows from a specific column of a geodatabase file. Currently I use a function in the query builder of the select tool (arcgis10) in ...
2
votes
1answer
88 views

Selecting features based on similar name

I am building a script to integrate into a model that iterates through data. I've been able to get two submodels to iterate through the original data and create large numbers of features in file ...
2
votes
2answers
860 views

Selecting Part of a Polygon

I have a dataset, in shapefile format, for agricultural land grades in England. It is divided into 7 categories in its attribute table. As the file is a large file and I only want a small section I ...
1
vote
2answers
114 views

Select feature one by one not working in pyQGIS?

I have used following code for selecting the features one by one. but when i run the script it is just selecting last feature and zoom it. I want to select each feature and zoom it. def ...
1
vote
1answer
99 views

Communicate relation between two table

At this time, I'm able to create a relation (1:M) between two table or geometries. After, I user Identify tool to exploit the relation. It is only possible to use this feature when your Identify tool ...
1
vote
1answer
787 views

Batch export all layers in ArcMap document that have selected features?

I have several layers in an ArcMap Document. All of these layers are stored as shape files. Specific features of the said layers are selected. I want to export the data as shapefile programatically. ...
1
vote
0answers
105 views

Does QGIS have a dynamic spatial join select tool, equivalent to MapInfo Boundary Select?

I´m a MapInfo user, I´ve gone over to QGIS and it´s got a lot going for it, except for some simple features from MapInfo I just can´t do without. One such is MapInfo Boundary Select, which is a basic ...
1
vote
1answer
944 views

How to add item to an existing selection layer

I have a selection layer of about 150 properties in ArcGIS ArcMap, and I want to add one more building to it (see image, area outlined in red circle). The problem is that I missed this building in ...
1
vote
1answer
245 views

Select point with highest value within a buffer

I work with ArcMap 10.2.1 and I created buffers around points. Some buffers contain many points and others just one. I would like to select one point for each buffer, but the points can represent ...