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

learn more… | top users | synonyms

1
vote
1answer
140 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 ...
0
votes
1answer
167 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 ...
0
votes
1answer
53 views

Selecting few biggest polygons within class

I have polygon shapefile with objects that have 'class' and 'area' values in attribute table. I want to select five biggest polygons in each class. I can't do it manually because of large number of ...
0
votes
1answer
91 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 ...
1
vote
1answer
97 views

Python script to select a point within a cell?

I have two features: points and grid cells (vector). I want to select a point within a grid cell (some cell do not have point) using python script and create a new feature layer with below conditions: ...
3
votes
2answers
447 views

How can one select only displayed features using the select by rectangle tool? [closed]

I have a shapefile with many features, only some of which are displayed. I'm using the "Select Features by Rectangle" tool (the one where you click and drag a box over the features you want to ...
8
votes
2answers
639 views

Simple way to detect/select border polygons of a shapefile

I am looking for a simple way to detect/select border polygons of a shapefile. Border polygons are here polygons that are not completely surrounded by other polygons i.e. polygons located at the ...
0
votes
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 ...
3
votes
1answer
112 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 ...
5
votes
1answer
1k views

How to select specific row in attribute table using ArcPy (without iterating through whole table)?

I am using ArcGIS 10.2 and have assumed until now that it is possible to select a specific row in an attribute table. However, I can't seem to find a way to do this. The only available methods seem to ...
0
votes
0answers
30 views

Selecting features through a many-to-one relationship

I want to select multiple counties based on the occurrence of a species present within them. I have a County polygon layer with CountyName as an attribute, a flat table called tblSpCnty with the ...
1
vote
0answers
100 views

select remove layers not working second time

http://www.youtube.com/watch?v=qxVO0tFdiuA&feature i captured video. You can watch. Now i explain my problem. Firstly, when i create popup and in popup menu when i call function and select ...
1
vote
2answers
5k 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
0answers
190 views

How to select and highlight feature by attribute

I have the below code which does a select by shape on my arc map how do I achieve this with attributes 1.The map has only one layer 2.There is a filter for the attributes on features Below is the ...
5
votes
1answer
5k views

How to Export Selected Feature to New Shapefile Using ArcPy?

I currently have a search cursor iterating through a shapefile in ArcGIS 10.1 that selects a feature and runs a viewshed analysis on that feature (and only that feature). What's the easiest way to ...
0
votes
1answer
23 views

QGIS 1.8 or 2.01 select entries in .shp file that match a field entry [duplicate]

I've got a .shp file with 40k points (trees) in it. One field is the species name. Is there a way to select those entries that match a desired field name e.g. 'black walnut' so I can move them to a ...
0
votes
2answers
548 views

How to Select By Location with matching attribute?

I have a whole bunch of overlapping polygons (buffers), I want to select with points only those poly's which: the point falls within; and the poly attribute matches the point attribute What would ...
12
votes
2answers
7k views

How to get 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 ...
3
votes
2answers
569 views

How to Select by Attributes on features sharing common value?

I am attempting to 'select by attributes' a point feature with the lowest numeric value which shares a common value with other point features in another field. For example: I may have 3 point features ...
5
votes
0answers
180 views

How to select features based upon 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
1answer
1k views

QGIS select feature, “add to current selection” feature

I am trying to perform a feature selection on qgis similar to "add to current selection" interactive selection method in Arcgis Desktop, is that possible? An example: I perform a spatial query and ...
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 ...
1
vote
2answers
176 views

Selecting a polygon within polygon where part of its boundary is the same. PostGIS

I would like to know how can I select a A_polygon within B_polygon, but part of the boundary of the A_polygon touch the B_polygon boundary. In Postgis 2.0, I tried few options but they didn´t work ...
3
votes
0answers
211 views

QGIS Select Single Feature not correct in attribute table

For some reason, QGIS is not displaying the correct row of my data when I click on a feature with "Select Single Feature" or even the other select tools. I have a point database linked from mysql. ...
3
votes
2answers
623 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
1answer
937 views

Check if feature is selected (Openlayers)

I wonder if there is a way to check whether a pointfeature (OpenLayers.Feature.Vector) is selected. I read the API, but didn't find any solution. Any idea?
5
votes
2answers
793 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 ...
3
votes
1answer
350 views

Why would Select By Location appear not to work properly after Multipart to Singlepart?

