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

learn more… | top users | synonyms

2
votes
1answer
162 views

Select features empty OpenLayers 3?

I created in OL3 selector elements new.ol.interacion.Select () on a WFS layer, and when I try to take these features returns an empty array. My intention is to create a json with the selection check ...
4
votes
1answer
530 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
0answers
87 views

Select by expression doesn't work - QGIS [closed]

I want to make a "selection by expression", as shown on the screenshot. I choose the FIELD and the VALUE from the side panel, but it's selecting 0 rows (there are actually more than 100...). I ...
1
vote
1answer
115 views

Why is select features button not working in ArcGIS 10.3?

Every time i opened a mxd file (in ArcGis 10.3) the default of most of the layersis in "Not Selectable". I search a way to change the default in the table of content ,so all the layers will be always ...
0
votes
1answer
39 views

ArcGIS Select largest N rows in group

I have feature class (Name: V1) in personal geodatabase with columns: Height [float] and Id [int] representing group number I need to do SQL query that will select eight highest 'Height' values in ...
15
votes
7answers
31k 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 ...
2
votes
1answer
866 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 ...
1
vote
1answer
54 views

Selecting Minimum values from in_memory dataset!

I am trying to select the minimum value from a data set being stored in the in_memory workspace. This prevents me from using sub-queries. I'm hoping that someone has found a work around for this issue ...
0
votes
2answers
300 views

Best Way to Get a List of Selected Rows for a Specific Layer using Layer Object in ArcGIS

What is the fastest/cleanest way to get a collection of rows that are selected in a certain layer? For some background, I am trying to hide selected features in a specified layer. The solution ...
1
vote
1answer
70 views

How to select attributes by unicode field value?

I have an attribute table in QGIS 2.10 with a string field (myfield) and when I want to make a selection based on the unique values of this field I get no selection at all. >idxmyfield = mylayer....
4
votes
1answer
97 views

Select feature one by one and save it as image

I have used following code for selecting the features and save it as image. layer = self.iface.activeLayer(); layer.setSelectedFeatures([]) count =layer.featureCount() lstChalta = [] lstFeatures = ...
1
vote
2answers
136 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
125 views

Deleting selected features with ArcPy?

I am having trouble deleting the features I have selected using 'arcpy.SelectLayerByLocation_management' tool. To use the select layer by location tool, you much pass in a .lyr file. My script ...
0
votes
0answers
37 views

Looping all features of cursor onto SQL Server feature class?

It might be me but I've been experiencing something weird. (I actually tried what suggested in this thread Arcpy MakeFeatureLayer won't loop with no luck) What I'm trying to accomplish is to use ...
2
votes
2answers
129 views

Selecting Polygons that have certain raster data within them

I am using a raster layer with either 1 or 0 in each cell. On top of this layer, I have a European countries shape file. The countries that contain a '1 cell' in the raster beneath are the Countries I ...
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 ...
0
votes
1answer
233 views

Arc Map 10.1 Identify tool

I'm trying to identify features from multiple layers. For example, I have many locations around a river (within a 100 m buffer) which I would like to identify, but instead of having to draw rectangles ...
7
votes
1answer
246 views

How to select features based on multiple values in graphical modeler?

I'm trying to create a basic model using QGIS, the QGIS graphical modeler and the sextante toolbar. In part of the model, I need to select features based upon multiple attribute values (for example - ...
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
119 views

List Attribute values selected by location

I would like to get a list of road features that intersect every county in a state and output it as CSV or Excel. Ex: county A intersect the Road Names a b c county B intersect the Road Names e ...
0
votes
0answers
20 views

How Show shp Selected [duplicate]

I need help with code to know if a SHP a MXD this selected or not. I have the following code which only shows me all shp'sy layers are in the layer , I need a list if there is a selecionado shp, ...
1
vote
1answer
31 views

QGIS 2.8 Change Colour of Selected features [duplicate]

How can I change the colour of the selected features in QGIS. The light yellow is not easy to see.
2
votes
2answers
113 views

QGIS Select double feature by attributes

There is this point shapefile in QGIS (2.12). There is one column with the street name and one with the housenumber. Is it possible to select all features that have the same street name and ...
3
votes
2answers
82 views

Copy/convert selection into filter/query builder of QGIS?

