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

learn more… | top users | synonyms

0
votes
0answers
31 views

PyQGIS & multi selection request [closed]

How I can do to iterate over a layer in order to select the all value of one parameter and add it into a table (without redondancy)? I am a beginner using QGIS and especially Python for QGIS. I ...
0
votes
4answers
62 views

Setting selection method in ArcPy?

I haven't found a way of setting the selection method (Create new, Add to current, Remove from current, Select from current selection) in arcpy. Is it possible to do this and - if yes - how? I am ...
2
votes
1answer
90 views

How to search for a text from column1 in column2 in QGIS?

I have street names in a column (column1) as well as in another one (column2). I would like to write a selection expression to find out if there are similar street names (or parts of the names) ...
0
votes
1answer
15 views

How to discard sites when there is overlap between buffers?

I have 1,000 sites in a landscape that were sampled along a road. However, I think my sites are too close together. A lack of independence between my sites many be influencing my statistical models. ...
1
vote
1answer
39 views

Display selected features with same point geometry

I have a point layer and some features have exactly the same geometry. When I make a selection it seems that some features are not selected because they do not display with the "Selection color" as ...
2
votes
1answer
74 views

How can I select points within a part of a raster?

I have a map with huge amount of points (9562 villages) and two rasters: population density and land elevation. I am trying, without success for the moment, to select just those villages with high ...
3
votes
2answers
138 views

Attribute table : How to select more then one feature?

I have a vector layer: ROADS that is composed of different types of roads: primary, secondary, tertiary, trunk, etc. When I right click on the layer ROADS and I go to Attribute table -> Select by ...
3
votes
0answers
38 views

PyQGIS select layer by original table name

As far as I see, on QgsMapLayerRegistry.instance() there is a method to select layers: mapLayersByName(Qstring) and the method mapLayer(QString) respectively, wich accesses a layer by its id. ...
4
votes
2answers
64 views

How to Select a Polygon beneath another Polygon in QGIS 2.14

We have a series of layers that contain polygons with additional polygons 'underneath' each polygon. How do we select the polygon beneath the existing feature without also selecting the feature ...
1
vote
1answer
58 views

Use Only First “x” Characters from Table in qgis:selectbyexpression

I have a list of street names in this format: STRNAME Elsinore Neil Young Penny Fall And a shapefile ("input_streets") with street names in this format: STREET Elsinore Av Neil Young St Penny Lane ...
3
votes
1answer
66 views

Select by expression and remove points

How do I select points by expression and delete these selected points? Is it possible to do this inside the modeler with a tool? The selection by expression works fine but do I have to set all the ...
1
vote
1answer
34 views

QGIS - selecting 3D Polygons

I have downloaded a 3D polygon shapefile of buildings. I would like to be able to select some of the objects to create a new shapefile for doing 3D rendering but I cannot seem to be able to select any ...
0
votes
2answers
38 views

Get List of manualy selected features on MXD and run script on selected features : [closed]

Using arcgis 10.3, I trying to write code that when i do selection on layer manualy on MXD (not in the script) and run the script, the script need to run just on the selected features. I have tried - ...
-2
votes
1answer
32 views

Select Adjacent Tax Parcels by Area

I am trying to select for adjacent tax parcels where their total area would be close to a specific value (450 acres). Area is already an attribute of each parcel. ArcGIS v. 10.3.1 Unfamiliar with ...
1
vote
1answer
73 views

How to select features intersecting each other and sharing the same attribute values in QGIS?

Is there a way to select all features of a single layer which intersect each other and share the same attribute values?
7
votes
2answers
111 views

Features to stay selected by default in QGIS?

Does anyone know if there's a way to configure QGIS so that when you plot a new feature (i.e. a polygon), it stays selected by default? If I have to select it separately, and it happens to fall on ...
0
votes
1answer
93 views

Using variable in Arcpy select analysis

I need to use arcpy.Select_analysis() in my arcpy script, but I have problem with using variables. When I use hard coded values in where_clause, it is working. where_clause = '"Area" > 20' arcpy....
2
votes
1answer
75 views

Create Layer With Selected in QGIS

Came across this "Create layer with selected" button in the result for a Spatial Query in QGIS. And simply, this creates another layer from the same source with a query on the IDs. Does anyone know if ...
0
votes
1answer
67 views

Is there an analog of PhotoShop's “Magic Wand Tool” in ArcGIS Desktop?

I want to interactively select rasters pixels based on it's values and modify them. Here is example of what this "Magic Wand Tool" should do:
1
vote
1answer
143 views

How to speed up Select by location?

Has anyone had a similar "extreme slow" experience using "Select by location" (Toolbox) and "Spatial query" tool? I've used both for selecting some points inside a polygon. The data was in SHPs and ...
1
vote
1answer
43 views

Interact with Selection and Entire Dataset using arcpy

ArcToolbox geoprocessing tools (and therefore arcpy) tend to run either on an entire dataset (if there is no selection) or on a selection set (if it exists). How can I set up an arcpy script that ...
3
votes
1answer
19 views

Cannot get Remove From Current Selection to work in ArcMap?

I am a Newbie using ArcGIS 10.3 for Desktop: After importing a whole watershed streams Layer, I selected by location a subset of the streams which was already defined with a separate name. "...
2
votes
1answer
103 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 ...
6
votes
3answers
293 views

How to select specific rows of polygons from a grid in QGIS?

I have a polygon layer. I would like to select every second row of the polygons but not manually. Is there an expression to select every second row as seen on the picture with Select by expression in ...
3
votes
2answers
71 views

How to select the most populated neighbourhood of each town in the country using QGIS?

I have data from a national census with population for each neighbourhood, grouped by municipality and town, in the country. I want to select the most populated neighbourhood of each town (there's a ...
2
votes
1answer
29 views

Using ArcGIS ModelBuilder in to Select By Attributes?

I have a file showing for each disaster, which provinces were affected. The number of provinces affected varies and their names or associated code varies as well. Example, if a flood in 2000 ...
0
votes
1answer
40 views

How to select congruent polygons in PostGIS?

Title says it all. What is the best way to select congruent polygons in PostGIS? CREATE TABLE polygon_a ( gid serial NOT NULL, geom geometry(Polygon, your_SRID), CONSTRAINT polygon_a_pkey PRIMARY KEY ...
1
vote
0answers
54 views

Selecting certain area of polygon according to size in ArcMap?

I have a set of polygons with a certain size (3500 sq meters each for examples). I only need 3000 sq meters of every polygon. Is there an automatic or semi-automatic way to create sub-polygons out of ...
0
votes
2answers
74 views

Selecting from selection based on attribute table in ArcGIS for Desktop?

I selected polygons which are less than 313 m2 and from that selection I need to select the ones that are completely within some other polygon. So, both selections are on the same shapefile. I ...
2
votes
1answer
163 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 ...
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 ...
4
votes
1answer
538 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") ) ...
1
vote
1answer
116 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 ...
1
vote
1answer
55 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 ...
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....
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 ...
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 ...
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 = ...
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
132 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 ...
0
votes
1answer
238 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 ...
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, ...
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
96 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 ...
3
votes
1answer
81 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 ...