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

learn more… | top users | synonyms

3
votes
2answers
45 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
22 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
32 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 ...
0
votes
1answer
423 views

CartoDB layer selector - selecting data from 2 layers

I used the CartoDB layer selector example (http://cartodb.github.io/cartodb.js/examples/layer_selector.html) with my data. Works fine. Now, what I really want to do is to select data from 2 layers at ...
1
vote
0answers
29 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
1answer
2k views

Get layer name by click on features OpenLayers3

I want to add selec interactions to my OL3 map. Adding two different select interactions like this is not working. Only the second one works. Like this: var select = new ...
1
vote
1answer
2k views

Having trouble selecting polygon from existing layer (using OpenLayers.Control.SelectFeature)

I am hoping someone can point me in the right direction. I am not a programmer, so that is my first roadblock. ha The problem: I have an existing polygon layer and I am trying to select one of the ...
1
vote
1answer
178 views

Creating buffer around WFS features to ease their selection in OpenLayers 2?

I'm using a WFS SelectFeature from OpenLayers 2 to show a Popup containing the features' attributes from line layers and point layers (from GeoServer). This works fine, but I would like to create a ...
3
votes
1answer
173 views

How to select an limited TOP n from a 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 ...
0
votes
1answer
207 views

Openlayers selected feature unselecting on map zoom

I have createc a select control and a StyleMap that includes default marker and select marker. var mystyle = new OpenLayers.StyleMap({ "default": new OpenLayers.Style("null", { ...
9
votes
2answers
7k views

Setting which layers are selectable in ArcMap?

I cannot figure out how to toggle selectable layers in ArcMap 10. In 9.3, I remember being able to choose from a list which layers I wanted to be able to select features from in the map. Let's say ...
2
votes
2answers
2k views

zoom to cluster onClick & have hover event

I've made a simple mock-up trying to combine two openlayers examples. I want to have clusters on which I can hover (so I can display an infowindow about it's content) and I want users to be able to ...
0
votes
2answers
46 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
51 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
1answer
131 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
64 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
45 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
33 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 ...
12
votes
7answers
27k 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
691 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
35 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
241 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
40 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 = ...
4
votes
1answer
80 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
81 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
57 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
18 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
98 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
45 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
219 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
850 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
52 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
20 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
94 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
65 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, ...
11
votes
3answers
10k 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
52 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
71 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
3k 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
3k 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
44 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
404 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 ...
2
votes
0answers
18 views

Is there a way to apply the “Select features by rectangle\polygon…” function on multiple layers simultaneously?

I have put a map together using openstreemap data that is intended to be used as a base for different projects. However due to the amount of information (number of layers) the loading time is rather ...
3
votes
3answers
190 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
34 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
129 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
751 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 ...