Can anyone tell me if it is possible (and how) to convert or copy a selection on a layer (that has not been created through "select by expression", but instead by irregular selections from a canvas, ...
14
votes
3answers
12k 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 ...
0
votes
0answers
10 views

Using predefined variables in whereclause? [duplicate]

Can't seem to figure out how to use variables for an SQL whereclause in python. e.g. want to select_analysis(layer, "new sel", field = attribute) with field and attribute being predefined by user ...
2
votes
1answer
95 views

Attribute Table Window loses highlighted selection after Addin is Opened

I'm so new to GIS that this question might seem dumb to a lot of GIS Developers. I have taken over a project that is an AddIn for an ArcGIS Desktop app. C# VS 2010 project. I can get the Selected ...
1
vote
2answers
76 views

Variable Expression In ArcGIS

I am creating many models doing many tasks. Basically, the first model will join 2 tables and the steps are as follow: make table view for each table, then add join for, then it will copy the rows for ...
2
votes
1answer
4k views

Activating and deactivating of button control not working properly

I have got two buttons, one for editing purposes and one just to see all the information related to the polygon I selected. Also I added these two buttons on my panel using OpenLayers control. I am ...
3
votes
2answers
4k views

Selecting features through ArcPy gives Assertion Error?

I would like to achieve the following functionality through arcpy: Querying an existing baselayer on time and create a new layer Apply symbology from an existing layer and add the new layer to the ...
3
votes
1answer
80 views

In ArcGIS 10.x, how do I select features of a point shapefile whose z values are above or below the elevations in a DEM?

I have a multi-point shapefile representing earthquake hypocenters (containing depth values) and I have a DEM raster representing an underground surface (the top of the PreCambrian basement). I want ...
2
votes
3answers
468 views

javascript function to search all OpenLayers vector features covering a pixel

I have an OpenLayers map that draws features in a vector layer. The features are selectable and have a popup on select. Unfortunately in a lot of cases the features overlap so it can be impossible to ...
3
votes
3answers
203 views

How can I select “ultimate perimeter” from a group of connected lines?

I have a number of drawings which I converted into geodatabase feature classes. Most drawings are composed or connected 3D polylines from which I want to construct TIN surfaces and multipatch ...
1
vote
0answers
42 views

Is there a way to select polygons by geometry (right angle)? [closed]

Is there a way to select polygons by geometry? I need to find a way to detect all the polygons that have a right angle, but I can't find a tool that can do that. I'm using QGIS 2.10.1 and ArcGIS ...
2
votes
2answers
294 views

Selecting features within polygon from another layer using R or Python?

For Selecting features within polygon from another layer using QGIS? the solution was to: use the "Vector->Research tools->Select by Location" However, I would like to know how to do the same ...
3
votes
1answer
801 views

Select Features returns There was error executing query in ArcMap when using OLE DB connection?

I have a spatial enabled OLE DB Provider corresponding to OGIS simple feature specification for OLE/COM revision 1.1 I can add spatial data as ArcMap layers successfully using this provider and by ...
0
votes
4answers
191 views

arcpy interate row, in a python script? SQL Select expression not working

I am creating a python script where I am trying to iterate over point feature class. I want to create seperate Feature classes from each individual day. So select daynumber and then export it to a new ...
1
vote
2answers
91 views

Switch selection of specific polygon

I'm using ArcGIS 10 desktop version. I have a number of polygons, let's say 300, in a layer. Each polygon contains information of schools, ranging from 100 to 250 points, in a separate point layer. ...
1
vote
2answers
358 views

How to pass only selected features in python toolbox

I have a feature class in a file geodatabase. I want to select features from the feature class and export their attribute to an excel sheet. I need a python tool in ArcGIS which does this. My problem ...
1
vote
1answer
71 views

Is there any way to select only the layer of which the features have been selected?

Is there any way to select only the layer of which the features have been selected? That is, if I have selected some roads then I want only the road layer to be selected.
1
vote
1answer
105 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 ...
0
votes
0answers
53 views

how I can get raster calculator select files with similar names?

The idea is to select raster files with parts of similar name, for example: Filenames (in between many others raster with other names, but in the same folder): 28feb11evs 28feb11evv 28feb11pr ...
0
votes
3answers
228 views

Show selected features on all zoom levels in ArcMap?

Is there a way to display selected features no matter the scale level in ArcMap 10.3? When I select by attribute and then zoom to selection I often just get a blank map since the layer is set not to ...
2
votes
2answers
823 views

Zoom to Selected feature, without using 'current' in ArcPy?

I am wondering if it is possible to build a zoom to geoprocessing service without using 'current' for the mxd variable in pyhton. Using 'current' my tool works in arcmap, but not in my gp service. ...
1
vote
2answers
97 views

Selecting nearest 300 buildings (polygons/centroids) from list of points using ArcGIS for Desktop?

I have been trying to look for an easy/quick way to select a certain amount of polygons (layer 1) from a 90 points shapefile (layer 2). The idea is to identify the nearest 300 buildings from each of ...
2
votes
1answer
82 views

QGIS 2.8+: How can layer.selectedFeatures() return an empty list while layer.selectedFeatureCount() returns the correct number of selected features?

I noticed some changes since qgis 2.8 but can't find any information about it. Let's say I have a very simple point layer loaded in QGIS, from a spatialite table. From this layer I select some points ...
1
vote
1answer
416 views

Label only selected feature using QGIS?

Is it possible to make an expression that labels only the selected feature in QGIS? I tried it with this expression in the label tab: attribute( $currentfeature, 'LAENGE' ) But it labels all and not ...
1
vote
2answers
102 views

Select points located within Multi Ring Buffer

I have two point datasets, 1 showing the location of road accidents, the other showing the location of traffic intersections. I have created a Multi Ring Buffer at 25m intervals around the traffic ...
1
vote
1answer
372 views

How to SELECT all points within a GeoJSON polygon in PostGIS

I have a GeoJSON polygon, and a table with lots of points. I want to SELECT all points that are within an arbitrary GeoJSON polygon. How can I do that with PostGIS SQL?
2
votes
1answer
126 views

How can I do a subquery inside a subquery in PostGIS?

I need to add a subquery to a working function. Instead of select * from table, I'd like to select * from (select * from table where height>1500) as sub, something that works in other functions I ...