I am having issues using ArcGIS Desktop 9.3 and the multipart to singlepart feature and then selecting by location. Basically, I am able to run the multipart to single part feature to split up some ...
0
votes
1answer
89 views

Openlayers selection

Is it possible to select a polygon from a predefined Lat & Lon programmatically? eg location point: x='1234' y='5678' intersects polygon '1234', therefore SELECT POLYGON '1234' So far I have ...
4
votes
1answer
625 views

How to eliminate small polygons using ModelBuilder to iterate through feature classes

I created four large polygon feature classes of surface slope classes from a grid of 6-foot cells covering half my county. In order to repair the geometry and eliminate small polygons I broke four ...
0
votes
1answer
82 views

how to select parts of a shape in QGIS

I have to have a Shapefile of France of the bigger regions: Ile-de-France, Bretagne, etc. and that is already included in my shape. But its only shown the Arrondissements (smaller regions) in France ...
0
votes
0answers
26 views

How to select areas from a target layer which do not intersect source layer? [duplicate]

I have two different layers, one is county boundary and another one is soil map. My question is I would like to select only those areas which are outside the county boundary. Using "Select by ...
0
votes
1answer
214 views

How can i select many rows from a table?

I want to create an action that select many rows from PostGIS table to show many lines in QGIS. How can i select many rows from table with python to add these rows in a layer? Thank you
3
votes
2answers
1k views

ArcObjects snipped to Select all Features currently visible on the ArcMap screen (ActiveView)

I guess I have to get the extent of the ActiveView and then use it to perform a spatial search. Is that the proper way to do it? Please share the code snipped if you have any. Thanks.
0
votes
1answer
377 views

Map Basic. Where-clause in Select Statement

what is wrong with this statement? I recon the where-clause is the problem. Select * from "BEDIRECT_POT_" + vo_num, PLZ5_2012_bereinigt where "BEDIRECT_POT_" + vo_num.PLZ like ...
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 ...
2
votes
1answer
89 views

How do I select all polygons in a layer that border 2+ polygons in the same layer?

My data consists of equal-sized polygons. I need to identify and select all the polygons that border two or more polygons.
0
votes
1answer
104 views

Selecting a Polygon based on the location of a point

Currently I have a polygon layer made up of three shapes. All the shapes are listed in the attribute table. One of these three shapes intersects a point. I would like to select just the shape that has ...
2
votes
2answers
2k views

Exporting selected feature to google earth in QGIS?

Does anyone know if there is a plugin for QGIS that will export features to google earth similar to the one for MapInfo? Thanks, Alan
1
vote
2answers
398 views

Selecting an item with the mouse in MapBasic

This may seem relatively simple, but I'm pretty confused. I have written a mapbasic tool that does things to the table 'Selection' depending on user choices in a popup menu, but currently you need to ...
5
votes
2answers
6k 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 ...
1
vote
2answers
394 views

How to select two points on a map using QGIS?

I need to select two points on a map in QGIS. I selected the element selection tool in menu view and I want to select two points. How can I accomplish this? Are there other tools or methods to ...
6
votes
1answer
5k views

Select all “NULL” values in the attribute table?

I have a quite simple syntax question. I want to select ALL my null values in an attribute table of a feature class, not just the values in a single field. So the question would be: what is the ...
0
votes
2answers
631 views

Select / Deselect and Identify Features in QGIS

Sorry if this is all a bit 101, but I'm new to QGIS. I basically have a large Arc project that I can access in QGIS for reference, so will only really be using it to identify features. For example to ...
28
votes
2answers
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 ...
1
vote
1answer
257 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 ...
1
vote
1answer
276 views

Sorting points with QGIS

I have a very good idea of what I would like to do but I really do not know if it is possible with QGIS. I have points that each one corresponds to a group size and I would like to use GIS to sort ...
0
votes
2answers
90 views

How to select by polygon in PostGIS with misaligned layers?

I have two polygon layers, one which defines subregions of the other. However, the layers do not line up exactly, so there are minor discrepancies along the edges. I would like to select all minor ...
0
votes
1answer
44 views

PostGIS: Querying a record table and explanatory table

Basically I have two tables one containing a collection of records and one table that contains extra info about features in the first. i.e Records Table: GID SITE SPECIES GEOM and the second table ...
1
vote
1answer
463 views

Data Driven Pages, Graphs, and selections in ArcMap 10.1

Is it possible in python to create a selection set based on the extent from a Data Driven Page (DDP)? I have a layout view with a map and a graph. The graph is set to only plot the selected set of ...